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

[Logging Date Time: 2016-10-18 15:00:09,579] =====================================================================================
SQL Command - CLIP.eForm error: This SQL map does not contain a MappedStatement named GetUnfinishedListPerDoctor

[Logging Date Time: 2016-10-18 15:06:06,507] =====================================================================================
SQL Command - CLIP.eForm error: This SQL map does not contain a MappedStatement named GetUnfinishedListPerDoctor

[Logging Date Time: 2016-10-18 15:13:45,586] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] PreparedStatement : [select pid,               (select ptbs.hngnm                  from pam.pmcmptbs ptbs                 where ptbs.pid = a.pid                       and ptbs.instcd = '111') as hngnm,               (select v.FORM_CD                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formcd,               (select v.FORM_NAME                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formnm,               (select v.PRINT_ONLY                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as printonly,               a.order_date as orderdate,               a.*          from cmr.consent_mst a         where a.cosign_dc_id =  :param0                and a.consent_state in ( :param1 )]

[Logging Date Time: 2016-10-18 15:13:45,586] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] PreparedStatement : [select pid,               (select ptbs.hngnm                  from pam.pmcmptbs ptbs                 where ptbs.pid = a.pid                       and ptbs.instcd = '111') as hngnm,               (select v.FORM_CD                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formcd,               (select v.FORM_NAME                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formnm,               (select v.PRINT_ONLY                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as printonly,               a.order_date as orderdate,               a.*          from cmr.consent_mst a         where a.cosign_dc_id =  :param0                and a.consent_state in ( :param1 )]

[Logging Date Time: 2016-10-18 15:13:45,666] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Parameters: [param0=[userid,104796], param1=[status,UNFINISHED]]

[Logging Date Time: 2016-10-18 15:13:45,666] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Parameters: [param0=[userid,104796], param1=[status,UNFINISHED]]

[Logging Date Time: 2016-10-18 15:13:45,666] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-10-18 15:13:45,666] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-10-18 15:19:33,132] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] PreparedStatement : [select pid,               (select ptbs.hngnm                  from pam.pmcmptbs ptbs                 where ptbs.pid = a.pid                       and ptbs.instcd = '111') as hngnm,               (select v.FORM_CD                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formcd,               (select v.FORM_NAME                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formnm,               (select v.PRINT_ONLY                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as printonly,               a.order_date as orderdate          from cmr.consent_mst a         where a.cosign_dc_id =  :param0                and a.consent_state in ( :param1 )]

[Logging Date Time: 2016-10-18 15:19:33,132] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] PreparedStatement : [select pid,               (select ptbs.hngnm                  from pam.pmcmptbs ptbs                 where ptbs.pid = a.pid                       and ptbs.instcd = '111') as hngnm,               (select v.FORM_CD                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formcd,               (select v.FORM_NAME                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formnm,               (select v.PRINT_ONLY                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as printonly,               a.order_date as orderdate          from cmr.consent_mst a         where a.cosign_dc_id =  :param0                and a.consent_state in ( :param1 )]

[Logging Date Time: 2016-10-18 15:19:33,132] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Parameters: [param0=[userid,104796], param1=[status,UNFINISHED]]

[Logging Date Time: 2016-10-18 15:19:33,132] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Parameters: [param0=[userid,104796], param1=[status,UNFINISHED]]

[Logging Date Time: 2016-10-18 15:19:33,132] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-10-18 15:19:33,132] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-10-18 15:20:26,791] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] PreparedStatement : [select pid,               (select ptbs.hngnm                  from pam.pmcmptbs ptbs                 where ptbs.pid = a.pid                       and ptbs.instcd = '111') as hngnm,               (select v.FORM_CD                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formcd,               (select v.FORM_NAME                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formnm,               (select v.PRINT_ONLY                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as printonly          from cmr.consent_mst a         where a.cosign_dc_id =  :param0                and a.consent_state in ( :param1 )]

[Logging Date Time: 2016-10-18 15:20:26,791] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] PreparedStatement : [select pid,               (select ptbs.hngnm                  from pam.pmcmptbs ptbs                 where ptbs.pid = a.pid                       and ptbs.instcd = '111') as hngnm,               (select v.FORM_CD                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formcd,               (select v.FORM_NAME                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formnm,               (select v.PRINT_ONLY                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as printonly          from cmr.consent_mst a         where a.cosign_dc_id =  :param0                and a.consent_state in ( :param1 )]

[Logging Date Time: 2016-10-18 15:20:26,792] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Parameters: [param0=[userid,104796], param1=[status,UNFINISHED]]

[Logging Date Time: 2016-10-18 15:20:26,792] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Parameters: [param0=[userid,104796], param1=[status,UNFINISHED]]

[Logging Date Time: 2016-10-18 15:20:26,792] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-10-18 15:20:26,792] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-10-18 15:20:26,931] =====================================================================================
SQL Command - CLIP.eForm error: orderdate

[Logging Date Time: 2016-10-18 15:27:55,934] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] PreparedStatement : [select pid,               (select ptbs.hngnm                  from pam.pmcmptbs ptbs                 where ptbs.pid = a.pid                       and ptbs.instcd = '111') as hngnm,               (select v.FORM_CD                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formcd,               (select v.FORM_NAME                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formnm,               (select v.PRINT_ONLY                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as printonly,               a.order_date as orderdate          from cmr.consent_mst a         where a.cosign_dc_id =  :param0                and a.consent_state in ( :param1 )]

[Logging Date Time: 2016-10-18 15:27:55,934] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] PreparedStatement : [select pid,               (select ptbs.hngnm                  from pam.pmcmptbs ptbs                 where ptbs.pid = a.pid                       and ptbs.instcd = '111') as hngnm,               (select v.FORM_CD                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formcd,               (select v.FORM_NAME                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formnm,               (select v.PRINT_ONLY                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as printonly,               a.order_date as orderdate          from cmr.consent_mst a         where a.cosign_dc_id =  :param0                and a.consent_state in ( :param1 )]

[Logging Date Time: 2016-10-18 15:27:55,990] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Parameters: [param0=[userid,104796], param1=[status,UNFINISEHD]]

[Logging Date Time: 2016-10-18 15:27:55,990] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Parameters: [param0=[userid,104796], param1=[status,UNFINISEHD]]

[Logging Date Time: 2016-10-18 15:27:55,990] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-10-18 15:27:55,990] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-10-18 15:28:29,554] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] PreparedStatement : [select pid,               (select ptbs.hngnm                  from pam.pmcmptbs ptbs                 where ptbs.pid = a.pid                       and ptbs.instcd = '111') as hngnm,               (select v.FORM_CD                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formcd,               (select v.FORM_NAME                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formnm,               (select v.PRINT_ONLY                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as printonly,               a.order_date as orderdate          from cmr.consent_mst a         where a.cosign_dc_id =  :param0                and a.consent_state in ( :param1 )]

[Logging Date Time: 2016-10-18 15:28:29,554] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] PreparedStatement : [select pid,               (select ptbs.hngnm                  from pam.pmcmptbs ptbs                 where ptbs.pid = a.pid                       and ptbs.instcd = '111') as hngnm,               (select v.FORM_CD                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formcd,               (select v.FORM_NAME                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formnm,               (select v.PRINT_ONLY                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as printonly,               a.order_date as orderdate          from cmr.consent_mst a         where a.cosign_dc_id =  :param0                and a.consent_state in ( :param1 )]

[Logging Date Time: 2016-10-18 15:28:29,555] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Parameters: [param0=[userid,104796], param1=[status,UNFINISHED]]

[Logging Date Time: 2016-10-18 15:28:29,555] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Parameters: [param0=[userid,104796], param1=[status,UNFINISHED]]

[Logging Date Time: 2016-10-18 15:28:29,555] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-10-18 15:28:29,555] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-10-18 17:42:31,261] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] PreparedStatement : [select pid,               (select ptbs.hngnm                  from pam.pmcmptbs ptbs                 where ptbs.pid = a.pid                       and ptbs.instcd = '111') as hngnm,               (select v.FORM_CD                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formcd,               (select v.FORM_NAME                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formnm,               (select v.PRINT_ONLY                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as printonly,               a.order_date as orderdate          from cmr.consent_mst a         where a.cosign_dc_id =  :param0                and a.consent_state in ( :param1 )]

[Logging Date Time: 2016-10-18 17:42:31,261] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] PreparedStatement : [select pid,               (select ptbs.hngnm                  from pam.pmcmptbs ptbs                 where ptbs.pid = a.pid                       and ptbs.instcd = '111') as hngnm,               (select v.FORM_CD                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formcd,               (select v.FORM_NAME                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formnm,               (select v.PRINT_ONLY                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as printonly,               a.order_date as orderdate          from cmr.consent_mst a         where a.cosign_dc_id =  :param0                and a.consent_state in ( :param1 )]

[Logging Date Time: 2016-10-18 17:42:31,428] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Parameters: [param0=[userid,104796], param1=[status,UNFINISHED]]

[Logging Date Time: 2016-10-18 17:42:31,428] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Parameters: [param0=[userid,104796], param1=[status,UNFINISHED]]

[Logging Date Time: 2016-10-18 17:42:31,429] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-10-18 17:42:31,429] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-10-18 17:42:41,103] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] PreparedStatement : [select pid,               (select ptbs.hngnm                  from pam.pmcmptbs ptbs                 where ptbs.pid = a.pid                       and ptbs.instcd = '111') as hngnm,               (select v.FORM_CD                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formcd,               (select v.FORM_NAME                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formnm,               (select v.PRINT_ONLY                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as printonly,               a.order_date as orderdate          from cmr.consent_mst a         where a.cosign_dc_id =  :param0                and a.consent_state in ( :param1 )]

[Logging Date Time: 2016-10-18 17:42:41,103] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] PreparedStatement : [select pid,               (select ptbs.hngnm                  from pam.pmcmptbs ptbs                 where ptbs.pid = a.pid                       and ptbs.instcd = '111') as hngnm,               (select v.FORM_CD                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formcd,               (select v.FORM_NAME                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as formnm,               (select v.PRINT_ONLY                  from cmr.v_eform_formdoc v                 where v.FORM_RID = a.form_rid) as printonly,               a.order_date as orderdate          from cmr.consent_mst a         where a.cosign_dc_id =  :param0                and a.consent_state in ( :param1 )]

[Logging Date Time: 2016-10-18 17:42:41,104] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Parameters: [param0=[userid,104796], param1=[status,UNFINISHED,TEMP]]

[Logging Date Time: 2016-10-18 17:42:41,104] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Parameters: [param0=[userid,104796], param1=[status,UNFINISHED,TEMP]]

[Logging Date Time: 2016-10-18 17:42:41,104] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String]]

[Logging Date Time: 2016-10-18 17:42:41,104] =====================================================================================
SQL Command - Statement Id: [GetUnfinishedListPerDoctor] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String]]