fatimaConsentApi/CLIP.e-Form.Consent.Dfh.Web/Logs/eFormServer.iBATIS.log_2016-10-04

[Logging Date Time: 2016-10-04 12:34:34,223] =====================================================================================
SQL Command - Unable to open connection to "Oracle, Microsoft provider V2.0.0.0".
IBatisNet.DataMapper.Exceptions.DataMapperException: Unable to open connection to "Oracle, Microsoft provider V2.0.0.0". ---> System.Data.OracleClient.OracleException: ORA-12154: TNS:지정된 접속 식별자를 분석할 수 없음

   위치: System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
   위치: System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   위치: System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   위치: System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   위치: System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   위치: System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   위치: System.Data.OracleClient.OracleConnection.Open()
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   --- 내부 예외 스택 추적의 끝 ---
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapSession.BeginTransaction(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapper.BeginTransaction()
   위치: CLIP.eForm.Server.Data.IBatisHelper.GetConnect(String sProvidersPath)

[Logging Date Time: 2016-10-04 13:55:03,254] =====================================================================================
SQL Command - Statement Id: [getOutPatList] PreparedStatement : [SELECT otpt.pid                                                                 AS pid,                 substr(otpt.orddd,1,4) || '/' || substr(otpt.orddd,5,2) || '/' || substr(otpt.orddd,7,2)     AS indd,                 otpt.cretno                                                              AS cretno,                 otpt.acptseqno                                                           AS seqno,                 otpt.instcd                                                              AS instcd,                 ptbs.hngnm                                                               AS hngnm,                 (select code.cdnm                  from com.zbcmcode code                 where code.cdgrupid = 'P0021'                       and code.valifromdd <= otpt.orddd                       and code.valitodd >= otpt.orddd                       and code.cdid = otpt.fsexamflag)                                   AS fsexamflag,                 otpt.orddeptcd                                                           AS orddeptcd,                 otpt.orddrid                                                             AS doctorid,                 1                                                                        AS hd,                 TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa,                 dept.depthngnm                                                                      AS deptnm,                 dept.deptengabbr                                                         AS deptengabbr,                 usrb.usernm                                                              AS doctornm,                 (SELECT term.termengnm diagengnm                    FROM emr.mmohdiag diag,                         emr.mrtmterm term                   WHERE diag.pid       = otpt.pid                     AND diag.orddd     = otpt.orddd                     AND diag.cretno    = otpt.cretno                     AND diag.orddeptcd = otpt.orddeptcd                     AND diag.instcd    = otpt.instcd                     AND diag.diagcd    = term.termcd                     AND diag.diagdd   >= term.termfromdd                     AND diag.diagdd   <= term.termtodd                     AND diag.instcd    = term.instcd                     AND diag.diaghistcd     = 'O'                     AND diag.diagtypecd     = 'D'                     AND diag.diagkindcdflag = 'M'                     AND ROWNUM = 1)                          AS diagnm,                 'N'                                                                      AS dschnoti,                     'N'                                                                      AS roomcd,                     'N'                                                                      AS cnst,                 otpt.ordtype                                                             AS ordtype,                 (SELECT z.cdnm                  FROM   com.zbcmcode z                  WHERE  otpt.insukind = z.cdid                  AND    z.cdgrupid = 'P0008'                  AND    otpt.orddd BETWEEN z.valifromdd AND z.valitodd)                  AS bostyle,                 case when otpt.elbulbodstat='0' then '접수'                 when otpt.elbulbodstat = '1' then '대기'                 when otpt.elbulbodstat = '2' then '완료'                 when otpt.elbulbodstat = '3' then '보류'                 end               AS elbulbodstat,                 substr(otpt.ordtm,1,2) || ':' || substr(otpt.ordtm,3,2) AS ordtm,                 otpt.centcd                  as centcd,                 cent.depthngnm               as centnm,                 cent.deptengabbr             as centengabbr,                 otpt.orddd            FROM pam.pmohotpt otpt               , pam.pmcmptbs ptbs               , com.zsdddept dept               , com.zsumusrb usrb               , com.zsdddept cent           WHERE otpt.histstat IN ('R', 'T')             AND otpt.ordtype IN ('O', 'S')             AND otpt.orddd = otpt.orgorddd             AND otpt.cretno = otpt.orgcretno             AND otpt.pid = ptbs.pid             AND otpt.instcd = ptbs.instcd             AND otpt.instcd = dept.instcd             AND otpt.orddeptcd = dept.deptcd             AND otpt.orddd >= dept.valifromdd             AND otpt.orddd <= dept.valitodd             AND otpt.orddrid = usrb.userid             AND otpt.orddd >= usrb.userfromdd             AND otpt.orddd <= usrb.usertodd             AND otpt.instcd = cent.instcd(+)             AND otpt.centcd = cent.deptcd(+)             AND otpt.orddd >= cent.valifromdd(+)             AND otpt.orddd <= cent.valitodd(+)                                          AND otpt.orgorddd =  :param0         AND otpt.orddd    =  :param0             AND otpt.instcd   =  :param1                        and exists (select 1                          from cmr.consent_mst mst                         where mst.hos_type = otpt.instcd                               and mst.visit_type = otpt.ordtype                               and mst.pid = otpt.pid                     and mst.cretno = otpt.cretno                               and mst.consent_state in ('UNFINISHED')                     and mst.use_yn = 'Y')                          AND otpt.orddeptcd =  :param2                        AND otpt.etcordflag NOT IN ('M','J')             AND otpt.medamtfreeresn NOT IN ('10')                         ORDER BY dept.deptengabbr, usrb.usernm, otpt.ordtm]

[Logging Date Time: 2016-10-04 13:55:03,254] =====================================================================================
SQL Command - Statement Id: [getOutPatList] PreparedStatement : [SELECT otpt.pid                                                                 AS pid,                 substr(otpt.orddd,1,4) || '/' || substr(otpt.orddd,5,2) || '/' || substr(otpt.orddd,7,2)     AS indd,                 otpt.cretno                                                              AS cretno,                 otpt.acptseqno                                                           AS seqno,                 otpt.instcd                                                              AS instcd,                 ptbs.hngnm                                                               AS hngnm,                 (select code.cdnm                  from com.zbcmcode code                 where code.cdgrupid = 'P0021'                       and code.valifromdd <= otpt.orddd                       and code.valitodd >= otpt.orddd                       and code.cdid = otpt.fsexamflag)                                   AS fsexamflag,                 otpt.orddeptcd                                                           AS orddeptcd,                 otpt.orddrid                                                             AS doctorid,                 1                                                                        AS hd,                 TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa,                 dept.depthngnm                                                                      AS deptnm,                 dept.deptengabbr                                                         AS deptengabbr,                 usrb.usernm                                                              AS doctornm,                 (SELECT term.termengnm diagengnm                    FROM emr.mmohdiag diag,                         emr.mrtmterm term                   WHERE diag.pid       = otpt.pid                     AND diag.orddd     = otpt.orddd                     AND diag.cretno    = otpt.cretno                     AND diag.orddeptcd = otpt.orddeptcd                     AND diag.instcd    = otpt.instcd                     AND diag.diagcd    = term.termcd                     AND diag.diagdd   >= term.termfromdd                     AND diag.diagdd   <= term.termtodd                     AND diag.instcd    = term.instcd                     AND diag.diaghistcd     = 'O'                     AND diag.diagtypecd     = 'D'                     AND diag.diagkindcdflag = 'M'                     AND ROWNUM = 1)                          AS diagnm,                 'N'                                                                      AS dschnoti,                     'N'                                                                      AS roomcd,                     'N'                                                                      AS cnst,                 otpt.ordtype                                                             AS ordtype,                 (SELECT z.cdnm                  FROM   com.zbcmcode z                  WHERE  otpt.insukind = z.cdid                  AND    z.cdgrupid = 'P0008'                  AND    otpt.orddd BETWEEN z.valifromdd AND z.valitodd)                  AS bostyle,                 case when otpt.elbulbodstat='0' then '접수'                 when otpt.elbulbodstat = '1' then '대기'                 when otpt.elbulbodstat = '2' then '완료'                 when otpt.elbulbodstat = '3' then '보류'                 end               AS elbulbodstat,                 substr(otpt.ordtm,1,2) || ':' || substr(otpt.ordtm,3,2) AS ordtm,                 otpt.centcd                  as centcd,                 cent.depthngnm               as centnm,                 cent.deptengabbr             as centengabbr,                 otpt.orddd            FROM pam.pmohotpt otpt               , pam.pmcmptbs ptbs               , com.zsdddept dept               , com.zsumusrb usrb               , com.zsdddept cent           WHERE otpt.histstat IN ('R', 'T')             AND otpt.ordtype IN ('O', 'S')             AND otpt.orddd = otpt.orgorddd             AND otpt.cretno = otpt.orgcretno             AND otpt.pid = ptbs.pid             AND otpt.instcd = ptbs.instcd             AND otpt.instcd = dept.instcd             AND otpt.orddeptcd = dept.deptcd             AND otpt.orddd >= dept.valifromdd             AND otpt.orddd <= dept.valitodd             AND otpt.orddrid = usrb.userid             AND otpt.orddd >= usrb.userfromdd             AND otpt.orddd <= usrb.usertodd             AND otpt.instcd = cent.instcd(+)             AND otpt.centcd = cent.deptcd(+)             AND otpt.orddd >= cent.valifromdd(+)             AND otpt.orddd <= cent.valitodd(+)                                          AND otpt.orgorddd =  :param0         AND otpt.orddd    =  :param0             AND otpt.instcd   =  :param1                        and exists (select 1                          from cmr.consent_mst mst                         where mst.hos_type = otpt.instcd                               and mst.visit_type = otpt.ordtype                               and mst.pid = otpt.pid                     and mst.cretno = otpt.cretno                               and mst.consent_state in ('UNFINISHED')                     and mst.use_yn = 'Y')                          AND otpt.orddeptcd =  :param2                        AND otpt.etcordflag NOT IN ('M','J')             AND otpt.medamtfreeresn NOT IN ('10')                         ORDER BY dept.deptengabbr, usrb.usernm, otpt.ordtm]

[Logging Date Time: 2016-10-04 13:55:03,404] =====================================================================================
SQL Command - Statement Id: [getOutPatList] Parameters: [param0=[srchdd,20160808], param1=[instcd,111], param2=[orddeptcd,2010300000]]

[Logging Date Time: 2016-10-04 13:55:03,404] =====================================================================================
SQL Command - Statement Id: [getOutPatList] Parameters: [param0=[srchdd,20160808], param1=[instcd,111], param2=[orddeptcd,2010300000]]

[Logging Date Time: 2016-10-04 13:55:03,404] =====================================================================================
SQL Command - Statement Id: [getOutPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]

[Logging Date Time: 2016-10-04 13:55:03,404] =====================================================================================
SQL Command - Statement Id: [getOutPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]

[Logging Date Time: 2016-10-04 13:58:12,977] =====================================================================================
SQL Command - Statement Id: [getOutPatList] PreparedStatement : [SELECT otpt.pid                                                                 AS pid,                 substr(otpt.orddd,1,4) || '/' || substr(otpt.orddd,5,2) || '/' || substr(otpt.orddd,7,2)     AS indd,                 otpt.cretno                                                              AS cretno,                 otpt.acptseqno                                                           AS seqno,                 otpt.instcd                                                              AS instcd,                 ptbs.hngnm                                                               AS hngnm,                 (select code.cdnm                  from com.zbcmcode code                 where code.cdgrupid = 'P0021'                       and code.valifromdd <= otpt.orddd                       and code.valitodd >= otpt.orddd                       and code.cdid = otpt.fsexamflag)                                   AS fsexamflag,                 otpt.orddeptcd                                                           AS orddeptcd,                 otpt.orddrid                                                             AS doctorid,                 1                                                                        AS hd,                 TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa,                 dept.depthngnm                                                                      AS deptnm,                 dept.deptengabbr                                                         AS deptengabbr,                 usrb.usernm                                                              AS doctornm,                 (SELECT term.termengnm diagengnm                    FROM emr.mmohdiag diag,                         emr.mrtmterm term                   WHERE diag.pid       = otpt.pid                     AND diag.orddd     = otpt.orddd                     AND diag.cretno    = otpt.cretno                     AND diag.orddeptcd = otpt.orddeptcd                     AND diag.instcd    = otpt.instcd                     AND diag.diagcd    = term.termcd                     AND diag.diagdd   >= term.termfromdd                     AND diag.diagdd   <= term.termtodd                     AND diag.instcd    = term.instcd                     AND diag.diaghistcd     = 'O'                     AND diag.diagtypecd     = 'D'                     AND diag.diagkindcdflag = 'M'                     AND ROWNUM = 1)                          AS diagnm,                 'N'                                                                      AS dschnoti,                     'N'                                                                      AS roomcd,                     'N'                                                                      AS cnst,                 otpt.ordtype                                                             AS ordtype,                 (SELECT z.cdnm                  FROM   com.zbcmcode z                  WHERE  otpt.insukind = z.cdid                  AND    z.cdgrupid = 'P0008'                  AND    otpt.orddd BETWEEN z.valifromdd AND z.valitodd)                  AS bostyle,                 case when otpt.elbulbodstat='0' then '접수'                 when otpt.elbulbodstat = '1' then '대기'                 when otpt.elbulbodstat = '2' then '완료'                 when otpt.elbulbodstat = '3' then '보류'                 end               AS elbulbodstat,                 substr(otpt.ordtm,1,2) || ':' || substr(otpt.ordtm,3,2) AS ordtm,                 otpt.centcd                  as centcd,                 cent.depthngnm               as centnm,                 cent.deptengabbr             as centengabbr,                 otpt.orddd            FROM pam.pmohotpt otpt               , pam.pmcmptbs ptbs               , com.zsdddept dept               , com.zsumusrb usrb               , com.zsdddept cent           WHERE otpt.histstat IN ('R', 'T')             AND otpt.ordtype IN ('O', 'S')             AND otpt.orddd = otpt.orgorddd             AND otpt.cretno = otpt.orgcretno             AND otpt.pid = ptbs.pid             AND otpt.instcd = ptbs.instcd             AND otpt.instcd = dept.instcd             AND otpt.orddeptcd = dept.deptcd             AND otpt.orddd >= dept.valifromdd             AND otpt.orddd <= dept.valitodd             AND otpt.orddrid = usrb.userid             AND otpt.orddd >= usrb.userfromdd             AND otpt.orddd <= usrb.usertodd             AND otpt.instcd = cent.instcd(+)             AND otpt.centcd = cent.deptcd(+)             AND otpt.orddd >= cent.valifromdd(+)             AND otpt.orddd <= cent.valitodd(+)                                          AND otpt.orgorddd =  :param0         AND otpt.orddd    =  :param0             AND otpt.instcd   =  :param1                        and exists (select 1                          from cmr.consent_mst mst                         where mst.hos_type = otpt.instcd                               and mst.visit_type = otpt.ordtype                               and mst.pid = otpt.pid                     and mst.cretno = otpt.cretno                               and mst.consent_state in ('UNFINISHED')                     and mst.use_yn = 'Y')                          AND otpt.orddeptcd =  :param2                        AND otpt.etcordflag NOT IN ('M','J')             AND otpt.medamtfreeresn NOT IN ('10')                         ORDER BY dept.deptengabbr, usrb.usernm, otpt.ordtm]

[Logging Date Time: 2016-10-04 13:58:12,977] =====================================================================================
SQL Command - Statement Id: [getOutPatList] PreparedStatement : [SELECT otpt.pid                                                                 AS pid,                 substr(otpt.orddd,1,4) || '/' || substr(otpt.orddd,5,2) || '/' || substr(otpt.orddd,7,2)     AS indd,                 otpt.cretno                                                              AS cretno,                 otpt.acptseqno                                                           AS seqno,                 otpt.instcd                                                              AS instcd,                 ptbs.hngnm                                                               AS hngnm,                 (select code.cdnm                  from com.zbcmcode code                 where code.cdgrupid = 'P0021'                       and code.valifromdd <= otpt.orddd                       and code.valitodd >= otpt.orddd                       and code.cdid = otpt.fsexamflag)                                   AS fsexamflag,                 otpt.orddeptcd                                                           AS orddeptcd,                 otpt.orddrid                                                             AS doctorid,                 1                                                                        AS hd,                 TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa,                 dept.depthngnm                                                                      AS deptnm,                 dept.deptengabbr                                                         AS deptengabbr,                 usrb.usernm                                                              AS doctornm,                 (SELECT term.termengnm diagengnm                    FROM emr.mmohdiag diag,                         emr.mrtmterm term                   WHERE diag.pid       = otpt.pid                     AND diag.orddd     = otpt.orddd                     AND diag.cretno    = otpt.cretno                     AND diag.orddeptcd = otpt.orddeptcd                     AND diag.instcd    = otpt.instcd                     AND diag.diagcd    = term.termcd                     AND diag.diagdd   >= term.termfromdd                     AND diag.diagdd   <= term.termtodd                     AND diag.instcd    = term.instcd                     AND diag.diaghistcd     = 'O'                     AND diag.diagtypecd     = 'D'                     AND diag.diagkindcdflag = 'M'                     AND ROWNUM = 1)                          AS diagnm,                 'N'                                                                      AS dschnoti,                     'N'                                                                      AS roomcd,                     'N'                                                                      AS cnst,                 otpt.ordtype                                                             AS ordtype,                 (SELECT z.cdnm                  FROM   com.zbcmcode z                  WHERE  otpt.insukind = z.cdid                  AND    z.cdgrupid = 'P0008'                  AND    otpt.orddd BETWEEN z.valifromdd AND z.valitodd)                  AS bostyle,                 case when otpt.elbulbodstat='0' then '접수'                 when otpt.elbulbodstat = '1' then '대기'                 when otpt.elbulbodstat = '2' then '완료'                 when otpt.elbulbodstat = '3' then '보류'                 end               AS elbulbodstat,                 substr(otpt.ordtm,1,2) || ':' || substr(otpt.ordtm,3,2) AS ordtm,                 otpt.centcd                  as centcd,                 cent.depthngnm               as centnm,                 cent.deptengabbr             as centengabbr,                 otpt.orddd            FROM pam.pmohotpt otpt               , pam.pmcmptbs ptbs               , com.zsdddept dept               , com.zsumusrb usrb               , com.zsdddept cent           WHERE otpt.histstat IN ('R', 'T')             AND otpt.ordtype IN ('O', 'S')             AND otpt.orddd = otpt.orgorddd             AND otpt.cretno = otpt.orgcretno             AND otpt.pid = ptbs.pid             AND otpt.instcd = ptbs.instcd             AND otpt.instcd = dept.instcd             AND otpt.orddeptcd = dept.deptcd             AND otpt.orddd >= dept.valifromdd             AND otpt.orddd <= dept.valitodd             AND otpt.orddrid = usrb.userid             AND otpt.orddd >= usrb.userfromdd             AND otpt.orddd <= usrb.usertodd             AND otpt.instcd = cent.instcd(+)             AND otpt.centcd = cent.deptcd(+)             AND otpt.orddd >= cent.valifromdd(+)             AND otpt.orddd <= cent.valitodd(+)                                          AND otpt.orgorddd =  :param0         AND otpt.orddd    =  :param0             AND otpt.instcd   =  :param1                        and exists (select 1                          from cmr.consent_mst mst                         where mst.hos_type = otpt.instcd                               and mst.visit_type = otpt.ordtype                               and mst.pid = otpt.pid                     and mst.cretno = otpt.cretno                               and mst.consent_state in ('UNFINISHED')                     and mst.use_yn = 'Y')                          AND otpt.orddeptcd =  :param2                        AND otpt.etcordflag NOT IN ('M','J')             AND otpt.medamtfreeresn NOT IN ('10')                         ORDER BY dept.deptengabbr, usrb.usernm, otpt.ordtm]

[Logging Date Time: 2016-10-04 13:58:12,978] =====================================================================================
SQL Command - Statement Id: [getOutPatList] Parameters: [param0=[srchdd,20160808], param1=[instcd,111], param2=[orddeptcd,2010300000]]

[Logging Date Time: 2016-10-04 13:58:12,978] =====================================================================================
SQL Command - Statement Id: [getOutPatList] Parameters: [param0=[srchdd,20160808], param1=[instcd,111], param2=[orddeptcd,2010300000]]

[Logging Date Time: 2016-10-04 13:58:12,978] =====================================================================================
SQL Command - Statement Id: [getOutPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]

[Logging Date Time: 2016-10-04 13:58:12,978] =====================================================================================
SQL Command - Statement Id: [getOutPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]

[Logging Date Time: 2016-10-04 13:58:44,366] =====================================================================================
SQL Command - Statement Id: [getOutPatList] PreparedStatement : [SELECT otpt.pid                                                                 AS pid,                 substr(otpt.orddd,1,4) || '/' || substr(otpt.orddd,5,2) || '/' || substr(otpt.orddd,7,2)     AS indd,                 otpt.cretno                                                              AS cretno,                 otpt.acptseqno                                                           AS seqno,                 otpt.instcd                                                              AS instcd,                 ptbs.hngnm                                                               AS hngnm,                 (select code.cdnm                  from com.zbcmcode code                 where code.cdgrupid = 'P0021'                       and code.valifromdd <= otpt.orddd                       and code.valitodd >= otpt.orddd                       and code.cdid = otpt.fsexamflag)                                   AS fsexamflag,                 otpt.orddeptcd                                                           AS orddeptcd,                 otpt.orddrid                                                             AS doctorid,                 1                                                                        AS hd,                 TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa,                 dept.depthngnm                                                                      AS deptnm,                 dept.deptengabbr                                                         AS deptengabbr,                 usrb.usernm                                                              AS doctornm,                 (SELECT term.termengnm diagengnm                    FROM emr.mmohdiag diag,                         emr.mrtmterm term                   WHERE diag.pid       = otpt.pid                     AND diag.orddd     = otpt.orddd                     AND diag.cretno    = otpt.cretno                     AND diag.orddeptcd = otpt.orddeptcd                     AND diag.instcd    = otpt.instcd                     AND diag.diagcd    = term.termcd                     AND diag.diagdd   >= term.termfromdd                     AND diag.diagdd   <= term.termtodd                     AND diag.instcd    = term.instcd                     AND diag.diaghistcd     = 'O'                     AND diag.diagtypecd     = 'D'                     AND diag.diagkindcdflag = 'M'                     AND ROWNUM = 1)                          AS diagnm,                 'N'                                                                      AS dschnoti,                     'N'                                                                      AS roomcd,                     'N'                                                                      AS cnst,                 otpt.ordtype                                                             AS ordtype,                 (SELECT z.cdnm                  FROM   com.zbcmcode z                  WHERE  otpt.insukind = z.cdid                  AND    z.cdgrupid = 'P0008'                  AND    otpt.orddd BETWEEN z.valifromdd AND z.valitodd)                  AS bostyle,                 case when otpt.elbulbodstat='0' then '접수'                 when otpt.elbulbodstat = '1' then '대기'                 when otpt.elbulbodstat = '2' then '완료'                 when otpt.elbulbodstat = '3' then '보류'                 end               AS elbulbodstat,                 substr(otpt.ordtm,1,2) || ':' || substr(otpt.ordtm,3,2) AS ordtm,                 otpt.centcd                  as centcd,                 cent.depthngnm               as centnm,                 cent.deptengabbr             as centengabbr,                 otpt.orddd            FROM pam.pmohotpt otpt               , pam.pmcmptbs ptbs               , com.zsdddept dept               , com.zsumusrb usrb               , com.zsdddept cent           WHERE otpt.histstat IN ('R', 'T')             AND otpt.ordtype IN ('O', 'S')             AND otpt.orddd = otpt.orgorddd             AND otpt.cretno = otpt.orgcretno             AND otpt.pid = ptbs.pid             AND otpt.instcd = ptbs.instcd             AND otpt.instcd = dept.instcd             AND otpt.orddeptcd = dept.deptcd             AND otpt.orddd >= dept.valifromdd             AND otpt.orddd <= dept.valitodd             AND otpt.orddrid = usrb.userid             AND otpt.orddd >= usrb.userfromdd             AND otpt.orddd <= usrb.usertodd             AND otpt.instcd = cent.instcd(+)             AND otpt.centcd = cent.deptcd(+)             AND otpt.orddd >= cent.valifromdd(+)             AND otpt.orddd <= cent.valitodd(+)                                          AND otpt.orgorddd =  :param0         AND otpt.orddd    =  :param0             AND otpt.instcd   =  :param1                        and exists (select 1                          from cmr.consent_mst mst                         where mst.hos_type = otpt.instcd                               and mst.visit_type = otpt.ordtype                               and mst.pid = otpt.pid                     and mst.cretno = otpt.cretno                               and mst.consent_state in ('UNFINISHED')                     and mst.use_yn = 'Y')                          AND otpt.orddeptcd =  :param2                        AND otpt.etcordflag NOT IN ('M','J')             AND otpt.medamtfreeresn NOT IN ('10')                         ORDER BY dept.deptengabbr, usrb.usernm, otpt.ordtm]

[Logging Date Time: 2016-10-04 13:58:44,366] =====================================================================================
SQL Command - Statement Id: [getOutPatList] PreparedStatement : [SELECT otpt.pid                                                                 AS pid,                 substr(otpt.orddd,1,4) || '/' || substr(otpt.orddd,5,2) || '/' || substr(otpt.orddd,7,2)     AS indd,                 otpt.cretno                                                              AS cretno,                 otpt.acptseqno                                                           AS seqno,                 otpt.instcd                                                              AS instcd,                 ptbs.hngnm                                                               AS hngnm,                 (select code.cdnm                  from com.zbcmcode code                 where code.cdgrupid = 'P0021'                       and code.valifromdd <= otpt.orddd                       and code.valitodd >= otpt.orddd                       and code.cdid = otpt.fsexamflag)                                   AS fsexamflag,                 otpt.orddeptcd                                                           AS orddeptcd,                 otpt.orddrid                                                             AS doctorid,                 1                                                                        AS hd,                 TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa,                 dept.depthngnm                                                                      AS deptnm,                 dept.deptengabbr                                                         AS deptengabbr,                 usrb.usernm                                                              AS doctornm,                 (SELECT term.termengnm diagengnm                    FROM emr.mmohdiag diag,                         emr.mrtmterm term                   WHERE diag.pid       = otpt.pid                     AND diag.orddd     = otpt.orddd                     AND diag.cretno    = otpt.cretno                     AND diag.orddeptcd = otpt.orddeptcd                     AND diag.instcd    = otpt.instcd                     AND diag.diagcd    = term.termcd                     AND diag.diagdd   >= term.termfromdd                     AND diag.diagdd   <= term.termtodd                     AND diag.instcd    = term.instcd                     AND diag.diaghistcd     = 'O'                     AND diag.diagtypecd     = 'D'                     AND diag.diagkindcdflag = 'M'                     AND ROWNUM = 1)                          AS diagnm,                 'N'                                                                      AS dschnoti,                     'N'                                                                      AS roomcd,                     'N'                                                                      AS cnst,                 otpt.ordtype                                                             AS ordtype,                 (SELECT z.cdnm                  FROM   com.zbcmcode z                  WHERE  otpt.insukind = z.cdid                  AND    z.cdgrupid = 'P0008'                  AND    otpt.orddd BETWEEN z.valifromdd AND z.valitodd)                  AS bostyle,                 case when otpt.elbulbodstat='0' then '접수'                 when otpt.elbulbodstat = '1' then '대기'                 when otpt.elbulbodstat = '2' then '완료'                 when otpt.elbulbodstat = '3' then '보류'                 end               AS elbulbodstat,                 substr(otpt.ordtm,1,2) || ':' || substr(otpt.ordtm,3,2) AS ordtm,                 otpt.centcd                  as centcd,                 cent.depthngnm               as centnm,                 cent.deptengabbr             as centengabbr,                 otpt.orddd            FROM pam.pmohotpt otpt               , pam.pmcmptbs ptbs               , com.zsdddept dept               , com.zsumusrb usrb               , com.zsdddept cent           WHERE otpt.histstat IN ('R', 'T')             AND otpt.ordtype IN ('O', 'S')             AND otpt.orddd = otpt.orgorddd             AND otpt.cretno = otpt.orgcretno             AND otpt.pid = ptbs.pid             AND otpt.instcd = ptbs.instcd             AND otpt.instcd = dept.instcd             AND otpt.orddeptcd = dept.deptcd             AND otpt.orddd >= dept.valifromdd             AND otpt.orddd <= dept.valitodd             AND otpt.orddrid = usrb.userid             AND otpt.orddd >= usrb.userfromdd             AND otpt.orddd <= usrb.usertodd             AND otpt.instcd = cent.instcd(+)             AND otpt.centcd = cent.deptcd(+)             AND otpt.orddd >= cent.valifromdd(+)             AND otpt.orddd <= cent.valitodd(+)                                          AND otpt.orgorddd =  :param0         AND otpt.orddd    =  :param0             AND otpt.instcd   =  :param1                        and exists (select 1                          from cmr.consent_mst mst                         where mst.hos_type = otpt.instcd                               and mst.visit_type = otpt.ordtype                               and mst.pid = otpt.pid                     and mst.cretno = otpt.cretno                               and mst.consent_state in ('UNFINISHED')                     and mst.use_yn = 'Y')                          AND otpt.orddeptcd =  :param2                        AND otpt.etcordflag NOT IN ('M','J')             AND otpt.medamtfreeresn NOT IN ('10')                         ORDER BY dept.deptengabbr, usrb.usernm, otpt.ordtm]

[Logging Date Time: 2016-10-04 13:58:44,367] =====================================================================================
SQL Command - Statement Id: [getOutPatList] Parameters: [param0=[srchdd,20160808], param1=[instcd,111], param2=[orddeptcd,2010300000]]

[Logging Date Time: 2016-10-04 13:58:44,367] =====================================================================================
SQL Command - Statement Id: [getOutPatList] Parameters: [param0=[srchdd,20160808], param1=[instcd,111], param2=[orddeptcd,2010300000]]

[Logging Date Time: 2016-10-04 13:58:44,367] =====================================================================================
SQL Command - Statement Id: [getOutPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]

[Logging Date Time: 2016-10-04 13:58:44,367] =====================================================================================
SQL Command - Statement Id: [getOutPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]

[Logging Date Time: 2016-10-04 14:11:17,156] =====================================================================================
SQL Command - Unable to open connection to "Oracle, Microsoft provider V2.0.0.0".
IBatisNet.DataMapper.Exceptions.DataMapperException: Unable to open connection to "Oracle, Microsoft provider V2.0.0.0". ---> System.Data.OracleClient.OracleException: ORA-12154: TNS:지정된 접속 식별자를 분석할 수 없음

   위치: System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
   위치: System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   위치: System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   위치: System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   위치: System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   위치: System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   위치: System.Data.OracleClient.OracleConnection.Open()
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   --- 내부 예외 스택 추적의 끝 ---
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapSession.BeginTransaction(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapper.BeginTransaction()
   위치: CLIP.eForm.Server.Data.IBatisHelper.GetConnect(String sProvidersPath)

[Logging Date Time: 2016-10-04 14:13:16,922] =====================================================================================
SQL Command - Unable to open connection to "Oracle, Microsoft provider V2.0.0.0".
IBatisNet.DataMapper.Exceptions.DataMapperException: Unable to open connection to "Oracle, Microsoft provider V2.0.0.0". ---> System.Data.OracleClient.OracleException: ORA-12154: TNS:지정된 접속 식별자를 분석할 수 없음

   위치: System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
   위치: System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   위치: System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   위치: System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   위치: System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   위치: System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   위치: System.Data.OracleClient.OracleConnection.Open()
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   --- 내부 예외 스택 추적의 끝 ---
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapSession.BeginTransaction(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapper.BeginTransaction()
   위치: CLIP.eForm.Server.Data.IBatisHelper.GetConnect(String sProvidersPath)

[Logging Date Time: 2016-10-04 14:23:25,558] =====================================================================================
SQL Command - Unable to open connection to "Oracle, Microsoft provider V2.0.0.0".
IBatisNet.DataMapper.Exceptions.DataMapperException: Unable to open connection to "Oracle, Microsoft provider V2.0.0.0". ---> System.Data.OracleClient.OracleException: ORA-12154: TNS:지정된 접속 식별자를 분석할 수 없음

   위치: System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
   위치: System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   위치: System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   위치: System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   위치: System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   위치: System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   위치: System.Data.OracleClient.OracleConnection.Open()
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   --- 내부 예외 스택 추적의 끝 ---
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapSession.BeginTransaction(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapper.BeginTransaction()
   위치: CLIP.eForm.Server.Data.IBatisHelper.GetConnect(String sProvidersPath)

[Logging Date Time: 2016-10-04 14:23:57,409] =====================================================================================
SQL Command - Unable to open connection to "Oracle, Microsoft provider V2.0.0.0".
IBatisNet.DataMapper.Exceptions.DataMapperException: Unable to open connection to "Oracle, Microsoft provider V2.0.0.0". ---> System.Data.OracleClient.OracleException: ORA-12514: TNS:리스너가 현재 접속 기술자에 요청된 서비스를 알지 못함

   위치: System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
   위치: System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   위치: System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   위치: System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   위치: System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   위치: System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   위치: System.Data.OracleClient.OracleConnection.Open()
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   --- 내부 예외 스택 추적의 끝 ---
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapSession.BeginTransaction(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapper.BeginTransaction()
   위치: CLIP.eForm.Server.Data.IBatisHelper.GetConnect(String sProvidersPath)

[Logging Date Time: 2016-10-04 14:24:23,646] =====================================================================================
SQL Command - Unable to open connection to "Oracle, Microsoft provider V2.0.0.0".
IBatisNet.DataMapper.Exceptions.DataMapperException: Unable to open connection to "Oracle, Microsoft provider V2.0.0.0". ---> System.Data.OracleClient.OracleException: ORA-12514: TNS:리스너가 현재 접속 기술자에 요청된 서비스를 알지 못함

   위치: System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
   위치: System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   위치: System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   위치: System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   위치: System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   위치: System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   위치: System.Data.OracleClient.OracleConnection.Open()
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   --- 내부 예외 스택 추적의 끝 ---
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapSession.BeginTransaction(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapper.BeginTransaction()
   위치: CLIP.eForm.Server.Data.IBatisHelper.GetConnect(String sProvidersPath)

[Logging Date Time: 2016-10-04 14:24:52,949] =====================================================================================
SQL Command - Unable to open connection to "Oracle, Microsoft provider V2.0.0.0".
IBatisNet.DataMapper.Exceptions.DataMapperException: Unable to open connection to "Oracle, Microsoft provider V2.0.0.0". ---> System.Data.OracleClient.OracleException: ORA-12514: TNS:리스너가 현재 접속 기술자에 요청된 서비스를 알지 못함

   위치: System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
   위치: System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   위치: System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   위치: System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   위치: System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   위치: System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   위치: System.Data.OracleClient.OracleConnection.Open()
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   --- 내부 예외 스택 추적의 끝 ---
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapSession.BeginTransaction(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapper.BeginTransaction()
   위치: CLIP.eForm.Server.Data.IBatisHelper.GetConnect(String sProvidersPath)

[Logging Date Time: 2016-10-04 14:25:41,321] =====================================================================================
SQL Command - Unable to open connection to "Oracle, Microsoft provider V2.0.0.0".
IBatisNet.DataMapper.Exceptions.DataMapperException: Unable to open connection to "Oracle, Microsoft provider V2.0.0.0". ---> System.Data.OracleClient.OracleException: ORA-12514: TNS:리스너가 현재 접속 기술자에 요청된 서비스를 알지 못함

   위치: System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
   위치: System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   위치: System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   위치: System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   위치: System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   위치: System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   위치: System.Data.OracleClient.OracleConnection.Open()
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   --- 내부 예외 스택 추적의 끝 ---
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapSession.BeginTransaction(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapper.BeginTransaction()
   위치: CLIP.eForm.Server.Data.IBatisHelper.GetConnect(String sProvidersPath)

[Logging Date Time: 2016-10-04 14:31:52,829] =====================================================================================
SQL Command - Unable to open connection to "Oracle, Microsoft provider V2.0.0.0".
IBatisNet.DataMapper.Exceptions.DataMapperException: Unable to open connection to "Oracle, Microsoft provider V2.0.0.0". ---> System.Data.OracleClient.OracleException: ORA-12514: TNS:리스너가 현재 접속 기술자에 요청된 서비스를 알지 못함

   위치: System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
   위치: System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   위치: System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   위치: System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   위치: System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   위치: System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   위치: System.Data.OracleClient.OracleConnection.Open()
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   --- 내부 예외 스택 추적의 끝 ---
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapSession.BeginTransaction(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapper.BeginTransaction()
   위치: CLIP.eForm.Server.Data.IBatisHelper.GetConnect(String sProvidersPath)

[Logging Date Time: 2016-10-04 14:36:51,647] =====================================================================================
SQL Command - Unable to open connection to "Oracle, Microsoft provider V2.0.0.0".
IBatisNet.DataMapper.Exceptions.DataMapperException: Unable to open connection to "Oracle, Microsoft provider V2.0.0.0". ---> System.Data.OracleClient.OracleException: ORA-12154: TNS:지정된 접속 식별자를 분석할 수 없음

   위치: System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
   위치: System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   위치: System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   위치: System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   위치: System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   위치: System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   위치: System.Data.OracleClient.OracleConnection.Open()
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   --- 내부 예외 스택 추적의 끝 ---
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapSession.BeginTransaction(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapper.BeginTransaction()
   위치: CLIP.eForm.Server.Data.IBatisHelper.GetConnect(String sProvidersPath)

[Logging Date Time: 2016-10-04 14:39:36,975] =====================================================================================
SQL Command - Unable to open connection to "Oracle, Microsoft provider V2.0.0.0".
IBatisNet.DataMapper.Exceptions.DataMapperException: Unable to open connection to "Oracle, Microsoft provider V2.0.0.0". ---> System.Data.OracleClient.OracleException: ORA-12154: TNS:지정된 접속 식별자를 분석할 수 없음

   위치: System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
   위치: System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   위치: System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   위치: System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   위치: System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   위치: System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   위치: System.Data.OracleClient.OracleConnection.Open()
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   --- 내부 예외 스택 추적의 끝 ---
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapSession.BeginTransaction(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapper.BeginTransaction()
   위치: CLIP.eForm.Server.Data.IBatisHelper.GetConnect(String sProvidersPath)

[Logging Date Time: 2016-10-04 14:41:38,813] =====================================================================================
SQL Command - Unable to open connection to "Oracle, Microsoft provider V2.0.0.0".
IBatisNet.DataMapper.Exceptions.DataMapperException: Unable to open connection to "Oracle, Microsoft provider V2.0.0.0". ---> System.Data.OracleClient.OracleException: ORA-12154: TNS:지정된 접속 식별자를 분석할 수 없음

   위치: System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
   위치: System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   위치: System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   위치: System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   위치: System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   위치: System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   위치: System.Data.OracleClient.OracleConnection.Open()
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   --- 내부 예외 스택 추적의 끝 ---
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapSession.BeginTransaction(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapper.BeginTransaction()
   위치: CLIP.eForm.Server.Data.IBatisHelper.GetConnect(String sProvidersPath)

[Logging Date Time: 2016-10-04 14:46:48,701] =====================================================================================
SQL Command - Unable to open connection to "Oracle, Microsoft provider V2.0.0.0".
IBatisNet.DataMapper.Exceptions.DataMapperException: Unable to open connection to "Oracle, Microsoft provider V2.0.0.0". ---> System.Data.OracleClient.OracleException: ORA-12154: TNS:지정된 접속 식별자를 분석할 수 없음

   위치: System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
   위치: System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   위치: System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   위치: System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   위치: System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   위치: System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   위치: System.Data.OracleClient.OracleConnection.Open()
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   --- 내부 예외 스택 추적의 끝 ---
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapSession.BeginTransaction(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapper.BeginTransaction()
   위치: CLIP.eForm.Server.Data.IBatisHelper.GetConnect(String sProvidersPath)

[Logging Date Time: 2016-10-04 14:48:12,701] =====================================================================================
SQL Command - Unable to open connection to "Oracle, Microsoft provider V2.0.0.0".
IBatisNet.DataMapper.Exceptions.DataMapperException: Unable to open connection to "Oracle, Microsoft provider V2.0.0.0". ---> System.Data.OracleClient.OracleException: ORA-12514: TNS:리스너가 현재 접속 기술자에 요청된 서비스를 알지 못함

   위치: System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
   위치: System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   위치: System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   위치: System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   위치: System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   위치: System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   위치: System.Data.OracleClient.OracleConnection.Open()
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   --- 내부 예외 스택 추적의 끝 ---
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapSession.BeginTransaction(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapper.BeginTransaction()
   위치: CLIP.eForm.Server.Data.IBatisHelper.GetConnect(String sProvidersPath)

[Logging Date Time: 2016-10-04 15:08:55,371] =====================================================================================
SQL Command - Unable to open connection to "Oracle, Microsoft provider V2.0.0.0".
IBatisNet.DataMapper.Exceptions.DataMapperException: Unable to open connection to "Oracle, Microsoft provider V2.0.0.0". ---> System.Data.OracleClient.OracleException: ORA-12514: TNS:리스너가 현재 접속 기술자에 요청된 서비스를 알지 못함

   위치: System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
   위치: System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   위치: System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   위치: System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   위치: System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   위치: System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   위치: System.Data.OracleClient.OracleConnection.Open()
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   --- 내부 예외 스택 추적의 끝 ---
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapSession.BeginTransaction(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapper.BeginTransaction()
   위치: CLIP.eForm.Server.Data.IBatisHelper.GetConnect(String sProvidersPath)

[Logging Date Time: 2016-10-04 15:26:22,776] =====================================================================================
SQL Command - Unable to open connection to "Oracle, Microsoft provider V2.0.0.0".
IBatisNet.DataMapper.Exceptions.DataMapperException: Unable to open connection to "Oracle, Microsoft provider V2.0.0.0". ---> System.Data.OracleClient.OracleException: ORA-12514: TNS:리스너가 현재 접속 기술자에 요청된 서비스를 알지 못함

   위치: System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
   위치: System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   위치: System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   위치: System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   위치: System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   위치: System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   위치: System.Data.OracleClient.OracleConnection.Open()
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   --- 내부 예외 스택 추적의 끝 ---
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapSession.BeginTransaction(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapper.BeginTransaction()
   위치: CLIP.eForm.Server.Data.IBatisHelper.GetConnect(String sProvidersPath)

[Logging Date Time: 2016-10-04 15:29:00,577] =====================================================================================
SQL Command - Unable to open connection to "Oracle, Microsoft provider V2.0.0.0".
IBatisNet.DataMapper.Exceptions.DataMapperException: Unable to open connection to "Oracle, Microsoft provider V2.0.0.0". ---> System.Data.OracleClient.OracleException: ORA-12154: TNS:지정된 접속 식별자를 분석할 수 없음

   위치: System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
   위치: System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   위치: System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   위치: System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   위치: System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   위치: System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   위치: System.Data.OracleClient.OracleConnection.Open()
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   --- 내부 예외 스택 추적의 끝 ---
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapSession.BeginTransaction(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapper.BeginTransaction()
   위치: CLIP.eForm.Server.Data.IBatisHelper.GetConnect(String sProvidersPath)

[Logging Date Time: 2016-10-04 15:29:46,522] =====================================================================================
SQL Command - Unable to open connection to "Oracle, Microsoft provider V2.0.0.0".
IBatisNet.DataMapper.Exceptions.DataMapperException: Unable to open connection to "Oracle, Microsoft provider V2.0.0.0". ---> System.Data.OracleClient.OracleException: ORA-12154: TNS:지정된 접속 식별자를 분석할 수 없음

   위치: System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
   위치: System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   위치: System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   위치: System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   위치: System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   위치: System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   위치: System.Data.OracleClient.OracleConnection.Open()
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   --- 내부 예외 스택 추적의 끝 ---
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapSession.BeginTransaction(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapper.BeginTransaction()
   위치: CLIP.eForm.Server.Data.IBatisHelper.GetConnect(String sProvidersPath)

[Logging Date Time: 2016-10-04 15:32:41,876] =====================================================================================
SQL Command - Statement Id: [getDeptList] PreparedStatement : [SELECT ' ' as deptcd,               '전체' as deptnm,               0 as clincdeptdispseq,               0 as sort               from dual        UNION ALL        SELECT deptcd,               depthngnm as deptnm,               clincdeptdispseq,               1 as sort          FROM com.zsdddept        WHERE instcd =  :param0           AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')>=valifromdd AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')<=valitodd                    AND rcptuseyn = 'Y'          ORDER BY clincdeptdispseq ASC]

[Logging Date Time: 2016-10-04 15:32:41,876] =====================================================================================
SQL Command - Statement Id: [getDeptList] PreparedStatement : [SELECT ' ' as deptcd,               '전체' as deptnm,               0 as clincdeptdispseq,               0 as sort               from dual        UNION ALL        SELECT deptcd,               depthngnm as deptnm,               clincdeptdispseq,               1 as sort          FROM com.zsdddept        WHERE instcd =  :param0           AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')>=valifromdd AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')<=valitodd                    AND rcptuseyn = 'Y'          ORDER BY clincdeptdispseq ASC]

[Logging Date Time: 2016-10-04 15:32:41,895] =====================================================================================
SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]]

[Logging Date Time: 2016-10-04 15:32:41,895] =====================================================================================
SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]]

[Logging Date Time: 2016-10-04 15:32:41,895] =====================================================================================
SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-10-04 15:32:41,895] =====================================================================================
SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-10-04 15:33:13,711] =====================================================================================
SQL Command - Statement Id: [getOutPatList] PreparedStatement : [SELECT otpt.pid                                                                 AS pid,                 substr(otpt.orddd,1,4) || '/' || substr(otpt.orddd,5,2) || '/' || substr(otpt.orddd,7,2)     AS indd,                 otpt.cretno                                                              AS cretno,                 otpt.acptseqno                                                           AS seqno,                 otpt.instcd                                                              AS instcd,                 ptbs.hngnm                                                               AS hngnm,                 (select code.cdnm                  from com.zbcmcode code                 where code.cdgrupid = 'P0021'                       and code.valifromdd <= otpt.orddd                       and code.valitodd >= otpt.orddd                       and code.cdid = otpt.fsexamflag)                                   AS fsexamflag,                 otpt.orddeptcd                                                           AS orddeptcd,                 otpt.orddrid                                                             AS doctorid,                 1                                                                        AS hd,                 TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa,                 dept.depthngnm                                                                      AS deptnm,                 dept.deptengabbr                                                         AS deptengabbr,                 usrb.usernm                                                              AS doctornm,                 (SELECT term.termengnm diagengnm                    FROM emr.mmohdiag diag,                         emr.mrtmterm term                   WHERE diag.pid       = otpt.pid                     AND diag.orddd     = otpt.orddd                     AND diag.cretno    = otpt.cretno                     AND diag.orddeptcd = otpt.orddeptcd                     AND diag.instcd    = otpt.instcd                     AND diag.diagcd    = term.termcd                     AND diag.diagdd   >= term.termfromdd                     AND diag.diagdd   <= term.termtodd                     AND diag.instcd    = term.instcd                     AND diag.diaghistcd     = 'O'                     AND diag.diagtypecd     = 'D'                     AND diag.diagkindcdflag = 'M'                     AND ROWNUM = 1)                          AS diagnm,                 'N'                                                                      AS dschnoti,                     'N'                                                                      AS roomcd,                     'N'                                                                      AS cnst,                 otpt.ordtype                                                             AS ordtype,                 (SELECT z.cdnm                  FROM   com.zbcmcode z                  WHERE  otpt.insukind = z.cdid                  AND    z.cdgrupid = 'P0008'                  AND    otpt.orddd BETWEEN z.valifromdd AND z.valitodd)                  AS bostyle,                 case when otpt.elbulbodstat='0' then '접수'                 when otpt.elbulbodstat = '1' then '대기'                 when otpt.elbulbodstat = '2' then '완료'                 when otpt.elbulbodstat = '3' then '보류'                 end               AS elbulbodstat,                 substr(otpt.ordtm,1,2) || ':' || substr(otpt.ordtm,3,2) AS ordtm,                 otpt.centcd                  as centcd,                 cent.depthngnm               as centnm,                 cent.deptengabbr             as centengabbr,                 otpt.orddd            FROM pam.pmohotpt otpt               , pam.pmcmptbs ptbs               , com.zsdddept dept               , com.zsumusrb usrb               , com.zsdddept cent           WHERE otpt.histstat IN ('R', 'T')             AND otpt.ordtype IN ('O', 'S')             AND otpt.orddd = otpt.orgorddd             AND otpt.cretno = otpt.orgcretno             AND otpt.pid = ptbs.pid             AND otpt.instcd = ptbs.instcd             AND otpt.instcd = dept.instcd             AND otpt.orddeptcd = dept.deptcd             AND otpt.orddd >= dept.valifromdd             AND otpt.orddd <= dept.valitodd             AND otpt.orddrid = usrb.userid             AND otpt.orddd >= usrb.userfromdd             AND otpt.orddd <= usrb.usertodd             AND otpt.instcd = cent.instcd(+)             AND otpt.centcd = cent.deptcd(+)             AND otpt.orddd >= cent.valifromdd(+)             AND otpt.orddd <= cent.valitodd(+)                                          AND otpt.orgorddd =  :param0         AND otpt.orddd    =  :param0             AND otpt.instcd   =  :param1                        and exists (select 1                          from cmr.consent_mst mst                         where mst.hos_type = otpt.instcd                               and mst.visit_type = otpt.ordtype                               and mst.pid = otpt.pid                     and mst.cretno = otpt.cretno                               and mst.consent_state in ('UNFINISHED')                     and mst.use_yn = 'Y')                          AND otpt.orddeptcd =  :param2                        AND otpt.etcordflag NOT IN ('M','J')             AND otpt.medamtfreeresn NOT IN ('10')                         ORDER BY dept.deptengabbr, usrb.usernm, otpt.ordtm]

[Logging Date Time: 2016-10-04 15:33:13,711] =====================================================================================
SQL Command - Statement Id: [getOutPatList] PreparedStatement : [SELECT otpt.pid                                                                 AS pid,                 substr(otpt.orddd,1,4) || '/' || substr(otpt.orddd,5,2) || '/' || substr(otpt.orddd,7,2)     AS indd,                 otpt.cretno                                                              AS cretno,                 otpt.acptseqno                                                           AS seqno,                 otpt.instcd                                                              AS instcd,                 ptbs.hngnm                                                               AS hngnm,                 (select code.cdnm                  from com.zbcmcode code                 where code.cdgrupid = 'P0021'                       and code.valifromdd <= otpt.orddd                       and code.valitodd >= otpt.orddd                       and code.cdid = otpt.fsexamflag)                                   AS fsexamflag,                 otpt.orddeptcd                                                           AS orddeptcd,                 otpt.orddrid                                                             AS doctorid,                 1                                                                        AS hd,                 TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa,                 dept.depthngnm                                                                      AS deptnm,                 dept.deptengabbr                                                         AS deptengabbr,                 usrb.usernm                                                              AS doctornm,                 (SELECT term.termengnm diagengnm                    FROM emr.mmohdiag diag,                         emr.mrtmterm term                   WHERE diag.pid       = otpt.pid                     AND diag.orddd     = otpt.orddd                     AND diag.cretno    = otpt.cretno                     AND diag.orddeptcd = otpt.orddeptcd                     AND diag.instcd    = otpt.instcd                     AND diag.diagcd    = term.termcd                     AND diag.diagdd   >= term.termfromdd                     AND diag.diagdd   <= term.termtodd                     AND diag.instcd    = term.instcd                     AND diag.diaghistcd     = 'O'                     AND diag.diagtypecd     = 'D'                     AND diag.diagkindcdflag = 'M'                     AND ROWNUM = 1)                          AS diagnm,                 'N'                                                                      AS dschnoti,                     'N'                                                                      AS roomcd,                     'N'                                                                      AS cnst,                 otpt.ordtype                                                             AS ordtype,                 (SELECT z.cdnm                  FROM   com.zbcmcode z                  WHERE  otpt.insukind = z.cdid                  AND    z.cdgrupid = 'P0008'                  AND    otpt.orddd BETWEEN z.valifromdd AND z.valitodd)                  AS bostyle,                 case when otpt.elbulbodstat='0' then '접수'                 when otpt.elbulbodstat = '1' then '대기'                 when otpt.elbulbodstat = '2' then '완료'                 when otpt.elbulbodstat = '3' then '보류'                 end               AS elbulbodstat,                 substr(otpt.ordtm,1,2) || ':' || substr(otpt.ordtm,3,2) AS ordtm,                 otpt.centcd                  as centcd,                 cent.depthngnm               as centnm,                 cent.deptengabbr             as centengabbr,                 otpt.orddd            FROM pam.pmohotpt otpt               , pam.pmcmptbs ptbs               , com.zsdddept dept               , com.zsumusrb usrb               , com.zsdddept cent           WHERE otpt.histstat IN ('R', 'T')             AND otpt.ordtype IN ('O', 'S')             AND otpt.orddd = otpt.orgorddd             AND otpt.cretno = otpt.orgcretno             AND otpt.pid = ptbs.pid             AND otpt.instcd = ptbs.instcd             AND otpt.instcd = dept.instcd             AND otpt.orddeptcd = dept.deptcd             AND otpt.orddd >= dept.valifromdd             AND otpt.orddd <= dept.valitodd             AND otpt.orddrid = usrb.userid             AND otpt.orddd >= usrb.userfromdd             AND otpt.orddd <= usrb.usertodd             AND otpt.instcd = cent.instcd(+)             AND otpt.centcd = cent.deptcd(+)             AND otpt.orddd >= cent.valifromdd(+)             AND otpt.orddd <= cent.valitodd(+)                                          AND otpt.orgorddd =  :param0         AND otpt.orddd    =  :param0             AND otpt.instcd   =  :param1                        and exists (select 1                          from cmr.consent_mst mst                         where mst.hos_type = otpt.instcd                               and mst.visit_type = otpt.ordtype                               and mst.pid = otpt.pid                     and mst.cretno = otpt.cretno                               and mst.consent_state in ('UNFINISHED')                     and mst.use_yn = 'Y')                          AND otpt.orddeptcd =  :param2                        AND otpt.etcordflag NOT IN ('M','J')             AND otpt.medamtfreeresn NOT IN ('10')                         ORDER BY dept.deptengabbr, usrb.usernm, otpt.ordtm]

[Logging Date Time: 2016-10-04 15:33:13,712] =====================================================================================
SQL Command - Statement Id: [getOutPatList] Parameters: [param0=[srchdd,20160808], param1=[instcd,111], param2=[orddeptcd,2010300000]]

[Logging Date Time: 2016-10-04 15:33:13,712] =====================================================================================
SQL Command - Statement Id: [getOutPatList] Parameters: [param0=[srchdd,20160808], param1=[instcd,111], param2=[orddeptcd,2010300000]]

[Logging Date Time: 2016-10-04 15:33:13,713] =====================================================================================
SQL Command - Statement Id: [getOutPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]

[Logging Date Time: 2016-10-04 15:33:13,713] =====================================================================================
SQL Command - Statement Id: [getOutPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]

[Logging Date Time: 2016-10-04 15:34:38,322] =====================================================================================
SQL Command - Statement Id: [getOutPatList] PreparedStatement : [SELECT otpt.pid                                                                 AS pid,                 substr(otpt.orddd,1,4) || '/' || substr(otpt.orddd,5,2) || '/' || substr(otpt.orddd,7,2)     AS indd,                 otpt.cretno                                                              AS cretno,                 otpt.acptseqno                                                           AS seqno,                 otpt.instcd                                                              AS instcd,                 ptbs.hngnm                                                               AS hngnm,                 (select code.cdnm                  from com.zbcmcode code                 where code.cdgrupid = 'P0021'                       and code.valifromdd <= otpt.orddd                       and code.valitodd >= otpt.orddd                       and code.cdid = otpt.fsexamflag)                                   AS fsexamflag,                 otpt.orddeptcd                                                           AS orddeptcd,                 otpt.orddrid                                                             AS doctorid,                 1                                                                        AS hd,                 TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa,                 dept.depthngnm                                                                      AS deptnm,                 dept.deptengabbr                                                         AS deptengabbr,                 usrb.usernm                                                              AS doctornm,                 (SELECT term.termengnm diagengnm                    FROM emr.mmohdiag diag,                         emr.mrtmterm term                   WHERE diag.pid       = otpt.pid                     AND diag.orddd     = otpt.orddd                     AND diag.cretno    = otpt.cretno                     AND diag.orddeptcd = otpt.orddeptcd                     AND diag.instcd    = otpt.instcd                     AND diag.diagcd    = term.termcd                     AND diag.diagdd   >= term.termfromdd                     AND diag.diagdd   <= term.termtodd                     AND diag.instcd    = term.instcd                     AND diag.diaghistcd     = 'O'                     AND diag.diagtypecd     = 'D'                     AND diag.diagkindcdflag = 'M'                     AND ROWNUM = 1)                          AS diagnm,                 'N'                                                                      AS dschnoti,                     'N'                                                                      AS roomcd,                     'N'                                                                      AS cnst,                 otpt.ordtype                                                             AS ordtype,                 (SELECT z.cdnm                  FROM   com.zbcmcode z                  WHERE  otpt.insukind = z.cdid                  AND    z.cdgrupid = 'P0008'                  AND    otpt.orddd BETWEEN z.valifromdd AND z.valitodd)                  AS bostyle,                 case when otpt.elbulbodstat='0' then '접수'                 when otpt.elbulbodstat = '1' then '대기'                 when otpt.elbulbodstat = '2' then '완료'                 when otpt.elbulbodstat = '3' then '보류'                 end               AS elbulbodstat,                 substr(otpt.ordtm,1,2) || ':' || substr(otpt.ordtm,3,2) AS ordtm,                 otpt.centcd                  as centcd,                 cent.depthngnm               as centnm,                 cent.deptengabbr             as centengabbr,                 otpt.orddd            FROM pam.pmohotpt otpt               , pam.pmcmptbs ptbs               , com.zsdddept dept               , com.zsumusrb usrb               , com.zsdddept cent           WHERE otpt.histstat IN ('R', 'T')             AND otpt.ordtype IN ('O', 'S')             AND otpt.orddd = otpt.orgorddd             AND otpt.cretno = otpt.orgcretno             AND otpt.pid = ptbs.pid             AND otpt.instcd = ptbs.instcd             AND otpt.instcd = dept.instcd             AND otpt.orddeptcd = dept.deptcd             AND otpt.orddd >= dept.valifromdd             AND otpt.orddd <= dept.valitodd             AND otpt.orddrid = usrb.userid             AND otpt.orddd >= usrb.userfromdd             AND otpt.orddd <= usrb.usertodd             AND otpt.instcd = cent.instcd(+)             AND otpt.centcd = cent.deptcd(+)             AND otpt.orddd >= cent.valifromdd(+)             AND otpt.orddd <= cent.valitodd(+)                                          AND otpt.orgorddd =  :param0         AND otpt.orddd    =  :param0             AND otpt.instcd   =  :param1                         AND otpt.orddeptcd =  :param2                        AND otpt.etcordflag NOT IN ('M','J')             AND otpt.medamtfreeresn NOT IN ('10')                         ORDER BY dept.deptengabbr, usrb.usernm, otpt.ordtm]

[Logging Date Time: 2016-10-04 15:34:38,322] =====================================================================================
SQL Command - Statement Id: [getOutPatList] PreparedStatement : [SELECT otpt.pid                                                                 AS pid,                 substr(otpt.orddd,1,4) || '/' || substr(otpt.orddd,5,2) || '/' || substr(otpt.orddd,7,2)     AS indd,                 otpt.cretno                                                              AS cretno,                 otpt.acptseqno                                                           AS seqno,                 otpt.instcd                                                              AS instcd,                 ptbs.hngnm                                                               AS hngnm,                 (select code.cdnm                  from com.zbcmcode code                 where code.cdgrupid = 'P0021'                       and code.valifromdd <= otpt.orddd                       and code.valitodd >= otpt.orddd                       and code.cdid = otpt.fsexamflag)                                   AS fsexamflag,                 otpt.orddeptcd                                                           AS orddeptcd,                 otpt.orddrid                                                             AS doctorid,                 1                                                                        AS hd,                 TRIM(ptbs.sex || '/' || LPAD(FLOOR(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd) / 12), 2, 0) || 'y' || LPAD(MOD(COM.FN_ZZ_GETAGE_EMR2('000000','0000000',otpt.orddd, 'B', ptbs.brthdd), 12), 2, 0) || 'm') AS sa,                 dept.depthngnm                                                                      AS deptnm,                 dept.deptengabbr                                                         AS deptengabbr,                 usrb.usernm                                                              AS doctornm,                 (SELECT term.termengnm diagengnm                    FROM emr.mmohdiag diag,                         emr.mrtmterm term                   WHERE diag.pid       = otpt.pid                     AND diag.orddd     = otpt.orddd                     AND diag.cretno    = otpt.cretno                     AND diag.orddeptcd = otpt.orddeptcd                     AND diag.instcd    = otpt.instcd                     AND diag.diagcd    = term.termcd                     AND diag.diagdd   >= term.termfromdd                     AND diag.diagdd   <= term.termtodd                     AND diag.instcd    = term.instcd                     AND diag.diaghistcd     = 'O'                     AND diag.diagtypecd     = 'D'                     AND diag.diagkindcdflag = 'M'                     AND ROWNUM = 1)                          AS diagnm,                 'N'                                                                      AS dschnoti,                     'N'                                                                      AS roomcd,                     'N'                                                                      AS cnst,                 otpt.ordtype                                                             AS ordtype,                 (SELECT z.cdnm                  FROM   com.zbcmcode z                  WHERE  otpt.insukind = z.cdid                  AND    z.cdgrupid = 'P0008'                  AND    otpt.orddd BETWEEN z.valifromdd AND z.valitodd)                  AS bostyle,                 case when otpt.elbulbodstat='0' then '접수'                 when otpt.elbulbodstat = '1' then '대기'                 when otpt.elbulbodstat = '2' then '완료'                 when otpt.elbulbodstat = '3' then '보류'                 end               AS elbulbodstat,                 substr(otpt.ordtm,1,2) || ':' || substr(otpt.ordtm,3,2) AS ordtm,                 otpt.centcd                  as centcd,                 cent.depthngnm               as centnm,                 cent.deptengabbr             as centengabbr,                 otpt.orddd            FROM pam.pmohotpt otpt               , pam.pmcmptbs ptbs               , com.zsdddept dept               , com.zsumusrb usrb               , com.zsdddept cent           WHERE otpt.histstat IN ('R', 'T')             AND otpt.ordtype IN ('O', 'S')             AND otpt.orddd = otpt.orgorddd             AND otpt.cretno = otpt.orgcretno             AND otpt.pid = ptbs.pid             AND otpt.instcd = ptbs.instcd             AND otpt.instcd = dept.instcd             AND otpt.orddeptcd = dept.deptcd             AND otpt.orddd >= dept.valifromdd             AND otpt.orddd <= dept.valitodd             AND otpt.orddrid = usrb.userid             AND otpt.orddd >= usrb.userfromdd             AND otpt.orddd <= usrb.usertodd             AND otpt.instcd = cent.instcd(+)             AND otpt.centcd = cent.deptcd(+)             AND otpt.orddd >= cent.valifromdd(+)             AND otpt.orddd <= cent.valitodd(+)                                          AND otpt.orgorddd =  :param0         AND otpt.orddd    =  :param0             AND otpt.instcd   =  :param1                         AND otpt.orddeptcd =  :param2                        AND otpt.etcordflag NOT IN ('M','J')             AND otpt.medamtfreeresn NOT IN ('10')                         ORDER BY dept.deptengabbr, usrb.usernm, otpt.ordtm]

[Logging Date Time: 2016-10-04 15:34:38,323] =====================================================================================
SQL Command - Statement Id: [getOutPatList] Parameters: [param0=[srchdd,20160808], param1=[instcd,111], param2=[orddeptcd,2010300000]]

[Logging Date Time: 2016-10-04 15:34:38,323] =====================================================================================
SQL Command - Statement Id: [getOutPatList] Parameters: [param0=[srchdd,20160808], param1=[instcd,111], param2=[orddeptcd,2010300000]]

[Logging Date Time: 2016-10-04 15:34:38,323] =====================================================================================
SQL Command - Statement Id: [getOutPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]

[Logging Date Time: 2016-10-04 15:34:38,323] =====================================================================================
SQL Command - Statement Id: [getOutPatList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]