Página Principal Explorar Ajuda
Registe-se Iniciar Sessão
dbs289
/
ConsentDemoServer
1
0
Fork 0
Ficheiros Problemas 0 Pull Requests 0 Wiki
Árvore: 48a9dbbbc5
Ramos Etiquetas
ConsentDemoS...
/
CLIP.e-Form.Consent.Web
/
Logs
/
eFormServer.iBATIS.log_2016-11-07

eFormServer.iBATIS.log_2016-11-07 18 KB
Histórico Em bruto

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108 
  1. 

  2. [Logging Date Time: 2016-11-07 13:12:47,094] =====================================================================================
    3. 

  3. SQL Command - Statement Id: [delEformData] PreparedStatement : [declare              I_PID              VARCHAR2(10) :=  :param0 ;           /* 등록번호 */              I_IOFLAG           VARCHAR2(1)  :=  :param1 ;       /* 입원/외래 구분 */              I_ORDDD            VARCHAR2(8)  :=  :param2 ;         /* 입원일 또는 진료일 */              I_DSCHDD           VARCHAR2(8)  :=  :param3 ;        /* 입원환자 퇴원일 외래환자면 값이 '' */              I_CRETNO           NUMBER(10)   :=  :param4 ;        /* 원무정보의 생성번호 */              I_FORMCD           VARCHAR2(10) :=  :param5 ;        /* FORMCD */              I_OCRCODE          VARCHAR2(13) :=  :param6 ;        /* OCRCODE */              I_USERID           VARCHAR2(10) :=  :param7 ;        /* 사용자 ID 실제 동의서 구득 행위를 하는 사람 */              I_USERNM           VARCHAR2(10) :=  :param8 ;      /* 사용자 이름 */              I_CONSENT_MST_RID  NUMBER(18)   :=  :param9 ; /* 동의서 작성 마스터 ID */              I_HOS_TYPE         VARCHAR2(10) :=  :param10 ;       /* 병원구분(대구파티마 - '111') */          begin            EMR.EFORM_DELETE(I_PID, I_IOFLAG, I_ORDDD, I_DSCHDD, I_CRETNO, I_FORMCD, I_OCRCODE, I_USERID, I_USERNM, I_CONSENT_MST_RID, I_HOS_TYPE);          end;]
    4. 

  4. 

  5. [Logging Date Time: 2016-11-07 13:12:47,094] =====================================================================================
    6. 

  6. SQL Command - Statement Id: [delEformData] PreparedStatement : [declare              I_PID              VARCHAR2(10) :=  :param0 ;           /* 등록번호 */              I_IOFLAG           VARCHAR2(1)  :=  :param1 ;       /* 입원/외래 구분 */              I_ORDDD            VARCHAR2(8)  :=  :param2 ;         /* 입원일 또는 진료일 */              I_DSCHDD           VARCHAR2(8)  :=  :param3 ;        /* 입원환자 퇴원일 외래환자면 값이 '' */              I_CRETNO           NUMBER(10)   :=  :param4 ;        /* 원무정보의 생성번호 */              I_FORMCD           VARCHAR2(10) :=  :param5 ;        /* FORMCD */              I_OCRCODE          VARCHAR2(13) :=  :param6 ;        /* OCRCODE */              I_USERID           VARCHAR2(10) :=  :param7 ;        /* 사용자 ID 실제 동의서 구득 행위를 하는 사람 */              I_USERNM           VARCHAR2(10) :=  :param8 ;      /* 사용자 이름 */              I_CONSENT_MST_RID  NUMBER(18)   :=  :param9 ; /* 동의서 작성 마스터 ID */              I_HOS_TYPE         VARCHAR2(10) :=  :param10 ;       /* 병원구분(대구파티마 - '111') */          begin            EMR.EFORM_DELETE(I_PID, I_IOFLAG, I_ORDDD, I_DSCHDD, I_CRETNO, I_FORMCD, I_OCRCODE, I_USERID, I_USERNM, I_CONSENT_MST_RID, I_HOS_TYPE);          end;]
    7. 

  7. 

  8. [Logging Date Time: 2016-11-07 13:12:47,130] =====================================================================================
    9. 

  9. SQL Command - Statement Id: [delEformData] Parameters: [param0=[pid,2073057], param1=[ordtype,I], param2=[orddd,20161024], param3=[dschdd,99991231], param4=[cretno,1], param5=[formcd,1300011166], param6=[ocrtag,2016102461898], param7=[userid,104591], param8=[username,이정은], param9=[consentmstrid,985], param10=[hostype,111]]
    10. 

  10. 

  11. [Logging Date Time: 2016-11-07 13:12:47,130] =====================================================================================
    12. 

  12. SQL Command - Statement Id: [delEformData] Parameters: [param0=[pid,2073057], param1=[ordtype,I], param2=[orddd,20161024], param3=[dschdd,99991231], param4=[cretno,1], param5=[formcd,1300011166], param6=[ocrtag,2016102461898], param7=[userid,104591], param8=[username,이정은], param9=[consentmstrid,985], param10=[hostype,111]]
    13. 

  13. 

  14. [Logging Date Time: 2016-11-07 13:12:47,130] =====================================================================================
    15. 

  15. SQL Command - Statement Id: [delEformData] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[AnsiString, System.String], param8=[AnsiString, System.String], param9=[AnsiString, System.String], param10=[AnsiString, System.String]]
    16. 

  16. 

  17. [Logging Date Time: 2016-11-07 13:12:47,130] =====================================================================================
    18. 

  18. SQL Command - Statement Id: [delEformData] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[AnsiString, System.String], param8=[AnsiString, System.String], param9=[AnsiString, System.String], param10=[AnsiString, System.String]]
    19. 

  19. 

  20. [Logging Date Time: 2016-11-07 13:12:47,209] =====================================================================================
    21. 

  21. SQL Command - CLIP.eForm delEformData error: ORA-06550: 줄 1, 열1125:PLS-00904: EMR.EFORM_DELETE 오브젝트를 액세스하기 위한 권한이 부족합니다
    22. 

  22. ORA-06550: 줄 1, 열1121:PL/SQL: Statement ignored
    23. 

  23. 

  24. 

  25. [Logging Date Time: 2016-11-07 13:14:04,453] =====================================================================================
    26. 

  26. SQL Command - Unable to open connection to "Oracle, Microsoft provider V2.0.0.0".
    27. 

  27. IBatisNet.DataMapper.Exceptions.DataMapperException: Unable to open connection to "Oracle, Microsoft provider V2.0.0.0". ---> System.Data.OracleClient.OracleException: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
    28. 

  28. 

  29.    위치: System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
    30. 

  30.    위치: System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
    31. 

  31.    위치: System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
    32. 

  32.    위치: System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
    33. 

  33.    위치: System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
    34. 

  34.    위치: System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
    35. 

  35.    위치: System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
    36. 

  36.    위치: System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
    37. 

  37.    위치: System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
    38. 

  38.    위치: System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
    39. 

  39.    위치: System.Data.OracleClient.OracleConnection.Open()
    40. 

  40.    위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
    41. 

  41.    --- 내부 예외 스택 추적의 끝 ---
    42. 

  42.    위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
    43. 

  43.    위치: IBatisNet.DataMapper.SqlMapSession.BeginTransaction(String connectionString)
    44. 

  44.    위치: IBatisNet.DataMapper.SqlMapper.BeginTransaction()
    45. 

  45.    위치: CLIP.eForm.Server.Data.IBatisHelper.GetConnect(String sProvidersPath)
    46. 

  46. 

  47. [Logging Date Time: 2016-11-07 13:15:03,042] =====================================================================================
    48. 

  48. SQL Command - Statement Id: [delEformData] PreparedStatement : [declare              I_PID              VARCHAR2(10) :=  :param0 ;           /* 등록번호 */              I_IOFLAG           VARCHAR2(1)  :=  :param1 ;       /* 입원/외래 구분 */              I_ORDDD            VARCHAR2(8)  :=  :param2 ;         /* 입원일 또는 진료일 */              I_DSCHDD           VARCHAR2(8)  :=  :param3 ;        /* 입원환자 퇴원일 외래환자면 값이 '' */              I_CRETNO           NUMBER(10)   :=  :param4 ;        /* 원무정보의 생성번호 */              I_FORMCD           VARCHAR2(10) :=  :param5 ;        /* FORMCD */              I_OCRCODE          VARCHAR2(13) :=  :param6 ;        /* OCRCODE */              I_USERID           VARCHAR2(10) :=  :param7 ;        /* 사용자 ID 실제 동의서 구득 행위를 하는 사람 */              I_USERNM           VARCHAR2(10) :=  :param8 ;      /* 사용자 이름 */              I_CONSENT_MST_RID  NUMBER(18)   :=  :param9 ; /* 동의서 작성 마스터 ID */              I_HOS_TYPE         VARCHAR2(10) :=  :param10 ;       /* 병원구분(대구파티마 - '111') */          begin            EMR.EFORM_DELETE(I_PID, I_IOFLAG, I_ORDDD, I_DSCHDD, I_CRETNO, I_FORMCD, I_OCRCODE, I_USERID, I_USERNM, I_CONSENT_MST_RID, I_HOS_TYPE);          end;]
    49. 

  49. 

  50. [Logging Date Time: 2016-11-07 13:15:03,042] =====================================================================================
    51. 

  51. SQL Command - Statement Id: [delEformData] PreparedStatement : [declare              I_PID              VARCHAR2(10) :=  :param0 ;           /* 등록번호 */              I_IOFLAG           VARCHAR2(1)  :=  :param1 ;       /* 입원/외래 구분 */              I_ORDDD            VARCHAR2(8)  :=  :param2 ;         /* 입원일 또는 진료일 */              I_DSCHDD           VARCHAR2(8)  :=  :param3 ;        /* 입원환자 퇴원일 외래환자면 값이 '' */              I_CRETNO           NUMBER(10)   :=  :param4 ;        /* 원무정보의 생성번호 */              I_FORMCD           VARCHAR2(10) :=  :param5 ;        /* FORMCD */              I_OCRCODE          VARCHAR2(13) :=  :param6 ;        /* OCRCODE */              I_USERID           VARCHAR2(10) :=  :param7 ;        /* 사용자 ID 실제 동의서 구득 행위를 하는 사람 */              I_USERNM           VARCHAR2(10) :=  :param8 ;      /* 사용자 이름 */              I_CONSENT_MST_RID  NUMBER(18)   :=  :param9 ; /* 동의서 작성 마스터 ID */              I_HOS_TYPE         VARCHAR2(10) :=  :param10 ;       /* 병원구분(대구파티마 - '111') */          begin            EMR.EFORM_DELETE(I_PID, I_IOFLAG, I_ORDDD, I_DSCHDD, I_CRETNO, I_FORMCD, I_OCRCODE, I_USERID, I_USERNM, I_CONSENT_MST_RID, I_HOS_TYPE);          end;]
    52. 

  52. 

  53. [Logging Date Time: 2016-11-07 13:15:03,073] =====================================================================================
    54. 

  54. SQL Command - Statement Id: [delEformData] Parameters: [param0=[pid,2073057], param1=[ordtype,I], param2=[orddd,20161024], param3=[dschdd,99991231], param4=[cretno,1], param5=[formcd,1300011166], param6=[ocrtag,2016102461898], param7=[userid,104591], param8=[username,이정은], param9=[consentmstrid,985], param10=[hostype,111]]
    55. 

  55. 

  56. [Logging Date Time: 2016-11-07 13:15:03,073] =====================================================================================
    57. 

  57. SQL Command - Statement Id: [delEformData] Parameters: [param0=[pid,2073057], param1=[ordtype,I], param2=[orddd,20161024], param3=[dschdd,99991231], param4=[cretno,1], param5=[formcd,1300011166], param6=[ocrtag,2016102461898], param7=[userid,104591], param8=[username,이정은], param9=[consentmstrid,985], param10=[hostype,111]]
    58. 

  58. 

  59. [Logging Date Time: 2016-11-07 13:15:03,073] =====================================================================================
    60. 

  60. SQL Command - Statement Id: [delEformData] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[AnsiString, System.String], param8=[AnsiString, System.String], param9=[AnsiString, System.String], param10=[AnsiString, System.String]]
    61. 

  61. 

  62. [Logging Date Time: 2016-11-07 13:15:03,073] =====================================================================================
    63. 

  63. SQL Command - Statement Id: [delEformData] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[AnsiString, System.String], param8=[AnsiString, System.String], param9=[AnsiString, System.String], param10=[AnsiString, System.String]]
    64. 

  64. 

  65. [Logging Date Time: 2016-11-07 20:11:42,202] =====================================================================================
    66. 

  66. SQL Command - Statement Id: [GET_CONSENT_IMAGE] PreparedStatement : [SELECT  CONSENT_MST_RID                , CONSENT_IMAGE_RID                , FORM_RID                , CASE WHEN SUBSTR(IMAGE_PATH,0,6) = 'Image1' THEN '\\192.168.100.32\image_a01' || SUBSTR(IMAGE_PATH,7)                       WHEN SUBSTR(IMAGE_PATH,0,6) = 'Image2' THEN '\\192.168.100.32\image_a02' || SUBSTR(IMAGE_PATH,7)                       WHEN SUBSTR(IMAGE_PATH,0,6) = 'Image3' THEN '\\192.168.100.32\image_a03' || SUBSTR(IMAGE_PATH,7)                       ELSE IMAGE_PATH                   END IMAGE_PATH                , IMAGE_FILENAME                , COMPLETE_YN                , CREATE_USER_ID                , CREATE_DATETIME            FROM  CONSENT_IMAGE           WHERE  COMPLETE_YN = 'Y'             AND  CONSENT_MST_RID =  :param0            ORDER BY CONSENT_IMAGE_RID]
    67. 

  67. 

  68. [Logging Date Time: 2016-11-07 20:11:42,202] =====================================================================================
    69. 

  69. SQL Command - Statement Id: [GET_CONSENT_IMAGE] PreparedStatement : [SELECT  CONSENT_MST_RID                , CONSENT_IMAGE_RID                , FORM_RID                , CASE WHEN SUBSTR(IMAGE_PATH,0,6) = 'Image1' THEN '\\192.168.100.32\image_a01' || SUBSTR(IMAGE_PATH,7)                       WHEN SUBSTR(IMAGE_PATH,0,6) = 'Image2' THEN '\\192.168.100.32\image_a02' || SUBSTR(IMAGE_PATH,7)                       WHEN SUBSTR(IMAGE_PATH,0,6) = 'Image3' THEN '\\192.168.100.32\image_a03' || SUBSTR(IMAGE_PATH,7)                       ELSE IMAGE_PATH                   END IMAGE_PATH                , IMAGE_FILENAME                , COMPLETE_YN                , CREATE_USER_ID                , CREATE_DATETIME            FROM  CONSENT_IMAGE           WHERE  COMPLETE_YN = 'Y'             AND  CONSENT_MST_RID =  :param0            ORDER BY CONSENT_IMAGE_RID]
    70. 

  70. 

  71. [Logging Date Time: 2016-11-07 20:11:42,247] =====================================================================================
    72. 

  72. SQL Command - Statement Id: [GET_CONSENT_IMAGE] Parameters: [param0=[consent-mst-rid,1157]]
    73. 

  73. 

  74. [Logging Date Time: 2016-11-07 20:11:42,247] =====================================================================================
    75. 

  75. SQL Command - Statement Id: [GET_CONSENT_IMAGE] Parameters: [param0=[consent-mst-rid,1157]]
    76. 

  76. 

  77. [Logging Date Time: 2016-11-07 20:11:42,247] =====================================================================================
    78. 

  78. SQL Command - Statement Id: [GET_CONSENT_IMAGE] Types: [param0=[Int32, System.Int32]]
    79. 

  79. 

  80. [Logging Date Time: 2016-11-07 20:11:42,247] =====================================================================================
    81. 

  81. SQL Command - Statement Id: [GET_CONSENT_IMAGE] Types: [param0=[Int32, System.Int32]]
    82. 

  82. 

  83. [Logging Date Time: 2016-11-07 20:11:42,270] =====================================================================================
    84. 

  84. SQL Command - DeleteTempFile : 2016-11-06 오후 8:11:42
    85. 

  85. 

  86. [Logging Date Time: 2016-11-07 20:13:09,814] =====================================================================================
    87. 

  87. SQL Command - Statement Id: [GET_CONSENT_IMAGE] PreparedStatement : [SELECT  CONSENT_MST_RID                , CONSENT_IMAGE_RID                , FORM_RID                , CASE WHEN SUBSTR(IMAGE_PATH,0,6) = 'Image1' THEN '\\192.168.100.32\image_a01' || SUBSTR(IMAGE_PATH,7)                       WHEN SUBSTR(IMAGE_PATH,0,6) = 'Image2' THEN '\\192.168.100.32\image_a02' || SUBSTR(IMAGE_PATH,7)                       WHEN SUBSTR(IMAGE_PATH,0,6) = 'Image3' THEN '\\192.168.100.32\image_a03' || SUBSTR(IMAGE_PATH,7)                       ELSE IMAGE_PATH                   END IMAGE_PATH                , IMAGE_FILENAME                , COMPLETE_YN                , CREATE_USER_ID                , CREATE_DATETIME            FROM  CONSENT_IMAGE           WHERE  COMPLETE_YN = 'Y'             AND  CONSENT_MST_RID =  :param0            ORDER BY CONSENT_IMAGE_RID]
    88. 

  88. 

  89. [Logging Date Time: 2016-11-07 20:13:09,814] =====================================================================================
    90. 

  90. SQL Command - Statement Id: [GET_CONSENT_IMAGE] PreparedStatement : [SELECT  CONSENT_MST_RID                , CONSENT_IMAGE_RID                , FORM_RID                , CASE WHEN SUBSTR(IMAGE_PATH,0,6) = 'Image1' THEN '\\192.168.100.32\image_a01' || SUBSTR(IMAGE_PATH,7)                       WHEN SUBSTR(IMAGE_PATH,0,6) = 'Image2' THEN '\\192.168.100.32\image_a02' || SUBSTR(IMAGE_PATH,7)                       WHEN SUBSTR(IMAGE_PATH,0,6) = 'Image3' THEN '\\192.168.100.32\image_a03' || SUBSTR(IMAGE_PATH,7)                       ELSE IMAGE_PATH                   END IMAGE_PATH                , IMAGE_FILENAME                , COMPLETE_YN                , CREATE_USER_ID                , CREATE_DATETIME            FROM  CONSENT_IMAGE           WHERE  COMPLETE_YN = 'Y'             AND  CONSENT_MST_RID =  :param0            ORDER BY CONSENT_IMAGE_RID]
    91. 

  91. 

  92. [Logging Date Time: 2016-11-07 20:13:09,850] =====================================================================================
    93. 

  93. SQL Command - Statement Id: [GET_CONSENT_IMAGE] Parameters: [param0=[consent-mst-rid,1157]]
    94. 

  94. 

  95. [Logging Date Time: 2016-11-07 20:13:09,850] =====================================================================================
    96. 

  96. SQL Command - Statement Id: [GET_CONSENT_IMAGE] Parameters: [param0=[consent-mst-rid,1157]]
    97. 

  97. 

  98. [Logging Date Time: 2016-11-07 20:13:09,850] =====================================================================================
    99. 

  99. SQL Command - Statement Id: [GET_CONSENT_IMAGE] Types: [param0=[Int32, System.Int32]]
    100. 

  100. 

  101. [Logging Date Time: 2016-11-07 20:13:09,850] =====================================================================================
    102. 

  102. SQL Command - Statement Id: [GET_CONSENT_IMAGE] Types: [param0=[Int32, System.Int32]]
    103. 

  103. 

  104. [Logging Date Time: 2016-11-07 20:13:09,866] =====================================================================================
    105. 

  105. SQL Command - DeleteTempFile : 2016-11-06 오후 8:13:09
    106. 

  106. 

  107. [Logging Date Time: 2016-11-07 20:13:09,867] =====================================================================================
    108. 

  108. SQL Command - DeleteTempFile : 2016-11-07 오후 8:10:54
    109.