[8/19/2019 6:52:44 PM] : [VWWebViewClient][ShouldInterceptRequest] request : file:///data/user/0/com.ramco.droid.unify/app_null/Apps/8d31af33-f193-452f-8a8e-6aa4e178e7eb/DRIVER_TRIP_MOBILE/unify/driver_trip_mobile/view/Dashboard_dtl_act_ThudetailsView.js [8/19/2019 6:52:44 PM] : [VWWebViewClient][ShouldInterceptRequest] request : file:///data/user/0/com.ramco.droid.unify/app_null/Apps/8d31af33-f193-452f-8a8e-6aa4e178e7eb/DRIVER_TRIP_MOBILE/unify/resources/css/dashboard_dtl_act_thudetails.css [8/19/2019 6:52:44 PM] : [VWWebViewClient][ShouldInterceptRequest] request : file:///data/user/0/com.ramco.droid.unify/app_null/Apps/8d31af33-f193-452f-8a8e-6aa4e178e7eb/DRIVER_TRIP_MOBILE/unify/driver_trip_mobile/enterprise/dashboard_dtl_act_thudetails.xml?_dc=1566220964758 [8/19/2019 6:52:44 PM] : [VWWebViewClient][ShouldInterceptRequest] request : file:///data/user/0/com.ramco.droid.unify/app_null/Apps/8d31af33-f193-452f-8a8e-6aa4e178e7eb/DRIVER_TRIP_MOBILE/unify/driver_trip_mobile/state/dashboard_dtl_act_thudetails.xml?_dc=1566220964760 [8/19/2019 6:52:45 PM] : [VWWebViewClient][ShouldInterceptRequest] request : file:///data/user/0/com.ramco.droid.unify/app_null/Apps/8d31af33-f193-452f-8a8e-6aa4e178e7eb/DRIVER_TRIP_MOBILE/unify/driver_trip_mobile/templates/dashboard_dtl_act_thudetails.js?_dc=1566220965401 [8/19/2019 6:52:45 PM] : [VWWebViewClient][ShouldInterceptRequest] request : file:///data/user/0/com.ramco.droid.unify/app_null/Apps/8d31af33-f193-452f-8a8e-6aa4e178e7eb/DRIVER_TRIP_MOBILE/unify/resources/fonts/Roboto.ttf [8/19/2019 6:52:45 PM] : [LDSE.GetQueryListAsync(DBQJ)]New Transaction Started: dtmmaireeinit [8/19/2019 6:52:45 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=select ddh_dispatch_doc_no 'consignment_note' from tms_ddh_dispatch_document_signature nolock where ddh_ouinstance = @ctxt_ou and ddh_seqno = '1' and ddh_Trip_id = 'TRPL/0016795/1617'; [8/19/2019 6:52:45 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=INSERT INTO delete_val_temp(trans_type,val_value) select 'CN', ddh_dispatch_doc_no from tms_ddh_dispatch_document_signature nolock where ddh_ouinstance = @ctxt_ou and ddh_seqno = '1' and ddh_Trip_id = 'TRPL/0016795/1617' LIMIT 1; [8/19/2019 6:52:45 PM] : [LDSE.UpdateRequestToDb] ExecutingQuery=INSERT INTO delete_val_temp(trans_type,val_value) select 'CN', ddh_dispatch_doc_no from tms_ddh_dispatch_document_signature nolock where ddh_ouinstance = @ctxt_ou and ddh_seqno = @sequence_no and ddh_Trip_id = @trip_id LIMIT 1; [8/19/2019 6:52:45 PM] : [LDSE.UpdateRequestToDb] Resulting RowCount: 1 [8/19/2019 6:52:45 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=select tdttd_THU_id 'thu_id' from tms_tdttd_driver_trip_thu_dtl nolock where tdttd_ouinstance = @ctxt_ou and tdttd_Trip_id = 'TRPL/0016795/1617' and tdttd_seq_no = '1' and tdttd_dispatch_no = coalesce((select ddh_dispatch_doc_no from tms_ddh_dispatch_document_signature nolock where ddh_ouinstance = @ctxt_ou and ddh_seqno = '1' and ddh_Trip_id = 'TRPL/0016795/1617' and ifnull('','')='' limit 1),''); [8/19/2019 6:52:45 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=INSERT INTO delete_val_temp(trans_type,val_value) select 'THU', tdttd_THU_id from tms_tdttd_driver_trip_thu_dtl nolock where tdttd_ouinstance = @ctxt_ou and tdttd_Trip_id = 'TRPL/0016795/1617' and tdttd_seq_no = '1' and tdttd_dispatch_no =(select ddh_dispatch_doc_no from tms_ddh_dispatch_document_signature nolock where ddh_ouinstance = @ctxt_ou and ddh_seqno = '1' and ddh_Trip_id = 'TRPL/0016795/1617' limit 1) LIMIT 1; [8/19/2019 6:52:45 PM] : [LDSE.UpdateRequestToDb] ExecutingQuery=INSERT INTO delete_val_temp(trans_type,val_value) select 'THU', tdttd_THU_id from tms_tdttd_driver_trip_thu_dtl nolock where tdttd_ouinstance = @ctxt_ou and tdttd_Trip_id = @trip_id and tdttd_seq_no = @sequence_no and tdttd_dispatch_no =(select ddh_dispatch_doc_no from tms_ddh_dispatch_document_signature nolock where ddh_ouinstance = @ctxt_ou and ddh_seqno = @sequence_no and ddh_Trip_id = @trip_id limit 1) LIMIT 1; [8/19/2019 6:52:45 PM] : [LDSE.UpdateRequestToDb] Resulting RowCount: 1 [8/19/2019 6:52:45 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=select '' 'class_of_stores', '' 'class_of_stores_hdn' union select tms_code_desc 'class_of_stores', tms_code 'class_of_stores_hdn' from tms_quick_code_master_met nolock where tms_ouinstance = @ctxt_ou and tms_code_type = 'CLSOFSTR'; [8/19/2019 6:52:45 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=select '' 'thudetailsuom_hdn', '' 'uom' union select ttum_code 'thudetailsuom_hdn', ttum_desc 'uom' from tms_thu_uom_mas nolock where ttum_ouinstance = @ctxt_ou; [8/19/2019 6:52:45 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=select NULL 'vendor_thu_id' union select tms_thu_vendor_thu 'vendor_thu_id' from tms_thu_vendor_dtl nolock inner join tms_tdttd_driver_trip_thu_dtl nolock on tms_thu_id = tdttd_THU_id inner join tms_quick_code_master_met nolock on tms_thu_trantype = tms_code inner join tms_tdtbd_driver_trip_br_dtl nolock on tdttd_ouinstance = tdtbd_ouinstance and tdttd_Trip_id = tdtbd_Trip_id and tdttd_seq_no = tdtbd_seqno and lower(tms_vendor_thu_ship_point_id) = lower(tdtbd_ship_point_id) and lower(tdtbd_leg_beh) = lower(tms_leg_beh) where tdttd_ouinstance = @ctxt_ou and tdttd_Trip_id = 'TRPL/0016795/1617' and tdttd_seq_no = '1' and tdttd_THU_id = coalesce((SELECT val_value FROM delete_val_temp NOLOCK WHERE trans_type='THU' and coalesce('','')=''),'') and tdttd_dispatch_no = coalesce((SELECT val_value FROM delete_val_temp NOLOCK WHERE trans_type='CN' and coalesce('','')=''),'') and tms_code_type ='TRNTYP'; [8/19/2019 6:52:45 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=INSERT INTO delete_val_temp(trans_type,val_value) select 'VEND' , tms_thu_vendor_thu from tms_thu_vendor_dtl nolock inner join tms_tdttd_driver_trip_thu_dtl nolock on tms_thu_id = tdttd_THU_id inner join tms_quick_code_master_met nolock on tms_thu_trantype = tms_code inner join tms_tdtbd_driver_trip_br_dtl nolock on tdttd_ouinstance = tdtbd_ouinstance and tdttd_Trip_id = tdtbd_Trip_id and tdttd_seq_no = tdtbd_seqno and lower(tms_vendor_thu_ship_point_id) = lower(tdtbd_ship_point_id) and lower(tdtbd_leg_beh) = lower(tms_leg_beh) where tdttd_ouinstance = @ctxt_ou and tdttd_Trip_id = 'TRPL/0016795/1617' and tdttd_seq_no = '1' and tdttd_THU_id = (SELECT val_value FROM delete_val_temp NOLOCK WHERE trans_type='THU') and tdttd_dispatch_no = (SELECT val_value FROM delete_val_temp NOLOCK WHERE trans_type='CN') and tms_code_type ='TRNTYP' limit 1; [8/19/2019 6:52:45 PM] : [LDSE.UpdateRequestToDb] ExecutingQuery=INSERT INTO delete_val_temp(trans_type,val_value) select 'VEND' , tms_thu_vendor_thu from tms_thu_vendor_dtl nolock inner join tms_tdttd_driver_trip_thu_dtl nolock on tms_thu_id = tdttd_THU_id inner join tms_quick_code_master_met nolock on tms_thu_trantype = tms_code inner join tms_tdtbd_driver_trip_br_dtl nolock on tdttd_ouinstance = tdtbd_ouinstance and tdttd_Trip_id = tdtbd_Trip_id and tdttd_seq_no = tdtbd_seqno and lower(tms_vendor_thu_ship_point_id) = lower(tdtbd_ship_point_id) and lower(tdtbd_leg_beh) = lower(tms_leg_beh) where tdttd_ouinstance = @ctxt_ou and tdttd_Trip_id = @trip_id and tdttd_seq_no = @sequence_no and tdttd_THU_id = (SELECT val_value FROM delete_val_temp NOLOCK WHERE trans_type='THU') and tdttd_dispatch_no = (SELECT val_value FROM delete_val_temp NOLOCK WHERE trans_type='CN') and tms_code_type ='TRNTYP' limit 1; [8/19/2019 6:52:45 PM] : [LDSE.UpdateRequestToDb] Resulting RowCount: 0 [8/19/2019 6:52:45 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=select '' 'thudetailstransfertype_hdn', '' 'transfer_type' union select tms_code 'thudetailstransfertype_hdn',tms_code_desc 'transfer_type' from tms_quick_code_master_met inner join tms_tdtbd_driver_trip_br_dtl on lower(tms_leg_beh) = lower(tdtbd_leg_beh) inner join tms_tdttd_driver_trip_thu_dtl on tdttd_ouinstance = tdtbd_ouinstance and tdttd_Trip_id = tdtbd_Trip_id and tdttd_seq_no = tdtbd_seqno inner join tms_thu_vendor_dtl nolock on tdttd_THU_id = tms_thu_id and lower(tms_vendor_thu_ship_point_id) = lower(tdtbd_ship_point_id) and tms_thu_trantype = tms_code where tdttd_ouinstance = @ctxt_ou and tdttd_Trip_id = 'TRPL/0016795/1617' and tdttd_seq_no = '1' and tdttd_THU_id = coalesce((SELECT val_value FROM delete_val_temp NOLOCK WHERE trans_type='THU' and coalesce('','')=''),'') and tdttd_dispatch_no = coalesce((SELECT val_value FROM delete_val_temp NOLOCK WHERE trans_type='CN' and coalesce('','')=''),'') and tms_thu_vendor_thu = coalesce((SELECT val_value FROM delete_val_temp NOLOCK WHERE trans_type='VEND' and coalesce('','')=''), '') and tms_code_type ='TRNTYP'; [8/19/2019 6:52:45 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=select '' 'consignment_damaged' union select tms_code 'consignment_damaged' from tms_quick_code_master_met nolock where tms_ouinstance = @ctxt_ou and tms_code_type = 'RSNCD' and tms_category = 'DAMAGED'; [8/19/2019 6:52:45 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=select '' 'picked_diff_planned' union select tms_code 'picked_diff_planned' from tms_quick_code_master_met nolock where tms_ouinstance = @ctxt_ou and tms_code_type = 'RSNCD' and tms_category = 'ACTUAL'; [8/19/2019 6:52:45 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=select '' 'consignment_returned' union select tms_code 'consignment_returned' from tms_quick_code_master_met nolock where tms_ouinstance = @ctxt_ou and tms_code_type = 'RSNCD' and tms_category = 'RETURN'; [8/19/2019 6:52:45 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=DELETE FROM delete_val_temp [8/19/2019 6:52:45 PM] : [LDSE.UpdateRequestToDb] ExecutingQuery=DELETE FROM delete_val_temp [8/19/2019 6:52:45 PM] : [LDSE.UpdateRequestToDb] Resulting RowCount: 2 [8/19/2019 6:52:45 PM] : [LDSE.GetQueryListAsync(DBQJ)] SB = {"cmbconsignment_note":[{"cmbconsignment_note":"CNN72"}],"cmbthu_id":[{"cmbthu_id":"BOX"}],"cmbclass_of_stores":[{"cmbclass_of_stores":"","hclass_of_stores_hdn":""},{"cmbclass_of_stores":"Chemicals","hclass_of_stores_hdn":"016"},{"cmbclass_of_stores":"Class of stores","hclass_of_stores_hdn":"COS"},{"cmbclass_of_stores":"Electronics","hclass_of_stores_hdn":"007"},{"cmbclass_of_stores":"GENERAL","hclass_of_stores_hdn":"GENERAL"},{"cmbclass_of_stores":"Hazardous","hclass_of_stores_hdn":"Hazard"},{"cmbclass_of_stores":"test","hclass_of_stores_hdn":"cls1"}],"cmbuom":[{"hthudetailsuom_hdn":"","cmbuom":""},{"hthudetailsuom_hdn":"BLS1","cmbuom":"BLS"},{"hthudetailsuom_hdn":"CM","cmbuom":"CENTI METER"},{"hthudetailsuom_hdn":"CMS","cmbuom":"CENTIMETER"},{"hthudetailsuom_hdn":"FTS","cmbuom":"FEET"},{"hthudetailsuom_hdn":"GRAM","cmbuom":"GRAMS"},{"hthudetailsuom_hdn":"GYD","cmbuom":"GROSS YARDS"},{"hthudetailsuom_hdn":"KILOS","cmbuom":"Kilograms"},{"hthudetailsuom_hdn":"KME","cmbuom":"KILOMETERS"},{"hthudetailsuom_hdn":"M","cmbuom":"METRE"},{"hthudetailsuom_hdn":"M2","cmbuom":"Square Meter"},{"hthudetailsuom_hdn":"MLS","cmbuom":"Miles"},{"hthudetailsuom_hdn":"MLT","cmbuom":"MILLILITER"},{"hthudetailsuom_hdn":"MN","cmbuom":"MICRON"},{"hthudetailsuom_hdn":"MTR","cmbuom":"METER"},{"hthudetailsuom_hdn":"PIECE_2","cmbuom":"piece_2"},{"hthudetailsuom_hdn":"SQF","cmbuom":"SQUARE FEET"},{"hthudetailsuom_hdn":"SQFT","cmbuom":"Square Feet"},{"hthudetailsuom_hdn":"SQM","cmbuom":"SQUARE METER"},{"hthudetailsuom_hdn":"SQY","cmbuom":"SQUARE YARDS"},{"hthudetailsuom_hdn":"WT5","cmbuom":"nos"},{"hthudetailsuom_hdn":"YDS","cmbuom":"YARDS"},{"hthudetailsuom_hdn":"µ","cmbuom":"mu"}],"cmbvendor_thu_id":[{"cmbvendor_thu_id":""}],"cmbtransfer_type":[{"hthudetailstransfertype_hdn":"","cmbtransfer_type":""}],"cmbconsignment_damaged":[{"cmbconsignment_damaged":""},{"cmbconsignment_damaged":"123"},{"cmbconsignment_damaged":"222"},{"cmbconsignment_damaged":"66"},{"cmbconsignment_damaged":"78"},{"cmbconsignment_damaged":"DAMAGED"},{"cmbconsignment_damaged":"Futile"},{"cmbconsignment_damaged":"Leave"},{"cmbconsignment_damaged":"MAXVALUEUTMAXVALUEUTMAXVALUEUTMAXVALUEUT"},{"cmbconsignment_damaged":"New Unified Asset"},{"cmbconsignment_damaged":"QC"},{"cmbconsignment_damaged":"rac"},{"cmbconsignment_damaged":"RC1"},{"cmbconsignment_damaged":"rc2"},{"cmbconsignment_damaged":"RC3"},{"cmbconsignment_damaged":"RC4"},{"cmbconsignment_damaged":"RC5"},{"cmbconsignment_damaged":"RC6"},{"cmbconsignment_damaged":"RC7"},{"cmbconsignment_damaged":"Re-Delivery"},{"cmbconsignment_damaged":"WE"}],"cmbpicked_diff_planned":[{"cmbpicked_diff_planned":""},{"cmbpicked_diff_planned":"123"},{"cmbpicked_diff_planned":"222"},{"cmbpicked_diff_planned":"66"},{"cmbpicked_diff_planned":"78"},{"cmbpicked_diff_planned":"DAMAGED"},{"cmbpicked_diff_planned":"Futile"},{"cmbpicked_diff_planned":"Leave"},{"cmbpicked_diff_planned":"MAXVALUEUTMAXVALUEUTMAXVALUEUTMAXVALUEUT"},{"cmbpicked_diff_planned":"New Unified Asset"},{"cmbpicked_diff_planned":"QC"},{"cmbpicked_diff_planned":"rac"},{"cmbpicked_diff_planned":"RC1"},{"cmbpicked_diff_planned":"rc2"},{"cmbpicked_diff_planned":"RC3"},{"cmbpicked_diff_planned":"RC4"},{"cmbpicked_diff_planned":"RC5"},{"cmbpicked_diff_planned":"RC6"},{"cmbpicked_diff_planned":"RC7"},{"cmbpicked_diff_planned":"Re-Delivery"},{"cmbpicked_diff_planned":"WE"}],"cmbconsignment_returned":[{"cmbconsignment_returned":""},{"cmbconsignment_returned":"123"},{"cmbconsignment_returned":"222"},{"cmbconsignment_returned":"66"},{"cmbconsignment_returned":"78"},{"cmbconsignment_returned":"DAMAGED"},{"cmbconsignment_returned":"Futile"},{"cmbconsignment_returned":"Leave"},{"cmbconsignment_returned":"MAXVALUEUTMAXVALUEUTMAXVALUEUTMAXVALUEUT"},{"cmbconsignment_returned":"New Unified Asset"},{"cmbconsignment_returned":"QC"},{"cmbconsignment_returned":"rac"},{"cmbconsignment_returned":"RC1"},{"cmbconsignment_returned":"rc2"},{"cmbconsignment_returned":"RC3"},{"cmbconsignment_returned":"RC4"},{"cmbconsignment_returned":"RC5"},{"cmbconsignment_returned":"RC6"},{"cmbconsignment_returned":"RC7"},{"cmbconsignment_returned":"Re-Delivery"},{"cmbconsignment_returned":"WE"}],"status":"service_success"} [8/19/2019 6:52:45 PM] : [LDSE.GetQueryListAsync(DBQJ)] Transaction Succesfully Committed: dtmmaireeinit [8/19/2019 6:52:45 PM] : [AutoSyncHelper.TrySync] Confirm Taskdtmmaireeinit Is Not Terminal Action [8/19/2019 6:52:45 PM] : { "hdr": { "bgsec": "", "cbid": "351812087", "sts": 1 }, "data": "{\n \"cmbconsignment_note\": [\n {\n \"cmbconsignment_note\": \"CNN72\"\n }\n ],\n \"cmbthu_id\": [\n {\n \"cmbthu_id\": \"BOX\"\n }\n ],\n \"cmbclass_of_stores\": [\n {\n \"cmbclass_of_stores\": \"\",\n \"hclass_of_stores_hdn\": \"\"\n },\n {\n \"cmbclass_of_stores\": \"Chemicals\",\n \"hclass_of_stores_hdn\": \"016\"\n },\n {\n \"cmbclass_of_stores\": \"Class of stores\",\n \"hclass_of_stores_hdn\": \"COS\"\n },\n {\n \"cmbclass_of_stores\": \"Electronics\",\n \"hclass_of_stores_hdn\": \"007\"\n },\n {\n \"cmbclass_of_stores\": \"GENERAL\",\n \"hclass_of_stores_hdn\": \"GENERAL\"\n },\n {\n \"cmbclass_of_stores\": \"Hazardous\",\n \"hclass_of_stores_hdn\": \"Hazard\"\n },\n {\n \"cmbclass_of_stores\": \"test\",\n \"hclass_of_stores_hdn\": \"cls1\"\n }\n ],\n \"cmbuom\": [\n {\n \"hthudetailsuom_hdn\": \"\",\n \"cmbuom\": \"\"\n },\n {\n \"hthudetailsuom_hdn\": \"BLS1\",\n \"cmbuom\": \"BLS\"\n },\n {\n \"hthudetailsuom_hdn\": \"CM\",\n \"cmbuom\": \"CENTI METER\"\n },\n {\n \"hthudetailsuom_hdn\": \"CMS\",\n \"cmbuom\": \"CENTIMETER\"\n },\n {\n \"hthudetailsuom_hdn\": \"FTS\",\n \"cmbuom\": \"FEET\"\n },\n {\n \"hthudetailsuom_hdn\": \"GRAM\",\n \"cmbuom\": \"GRAMS\"\n },\n {\n \"hthudetailsuom_hdn\": \"GYD\",\n \"cmbuom\": \"GROSS YARDS\"\n },\n {\n \"hthudetailsuom_hdn\": \"KILOS\",\n \"cmbuom\": \"Kilograms\"\n },\n {\n \"hthudetailsuom_hdn\": \"KME\",\n \"cmbuom\": \"KILOMETERS\"\n },\n {\n \"hthudetailsuom_hdn\": \"M\",\n \"cmbuom\": \"METRE\"\n },\n {\n \"hthudetailsuom_hdn\": \"M2\",\n \"cmbuom\": \"Square Meter\"\n },\n {\n \"hthudetailsuom_hdn\": \"MLS\",\n \"cmbuom\": \"Miles\"\n },\n {\n \"hthudetailsuom_hdn\": \"MLT\",\n \"cmbuom\": \"MILLILITER\"\n },\n {\n \"hthudetailsuom_hdn\": \"MN\",\n \"cmbuom\": \"MICRON\"\n },\n {\n \"hthudetailsuom_hdn\": \"MTR\",\n \"cmbuom\": \"METER\"\n },\n {\n \"hthudetailsuom_hdn\": \"PIECE_2\",\n \"cmbuom\": \"piece_2\"\n },\n {\n \"hthudetailsuom_hdn\": \"SQF\",\n \"cmbuom\": \"SQUARE FEET\"\n },\n {\n \"hthudetailsuom_hdn\": \"SQFT\",\n \"cmbuom\": \"Square Feet\"\n },\n {\n \"hthudetailsuom_hdn\": \"SQM\",\n \"cmbuom\": \"SQUARE METER\"\n },\n {\n \"hthudetailsuom_hdn\": \"SQY\",\n \"cmbuom\": \"SQUARE YARDS\"\n },\n {\n \"hthudetailsuom_hdn\": \"WT5\",\n \"cmbuom\": \"nos\"\n },\n {\n \"hthudetailsuom_hdn\": \"YDS\",\n \"cmbuom\": \"YARDS\"\n },\n {\n \"hthudetailsuom_hdn\": \"µ\",\n \"cmbuom\": \"mu\"\n }\n ],\n \"cmbvendor_thu_id\": [\n {\n \"cmbvendor_thu_id\": \"\"\n }\n ],\n \"cmbtransfer_type\": [\n {\n \"hthudetailstransfertype_hdn\": \"\",\n \"cmbtransfer_type\": \"\"\n }\n ],\n \"cmbconsignment_damaged\": [\n {\n \"cmbconsignment_damaged\": \"\"\n },\n {\n \"cmbconsignment_damaged\": \"123\"\n },\n {\n \"cmbconsignment_damaged\": \"222\"\n },\n {\n \"cmbconsignment_damaged\": \"66\"\n },\n {\n \"cmbconsignment_damaged\": \"78\"\n },\n {\n \"cmbconsignment_damaged\": \"DAMAGED\"\n },\n {\n \"cmbconsignment_damaged\": \"Futile\"\n },\n {\n \"cmbconsignment_damaged\": \"Leave\"\n },\n {\n \"cmbconsignment_damaged\": \"MAXVALUEUTMAXVALUEUTMAXVALUEUTMAXVALUEUT\"\n },\n {\n \"cmbconsignment_damaged\": \"New Unified Asset\"\n },\n {\n \"cmbconsignment_damaged\": \"QC\"\n },\n {\n \"cmbconsignment_damaged\": \"rac\"\n },\n {\n \"cmbconsignment_damaged\": \"RC1\"\n },\n {\n \"cmbconsignment_damaged\": \"rc2\"\n },\n {\n \"cmbconsignment_damaged\": \"RC3\"\n },\n {\n \"cmbconsignment_damaged\": \"RC4\"\n },\n {\n \"cmbconsignment_damaged\": \"RC5\"\n },\n {\n \"cmbconsignment_damaged\": \"RC6\"\n },\n {\n \"cmbconsignment_damaged\": \"RC7\"\n },\n {\n \"cmbconsignment_damaged\": \"Re-Delivery\"\n },\n {\n \"cmbconsignment_damaged\": \"WE\"\n }\n ],\n \"cmbpicked_diff_planned\": [\n {\n \"cmbpicked_diff_planned\": \"\"\n },\n {\n \"cmbpicked_diff_planned\": \"123\"\n },\n {\n \"cmbpicked_diff_planned\": \"222\"\n },\n {\n \"cmbpicked_diff_planned\": \"66\"\n },\n {\n \"cmbpicked_diff_planned\": \"78\"\n },\n {\n \"cmbpicked_diff_planned\": \"DAMAGED\"\n },\n {\n \"cmbpicked_diff_planned\": \"Futile\"\n },\n {\n \"cmbpicked_diff_planned\": \"Leave\"\n },\n {\n \"cmbpicked_diff_planned\": \"MAXVALUEUTMAXVALUEUTMAXVALUEUTMAXVALUEUT\"\n },\n {\n \"cmbpicked_diff_planned\": \"New Unified Asset\"\n },\n {\n \"cmbpicked_diff_planned\": \"QC\"\n },\n {\n \"cmbpicked_diff_planned\": \"rac\"\n },\n {\n \"cmbpicked_diff_planned\": \"RC1\"\n },\n {\n \"cmbpicked_diff_planned\": \"rc2\"\n },\n {\n \"cmbpicked_diff_planned\": \"RC3\"\n },\n {\n \"cmbpicked_diff_planned\": \"RC4\"\n },\n {\n \"cmbpicked_diff_planned\": \"RC5\"\n },\n {\n \"cmbpicked_diff_planned\": \"RC6\"\n },\n {\n \"cmbpicked_diff_planned\": \"RC7\"\n },\n {\n \"cmbpicked_diff_planned\": \"Re-Delivery\"\n },\n {\n \"cmbpicked_diff_planned\": \"WE\"\n }\n ],\n \"cmbconsignment_returned\": [\n {\n \"cmbconsignment_returned\": \"\"\n },\n {\n \"cmbconsignment_returned\": \"123\"\n },\n {\n \"cmbconsignment_returned\": \"222\"\n },\n {\n \"cmbconsignment_returned\": \"66\"\n },\n {\n \"cmbconsignment_returned\": \"78\"\n },\n {\n \"cmbconsignment_returned\": \"DAMAGED\"\n },\n {\n \"cmbconsignment_returned\": \"Futile\"\n },\n {\n \"cmbconsignment_returned\": \"Leave\"\n },\n {\n \"cmbconsignment_returned\": \"MAXVALUEUTMAXVALUEUTMAXVALUEUTMAXVALUEUT\"\n },\n {\n \"cmbconsignment_returned\": \"New Unified Asset\"\n },\n {\n \"cmbconsignment_returned\": \"QC\"\n },\n {\n \"cmbconsignment_returned\": \"rac\"\n },\n {\n \"cmbconsignment_returned\": \"RC1\"\n },\n {\n \"cmbconsignment_returned\": \"rc2\"\n },\n {\n \"cmbconsignment_returned\": \"RC3\"\n },\n {\n \"cmbconsignment_returned\": \"RC4\"\n },\n {\n \"cmbconsignment_returned\": \"RC5\"\n },\n {\n \"cmbconsignment_returned\": \"RC6\"\n },\n {\n \"cmbconsignment_returned\": \"RC7\"\n },\n {\n \"cmbconsignment_returned\": \"Re-Delivery\"\n },\n {\n \"cmbconsignment_returned\": \"WE\"\n }\n ],\n \"status\": \"service_success\"\n}" } [8/19/2019 6:52:45 PM] : Failed to locate callbackHandler for id : 351812087 [8/19/2019 6:52:45 PM] : anywhere.callbackFromNative({ "hdr": { "bgsec": "", "cbid": "351812087", "sts": 1 }, "data": "{\n \"cmbconsignment_note\": [\n {\n \"cmbconsignment_note\": \"CNN72\"\n }\n ],\n \"cmbthu_id\": [\n {\n \"cmbthu_id\": \"BOX\"\n }\n ],\n \"cmbclass_of_stores\": [\n {\n \"cmbclass_of_stores\": \"\",\n \"hclass_of_stores_hdn\": \"\"\n },\n {\n \"cmbclass_of_stores\": \"Chemicals\",\n \"hclass_of_stores_hdn\": \"016\"\n },\n {\n \"cmbclass_of_stores\": \"Class of stores\",\n \"hclass_of_stores_hdn\": \"COS\"\n },\n {\n \"cmbclass_of_stores\": \"Electronics\",\n \"hclass_of_stores_hdn\": \"007\"\n },\n {\n \"cmbclass_of_stores\": \"GENERAL\",\n \"hclass_of_stores_hdn\": \"GENERAL\"\n },\n {\n \"cmbclass_of_stores\": \"Hazardous\",\n \"hclass_of_stores_hdn\": \"Hazard\"\n },\n {\n \"cmbclass_of_stores\": \"test\",\n \"hclass_of_stores_hdn\": \"cls1\"\n }\n ],\n \"cmbuom\": [\n {\n \"hthudetailsuom_hdn\": \"\",\n \"cmbuom\": \"\"\n },\n {\n \"hthudetailsuom_hdn\": \"BLS1\",\n \"cmbuom\": \"BLS\"\n },\n {\n \"hthudetailsuom_hdn\": \"CM\",\n \"cmbuom\": \"CENTI METER\"\n },\n {\n \"hthudetailsuom_hdn\": \"CMS\",\n \"cmbuom\": \"CENTIMETER\"\n },\n {\n \"hthudetailsuom_hdn\": \"FTS\",\n \"cmbuom\": \"FEET\"\n },\n {\n \"hthudetailsuom_hdn\": \"GRAM\",\n \"cmbuom\": \"GRAMS\"\n },\n {\n \"hthudetailsuom_hdn\": \"GYD\",\n \"cmbuom\": \"GROSS YARDS\"\n },\n {\n \"hthudetailsuom_hdn\": \"KILOS\",\n \"cmbuom\": \"Kilograms\"\n },\n {\n \"hthudetailsuom_hdn\": \"KME\",\n \"cmbuom\": \"KILOMETERS\"\n },\n {\n \"hthudetailsuom_hdn\": \"M\",\n \"cmbuom\": \"METRE\"\n },\n {\n \"hthudetailsuom_hdn\": \"M2\",\n \"cmbuom\": \"Square Meter\"\n },\n {\n \"hthudetailsuom_hdn\": \"MLS\",\n \"cmbuom\": \"Miles\"\n },\n {\n \"hthudetailsuom_hdn\": \"MLT\",\n \"cmbuom\": \"MILLILITER\"\n },\n {\n \"hthudetailsuom_hdn\": \"MN\",\n \"cmbuom\": \"MICRON\"\n },\n {\n \"hthudetailsuom_hdn\": \"MTR\",\n \"cmbuom\": \"METER\"\n },\n {\n \"hthudetailsuom_hdn\": \"PIECE_2\",\n \"cmbuom\": \"piece_2\"\n },\n {\n \"hthudetailsuom_hdn\": \"SQF\",\n \"cmbuom\": \"SQUARE FEET\"\n },\n {\n \"hthudetailsuom_hdn\": \"SQFT\",\n \"cmbuom\": \"Square Feet\"\n },\n {\n \"hthudetailsuom_hdn\": \"SQM\",\n \"cmbuom\": \"SQUARE METER\"\n },\n {\n \"hthudetailsuom_hdn\": \"SQY\",\n \"cmbuom\": \"SQUARE YARDS\"\n },\n {\n \"hthudetailsuom_hdn\": \"WT5\",\n \"cmbuom\": \"nos\"\n },\n {\n \"hthudetailsuom_hdn\": \"YDS\",\n \"cmbuom\": \"YARDS\"\n },\n {\n \"hthudetailsuom_hdn\": \"µ\",\n \"cmbuom\": \"mu\"\n }\n ],\n \"cmbvendor_thu_id\": [\n {\n \"cmbvendor_thu_id\": \"\"\n }\n ],\n \"cmbtransfer_type\": [\n {\n \"hthudetailstransfertype_hdn\": \"\",\n \"cmbtransfer_type\": \"\"\n }\n ],\n \"cmbconsignment_damaged\": [\n {\n \"cmbconsignment_damaged\": \"\"\n },\n {\n \"cmbconsignment_damaged\": \"123\"\n },\n {\n \"cmbconsignment_damaged\": \"222\"\n },\n {\n \"cmbconsignment_damaged\": \"66\"\n },\n {\n \"cmbconsignment_damaged\": \"78\"\n },\n {\n \"cmbconsignment_damaged\": \"DAMAGED\"\n },\n {\n \"cmbconsignment_damaged\": \"Futile\"\n },\n {\n \"cmbconsignment_damaged\": \"Leave\"\n },\n {\n \"cmbconsignment_damaged\": \"MAXVALUEUTMAXVALUEUTMAXVALUEUTMAXVALUEUT\"\n },\n {\n \"cmbconsignment_damaged\": \"New Unified Asset\"\n },\n {\n \"cmbconsignment_damaged\": \"QC\"\n },\n {\n \"cmbconsignment_damaged\": \"rac\"\n },\n {\n \"cmbconsignment_damaged\": \"RC1\"\n },\n {\n \"cmbconsignment_damaged\": \"rc2\"\n },\n {\n \"cmbconsignment_damaged\": \"RC3\"\n },\n {\n \"cmbconsignment_damaged\": \"RC4\"\n },\n {\n \"cmbconsignment_damaged\": \"RC5\"\n },\n {\n \"cmbconsignment_damaged\": \"RC6\"\n },\n {\n \"cmbconsignment_damaged\": \"RC7\"\n },\n {\n \"cmbconsignment_damaged\": \"Re-Delivery\"\n },\n {\n \"cmbconsignment_damaged\": \"WE\"\n }\n ],\n \"cmbpicked_diff_planned\": [\n {\n \"cmbpicked_diff_planned\": \"\"\n },\n {\n \"cmbpicked_diff_planned\": \"123\"\n },\n {\n \"cmbpicked_diff_planned\": \"222\"\n },\n {\n \"cmbpicked_diff_planned\": \"66\"\n },\n {\n \"cmbpicked_diff_planned\": \"78\"\n },\n {\n \"cmbpicked_diff_planned\": \"DAMAGED\"\n },\n {\n \"cmbpicked_diff_planned\": \"Futile\"\n },\n {\n \"cmbpicked_diff_planned\": \"Leave\"\n },\n {\n \"cmbpicked_diff_planned\": \"MAXVALUEUTMAXVALUEUTMAXVALUEUTMAXVALUEUT\"\n },\n {\n \"cmbpicked_diff_planned\": \"New Unified Asset\"\n },\n {\n \"cmbpicked_diff_planned\": \"QC\"\n },\n {\n \"cmbpicked_diff_planned\": \"rac\"\n },\n {\n \"cmbpicked_diff_planned\": \"RC1\"\n },\n {\n \"cmbpicked_diff_planned\": \"rc2\"\n },\n {\n \"cmbpicked_diff_planned\": \"RC3\"\n },\n {\n \"cmbpicked_diff_planned\": \"RC4\"\n },\n {\n \"cmbpicked_diff_planned\": \"RC5\"\n },\n {\n \"cmbpicked_diff_planned\": \"RC6\"\n },\n {\n \"cmbpicked_diff_planned\": \"RC7\"\n },\n {\n \"cmbpicked_diff_planned\": \"Re-Delivery\"\n },\n {\n \"cmbpicked_diff_planned\": \"WE\"\n }\n ],\n \"cmbconsignment_returned\": [\n {\n \"cmbconsignment_returned\": \"\"\n },\n {\n \"cmbconsignment_returned\": \"123\"\n },\n {\n \"cmbconsignment_returned\": \"222\"\n },\n {\n \"cmbconsignment_returned\": \"66\"\n },\n {\n \"cmbconsignment_returned\": \"78\"\n },\n {\n \"cmbconsignment_returned\": \"DAMAGED\"\n },\n {\n \"cmbconsignment_returned\": \"Futile\"\n },\n {\n \"cmbconsignment_returned\": \"Leave\"\n },\n {\n \"cmbconsignment_returned\": \"MAXVALUEUTMAXVALUEUTMAXVALUEUTMAXVALUEUT\"\n },\n {\n \"cmbconsignment_returned\": \"New Unified Asset\"\n },\n {\n \"cmbconsignment_returned\": \"QC\"\n },\n {\n \"cmbconsignment_returned\": \"rac\"\n },\n {\n \"cmbconsignment_returned\": \"RC1\"\n },\n {\n \"cmbconsignment_returned\": \"rc2\"\n },\n {\n \"cmbconsignment_returned\": \"RC3\"\n },\n {\n \"cmbconsignment_returned\": \"RC4\"\n },\n {\n \"cmbconsignment_returned\": \"RC5\"\n },\n {\n \"cmbconsignment_returned\": \"RC6\"\n },\n {\n \"cmbconsignment_returned\": \"RC7\"\n },\n {\n \"cmbconsignment_returned\": \"Re-Delivery\"\n },\n {\n \"cmbconsignment_returned\": \"WE\"\n }\n ],\n \"status\": \"service_success\"\n}" }); [8/19/2019 6:52:45 PM] : [LDSE.GetQueryListAsync(DBQJ)]New Transaction Started: dtmmaireefth [8/19/2019 6:52:45 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=with cte_pud as (select 'Y' 'pud_cond', tdtbd_Trip_id 'trip' from tms_tdtbd_driver_trip_br_dtl nolock join tms_ddh_dispatch_document_signature nolock on ddh_ouinstance = tdtbd_ouinstance and ddh_Trip_id = tdtbd_Trip_id and ddh_seqno = tdtbd_seqno where tdtbd_ouinstance = @ctxt_ou and tdtbd_Trip_id = 'TRPL/0016795/1617' and tdtbd_exec_leg_id = 'pud' and tdtbd_seqno < '1' and coalesce(ddh_signature_status,'N') = 'N' ) select case when coalesce(pud_cond,'N')='Y' or ( tdtbd_leg_beh='bhub' and coalesce(tdtbd_Handed_over_date,'')<>'') then 'ac_sts_dlvry' when coalesce(ddh_signature_status,'N') = 'Y' then case when tdtbd_leg_beh in ('Pick','VedrI') then case when (coalesce(rsn.tdttd_qty_reason_code,'')='' and coalesce(rsn.tdttd_dmgd_reason_code,'')='') then case when (tdtbd_leg_beh='Pick' and coalesce(tdttd_br_cop,0)=1) then 'sign_pick_cop' when coalesce(tdttd_br_cop,0)=0 and coalesce(tdttd_br_collection_mode,'')<>'Cash' collate nocase then 'sign_pick' end when (coalesce(rsn.tdttd_qty_reason_code,'')<>'' or coalesce(rsn.tdttd_dmgd_reason_code,'')<>'') then case when (tdtbd_leg_beh='Pick' and coalesce(tdttd_br_cop,0)=1) then 'sign_pick_cond_cop' when coalesce(tdttd_br_cop,0)=0 and coalesce(tdttd_br_collection_mode,'')<>'Cash' collate nocase then 'sign_pick_cond' end end when tdtbd_leg_beh not in ('Pick','VedrI') then case when (coalesce(rsn.tdttd_qty_reason_code,'')='' and coalesce(rsn.tdttd_dmgd_reason_code,'')='' and coalesce(rsn.tdttd_rtrnd_reason_code,'')='') then case when tdtbd_leg_beh='Dvry' and (coalesce(tdttd_br_cod_pv,0)=1 or coalesce(tdttd_br_cod_sf,0)=1) then 'sign_dlvry_cod' when coalesce(tdttd_br_cod_pv,0)=0 and coalesce(tdttd_br_cod_sf,0)=0 and coalesce(tdttd_br_collection_mode,'')<>'Cash' collate nocase then 'sign_dlvry' end when (coalesce(rsn.tdttd_qty_reason_code,'')<>'' or coalesce(rsn.tdttd_dmgd_reason_code,'')<>'' or coalesce(rsn.tdttd_rtrnd_reason_code,'')<>'') then case when tdtbd_leg_beh='Dvry' and (coalesce(tdttd_br_cod_pv,0)=1 or coalesce(tdttd_br_cod_sf,0)=1) then 'sign_dlvry_cond_cod' when coalesce(tdttd_br_cod_pv,0)=0 and coalesce(tdttd_br_cod_sf,0)=0 and coalesce(tdttd_br_collection_mode,'')<>'Cash' collate nocase then 'sign_dlvry_cond' end end end when coalesce(ddh_signature_status,'N') = 'N' then case when tdtbd_Trip_line_status = 'DR' then case when coalesce(thu.tdttd_actual_qty,0)>0 then case when tdtbd_leg_beh in ('Pick','VedrI') then case when (coalesce(rsn.tdttd_qty_reason_code,'')='' and coalesce(rsn.tdttd_dmgd_reason_code,'')='') then case when (tdtbd_leg_beh='Pick' and coalesce(tdttd_br_cop,0)=1) then 'dr_sts_pick_cop' when coalesce(tdttd_br_cop,0)=0 and coalesce(tdttd_br_collection_mode,'')<>'Cash' collate nocase then 'dr_sts_pick' end when (coalesce(rsn.tdttd_qty_reason_code,'')<>'' or coalesce(rsn.tdttd_dmgd_reason_code,'')<>'') then case when (tdtbd_leg_beh='Pick' and coalesce(tdttd_br_cop,0)=1) then 'dr_sts_pick_cond_cop' when coalesce(tdttd_br_cop,0)=0 and coalesce(tdttd_br_collection_mode,'')<>'Cash' collate nocase then 'dr_sts_pick_cond' end end when tdtbd_leg_beh not in ('Pick','VedrI') then case when (coalesce(rsn.tdttd_qty_reason_code,'')='' and coalesce(rsn.tdttd_dmgd_reason_code,'')='' and coalesce(rsn.tdttd_rtrnd_reason_code,'')='') then case when tdtbd_leg_beh='Dvry' and (coalesce(tdttd_br_cod_pv,0)=1 or coalesce(tdttd_br_cod_sf,0)=1) then 'dr_sts_dlvry_cod' when coalesce(tdttd_br_cod_pv,0)=0 and coalesce(tdttd_br_cod_sf,0)=0 and coalesce(tdttd_br_collection_mode,'')<>'Cash' collate nocase then 'dr_sts_dlvry' end when (coalesce(rsn.tdttd_qty_reason_code,'')<>'' or coalesce(rsn.tdttd_dmgd_reason_code,'')<>'' or coalesce(rsn.tdttd_rtrnd_reason_code,'')<>'') then case when tdtbd_leg_beh='Dvry' and (coalesce(tdttd_br_cod_pv,0)=1 or coalesce(tdttd_br_cod_sf,0)=1) then 'dr_sts_dlvry_cond_cod' when coalesce(tdttd_br_cod_pv,0)=0 and coalesce(tdttd_br_cod_sf,0)=0 and coalesce(tdttd_br_collection_mode,'')<>'Cash' collate nocase then 'dr_sts_dlvry_cond' end end end when coalesce(thu.tdttd_actual_qty,0)=0 then case when tdtbd_leg_beh in ('Pick','VedrI') then case when (tdtbd_leg_beh='Pick' and coalesce(tdttd_br_cop,0)=1) or coalesce(tdttd_br_collection_mode,'')='Cash' collate nocase then 'ac_sts_pick_arr_cop' when coalesce(tdttd_br_cop,0)=0 and coalesce(tdttd_br_collection_mode,'')<>'Cash' collate nocase then 'ac_sts_pick_arr' end when tdtbd_leg_beh not in ('Pick','VedrI') then case when tdtbd_leg_beh='Dvry' and (coalesce(tdttd_br_cod_pv,0)=1 or coalesce(tdttd_br_cod_sf,0)=1) then 'ac_sts_dlrvy_arr_cod' when coalesce(tdttd_br_cod_pv,0)=0 and coalesce(tdttd_br_cod_sf,0)=0 and coalesce(tdttd_br_collection_mode,'')<>'Cash' collate nocase then 'ac_sts_dlrvy_arr' end end end when (tdtbd_Trip_line_status = 'AC' and coalesce(tdtbd_arrived_date,'')='') OR tdtbd_Trip_line_status = 'RT' then case when tdtbd_leg_beh in ('Pick','VedrI') then 'ac_sts_pick' when tdtbd_leg_beh not in ('Pick','VedrI') then 'ac_sts_dlvry' end end end as 'hdnrt_stcontrol' from tms_tdtbd_driver_trip_br_dtl nolock join tms_tdttd_driver_trip_thu_dtl thu on tdtbd_ouinstance = thu.tdttd_ouinstance and tdtbd_Trip_id = thu.tdttd_Trip_id and tdtbd_seqno = thu.tdttd_seq_no join tms_ddh_dispatch_document_signature nolock on ddh_ouinstance = thu.tdttd_ouinstance and ddh_Trip_id = thu.tdttd_Trip_id and ddh_seqno = thu.tdttd_seq_no and ddh_dispatch_doc_no = thu.tdttd_dispatch_no left join tms_tdttd_thu_reason_code rsn on rsn.tdttd_ouinstance = tdtbd_ouinstance and rsn.tdttd_Trip_id = tdtbd_Trip_id and rsn.tdttd_seq_no = tdtbd_seqno and rsn.tdttd_dispatch_no = thu.tdttd_dispatch_no and rsn.tdttd_THU_id = thu.tdttd_THU_id left join cte_pud on tdtbd_Trip_id = trip where tdtbd_ouinstance = @ctxt_ou and tdtbd_Trip_id = 'TRPL/0016795/1617' and tdtbd_seqno = '1' and thu.tdttd_dispatch_no = 'CNN72' and thu.tdttd_THU_id = 'BOX' [8/19/2019 6:52:46 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=select case when tdtbd_leg_beh in ('pick','VedrI') THEN 'Picked Qty.' else 'Delivered Qty.' end 'delivered_qty_caption' from tms_tdtbd_driver_trip_br_dtl nolock WHERE tdtbd_ouinstance = @ctxt_ou and tdtbd_Trip_id = 'TRPL/0016795/1617' and tdtbd_seqno = '1'; [8/19/2019 6:52:46 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=select case when tdttd_leg_beh in ('pick','VedrI') COLLATE NOCASE and coalesce(tdttd_br_cop,0)=1 then 'COP' when tdttd_leg_beh NOT in ('pick','VedrI') COLLATE NOCASE and coalesce(tdttd_br_cod_pv,0)=1 or coalesce(tdttd_br_cod_sf,0)=1 then 'COD' when coalesce(tdttd_br_collection_mode,'')='Cash' collate nocase then 'Cash Collected' end 'cash_hdn' from tms_tdttd_driver_trip_thu_dtl nolock WHERE tdttd_ouinstance = @ctxt_ou and tdttd_Trip_id = 'TRPL/0016795/1617' and tdttd_seq_no = '1' and tdttd_dispatch_no = 'CNN72' and tdttd_THU_id = 'BOX' [8/19/2019 6:52:46 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=select NULLIF(tdttd_actual_qty,0) 'delivered_qty', tdttd_planned_qty 'planned_qty', tdttd_picked_palletspace 'palletspace', tdttd_thu_weight 'thu_actual_weight',tdttd_thu_uom 'thudetailsuom_hdn', IFNULL(tdttd_damaged_qty,0) 'damaged_qty',IFNULL(tdttd_returned_qty,0) 'returned_qty', tdttd_vendor_thu_id 'vendor_thu_id', tdttd_transfer_type 'thudetailstransfertype_hdn', tdttd_vendor_account 'vendor_ac_no', tdttd_Transfer_doc 'transfer_doc_no', tdttd_dispatch_no 'disp_doc_no', tdttd_class_of_stores 'class_of_stores_hdn' from tms_tdttd_driver_trip_thu_dtl nolock where tdttd_ouinstance = @ctxt_ou and tdttd_Trip_id = 'TRPL/0016795/1617' and tdttd_seq_no = '1' and tdttd_THU_id = 'BOX' and tdttd_dispatch_no = 'CNN72'; [8/19/2019 6:52:46 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=select ttad_image 'image', ttad_image_dtl_desc 'image_desc', ttad_key_guid 'key_guid' from tms_ttad_trip_attachment_dtl nolock where ttad_ouinstance = @ctxt_ou and ttad_Trip_id = 'TRPL/0016795/1617' and ttad_Doc_type = 'THU_IMAGE' and ttad_parameter1 = '1' and ttad_parameter2 = 'BOX' and ttad_dispatch_no = 'CNN72'; [8/19/2019 6:52:46 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=select '{''total_thus'':'''||coalesce(count(*),0) ||''',''tplid'':''Thudetails''}' as 'total_thus_label' from tms_tdttd_driver_trip_thu_dtl where tdttd_ouinstance = @ctxt_ou and tdttd_Trip_id = 'TRPL/0016795/1617' and tdttd_seq_no = '1' and tdttd_dispatch_no ='CNN72'; [8/19/2019 6:52:46 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=SELECT sum(tlccdm_amount_collected)+sum(tlccdm_ship_fee_collect) 'udd_hdncntrl06' FROM tms_tlccdm_triplog_codcop_collection_dtl_mob NOLOCK WHERE tlccdm_ouinstance = @ctxt_ou AND tlccdm_trip_plan_id ='TRPL/0016795/1617' AND tlccdm_sequence_no ='1' AND tlccdm_dispatch_doc_no ='CNN72' [8/19/2019 6:52:46 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=SELECT sum(tlcidm_value) 'udd_hdncntrl07' FROM tms_tlcidm_triplog_codcop_instrument_dtl_mob NOLOCK WHERE tlcidm_ouinstance = @ctxt_ou AND tlcidm_trip_plan_id ='TRPL/0016795/1617' AND tlcidm_sequence_no ='1' AND tlcidm_dispatch_doc_no ='CNN72' [8/19/2019 6:52:46 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=select '{''tplid'':''special_inst_popup''}' as 'cn_popup_link', '{''tplid'':''add_thu_id_lnk''}' as 'add_thuid_link', '{''tplid'':''thu_add_details_lnk''}' as 'thu_additional_det_link', '{''tplid'':''special_inst_popup''}' as 'reason_code_popup_link', '{''tplid'':''vendor_thu_dets_lnk''}' as 'mv_popup_link', 'N' AS 'child_thu_flag' [8/19/2019 6:52:46 PM] : [LDSE.GetQueryListAsync(DBQJ)] SB = {"mlattc_paggrid":[],"_hseg":{"hdnhdnrt_stcontrol":"ac_sts_pick_arr_cop","hdndelivered_qty_caption":"Picked Qty.","hdncash_hdn":"COP","txtdelivered_qty":"","dspplanned_qty":4,"txtpalletspace":"0","txtthu_actual_weight":"13.00000000","hthudetailsuom_hdn":"kilos","txtdamaged_qty":0,"txtreturned_qty":0,"cmbvendor_thu_id":"","hthudetailstransfertype_hdn":"","txtvendor_ac_no":"","txttransfer_doc_no":"","hdndisp_doc_no":"CNN72","hclass_of_stores_hdn":"007","dsptotal_thus_label":"{'total_thus':'1','tplid':'Thudetails'}","hdnudd_hdncntrl06":0.0,"hdnudd_hdncntrl07":"","lnkcn_popup_link":"{'tplid':'special_inst_popup'}","lnkadd_thuid_link":"{'tplid':'add_thu_id_lnk'}","lnkthu_additional_det_link":"{'tplid':'thu_add_details_lnk'}","lnkreason_code_popup_link":"{'tplid':'special_inst_popup'}","lnkmv_popup_link":"{'tplid':'vendor_thu_dets_lnk'}","hdnchild_thu_flag":"N"},"status":"service_success"} [8/19/2019 6:52:46 PM] : [LDSE.GetQueryListAsync(DBQJ)] Transaction Succesfully Committed: dtmmaireefth [8/19/2019 6:52:46 PM] : [AutoSyncHelper.TrySync] Confirm Taskdtmmaireefth Is Not Terminal Action [8/19/2019 6:52:46 PM] : { "hdr": { "bgsec": "", "cbid": "1812579034", "sts": 1 }, "data": "{\n \"mlattc_paggrid\": [],\n \"_hseg\": {\n \"hdnhdnrt_stcontrol\": \"ac_sts_pick_arr_cop\",\n \"hdndelivered_qty_caption\": \"Picked Qty.\",\n \"hdncash_hdn\": \"COP\",\n \"txtdelivered_qty\": \"\",\n \"dspplanned_qty\": 4,\n \"txtpalletspace\": \"0\",\n \"txtthu_actual_weight\": \"13.00000000\",\n \"hthudetailsuom_hdn\": \"kilos\",\n \"txtdamaged_qty\": 0,\n \"txtreturned_qty\": 0,\n \"cmbvendor_thu_id\": \"\",\n \"hthudetailstransfertype_hdn\": \"\",\n \"txtvendor_ac_no\": \"\",\n \"txttransfer_doc_no\": \"\",\n \"hdndisp_doc_no\": \"CNN72\",\n \"hclass_of_stores_hdn\": \"007\",\n \"dsptotal_thus_label\": \"{'total_thus':'1','tplid':'Thudetails'}\",\n \"hdnudd_hdncntrl06\": 0.0,\n \"hdnudd_hdncntrl07\": \"\",\n \"lnkcn_popup_link\": \"{'tplid':'special_inst_popup'}\",\n \"lnkadd_thuid_link\": \"{'tplid':'add_thu_id_lnk'}\",\n \"lnkthu_additional_det_link\": \"{'tplid':'thu_add_details_lnk'}\",\n \"lnkreason_code_popup_link\": \"{'tplid':'special_inst_popup'}\",\n \"lnkmv_popup_link\": \"{'tplid':'vendor_thu_dets_lnk'}\",\n \"hdnchild_thu_flag\": \"N\"\n },\n \"status\": \"service_success\"\n}" } [8/19/2019 6:52:46 PM] : Failed to locate callbackHandler for id : 1812579034 [8/19/2019 6:52:46 PM] : anywhere.callbackFromNative({ "hdr": { "bgsec": "", "cbid": "1812579034", "sts": 1 }, "data": "{\n \"mlattc_paggrid\": [],\n \"_hseg\": {\n \"hdnhdnrt_stcontrol\": \"ac_sts_pick_arr_cop\",\n \"hdndelivered_qty_caption\": \"Picked Qty.\",\n \"hdncash_hdn\": \"COP\",\n \"txtdelivered_qty\": \"\",\n \"dspplanned_qty\": 4,\n \"txtpalletspace\": \"0\",\n \"txtthu_actual_weight\": \"13.00000000\",\n \"hthudetailsuom_hdn\": \"kilos\",\n \"txtdamaged_qty\": 0,\n \"txtreturned_qty\": 0,\n \"cmbvendor_thu_id\": \"\",\n \"hthudetailstransfertype_hdn\": \"\",\n \"txtvendor_ac_no\": \"\",\n \"txttransfer_doc_no\": \"\",\n \"hdndisp_doc_no\": \"CNN72\",\n \"hclass_of_stores_hdn\": \"007\",\n \"dsptotal_thus_label\": \"{'total_thus':'1','tplid':'Thudetails'}\",\n \"hdnudd_hdncntrl06\": 0.0,\n \"hdnudd_hdncntrl07\": \"\",\n \"lnkcn_popup_link\": \"{'tplid':'special_inst_popup'}\",\n \"lnkadd_thuid_link\": \"{'tplid':'add_thu_id_lnk'}\",\n \"lnkthu_additional_det_link\": \"{'tplid':'thu_add_details_lnk'}\",\n \"lnkreason_code_popup_link\": \"{'tplid':'special_inst_popup'}\",\n \"lnkmv_popup_link\": \"{'tplid':'vendor_thu_dets_lnk'}\",\n \"hdnchild_thu_flag\": \"N\"\n },\n \"status\": \"service_success\"\n}" }); [8/19/2019 6:52:48 PM] : [VWWebViewClient][ShouldInterceptRequest] request : file:///data/user/0/com.ramco.droid.unify/app_null/Apps/8d31af33-f193-452f-8a8e-6aa4e178e7eb/DRIVER_TRIP_MOBILE/unify/driver_trip_mobile/view/Dashboard_dtl_act_RecordcopdetailsView.js [8/19/2019 6:52:48 PM] : [VWWebViewClient][ShouldInterceptRequest] request : file:///data/user/0/com.ramco.droid.unify/app_null/Apps/8d31af33-f193-452f-8a8e-6aa4e178e7eb/DRIVER_TRIP_MOBILE/unify/resources/css/dashboard_dtl_act_recordcopdetails.css [8/19/2019 6:52:48 PM] : [VWWebViewClient][ShouldInterceptRequest] request : file:///data/user/0/com.ramco.droid.unify/app_null/Apps/8d31af33-f193-452f-8a8e-6aa4e178e7eb/DRIVER_TRIP_MOBILE/unify/driver_trip_mobile/enterprise/dashboard_dtl_act_recordcopdetails.xml?_dc=1566220968290 [8/19/2019 6:52:48 PM] : [VWWebViewClient][ShouldInterceptRequest] request : file:///data/user/0/com.ramco.droid.unify/app_null/Apps/8d31af33-f193-452f-8a8e-6aa4e178e7eb/DRIVER_TRIP_MOBILE/unify/driver_trip_mobile/state/dashboard_dtl_act_recordcopdetails.xml?_dc=1566220968292 [8/19/2019 6:52:48 PM] : [VWWebViewClient][ShouldInterceptRequest] request : file:///data/user/0/com.ramco.droid.unify/app_null/Apps/8d31af33-f193-452f-8a8e-6aa4e178e7eb/DRIVER_TRIP_MOBILE/unify/driver_trip_mobile/templates/dashboard_dtl_act_recordcopdetails.js?_dc=1566220968464 [8/19/2019 6:52:48 PM] : [VWWebViewClient][ShouldInterceptRequest] request : file:///data/user/0/com.ramco.droid.unify/app_null/Apps/8d31af33-f193-452f-8a8e-6aa4e178e7eb/DRIVER_TRIP_MOBILE/unify/resources/fonts/Roboto.ttf [8/19/2019 6:52:48 PM] : [LDSE.GetQueryListAsync(DBQJ)]New Transaction Started: dtmmains8init [8/19/2019 6:52:48 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=select '' 'reason_for_difference' union select tms_code 'reason_for_difference' from tms_quick_code_master_met nolock where tms_ouinstance = @ctxt_ou and tms_code_type = 'RSNCD' and tms_category = 'CASH_REASON' [8/19/2019 6:52:48 PM] : [LDSE.GetQueryListAsync(DBQJ)] SB = {"cmbreason_for_difference":[{"cmbreason_for_difference":""},{"cmbreason_for_difference":"123"},{"cmbreason_for_difference":"222"},{"cmbreason_for_difference":"66"},{"cmbreason_for_difference":"78"},{"cmbreason_for_difference":"DAMAGED"},{"cmbreason_for_difference":"Futile"},{"cmbreason_for_difference":"Leave"},{"cmbreason_for_difference":"MAXVALUEUTMAXVALUEUTMAXVALUEUTMAXVALUEUT"},{"cmbreason_for_difference":"New Unified Asset"},{"cmbreason_for_difference":"QC"},{"cmbreason_for_difference":"rac"},{"cmbreason_for_difference":"RC1"},{"cmbreason_for_difference":"rc2"},{"cmbreason_for_difference":"RC3"},{"cmbreason_for_difference":"RC4"},{"cmbreason_for_difference":"RC5"},{"cmbreason_for_difference":"RC6"},{"cmbreason_for_difference":"RC7"},{"cmbreason_for_difference":"Re-Delivery"},{"cmbreason_for_difference":"WE"}],"status":"service_success"} [8/19/2019 6:52:48 PM] : [LDSE.GetQueryListAsync(DBQJ)] Transaction Succesfully Committed: dtmmains8init [8/19/2019 6:52:48 PM] : [AutoSyncHelper.TrySync] Confirm Taskdtmmains8init Is Not Terminal Action [8/19/2019 6:52:48 PM] : { "hdr": { "bgsec": "", "cbid": "1094042130", "sts": 1 }, "data": "{\n \"cmbreason_for_difference\": [\n {\n \"cmbreason_for_difference\": \"\"\n },\n {\n \"cmbreason_for_difference\": \"123\"\n },\n {\n \"cmbreason_for_difference\": \"222\"\n },\n {\n \"cmbreason_for_difference\": \"66\"\n },\n {\n \"cmbreason_for_difference\": \"78\"\n },\n {\n \"cmbreason_for_difference\": \"DAMAGED\"\n },\n {\n \"cmbreason_for_difference\": \"Futile\"\n },\n {\n \"cmbreason_for_difference\": \"Leave\"\n },\n {\n \"cmbreason_for_difference\": \"MAXVALUEUTMAXVALUEUTMAXVALUEUTMAXVALUEUT\"\n },\n {\n \"cmbreason_for_difference\": \"New Unified Asset\"\n },\n {\n \"cmbreason_for_difference\": \"QC\"\n },\n {\n \"cmbreason_for_difference\": \"rac\"\n },\n {\n \"cmbreason_for_difference\": \"RC1\"\n },\n {\n \"cmbreason_for_difference\": \"rc2\"\n },\n {\n \"cmbreason_for_difference\": \"RC3\"\n },\n {\n \"cmbreason_for_difference\": \"RC4\"\n },\n {\n \"cmbreason_for_difference\": \"RC5\"\n },\n {\n \"cmbreason_for_difference\": \"RC6\"\n },\n {\n \"cmbreason_for_difference\": \"RC7\"\n },\n {\n \"cmbreason_for_difference\": \"Re-Delivery\"\n },\n {\n \"cmbreason_for_difference\": \"WE\"\n }\n ],\n \"status\": \"service_success\"\n}" } [8/19/2019 6:52:48 PM] : Failed to locate callbackHandler for id : 1094042130 [8/19/2019 6:52:48 PM] : anywhere.callbackFromNative({ "hdr": { "bgsec": "", "cbid": "1094042130", "sts": 1 }, "data": "{\n \"cmbreason_for_difference\": [\n {\n \"cmbreason_for_difference\": \"\"\n },\n {\n \"cmbreason_for_difference\": \"123\"\n },\n {\n \"cmbreason_for_difference\": \"222\"\n },\n {\n \"cmbreason_for_difference\": \"66\"\n },\n {\n \"cmbreason_for_difference\": \"78\"\n },\n {\n \"cmbreason_for_difference\": \"DAMAGED\"\n },\n {\n \"cmbreason_for_difference\": \"Futile\"\n },\n {\n \"cmbreason_for_difference\": \"Leave\"\n },\n {\n \"cmbreason_for_difference\": \"MAXVALUEUTMAXVALUEUTMAXVALUEUTMAXVALUEUT\"\n },\n {\n \"cmbreason_for_difference\": \"New Unified Asset\"\n },\n {\n \"cmbreason_for_difference\": \"QC\"\n },\n {\n \"cmbreason_for_difference\": \"rac\"\n },\n {\n \"cmbreason_for_difference\": \"RC1\"\n },\n {\n \"cmbreason_for_difference\": \"rc2\"\n },\n {\n \"cmbreason_for_difference\": \"RC3\"\n },\n {\n \"cmbreason_for_difference\": \"RC4\"\n },\n {\n \"cmbreason_for_difference\": \"RC5\"\n },\n {\n \"cmbreason_for_difference\": \"RC6\"\n },\n {\n \"cmbreason_for_difference\": \"RC7\"\n },\n {\n \"cmbreason_for_difference\": \"Re-Delivery\"\n },\n {\n \"cmbreason_for_difference\": \"WE\"\n }\n ],\n \"status\": \"service_success\"\n}" }); [8/19/2019 6:52:49 PM] : [LDSE.GetQueryListAsync(DBQJ)]New Transaction Started: dtmmains8fth [8/19/2019 6:52:49 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=select case when coalesce(ddh_signature_status,'N')='Y' then 'Exec_save' else 'Active_save' end 'hdnrt_stcontrol' from tms_ddh_dispatch_document_signature nolock WHERE ddh_ouinstance = @ctxt_ou AND ddh_Trip_id = 'TRPL/0016795/1617' AND ddh_seqno = '1' and ddh_dispatch_doc_no = 'CNN72' [8/19/2019 6:52:49 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=SELECT '{''consignment_note'':'''||coalesce(tlccdm_dispatch_doc_no, '') ||''',''tplid'':''Header7_cash''}' as 'co_hdr_display' FROM tms_tlccdm_triplog_codcop_collection_dtl_mob, tms_tcm_currency_mst where tlccdm_ouinstance = @ctxt_ou and tlccdm_trip_plan_id = 'TRPL/0016795/1617' and tlccdm_sequence_no = '1' and tlccdm_dispatch_doc_no = 'CNN72' [8/19/2019 6:52:49 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=SELECT tcm_Curr_code || ' ' ||COALESCE(tlccdm_ship_fee_to_be_collect,0) AS 'amount_to_be_collected', tlccdm_ship_fee_collect 'amount_collected', tcm_Curr_code AS 'currency', tlccdm_rsn_for_diff_ship_fee 'reason_for_difference', tms_code_desc 'rsn_for_diff_desc', tlccdm_remarks 'remarks' FROM tms_tlccdm_triplog_codcop_collection_dtl_mob nolock left join tms_quick_code_master_met nolock on tms_code=tlccdm_rsn_for_diff_ship_fee and tms_code_type = 'RSNCD' and tms_category = 'CASH_REASON' left join tms_tcm_currency_mst nolock on tcm_ouinstance=tlccdm_ouinstance where tlccdm_ouinstance = @ctxt_ou and tlccdm_trip_plan_id = 'TRPL/0016795/1617' and tlccdm_sequence_no = '1' and tlccdm_dispatch_doc_no = 'CNN72' [8/19/2019 6:52:49 PM] : [LDSE.GetQueryListAsync(DBQJ)] SB = {"_hseg":{"hdnhdnrt_stcontrol":"Active_save","dspco_hdr_display":"{'consignment_note':'CNN72','tplid':'Header7_cash'}","dspamount_to_be_collected":"INR 1000","txtamount_collected":0.0,"dspcurrency":"INR","cmbreason_for_difference":"","dsprsn_for_diff_desc":"","txtremarks":""},"status":"service_success"} [8/19/2019 6:52:49 PM] : [LDSE.GetQueryListAsync(DBQJ)] Transaction Succesfully Committed: dtmmains8fth [8/19/2019 6:52:49 PM] : [AutoSyncHelper.TrySync] Confirm Taskdtmmains8fth Is Not Terminal Action [8/19/2019 6:52:49 PM] : { "hdr": { "bgsec": "", "cbid": "1669541047", "sts": 1 }, "data": "{\n \"_hseg\": {\n \"hdnhdnrt_stcontrol\": \"Active_save\",\n \"dspco_hdr_display\": \"{'consignment_note':'CNN72','tplid':'Header7_cash'}\",\n \"dspamount_to_be_collected\": \"INR 1000\",\n \"txtamount_collected\": 0.0,\n \"dspcurrency\": \"INR\",\n \"cmbreason_for_difference\": \"\",\n \"dsprsn_for_diff_desc\": \"\",\n \"txtremarks\": \"\"\n },\n \"status\": \"service_success\"\n}" } [8/19/2019 6:52:49 PM] : Failed to locate callbackHandler for id : 1669541047 [8/19/2019 6:52:49 PM] : anywhere.callbackFromNative({ "hdr": { "bgsec": "", "cbid": "1669541047", "sts": 1 }, "data": "{\n \"_hseg\": {\n \"hdnhdnrt_stcontrol\": \"Active_save\",\n \"dspco_hdr_display\": \"{'consignment_note':'CNN72','tplid':'Header7_cash'}\",\n \"dspamount_to_be_collected\": \"INR 1000\",\n \"txtamount_collected\": 0.0,\n \"dspcurrency\": \"INR\",\n \"cmbreason_for_difference\": \"\",\n \"dsprsn_for_diff_desc\": \"\",\n \"txtremarks\": \"\"\n },\n \"status\": \"service_success\"\n}" }); [8/19/2019 6:52:54 PM] : [LDSE.GetQueryListAsync(DBQJ)]New Transaction Started: dtmmains8reasonui [8/19/2019 6:52:54 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=SELECT tms_code_desc 'rsn_for_diff_desc' from tms_quick_code_master_met nolock where tms_ouinstance = @ctxt_ou and tms_code_type = 'RSNCD' and tms_category = 'CASH_REASON' AND tms_code = '123' [8/19/2019 6:52:54 PM] : [LDSE.GetQueryListAsync(DBQJ)] SB = {"_hseg":{"dsprsn_for_diff_desc":"1234566789012345678901234567890-12345678"},"status":"service_success"} [8/19/2019 6:52:54 PM] : [LDSE.GetQueryListAsync(DBQJ)] Transaction Succesfully Committed: dtmmains8reasonui [8/19/2019 6:52:54 PM] : [AutoSyncHelper.TrySync] Confirm Taskdtmmains8reasonui Is Not Terminal Action [8/19/2019 6:52:54 PM] : { "hdr": { "bgsec": "", "cbid": "1047064512", "sts": 1 }, "data": "{\n \"_hseg\": {\n \"dsprsn_for_diff_desc\": \"1234566789012345678901234567890-12345678\"\n },\n \"status\": \"service_success\"\n}" } [8/19/2019 6:52:54 PM] : Failed to locate callbackHandler for id : 1047064512 [8/19/2019 6:52:54 PM] : anywhere.callbackFromNative({ "hdr": { "bgsec": "", "cbid": "1047064512", "sts": 1 }, "data": "{\n \"_hseg\": {\n \"dsprsn_for_diff_desc\": \"1234566789012345678901234567890-12345678\"\n },\n \"status\": \"service_success\"\n}" }); [8/19/2019 6:52:55 PM] : [LDSE.GetQueryListAsync(DBQJ)]New Transaction Started: dtmmains8save1tr [8/19/2019 6:52:55 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=select '40001' as 'error_id' from tms_ddh_dispatch_document_signature nolock where exists (select 'x' from tms_ddh_dispatch_document_signature nolock where ddh_ouinstance=@ctxt_ou and ddh_Trip_id='TRPL/0016795/1617' and ddh_seqno='1' and ddh_dispatch_doc_no='CNN72' and ddh_signature is not null) [8/19/2019 6:52:55 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=SELECT CASE WHEN IFNULL('500',0)=0 THEN '40002' WHEN IFNULL(tlccdm_ship_fee_to_be_collect,0) <> ifnull('500',0) and ifnull('123' ,'')='' then '40003' end 'error_id' from tms_tlccdm_triplog_codcop_collection_dtl_mob WHERE tlccdm_ouinstance = @ctxt_ou AND tlccdm_trip_plan_id = 'TRPL/0016795/1617' AND tlccdm_sequence_no = '1' AND tlccdm_dispatch_doc_no = 'CNN72' [8/19/2019 6:52:55 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=UPDATE tms_tlcidm_triplog_codcop_instrument_dtl_mob SET tlcidm_value = (SELECT case when coalesce('NULL',0)=0 then tlcidm_value+'500' else (tlcidm_value-'NULL')+'500' end ) WHERE tlcidm_ouinstance = @ctxt_ou AND tlcidm_trip_plan_id ='TRPL/0016795/1617' AND tlcidm_sequence_no ='1' AND tlcidm_dispatch_doc_no ='CNN72' AND coalesce(tlcidm_mode_of_collection,'') = 'Cash' collate nocase [8/19/2019 6:52:55 PM] : [LDSE.UpdateRequestToDb] ExecutingQuery=UPDATE tms_tlcidm_triplog_codcop_instrument_dtl_mob SET tlcidm_value = (SELECT case when coalesce(@udd_hdncntrl10,0)=0 then tlcidm_value+@amount_collected else (tlcidm_value-@udd_hdncntrl10)+@amount_collected end ) WHERE tlcidm_ouinstance = @ctxt_ou AND tlcidm_trip_plan_id =@trip_id AND tlcidm_sequence_no =@sequence_no AND tlcidm_dispatch_doc_no =@consignment_note AND coalesce(tlcidm_mode_of_collection,'') = 'Cash' collate nocase [8/19/2019 6:52:55 PM] : [LDSE.UpdateRequestToDb] Resulting RowCount: 1 [8/19/2019 6:52:55 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=Insert into tms_tlcidm_triplog_codcop_instrument_dtl_mob (tlcidm_ouinstance,tlcidm_trip_plan_id,tlcidm_sequence_no,tlcidm_dispatch_doc_no,tlcidm_line_no, tlcidm_mode_of_collection,tlcidm_instrument_no,tlcidm_value,tlcidm_remarks) SELECT @ctxt_ou,'TRPL/0016795/1617','1','CNN72',hex(randomblob(4))||'-'||hex(randomblob(4)), 'Cash',null,'500',null WHERE NOT EXISTS ( SELECT '1' FROM tms_tlcidm_triplog_codcop_instrument_dtl_mob NOLOCK WHERE tlcidm_ouinstance = @ctxt_ou AND tlcidm_trip_plan_id = 'TRPL/0016795/1617' AND tlcidm_sequence_no = '1' AND tlcidm_dispatch_doc_no = 'CNN72' AND coalesce(tlcidm_mode_of_collection,'') = 'Cash' collate nocase ) [8/19/2019 6:52:55 PM] : [LDSE.UpdateRequestToDb] ExecutingQuery=Insert into tms_tlcidm_triplog_codcop_instrument_dtl_mob (tlcidm_ouinstance,tlcidm_trip_plan_id,tlcidm_sequence_no,tlcidm_dispatch_doc_no,tlcidm_line_no, tlcidm_mode_of_collection,tlcidm_instrument_no,tlcidm_value,tlcidm_remarks) SELECT @ctxt_ou,@trip_id,@sequence_no,@consignment_note,hex(randomblob(4))||'-'||hex(randomblob(4)), 'Cash',null,@amount_collected,null WHERE NOT EXISTS ( SELECT '1' FROM tms_tlcidm_triplog_codcop_instrument_dtl_mob NOLOCK WHERE tlcidm_ouinstance = @ctxt_ou AND tlcidm_trip_plan_id = @trip_id AND tlcidm_sequence_no = @sequence_no AND tlcidm_dispatch_doc_no = @consignment_note AND coalesce(tlcidm_mode_of_collection,'') = 'Cash' collate nocase ) [8/19/2019 6:52:55 PM] : [LDSE.UpdateRequestToDb] Resulting RowCount: 0 [8/19/2019 6:52:55 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=UPDATE tms_tlccdm_triplog_codcop_collection_dtl_mob SET tlccdm_ship_fee_collect = '500', tlccdm_rsn_for_diff_ship_fee = '123', tlccdm_remarks = '' WHERE tlccdm_ouinstance = @ctxt_ou AND tlccdm_trip_plan_id = 'TRPL/0016795/1617' AND tlccdm_sequence_no = '1' AND tlccdm_dispatch_doc_no = 'CNN72' [8/19/2019 6:52:55 PM] : [LDSE.UpdateRequestToDb] ExecutingQuery=UPDATE tms_tlccdm_triplog_codcop_collection_dtl_mob SET tlccdm_ship_fee_collect = @amount_collected, tlccdm_rsn_for_diff_ship_fee = @reason_for_difference, tlccdm_remarks = @remarks WHERE tlccdm_ouinstance = @ctxt_ou AND tlccdm_trip_plan_id = @trip_id AND tlccdm_sequence_no = @sequence_no AND tlccdm_dispatch_doc_no = @consignment_note [8/19/2019 6:52:55 PM] : [LDSE.UpdateRequestToDb] Resulting RowCount: 1 [8/19/2019 6:52:55 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery= UPDATE tms_tdttd_driver_trip_thu_dtl SET tdttd_cop_cod_status = 'Y' WHERE tdttd_ouinstance= @ctxt_ou AND tdttd_Trip_id = 'TRPL/0016795/1617' AND tdttd_seq_no = '1' AND tdttd_dispatch_no = 'CNN72' [8/19/2019 6:52:55 PM] : [LDSE.UpdateRequestToDb] ExecutingQuery= UPDATE tms_tdttd_driver_trip_thu_dtl SET tdttd_cop_cod_status = 'Y' WHERE tdttd_ouinstance= @ctxt_ou AND tdttd_Trip_id = @trip_id AND tdttd_seq_no = @sequence_no AND tdttd_dispatch_no = @consignment_note [8/19/2019 6:52:55 PM] : [LDSE.UpdateRequestToDb] Resulting RowCount: 1 [8/19/2019 6:52:55 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=SELECT '{''consignment_note'':'''||coalesce(tlccdm_dispatch_doc_no, '') ||''',''tplid'':''Header7_cash''}' as 'co_hdr_display' FROM tms_tlccdm_triplog_codcop_collection_dtl_mob, tms_tcm_currency_mst where tlccdm_ouinstance = @ctxt_ou and tlccdm_trip_plan_id = 'TRPL/0016795/1617' and tlccdm_sequence_no = '1' and tlccdm_dispatch_doc_no = 'CNN72' [8/19/2019 6:52:55 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=SELECT tcm_Curr_code || ' ' ||COALESCE(tlccdm_ship_fee_to_be_collect,0) AS 'amount_to_be_collected', tlccdm_ship_fee_collect 'amount_collected', tcm_Curr_code AS 'currency', tlccdm_rsn_for_diff_ship_fee 'reason_for_difference', tms_code_desc 'rsn_for_diff_desc', tlccdm_remarks 'remarks' FROM tms_tlccdm_triplog_codcop_collection_dtl_mob nolock left join tms_quick_code_master_met nolock on tms_code=tlccdm_rsn_for_diff_ship_fee and tms_code_type = 'RSNCD' and tms_category = 'CASH_REASON' left join tms_tcm_currency_mst nolock on tcm_ouinstance=tlccdm_ouinstance where tlccdm_ouinstance = @ctxt_ou and tlccdm_trip_plan_id = 'TRPL/0016795/1617' and tlccdm_sequence_no = '1' and tlccdm_dispatch_doc_no = 'CNN72' [8/19/2019 6:52:55 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=select '40004' as 'error_id' [8/19/2019 6:52:55 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=SELECT error_desc FROM err_msg_meta WHERE error_id = @error_id [8/19/2019 6:52:55 PM] : SELECT error_desc FROM err_msg_meta WHERE error_id = @error_id [8/19/2019 6:52:55 PM] : error_desc = {0} details saved successfully [8/19/2019 6:52:55 PM] : [LocalDBHelper.SetValue]error_desc : {0} details saved successfully [8/19/2019 6:52:55 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=SELECT bt_name FROM err_msg_bt_map WHERE error_id = @error_id ORDER BY seq_no [8/19/2019 6:52:55 PM] : SELECT bt_name FROM err_msg_bt_map WHERE error_id = @error_id ORDER BY seq_no [8/19/2019 6:52:55 PM] : [LDSE.GetQueryListAsync(DBQJ)] SB = {"_hseg":{"error_id":"40004","dspco_hdr_display":"{'consignment_note':'CNN72','tplid':'Header7_cash'}","dspamount_to_be_collected":"INR 1000","txtamount_collected":500.0,"dspcurrency":"INR","cmbreason_for_difference":"123","dsprsn_for_diff_desc":"1234566789012345678901234567890-12345678","txtremarks":""},"status":"service_success","informations":[{"code":"40004","desc":"{0} details saved successfully"}]} [8/19/2019 6:52:55 PM] : [LDSE.GetQueryListAsync(DBQJ)] Transaction Succesfully Committed: dtmmains8save1tr [8/19/2019 6:52:55 PM] : [AutoSyncHelper.TrySync] Confirm Taskdtmmains8save1tr Is Not Terminal Action [8/19/2019 6:52:55 PM] : { "hdr": { "bgsec": "", "cbid": "1417958712", "sts": 1 }, "data": "{\n \"_hseg\": {\n \"error_id\": \"40004\",\n \"dspco_hdr_display\": \"{'consignment_note':'CNN72','tplid':'Header7_cash'}\",\n \"dspamount_to_be_collected\": \"INR 1000\",\n \"txtamount_collected\": 500.0,\n \"dspcurrency\": \"INR\",\n \"cmbreason_for_difference\": \"123\",\n \"dsprsn_for_diff_desc\": \"1234566789012345678901234567890-12345678\",\n \"txtremarks\": \"\"\n },\n \"status\": \"service_success\",\n \"informations\": [\n {\n \"code\": \"40004\",\n \"desc\": \"{0} details saved successfully\"\n }\n ]\n}" } [8/19/2019 6:52:55 PM] : Failed to locate callbackHandler for id : 1417958712 [8/19/2019 6:52:55 PM] : anywhere.callbackFromNative({ "hdr": { "bgsec": "", "cbid": "1417958712", "sts": 1 }, "data": "{\n \"_hseg\": {\n \"error_id\": \"40004\",\n \"dspco_hdr_display\": \"{'consignment_note':'CNN72','tplid':'Header7_cash'}\",\n \"dspamount_to_be_collected\": \"INR 1000\",\n \"txtamount_collected\": 500.0,\n \"dspcurrency\": \"INR\",\n \"cmbreason_for_difference\": \"123\",\n \"dsprsn_for_diff_desc\": \"1234566789012345678901234567890-12345678\",\n \"txtremarks\": \"\"\n },\n \"status\": \"service_success\",\n \"informations\": [\n {\n \"code\": \"40004\",\n \"desc\": \"{0} details saved successfully\"\n }\n ]\n}" }); [8/19/2019 6:52:57 PM] : [LDSE.GetQueryListAsync(DBQJ)]New Transaction Started: dtmmains8recordlk [8/19/2019 6:52:57 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=select CASE WHEN coalesce(tlccdm_ship_fee_collect,0)=0 THEN '40005' END as 'error_id' FROM tms_tlccdm_triplog_codcop_collection_dtl_mob WHERE tlccdm_ouinstance = @ctxt_ou AND tlccdm_trip_plan_id = 'TRPL/0016795/1617' AND tlccdm_sequence_no = '1' AND tlccdm_dispatch_doc_no = 'CNN72' [8/19/2019 6:52:57 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=SELECT CASE WHEN count('1') < 1 then '40006' END as 'error_id' from tms_tlcidm_triplog_codcop_instrument_dtl_mob nolock WHERE tlcidm_ouinstance = @ctxt_ou AND tlcidm_trip_plan_id = 'TRPL/0016795/1617' tlcidm_sequence_no = '1' tlcidm_dispatch_doc_no = 'CNN72' coalesce(tlcidm_mode_of_collection,'') = 'Cash' collate nocase [8/19/2019 6:52:57 PM] : [LDSE.FetchResponseFromDb] Exception SQLite error Insufficient parameters supplied to the command [8/19/2019 6:52:57 PM] : [LDSE.GetQueryListAsync(DBQJ)] Exception Exception Occured Message :: SQLite error Insufficient parameters supplied to the command InnerException :: Source :: mscorlib StackTrace :: at Mono.Data.Sqlite.SqliteStatement.BindParameter (System.Int32 index, Mono.Data.Sqlite.SqliteParameter param) [0x0000e] in :0 at Mono.Data.Sqlite.SqliteStatement.BindParameters () [0x00016] in :0 at Mono.Data.Sqlite.SqliteCommand.BuildNextCommand () [0x000d3] in :0 at Mono.Data.Sqlite.SqliteCommand.GetStatement (System.Int32 index) [0x00008] in :0 at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteCommand.GetStatement(int) at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x000b3] in :0 at Mono.Data.Sqlite.SqliteDataReader..ctor (Mono.Data.Sqlite.SqliteCommand cmd, System.Data.CommandBehavior behave) [0x0004e] in :0 at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteDataReader..ctor(Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior) at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00006] in :0 at Mono.Data.Sqlite.SqliteCommand.ExecuteDbDataReader (System.Data.CommandBehavior behavior) [0x00000] in :0 at System.Data.Common.DbCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00000] in :0 at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync (System.Data.CommandBehavior behavior, System.Threading.CancellationToken cancellationToken) [0x00049] in :0 --- End of stack trace from previous location where exception was thrown --- at mHub.RT.Library.LocalDBServiceExecutor+d__10.MoveNext () [0x0069b] in :0 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter.GetResult () [0x00000] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at mHub.RT.Library.LocalDBServiceExecutor+<>c__DisplayClass8_0+<b__0>d.MoveNext () [0x0083e] in :0 [8/19/2019 6:52:57 PM] : UnifyXamarinException Occured Message :: SQLite error Insufficient parameters supplied to the command InnerException :: Source :: mscorlib StackTrace :: at Mono.Data.Sqlite.SqliteStatement.BindParameter (System.Int32 index, Mono.Data.Sqlite.SqliteParameter param) [0x0000e] in :0 at Mono.Data.Sqlite.SqliteStatement.BindParameters () [0x00016] in :0 at Mono.Data.Sqlite.SqliteCommand.BuildNextCommand () [0x000d3] in :0 at Mono.Data.Sqlite.SqliteCommand.GetStatement (System.Int32 index) [0x00008] in :0 at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteCommand.GetStatement(int) at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x000b3] in :0 at Mono.Data.Sqlite.SqliteDataReader..ctor (Mono.Data.Sqlite.SqliteCommand cmd, System.Data.CommandBehavior behave) [0x0004e] in :0 at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteDataReader..ctor(Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior) at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00006] in :0 at Mono.Data.Sqlite.SqliteCommand.ExecuteDbDataReader (System.Data.CommandBehavior behavior) [0x00000] in :0 at System.Data.Common.DbCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00000] in :0 at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync (System.Data.CommandBehavior behavior, System.Threading.CancellationToken cancellationToken) [0x00049] in :0 --- End of stack trace from previous location where exception was thrown --- at mHub.RT.Library.LocalDBServiceExecutor+d__10.MoveNext () [0x0069b] in :0 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter.GetResult () [0x00000] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at mHub.RT.Library.LocalDBServiceExecutor+<>c__DisplayClass8_0+<b__0>d.MoveNext () [0x0083e] in :0 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at mHub.UI.AnywherePlugins.SQLitePlugin+d__0.MoveNext () [0x002b9] in <01e3f1a4848e436a80dbe0bc268c0311>:0 [8/19/2019 6:52:57 PM] : { "hdr": { "bgsec": "", "cbid": "423949008", "sts": 9 }, "data": "{\n \"Code\": \"mscorlib\",\n \"Message\": \"SQLite error\\r\\nInsufficient parameters supplied to the command\",\n \"CorrectiveAction\": \"\",\n \"Details\": {}\n}" } [8/19/2019 6:52:57 PM] : Failed to locate callbackHandler for id : 423949008 [8/19/2019 6:52:57 PM] : anywhere.callbackFromNative({ "hdr": { "bgsec": "", "cbid": "423949008", "sts": 9 }, "data": "{\n \"Code\": \"mscorlib\",\n \"Message\": \"SQLite error\\r\\nInsufficient parameters supplied to the command\",\n \"CorrectiveAction\": \"\",\n \"Details\": {}\n}" }); [8/19/2019 6:54:23 PM] : [LDSE.GetQueryListAsync(DBQJ)]New Transaction Started: dtmmains8recordlk [8/19/2019 6:54:23 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=select CASE WHEN coalesce(tlccdm_ship_fee_collect,0)=0 THEN '40005' END as 'error_id' FROM tms_tlccdm_triplog_codcop_collection_dtl_mob WHERE tlccdm_ouinstance = @ctxt_ou AND tlccdm_trip_plan_id = 'TRPL/0016795/1617' AND tlccdm_sequence_no = '1' AND tlccdm_dispatch_doc_no = 'CNN72' [8/19/2019 6:54:23 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=SELECT CASE WHEN count('1') < 1 then '40006' END as 'error_id' from tms_tlcidm_triplog_codcop_instrument_dtl_mob nolock WHERE tlcidm_ouinstance = @ctxt_ou AND tlcidm_trip_plan_id = 'TRPL/0016795/1617' tlcidm_sequence_no = '1' tlcidm_dispatch_doc_no = 'CNN72' coalesce(tlcidm_mode_of_collection,'') = 'Cash' collate nocase [8/19/2019 6:54:23 PM] : [LDSE.FetchResponseFromDb] Exception SQLite error Insufficient parameters supplied to the command [8/19/2019 6:54:23 PM] : [LDSE.GetQueryListAsync(DBQJ)] Exception Exception Occured Message :: SQLite error Insufficient parameters supplied to the command InnerException :: Source :: mscorlib StackTrace :: at Mono.Data.Sqlite.SqliteStatement.BindParameter (System.Int32 index, Mono.Data.Sqlite.SqliteParameter param) [0x0000e] in :0 at Mono.Data.Sqlite.SqliteStatement.BindParameters () [0x00016] in :0 at Mono.Data.Sqlite.SqliteCommand.BuildNextCommand () [0x000d3] in :0 at Mono.Data.Sqlite.SqliteCommand.GetStatement (System.Int32 index) [0x00008] in :0 at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteCommand.GetStatement(int) at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x000b3] in :0 at Mono.Data.Sqlite.SqliteDataReader..ctor (Mono.Data.Sqlite.SqliteCommand cmd, System.Data.CommandBehavior behave) [0x0004e] in :0 at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteDataReader..ctor(Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior) at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00006] in :0 at Mono.Data.Sqlite.SqliteCommand.ExecuteDbDataReader (System.Data.CommandBehavior behavior) [0x00000] in :0 at System.Data.Common.DbCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00000] in :0 at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync (System.Data.CommandBehavior behavior, System.Threading.CancellationToken cancellationToken) [0x00049] in :0 --- End of stack trace from previous location where exception was thrown --- at mHub.RT.Library.LocalDBServiceExecutor+d__10.MoveNext () [0x0069b] in :0 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter.GetResult () [0x00000] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at mHub.RT.Library.LocalDBServiceExecutor+<>c__DisplayClass8_0+<b__0>d.MoveNext () [0x0083e] in :0 [8/19/2019 6:54:23 PM] : UnifyXamarinException Occured Message :: SQLite error Insufficient parameters supplied to the command InnerException :: Source :: mscorlib StackTrace :: at Mono.Data.Sqlite.SqliteStatement.BindParameter (System.Int32 index, Mono.Data.Sqlite.SqliteParameter param) [0x0000e] in :0 at Mono.Data.Sqlite.SqliteStatement.BindParameters () [0x00016] in :0 at Mono.Data.Sqlite.SqliteCommand.BuildNextCommand () [0x000d3] in :0 at Mono.Data.Sqlite.SqliteCommand.GetStatement (System.Int32 index) [0x00008] in :0 at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteCommand.GetStatement(int) at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x000b3] in :0 at Mono.Data.Sqlite.SqliteDataReader..ctor (Mono.Data.Sqlite.SqliteCommand cmd, System.Data.CommandBehavior behave) [0x0004e] in :0 at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteDataReader..ctor(Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior) at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00006] in :0 at Mono.Data.Sqlite.SqliteCommand.ExecuteDbDataReader (System.Data.CommandBehavior behavior) [0x00000] in :0 at System.Data.Common.DbCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00000] in :0 at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync (System.Data.CommandBehavior behavior, System.Threading.CancellationToken cancellationToken) [0x00049] in :0 --- End of stack trace from previous location where exception was thrown --- at mHub.RT.Library.LocalDBServiceExecutor+d__10.MoveNext () [0x0069b] in :0 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter.GetResult () [0x00000] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at mHub.RT.Library.LocalDBServiceExecutor+<>c__DisplayClass8_0+<b__0>d.MoveNext () [0x0083e] in :0 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at mHub.UI.AnywherePlugins.SQLitePlugin+d__0.MoveNext () [0x002b9] in <01e3f1a4848e436a80dbe0bc268c0311>:0 [8/19/2019 6:54:23 PM] : { "hdr": { "bgsec": "", "cbid": "350446906", "sts": 9 }, "data": "{\n \"Code\": \"mscorlib\",\n \"Message\": \"SQLite error\\r\\nInsufficient parameters supplied to the command\",\n \"CorrectiveAction\": \"\",\n \"Details\": {}\n}" } [8/19/2019 6:54:23 PM] : Failed to locate callbackHandler for id : 350446906 [8/19/2019 6:54:23 PM] : anywhere.callbackFromNative({ "hdr": { "bgsec": "", "cbid": "350446906", "sts": 9 }, "data": "{\n \"Code\": \"mscorlib\",\n \"Message\": \"SQLite error\\r\\nInsufficient parameters supplied to the command\",\n \"CorrectiveAction\": \"\",\n \"Details\": {}\n}" }); [8/19/2019 6:55:35 PM] : [LocationTracker.Tracker_timer_Elapsed] GeoTrack Task = dtmmainscfth_GTUPD Starts. [8/19/2019 6:55:35 PM] : [LDSE.GetQueryListAsync(DBQJ)]New Transaction Started: dtmmainscfth_GTUPD [8/19/2019 6:55:35 PM] : [LDSE.UpdateRequestToDb] ExecutingQuery=select strftime("%Y-%m-%d %H:%M:%S", datetime("now","localtime")); [8/19/2019 6:55:35 PM] : [LDSE.UpdateRequestToDb] Resulting RowCount: 0 [8/19/2019 6:55:35 PM] : [LDSE.GetQueryListAsync(DBQJ)] SB = {"status":"service_success"} [8/19/2019 6:55:35 PM] : [LDSE.GetQueryListAsync(DBQJ)] Transaction Succesfully Committed: dtmmainscfth_GTUPD [8/19/2019 6:55:35 PM] : [LocationTracker.Tracker_timer_Elapsed] GeoTrack Task = dtmmainscfth_GTUPD Ends. [8/19/2019 6:56:02 PM] : [LDSE.GetQueryListAsync(DBQJ)]New Transaction Started: dtmmains8recordlk [8/19/2019 6:56:02 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=select CASE WHEN coalesce(tlccdm_ship_fee_collect,0)=0 THEN '40005' END as 'error_id' FROM tms_tlccdm_triplog_codcop_collection_dtl_mob WHERE tlccdm_ouinstance = @ctxt_ou AND tlccdm_trip_plan_id = 'TRPL/0016795/1617' AND tlccdm_sequence_no = '1' AND tlccdm_dispatch_doc_no = 'CNN72' [8/19/2019 6:56:02 PM] : [LDSE.AddPropertiesAsParams]ExecutingQuery=SELECT CASE WHEN count('1') < 1 then '40006' END as 'error_id' from tms_tlcidm_triplog_codcop_instrument_dtl_mob nolock WHERE tlcidm_ouinstance = @ctxt_ou AND tlcidm_trip_plan_id = 'TRPL/0016795/1617' tlcidm_sequence_no = '1' tlcidm_dispatch_doc_no = 'CNN72' coalesce(tlcidm_mode_of_collection,'') = 'Cash' collate nocase [8/19/2019 6:56:02 PM] : [LDSE.FetchResponseFromDb] Exception SQLite error Insufficient parameters supplied to the command [8/19/2019 6:56:02 PM] : [LDSE.GetQueryListAsync(DBQJ)] Exception Exception Occured Message :: SQLite error Insufficient parameters supplied to the command InnerException :: Source :: mscorlib StackTrace :: at Mono.Data.Sqlite.SqliteStatement.BindParameter (System.Int32 index, Mono.Data.Sqlite.SqliteParameter param) [0x0000e] in :0 at Mono.Data.Sqlite.SqliteStatement.BindParameters () [0x00016] in :0 at Mono.Data.Sqlite.SqliteCommand.BuildNextCommand () [0x000d3] in :0 at Mono.Data.Sqlite.SqliteCommand.GetStatement (System.Int32 index) [0x00008] in :0 at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteCommand.GetStatement(int) at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x000b3] in :0 at Mono.Data.Sqlite.SqliteDataReader..ctor (Mono.Data.Sqlite.SqliteCommand cmd, System.Data.CommandBehavior behave) [0x0004e] in :0 at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteDataReader..ctor(Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior) at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00006] in :0 at Mono.Data.Sqlite.SqliteCommand.ExecuteDbDataReader (System.Data.CommandBehavior behavior) [0x00000] in :0 at System.Data.Common.DbCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00000] in :0 at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync (System.Data.CommandBehavior behavior, System.Threading.CancellationToken cancellationToken) [0x00049] in :0 --- End of stack trace from previous location where exception was thrown --- at mHub.RT.Library.LocalDBServiceExecutor+d__10.MoveNext () [0x0069b] in :0 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter.GetResult () [0x00000] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at mHub.RT.Library.LocalDBServiceExecutor+<>c__DisplayClass8_0+<b__0>d.MoveNext () [0x0083e] in :0 [8/19/2019 6:56:02 PM] : UnifyXamarinException Occured Message :: SQLite error Insufficient parameters supplied to the command InnerException :: Source :: mscorlib StackTrace :: at Mono.Data.Sqlite.SqliteStatement.BindParameter (System.Int32 index, Mono.Data.Sqlite.SqliteParameter param) [0x0000e] in :0 at Mono.Data.Sqlite.SqliteStatement.BindParameters () [0x00016] in :0 at Mono.Data.Sqlite.SqliteCommand.BuildNextCommand () [0x000d3] in :0 at Mono.Data.Sqlite.SqliteCommand.GetStatement (System.Int32 index) [0x00008] in :0 at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteCommand.GetStatement(int) at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x000b3] in :0 at Mono.Data.Sqlite.SqliteDataReader..ctor (Mono.Data.Sqlite.SqliteCommand cmd, System.Data.CommandBehavior behave) [0x0004e] in :0 at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteDataReader..ctor(Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior) at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00006] in :0 at Mono.Data.Sqlite.SqliteCommand.ExecuteDbDataReader (System.Data.CommandBehavior behavior) [0x00000] in :0 at System.Data.Common.DbCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00000] in :0 at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync (System.Data.CommandBehavior behavior, System.Threading.CancellationToken cancellationToken) [0x00049] in :0 --- End of stack trace from previous location where exception was thrown --- at mHub.RT.Library.LocalDBServiceExecutor+d__10.MoveNext () [0x0069b] in :0 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter.GetResult () [0x00000] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at mHub.RT.Library.LocalDBServiceExecutor+<>c__DisplayClass8_0+<b__0>d.MoveNext () [0x0083e] in :0 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <7036aaf8bcc342e6a6e9aa28a95c3fd9>:0 at mHub.UI.AnywherePlugins.SQLitePlugin+d__0.MoveNext () [0x002b9] in <01e3f1a4848e436a80dbe0bc268c0311>:0 [8/19/2019 6:56:02 PM] : { "hdr": { "bgsec": "", "cbid": "1725665144", "sts": 9 }, "data": "{\n \"Code\": \"mscorlib\",\n \"Message\": \"SQLite error\\r\\nInsufficient parameters supplied to the command\",\n \"CorrectiveAction\": \"\",\n \"Details\": {}\n}" } [8/19/2019 6:56:02 PM] : Failed to locate callbackHandler for id : 1725665144 [8/19/2019 6:56:02 PM] : anywhere.callbackFromNative({ "hdr": { "bgsec": "", "cbid": "1725665144", "sts": 9 }, "data": "{\n \"Code\": \"mscorlib\",\n \"Message\": \"SQLite error\\r\\nInsufficient parameters supplied to the command\",\n \"CorrectiveAction\": \"\",\n \"Details\": {}\n}" });