3/6/2022 2:30:03 AM : Start Process : checkAllTablesExists()  ### Driver={SQL Server};Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
3/6/2022 2:30:04 AM : StartProcess  ### 3/6/2022 2:30:04 AM

3/6/2022 2:30:04 AM : 11  ### 3/6/2022 2:30:04 AM

3/6/2022 2:30:04 AM : 22  ### 3/6/2022 2:30:04 AM

3/6/2022 2:30:04 AM : 33  ### 3/6/2022 2:30:04 AM

3/6/2022 2:30:04 AM : Application Started  ### 3/6/2022 2:30:04 AM

3/6/2022 2:30:04 AM : Start Process : checkAllTablesExists()  ### 
3/6/2022 2:30:04 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 3/6/2022 2:30:04 AM
3/6/2022 2:30:04 AM : MainForm_Load  ### AlertSystem ON
3/6/2022 2:30:05 AM : No. of Files to import (RECEIVEFINAL):  ### 1
3/6/2022 2:30:05 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
3/6/2022 2:30:05 AM : PostData() --->>  ### 3/6/2022 2:30:05 AM
3/6/2022 2:30:05 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 3/6/2022 2:30:05 AM
3/6/2022 2:30:06 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '06/Mar/2022' ### 3/6/2022 2:30:06 AM
3/6/2022 2:30:06 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '06/Mar/2022' ### 3/6/2022 2:30:06 AM
3/6/2022 2:30:06 AM :  ### 
3/6/2022 2:30:06 AM : UNLINKEDSALES Record Count Before --->> 0 ### 3/6/2022 2:30:06 AM
3/6/2022 2:30:06 AM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 3/6/2022 2:30:06 AM
3/6/2022 2:30:13 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '06/Mar/2022' ### 3/6/2022 2:30:13 AM
3/6/2022 2:30:13 AM : UNLINKEDSALES Record Count After --->> 0 ### 3/6/2022 2:30:13 AM
3/6/2022 2:30:13 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 3/6/2022 2:30:13 AM
3/6/2022 2:30:13 AM :  ### 
3/6/2022 2:30:13 AM : Posting Supplierlink Query for Purchases --->>  ### 3/6/2022 2:30:13 AM
3/6/2022 2:30:20 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '06/Mar/2022' ### 3/6/2022 2:30:20 AM
3/6/2022 2:30:25 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '06/Mar/2022' ### 3/6/2022 2:30:25 AM
3/6/2022 2:30:25 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 3/6/2022 2:30:25 AM
3/6/2022 2:30:25 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '06/Mar/2022' ### 3/6/2022 2:30:25 AM
3/6/2022 2:30:26 AM : Posting ClosingStock Successful --->>  ### 3/6/2022 2:30:26 AM
3/6/2022 2:30:26 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 3/6/2022 2:30:26 AM
3/6/2022 2:30:26 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
3/6/2022 2:30:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 3/6/2022 2:30:26 AM
3/6/2022 2:30:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 3/6/2022 2:30:26 AM
3/6/2022 2:30:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 3/6/2022 2:30:26 AM
3/6/2022 2:30:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 3/6/2022 2:30:26 AM
3/6/2022 2:30:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 3/6/2022 2:30:26 AM
3/6/2022 2:30:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 3/6/2022 2:30:26 AM
3/6/2022 2:30:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 3/6/2022 2:30:26 AM
3/6/2022 2:30:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 3/6/2022 2:30:26 AM
3/6/2022 2:30:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 3/6/2022 2:30:26 AM
3/6/2022 2:30:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 3/6/2022 2:30:26 AM
3/6/2022 2:30:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 3/6/2022 2:30:26 AM
3/6/2022 2:30:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 3/6/2022 2:30:26 AM
3/6/2022 2:30:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 3/6/2022 2:30:26 AM
3/6/2022 2:30:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 3/6/2022 2:30:26 AM
3/6/2022 2:30:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 3/6/2022 2:30:26 AM
3/6/2022 2:30:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 3/6/2022 2:30:26 AM
3/6/2022 2:30:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 3/6/2022 2:30:26 AM
3/6/2022 2:30:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:26 AM : Template Import Complete  ### 3/6/2022 2:30:26 AM
3/6/2022 2:30:29 AM : Completed Updating Has Transaction Flag  ### 3/6/2022 2:30:29 AM
3/6/2022 2:30:29 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 3/6/2022 2:30:29 AM
3/6/2022 2:30:29 AM : Zylem Access Unblocked  ### 3/6/2022 2:30:29 AM
3/6/2022 2:30:29 AM : Application Ended  ### 3/6/2022 2:30:29 AM

