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

4/24/2022 2:30:04 AM : 11  ### 4/24/2022 2:30:04 AM

4/24/2022 2:30:04 AM : 22  ### 4/24/2022 2:30:04 AM

4/24/2022 2:30:04 AM : 33  ### 4/24/2022 2:30:04 AM

4/24/2022 2:30:04 AM : Application Started  ### 4/24/2022 2:30:04 AM

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

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

4/24/2022 7:30:03 AM : 11  ### 4/24/2022 7:30:03 AM

4/24/2022 7:30:03 AM : 22  ### 4/24/2022 7:30:03 AM

4/24/2022 7:30:03 AM : 33  ### 4/24/2022 7:30:03 AM

4/24/2022 7:30:04 AM : Application Started  ### 4/24/2022 7:30:04 AM

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

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

4/24/2022 2:30:04 PM : 11  ### 4/24/2022 2:30:04 PM

4/24/2022 2:30:04 PM : 22  ### 4/24/2022 2:30:04 PM

4/24/2022 2:30:04 PM : 33  ### 4/24/2022 2:30:04 PM

4/24/2022 2:30:04 PM : Application Started  ### 4/24/2022 2:30:04 PM

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