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

1/9/2022 2:30:04 AM : 11  ### 1/9/2022 2:30:04 AM

1/9/2022 2:30:04 AM : 22  ### 1/9/2022 2:30:04 AM

1/9/2022 2:30:04 AM : 33  ### 1/9/2022 2:30:04 AM

1/9/2022 2:30:04 AM : Application Started  ### 1/9/2022 2:30:04 AM

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

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

1/9/2022 7:30:03 AM : 11  ### 1/9/2022 7:30:03 AM

1/9/2022 7:30:03 AM : 22  ### 1/9/2022 7:30:03 AM

1/9/2022 7:30:03 AM : 33  ### 1/9/2022 7:30:03 AM

1/9/2022 7:30:03 AM : Application Started  ### 1/9/2022 7:30:03 AM

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

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

1/9/2022 2:30:04 PM : 11  ### 1/9/2022 2:30:04 PM

1/9/2022 2:30:04 PM : 22  ### 1/9/2022 2:30:04 PM

1/9/2022 2:30:04 PM : 33  ### 1/9/2022 2:30:04 PM

1/9/2022 2:30:04 PM : Application Started  ### 1/9/2022 2:30:04 PM

1/9/2022 2:30:04 PM : Start Process : checkAllTablesExists()  ### 
1/9/2022 2:30:04 PM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 1/9/2022 2:30:04 PM
1/9/2022 2:30:04 PM : MainForm_Load  ### AlertSystem ON
1/9/2022 2:30:04 PM : No. of Files to import (RECEIVEFINAL):  ### 1286
1/9/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
1/9/2022 2:30:53 PM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::0
1/9/2022 2:30:53 PM : Import IN File --->> IN_820_20220108_82e457f4a616e4e61434746eaeb79817.TXT ### 1/9/2022 2:30:53 PM
1/9/2022 2:30:54 PM : PostData() --->>  ### 1/9/2022 2:30:54 PM
1/9/2022 2:30:54 PM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 1/9/2022 2:30:54 PM
1/9/2022 2:30:54 PM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '09/Jan/2022' ### 1/9/2022 2:30:54 PM
1/9/2022 2:30:55 PM : ItemLink Successful --->> exec SP_ItemLinkDiff '09/Jan/2022' ### 1/9/2022 2:30:55 PM
1/9/2022 2:30:55 PM :  ### 
1/9/2022 2:30:55 PM : UNLINKEDSALES Record Count Before --->> 2 ### 1/9/2022 2:30:55 PM
1/9/2022 2:30:55 PM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 1/9/2022 2:30:55 PM
1/9/2022 2:31:02 PM : Posting Sales Successful --->> exec prPostLinkedDiffSales '09/Jan/2022' ### 1/9/2022 2:31:02 PM
1/9/2022 2:31:02 PM : UNLINKEDSALES Record Count After --->> 0 ### 1/9/2022 2:31:02 PM
1/9/2022 2:31:02 PM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 1/9/2022 2:31:02 PM
1/9/2022 2:31:02 PM :  ### 
1/9/2022 2:31:02 PM : Posting Supplierlink Query for Purchases --->>  ### 1/9/2022 2:31:02 PM
1/9/2022 2:31:08 PM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '09/Jan/2022' ### 1/9/2022 2:31:08 PM
1/9/2022 2:31:14 PM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '09/Jan/2022' ### 1/9/2022 2:31:14 PM
1/9/2022 2:31:14 PM : Posting Supplierlink Query for CompanyPurchases --->>  ### 1/9/2022 2:31:14 PM
1/9/2022 2:31:14 PM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '09/Jan/2022' ### 1/9/2022 2:31:14 PM
1/9/2022 2:31:14 PM : Posting ClosingStock Successful --->>  ### 1/9/2022 2:31:14 PM
1/9/2022 2:31:15 PM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 1/9/2022 2:31:15 PM
1/9/2022 2:31:15 PM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
1/9/2022 2:31:15 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 1/9/2022 2:31:15 PM
1/9/2022 2:31:15 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/9/2022 2:31:15 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 1/9/2022 2:31:15 PM
1/9/2022 2:31:15 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/9/2022 2:31:15 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 1/9/2022 2:31:15 PM
1/9/2022 2:31:15 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/9/2022 2:31:15 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 1/9/2022 2:31:15 PM
1/9/2022 2:31:15 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/9/2022 2:31:15 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 1/9/2022 2:31:15 PM
1/9/2022 2:31:15 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/9/2022 2:31:15 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2848065_TEMPLATE1.TXT ### 1/9/2022 2:31:15 PM
1/9/2022 2:31:15 PM : Count:: ### TEMPLATE1:52
1/9/2022 2:31:18 PM : SP_DistributorTemplatePosting Successful --->>  ### 1/9/2022 2:31:18 PM
1/9/2022 2:31:18 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3559252_TEMPLATE1.TXT ### 1/9/2022 2:31:18 PM
1/9/2022 2:31:18 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/9/2022 2:31:18 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 1/9/2022 2:31:18 PM
1/9/2022 2:31:18 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/9/2022 2:31:18 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 1/9/2022 2:31:18 PM
1/9/2022 2:31:18 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/9/2022 2:31:18 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3643369_TEMPLATE1.TXT ### 1/9/2022 2:31:18 PM
1/9/2022 2:31:18 PM : Count:: ### TEMPLATE1:178
1/9/2022 2:31:52 PM : SP_DistributorTemplatePosting Successful --->>  ### 1/9/2022 2:31:52 PM
1/9/2022 2:31:52 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 1/9/2022 2:31:52 PM
1/9/2022 2:31:52 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/9/2022 2:31:52 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 1/9/2022 2:31:52 PM
1/9/2022 2:31:52 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/9/2022 2:31:52 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 1/9/2022 2:31:52 PM
1/9/2022 2:31:52 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/9/2022 2:31:52 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 1/9/2022 2:31:52 PM
1/9/2022 2:31:52 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/9/2022 2:31:52 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 1/9/2022 2:31:52 PM
1/9/2022 2:31:52 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/9/2022 2:31:52 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060448_TEMPLATE1.TXT ### 1/9/2022 2:31:52 PM
1/9/2022 2:31:52 PM : Count:: ### TEMPLATE1:29
1/9/2022 2:31:54 PM : SP_DistributorTemplatePosting Successful --->>  ### 1/9/2022 2:31:54 PM
1/9/2022 2:31:54 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060653_TEMPLATE1.txt ### 1/9/2022 2:31:54 PM
1/9/2022 2:31:54 PM : Count:: ### TEMPLATE1:41
1/9/2022 2:31:59 PM : SP_DistributorTemplatePosting Successful --->>  ### 1/9/2022 2:31:59 PM
1/9/2022 2:31:59 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 1/9/2022 2:31:59 PM
1/9/2022 2:31:59 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/9/2022 2:31:59 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 1/9/2022 2:31:59 PM
1/9/2022 2:31:59 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/9/2022 2:31:59 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 1/9/2022 2:31:59 PM
1/9/2022 2:32:00 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/9/2022 2:32:00 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 1/9/2022 2:32:00 PM
1/9/2022 2:32:00 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/9/2022 2:32:00 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 1/9/2022 2:32:00 PM
1/9/2022 2:32:00 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
1/9/2022 2:32:00 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9064126_TEMPLATE1.txt ### 1/9/2022 2:32:00 PM
1/9/2022 2:32:00 PM : Count:: ### TEMPLATE1:2
1/9/2022 2:32:00 PM : SP_DistributorTemplatePosting Successful --->>  ### 1/9/2022 2:32:00 PM
1/9/2022 2:32:00 PM : Template Import Complete  ### 1/9/2022 2:32:00 PM
1/9/2022 2:32:02 PM : Completed Updating Has Transaction Flag  ### 1/9/2022 2:32:02 PM
1/9/2022 2:32:02 PM : Transaction Table lastEdiDate Update on BrandAlias Update ### 1/9/2022 2:32:02 PM
1/9/2022 2:32:02 PM : Zylem Access Unblocked  ### 1/9/2022 2:32:02 PM
1/9/2022 2:32:03 PM : Application Ended  ### 1/9/2022 2:32:03 PM