3/6/2022 7:30:03 AM : Start Process : checkAllTablesExists()  ### Driver={SQL Server};Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
3/6/2022 7:30:04 AM : StartProcess  ### 3/6/2022 7:30:04 AM

3/6/2022 7:30:04 AM : 11  ### 3/6/2022 7:30:04 AM

3/6/2022 7:30:04 AM : 22  ### 3/6/2022 7:30:04 AM

3/6/2022 7:30:04 AM : 33  ### 3/6/2022 7:30:04 AM

3/6/2022 7:30:04 AM : Application Started  ### 3/6/2022 7:30:04 AM

3/6/2022 7:30:04 AM : Start Process : checkAllTablesExists()  ### 
3/6/2022 7:30:04 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 3/6/2022 7:30:04 AM
3/6/2022 7:30:04 AM : MainForm_Load  ### AlertSystem ON
3/6/2022 7:30:05 AM : No. of Files to import (RECEIVEFINAL):  ### 1708
3/6/2022 7:30:05 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
3/6/2022 7:30:05 AM : For Distributor 000000000001119 Insert Count::2 ### Delete Count::0
3/6/2022 7:30:05 AM : Import AD File --->> AD_1119_20220306_a9beed5f1f221262ecd0d1733272ef6c.TXT ### 3/6/2022 7:30:05 AM
3/6/2022 7:30:06 AM : For Distributor 000000000000739 Insert Count::1 ### Delete Count::0
3/6/2022 7:30:06 AM : Import AD File --->> AD_739_20220306_56bc5bd07546d7906ae4532e911a42fb.TXT ### 3/6/2022 7:30:06 AM
3/6/2022 7:31:00 AM : For Distributor 000000000001119 Insert Count::2 ### Delete Count::0
3/6/2022 7:31:00 AM : Import IN File --->> IN_1119_20220302_6636bf0ea97565fbfe08b3a6d850b275.TXT ### 3/6/2022 7:31:00 AM
3/6/2022 7:31:00 AM : For Distributor 000000000001119 Insert Count::1 ### Delete Count::0
3/6/2022 7:31:00 AM : Import IN File --->> IN_1119_20220303_9b52a1f0098b06e86c336b5b2f0f5349.TXT ### 3/6/2022 7:31:00 AM
3/6/2022 7:31:00 AM : For Distributor 000000000001119 Insert Count::13 ### Delete Count::1
3/6/2022 7:31:00 AM : Import IN File --->> IN_1119_20220304_229c4dcf2f15939e1efa20ccb952b80e.TXT ### 3/6/2022 7:31:00 AM
3/6/2022 7:31:00 AM : For Distributor 000000000001119 Insert Count::90 ### Delete Count::0
3/6/2022 7:31:00 AM : Import IN File --->> IN_1119_20220305_d22c35ede04bb5cc6e4bbc75bb6eeaba.TXT ### 3/6/2022 7:31:00 AM
3/6/2022 7:31:17 AM : For Distributor 000000000000424 Insert Count::10 ### Delete Count::0
3/6/2022 7:31:17 AM : Import IN File --->> IN_424_20220305_770d961d0ded49f873ab599a3c4d70b3.TXT ### 3/6/2022 7:31:17 AM
3/6/2022 7:31:17 AM : Import IN File --->> IN_424_20220306_0a787a272266a9e8829be93a2d893250.TXT ### 3/6/2022 7:31:17 AM
3/6/2022 7:31:17 AM : NO Previous File For Distributor 000000000000424 ### Insert Count::1
3/6/2022 7:31:18 AM : For Distributor 000000000000739 Insert Count::11 ### Delete Count::0
3/6/2022 7:31:18 AM : Import IN File --->> IN_739_20220305_ba3406e39a4d424968679461d5864368.TXT ### 3/6/2022 7:31:18 AM
3/6/2022 7:31:20 AM : For Distributor 000000000001119 Insert Count::1 ### Delete Count::0
3/6/2022 7:31:20 AM : Import PR File --->> PR_1119_20220306_4143a5119496f86a8d14400dee6f2a7e.TXT ### 3/6/2022 7:31:20 AM
3/6/2022 7:31:20 AM : PostData() --->>  ### 3/6/2022 7:31:20 AM
3/6/2022 7:31:24 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 3/6/2022 7:31:24 AM
3/6/2022 7:31:26 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '06/Mar/2022' ### 3/6/2022 7:31:26 AM
3/6/2022 7:31:26 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '06/Mar/2022' ### 3/6/2022 7:31:26 AM
3/6/2022 7:31:26 AM :  ### 
3/6/2022 7:31:26 AM : UNLINKEDSALES Record Count Before --->> 128 ### 3/6/2022 7:31:26 AM
3/6/2022 7:31:26 AM : UNLINKEDSALES_DEL Record Count Before --->> 1 ### 3/6/2022 7:31:26 AM
3/6/2022 7:31:35 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '06/Mar/2022' ### 3/6/2022 7:31:35 AM
3/6/2022 7:31:35 AM : UNLINKEDSALES Record Count After --->> 0 ### 3/6/2022 7:31:35 AM
3/6/2022 7:31:35 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 3/6/2022 7:31:35 AM
3/6/2022 7:31:35 AM :  ### 
3/6/2022 7:31:35 AM : Posting Supplierlink Query for Purchases --->>  ### 3/6/2022 7:31:35 AM
3/6/2022 7:31:41 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '06/Mar/2022' ### 3/6/2022 7:31:41 AM
3/6/2022 7:31:46 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '06/Mar/2022' ### 3/6/2022 7:31:46 AM
3/6/2022 7:31:46 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 3/6/2022 7:31:46 AM
3/6/2022 7:31:46 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '06/Mar/2022' ### 3/6/2022 7:31:46 AM
3/6/2022 7:31:46 AM : Posting ClosingStock Successful --->>  ### 3/6/2022 7:31:46 AM
3/6/2022 7:31:46 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 3/6/2022 7:31:46 AM
3/6/2022 7:31:46 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
3/6/2022 7:31:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 3/6/2022 7:31:46 AM
3/6/2022 7:31:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 7:31:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 3/6/2022 7:31:46 AM
3/6/2022 7:31:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 7:31:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 3/6/2022 7:31:46 AM
3/6/2022 7:31:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 7:31:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 3/6/2022 7:31:46 AM
3/6/2022 7:31:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 7:31:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 3/6/2022 7:31:46 AM
3/6/2022 7:31:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 7:31:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3482327_TEMPLATE1.TXT ### 3/6/2022 7:31:46 AM
3/6/2022 7:31:46 AM : Count:: ### TEMPLATE1:17
3/6/2022 7:31:47 AM : SP_DistributorTemplatePosting Successful --->>  ### 3/6/2022 7:31:47 AM
3/6/2022 7:31:47 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3513087_TEMPLATE1.TXT ### 3/6/2022 7:31:47 AM
3/6/2022 7:31:47 AM : Count:: ### TEMPLATE1:5
3/6/2022 7:31:48 AM : SP_DistributorTemplatePosting Successful --->>  ### 3/6/2022 7:31:48 AM
3/6/2022 7:31:48 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 3/6/2022 7:31:48 AM
3/6/2022 7:31:48 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 7:31:48 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 3/6/2022 7:31:48 AM
3/6/2022 7:31:48 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 7:31:48 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3643369_TEMPLATE1.TXT ### 3/6/2022 7:31:48 AM
3/6/2022 7:31:48 AM : Count:: ### TEMPLATE1:178
3/6/2022 7:32:23 AM : SP_DistributorTemplatePosting Successful --->>  ### 3/6/2022 7:32:23 AM
3/6/2022 7:32:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 3/6/2022 7:32:23 AM
3/6/2022 7:32:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 7:32:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 3/6/2022 7:32:23 AM
3/6/2022 7:32:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 7:32:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 3/6/2022 7:32:23 AM
3/6/2022 7:32:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 7:32:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 3/6/2022 7:32:23 AM
3/6/2022 7:32:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 7:32:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 3/6/2022 7:32:23 AM
3/6/2022 7:32:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 7:32:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060893_TEMPLATE1.txt ### 3/6/2022 7:32:23 AM
3/6/2022 7:32:23 AM : Count:: ### TEMPLATE1:488
3/6/2022 7:32:53 AM : SP_DistributorTemplatePosting Successful --->>  ### 3/6/2022 7:32:53 AM
3/6/2022 7:32:53 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 3/6/2022 7:32:53 AM
3/6/2022 7:32:53 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 7:32:53 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 3/6/2022 7:32:53 AM
3/6/2022 7:32:53 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 7:32:53 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 3/6/2022 7:32:53 AM
3/6/2022 7:32:53 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 7:32:53 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061625_TEMPLATE1.txt ### 3/6/2022 7:32:53 AM
3/6/2022 7:32:53 AM : Count:: ### TEMPLATE1:158
3/6/2022 7:33:03 AM : SP_DistributorTemplatePosting Successful --->>  ### 3/6/2022 7:33:03 AM
3/6/2022 7:33:03 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 3/6/2022 7:33:03 AM
3/6/2022 7:33:03 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 7:33:03 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 3/6/2022 7:33:03 AM
3/6/2022 7:33:03 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 7:33:03 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9064126_TEMPLATE1.txt ### 3/6/2022 7:33:03 AM
3/6/2022 7:33:03 AM : Count:: ### TEMPLATE1:2
3/6/2022 7:33:04 AM : SP_DistributorTemplatePosting Successful --->>  ### 3/6/2022 7:33:04 AM
3/6/2022 7:33:04 AM : Template Import Complete  ### 3/6/2022 7:33:04 AM
3/6/2022 7:33:06 AM : Completed Updating Has Transaction Flag  ### 3/6/2022 7:33:06 AM
3/6/2022 7:33:06 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 3/6/2022 7:33:06 AM
3/6/2022 7:33:06 AM : Zylem Access Unblocked  ### 3/6/2022 7:33:06 AM
3/6/2022 7:33:07 AM : Application Ended  ### 3/6/2022 7:33:07 AM

