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

2/20/2022 2:30:04 AM : 11  ### 2/20/2022 2:30:04 AM

2/20/2022 2:30:04 AM : 22  ### 2/20/2022 2:30:04 AM

2/20/2022 2:30:04 AM : 33  ### 2/20/2022 2:30:04 AM

2/20/2022 2:30:04 AM : Application Started  ### 2/20/2022 2:30:04 AM

2/20/2022 2:30:04 AM : Start Process : checkAllTablesExists()  ### 
2/20/2022 2:30:04 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 2/20/2022 2:30:04 AM
2/20/2022 2:30:04 AM : MainForm_Load  ### AlertSystem ON
2/20/2022 2:30:05 AM : No. of Files to import (RECEIVEFINAL):  ### 1
2/20/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
2/20/2022 2:30:05 AM : PostData() --->>  ### 2/20/2022 2:30:05 AM
2/20/2022 2:30:05 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 2/20/2022 2:30:05 AM
2/20/2022 2:30:06 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '20/Feb/2022' ### 2/20/2022 2:30:06 AM
2/20/2022 2:30:06 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '20/Feb/2022' ### 2/20/2022 2:30:06 AM
2/20/2022 2:30:06 AM :  ### 
2/20/2022 2:30:06 AM : UNLINKEDSALES Record Count Before --->> 42 ### 2/20/2022 2:30:06 AM
2/20/2022 2:30:06 AM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 2/20/2022 2:30:06 AM
2/20/2022 2:30:14 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '20/Feb/2022' ### 2/20/2022 2:30:14 AM
2/20/2022 2:30:14 AM : UNLINKEDSALES Record Count After --->> 42 ### 2/20/2022 2:30:14 AM
2/20/2022 2:30:14 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 2/20/2022 2:30:14 AM
2/20/2022 2:30:14 AM :  ### 
2/20/2022 2:30:14 AM : Posting Supplierlink Query for Purchases --->>  ### 2/20/2022 2:30:14 AM
2/20/2022 2:30:20 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '20/Feb/2022' ### 2/20/2022 2:30:20 AM
2/20/2022 2:30:26 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '20/Feb/2022' ### 2/20/2022 2:30:26 AM
2/20/2022 2:30:26 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 2/20/2022 2:30:26 AM
2/20/2022 2:30:26 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '20/Feb/2022' ### 2/20/2022 2:30:26 AM
2/20/2022 2:30:27 AM : Posting ClosingStock Successful --->>  ### 2/20/2022 2:30:27 AM
2/20/2022 2:30:27 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 2/20/2022 2:30:27 AM
2/20/2022 2:30:27 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
2/20/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 2/20/2022 2:30:27 AM
2/20/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 2/20/2022 2:30:27 AM
2/20/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 2/20/2022 2:30:27 AM
2/20/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 2/20/2022 2:30:27 AM
2/20/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 2/20/2022 2:30:27 AM
2/20/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 2/20/2022 2:30:27 AM
2/20/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 2/20/2022 2:30:27 AM
2/20/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 2/20/2022 2:30:27 AM
2/20/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 2/20/2022 2:30:27 AM
2/20/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 2/20/2022 2:30:27 AM
2/20/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 2/20/2022 2:30:27 AM
2/20/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 2/20/2022 2:30:27 AM
2/20/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 2/20/2022 2:30:27 AM
2/20/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 2/20/2022 2:30:27 AM
2/20/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 2/20/2022 2:30:27 AM
2/20/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 2/20/2022 2:30:27 AM
2/20/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 2/20/2022 2:30:27 AM
2/20/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:30:27 AM : Template Import Complete  ### 2/20/2022 2:30:27 AM
2/20/2022 2:30:30 AM : Completed Updating Has Transaction Flag  ### 2/20/2022 2:30:30 AM
2/20/2022 2:30:30 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 2/20/2022 2:30:30 AM
2/20/2022 2:30:30 AM : Zylem Access Unblocked  ### 2/20/2022 2:30:30 AM
2/20/2022 2:30:30 AM : Application Ended  ### 2/20/2022 2:30:30 AM

