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

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

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

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

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

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

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

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

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

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

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

3/27/2022 7:30:03 AM : Start Process : checkAllTablesExists()  ### 
3/27/2022 7:30:03 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 3/27/2022 7:30:03 AM
3/27/2022 7:30:03 AM : MainForm_Load  ### AlertSystem ON
3/27/2022 7:30:04 AM : No. of Files to import (RECEIVEFINAL):  ### 1346
3/27/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/27/2022 7:30:05 AM : For Distributor 000000000001026 Insert Count::19 ### Delete Count::0
3/27/2022 7:30:05 AM : Import AD File --->> AD_1026_20220327_15a2f8b703040bfcff3c8cffcd1fef79.TXT ### 3/27/2022 7:30:05 AM
3/27/2022 7:30:05 AM : For Distributor 000000000000362 Insert Count::1 ### Delete Count::0
3/27/2022 7:30:05 AM : Import AD File --->> AD_362_20220327_30cb3cb557b7a4bf3c1778e22bbe1e1d.TXT ### 3/27/2022 7:30:05 AM
3/27/2022 7:30:39 AM : For Distributor 000000000001026 Insert Count::2 ### Delete Count::0
3/27/2022 7:30:39 AM : Import DN File --->> DN_1026_20220326_535f4fe3b39f2dfbbf96df6389420fe2.TXT ### 3/27/2022 7:30:39 AM
3/27/2022 7:30:47 AM : For Distributor 000000000000362 Insert Count::1 ### Delete Count::0
3/27/2022 7:30:47 AM : Import DN File --->> DN_362_20220316_e39a97000e07597e846222ab35905652.TXT ### 3/27/2022 7:30:47 AM
3/27/2022 7:30:53 AM : For Distributor 000000000000424 Insert Count::1 ### Delete Count::0
3/27/2022 7:30:53 AM : Import DN File --->> DN_424_20220325_bcfa28c59d76e638108ebb677a874c62.TXT ### 3/27/2022 7:30:53 AM
3/27/2022 7:31:10 AM : For Distributor 000000000001026 Insert Count::1 ### Delete Count::0
3/27/2022 7:31:10 AM : Import IN File --->> IN_1026_20220322_211fc5a080a97bd927ce96def8b21303.TXT ### 3/27/2022 7:31:10 AM
3/27/2022 7:31:10 AM : For Distributor 000000000001026 Insert Count::8 ### Delete Count::0
3/27/2022 7:31:10 AM : Import IN File --->> IN_1026_20220323_658c4840d8c67f86527df12e5811dc34.TXT ### 3/27/2022 7:31:10 AM
3/27/2022 7:31:11 AM : For Distributor 000000000001026 Insert Count::9 ### Delete Count::0
3/27/2022 7:31:11 AM : Import IN File --->> IN_1026_20220324_d4e6cbceac631cfe0f8de75111f1e50d.TXT ### 3/27/2022 7:31:11 AM
3/27/2022 7:31:11 AM : For Distributor 000000000001026 Insert Count::1 ### Delete Count::0
3/27/2022 7:31:11 AM : Import IN File --->> IN_1026_20220325_e0d6c8559cdb23fa4ebffb2f7449cfaf.TXT ### 3/27/2022 7:31:11 AM
3/27/2022 7:31:11 AM : For Distributor 000000000001026 Insert Count::3 ### Delete Count::1
3/27/2022 7:31:11 AM : Import IN File --->> IN_1026_20220326_cdf92cf9603b2e74ae1ce024cc125a96.TXT ### 3/27/2022 7:31:11 AM
3/27/2022 7:31:13 AM : For Distributor 000000000000362 Insert Count::2 ### Delete Count::0
3/27/2022 7:31:13 AM : Import IN File --->> IN_362_20220315_8294278babba19f4e92cff69346c5286.TXT ### 3/27/2022 7:31:13 AM
3/27/2022 7:31:13 AM : For Distributor 000000000000362 Insert Count::2 ### Delete Count::0
3/27/2022 7:31:13 AM : Import IN File --->> IN_362_20220316_238cb235fca39d79bcc37182519e7f97.TXT ### 3/27/2022 7:31:13 AM
3/27/2022 7:31:13 AM : Import IN File --->> IN_362_20220317_9bc2f6c72c23d541af8c6f0cc948ffd4.TXT ### 3/27/2022 7:31:13 AM
3/27/2022 7:31:13 AM : NO Previous File For Distributor 000000000000362 ### Insert Count::1
3/27/2022 7:31:29 AM : For Distributor 000000000000424 Insert Count::1 ### Delete Count::0
3/27/2022 7:31:29 AM : Import IN File --->> IN_424_20220326_4bd9aa22614e265e9eb794e80a34bb07.TXT ### 3/27/2022 7:31:29 AM
3/27/2022 7:31:31 AM : PostData() --->>  ### 3/27/2022 7:31:31 AM
3/27/2022 7:31:32 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 3/27/2022 7:31:32 AM
3/27/2022 7:31:33 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '27/Mar/2022' ### 3/27/2022 7:31:33 AM
3/27/2022 7:31:34 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '27/Mar/2022' ### 3/27/2022 7:31:34 AM
3/27/2022 7:31:34 AM :  ### 
3/27/2022 7:31:34 AM : UNLINKEDSALES Record Count Before --->> 28 ### 3/27/2022 7:31:34 AM
3/27/2022 7:31:34 AM : UNLINKEDSALES_DEL Record Count Before --->> 1 ### 3/27/2022 7:31:34 AM
3/27/2022 7:31:42 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '27/Mar/2022' ### 3/27/2022 7:31:42 AM
3/27/2022 7:31:42 AM : UNLINKEDSALES Record Count After --->> 0 ### 3/27/2022 7:31:42 AM
3/27/2022 7:31:42 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 3/27/2022 7:31:42 AM
3/27/2022 7:31:42 AM :  ### 
3/27/2022 7:31:42 AM : Posting Supplierlink Query for Purchases --->>  ### 3/27/2022 7:31:42 AM
3/27/2022 7:31:48 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '27/Mar/2022' ### 3/27/2022 7:31:48 AM
3/27/2022 7:31:53 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '27/Mar/2022' ### 3/27/2022 7:31:53 AM
3/27/2022 7:31:53 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 3/27/2022 7:31:53 AM
3/27/2022 7:31:53 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '27/Mar/2022' ### 3/27/2022 7:31:53 AM
3/27/2022 7:31:53 AM : Posting ClosingStock Successful --->>  ### 3/27/2022 7:31:53 AM
3/27/2022 7:31:53 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 3/27/2022 7:31:53 AM
3/27/2022 7:31:53 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
3/27/2022 7:31:53 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 3/27/2022 7:31:53 AM
3/27/2022 7:31:54 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 7:31:54 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 3/27/2022 7:31:54 AM
3/27/2022 7:31:54 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 7:31:54 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 3/27/2022 7:31:54 AM
3/27/2022 7:31:54 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 7:31:54 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 3/27/2022 7:31:54 AM
3/27/2022 7:31:54 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 7:31:54 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 3/27/2022 7:31:54 AM
3/27/2022 7:31:54 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 7:31:54 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 3/27/2022 7:31:54 AM
3/27/2022 7:31:54 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 7:31:54 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 3/27/2022 7:31:54 AM
3/27/2022 7:31:54 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 7:31:54 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 3/27/2022 7:31:54 AM
3/27/2022 7:31:54 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 7:31:54 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 3/27/2022 7:31:54 AM
3/27/2022 7:31:54 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 7:31:54 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 3/27/2022 7:31:54 AM
3/27/2022 7:31:54 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 7:31:54 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 3/27/2022 7:31:54 AM
3/27/2022 7:31:54 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 7:31:54 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 3/27/2022 7:31:54 AM
3/27/2022 7:31:54 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 7:31:54 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060893_TEMPLATE1.txt ### 3/27/2022 7:31:54 AM
3/27/2022 7:31:54 AM : Count:: ### TEMPLATE1:500
3/27/2022 7:32:25 AM : SP_DistributorTemplatePosting Successful --->>  ### 3/27/2022 7:32:25 AM
3/27/2022 7:32:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 3/27/2022 7:32:25 AM
3/27/2022 7:32:25 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 7:32:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 3/27/2022 7:32:25 AM
3/27/2022 7:32:25 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 7:32:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 3/27/2022 7:32:25 AM
3/27/2022 7:32:25 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 7:32:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 3/27/2022 7:32:25 AM
3/27/2022 7:32:25 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 7:32:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 3/27/2022 7:32:25 AM
3/27/2022 7:32:25 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 7:32:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9064126_TEMPLATE1.txt ### 3/27/2022 7:32:25 AM
3/27/2022 7:32:25 AM : Count:: ### TEMPLATE1:2
3/27/2022 7:32:26 AM : SP_DistributorTemplatePosting Successful --->>  ### 3/27/2022 7:32:26 AM
3/27/2022 7:32:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067123_TEMPLATE1.txt ### 3/27/2022 7:32:26 AM
3/27/2022 7:32:26 AM : Count:: ### TEMPLATE1:33
3/27/2022 7:32:30 AM : SP_DistributorTemplatePosting Successful --->>  ### 3/27/2022 7:32:30 AM
3/27/2022 7:32:30 AM : Template Import Complete  ### 3/27/2022 7:32:30 AM
3/27/2022 7:32:33 AM : Completed Updating Has Transaction Flag  ### 3/27/2022 7:32:33 AM
3/27/2022 7:32:33 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 3/27/2022 7:32:33 AM
3/27/2022 7:32:33 AM : Zylem Access Unblocked  ### 3/27/2022 7:32:33 AM
3/27/2022 7:32:33 AM : Application Ended  ### 3/27/2022 7:32:33 AM

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

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

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

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

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

