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

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

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

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

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

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

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

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

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

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

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

3/20/2022 7:30:03 AM : Start Process : checkAllTablesExists()  ### 
3/20/2022 7:30:03 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 3/20/2022 7:30:03 AM
3/20/2022 7:30:04 AM : MainForm_Load  ### AlertSystem ON
3/20/2022 7:30:04 AM : No. of Files to import (RECEIVEFINAL):  ### 1209
3/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
3/20/2022 7:30:05 AM : For Distributor 000000000001026 Insert Count::40 ### Delete Count::0
3/20/2022 7:30:05 AM : Import AD File --->> AD_1026_20220320_d8dfb8104afbeaf7491bc47dbeb0e3d1.TXT ### 3/20/2022 7:30:05 AM
3/20/2022 7:31:02 AM : For Distributor 000000000001026 Insert Count::8 ### Delete Count::0
3/20/2022 7:31:02 AM : Import IN File --->> IN_1026_20220311_ad33877e08169966c7ed829fe77b73f5.TXT ### 3/20/2022 7:31:02 AM
3/20/2022 7:31:02 AM : For Distributor 000000000001026 Insert Count::15 ### Delete Count::0
3/20/2022 7:31:02 AM : Import IN File --->> IN_1026_20220312_c7288648e9985c6fcc19229544498015.TXT ### 3/20/2022 7:31:02 AM
3/20/2022 7:31:02 AM : For Distributor 000000000001026 Insert Count::15 ### Delete Count::0
3/20/2022 7:31:02 AM : Import IN File --->> IN_1026_20220313_f373ee0224f20dd532036cda9d9d594c.TXT ### 3/20/2022 7:31:02 AM
3/20/2022 7:31:02 AM : For Distributor 000000000001026 Insert Count::2 ### Delete Count::0
3/20/2022 7:31:02 AM : Import IN File --->> IN_1026_20220314_c05693edd71dd1c4149c5bcbda827964.TXT ### 3/20/2022 7:31:02 AM
3/20/2022 7:31:03 AM : For Distributor 000000000001026 Insert Count::3 ### Delete Count::0
3/20/2022 7:31:03 AM : Import IN File --->> IN_1026_20220319_baa08e955b858cc0a225b74c09850a5e.TXT ### 3/20/2022 7:31:03 AM
3/20/2022 7:31:19 AM : For Distributor 000000000000424 Insert Count::7 ### Delete Count::0
3/20/2022 7:31:19 AM : Import IN File --->> IN_424_20220319_8426730a90d99437b1f0436ae86219a2.TXT ### 3/20/2022 7:31:19 AM
3/20/2022 7:31:21 AM : PostData() --->>  ### 3/20/2022 7:31:21 AM
3/20/2022 7:31:23 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 3/20/2022 7:31:23 AM
3/20/2022 7:31:24 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '20/Mar/2022' ### 3/20/2022 7:31:24 AM
3/20/2022 7:31:25 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '20/Mar/2022' ### 3/20/2022 7:31:25 AM
3/20/2022 7:31:25 AM :  ### 
3/20/2022 7:31:25 AM : UNLINKEDSALES Record Count Before --->> 50 ### 3/20/2022 7:31:25 AM
3/20/2022 7:31:25 AM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 3/20/2022 7:31:25 AM
3/20/2022 7:31:33 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '20/Mar/2022' ### 3/20/2022 7:31:33 AM
3/20/2022 7:31:33 AM : UNLINKEDSALES Record Count After --->> 0 ### 3/20/2022 7:31:33 AM
3/20/2022 7:31:33 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 3/20/2022 7:31:33 AM
3/20/2022 7:31:33 AM :  ### 
3/20/2022 7:31:33 AM : Posting Supplierlink Query for Purchases --->>  ### 3/20/2022 7:31:33 AM
3/20/2022 7:31:39 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '20/Mar/2022' ### 3/20/2022 7:31:39 AM
3/20/2022 7:31:45 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '20/Mar/2022' ### 3/20/2022 7:31:45 AM
3/20/2022 7:31:45 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 3/20/2022 7:31:45 AM
3/20/2022 7:31:45 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '20/Mar/2022' ### 3/20/2022 7:31:45 AM
3/20/2022 7:31:45 AM : Posting ClosingStock Successful --->>  ### 3/20/2022 7:31:45 AM
3/20/2022 7:31:45 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 3/20/2022 7:31:45 AM
3/20/2022 7:31:45 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
3/20/2022 7:31:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 3/20/2022 7:31:45 AM
3/20/2022 7:31:45 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 7:31:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 3/20/2022 7:31:45 AM
3/20/2022 7:31:45 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 7:31:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 3/20/2022 7:31:45 AM
3/20/2022 7:31:45 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 7:31:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 3/20/2022 7:31:45 AM
3/20/2022 7:31:45 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 7:31:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 3/20/2022 7:31:45 AM
3/20/2022 7:31:45 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 7:31:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 3/20/2022 7:31:45 AM
3/20/2022 7:31:45 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 7:31:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 3/20/2022 7:31:45 AM
3/20/2022 7:31:45 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 7:31:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 3/20/2022 7:31:45 AM
3/20/2022 7:31:45 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 7:31:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 3/20/2022 7:31:45 AM
3/20/2022 7:31:45 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 7:31:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 3/20/2022 7:31:45 AM
3/20/2022 7:31:45 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 7:31:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 3/20/2022 7:31:45 AM
3/20/2022 7:31:45 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 7:31:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 3/20/2022 7:31:45 AM
3/20/2022 7:31:45 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 7:31:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060893_TEMPLATE1.txt ### 3/20/2022 7:31:45 AM
3/20/2022 7:31:45 AM : Count:: ### TEMPLATE1:495
3/20/2022 7:32:17 AM : SP_DistributorTemplatePosting Successful --->>  ### 3/20/2022 7:32:17 AM
3/20/2022 7:32:17 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 3/20/2022 7:32:17 AM
3/20/2022 7:32:17 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 7:32:17 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 3/20/2022 7:32:17 AM
3/20/2022 7:32:17 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 7:32:17 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 3/20/2022 7:32:17 AM
3/20/2022 7:32:17 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 7:32:17 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 3/20/2022 7:32:17 AM
3/20/2022 7:32:17 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 7:32:17 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 3/20/2022 7:32:17 AM
3/20/2022 7:32:17 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 7:32:17 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9064126_TEMPLATE1.txt ### 3/20/2022 7:32:17 AM
3/20/2022 7:32:17 AM : Count:: ### TEMPLATE1:2
3/20/2022 7:32:17 AM : SP_DistributorTemplatePosting Successful --->>  ### 3/20/2022 7:32:17 AM
3/20/2022 7:32:17 AM : Template Import Complete  ### 3/20/2022 7:32:17 AM
3/20/2022 7:32:20 AM : Completed Updating Has Transaction Flag  ### 3/20/2022 7:32:20 AM
3/20/2022 7:32:20 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 3/20/2022 7:32:20 AM
3/20/2022 7:32:20 AM : Zylem Access Unblocked  ### 3/20/2022 7:32:20 AM
3/20/2022 7:32:20 AM : Application Ended  ### 3/20/2022 7:32:20 AM

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