2/20/2022 7:30:02 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
2/20/2022 7:30:03 AM : StartProcess  ### 2/20/2022 7:30:03 AM

2/20/2022 7:30:03 AM : 11  ### 2/20/2022 7:30:03 AM

2/20/2022 7:30:03 AM : 22  ### 2/20/2022 7:30:03 AM

2/20/2022 7:30:03 AM : 33  ### 2/20/2022 7:30:03 AM

2/20/2022 7:30:03 AM : Application Started  ### 2/20/2022 7:30:03 AM

2/20/2022 7:30:03 AM : Start Process : checkAllTablesExists()  ### 
2/20/2022 7:30:03 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 2/20/2022 7:30:03 AM
2/20/2022 7:30:03 AM : MainForm_Load  ### AlertSystem ON
2/20/2022 7:30:03 AM : No. of Files to import (RECEIVEFINAL):  ### 1237
2/20/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
2/20/2022 7:30:34 AM : For Distributor 000000000001026 Insert Count::1 ### Delete Count::0
2/20/2022 7:30:34 AM : Import IN File --->> IN_1026_20220219_a6d7eac5576bcca282813f49bd810b20.TXT ### 2/20/2022 7:30:34 AM
2/20/2022 7:30:48 AM : For Distributor 000000000000424 Insert Count::11 ### Delete Count::0
2/20/2022 7:30:48 AM : Import IN File --->> IN_424_20220219_8f5358519c7fc93d8175a23c45766238.TXT ### 2/20/2022 7:30:48 AM
2/20/2022 7:30:50 AM : For Distributor 000000000000739 Insert Count::16 ### Delete Count::0
2/20/2022 7:30:50 AM : Import IN File --->> IN_739_20220219_c015b7a63e7adc52caa4d81cc6e25bfb.TXT ### 2/20/2022 7:30:50 AM
2/20/2022 7:30:53 AM : PostData() --->>  ### 2/20/2022 7:30:53 AM
2/20/2022 7:30:54 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 2/20/2022 7:30:54 AM
2/20/2022 7:30:54 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '20/Feb/2022' ### 2/20/2022 7:30:54 AM
2/20/2022 7:30:55 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '20/Feb/2022' ### 2/20/2022 7:30:55 AM
2/20/2022 7:30:55 AM :  ### 
2/20/2022 7:30:55 AM : UNLINKEDSALES Record Count Before --->> 70 ### 2/20/2022 7:30:55 AM
2/20/2022 7:30:55 AM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 2/20/2022 7:30:55 AM
2/20/2022 7:31:02 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '20/Feb/2022' ### 2/20/2022 7:31:02 AM
2/20/2022 7:31:02 AM : UNLINKEDSALES Record Count After --->> 42 ### 2/20/2022 7:31:02 AM
2/20/2022 7:31:02 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 2/20/2022 7:31:02 AM
2/20/2022 7:31:02 AM :  ### 
2/20/2022 7:31:02 AM : Posting Supplierlink Query for Purchases --->>  ### 2/20/2022 7:31:02 AM
2/20/2022 7:31:08 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '20/Feb/2022' ### 2/20/2022 7:31:08 AM
2/20/2022 7:31:14 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '20/Feb/2022' ### 2/20/2022 7:31:14 AM
2/20/2022 7:31:14 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 2/20/2022 7:31:14 AM
2/20/2022 7:31:14 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '20/Feb/2022' ### 2/20/2022 7:31:14 AM
2/20/2022 7:31:14 AM : Posting ClosingStock Successful --->>  ### 2/20/2022 7:31:14 AM
2/20/2022 7:31:14 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 2/20/2022 7:31:14 AM
2/20/2022 7:31:14 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
2/20/2022 7:31:14 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 2/20/2022 7:31:14 AM
2/20/2022 7:31:14 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 7:31:14 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 2/20/2022 7:31:14 AM
2/20/2022 7:31:14 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 7:31:14 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 2/20/2022 7:31:14 AM
2/20/2022 7:31:14 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 7:31:14 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 2/20/2022 7:31:14 AM
2/20/2022 7:31:14 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 7:31:14 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 2/20/2022 7:31:14 AM
2/20/2022 7:31:14 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 7:31:14 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3482327_TEMPLATE1.TXT ### 2/20/2022 7:31:14 AM
2/20/2022 7:31:14 AM : Count:: ### TEMPLATE1:28
2/20/2022 7:31:15 AM : SP_DistributorTemplatePosting Successful --->>  ### 2/20/2022 7:31:15 AM
2/20/2022 7:31:15 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 2/20/2022 7:31:15 AM
2/20/2022 7:31:15 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 7:31:15 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 2/20/2022 7:31:15 AM
2/20/2022 7:31:15 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 7:31:15 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 2/20/2022 7:31:15 AM
2/20/2022 7:31:15 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 7:31:15 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 2/20/2022 7:31:15 AM
2/20/2022 7:31:15 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 7:31:15 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 2/20/2022 7:31:15 AM
2/20/2022 7:31:15 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 7:31:15 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 2/20/2022 7:31:15 AM
2/20/2022 7:31:15 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 7:31:15 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 2/20/2022 7:31:15 AM
2/20/2022 7:31:15 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 7:31:15 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060893_TEMPLATE1.txt ### 2/20/2022 7:31:15 AM
2/20/2022 7:31:16 AM : Count:: ### TEMPLATE1:484
2/20/2022 7:31:46 AM : SP_DistributorTemplatePosting Successful --->>  ### 2/20/2022 7:31:46 AM
2/20/2022 7:31:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 2/20/2022 7:31:46 AM
2/20/2022 7:31:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 7:31:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 2/20/2022 7:31:46 AM
2/20/2022 7:31:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 7:31:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 2/20/2022 7:31:46 AM
2/20/2022 7:31:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 7:31:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061625_TEMPLATE1.txt ### 2/20/2022 7:31:46 AM
2/20/2022 7:31:46 AM : Count:: ### TEMPLATE1:158
2/20/2022 7:31:56 AM : SP_DistributorTemplatePosting Successful --->>  ### 2/20/2022 7:31:56 AM
2/20/2022 7:31:56 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 2/20/2022 7:31:56 AM
2/20/2022 7:31:56 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 7:31:56 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 2/20/2022 7:31:56 AM
2/20/2022 7:31:56 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 7:31:56 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9064126_TEMPLATE1.txt ### 2/20/2022 7:31:56 AM
2/20/2022 7:31:56 AM : Count:: ### TEMPLATE1:2
2/20/2022 7:31:56 AM : SP_DistributorTemplatePosting Successful --->>  ### 2/20/2022 7:31:56 AM
2/20/2022 7:31:56 AM : Template Import Complete  ### 2/20/2022 7:31:56 AM
2/20/2022 7:31:59 AM : Completed Updating Has Transaction Flag  ### 2/20/2022 7:31:59 AM
2/20/2022 7:31:59 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 2/20/2022 7:31:59 AM
2/20/2022 7:31:59 AM : Zylem Access Unblocked  ### 2/20/2022 7:31:59 AM
2/20/2022 7:31:59 AM : Application Ended  ### 2/20/2022 7:31:59 AM

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