3/27/2022 2:30:03 PM : Start Process : checkAllTablesExists()  ### 
3/27/2022 2:30:03 PM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 3/27/2022 2:30:03 PM
3/27/2022 2:30:03 PM : MainForm_Load  ### AlertSystem ON
3/27/2022 2:30:04 PM : No. of Files to import (RECEIVEFINAL):  ### 168
3/27/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
3/27/2022 2:30:04 PM : For Distributor 000000000001289 Insert Count::13 ### Delete Count::0
3/27/2022 2:30:04 PM : Import AD File --->> AD_1289_20220327_acc963186f66f102e55d17669f7865af.TXT ### 3/27/2022 2:30:04 PM
3/27/2022 2:30:05 PM : For Distributor 000000000001289 Insert Count::3 ### Delete Count::0
3/27/2022 2:30:05 PM : Import DN File --->> DN_1289_20220224_170aa6fe91cad7206aafe994023424ba.TXT ### 3/27/2022 2:30:05 PM
3/27/2022 2:30:06 PM : For Distributor 000000000001289 Insert Count::8 ### Delete Count::0
3/27/2022 2:30:06 PM : Import DN File --->> DN_1289_20220308_ad13a21ff65123cd9c5ca7786341c061.TXT ### 3/27/2022 2:30:06 PM
3/27/2022 2:30:06 PM : For Distributor 000000000001289 Insert Count::4 ### Delete Count::0
3/27/2022 2:30:06 PM : Import DN File --->> DN_1289_20220310_db66a6f60c98ae861c6a8b18751a9ab4.TXT ### 3/27/2022 2:30:06 PM
3/27/2022 2:30:06 PM : For Distributor 000000000001289 Insert Count::9 ### Delete Count::0
3/27/2022 2:30:06 PM : Import DN File --->> DN_1289_20220315_3c9cd38bb8114dbd9fd7dc112cd34269.TXT ### 3/27/2022 2:30:06 PM
3/27/2022 2:30:06 PM : For Distributor 000000000001289 Insert Count::5 ### Delete Count::0
3/27/2022 2:30:06 PM : Import DN File --->> DN_1289_20220317_5cd50ea7612d46bb7176fc297ef8a71a.TXT ### 3/27/2022 2:30:06 PM
3/27/2022 2:30:07 PM : Import DN File --->> DN_1289_20220322_557ab7f07f22540c97b3f7c47da847dd.TXT ### 3/27/2022 2:30:07 PM
3/27/2022 2:30:07 PM : NO Previous File For Distributor 000000000001289 ### Insert Count::1
3/27/2022 2:30:09 PM : For Distributor 000000000001289 Insert Count::5 ### Delete Count::0
3/27/2022 2:30:09 PM : Import IN File --->> IN_1289_20220320_d5f5b0a99eafb9b1783862a85b9fdd48.TXT ### 3/27/2022 2:30:09 PM
3/27/2022 2:30:09 PM : Import IN File --->> IN_1289_20220322_63559c9a0a99a13371471ad23933a1ab.TXT ### 3/27/2022 2:30:09 PM
3/27/2022 2:30:09 PM : NO Previous File For Distributor 000000000001289 ### Insert Count::23
3/27/2022 2:30:09 PM : Import IN File --->> IN_1289_20220323_d84dc68453f1b563503ebcba056f4a01.TXT ### 3/27/2022 2:30:09 PM
3/27/2022 2:30:09 PM : NO Previous File For Distributor 000000000001289 ### Insert Count::13
3/27/2022 2:30:09 PM : Import IN File --->> IN_1289_20220324_89ef94960f71e9074bd2bda18de428a2.TXT ### 3/27/2022 2:30:09 PM
3/27/2022 2:30:09 PM : NO Previous File For Distributor 000000000001289 ### Insert Count::17
3/27/2022 2:30:09 PM : Import IN File --->> IN_1289_20220325_2890415b24ded96a3093b5cceadf2a62.TXT ### 3/27/2022 2:30:09 PM
3/27/2022 2:30:09 PM : NO Previous File For Distributor 000000000001289 ### Insert Count::5
3/27/2022 2:30:09 PM : Import IN File --->> IN_1289_20220326_7a27967c1453e68e9c8b884e48923d54.TXT ### 3/27/2022 2:30:09 PM
3/27/2022 2:30:09 PM : NO Previous File For Distributor 000000000001289 ### Insert Count::3
3/27/2022 2:30:11 PM : PostData() --->>  ### 3/27/2022 2:30:11 PM
3/27/2022 2:30:14 PM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 3/27/2022 2:30:14 PM
3/27/2022 2:30:15 PM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '27/Mar/2022' ### 3/27/2022 2:30:15 PM
3/27/2022 2:30:16 PM : ItemLink Successful --->> exec SP_ItemLinkDiff '27/Mar/2022' ### 3/27/2022 2:30:16 PM
3/27/2022 2:30:16 PM :  ### 
3/27/2022 2:30:16 PM : UNLINKEDSALES Record Count Before --->> 66 ### 3/27/2022 2:30:16 PM
3/27/2022 2:30:16 PM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 3/27/2022 2:30:16 PM
3/27/2022 2:30:23 PM : Posting Sales Successful --->> exec prPostLinkedDiffSales '27/Mar/2022' ### 3/27/2022 2:30:23 PM
3/27/2022 2:30:23 PM : UNLINKEDSALES Record Count After --->> 0 ### 3/27/2022 2:30:23 PM
3/27/2022 2:30:23 PM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 3/27/2022 2:30:23 PM
3/27/2022 2:30:23 PM :  ### 
3/27/2022 2:30:23 PM : Posting Supplierlink Query for Purchases --->>  ### 3/27/2022 2:30:23 PM
3/27/2022 2:30:29 PM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '27/Mar/2022' ### 3/27/2022 2:30:29 PM
3/27/2022 2:30:35 PM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '27/Mar/2022' ### 3/27/2022 2:30:35 PM
3/27/2022 2:30:35 PM : Posting Supplierlink Query for CompanyPurchases --->>  ### 3/27/2022 2:30:35 PM
3/27/2022 2:30:35 PM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '27/Mar/2022' ### 3/27/2022 2:30:35 PM
3/27/2022 2:30:35 PM : Posting ClosingStock Successful --->>  ### 3/27/2022 2:30:35 PM
3/27/2022 2:30:35 PM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 3/27/2022 2:30:35 PM
3/27/2022 2:30:35 PM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
3/27/2022 2:30:35 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1016226_TEMPLATE1.TXT ### 3/27/2022 2:30:35 PM
3/27/2022 2:30:35 PM : Count:: ### TEMPLATE1:84
3/27/2022 2:30:47 PM : SP_DistributorTemplatePosting Successful --->>  ### 3/27/2022 2:30:47 PM
3/27/2022 2:30:47 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 3/27/2022 2:30:47 PM
3/27/2022 2:30:47 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 2:30:47 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 3/27/2022 2:30:47 PM
3/27/2022 2:30:47 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 2:30:47 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 3/27/2022 2:30:47 PM
3/27/2022 2:30:47 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 2:30:47 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 3/27/2022 2:30:47 PM
3/27/2022 2:30:47 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 2:30:47 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 3/27/2022 2:30:47 PM
3/27/2022 2:30:47 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 2:30:47 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 3/27/2022 2:30:47 PM
3/27/2022 2:30:47 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 2:30:47 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 3/27/2022 2:30:47 PM
3/27/2022 2:30:47 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 2:30:47 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 3/27/2022 2:30:47 PM
3/27/2022 2:30:47 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 2:30:47 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 3/27/2022 2:30:47 PM
3/27/2022 2:30:47 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 2:30:47 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3985879_TEMPLATE1.txt ### 3/27/2022 2:30:47 PM
3/27/2022 2:30:47 PM : Count:: ### TEMPLATE1:85
3/27/2022 2:30:49 PM : SP_DistributorTemplatePosting Successful --->>  ### 3/27/2022 2:30:49 PM
3/27/2022 2:30:49 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 3/27/2022 2:30:49 PM
3/27/2022 2:30:49 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 2:30:49 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 3/27/2022 2:30:49 PM
3/27/2022 2:30:49 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 2:30:49 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 3/27/2022 2:30:49 PM
3/27/2022 2:30:49 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 2:30:49 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 3/27/2022 2:30:49 PM
3/27/2022 2:30:49 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 2:30:49 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 3/27/2022 2:30:49 PM
3/27/2022 2:30:49 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 2:30:49 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 3/27/2022 2:30:49 PM
3/27/2022 2:30:49 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 2:30:49 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 3/27/2022 2:30:49 PM
3/27/2022 2:30:49 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 2:30:50 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 3/27/2022 2:30:50 PM
3/27/2022 2:30:50 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
3/27/2022 2:30:50 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9064126_TEMPLATE1.txt ### 3/27/2022 2:30:50 PM
3/27/2022 2:30:50 PM : Count:: ### TEMPLATE1:2
3/27/2022 2:30:50 PM : SP_DistributorTemplatePosting Successful --->>  ### 3/27/2022 2:30:50 PM
3/27/2022 2:30:50 PM : Template Import Complete  ### 3/27/2022 2:30:50 PM
3/27/2022 2:30:53 PM : Completed Updating Has Transaction Flag  ### 3/27/2022 2:30:53 PM
3/27/2022 2:30:53 PM : Transaction Table lastEdiDate Update on BrandAlias Update ### 3/27/2022 2:30:53 PM
3/27/2022 2:30:53 PM : Zylem Access Unblocked  ### 3/27/2022 2:30:53 PM
3/27/2022 2:30:53 PM : Application Ended  ### 3/27/2022 2:30:53 PM