1/23/2022 2:30:05 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
1/23/2022 2:30:06 AM : StartProcess  ### 1/23/2022 2:30:06 AM

1/23/2022 2:30:06 AM : 11  ### 1/23/2022 2:30:06 AM

1/23/2022 2:30:06 AM : 22  ### 1/23/2022 2:30:06 AM

1/23/2022 2:30:06 AM : 33  ### 1/23/2022 2:30:06 AM

1/23/2022 2:30:06 AM : Application Started  ### 1/23/2022 2:30:06 AM

1/23/2022 2:30:06 AM : Start Process : checkAllTablesExists()  ### 
1/23/2022 2:30:06 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 1/23/2022 2:30:06 AM
1/23/2022 2:30:06 AM : MainForm_Load  ### AlertSystem ON
1/23/2022 2:30:06 AM : No. of Files to import (RECEIVEFINAL):  ### 359
1/23/2022 2:30:07 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
1/23/2022 2:30:07 AM : For Distributor 000000000000739 Insert Count::10 ### Delete Count::0
1/23/2022 2:30:07 AM : Import IN File --->> IN_739_20220122_7946076795ebf08990b8a819be060227.TXT ### 1/23/2022 2:30:07 AM
1/23/2022 2:30:09 AM : For Distributor 000000000000820 Insert Count::1 ### Delete Count::0
1/23/2022 2:30:09 AM : Import IN File --->> IN_820_20220120_623567bb7bc0fa4320f81eb7229cb475.TXT ### 1/23/2022 2:30:09 AM
1/23/2022 2:30:09 AM : Import IN File --->> IN_820_20220121_b417e649cbd04c2f4366f2824b4025d8.TXT ### 1/23/2022 2:30:09 AM
1/23/2022 2:30:09 AM : NO Previous File For Distributor 000000000000820 ### Insert Count::6
1/23/2022 2:30:09 AM : Import IN File --->> IN_820_20220122_eb6bc317bb9427b359e1054d6be1db4f.TXT ### 1/23/2022 2:30:09 AM
1/23/2022 2:30:09 AM : NO Previous File For Distributor 000000000000820 ### Insert Count::7
1/23/2022 2:30:20 AM : For Distributor 000000000000947 Insert Count::7 ### Delete Count::0
1/23/2022 2:30:20 AM : Import IN File --->> IN_947_20220102_e189145dad5cee27bb59d900b6fcd5de.TXT ### 1/23/2022 2:30:20 AM
1/23/2022 2:30:21 AM : Import OT File --->> OT_947_20220102_e189145dad5cee27bb59d900b6fcd5de.TXT ### 1/23/2022 2:30:21 AM
1/23/2022 2:30:21 AM : NO Previous File For Distributor 000000000000947 ### Insert Count::7
1/23/2022 2:30:21 AM : For Distributor 000000000001025 Insert Count::1 ### Delete Count::0
1/23/2022 2:30:21 AM : Import PR File --->> PR_1025_20220122_cc60f852701970edefb1c2ab0ad007af.TXT ### 1/23/2022 2:30:21 AM
1/23/2022 2:30:21 AM : For Distributor 000000000001274 Insert Count::5 ### Delete Count::0
1/23/2022 2:30:21 AM : Import PR File --->> PR_1274_20220122_e2045d852e7ead2b9ece12af35507030.TXT ### 1/23/2022 2:30:21 AM
1/23/2022 2:30:21 AM : For Distributor 000000000000357 Insert Count::19 ### Delete Count::11
1/23/2022 2:30:21 AM : Import PR File --->> PR_357_20220122_98084a5b907a41743eaf6d3a84ef83b1.TXT ### 1/23/2022 2:30:21 AM
1/23/2022 2:30:22 AM : PostData() --->>  ### 1/23/2022 2:30:22 AM
1/23/2022 2:30:23 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 1/23/2022 2:30:23 AM
1/23/2022 2:30:23 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '23/Jan/2022' ### 1/23/2022 2:30:23 AM
1/23/2022 2:30:24 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '23/Jan/2022' ### 1/23/2022 2:30:24 AM
1/23/2022 2:30:24 AM :  ### 
1/23/2022 2:30:24 AM : UNLINKEDSALES Record Count Before --->> 31 ### 1/23/2022 2:30:24 AM
1/23/2022 2:30:24 AM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 1/23/2022 2:30:24 AM
1/23/2022 2:30:33 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '23/Jan/2022' ### 1/23/2022 2:30:33 AM
1/23/2022 2:30:33 AM : UNLINKEDSALES Record Count After --->> 0 ### 1/23/2022 2:30:33 AM
1/23/2022 2:30:33 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 1/23/2022 2:30:33 AM
1/23/2022 2:30:33 AM :  ### 
1/23/2022 2:30:33 AM : Posting Supplierlink Query for Purchases --->>  ### 1/23/2022 2:30:33 AM
1/23/2022 2:30:39 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '23/Jan/2022' ### 1/23/2022 2:30:39 AM
1/23/2022 2:30:45 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '23/Jan/2022' ### 1/23/2022 2:30:45 AM
1/23/2022 2:30:45 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 1/23/2022 2:30:45 AM
1/23/2022 2:30:45 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '23/Jan/2022' ### 1/23/2022 2:30:45 AM
1/23/2022 2:30:45 AM : Posting ClosingStock Successful --->>  ### 1/23/2022 2:30:45 AM
1/23/2022 2:30:45 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 1/23/2022 2:30:45 AM
1/23/2022 2:30:45 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
1/23/2022 2:30:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 1/23/2022 2:30:45 AM
1/23/2022 2:30:45 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:30:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 1/23/2022 2:30:45 AM
1/23/2022 2:30:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:30:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 1/23/2022 2:30:46 AM
1/23/2022 2:30:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:30:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 1/23/2022 2:30:46 AM
1/23/2022 2:30:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:30:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 1/23/2022 2:30:46 AM
1/23/2022 2:30:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:30:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 1/23/2022 2:30:46 AM
1/23/2022 2:30:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:30:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 1/23/2022 2:30:46 AM
1/23/2022 2:30:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:30:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 1/23/2022 2:30:46 AM
1/23/2022 2:30:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:30:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 1/23/2022 2:30:46 AM
1/23/2022 2:30:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:30:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 1/23/2022 2:30:46 AM
1/23/2022 2:30:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:30:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 1/23/2022 2:30:46 AM
1/23/2022 2:30:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:30:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 1/23/2022 2:30:46 AM
1/23/2022 2:30:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:30:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 1/23/2022 2:30:46 AM
1/23/2022 2:30:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:30:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 1/23/2022 2:30:46 AM
1/23/2022 2:30:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:30:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 1/23/2022 2:30:46 AM
1/23/2022 2:30:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:30:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 1/23/2022 2:30:46 AM
1/23/2022 2:30:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:30:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 1/23/2022 2:30:46 AM
1/23/2022 2:30:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:30:46 AM : Template Import Complete  ### 1/23/2022 2:30:46 AM
1/23/2022 2:30:48 AM : Completed Updating Has Transaction Flag  ### 1/23/2022 2:30:48 AM
1/23/2022 2:30:48 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 1/23/2022 2:30:48 AM
1/23/2022 2:30:48 AM : Zylem Access Unblocked  ### 1/23/2022 2:30:48 AM
1/23/2022 2:30:49 AM : Application Ended  ### 1/23/2022 2:30:49 AM

