05/14/2020 03:09:36 PM WS_FINISHCALL Parameters: [route:4203][binsOnSite:0][driver:59][endOdom:40509][routeDate:2020-05-14][companyCode:RW][activity:DR][qty:1.0][startOdom:40506][endTime:2020-05-14 14:34:08][logid:660921][doCM05Adjustment:0][newServ:6][startTime:2020-05-14 14:01:35][truck:223] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (660921). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:bb14f0df-14e6-4110-9fd2-365c8daa6bd1 Error Number:2627,State:1,Class:14 05/15/2020 02:03:28 PM WS_FINISHCALL Parameters: [route:5203][binsOnSite:0][driver:59][endOdom:40652][routeDate:2020-05-15][companyCode:RW][activity:DR][qty:1.0][startOdom:40650][endTime:2020-05-15 13:21:01][logid:661539][doCM05Adjustment:0][newServ:6][startTime:2020-05-15 12:44:06][truck:223] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (661539). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:b4942dc9-5767-47f9-a69a-71fe9bd1d6e7 Error Number:2627,State:1,Class:14 05/19/2020 02:32:05 PM WS_FINISHCALL Parameters: [route:2205][binsOnSite:0][driver:48][endOdom:142815][routeDate:2020-05-19][companyCode:RW][activity:DR][qty:1.0][startOdom:142803][endTime:2020-05-19 14:12:13][logid:661650][doCM05Adjustment:0][newServ:2][startTime:2020-05-19 13:13:57][truck:218] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (661650). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:98a140d7-a7cd-4692-ac0a-82c6047ee324 Error Number:2627,State:1,Class:14 05/20/2020 09:15:51 AM WS_FINISHCALL Parameters: [route:3206][binsOnSite:0][driver:6][endOdom:58728][routeDate:2020-05-20][companyCode:RW][activity:DR][qty:1.0][startOdom:58721][endTime:2020-05-20 09:15:41][logid:663603][doCM05Adjustment:0][newServ:1][startTime:2020-05-20 08:32:10][truck:222] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (663603). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:c53c781a-a958-40c5-b35d-5cb76694182d Error Number:2627,State:1,Class:14 05/20/2020 11:41:14 AM WS_FINISHCALL Parameters: [route:3306][binsOnSite:0][driver:71][endOdom:29859][routeDate:2020-05-20][companyCode:RW][activity:SS][qty:1.0][startOdom:29853][endTime:2020-05-20 11:40:56][logid:665382][doCM05Adjustment:0][newServ:1][startTime:2020-05-20 10:16:18][truck:313] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (665382). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:ce38bc50-0d0f-4f09-8419-d677454ffc53 Error Number:2627,State:1,Class:14 05/21/2020 11:46:09 AM WS_FINISHCALL Parameters: [route:4206][binsOnSite:0][driver:6][endOdom:58957][routeDate:2020-05-21][companyCode:RW][activity:SW][qty:1.0][startOdom:58944][endTime:2020-05-21 11:46:04][logid:663604][doCM05Adjustment:0][newServ:1][startTime:2020-05-21 10:55:14][truck:222] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (663604). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:1ca2d5a1-1eb6-4f81-9167-36d131b7c6ab Error Number:2627,State:1,Class:14 05/21/2020 02:35:44 PM WS_SAVECALLSIGNATURE Parameters: [signer:][logid:665527][companyCode:RW][signTime:2020/05/21 14:34:41] System.NullReferenceException: Object reference not set to an instance of an object. at WSRouting.WSRout_Android.WS_Android.WS_SAVECALLSIGNATURE(String logid, String companyCode, String signTime, String image, String signer) 05/21/2020 02:51:11 PM WS_FINISHCALL Parameters: [route:4215][binsOnSite:0][driver:15][endOdom:85376][routeDate:2020-05-21][companyCode:RW][activity:DR][qty:1.0][startOdom:85373][endTime:2020-05-21 14:34:15][logid:666464][doCM05Adjustment:0][newServ:3][startTime:2020-05-21 13:37:40][truck:219] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (666464). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:9a402860-d324-40a0-894f-c5c639379c99 Error Number:2627,State:1,Class:14 05/22/2020 10:15:59 AM WS_FINISHCALL Parameters: [route:5203][binsOnSite:0][driver:59][endOdom:41510][routeDate:2020-05-22][companyCode:RW][activity:DR][qty:2.0][startOdom:41479][endTime:2020-05-22 10:15:45][logid:666381][doCM05Adjustment:0][newServ:1][startTime:2020-05-22 09:20:10][truck:223] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (666381). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:2116f818-61b5-41ff-8fec-b0959cc12795 Error Number:2627,State:1,Class:14 05/22/2020 10:44:22 AM WS_FINISHCALL Parameters: [route:5206][binsOnSite:0][driver:6][endOdom:59125][routeDate:2020-05-22][companyCode:RW][activity:SW][qty:1.0][startOdom:59115][endTime:2020-05-22 10:44:19][logid:663605][doCM05Adjustment:0][newServ:1][startTime:2020-05-22 09:53:03][truck:222] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (663605). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:a187ca2a-2a85-4783-a8cb-eaa692fd6d7f Error Number:2627,State:1,Class:14 05/26/2020 09:55:41 AM WS_FINISHCALL Parameters: [route:2210][binsOnSite:0][driver:60][endOdom:483390][routeDate:2020-05-26][companyCode:RW][activity:DR][qty:1.0][startOdom:483369][endTime:2020-05-26 08:52:38][logid:667203][doCM05Adjustment:0][newServ:4][startTime:2020-05-26 07:27:10][truck:207] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (667203). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:4e75c313-170e-4ddf-a285-11d864ec5e96 Error Number:2627,State:1,Class:14 05/26/2020 03:36:29 PM WS_FINISHCALL Parameters: [route:2204][binsOnSite:0][driver:33][endOdom:180403][routeDate:2020-05-26][companyCode:RW][activity:DL][qty:1.0][startOdom:180382][endTime:2020-05-26 15:11:21][logid:666492][doCM05Adjustment:0][newServ:1][startTime:2020-05-26 14:40:33][truck:216] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (666492). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:132e9fbd-2693-431e-972b-0aa1d776a22f Error Number:2627,State:1,Class:14 05/27/2020 08:21:24 AM WS_SAVECUSTOMERSERVICEISSUE Parameters: [subject:no morning can][logid:667204][currentTime:2020-05-27 07:59:00][customerServiceIssueType:01][companyCode:RW][details:they called and said they didn't want the morning dump. didn't get the message until I already arrived with a swap can. had to take can back to Layton byard. ][driver:49] Couldn't find Customer for call 667204 05/27/2020 10:28:23 AM WS_FINISHCALL Parameters: [route:3215][binsOnSite:0][driver:15][endOdom:85578][routeDate:2020-05-27][companyCode:RW][activity:CK][qty:1.0][startOdom:85577][endTime:2020-05-27 09:55:33][logid:668889][doCM05Adjustment:0][newServ:1][startTime:2020-05-27 09:54:29][truck:219] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (668889). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:d620145a-4483-4508-995d-d079cacb1b8d Error Number:2627,State:1,Class:14 05/27/2020 12:53:05 PM WS_SAVECALLSIGNATURE Parameters: [signer:][logid:668838][companyCode:RW][signTime:2020/05/27 12:53:05] System.NullReferenceException: Object reference not set to an instance of an object. at WSRouting.WSRout_Android.WS_Android.WS_SAVECALLSIGNATURE(String logid, String companyCode, String signTime, String image, String signer) 05/27/2020 03:10:09 PM WS_SAVEDISPOSAL Parameters: [ticketNumber:3307403][saveTime:05/27/2020][endTime:05/27/2020 15:10][bol:][startTime:05/27/2020 15:10][route:3302][logid:-1][facilityCode:01][materials:~0][routeDate:05/27/2020][companyCode:RW] System.NullReferenceException: Object reference not set to an instance of an object. at WSRouting.WSRout_Android.WS_Android.WS_SAVEDISPOSAL(String ticketNumber, String facilityCode, String logid, String startTime, String endTime, String routeDate, String saveTime, String route, String[] materials, String companyCode, String bol) 05/28/2020 10:15:55 AM WS_FINISHCALL Parameters: [route:4212][binsOnSite:0][driver:4][endOdom:418620][routeDate:2020-05-28][companyCode:RW][activity:DR][qty:1.0][startOdom:418615][endTime:2020-05-28 09:58:03][logid:669738][doCM05Adjustment:0][newServ:1][startTime:2020-05-28 09:29:08][truck:213] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (669738). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:263ea789-6d2e-4690-aa72-506b7594c7f9 Error Number:2627,State:1,Class:14 05/29/2020 08:55:27 AM WS_FINISHCALL Parameters: [route:5215][binsOnSite:0][driver:15][endOdom:85807][routeDate:2020-05-29][companyCode:RW][activity:CK][qty:1.0][startOdom:85807][endTime:2020-05-29 08:15:07][logid:670611][doCM05Adjustment:0][newServ:2][startTime:2020-05-29 08:15:01][truck:219] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (670611). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:f7bff390-4572-4592-841f-3ab297d2bd67 Error Number:2627,State:1,Class:14 05/29/2020 09:56:10 AM WS_FINISHCALL Parameters: [route:5215][binsOnSite:0][driver:15][endOdom:85820][routeDate:2020-05-29][companyCode:RW][activity:DR][qty:1.0][startOdom:85808][endTime:2020-05-29 09:15:02][logid:670612][doCM05Adjustment:0][newServ:2][startTime:2020-05-29 08:20:29][truck:219] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (670612). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:5903357b-2aa6-4228-8e64-2ffaa6b64502 Error Number:2627,State:1,Class:14 05/29/2020 01:43:59 PM WS_FINISHCALL Parameters: [route:5207][binsOnSite:0][driver:49][endOdom:456895][routeDate:2020-05-29][companyCode:RW][activity:DL][qty:1.0][startOdom:456888][endTime:2020-05-29 13:43:42][logid:670703][doCM05Adjustment:0][newServ:4][startTime:2020-05-29 13:21:26][truck:214] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (670703). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:2cfe2d38-7543-4cf7-a95f-11ae269de44f Error Number:2627,State:1,Class:14 06/02/2020 03:21:07 PM WS_FINISHCALL Parameters: [route:2215][binsOnSite:0][driver:15][endOdom:86187][routeDate:2020-06-02][companyCode:RW][activity:DR][qty:1.0][startOdom:86175][endTime:2020-06-02 14:39:39][logid:673082][doCM05Adjustment:0][newServ:5][startTime:2020-06-02 13:14:07][truck:219] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (673082). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:d444e613-f144-4d9e-8adf-84d7e35fcc8a Error Number:2627,State:1,Class:14 06/10/2020 11:29:58 AM WS_FINISHCALL Parameters: [route:3207][binsOnSite:0][driver:49][endOdom:458229][routeDate:2020-06-10][companyCode:RW][activity:DR][qty:1.0][startOdom:458206][endTime:2020-06-10 11:05:29][logid:677309][doCM05Adjustment:0][newServ:1][startTime:2020-06-10 09:45:26][truck:214] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (677309). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:65080acb-4e45-4f08-b250-269568eec382 Error Number:2627,State:1,Class:14 06/11/2020 06:47:59 AM WS_SAVEDISPOSAL Parameters: [ticketNumber:3318982][saveTime:06/09/2020][endTime:06/09/2020 12:50][bol:][startTime:06/09/2020 12:50][route:2304][logid:-1][facilityCode:01][materials:MS~11.68][routeDate:06/09/2020][companyCode:RW] route doesn't exist?? 06/11/2020 09:46:35 AM WS_FINISHCALL Parameters: [route:4215][binsOnSite:0][driver:15][endOdom:243644][routeDate:2020-06-11][companyCode:RW][activity:CK][qty:1.0][startOdom:243644][endTime:2020-06-11 09:04:59][logid:678215][doCM05Adjustment:0][newServ:1][startTime:2020-06-11 09:04:53][truck:215] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (678215). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:2639f606-c929-403b-b1e5-9ba6d23726f1 Error Number:2627,State:1,Class:14 06/11/2020 12:44:42 PM WS_FINISHCALL Parameters: [route:4304][binsOnSite:0][driver:73][endOdom:94305][routeDate:2020-06-11][companyCode:RW][activity:SS][qty:1.0][startOdom:94305][endTime:2020-06-11 11:33:23][logid:678638][doCM05Adjustment:0][newServ:1][startTime:2020-06-11 11:32:13][truck:314] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (678638). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:03f5e05d-d831-4901-b527-4f532e7a044d Error Number:2627,State:1,Class:14 06/11/2020 03:37:16 PM WS_FINISHCALL Parameters: [route:4201][binsOnSite:0][driver:45][endOdom:243510][routeDate:2020-06-11][companyCode:RW][activity:DR][qty:1.0][startOdom:243507][endTime:2020-06-11 15:11:53][logid:679145][doCM05Adjustment:0][newServ:4][startTime:2020-06-11 14:24:30][truck:217] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (679145). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:cf719a7d-9e83-4014-97d4-c9c3f2fd4346 Error Number:2627,State:1,Class:14 06/12/2020 08:51:25 AM WS_FINISHCALL Parameters: [route:5215][binsOnSite:0][driver:15][endOdom:86817][routeDate:2020-06-12][companyCode:RW][activity:DR][qty:1.0][startOdom:86806][endTime:2020-06-12 08:21:02][logid:679084][doCM05Adjustment:0][newServ:4][startTime:2020-06-12 07:30:39][truck:219] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (679084). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:3bc61106-cac3-4bec-bfd4-331d9ab883b2 Error Number:2627,State:1,Class:14 06/12/2020 09:51:26 AM WS_FINISHCALL Parameters: [route:5208][binsOnSite:0][driver:50][endOdom:243322][routeDate:2020-06-12][companyCode:RW][activity:FN][qty:1.0][startOdom:243311][endTime:2020-06-12 08:59:42][logid:679192][doCM05Adjustment:0][newServ:2][startTime:2020-06-12 08:15:54][truck:209] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (679192). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:a61fb159-4d28-471e-9e9f-06978bc64ad8 Error Number:2627,State:1,Class:14 06/15/2020 11:58:49 AM WS_FINISHCALL Parameters: [route:1214][binsOnSite:0][driver:1][endOdom:110554][routeDate:2020-06-15][companyCode:RW][activity:DR][qty:1.0][startOdom:110542][endTime:2020-06-15 11:48:30][logid:679836][doCM05Adjustment:0][newServ:1][startTime:2020-06-15 10:54:40][truck:220] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (679836). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:7dfca513-b010-4045-9a45-6d585e20a4bc Error Number:2627,State:1,Class:14 06/15/2020 02:42:57 PM WS_FINISHCALL Parameters: [route:1215][binsOnSite:0][driver:15][endOdom:86991][routeDate:2020-06-15][companyCode:RW][activity:FN][qty:1.0][startOdom:86986][endTime:2020-06-15 14:42:38][logid:679934][doCM05Adjustment:0][newServ:1][startTime:2020-06-15 14:20:12][truck:219] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (679934). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:b3c1d512-95ed-4a93-9ab5-37be7be4a8da Error Number:2627,State:1,Class:14 06/15/2020 02:55:08 PM WS_FINISHCALL Parameters: [route:1208][binsOnSite:0][driver:7][endOdom:625312][routeDate:2020-06-15][companyCode:RW][activity:FN][qty:1.0][startOdom:625292][endTime:2020-06-15 14:16:44][logid:679929][doCM05Adjustment:0][newServ:1][startTime:2020-06-15 13:13:19][truck:208] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (679929). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:d9f1429d-d7b4-42cb-95c2-0caa74f76c74 Error Number:2627,State:1,Class:14 06/16/2020 03:23:44 PM WS_FINISHCALL Parameters: [route:2206][binsOnSite:0][driver:6][endOdom:62327][routeDate:2020-06-16][companyCode:RW][activity:DR][qty:1.0][startOdom:62315][endTime:2020-06-16 14:51:28][logid:681640][doCM05Adjustment:0][newServ:1][startTime:2020-06-16 13:58:44][truck:222] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (681640). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:5a04056f-e316-4a67-85ef-e2ffb17d5d07 Error Number:2627,State:1,Class:14 06/17/2020 10:10:06 AM WS_SAVECUSTOMERSERVICEISSUE Parameters: [subject:changed schedule ][logid:681686][currentTime:2020-06-17 10:10:05][customerServiceIssueType:01][companyCode:RW][details:][driver:59] Couldn't find Customer for call 681686 06/17/2020 10:10:11 AM WS_SAVECALLSIGNATURE Parameters: [signer:][logid:681686][companyCode:RW][signTime:2020/06/17 10:10:09] System.NullReferenceException: Object reference not set to an instance of an object. at WSRouting.WSRout_Android.WS_Android.WS_SAVECALLSIGNATURE(String logid, String companyCode, String signTime, String image, String signer) 06/18/2020 10:28:38 AM WS_GETCALLSONROUTE Parameters: [route:4201][truck:217][excludedLogids:][companyCode:RW][date:06/18/2020] Logid 682457 doesn't exist in the trux database. Proceeding to delete the record. 06/19/2020 09:55:10 AM WS_FINISHCALL Parameters: [route:5212][binsOnSite:0][driver:4][endOdom:421439][routeDate:2020-06-19][companyCode:RW][activity:DR][qty:1.0][startOdom:421431][endTime:2020-06-19 08:59:23][logid:683349][doCM05Adjustment:0][newServ:4][startTime:2020-06-19 07:56:37][truck:213] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (683349). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:1a47c303-ff0d-4993-8668-4fc43082b5cb Error Number:2627,State:1,Class:14 06/19/2020 02:09:32 PM WS_FINISHCALL Parameters: [route:5205][binsOnSite:0][driver:48][endOdom:145777][routeDate:2020-06-19][companyCode:RW][activity:FN][qty:1.0][startOdom:145765][endTime:2020-06-19 14:09:20][logid:684197][doCM05Adjustment:0][newServ:3][startTime:2020-06-19 13:00:06][truck:218] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (684197). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:70b3e585-0ca5-40e7-a4b5-074ddd4e0f4c Error Number:2627,State:1,Class:14 06/22/2020 10:50:12 AM WS_FINISHCALL Parameters: [route:1215][binsOnSite:0][driver:15][endOdom:87642][routeDate:2020-06-22][companyCode:RW][activity:CK][qty:1.0][startOdom:87641][endTime:2020-06-22 10:14:05][logid:684184][doCM05Adjustment:0][newServ:1][startTime:2020-06-22 10:12:50][truck:219] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (684184). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:99e2d512-c1ca-47d4-8272-2dd0dee53d2a Error Number:2627,State:1,Class:14 06/22/2020 02:45:19 PM WS_FINISHCALL Parameters: [route:1210][binsOnSite:0][driver:7][endOdom:244196][routeDate:2020-06-22][companyCode:RW][activity:SW][qty:1.0][startOdom:244163][endTime:2020-06-22 13:49:45][logid:685072][doCM05Adjustment:0][newServ:1][startTime:2020-06-22 12:14:36][truck:215] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (685072). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:f489216c-22b9-46e0-a78c-c3da666411aa Error Number:2627,State:1,Class:14 06/23/2020 08:59:25 AM WS_FINISHCALL Parameters: [route:2214][binsOnSite:0][driver:1][endOdom:111478][routeDate:2020-06-23][companyCode:RW][activity:CK][qty:1.0][startOdom:111478][endTime:2020-06-23 07:34:33][logid:685163][doCM05Adjustment:0][newServ:5][startTime:2020-06-23 07:34:28][truck:220] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (685163). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:44b35210-c49a-4024-a2f6-0684a8537f0b Error Number:2627,State:1,Class:14 06/24/2020 09:51:07 AM WS_FINISHCALL Parameters: [route:3208][binsOnSite:0][driver:50][endOdom:243894][routeDate:2020-06-24][companyCode:RW][activity:DL][qty:1.0][startOdom:243887][endTime:2020-06-24 09:12:01][logid:685995][doCM05Adjustment:0][newServ:2][startTime:2020-06-24 08:52:51][truck:209] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (685995). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:70061fcf-92e3-42cb-93aa-c66edfbfbc4c Error Number:2627,State:1,Class:14 06/24/2020 10:34:51 AM WS_FINISHCALL Parameters: [route:3210][binsOnSite:0][driver:60][endOdom:485933][routeDate:2020-06-24][companyCode:RW][activity:DR][qty:1.0][startOdom:485928][endTime:2020-06-24 10:34:46][logid:686099][doCM05Adjustment:0][newServ:1][startTime:2020-06-24 10:13:42][truck:207] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (686099). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:dbac26ce-6f30-4837-a43f-335c0b28c124 Error Number:2627,State:1,Class:14 06/26/2020 09:33:49 AM WS_FINISHCALL Parameters: [route:5208][binsOnSite:0][driver:7][endOdom:244052][routeDate:2020-06-26][companyCode:RW][activity:DL][qty:1.0][startOdom:244046][endTime:2020-06-26 09:16:46][logid:688490][doCM05Adjustment:0][newServ:1][startTime:2020-06-26 08:55:53][truck:209] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (688490). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:ea291927-a563-46fa-8e56-931e71a9d927 Error Number:2627,State:1,Class:14 06/26/2020 12:38:28 PM SAVE_IMAGE Parameters: [sql:INSERT INTO SC01P(SC01P_CALL,SC01P_FILE,SC01P_FILENAME) VALUES(1, @file, @name)][companyCode:RW][mustSaveInDB:False] System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SC01P_SC01". The conflict occurred in database "TRUX_RW_COMP", table "dbo.sc01", column 'SC01_CALL'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at WSRouting.WSRout_Android.WS_Android.SaveImage(String companyCode, String image, String sql, Boolean mustSaveInDB) ClientConnectionId:b37bd80f-dda8-4254-9b42-7eec1920d8d8 Error Number:547,State:0,Class:16 06/26/2020 02:29:49 PM WS_SAVEDISPOSAL Parameters: [ticketNumber:3333630][saveTime:06/26/2020][endTime:06/26/2020 14:06][bol:][startTime:06/26/2020 14:06][route:5204][logid:687850][facilityCode:01][materials:CD~4.76][routeDate:06/26/2020][companyCode:RW] duplicate facility-ticketNumber-material combo found 06/26/2020 02:29:50 PM WS_FINISHCALL Parameters: [route:5204][binsOnSite:0][driver:33][endOdom:183319][routeDate:2020-06-26][companyCode:RW][activity:FN][qty:1.0][startOdom:183302][endTime:2020-06-26 14:29:29][logid:687850][doCM05Adjustment:0][newServ:2][startTime:2020-06-26 12:36:47][truck:216] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (687850). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:ded05a34-e8fd-468a-ab40-1c22b3f0974d Error Number:2627,State:1,Class:14 06/29/2020 07:16:06 AM WS_FINISHCALL Parameters: [route:1215][binsOnSite:0][driver:15][endOdom:88148][routeDate:2020-06-29][companyCode:RW][activity:CK][qty:1.0][startOdom:88148][endTime:2020-06-29 06:28:06][logid:688621][doCM05Adjustment:0][newServ:1][startTime:2020-06-29 06:27:01][truck:219] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (688621). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:97e79a03-1fd3-4bf5-b492-018cd3104970 Error Number:2627,State:1,Class:14 06/29/2020 10:47:16 AM WS_FINISHCALL Parameters: [route:1210][binsOnSite:0][driver:60][endOdom:486304][routeDate:2020-06-29][companyCode:RW][activity:CK][qty:1.0][startOdom:486304][endTime:2020-06-29 10:09:50][logid:688588][doCM05Adjustment:0][newServ:1][startTime:2020-06-29 10:09:42][truck:207] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (688588). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:176ed9cc-f632-462c-98cd-1f2e6c1b7e6f Error Number:2627,State:1,Class:14 06/29/2020 03:15:12 PM WS_FINISHCALL Parameters: [route:1210][binsOnSite:0][driver:60][endOdom:486378][routeDate:2020-06-29][companyCode:RW][activity:DR][qty:1.0][startOdom:486353][endTime:2020-06-29 15:15:09][logid:689419][doCM05Adjustment:0][newServ:1][startTime:2020-06-29 13:59:08][truck:207] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (689419). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:25dfb924-dad6-4a11-b877-79e1beb955ea Error Number:2627,State:1,Class:14 07/01/2020 03:22:46 AM WS_SAVEDISPOSAL Parameters: [ticketNumber:3336446][saveTime:06/30/2020][endTime:06/30/2020 14:05][bol:][startTime:06/30/2020 14:05][route:2307][logid:-1][facilityCode:01][materials:MS~3.14][routeDate:06/30/2020][companyCode:RW] route doesn't exist?? 07/01/2020 08:33:03 AM WS_FINISHCALL Parameters: [route:3208][binsOnSite:0][driver:50][endOdom:244148][routeDate:2020-07-01][companyCode:RW][activity:DR][qty:1.0][startOdom:244136][endTime:2020-07-01 08:10:33][logid:691096][doCM05Adjustment:0][newServ:1][startTime:2020-07-01 07:28:03][truck:209] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (691096). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:8aeb6549-7fad-4f83-95f3-fc247c4e97a5 Error Number:2627,State:1,Class:14 07/01/2020 03:05:18 PM WS_FINISHCALL Parameters: [route:3208][binsOnSite:0][driver:50][endOdom:244260][routeDate:2020-07-01][companyCode:RW][activity:FN][qty:1.0][startOdom:244251][endTime:2020-07-01 14:51:57][logid:691211][doCM05Adjustment:0][newServ:1][startTime:2020-07-01 14:10:09][truck:209] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (691211). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:40adbaf6-aa36-4c96-8a7d-5b2d3d17f985 Error Number:2627,State:1,Class:14 07/02/2020 05:53:22 AM WS_FINISHCALL Parameters: [route:3204][binsOnSite:0][driver:33][endOdom:183737][routeDate:2020-07-01][companyCode:RW][activity:SS][qty:1.0][startOdom:183726][endTime:2020-07-01 14:42:49][logid:690378][doCM05Adjustment:0][newServ:1][startTime:2020-07-01 13:29:50][truck:216] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (690378). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:48018e4d-428f-4c23-afea-c4161f7a6c1f Error Number:2627,State:1,Class:14 07/02/2020 07:21:48 AM WS_SAVEDISPOSAL Parameters: [ticketNumber:333 yuh 237][saveTime:06/30/2020][endTime:06/30/2020 12:28][bol:][startTime:06/30/2020 12:28][route:2304][logid:-1][facilityCode:01][materials:MS~6.86][routeDate:06/30/2020][companyCode:RW] route doesn't exist?? 07/02/2020 07:21:48 AM WS_SAVEDISPOSAL Parameters: [ticketNumber:3336331][saveTime:06/30/2020][endTime:06/30/2020 12:28][bol:][startTime:06/30/2020 12:28][route:2304][logid:-1][facilityCode:01][materials:MS~3.42][routeDate:06/30/2020][companyCode:RW] route doesn't exist?? 07/06/2020 10:32:48 AM WS_SAVEDISPOSAL Parameters: [ticketNumber:709618][saveTime:07/06/2020][endTime:07/06/2020 09:59][bol:][startTime:07/06/2020 09:51][route:1201][logid:693529][facilityCode:14][materials:~0,CD~3.08][routeDate:07/06/2020][companyCode:RW] System.NullReferenceException: Object reference not set to an instance of an object. at WSRouting.WSRout_Android.WS_Android.WS_SAVEDISPOSAL(String ticketNumber, String facilityCode, String logid, String startTime, String endTime, String routeDate, String saveTime, String route, String[] materials, String companyCode, String bol) 07/08/2020 03:30:09 AM WS_LOGIN Parameters: [route:3303][apkVersion:7.19.0001.02][companyCode:RW][odom:188008][routeDate:07/08/2020][truck:310][time:03:30:08][currentDate:07/08/2020][driver:3] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_FL09'. Cannot insert duplicate key in object 'dbo.FL09'. The duplicate key value is (Jul 8 2020 3:30AM, 3, 310). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_LOGIN(String routeDate, String currentDate, String time, String truck, String driver, String route, String odom, String companyCode, String apkVersion) ClientConnectionId:56172803-acd1-4557-8284-b6c91ee929e8 Error Number:2627,State:1,Class:14 07/09/2020 12:16:37 PM WS_FINISHCALL Parameters: [route:4203][binsOnSite:0][driver:59][endOdom:46667][routeDate:2020-07-09][companyCode:RW][activity:DR][qty:1.0][startOdom:46667][endTime:2020-07-09 11:41:00][logid:695337][doCM05Adjustment:0][newServ:10][startTime:2020-07-09 11:40:17][truck:223] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (695337). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:fc874dd9-f3e2-4b08-8f84-ec393fe8722c Error Number:2627,State:1,Class:14 07/13/2020 01:05:20 PM WS_SAVEDISPOSAL Parameters: [ticketNumber:3345956][saveTime:07/13/2020][endTime:07/13/2020 13:05][bol:][startTime:07/13/2020 13:05][route:1306][logid:-1][facilityCode:01][materials:~0][routeDate:07/13/2020][companyCode:RW] System.NullReferenceException: Object reference not set to an instance of an object. at WSRouting.WSRout_Android.WS_Android.WS_SAVEDISPOSAL(String ticketNumber, String facilityCode, String logid, String startTime, String endTime, String routeDate, String saveTime, String route, String[] materials, String companyCode, String bol) 07/14/2020 09:00:11 AM WS_LOGIN Parameters: [route:2304][apkVersion:7.19.0001.02][companyCode:RW][odom:96121][routeDate:07/14/2020][truck:314][time:09:00:11][currentDate:07/14/2020][driver:73] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_FL09'. Cannot insert duplicate key in object 'dbo.FL09'. The duplicate key value is (Jul 14 2020 9:00AM, 73, 314). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_LOGIN(String routeDate, String currentDate, String time, String truck, String driver, String route, String odom, String companyCode, String apkVersion) ClientConnectionId:5b1b87ba-968e-418d-b714-f05bb31f6b5c Error Number:2627,State:1,Class:14 07/14/2020 09:19:13 AM WS_FINISHCALL Parameters: [route:2215][binsOnSite:0][driver:15][endOdom:89360][routeDate:2020-07-14][companyCode:RW][activity:CK][qty:1.0][startOdom:89360][endTime:2020-07-14 08:39:42][logid:697986][doCM05Adjustment:0][newServ:2][startTime:2020-07-14 08:39:36][truck:219] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (697986). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:a70f5ab8-19dc-46e2-a7b4-5b27635aed32 Error Number:2627,State:1,Class:14 07/14/2020 09:57:45 AM WS_FINISHCALL Parameters: [route:2211][binsOnSite:0][driver:19][endOdom:211887][routeDate:2020-07-14][companyCode:RW][activity:DR][qty:1.0][startOdom:211876][endTime:2020-07-14 08:39:01][logid:697952][doCM05Adjustment:0][newServ:9][startTime:2020-07-14 07:54:49][truck:221] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (697952). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:cb148850-8bb6-4a97-b2ed-f5715104625a Error Number:2627,State:1,Class:14 07/14/2020 10:51:27 AM WS_FINISHCALL Parameters: [route:2208][binsOnSite:0][driver:50][endOdom:244797][routeDate:2020-07-14][companyCode:RW][activity:DR][qty:1.0][startOdom:244791][endTime:2020-07-14 10:15:27][logid:698005][doCM05Adjustment:0][newServ:1][startTime:2020-07-14 09:50:22][truck:209] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (698005). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:3824b8f4-0d9b-4d46-a1c7-fd3454dccb7a Error Number:2627,State:1,Class:14 07/16/2020 04:42:57 PM WS_FINISHCALL Parameters: [route:4201][binsOnSite:0][driver:8][endOdom:247254][routeDate:2020-07-16][companyCode:RW][activity:RL][qty:1.0][startOdom:247251][endTime:2020-07-16 16:12:50][logid:699701][doCM05Adjustment:0][newServ:1][startTime:2020-07-16 15:56:20][truck:217] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (699701). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:bd882ca1-3c33-4730-9617-1f236a09189c Error Number:2627,State:1,Class:14 07/17/2020 03:18:34 PM WS_FINISHCALL Parameters: [route:5205][binsOnSite:0][driver:48][endOdom:148227][routeDate:2020-07-17][companyCode:RW][activity:DR][qty:1.0][startOdom:148219][endTime:2020-07-17 14:47:49][logid:701945][doCM05Adjustment:0][newServ:2][startTime:2020-07-17 13:58:35][truck:218] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (701945). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:ea051600-c6c8-4f45-97d8-03c7882fd7c1 Error Number:2627,State:1,Class:14 07/20/2020 08:13:30 AM WS_FINISHCALL Parameters: [route:1208][binsOnSite:0][driver:50][endOdom:245126][routeDate:2020-07-20][companyCode:RW][activity:DR][qty:1.0][startOdom:245123][endTime:2020-07-20 07:50:41][logid:701956][doCM05Adjustment:0][newServ:1][startTime:2020-07-20 07:25:50][truck:209] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (701956). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:71894020-6ad1-4234-8ecd-525548924aff Error Number:2627,State:1,Class:14 07/20/2020 08:25:08 AM WS_FINISHCALL Parameters: [route:1208][binsOnSite:0][driver:50][endOdom:245126][routeDate:2020-07-20][companyCode:RW][activity:DR][qty:1.0][startOdom:245123][endTime:2020-07-20 07:50:41][logid:701956][doCM05Adjustment:0][newServ:1][startTime:2020-07-20 07:25:50][truck:209] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (701956). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:d937fa3f-4dd1-4572-bbd8-fa7c5f7ac31c Error Number:2627,State:1,Class:14 07/20/2020 02:01:58 PM WS_FINISHCALL Parameters: [route:1204][binsOnSite:0][driver:33][endOdom:185497][routeDate:2020-07-20][companyCode:RW][activity:SW][qty:1.0][startOdom:185460][endTime:2020-07-20 13:07:01][logid:702786][doCM05Adjustment:0][newServ:1][startTime:2020-07-20 11:48:59][truck:216] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (702786). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:9751408e-e66f-4c74-bce6-03b0122819b7 Error Number:2627,State:1,Class:14 07/21/2020 07:34:11 AM WS_FINISHCALL Parameters: [route:2208][binsOnSite:0][driver:50][endOdom:458798][routeDate:2020-07-21][companyCode:RW][activity:DR][qty:1.0][startOdom:458783][endTime:2020-07-21 06:58:20][logid:701968][doCM05Adjustment:0][newServ:1][startTime:2020-07-21 06:00:17][truck:203] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (701968). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:597b3188-70e6-47db-a672-d468310734c1 Error Number:2627,State:1,Class:14 07/21/2020 03:37:17 PM WS_FINISHCALL Parameters: [route:2201][binsOnSite:0][driver:8][endOdom:247873][routeDate:2020-07-21][companyCode:RW][activity:DR][qty:1.0][startOdom:247857][endTime:2020-07-21 15:09:21][logid:702904][doCM05Adjustment:0][newServ:1][startTime:2020-07-21 14:05:35][truck:217] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (702904). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:017732c2-e6ba-4b44-ab16-b197c900e2e2 Error Number:2627,State:1,Class:14 07/23/2020 01:59:13 PM WS_FINISHCALL Parameters: [route:4207][binsOnSite:0][driver:49][endOdom:461724][routeDate:2020-07-23][companyCode:RW][activity:DR][qty:1.0][startOdom:461719][endTime:2020-07-23 13:59:12][logid:705514][doCM05Adjustment:0][newServ:1][startTime:2020-07-23 13:34:08][truck:214] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (705514). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:28874a38-2a8c-4db9-84fc-47a89a6c7bfc Error Number:2627,State:1,Class:14 07/28/2020 08:17:33 AM WS_FINISHCALL Parameters: [route:2207][binsOnSite:0][driver:49][endOdom:462159][routeDate:2020-07-28][companyCode:RW][activity:FN][qty:1.0][startOdom:462127][endTime:2020-07-28 07:39:11][logid:706272][doCM05Adjustment:0][newServ:15][startTime:2020-07-28 06:06:41][truck:214] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (706272). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:68e92e10-2342-480d-91a8-e4f141ab4b42 Error Number:2627,State:1,Class:14 07/29/2020 09:53:06 AM WS_FINISHCALL Parameters: [route:3204][binsOnSite:0][driver:33][endOdom:186286][routeDate:2020-07-29][companyCode:RW][activity:DR][qty:1.0][startOdom:186269][endTime:2020-07-29 08:36:11][logid:708829][doCM05Adjustment:0][newServ:1][startTime:2020-07-29 07:17:44][truck:216] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (708829). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:0f40270e-0927-4843-ac0f-6c4dbceaf93b Error Number:2627,State:1,Class:14 07/29/2020 12:16:22 PM WS_FINISHCALL Parameters: [route:3214][binsOnSite:0][driver:1][endOdom:115115][routeDate:2020-07-29][companyCode:RW][activity:DR][qty:1.0][startOdom:115114][endTime:2020-07-29 11:24:24][logid:708095][doCM05Adjustment:0][newServ:6][startTime:2020-07-29 10:41:29][truck:220] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (708095). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:54dd21fe-ee75-4ce3-a8f3-4f9d6054c0ed Error Number:2627,State:1,Class:14 07/30/2020 12:49:25 PM WS_FINISHCALL Parameters: [route:4214][binsOnSite:0][driver:1][endOdom:115227][routeDate:2020-07-30][companyCode:RW][activity:CK][qty:1.0][startOdom:115227][endTime:2020-07-30 09:30:14][logid:708881][doCM05Adjustment:0][newServ:2][startTime:2020-07-30 09:30:08][truck:220] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (708881). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:4ebc15ab-3b6d-4f0e-a577-b508f11f02c9 Error Number:2627,State:1,Class:14 07/30/2020 01:02:22 PM WS_FINISHCALL Parameters: [route:4208][binsOnSite:0][driver:50][endOdom:245677][routeDate:2020-07-30][companyCode:RW][activity:DR][qty:1.0][startOdom:245668][endTime:2020-07-30 12:40:29][logid:708941][doCM05Adjustment:0][newServ:1][startTime:2020-07-30 11:50:33][truck:209] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (708941). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:023c863e-1177-46b1-a530-609a24a2857f Error Number:2627,State:1,Class:14 07/30/2020 02:38:47 PM WS_FINISHCALL Parameters: [route:4210][binsOnSite:0][driver:80][endOdom:487041][routeDate:2020-07-30][companyCode:RW][activity:CK][qty:1.0][startOdom:487041][endTime:2020-07-30 14:38:06][logid:709777][doCM05Adjustment:0][newServ:1][startTime:2020-07-30 14:38:06][truck:207] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (709777). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:393dc9fd-1eb5-4d1e-99d2-ec7c45849492 Error Number:2627,State:1,Class:14 08/06/2020 07:07:14 AM WS_FINISHCALL Parameters: [route:4215][binsOnSite:0][driver:15][endOdom:91214][routeDate:2020-08-06][companyCode:RW][activity:CK][qty:1.0][startOdom:91210][endTime:2020-08-06 06:25:46][logid:713264][doCM05Adjustment:0][newServ:4][startTime:2020-08-06 06:12:39][truck:219] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (713264). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:28fb7fbf-c2e8-4726-a22a-0cbd31215b8e Error Number:2627,State:1,Class:14 08/07/2020 01:55:03 PM WS_FINISHCALL Parameters: [route:5211][binsOnSite:0][driver:19][endOdom:213785][routeDate:2020-08-07][companyCode:RW][activity:DR][qty:1.0][startOdom:213771][endTime:2020-08-07 13:38:22][logid:715049][doCM05Adjustment:0][newServ:1][startTime:2020-08-07 12:41:34][truck:221] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (715049). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:68fa2f10-da78-4fc4-81b5-c0e7999ed70e Error Number:2627,State:1,Class:14 08/10/2020 07:16:19 AM WS_SAVEDISPOSAL Parameters: [ticketNumber:224554][saveTime:08/10/2020][endTime:08/10/2020 06:54][bol:][startTime:08/10/2020 06:42][route:1212][logid:715047][facilityCode:23][materials:~0,CD~2.59][routeDate:08/10/2020][companyCode:RW] System.NullReferenceException: Object reference not set to an instance of an object. at WSRouting.WSRout_Android.WS_Android.WS_SAVEDISPOSAL(String ticketNumber, String facilityCode, String logid, String startTime, String endTime, String routeDate, String saveTime, String route, String[] materials, String companyCode, String bol) 08/11/2020 08:02:19 AM WS_FINISHCALL Parameters: [route:2215][binsOnSite:0][driver:15][endOdom:91515][routeDate:2020-08-11][companyCode:RW][activity:CK][qty:1.0][startOdom:91515][endTime:2020-08-11 06:31:21][logid:715827][doCM05Adjustment:0][newServ:1][startTime:2020-08-11 06:26:09][truck:219] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (715827). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:2775b180-3b93-4b99-a63c-a2ad403022d9 Error Number:2627,State:1,Class:14 08/12/2020 10:20:37 AM WS_FINISHCALL Parameters: [route:3214][binsOnSite:0][driver:1][endOdom:116481][routeDate:2020-08-12][companyCode:RW][activity:CK][qty:1.0][startOdom:116481][endTime:2020-08-12 09:40:45][logid:716702][doCM05Adjustment:0][newServ:2][startTime:2020-08-12 09:36:51][truck:220] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (716702). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:3bd28f47-45b9-4639-94ee-da7c55ba71db Error Number:2627,State:1,Class:14 08/13/2020 08:24:43 AM WS_FINISHCALL Parameters: [route:4212][binsOnSite:0][driver:4][endOdom:427001][routeDate:2020-08-13][companyCode:RW][activity:DR][qty:1.0][startOdom:427001][endTime:2020-08-13 07:23:53][logid:717548][doCM05Adjustment:0][newServ:1][startTime:2020-08-13 07:06:00][truck:213] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (717548). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:d4e1dc66-facd-4ab6-84ce-7f8618916842 Error Number:2627,State:1,Class:14 08/17/2020 09:54:02 AM WS_FINISHCALL Parameters: [route:1215][binsOnSite:0][driver:15][endOdom:92055][routeDate:2020-08-17][companyCode:RW][activity:DR][qty:1.0][startOdom:92045][endTime:2020-08-17 09:33:28][logid:719256][doCM05Adjustment:0][newServ:2][startTime:2020-08-17 08:36:28][truck:219] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (719256). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:9791f6d3-e7ea-4136-930f-9893686b09f9 Error Number:2627,State:1,Class:14 08/19/2020 11:29:32 AM WS_FINISHCALL Parameters: [route:3205][binsOnSite:0][driver:48][endOdom:150984][routeDate:2020-08-19][companyCode:RW][activity:DR][qty:1.0][startOdom:150975][endTime:2020-08-19 10:59:30][logid:721134][doCM05Adjustment:0][newServ:3][startTime:2020-08-19 10:04:11][truck:218] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (721134). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:0ce3c347-dae6-44ff-a00c-3f09dd38b51d Error Number:2627,State:1,Class:14 08/20/2020 10:34:02 AM WS_SAVECUSTOMERSERVICEISSUE Parameters: [subject:empty][logid:722007][currentTime:2020-08-20 10:34:02][customerServiceIssueType:01][companyCode:RW][details:40 yd open top empty. 40 yd compactor only at 10%. both dumped yesterday. no dumps today on either can.][driver:49] Couldn't find Customer for call 722007 08/20/2020 12:40:15 PM WS_FINISHCALL Parameters: [route:4215][binsOnSite:0][driver:15][endOdom:92390][routeDate:2020-08-20][companyCode:RW][activity:SS][qty:1.0][startOdom:92390][endTime:2020-08-20 12:39:59][logid:721934][doCM05Adjustment:0][newServ:2][startTime:2020-08-20 12:39:56][truck:219] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (721934). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:d0f42249-0c3d-4ade-9d69-49abd39f2d47 Error Number:2627,State:1,Class:14 08/21/2020 08:29:38 AM WS_FINISHCALL Parameters: [route:5203][binsOnSite:0][driver:59][endOdom:51042][routeDate:2020-08-21][companyCode:RW][activity:DR][qty:1.0][startOdom:51037][endTime:2020-08-21 07:40:59][logid:722823][doCM05Adjustment:0][newServ:11][startTime:2020-08-21 07:00:52][truck:223] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (722823). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:3ae318b9-1d51-4492-8a97-5105ab6af9d3 Error Number:2627,State:1,Class:14 08/21/2020 12:34:39 PM WS_FINISHCALL Parameters: [route:5215][binsOnSite:0][driver:15][endOdom:92477][routeDate:2020-08-21][companyCode:RW][activity:SS][qty:1.0][startOdom:92477][endTime:2020-08-21 11:18:39][logid:722867][doCM05Adjustment:0][newServ:2][startTime:2020-08-21 11:18:35][truck:219] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (722867). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:08133129-05cc-435f-a667-e6b6d165d6e9 Error Number:2627,State:1,Class:14 08/24/2020 11:24:06 AM WS_FINISHCALL Parameters: [route:1205][binsOnSite:0][driver:48][endOdom:151333][routeDate:2020-08-24][companyCode:RW][activity:DR][qty:1.0][startOdom:151319][endTime:2020-08-24 10:47:55][logid:724462][doCM05Adjustment:0][newServ:1][startTime:2020-08-24 09:34:45][truck:218] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (724462). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:7f62d39b-762d-45b1-9849-da222c541468 Error Number:2627,State:1,Class:14 08/25/2020 12:07:21 PM WS_FINISHCALL Parameters: [route:2214][binsOnSite:0][driver:1][endOdom:117686][routeDate:2020-08-25][companyCode:RW][activity:DR][qty:1.0][startOdom:117667][endTime:2020-08-25 10:38:50][logid:724506][doCM05Adjustment:0][newServ:1][startTime:2020-08-25 09:37:16][truck:220] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (724506). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:25aa8da1-c8fc-49d6-b6d2-2eac01b09970 Error Number:2627,State:1,Class:14 08/26/2020 01:09:32 PM WS_FINISHCALL Parameters: [route:3204][binsOnSite:0][driver:83][endOdom:189059][routeDate:2020-08-26][companyCode:RW][activity:DR][qty:1.0][startOdom:189059][endTime:2020-08-26 12:08:08][logid:725470][doCM05Adjustment:0][newServ:1][startTime:2020-08-26 12:06:01][truck:216] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (725470). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:15f80d5f-13be-4e5d-bd15-218ae5caa3fa Error Number:2627,State:1,Class:14 08/26/2020 02:32:40 PM WS_FINISHCALL Parameters: [route:3214][binsOnSite:0][driver:1][endOdom:117894][routeDate:2020-08-26][companyCode:RW][activity:CK][qty:1.0][startOdom:117893][endTime:2020-08-26 14:30:32][logid:725568][doCM05Adjustment:0][newServ:4][startTime:2020-08-26 14:30:29][truck:220] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (725568). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:c108f165-8b5c-4196-96dc-35cde717a0eb Error Number:2627,State:1,Class:14 08/28/2020 12:11:02 PM WS_FINISHCALL Parameters: [route:5205][binsOnSite:0][driver:48][endOdom:151767][routeDate:2020-08-28][companyCode:RW][activity:DR][qty:1.0][startOdom:151758][endTime:2020-08-28 11:21:15][logid:727158][doCM05Adjustment:0][newServ:1][startTime:2020-08-28 10:15:05][truck:218] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (727158). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:b0feb830-5c34-4058-8eb6-09ba589e6ae0 Error Number:2627,State:1,Class:14 08/31/2020 06:54:38 AM WS_FINISHCALL Parameters: [route:1215][binsOnSite:0][driver:15][endOdom:93047][routeDate:2020-08-31][companyCode:RW][activity:CK][qty:1.0][startOdom:93046][endTime:2020-08-31 06:28:40][logid:728010][doCM05Adjustment:0][newServ:1][startTime:2020-08-31 06:23:03][truck:219] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (728010). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:d42e4d73-feca-4d5e-b3de-d7c69943099e Error Number:2627,State:1,Class:14 08/31/2020 08:52:48 AM WS_FINISHCALL Parameters: [route:1214][binsOnSite:0][driver:1][endOdom:118242][routeDate:2020-08-31][companyCode:RW][activity:CK][qty:1.0][startOdom:118242][endTime:2020-08-31 07:34:50][logid:727983][doCM05Adjustment:0][newServ:4][startTime:2020-08-31 07:34:42][truck:220] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (727983). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:b39ae703-8cad-469e-999c-0d5726451571 Error Number:2627,State:1,Class:14 09/01/2020 11:05:30 AM WS_FINISHCALL Parameters: [route:2302][binsOnSite:0][driver:84][endOdom:118883][routeDate:2020-09-01][companyCode:RW][activity:CD][qty:1.0][startOdom:118872][endTime:2020-09-01 11:01:49][logid:729903][doCM05Adjustment:0][newServ:1][startTime:2020-09-01 10:22:00][truck:311] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (729903). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:aaa86004-ad94-40b1-ab3a-023b3b935bd0 Error Number:2627,State:1,Class:14 09/02/2020 06:18:38 AM WS_SAVEDISPOSAL Parameters: [ticketNumber:3381085][saveTime:09/01/2020][endTime:09/01/2020 13:42][bol:][startTime:09/01/2020 13:42][route:2205][logid:729049][facilityCode:01][materials:MS~2.4][routeDate:09/01/2020][companyCode:RW] System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'SET'. Incorrect syntax near the keyword 'SET'. Incorrect syntax near the keyword 'DECLARE'. at TxUtilities.Database.GetDataSet(String strSql, String strTable) at TxUtilities.Database.GetDataView(String select, String tablename, String RowFilter, String Sort, DataViewRowState RowState) at TxUtilities.Database.GetDataView(String select, String tablename) at WSRouting.WSRout_Android.WS_Android.WS_SAVEDISPOSAL(String ticketNumber, String facilityCode, String logid, String startTime, String endTime, String routeDate, String saveTime, String route, String[] materials, String companyCode, String bol) ClientConnectionId:e6e548ee-9352-4baa-b940-7e15c25fec31 Error Number:156,State:1,Class:15 09/02/2020 06:18:40 AM WS_SAVECALLSIGNATURE Parameters: [signer:][logid:729049][companyCode:RW][signTime:2020/09/02 06:18:40] System.NullReferenceException: Object reference not set to an instance of an object. at WSRouting.WSRout_Android.WS_Android.WS_SAVECALLSIGNATURE(String logid, String companyCode, String signTime, String image, String signer) 09/04/2020 08:59:03 AM WS_FINISHCALL Parameters: [route:5215][binsOnSite:0][driver:15][endOdom:93289][routeDate:2020-09-04][companyCode:RW][activity:CK][qty:1.0][startOdom:93288][endTime:2020-09-04 08:22:24][logid:731605][doCM05Adjustment:0][newServ:1][startTime:2020-09-04 08:16:29][truck:219] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (731605). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:0a1f1d9d-4161-4442-81df-e8f16b48a022 Error Number:2627,State:1,Class:14 09/08/2020 08:48:19 AM WS_FINISHCALL Parameters: [route:2305][binsOnSite:0][driver:72][endOdom:39167][routeDate:2020-09-08][companyCode:RW][activity:SS][qty:2.0][startOdom:39167][endTime:2020-09-08 06:56:14][logid:733710][doCM05Adjustment:0][newServ:10][startTime:2020-09-08 06:51:52][truck:316] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (733710). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:2991999e-aa7b-41fc-aaa2-c726bd792da5 Error Number:2627,State:1,Class:14 09/08/2020 10:07:38 AM SAVE_IMAGE Parameters: [sql:INSERT INTO SC01P(SC01P_CALL,SC01P_FILE,SC01P_FILENAME) VALUES(3, @file, @name)][companyCode:RW][mustSaveInDB:False] System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SC01P_SC01". The conflict occurred in database "TRUX_RW_COMP", table "dbo.sc01", column 'SC01_CALL'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at WSRouting.WSRout_Android.WS_Android.SaveImage(String companyCode, String image, String sql, Boolean mustSaveInDB) ClientConnectionId:7f4935bd-3c80-40e8-a453-61bf7c5611a6 Error Number:547,State:0,Class:16 09/08/2020 10:07:48 AM SAVE_IMAGE Parameters: [sql:INSERT INTO SC01P(SC01P_CALL,SC01P_FILE,SC01P_FILENAME) VALUES(5, @file, @name)][companyCode:RW][mustSaveInDB:False] System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SC01P_SC01". The conflict occurred in database "TRUX_RW_COMP", table "dbo.sc01", column 'SC01_CALL'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at WSRouting.WSRout_Android.WS_Android.SaveImage(String companyCode, String image, String sql, Boolean mustSaveInDB) ClientConnectionId:237fa470-be08-4a88-942c-3adca4953a48 Error Number:547,State:0,Class:16 09/10/2020 06:15:03 AM WS_FINISHCALL Parameters: [route:2212][binsOnSite:0][driver:4][endOdom:429829][routeDate:2020-09-08][companyCode:RW][activity:DR][qty:1.0][startOdom:429829][endTime:2020-09-08 09:38:17][logid:733133][doCM05Adjustment:0][newServ:1][startTime:2020-09-08 08:12:59][truck:213] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (733133). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:7403c09c-6605-4c25-a7d7-354999653437 Error Number:2627,State:1,Class:14 09/10/2020 06:22:43 AM WS_FINISHCALL Parameters: [route:2205][binsOnSite:0][driver:48][endOdom:152697][routeDate:2020-09-08][companyCode:RW][activity:SW][qty:1.0][startOdom:152667][endTime:2020-09-08 11:40:58][logid:734098][doCM05Adjustment:0][newServ:1][startTime:2020-09-08 10:14:35][truck:218] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (734098). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:7403c09c-6605-4c25-a7d7-354999653437 Error Number:2627,State:1,Class:14 09/11/2020 03:40:01 AM WS_FINISHCALL Parameters: [route:2307][binsOnSite:0][driver:76][endOdom:221591][routeDate:2020-09-08][companyCode:RW][activity:SS][qty:1.0][startOdom:221591][endTime:2020-09-08 10:09:57][logid:733911][doCM05Adjustment:0][newServ:1][startTime:2020-09-08 10:08:03][truck:308] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (733911). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:9c775cab-c963-494a-b70f-1907a442fe20 Error Number:2627,State:1,Class:14 09/11/2020 10:19:33 AM WS_FINISHCALL Parameters: [route:5215][binsOnSite:0][driver:15][endOdom:93807][routeDate:2020-09-11][companyCode:RW][activity:DR][qty:1.0][startOdom:93796][endTime:2020-09-11 10:13:12][logid:737323][doCM05Adjustment:0][newServ:2][startTime:2020-09-11 09:26:05][truck:219] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (737323). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:7c94862b-113e-44fb-ae61-5f7a872ceb63 Error Number:2627,State:1,Class:14 09/11/2020 11:28:58 AM WS_FINISHCALL Parameters: [route:5217][binsOnSite:0][driver:59][endOdom:461556][routeDate:2020-09-11][companyCode:RW][activity:DL][qty:1.0][startOdom:461551][endTime:2020-09-11 10:48:35][logid:738045][doCM05Adjustment:0][newServ:2][startTime:2020-09-11 10:31:55][truck:203] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (738045). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:6a1a6bfc-53b6-4d84-8b56-d32abf7f7c94 Error Number:2627,State:1,Class:14 09/18/2020 08:28:34 AM WS_FINISHCALL Parameters: [route:5201][binsOnSite:0][driver:8][endOdom:251972][routeDate:2020-09-18][companyCode:RW][activity:DR][qty:1.0][startOdom:251969][endTime:2020-09-18 08:17:08][logid:742517][doCM05Adjustment:0][newServ:5][startTime:2020-09-18 07:29:13][truck:217] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (742517). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:fe153839-4e4a-41b4-9784-992de1dbe78e Error Number:2627,State:1,Class:14 09/22/2020 07:33:45 AM WS_SAVEDISPOSAL Parameters: [ticketNumber:2324408][saveTime:09/22/2020][endTime:09/22/2020 07:18][bol:][startTime:09/22/2020 07:06][route:2212][logid:743603][facilityCode:23][materials:~0][routeDate:09/22/2020][companyCode:RW] System.NullReferenceException: Object reference not set to an instance of an object. at WSRouting.WSRout_Android.WS_Android.WS_SAVEDISPOSAL(String ticketNumber, String facilityCode, String logid, String startTime, String endTime, String routeDate, String saveTime, String route, String[] materials, String companyCode, String bol) 09/28/2020 02:28:16 PM WS_FINISHCALL Parameters: [route:1214][binsOnSite:0][driver:1][endOdom:120770][routeDate:2020-09-28][companyCode:RW][activity:CK][qty:1.0][startOdom:120770][endTime:2020-09-28 14:28:07][logid:747072][doCM05Adjustment:0][newServ:2][startTime:2020-09-28 14:28:01][truck:220] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (747072). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:b5c75fc1-54cb-4121-9d9f-d793cc38a0f6 Error Number:2627,State:1,Class:14 09/28/2020 03:07:21 PM WS_FINISHCALL Parameters: [route:1215][binsOnSite:0][driver:15][endOdom:95096][routeDate:2020-09-28][companyCode:RW][activity:DR][qty:1.0][startOdom:95078][endTime:2020-09-28 14:55:06][logid:747059][doCM05Adjustment:0][newServ:3][startTime:2020-09-28 14:09:01][truck:219] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (747059). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:8fbf9b3a-dafa-4ebd-a12f-bc3672f05913 Error Number:2627,State:1,Class:14 09/29/2020 10:49:56 AM WS_FINISHCALL Parameters: [route:2212][binsOnSite:0][driver:4][endOdom:432376][routeDate:2020-09-29][companyCode:RW][activity:DR][qty:1.0][startOdom:432371][endTime:2020-09-29 10:13:46][logid:748100][doCM05Adjustment:0][newServ:1][startTime:2020-09-29 09:38:25][truck:213] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (748100). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:e302af56-2585-4bc2-aa81-8d40630d7520 Error Number:2627,State:1,Class:14 09/29/2020 02:28:17 PM WS_SAVEDISPOSAL Parameters: [ticketNumber:233875][saveTime:09/29/2020][endTime:09/29/2020 12:59][bol:][startTime:09/29/2020 12:47][route:2212][logid:748979][facilityCode:23][materials:~0][routeDate:09/29/2020][companyCode:RW] System.NullReferenceException: Object reference not set to an instance of an object. at WSRouting.WSRout_Android.WS_Android.WS_SAVEDISPOSAL(String ticketNumber, String facilityCode, String logid, String startTime, String endTime, String routeDate, String saveTime, String route, String[] materials, String companyCode, String bol) 09/30/2020 08:23:02 AM WS_FINISHCALL Parameters: [route:3202][binsOnSite:0][driver:31][endOdom:587485][routeDate:2020-09-30][companyCode:RW][activity:DL][qty:1.0][startOdom:587481][endTime:2020-09-30 07:40:21][logid:749749][doCM05Adjustment:0][newServ:1][startTime:2020-09-30 07:26:17][truck:210] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (749749). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:33b2019b-55df-4646-bea2-b89a5ab51456 Error Number:2627,State:1,Class:14 10/02/2020 07:20:42 AM WS_FINISHCALL Parameters: [route:5202][binsOnSite:0][driver:31][endOdom:587754][routeDate:2020-10-02][companyCode:RW][activity:DR][qty:1.0][startOdom:587737][endTime:2020-10-02 07:04:46][logid:750868][doCM05Adjustment:0][newServ:1][startTime:2020-10-02 06:03:22][truck:210] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (750868). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:46fb5ec5-dc4b-4e2d-a532-4893a60d6989 Error Number:2627,State:1,Class:14 10/02/2020 12:00:08 PM WS_FINISHCALL Parameters: [route:5211][binsOnSite:0][driver:19][endOdom:217212][routeDate:2020-10-02][companyCode:RW][activity:DR][qty:1.0][startOdom:217200][endTime:2020-10-02 10:19:34][logid:750901][doCM05Adjustment:0][newServ:1][startTime:2020-10-02 09:18:47][truck:221] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (750901). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:23b684f9-f0f5-4a52-8c0d-d4b94244602d Error Number:2627,State:1,Class:14 10/05/2020 12:00:40 PM WS_FINISHCALL Parameters: [route:1208][binsOnSite:0][driver:50][endOdom:464005][routeDate:2020-10-05][companyCode:RW][activity:DL][qty:1.0][startOdom:464005][endTime:2020-10-05 12:00:31][logid:751841][doCM05Adjustment:0][newServ:1][startTime:2020-10-05 12:00:31][truck:203] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (751841). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:149c8959-5904-4de7-9b70-c94036a9001b Error Number:2627,State:1,Class:14 10/05/2020 02:03:32 PM WS_FINISHCALL Parameters: [route:1214][binsOnSite:0][driver:1][endOdom:121632][routeDate:2020-10-05][companyCode:RW][activity:CK][qty:1.0][startOdom:121632][endTime:2020-10-05 12:19:45][logid:751611][doCM05Adjustment:0][newServ:3][startTime:2020-10-05 12:19:38][truck:220] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (751611). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:df815d19-79a1-4a56-bad0-6da285ede9c1 Error Number:2627,State:1,Class:14 10/05/2020 03:29:39 PM WS_FINISHCALL Parameters: [route:1208][binsOnSite:0][driver:50][endOdom:464054][routeDate:2020-10-05][companyCode:RW][activity:DR][qty:1.0][startOdom:464028][endTime:2020-10-05 15:29:26][logid:752723][doCM05Adjustment:0][newServ:5][startTime:2020-10-05 14:14:33][truck:203] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (752723). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:f7e7edf4-34a6-48e3-9213-02c88663292f Error Number:2627,State:1,Class:14 10/05/2020 04:31:51 PM WS_SAVEDISPOSAL Parameters: [ticketNumber:3416181][saveTime:10/05/2020][endTime:10/05/2020 16:31][bol:][startTime:10/05/2020 16:31][route:1306][logid:-1][facilityCode:01][materials:~0][routeDate:10/05/2020][companyCode:RW] System.NullReferenceException: Object reference not set to an instance of an object. at WSRouting.WSRout_Android.WS_Android.WS_SAVEDISPOSAL(String ticketNumber, String facilityCode, String logid, String startTime, String endTime, String routeDate, String saveTime, String route, String[] materials, String companyCode, String bol) 10/08/2020 08:53:40 AM WS_FINISHCALL Parameters: [route:4202][binsOnSite:0][driver:31][endOdom:588435][routeDate:2020-10-08][companyCode:RW][activity:DR][qty:1.0][startOdom:588429][endTime:2020-10-08 08:07:19][logid:754403][doCM05Adjustment:0][newServ:14][startTime:2020-10-08 07:31:41][truck:210] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (754403). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:019bf53a-6ccd-46a6-a6c7-5d57249bccb3 Error Number:2627,State:1,Class:14 10/08/2020 09:51:30 AM WS_FINISHCALL Parameters: [route:4212][binsOnSite:0][driver:4][endOdom:433617][routeDate:2020-10-08][companyCode:RW][activity:DR][qty:1.0][startOdom:433605][endTime:2020-10-08 09:29:44][logid:754358][doCM05Adjustment:0][newServ:1][startTime:2020-10-08 08:25:08][truck:213] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (754358). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:d2e4d14e-140b-43a3-8a57-4689a6ebfa8d Error Number:2627,State:1,Class:14 10/13/2020 11:32:36 AM WS_FINISHCALL Parameters: [route:2207][binsOnSite:0][driver:49][endOdom:470459][routeDate:2020-10-13][companyCode:RW][activity:DR][qty:1.0][startOdom:470440][endTime:2020-10-13 11:04:18][logid:757922][doCM05Adjustment:0][newServ:1][startTime:2020-10-13 09:45:23][truck:214] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (757922). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:fd938044-89dd-4aaa-a359-b99c21937b82 Error Number:2627,State:1,Class:14 10/14/2020 09:54:46 AM WS_FINISHCALL Parameters: [route:3206][binsOnSite:0][driver:6][endOdom:79074][routeDate:2020-10-14][companyCode:RW][activity:FN][qty:1.0][startOdom:79070][endTime:2020-10-14 09:54:42][logid:758681][doCM05Adjustment:0][newServ:1][startTime:2020-10-14 09:44:53][truck:222] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (758681). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:f1496a1b-60c8-46db-8ff9-e64df255833f Error Number:2627,State:1,Class:14 10/16/2020 03:26:51 AM WS_SAVEDISPOSAL Parameters: [ticketNumber:34223869][saveTime:10/15/2020][endTime:10/15/2020 13:44][bol:][startTime:10/15/2020 13:44][route:4302][logid:-1][facilityCode:01][materials:MS~4.68][routeDate:10/15/2020][companyCode:RW] route doesn't exist?? 10/26/2020 08:22:28 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765112 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:28 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765113 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:28 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765114 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:28 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765115 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:28 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765116 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:28 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765117 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:28 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765118 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765119 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765120 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765121 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765122 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765123 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765124 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765125 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765126 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765127 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765128 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765129 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765130 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765131 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765132 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765133 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765134 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765135 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765136 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765137 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765138 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765139 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765140 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765141 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765142 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765143 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765144 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765145 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765146 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765147 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765148 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765149 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765150 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765151 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765152 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765153 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765154 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765155 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765156 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765157 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765158 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765159 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:29 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765160 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765161 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765162 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765163 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765164 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765165 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765166 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765167 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765168 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765169 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765170 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765171 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765172 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765173 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765174 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765175 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765176 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765177 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765178 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765179 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765180 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765181 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765182 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765183 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765184 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765185 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765186 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765187 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765188 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765189 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765190 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765191 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765192 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765193 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765194 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:30 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765195 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765196 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765197 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765198 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765199 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765200 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765201 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765202 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765203 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765204 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765205 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765206 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765207 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765208 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765209 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765210 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765211 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765212 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765213 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765214 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765215 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765216 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765217 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765218 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765219 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765220 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765221 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765222 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765223 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765224 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765225 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765226 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765227 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765228 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765229 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765230 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765231 doesn't exist in the trux database. Proceeding to delete the record. 10/26/2020 08:22:31 AM WS_GETCALLSONROUTE Parameters: [route:1303][truck:310][excludedLogids:][companyCode:RW][date:10/26/2020] Logid 765232 doesn't exist in the trux database. Proceeding to delete the record. 11/02/2020 05:23:58 AM WS_FINISHCALL Parameters: [route:5211][binsOnSite:0][driver:19][endOdom:219095][routeDate:2020-10-30][companyCode:RW][activity:DR][qty:1.0][startOdom:219090][endTime:2020-10-30 12:18:01][logid:767802][doCM05Adjustment:0][newServ:1][startTime:2020-10-30 11:15:44][truck:221] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (767802). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:4dbe82e0-79ed-481e-8cda-3f2a0388b2a9 Error Number:2627,State:1,Class:14 11/03/2020 08:16:36 AM WS_FINISHCALL Parameters: [route:2201][binsOnSite:0][driver:8][endOdom:255127][routeDate:2020-11-03][companyCode:RW][activity:CK][qty:1.0][startOdom:255125][endTime:2020-11-03 07:29:09][logid:770335][doCM05Adjustment:0][newServ:2][startTime:2020-11-03 07:19:42][truck:217] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (770335). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:a332d45d-f229-444d-b01a-20d05d5160df Error Number:2627,State:1,Class:14 11/05/2020 05:28:33 AM WS_FINISHCALL Parameters: [route:3211][binsOnSite:0][driver:19][endOdom:219364][routeDate:2020-11-04][companyCode:RW][activity:DR][qty:1.0][startOdom:219359][endTime:2020-11-04 13:02:21][logid:771357][doCM05Adjustment:0][newServ:7][startTime:2020-11-04 12:26:41][truck:221] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (771357). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:713e466b-449e-4753-8caf-70e9e8b76ed3 Error Number:2627,State:1,Class:14 11/06/2020 07:48:25 AM WS_FINISHCALL Parameters: [route:5212][binsOnSite:0][driver:4][endOdom:436310][routeDate:2020-11-06][companyCode:RW][activity:FN][qty:1.0][startOdom:436309][endTime:2020-11-06 07:02:07][logid:773098][doCM05Adjustment:0][newServ:4][startTime:2020-11-06 06:01:33][truck:213] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (773098). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:8cdebae1-8c4d-435a-bb18-70fa464d21e1 Error Number:2627,State:1,Class:14 11/09/2020 03:56:18 PM WS_SAVEDISPOSAL Parameters: [ticketNumber:3443881][saveTime:11/09/2020][endTime:11/09/2020 15:56][bol:][startTime:11/09/2020 15:56][route:1306][logid:-1][facilityCode:01][materials:~0][routeDate:11/09/2020][companyCode:RW] System.NullReferenceException: Object reference not set to an instance of an object. at WSRouting.WSRout_Android.WS_Android.WS_SAVEDISPOSAL(String ticketNumber, String facilityCode, String logid, String startTime, String endTime, String routeDate, String saveTime, String route, String[] materials, String companyCode, String bol) 11/10/2020 11:27:40 AM WS_FINISHCALL Parameters: [route:2214][binsOnSite:0][driver:1][endOdom:125369][routeDate:2020-11-10][companyCode:RW][activity:CK][qty:1.0][startOdom:125369][endTime:2020-11-10 10:43:25][logid:774828][doCM05Adjustment:0][newServ:6][startTime:2020-11-10 10:43:20][truck:220] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (774828). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:df4c6213-5c6b-4c29-bbd5-ce64b365d84d Error Number:2627,State:1,Class:14 11/10/2020 12:58:54 PM WS_FINISHCALL Parameters: [route:2214][binsOnSite:0][driver:1][endOdom:125369][routeDate:2020-11-10][companyCode:RW][activity:CK][qty:1.0][startOdom:125369][endTime:2020-11-10 11:54:08][logid:774827][doCM05Adjustment:0][newServ:2][startTime:2020-11-10 11:54:03][truck:220] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (774827). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:548aa1ce-9b4a-434c-aab6-a16e00d4c4a0 Error Number:2627,State:1,Class:14 11/11/2020 12:20:13 PM WS_FINISHCALL Parameters: [route:3204][binsOnSite:0][driver:33][endOdom:195164][routeDate:2020-11-11][companyCode:RW][activity:DR][qty:1.0][startOdom:195149][endTime:2020-11-11 12:19:47][logid:775732][doCM05Adjustment:0][newServ:1][startTime:2020-11-11 10:49:14][truck:216] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (775732). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:19c834f2-452d-4e72-a83e-ae600b0555b7 Error Number:2627,State:1,Class:14 11/17/2020 05:52:50 AM WS_SAVEDISPOSAL Parameters: [ticketNumber:3445838][saveTime:11/13/2020][endTime:11/13/2020 12:37][bol:][startTime:11/13/2020 12:37][route:5310][logid:-1][facilityCode:01][materials:MS~7.57][routeDate:11/13/2020][companyCode:RW] route doesn't exist?? 12/03/2020 12:56:27 PM WS_FINISHCALL Parameters: [route:4201][binsOnSite:0][driver:8][endOdom:256817][routeDate:2020-12-03][companyCode:RW][activity:DR][qty:1.0][startOdom:256809][endTime:2020-12-03 12:32:00][logid:789692][doCM05Adjustment:0][newServ:1][startTime:2020-12-03 11:26:55][truck:217] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (789692). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:ee9e3dc5-e5d0-4052-bf66-fbdd9b2015f5 Error Number:2627,State:1,Class:14 12/09/2020 01:58:33 PM WS_SAVEDISPOSAL Parameters: [ticketNumber:001936][saveTime:12/09/2020][endTime:12/09/2020 13:42][bol:][startTime:12/09/2020 13:26][route:3212][logid:794183][facilityCode:23][materials:~0,CD~0.88][routeDate:12/09/2020][companyCode:RW] System.NullReferenceException: Object reference not set to an instance of an object. at WSRouting.WSRout_Android.WS_Android.WS_SAVEDISPOSAL(String ticketNumber, String facilityCode, String logid, String startTime, String endTime, String routeDate, String saveTime, String route, String[] materials, String companyCode, String bol) 12/16/2020 06:16:33 AM WS_LOGIN Parameters: [route:3201][apkVersion:7.19.0001.02][companyCode:RW][odom:257535][routeDate:12/16/2020][truck:217][time:06:16:32][currentDate:12/16/2020][driver:8] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_FL09'. Cannot insert duplicate key in object 'dbo.FL09'. The duplicate key value is (Dec 16 2020 6:16AM, 8, 217). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_LOGIN(String routeDate, String currentDate, String time, String truck, String driver, String route, String odom, String companyCode, String apkVersion) ClientConnectionId:b04e49ae-5e12-430c-aa20-2e53a945e12e Error Number:2627,State:1,Class:14 12/19/2020 10:34:17 AM WS_SAVEDISPOSAL Parameters: [ticketNumber:3464305][saveTime:12/19/2020][endTime:12/19/2020 10:34][bol:][startTime:12/19/2020 10:24][route:6301][logid:-1][facilityCode:01][materials:~0][routeDate:12/19/2020][companyCode:RW] System.NullReferenceException: Object reference not set to an instance of an object. at WSRouting.WSRout_Android.WS_Android.WS_SAVEDISPOSAL(String ticketNumber, String facilityCode, String logid, String startTime, String endTime, String routeDate, String saveTime, String route, String[] materials, String companyCode, String bol) 12/22/2020 12:43:49 PM WS_FINISHCALL Parameters: [route:2211][binsOnSite:0][driver:19][endOdom:222655][routeDate:2020-12-22][companyCode:RW][activity:DR][qty:1.0][startOdom:222650][endTime:2020-12-22 12:16:23][logid:801550][doCM05Adjustment:0][newServ:1][startTime:2020-12-22 11:41:11][truck:221] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (801550). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:7a398776-97f8-4471-b6be-0df01871b608 Error Number:2627,State:1,Class:14 12/24/2020 08:47:44 AM WS_FINISHCALL Parameters: [route:4211][binsOnSite:0][driver:19][endOdom:222820][routeDate:2020-12-24][companyCode:RW][activity:CK][qty:1.0][startOdom:222820][endTime:2020-12-24 08:04:33][logid:802394][doCM05Adjustment:0][newServ:3][startTime:2020-12-24 08:04:02][truck:221] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (802394). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:b2554035-cfab-4364-bd0e-4165a04648b3 Error Number:2627,State:1,Class:14 12/28/2020 05:33:58 AM WS_LOGIN Parameters: [route:1202][apkVersion:7.19.0001.02][companyCode:RW][odom:595556][routeDate:12/28/2020][truck:210][time:05:33:58][currentDate:12/28/2020][driver:31] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_FL09'. Cannot insert duplicate key in object 'dbo.FL09'. The duplicate key value is (Dec 28 2020 5:33AM, 31, 210). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_LOGIN(String routeDate, String currentDate, String time, String truck, String driver, String route, String odom, String companyCode, String apkVersion) ClientConnectionId:2a06a76a-01aa-4c2f-9b22-38cdd3faaa43 Error Number:2627,State:1,Class:14 01/04/2021 08:45:13 AM WS_FINISHCALL Parameters: [route:1201][binsOnSite:0][driver:8][endOdom:266668][routeDate:2021-01-04][companyCode:RW][activity:CK][qty:1.0][startOdom:266667][endTime:2021-01-04 08:39:40][logid:807906][doCM05Adjustment:0][newServ:2][startTime:2021-01-04 08:26:57][truck:217] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (807906). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:9df049c4-1925-40fa-958c-9f93fe3deb96 Error Number:2627,State:1,Class:14 01/05/2021 07:10:47 AM WS_FINISHCALL Parameters: [route:2212][binsOnSite:0][driver:4][endOdom:440880][routeDate:2021-01-05][companyCode:RW][activity:DR][qty:1.0][startOdom:440867][endTime:2021-01-05 06:55:15][logid:809957][doCM05Adjustment:0][newServ:2][startTime:2021-01-05 06:01:35][truck:213] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (809957). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:c670502b-7c61-477d-949d-5faa5fb3c79d Error Number:2627,State:1,Class:14 01/06/2021 03:00:08 AM WS_GETUPDATECONTAINERS Parameters: [companyCode:RW][truck:309] System.NullReferenceException: Object reference not set to an instance of an object. at TxWebService.TxWebBase.TxWebBase.InitalizeCompDB(String _companyCode) at WSRouting.WSRout_Android.WS_Android.WS_GETUPDATECONTAINERS(String truck, String companyCode) 01/08/2021 05:40:36 AM WS_LOGOFF Parameters: [endOdom:441198][fuel:0.0][companyCode:RW][diff:-51][endDateTime:01/07/2021 12:18:09][fuom:GA][route:4212][ehours:22809.0][truck:213][routeDate:01/07/2021][driver:4] Failed to send email: Unclosed quotation mark after the character string '0302584799''. Incorrect syntax near '0302584799''. 01/08/2021 12:45:05 PM WS_FINISHCALL Parameters: [route:5201][binsOnSite:0][driver:8][endOdom:267680][routeDate:2021-01-08][companyCode:RW][activity:DR][qty:1.0][startOdom:267633][endTime:2021-01-08 11:45:08][logid:812572][doCM05Adjustment:0][newServ:1][startTime:2021-01-08 09:54:03][truck:217] System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_RM03A'. Cannot insert duplicate key in object 'dbo.RM03A'. The duplicate key value is (812572). The statement has been terminated. at TxUtilities.Database.ExecuteSqlNonQuery(String strSql) at WSRouting.WSRout_Android.WS_Android.WS_FINISHCALL(String logid, String route, String truck, String startOdom, String endOdom, String driver, String routeDate, String qty, String activity, String startTime, String endTime, String companyCode, String doCM05Adjustment, String binsOnSite, String newServ, String startLat, String startLong, String endLat, String endLong) ClientConnectionId:0723d4e5-4256-43f0-8ce3-ef3cc7269191 Error Number:2627,State:1,Class:14 01/20/2021 05:22:44 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820295 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:44 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820296 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:44 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820297 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:44 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820298 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:44 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820299 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:44 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820300 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:44 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820301 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:44 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820302 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:44 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820303 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:44 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820304 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:44 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820305 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:44 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820306 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:44 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820307 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:44 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820308 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:44 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820309 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:44 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820310 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:44 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820311 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:44 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820312 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:44 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820313 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:44 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820314 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:44 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820315 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:44 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820316 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:44 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820317 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:44 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820318 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:45 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820319 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:45 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820320 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:45 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820321 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:45 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820322 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:45 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820323 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:45 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820324 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:45 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820325 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:45 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820326 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:45 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820327 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:45 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820328 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:45 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820329 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:45 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820330 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:45 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820331 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:45 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820332 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:45 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820333 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:45 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820334 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:45 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820335 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:45 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820336 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:45 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820337 doesn't exist in the trux database. Proceeding to delete the record. 01/20/2021 05:22:45 AM WS_GETCALLSONROUTE Parameters: [route:3307][truck:308][excludedLogids:][companyCode:RW][date:01/20/2021] Logid 820338 doesn't exist in the trux database. Proceeding to delete the record.