3/20/2022 2:30:02 PM : 11  ### 3/20/2022 2:30:02 PM

3/20/2022 2:30:02 PM : 22  ### 3/20/2022 2:30:02 PM

3/20/2022 2:30:02 PM : 33  ### 3/20/2022 2:30:02 PM

3/20/2022 2:30:02 PM : Application Started  ### 3/20/2022 2:30:02 PM

3/20/2022 2:30:02 PM : Start Process : checkAllTablesExists()  ### 
3/20/2022 2:30:02 PM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 3/20/2022 2:30:02 PM
3/20/2022 2:30:02 PM : MainForm_Load  ### AlertSystem ON
3/20/2022 2:30:03 PM : No. of Files to import (RECEIVEFINAL):  ### 98
3/20/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/20/2022 2:30:03 PM : For Distributor 000000000001289 Insert Count::9 ### Delete Count::0
3/20/2022 2:30:03 PM : Import AD File --->> AD_1289_20220320_d31d8520a0fe9eba2553ddce41ba9cb4.TXT ### 3/20/2022 2:30:03 PM
3/20/2022 2:30:07 PM : For Distributor 000000000001289 Insert Count::4 ### Delete Count::0
3/20/2022 2:30:07 PM : Import IN File --->> IN_1289_20220312_a35470f179e53198147ed3bae6e118a4.TXT ### 3/20/2022 2:30:07 PM
3/20/2022 2:30:07 PM : For Distributor 000000000001289 Insert Count::3 ### Delete Count::0
3/20/2022 2:30:07 PM : Import IN File --->> IN_1289_20220313_918384b8f0773fd328029aa53bad653e.TXT ### 3/20/2022 2:30:07 PM
3/20/2022 2:30:07 PM : Import IN File --->> IN_1289_20220314_998ad13cfcb3a006429ce9d0981adbfd.TXT ### 3/20/2022 2:30:07 PM
3/20/2022 2:30:07 PM : NO Previous File For Distributor 000000000001289 ### Insert Count::4
3/20/2022 2:30:07 PM : Import IN File --->> IN_1289_20220315_0b0a87cd34cc57c1255e32a946f5f71e.TXT ### 3/20/2022 2:30:07 PM
3/20/2022 2:30:07 PM : NO Previous File For Distributor 000000000001289 ### Insert Count::14
3/20/2022 2:30:07 PM : Import IN File --->> IN_1289_20220316_5a8ed98e6d513068fa260e49e2e18bb9.TXT ### 3/20/2022 2:30:07 PM
3/20/2022 2:30:07 PM : NO Previous File For Distributor 000000000001289 ### Insert Count::2
3/20/2022 2:30:08 PM : Import IN File --->> IN_1289_20220319_c19bbbd92eb6e83f7368b60501089911.TXT ### 3/20/2022 2:30:08 PM
3/20/2022 2:30:08 PM : NO Previous File For Distributor 000000000001289 ### Insert Count::5
3/20/2022 2:30:08 PM : PostData() --->>  ### 3/20/2022 2:30:08 PM
3/20/2022 2:30:09 PM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 3/20/2022 2:30:09 PM
3/20/2022 2:30:10 PM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '20/Mar/2022' ### 3/20/2022 2:30:10 PM
3/20/2022 2:30:10 PM : ItemLink Successful --->> exec SP_ItemLinkDiff '20/Mar/2022' ### 3/20/2022 2:30:10 PM
3/20/2022 2:30:10 PM :  ### 
3/20/2022 2:30:10 PM : UNLINKEDSALES Record Count Before --->> 32 ### 3/20/2022 2:30:10 PM
3/20/2022 2:30:10 PM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 3/20/2022 2:30:10 PM
3/20/2022 2:30:19 PM : Posting Sales Successful --->> exec prPostLinkedDiffSales '20/Mar/2022' ### 3/20/2022 2:30:19 PM
3/20/2022 2:30:19 PM : UNLINKEDSALES Record Count After --->> 0 ### 3/20/2022 2:30:19 PM
3/20/2022 2:30:19 PM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 3/20/2022 2:30:19 PM
3/20/2022 2:30:19 PM :  ### 
3/20/2022 2:30:19 PM : Posting Supplierlink Query for Purchases --->>  ### 3/20/2022 2:30:19 PM
3/20/2022 2:30:25 PM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '20/Mar/2022' ### 3/20/2022 2:30:25 PM
3/20/2022 2:30:30 PM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '20/Mar/2022' ### 3/20/2022 2:30:30 PM
3/20/2022 2:30:30 PM : Posting Supplierlink Query for CompanyPurchases --->>  ### 3/20/2022 2:30:30 PM
3/20/2022 2:30:31 PM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '20/Mar/2022' ### 3/20/2022 2:30:31 PM
3/20/2022 2:30:31 PM : Posting ClosingStock Successful --->>  ### 3/20/2022 2:30:31 PM
3/20/2022 2:30:31 PM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 3/20/2022 2:30:31 PM
3/20/2022 2:30:31 PM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
3/20/2022 2:30:31 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1016226_TEMPLATE1.TXT ### 3/20/2022 2:30:31 PM
3/20/2022 2:30:31 PM : Count:: ### TEMPLATE1:71
3/20/2022 2:30:41 PM : SP_DistributorTemplatePosting Successful --->>  ### 3/20/2022 2:30:41 PM
3/20/2022 2:30:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 3/20/2022 2:30:41 PM
3/20/2022 2:30:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 2:30:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 3/20/2022 2:30:41 PM
3/20/2022 2:30:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 2:30:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 3/20/2022 2:30:41 PM
3/20/2022 2:30:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 2:30:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 3/20/2022 2:30:41 PM
3/20/2022 2:30:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 2:30:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 3/20/2022 2:30:41 PM
3/20/2022 2:30:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 2:30:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 3/20/2022 2:30:41 PM
3/20/2022 2:30:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 2:30:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 3/20/2022 2:30:41 PM
3/20/2022 2:30:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 2:30:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 3/20/2022 2:30:41 PM
3/20/2022 2:30:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 2:30:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 3/20/2022 2:30:41 PM
3/20/2022 2:30:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 2:30:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 3/20/2022 2:30:41 PM
3/20/2022 2:30:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 2:30:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 3/20/2022 2:30:41 PM
3/20/2022 2:30:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 2:30:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 3/20/2022 2:30:41 PM
3/20/2022 2:30:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 2:30:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 3/20/2022 2:30:41 PM
3/20/2022 2:30:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 2:30:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 3/20/2022 2:30:41 PM
3/20/2022 2:30:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 2:30:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 3/20/2022 2:30:41 PM
3/20/2022 2:30:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 2:30:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 3/20/2022 2:30:41 PM
3/20/2022 2:30:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 2:30:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 3/20/2022 2:30:41 PM
3/20/2022 2:30:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/20/2022 2:30:41 PM : Template Import Complete  ### 3/20/2022 2:30:41 PM
3/20/2022 2:30:44 PM : Completed Updating Has Transaction Flag  ### 3/20/2022 2:30:44 PM
3/20/2022 2:30:44 PM : Transaction Table lastEdiDate Update on BrandAlias Update ### 3/20/2022 2:30:44 PM
3/20/2022 2:30:44 PM : Zylem Access Unblocked  ### 3/20/2022 2:30:44 PM
3/20/2022 2:30:44 PM : Application Ended  ### 3/20/2022 2:30:44 PM