1/23/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
1/23/2022 7:30:04 AM : StartProcess  ### 1/23/2022 7:30:04 AM

1/23/2022 7:30:04 AM : 11  ### 1/23/2022 7:30:04 AM

1/23/2022 7:30:04 AM : 22  ### 1/23/2022 7:30:04 AM

1/23/2022 7:30:04 AM : 33  ### 1/23/2022 7:30:04 AM

1/23/2022 7:30:04 AM : Application Started  ### 1/23/2022 7:30:04 AM

1/23/2022 7:30:04 AM : Start Process : checkAllTablesExists()  ### 
1/23/2022 7:30:04 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 1/23/2022 7:30:04 AM
1/23/2022 7:30:04 AM : MainForm_Load  ### AlertSystem ON
1/23/2022 7:30:04 AM : No. of Files to import (RECEIVEFINAL):  ### 1519
1/23/2022 7:30:04 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
1/23/2022 7:30:04 AM : For Distributor 000000000001047 Insert Count::1 ### Delete Count::0
1/23/2022 7:30:04 AM : Import AD File --->> AD_1047_20220123_fcdceccc3a38ee1b0b90d4e8375adbf1.TXT ### 1/23/2022 7:30:04 AM
1/23/2022 7:30:05 AM : For Distributor 000000000001119 Insert Count::1 ### Delete Count::0
1/23/2022 7:30:05 AM : Import AD File --->> AD_1119_20220123_a35e2eb0f62fbb2533da7bb4a8dff2a7.TXT ### 1/23/2022 7:30:05 AM
1/23/2022 7:30:47 AM : For Distributor 000000000001047 Insert Count::13 ### Delete Count::0
1/23/2022 7:30:47 AM : Import IN File --->> IN_1047_20220122_143c224f115620c8123187529e78f925.TXT ### 1/23/2022 7:30:47 AM
1/23/2022 7:30:49 AM : For Distributor 000000000001119 Insert Count::13 ### Delete Count::0
1/23/2022 7:30:49 AM : Import IN File --->> IN_1119_20220122_b80a44250547b6cd57e64b63662f19f5.TXT ### 1/23/2022 7:30:49 AM
1/23/2022 7:30:49 AM : Import IN File --->> IN_1119_20220123_78f1483476b48d2db0bc2395f932134c.TXT ### 1/23/2022 7:30:49 AM
1/23/2022 7:30:49 AM : NO Previous File For Distributor 000000000001119 ### Insert Count::1
1/23/2022 7:31:02 AM : PostData() --->>  ### 1/23/2022 7:31:02 AM
1/23/2022 7:31:03 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 1/23/2022 7:31:03 AM
1/23/2022 7:31:04 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '23/Jan/2022' ### 1/23/2022 7:31:04 AM
1/23/2022 7:31:05 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '23/Jan/2022' ### 1/23/2022 7:31:05 AM
1/23/2022 7:31:05 AM :  ### 
1/23/2022 7:31:05 AM : UNLINKEDSALES Record Count Before --->> 27 ### 1/23/2022 7:31:05 AM
1/23/2022 7:31:05 AM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 1/23/2022 7:31:05 AM
1/23/2022 7:31:12 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '23/Jan/2022' ### 1/23/2022 7:31:12 AM
1/23/2022 7:31:12 AM : UNLINKEDSALES Record Count After --->> 0 ### 1/23/2022 7:31:12 AM
1/23/2022 7:31:12 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 1/23/2022 7:31:12 AM
1/23/2022 7:31:12 AM :  ### 
1/23/2022 7:31:12 AM : Posting Supplierlink Query for Purchases --->>  ### 1/23/2022 7:31:12 AM
1/23/2022 7:31:18 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '23/Jan/2022' ### 1/23/2022 7:31:18 AM
1/23/2022 7:31:24 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '23/Jan/2022' ### 1/23/2022 7:31:24 AM
1/23/2022 7:31:24 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 1/23/2022 7:31:24 AM
1/23/2022 7:31:24 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '23/Jan/2022' ### 1/23/2022 7:31:24 AM
1/23/2022 7:31:24 AM : Posting ClosingStock Successful --->>  ### 1/23/2022 7:31:24 AM
1/23/2022 7:31:25 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 1/23/2022 7:31:25 AM
1/23/2022 7:31:25 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
1/23/2022 7:31:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 1/23/2022 7:31:25 AM
1/23/2022 7:31:25 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 7:31:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 1/23/2022 7:31:25 AM
1/23/2022 7:31:25 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 7:31:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 1/23/2022 7:31:25 AM
1/23/2022 7:31:25 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 7:31:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 1/23/2022 7:31:25 AM
1/23/2022 7:31:25 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 7:31:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 1/23/2022 7:31:25 AM
1/23/2022 7:31:25 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 7:31:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3482327_TEMPLATE1.TXT ### 1/23/2022 7:31:25 AM
1/23/2022 7:31:25 AM : Count:: ### TEMPLATE1:30
1/23/2022 7:31:26 AM : SP_DistributorTemplatePosting Successful --->>  ### 1/23/2022 7:31:26 AM
1/23/2022 7:31:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 1/23/2022 7:31:26 AM
1/23/2022 7:31:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 7:31:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 1/23/2022 7:31:26 AM
1/23/2022 7:31:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 7:31:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 1/23/2022 7:31:26 AM
1/23/2022 7:31:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 7:31:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 1/23/2022 7:31:26 AM
1/23/2022 7:31:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 7:31:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 1/23/2022 7:31:26 AM
1/23/2022 7:31:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 7:31:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 1/23/2022 7:31:26 AM
1/23/2022 7:31:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 7:31:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 1/23/2022 7:31:26 AM
1/23/2022 7:31:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 7:31:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 1/23/2022 7:31:26 AM
1/23/2022 7:31:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 7:31:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 1/23/2022 7:31:26 AM
1/23/2022 7:31:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 7:31:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 1/23/2022 7:31:26 AM
1/23/2022 7:31:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 7:31:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061625_TEMPLATE1.txt ### 1/23/2022 7:31:26 AM
1/23/2022 7:31:26 AM : Count:: ### TEMPLATE1:158
1/23/2022 7:31:35 AM : SP_DistributorTemplatePosting Successful --->>  ### 1/23/2022 7:31:35 AM
1/23/2022 7:31:35 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 1/23/2022 7:31:35 AM
1/23/2022 7:31:35 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 7:31:35 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 1/23/2022 7:31:35 AM
1/23/2022 7:31:35 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 7:31:35 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9065122_TEMPLATE1.txt ### 1/23/2022 7:31:35 AM
1/23/2022 7:31:35 AM : Count:: ### TEMPLATE1:126
1/23/2022 7:31:52 AM : SP_DistributorTemplatePosting Successful --->>  ### 1/23/2022 7:31:52 AM
1/23/2022 7:31:52 AM : Template Import Complete  ### 1/23/2022 7:31:52 AM
1/23/2022 7:31:54 AM : Completed Updating Has Transaction Flag  ### 1/23/2022 7:31:54 AM
1/23/2022 7:31:54 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 1/23/2022 7:31:54 AM
1/23/2022 7:31:54 AM : Zylem Access Unblocked  ### 1/23/2022 7:31:54 AM
1/23/2022 7:31:55 AM : Application Ended  ### 1/23/2022 7:31:55 AM