3/6/2022 2:30:02 PM : Start Process : checkAllTablesExists()  ### Driver={SQL Server};Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
3/6/2022 2:30:03 PM : StartProcess  ### 3/6/2022 2:30:03 PM

3/6/2022 2:30:03 PM : 11  ### 3/6/2022 2:30:03 PM

3/6/2022 2:30:03 PM : 22  ### 3/6/2022 2:30:03 PM

3/6/2022 2:30:03 PM : 33  ### 3/6/2022 2:30:03 PM

3/6/2022 2:30:03 PM : Application Started  ### 3/6/2022 2:30:03 PM

3/6/2022 2:30:03 PM : Start Process : checkAllTablesExists()  ### 
3/6/2022 2:30:03 PM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 3/6/2022 2:30:03 PM
3/6/2022 2:30:03 PM : MainForm_Load  ### AlertSystem ON
3/6/2022 2:30:03 PM : No. of Files to import (RECEIVEFINAL):  ### 138
3/6/2022 2:30:03 PM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
3/6/2022 2:30:04 PM : For Distributor 000000000001289 Insert Count::12 ### Delete Count::19
3/6/2022 2:30:04 PM : Import AD File --->> AD_1289_20220306_12f7abf6de90714e99eed7b3bc98b99d.TXT ### 3/6/2022 2:30:04 PM
3/6/2022 2:30:04 PM : For Distributor 000000000001289 Insert Count::1 ### Delete Count::1
3/6/2022 2:30:04 PM : Import DN File --->> DN_1289_20220204_1c4a61e5a345fd02601a4d2e044b2c5f.TXT ### 3/6/2022 2:30:04 PM
3/6/2022 2:30:04 PM : For Distributor 000000000001289 Insert Count::3 ### Delete Count::3
3/6/2022 2:30:04 PM : Import DN File --->> DN_1289_20220205_6dbb836aa60ba991f65e284705c9a182.TXT ### 3/6/2022 2:30:04 PM
3/6/2022 2:30:04 PM : For Distributor 000000000001289 Insert Count::6 ### Delete Count::6
3/6/2022 2:30:04 PM : Import DN File --->> DN_1289_20220211_224dcca90ee13dd8410cca359763ca12.TXT ### 3/6/2022 2:30:04 PM
3/6/2022 2:30:05 PM : For Distributor 000000000001289 Insert Count::1 ### Delete Count::1
3/6/2022 2:30:05 PM : Import DN File --->> DN_1289_20220216_6027a9b37c166ad0930af5cdbaba27cd.TXT ### 3/6/2022 2:30:05 PM
3/6/2022 2:30:05 PM : For Distributor 000000000001289 Insert Count::1 ### Delete Count::1
3/6/2022 2:30:05 PM : Import DN File --->> DN_1289_20220221_89117ec2aa4402f19d94538a272cde50.TXT ### 3/6/2022 2:30:05 PM
3/6/2022 2:30:08 PM : For Distributor 000000000001289 Insert Count::5 ### Delete Count::5
3/6/2022 2:30:08 PM : Import IN File --->> IN_1289_20220216_c9d869c912b6c862652b2e8405a555a7.TXT ### 3/6/2022 2:30:08 PM
3/6/2022 2:30:08 PM : For Distributor 000000000001289 Insert Count::3 ### Delete Count::3
3/6/2022 2:30:08 PM : Import IN File --->> IN_1289_20220218_f8b6e2a88861b1642f555d5151129522.TXT ### 3/6/2022 2:30:08 PM
3/6/2022 2:30:08 PM : For Distributor 000000000001289 Insert Count::3 ### Delete Count::3
3/6/2022 2:30:08 PM : Import IN File --->> IN_1289_20220219_6d33294e129417dd9e963d58b4e1c573.TXT ### 3/6/2022 2:30:08 PM
3/6/2022 2:30:09 PM : For Distributor 000000000001289 Insert Count::10 ### Delete Count::10
3/6/2022 2:30:09 PM : Import IN File --->> IN_1289_20220222_51d4b6f4975fea4f6bcb65c2da1a053f.TXT ### 3/6/2022 2:30:09 PM
3/6/2022 2:30:09 PM : For Distributor 000000000001289 Insert Count::13 ### Delete Count::13
3/6/2022 2:30:09 PM : Import IN File --->> IN_1289_20220223_50207d03f02c6d19cae2335da6fa9d2e.TXT ### 3/6/2022 2:30:09 PM
3/6/2022 2:30:09 PM : For Distributor 000000000001289 Insert Count::10 ### Delete Count::10
3/6/2022 2:30:09 PM : Import IN File --->> IN_1289_20220224_fe25d850bbf9ec260ab6f4c59171eb5b.TXT ### 3/6/2022 2:30:09 PM
3/6/2022 2:30:09 PM : For Distributor 000000000001289 Insert Count::6 ### Delete Count::6
3/6/2022 2:30:09 PM : Import IN File --->> IN_1289_20220225_ca779764da31aca13998a0416982719c.TXT ### 3/6/2022 2:30:09 PM
3/6/2022 2:30:09 PM : For Distributor 000000000001289 Insert Count::5 ### Delete Count::4
3/6/2022 2:30:09 PM : Import IN File --->> IN_1289_20220226_01f5a64df9ba2c8050d379236e8b9c15.TXT ### 3/6/2022 2:30:09 PM
3/6/2022 2:30:09 PM : Import IN File --->> IN_1289_20220228_d0e8ed562ae0010334c1f8a3b158229f.TXT ### 3/6/2022 2:30:09 PM
3/6/2022 2:30:09 PM : NO Previous File For Distributor 000000000001289 ### Insert Count::1
3/6/2022 2:30:09 PM : Import IN File --->> IN_1289_20220301_d80e6d053fe2a3fe09b29f1173d7689f.TXT ### 3/6/2022 2:30:09 PM
3/6/2022 2:30:09 PM : NO Previous File For Distributor 000000000001289 ### Insert Count::23
3/6/2022 2:30:09 PM : Import IN File --->> IN_1289_20220302_5a89747811ea2b7e629a61324a461bde.TXT ### 3/6/2022 2:30:09 PM
3/6/2022 2:30:09 PM : NO Previous File For Distributor 000000000001289 ### Insert Count::8
3/6/2022 2:30:09 PM : Import IN File --->> IN_1289_20220303_301be106ae7117ed122cebb6ca23e662.TXT ### 3/6/2022 2:30:09 PM
3/6/2022 2:30:09 PM : NO Previous File For Distributor 000000000001289 ### Insert Count::1
3/6/2022 2:30:09 PM : Import IN File --->> IN_1289_20220304_6ea6aba7e3b1bd2c8a6dd641c3228a25.TXT ### 3/6/2022 2:30:09 PM
3/6/2022 2:30:10 PM : NO Previous File For Distributor 000000000001289 ### Insert Count::7
3/6/2022 2:30:11 PM : PostData() --->>  ### 3/6/2022 2:30:11 PM
3/6/2022 2:30:14 PM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 3/6/2022 2:30:14 PM
3/6/2022 2:30:16 PM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '06/Mar/2022' ### 3/6/2022 2:30:16 PM
3/6/2022 2:30:16 PM : ItemLink Successful --->> exec SP_ItemLinkDiff '06/Mar/2022' ### 3/6/2022 2:30:16 PM
3/6/2022 2:30:16 PM :  ### 
3/6/2022 2:30:16 PM : UNLINKEDSALES Record Count Before --->> 95 ### 3/6/2022 2:30:16 PM
3/6/2022 2:30:16 PM : UNLINKEDSALES_DEL Record Count Before --->> 54 ### 3/6/2022 2:30:16 PM
3/6/2022 2:30:32 PM : Posting Sales Successful --->> exec prPostLinkedDiffSales '06/Mar/2022' ### 3/6/2022 2:30:32 PM
3/6/2022 2:30:32 PM : UNLINKEDSALES Record Count After --->> 0 ### 3/6/2022 2:30:32 PM
3/6/2022 2:30:32 PM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 3/6/2022 2:30:32 PM
3/6/2022 2:30:32 PM :  ### 
3/6/2022 2:30:32 PM : Posting Supplierlink Query for Purchases --->>  ### 3/6/2022 2:30:32 PM
3/6/2022 2:30:39 PM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '06/Mar/2022' ### 3/6/2022 2:30:39 PM
3/6/2022 2:30:45 PM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '06/Mar/2022' ### 3/6/2022 2:30:45 PM
3/6/2022 2:30:45 PM : Posting Supplierlink Query for CompanyPurchases --->>  ### 3/6/2022 2:30:45 PM
3/6/2022 2:30:45 PM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '06/Mar/2022' ### 3/6/2022 2:30:45 PM
3/6/2022 2:30:45 PM : Posting ClosingStock Successful --->>  ### 3/6/2022 2:30:45 PM
3/6/2022 2:30:45 PM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 3/6/2022 2:30:45 PM
3/6/2022 2:30:45 PM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
3/6/2022 2:30:45 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1016226_TEMPLATE1.TXT ### 3/6/2022 2:30:45 PM
3/6/2022 2:30:45 PM : Count:: ### TEMPLATE1:57
3/6/2022 2:30:53 PM : SP_DistributorTemplatePosting Successful --->>  ### 3/6/2022 2:30:53 PM
3/6/2022 2:30:53 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 3/6/2022 2:30:53 PM
3/6/2022 2:30:53 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:53 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 3/6/2022 2:30:53 PM
3/6/2022 2:30:53 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:53 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 3/6/2022 2:30:53 PM
3/6/2022 2:30:53 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:53 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 3/6/2022 2:30:53 PM
3/6/2022 2:30:53 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:53 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 3/6/2022 2:30:53 PM
3/6/2022 2:30:53 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:53 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 3/6/2022 2:30:53 PM
3/6/2022 2:30:53 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:53 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 3/6/2022 2:30:53 PM
3/6/2022 2:30:53 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:53 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 3/6/2022 2:30:53 PM
3/6/2022 2:30:53 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:53 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 3/6/2022 2:30:53 PM
3/6/2022 2:30:53 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:54 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 3/6/2022 2:30:54 PM
3/6/2022 2:30:54 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:54 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 3/6/2022 2:30:54 PM
3/6/2022 2:30:54 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:54 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 3/6/2022 2:30:54 PM
3/6/2022 2:30:54 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:54 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 3/6/2022 2:30:54 PM
3/6/2022 2:30:54 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:54 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061033_TEMPLATE1.TXT ### 3/6/2022 2:30:54 PM
3/6/2022 2:30:54 PM : Count:: ### TEMPLATE1:37
3/6/2022 2:30:56 PM : SP_DistributorTemplatePosting Successful --->>  ### 3/6/2022 2:30:56 PM
3/6/2022 2:30:56 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 3/6/2022 2:30:56 PM
3/6/2022 2:30:56 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:56 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 3/6/2022 2:30:56 PM
3/6/2022 2:30:56 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:30:56 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061625_TEMPLATE1.txt ### 3/6/2022 2:30:56 PM
3/6/2022 2:30:56 PM : Count:: ### TEMPLATE1:158
3/6/2022 2:31:18 PM : SP_DistributorTemplatePosting Successful --->>  ### 3/6/2022 2:31:18 PM
3/6/2022 2:31:18 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 3/6/2022 2:31:18 PM
3/6/2022 2:31:18 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:31:18 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 3/6/2022 2:31:18 PM
3/6/2022 2:31:18 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/6/2022 2:31:18 PM : Template Import Complete  ### 3/6/2022 2:31:18 PM
3/6/2022 2:31:20 PM : Completed Updating Has Transaction Flag  ### 3/6/2022 2:31:20 PM
3/6/2022 2:31:20 PM : Transaction Table lastEdiDate Update on BrandAlias Update ### 3/6/2022 2:31:20 PM
3/6/2022 2:31:20 PM : Zylem Access Unblocked  ### 3/6/2022 2:31:20 PM
3/6/2022 2:31:21 PM : Application Ended  ### 3/6/2022 2:31:21 PM