2/20/2022 2:30:03 PM : 11  ### 2/20/2022 2:30:03 PM

2/20/2022 2:30:03 PM : 22  ### 2/20/2022 2:30:03 PM

2/20/2022 2:30:03 PM : 33  ### 2/20/2022 2:30:03 PM

2/20/2022 2:30:03 PM : Application Started  ### 2/20/2022 2:30:03 PM

2/20/2022 2:30:03 PM : Start Process : checkAllTablesExists()  ### 
2/20/2022 2:30:03 PM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 2/20/2022 2:30:03 PM
2/20/2022 2:30:04 PM : MainForm_Load  ### AlertSystem ON
2/20/2022 2:30:04 PM : No. of Files to import (RECEIVEFINAL):  ### 1201
2/20/2022 2:30:04 PM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
2/20/2022 2:30:09 PM : For Distributor 000000000001119 Insert Count::2 ### Delete Count::0
2/20/2022 2:30:09 PM : Import DN File --->> DN_1119_20220214_190500319f6d57464985205231558ba6.TXT ### 2/20/2022 2:30:09 PM
2/20/2022 2:30:09 PM : For Distributor 000000000001119 Insert Count::1 ### Delete Count::0
2/20/2022 2:30:09 PM : Import DN File --->> DN_1119_20220215_92695bac7321490aafd0bc088b8a8a91.TXT ### 2/20/2022 2:30:09 PM
2/20/2022 2:30:09 PM : For Distributor 000000000001119 Insert Count::1 ### Delete Count::0
2/20/2022 2:30:09 PM : Import DN File --->> DN_1119_20220216_3e43e651dbcc58ba5c3d2ecc7d463318.TXT ### 2/20/2022 2:30:09 PM
2/20/2022 2:30:36 PM : For Distributor 000000000001119 Insert Count::60 ### Delete Count::0
2/20/2022 2:30:36 PM : Import IN File --->> IN_1119_20220219_315f1d8924a860d5a0824bb600b88136.TXT ### 2/20/2022 2:30:36 PM
2/20/2022 2:30:37 PM : Import IN File --->> IN_1119_20220220_23bfaa9f992951ee39a9ed8988df1dd3.TXT ### 2/20/2022 2:30:37 PM
2/20/2022 2:30:37 PM : NO Previous File For Distributor 000000000001119 ### Insert Count::23
2/20/2022 2:30:51 PM : For Distributor 000000000000739 Insert Count::4 ### Delete Count::0
2/20/2022 2:30:51 PM : Import IN File --->> IN_739_20220220_3b50ddad7c03396203f5c1368c963cf7.TXT ### 2/20/2022 2:30:51 PM
2/20/2022 2:30:51 PM : For Distributor 000000000001119 Insert Count::1 ### Delete Count::0
2/20/2022 2:30:51 PM : Import PR File --->> PR_1119_20220220_b31fcbdde4b5623253f0ddf234d5fbd7.TXT ### 2/20/2022 2:30:51 PM
2/20/2022 2:30:51 PM : PostData() --->>  ### 2/20/2022 2:30:51 PM
2/20/2022 2:30:55 PM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 2/20/2022 2:30:55 PM
2/20/2022 2:30:56 PM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '20/Feb/2022' ### 2/20/2022 2:30:56 PM
2/20/2022 2:30:56 PM : ItemLink Successful --->> exec SP_ItemLinkDiff '20/Feb/2022' ### 2/20/2022 2:30:56 PM
2/20/2022 2:30:56 PM :  ### 
2/20/2022 2:30:56 PM : UNLINKEDSALES Record Count Before --->> 129 ### 2/20/2022 2:30:56 PM
2/20/2022 2:30:56 PM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 2/20/2022 2:30:56 PM
2/20/2022 2:31:04 PM : Posting Sales Successful --->> exec prPostLinkedDiffSales '20/Feb/2022' ### 2/20/2022 2:31:04 PM
2/20/2022 2:31:04 PM : UNLINKEDSALES Record Count After --->> 42 ### 2/20/2022 2:31:04 PM
2/20/2022 2:31:04 PM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 2/20/2022 2:31:04 PM
2/20/2022 2:31:04 PM :  ### 
2/20/2022 2:31:04 PM : Posting Supplierlink Query for Purchases --->>  ### 2/20/2022 2:31:04 PM
2/20/2022 2:31:10 PM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '20/Feb/2022' ### 2/20/2022 2:31:10 PM
2/20/2022 2:31:16 PM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '20/Feb/2022' ### 2/20/2022 2:31:16 PM
2/20/2022 2:31:16 PM : Posting Supplierlink Query for CompanyPurchases --->>  ### 2/20/2022 2:31:16 PM
2/20/2022 2:31:16 PM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '20/Feb/2022' ### 2/20/2022 2:31:16 PM
2/20/2022 2:31:16 PM : Posting ClosingStock Successful --->>  ### 2/20/2022 2:31:16 PM
2/20/2022 2:31:16 PM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 2/20/2022 2:31:16 PM
2/20/2022 2:31:16 PM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
2/20/2022 2:31:16 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 2/20/2022 2:31:16 PM
2/20/2022 2:31:16 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:31:16 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 2/20/2022 2:31:16 PM
2/20/2022 2:31:16 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:31:16 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 2/20/2022 2:31:16 PM
2/20/2022 2:31:16 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:31:17 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 2/20/2022 2:31:17 PM
2/20/2022 2:31:17 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:31:17 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 2/20/2022 2:31:17 PM
2/20/2022 2:31:17 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:31:17 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3482327_TEMPLATE1.TXT ### 2/20/2022 2:31:17 PM
2/20/2022 2:31:17 PM : Count:: ### TEMPLATE1:28
2/20/2022 2:31:17 PM : SP_DistributorTemplatePosting Successful --->>  ### 2/20/2022 2:31:17 PM
2/20/2022 2:31:17 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 2/20/2022 2:31:17 PM
2/20/2022 2:31:17 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:31:17 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 2/20/2022 2:31:17 PM
2/20/2022 2:31:17 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:31:17 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3643369_TEMPLATE1.TXT ### 2/20/2022 2:31:17 PM
2/20/2022 2:31:17 PM : Count:: ### TEMPLATE1:178
2/20/2022 2:31:51 PM : SP_DistributorTemplatePosting Successful --->>  ### 2/20/2022 2:31:51 PM
2/20/2022 2:31:51 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 2/20/2022 2:31:51 PM
2/20/2022 2:31:51 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:31:51 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 2/20/2022 2:31:51 PM
2/20/2022 2:31:51 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:31:51 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3922886_TEMPLATE1.txt ### 2/20/2022 2:31:51 PM
2/20/2022 2:31:51 PM : Count:: ### TEMPLATE1:45
2/20/2022 2:31:52 PM : SP_DistributorTemplatePosting Successful --->>  ### 2/20/2022 2:31:52 PM
2/20/2022 2:31:52 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 2/20/2022 2:31:52 PM
2/20/2022 2:31:52 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:31:52 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 2/20/2022 2:31:52 PM
2/20/2022 2:31:52 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:31:52 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 2/20/2022 2:31:52 PM
2/20/2022 2:31:52 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:31:52 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 2/20/2022 2:31:52 PM
2/20/2022 2:31:52 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:31:52 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 2/20/2022 2:31:52 PM
2/20/2022 2:31:52 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:31:52 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 2/20/2022 2:31:52 PM
2/20/2022 2:31:52 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:31:52 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 2/20/2022 2:31:52 PM
2/20/2022 2:31:52 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:31:52 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 2/20/2022 2:31:52 PM
2/20/2022 2:31:52 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/20/2022 2:31:52 PM : Template Import Complete  ### 2/20/2022 2:31:52 PM
2/20/2022 2:31:55 PM : Completed Updating Has Transaction Flag  ### 2/20/2022 2:31:55 PM
2/20/2022 2:31:55 PM : Transaction Table lastEdiDate Update on BrandAlias Update ### 2/20/2022 2:31:55 PM
2/20/2022 2:31:55 PM : Zylem Access Unblocked  ### 2/20/2022 2:31:55 PM
2/20/2022 2:31:55 PM : Application Ended  ### 2/20/2022 2:31:55 PM