1/23/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
1/23/2022 2:30:03 PM : StartProcess  ### 1/23/2022 2:30:03 PM

1/23/2022 2:30:03 PM : 11  ### 1/23/2022 2:30:03 PM

1/23/2022 2:30:03 PM : 22  ### 1/23/2022 2:30:03 PM

1/23/2022 2:30:03 PM : 33  ### 1/23/2022 2:30:03 PM

1/23/2022 2:30:03 PM : Application Started  ### 1/23/2022 2:30:03 PM

1/23/2022 2:30:03 PM : Start Process : checkAllTablesExists()  ### 
1/23/2022 2:30:03 PM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 1/23/2022 2:30:03 PM
1/23/2022 2:30:03 PM : MainForm_Load  ### AlertSystem ON
1/23/2022 2:30:03 PM : No. of Files to import (RECEIVEFINAL):  ### 887
1/23/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
1/23/2022 2:30:04 PM : For Distributor 000000000000362 Insert Count::0 ### Delete Count::4
1/23/2022 2:30:04 PM : Import AD File --->> AD_362_20220123_d9a644f1c779da02d8d57e82751c301e.TXT ### 1/23/2022 2:30:04 PM
1/23/2022 2:30:04 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::48
1/23/2022 2:30:04 PM : Import AD File --->> AD_525_20220123_9def1204b2242d916d9b1aaf3f1a8371.TXT ### 1/23/2022 2:30:04 PM
1/23/2022 2:30:20 PM : For Distributor 000000000000362 Insert Count::0 ### Delete Count::2
1/23/2022 2:30:20 PM : Import IN File --->> IN_362_20211202_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:20 PM
1/23/2022 2:30:21 PM : For Distributor 000000000000362 Insert Count::0 ### Delete Count::3
1/23/2022 2:30:21 PM : Import IN File --->> IN_362_20211203_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:21 PM
1/23/2022 2:30:21 PM : For Distributor 000000000000362 Insert Count::0 ### Delete Count::5
1/23/2022 2:30:21 PM : Import IN File --->> IN_362_20211207_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:21 PM
1/23/2022 2:30:21 PM : For Distributor 000000000000362 Insert Count::0 ### Delete Count::4
1/23/2022 2:30:21 PM : Import IN File --->> IN_362_20211209_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:21 PM
1/23/2022 2:30:21 PM : For Distributor 000000000000362 Insert Count::0 ### Delete Count::2
1/23/2022 2:30:21 PM : Import IN File --->> IN_362_20211213_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:21 PM
1/23/2022 2:30:21 PM : For Distributor 000000000000362 Insert Count::0 ### Delete Count::1
1/23/2022 2:30:21 PM : Import IN File --->> IN_362_20211214_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:21 PM
1/23/2022 2:30:22 PM : For Distributor 000000000000362 Insert Count::0 ### Delete Count::2
1/23/2022 2:30:22 PM : Import IN File --->> IN_362_20211215_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:22 PM
1/23/2022 2:30:22 PM : For Distributor 000000000000362 Insert Count::0 ### Delete Count::1
1/23/2022 2:30:22 PM : Import IN File --->> IN_362_20211217_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:22 PM
1/23/2022 2:30:22 PM : For Distributor 000000000000362 Insert Count::0 ### Delete Count::1
1/23/2022 2:30:22 PM : Import IN File --->> IN_362_20211220_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:22 PM
1/23/2022 2:30:22 PM : For Distributor 000000000000362 Insert Count::0 ### Delete Count::1
1/23/2022 2:30:22 PM : Import IN File --->> IN_362_20211221_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:22 PM
1/23/2022 2:30:22 PM : For Distributor 000000000000362 Insert Count::0 ### Delete Count::3
1/23/2022 2:30:22 PM : Import IN File --->> IN_362_20211222_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:22 PM
1/23/2022 2:30:35 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::11
1/23/2022 2:30:35 PM : Import IN File --->> IN_525_20211209_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:35 PM
1/23/2022 2:30:35 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::14
1/23/2022 2:30:35 PM : Import IN File --->> IN_525_20211210_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:35 PM
1/23/2022 2:30:35 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::9
1/23/2022 2:30:35 PM : Import IN File --->> IN_525_20211211_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:35 PM
1/23/2022 2:30:35 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::11
1/23/2022 2:30:35 PM : Import IN File --->> IN_525_20211212_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:35 PM
1/23/2022 2:30:36 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::9
1/23/2022 2:30:36 PM : Import IN File --->> IN_525_20211213_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:36 PM
1/23/2022 2:30:36 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::13
1/23/2022 2:30:36 PM : Import IN File --->> IN_525_20211215_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:36 PM
1/23/2022 2:30:36 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::13
1/23/2022 2:30:36 PM : Import IN File --->> IN_525_20211216_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:36 PM
1/23/2022 2:30:36 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::13
1/23/2022 2:30:36 PM : Import IN File --->> IN_525_20211217_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:36 PM
1/23/2022 2:30:36 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::6
1/23/2022 2:30:36 PM : Import IN File --->> IN_525_20211218_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:36 PM
1/23/2022 2:30:36 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::10
1/23/2022 2:30:36 PM : Import IN File --->> IN_525_20211219_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:36 PM
1/23/2022 2:30:36 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::9
1/23/2022 2:30:36 PM : Import IN File --->> IN_525_20211220_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:36 PM
1/23/2022 2:30:36 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::13
1/23/2022 2:30:36 PM : Import IN File --->> IN_525_20211222_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:36 PM
1/23/2022 2:30:37 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::7
1/23/2022 2:30:37 PM : Import IN File --->> IN_525_20211223_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:37 PM
1/23/2022 2:30:37 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::7
1/23/2022 2:30:37 PM : Import IN File --->> IN_525_20211224_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:37 PM
1/23/2022 2:30:37 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::4
1/23/2022 2:30:37 PM : Import IN File --->> IN_525_20211225_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:37 PM
1/23/2022 2:30:37 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::7
1/23/2022 2:30:37 PM : Import IN File --->> IN_525_20211226_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:37 PM
1/23/2022 2:30:37 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::4
1/23/2022 2:30:37 PM : Import IN File --->> IN_525_20211227_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:37 PM
1/23/2022 2:30:37 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::12
1/23/2022 2:30:37 PM : Import IN File --->> IN_525_20211229_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:37 PM
1/23/2022 2:30:37 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::2
1/23/2022 2:30:37 PM : Import IN File --->> IN_525_20211230_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:37 PM
1/23/2022 2:30:37 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::5
1/23/2022 2:30:37 PM : Import IN File --->> IN_525_20211231_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:37 PM
1/23/2022 2:30:38 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::11
1/23/2022 2:30:38 PM : Import IN File --->> IN_525_20220101_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:38 PM
1/23/2022 2:30:38 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::6
1/23/2022 2:30:38 PM : Import IN File --->> IN_525_20220102_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:38 PM
1/23/2022 2:30:38 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::5
1/23/2022 2:30:38 PM : Import IN File --->> IN_525_20220103_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:38 PM
1/23/2022 2:30:38 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::12
1/23/2022 2:30:38 PM : Import IN File --->> IN_525_20220105_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:38 PM
1/23/2022 2:30:38 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::9
1/23/2022 2:30:38 PM : Import IN File --->> IN_525_20220106_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:38 PM
1/23/2022 2:30:38 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::15
1/23/2022 2:30:38 PM : Import IN File --->> IN_525_20220107_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:38 PM
1/23/2022 2:30:38 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::5
1/23/2022 2:30:38 PM : Import IN File --->> IN_525_20220108_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:38 PM
1/23/2022 2:30:38 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::14
1/23/2022 2:30:38 PM : Import IN File --->> IN_525_20220109_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:38 PM
1/23/2022 2:30:39 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::12
1/23/2022 2:30:39 PM : Import IN File --->> IN_525_20220110_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:39 PM
1/23/2022 2:30:39 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::8
1/23/2022 2:30:39 PM : Import IN File --->> IN_525_20220112_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:39 PM
1/23/2022 2:30:39 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::7
1/23/2022 2:30:39 PM : Import IN File --->> IN_525_20220113_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:39 PM
1/23/2022 2:30:39 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::10
1/23/2022 2:30:39 PM : Import IN File --->> IN_525_20220114_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:39 PM
1/23/2022 2:30:39 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::10
1/23/2022 2:30:39 PM : Import IN File --->> IN_525_20220115_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:39 PM
1/23/2022 2:30:39 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::8
1/23/2022 2:30:39 PM : Import IN File --->> IN_525_20220116_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:39 PM
1/23/2022 2:30:39 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::4
1/23/2022 2:30:39 PM : Import IN File --->> IN_525_20220117_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:39 PM
1/23/2022 2:30:39 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::7
1/23/2022 2:30:39 PM : Import IN File --->> IN_525_20220119_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:39 PM
1/23/2022 2:30:39 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::11
1/23/2022 2:30:39 PM : Import IN File --->> IN_525_20220120_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:39 PM
1/23/2022 2:30:40 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::5
1/23/2022 2:30:40 PM : Import IN File --->> IN_525_20220121_d41d8cd98f00b204e9800998ecf8427e.TXT ### 1/23/2022 2:30:40 PM
1/23/2022 2:30:42 PM : For Distributor 000000000000739 Insert Count::3 ### Delete Count::0
1/23/2022 2:30:42 PM : Import IN File --->> IN_739_20220123_36f2b444df9ef86d1cdc0dece12d3f75.TXT ### 1/23/2022 2:30:42 PM
1/23/2022 2:30:42 PM : For Distributor 000000000000525 Insert Count::0 ### Delete Count::5
1/23/2022 2:30:42 PM : Import PR File --->> PR_525_20220123_82c7c91577945338d8af1448fc259089.TXT ### 1/23/2022 2:30:42 PM
1/23/2022 2:30:42 PM : PostData() --->>  ### 1/23/2022 2:30:42 PM
1/23/2022 2:30:42 PM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 1/23/2022 2:30:42 PM
1/23/2022 2:30:43 PM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '23/Jan/2022' ### 1/23/2022 2:30:43 PM
1/23/2022 2:30:43 PM : ItemLink Successful --->> exec SP_ItemLinkDiff '23/Jan/2022' ### 1/23/2022 2:30:43 PM
1/23/2022 2:30:43 PM :  ### 
1/23/2022 2:30:43 PM : UNLINKEDSALES Record Count Before --->> 3 ### 1/23/2022 2:30:43 PM
1/23/2022 2:30:43 PM : UNLINKEDSALES_DEL Record Count Before --->> 363 ### 1/23/2022 2:30:43 PM
1/23/2022 2:30:51 PM : Posting Sales Successful --->> exec prPostLinkedDiffSales '23/Jan/2022' ### 1/23/2022 2:30:51 PM
1/23/2022 2:30:51 PM : UNLINKEDSALES Record Count After --->> 0 ### 1/23/2022 2:30:51 PM
1/23/2022 2:30:51 PM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 1/23/2022 2:30:51 PM
1/23/2022 2:30:51 PM :  ### 
1/23/2022 2:30:51 PM : Posting Supplierlink Query for Purchases --->>  ### 1/23/2022 2:30:51 PM
1/23/2022 2:30:57 PM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '23/Jan/2022' ### 1/23/2022 2:30:57 PM
1/23/2022 2:31:03 PM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '23/Jan/2022' ### 1/23/2022 2:31:03 PM
1/23/2022 2:31:03 PM : Posting Supplierlink Query for CompanyPurchases --->>  ### 1/23/2022 2:31:03 PM
1/23/2022 2:31:03 PM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '23/Jan/2022' ### 1/23/2022 2:31:03 PM
1/23/2022 2:31:04 PM : Posting ClosingStock Successful --->>  ### 1/23/2022 2:31:04 PM
1/23/2022 2:31:04 PM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 1/23/2022 2:31:04 PM
1/23/2022 2:31:04 PM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
1/23/2022 2:31:04 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 1/23/2022 2:31:04 PM
1/23/2022 2:31:04 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:31:04 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 1/23/2022 2:31:04 PM
1/23/2022 2:31:04 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:31:04 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 1/23/2022 2:31:04 PM
1/23/2022 2:31:04 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:31:04 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 1/23/2022 2:31:04 PM
1/23/2022 2:31:04 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:31:04 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 1/23/2022 2:31:04 PM
1/23/2022 2:31:04 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:31:04 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3482327_TEMPLATE1.TXT ### 1/23/2022 2:31:04 PM
1/23/2022 2:31:04 PM : Count:: ### TEMPLATE1:30
1/23/2022 2:31:05 PM : SP_DistributorTemplatePosting Successful --->>  ### 1/23/2022 2:31:05 PM
1/23/2022 2:31:05 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 1/23/2022 2:31:05 PM
1/23/2022 2:31:05 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:31:05 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 1/23/2022 2:31:05 PM
1/23/2022 2:31:05 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:31:05 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3643369_TEMPLATE1.TXT ### 1/23/2022 2:31:05 PM
1/23/2022 2:31:05 PM : Count:: ### TEMPLATE1:178
1/23/2022 2:31:40 PM : SP_DistributorTemplatePosting Successful --->>  ### 1/23/2022 2:31:40 PM
1/23/2022 2:31:40 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 1/23/2022 2:31:40 PM
1/23/2022 2:31:40 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:31:40 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 1/23/2022 2:31:40 PM
1/23/2022 2:31:40 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:31:40 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 1/23/2022 2:31:40 PM
1/23/2022 2:31:40 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:31:40 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 1/23/2022 2:31:40 PM
1/23/2022 2:31:40 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:31:40 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 1/23/2022 2:31:40 PM
1/23/2022 2:31:40 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:31:40 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 1/23/2022 2:31:40 PM
1/23/2022 2:31:40 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:31:40 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061033_TEMPLATE1.TXT ### 1/23/2022 2:31:40 PM
1/23/2022 2:31:40 PM : Count:: ### TEMPLATE1:17
1/23/2022 2:31:41 PM : SP_DistributorTemplatePosting Successful --->>  ### 1/23/2022 2:31:41 PM
1/23/2022 2:31:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 1/23/2022 2:31:41 PM
1/23/2022 2:31:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:31:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 1/23/2022 2:31:41 PM
1/23/2022 2:31:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:31:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 1/23/2022 2:31:41 PM
1/23/2022 2:31:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:31:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 1/23/2022 2:31:41 PM
1/23/2022 2:31:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/23/2022 2:31:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9064126_TEMPLATE1.txt ### 1/23/2022 2:31:41 PM
1/23/2022 2:31:41 PM : Count:: ### TEMPLATE1:2
1/23/2022 2:31:41 PM : SP_DistributorTemplatePosting Successful --->>  ### 1/23/2022 2:31:41 PM
1/23/2022 2:31:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067123_TEMPLATE1.txt ### 1/23/2022 2:31:41 PM
1/23/2022 2:31:41 PM : Count:: ### TEMPLATE1:18
1/23/2022 2:31:44 PM : SP_DistributorTemplatePosting Successful --->>  ### 1/23/2022 2:31:44 PM
1/23/2022 2:31:44 PM : Template Import Complete  ### 1/23/2022 2:31:44 PM
1/23/2022 2:31:46 PM : Completed Updating Has Transaction Flag  ### 1/23/2022 2:31:46 PM
1/23/2022 2:31:46 PM : Transaction Table lastEdiDate Update on BrandAlias Update ### 1/23/2022 2:31:46 PM
1/23/2022 2:31:46 PM : Zylem Access Unblocked  ### 1/23/2022 2:31:46 PM
1/23/2022 2:31:47 PM : Application Ended  ### 1/23/2022 2:31:47 PM