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

6/5/2022 2:30:04 AM : 11  ### 6/5/2022 2:30:04 AM

6/5/2022 2:30:04 AM : 22  ### 6/5/2022 2:30:04 AM

6/5/2022 2:30:04 AM : 33  ### 6/5/2022 2:30:04 AM

6/5/2022 2:30:04 AM : Application Started  ### 6/5/2022 2:30:04 AM

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

6/5/2022 7:30:01 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
6/5/2022 7:30:02 AM : StartProcess  ### 6/5/2022 7:30:02 AM

6/5/2022 7:30:02 AM : 11  ### 6/5/2022 7:30:02 AM

6/5/2022 7:30:02 AM : 22  ### 6/5/2022 7:30:02 AM

6/5/2022 7:30:02 AM : 33  ### 6/5/2022 7:30:02 AM

6/5/2022 7:30:02 AM : Application Started  ### 6/5/2022 7:30:02 AM

6/5/2022 7:30:02 AM : Start Process : checkAllTablesExists()  ### 
6/5/2022 7:30:02 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 6/5/2022 7:30:02 AM
6/5/2022 7:30:02 AM : MainForm_Load  ### AlertSystem ON
6/5/2022 7:30:02 AM : No. of Files to import (RECEIVEFINAL):  ### 334
6/5/2022 7:30:02 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
6/5/2022 7:30:03 AM : For Distributor 000000000000814 Insert Count::0 ### Delete Count::0
6/5/2022 7:30:03 AM : Import AD File --->> AD_814_20220605_a28a49d96736fef9c919af4857c93162.TXT ### 6/5/2022 7:30:03 AM
6/5/2022 7:30:10 AM : For Distributor 000000000000424 Insert Count::1 ### Delete Count::0
6/5/2022 7:30:10 AM : Import DN File --->> DN_424_20220602_827806f6bdf3600bb2ef448813c738ce.TXT ### 6/5/2022 7:30:10 AM
6/5/2022 7:30:14 AM : For Distributor 000000000001026 Insert Count::2 ### Delete Count::0
6/5/2022 7:30:14 AM : Import IN File --->> IN_1026_20220604_67a37614fadc6826a3b635a6515360be.TXT ### 6/5/2022 7:30:14 AM
6/5/2022 7:30:18 AM : For Distributor 000000000000424 Insert Count::2 ### Delete Count::0
6/5/2022 7:30:18 AM : Import IN File --->> IN_424_20220604_8962404dc8335bf4f60cf960f8df2bbb.TXT ### 6/5/2022 7:30:18 AM
6/5/2022 7:30:20 AM : For Distributor 000000000000814 Insert Count::0 ### Delete Count::1
6/5/2022 7:30:20 AM : Import IN File --->> IN_814_20220419_d41d8cd98f00b204e9800998ecf8427e.TXT ### 6/5/2022 7:30:20 AM
6/5/2022 7:30:20 AM : For Distributor 000000000000814 Insert Count::0 ### Delete Count::1
6/5/2022 7:30:20 AM : Import IN File --->> IN_814_20220420_d41d8cd98f00b204e9800998ecf8427e.TXT ### 6/5/2022 7:30:20 AM
6/5/2022 7:30:21 AM : For Distributor 000000000000814 Insert Count::0 ### Delete Count::1
6/5/2022 7:30:21 AM : Import IN File --->> IN_814_20220502_d41d8cd98f00b204e9800998ecf8427e.TXT ### 6/5/2022 7:30:21 AM
6/5/2022 7:30:21 AM : For Distributor 000000000000814 Insert Count::0 ### Delete Count::2
6/5/2022 7:30:21 AM : Import IN File --->> IN_814_20220507_d41d8cd98f00b204e9800998ecf8427e.TXT ### 6/5/2022 7:30:21 AM
6/5/2022 7:30:21 AM : For Distributor 000000000000814 Insert Count::0 ### Delete Count::1
6/5/2022 7:30:21 AM : Import IN File --->> IN_814_20220511_d41d8cd98f00b204e9800998ecf8427e.TXT ### 6/5/2022 7:30:21 AM
6/5/2022 7:30:22 AM : For Distributor 000000000000814 Insert Count::0 ### Delete Count::1
6/5/2022 7:30:22 AM : Import IN File --->> IN_814_20220519_d41d8cd98f00b204e9800998ecf8427e.TXT ### 6/5/2022 7:30:22 AM
6/5/2022 7:30:22 AM : For Distributor 000000000000814 Insert Count::0 ### Delete Count::3
6/5/2022 7:30:22 AM : Import IN File --->> IN_814_20220523_d41d8cd98f00b204e9800998ecf8427e.TXT ### 6/5/2022 7:30:22 AM
6/5/2022 7:30:22 AM : For Distributor 000000000000814 Insert Count::0 ### Delete Count::1
6/5/2022 7:30:22 AM : Import IN File --->> IN_814_20220525_d41d8cd98f00b204e9800998ecf8427e.TXT ### 6/5/2022 7:30:22 AM
6/5/2022 7:30:23 AM : For Distributor 000000000000814 Insert Count::0 ### Delete Count::1
6/5/2022 7:30:23 AM : Import IN File --->> IN_814_20220527_d41d8cd98f00b204e9800998ecf8427e.TXT ### 6/5/2022 7:30:23 AM
6/5/2022 7:30:23 AM : PostData() --->>  ### 6/5/2022 7:30:23 AM
6/5/2022 7:30:24 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 6/5/2022 7:30:24 AM
6/5/2022 7:30:24 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '05/Jun/2022' ### 6/5/2022 7:30:24 AM
6/5/2022 7:30:25 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '05/Jun/2022' ### 6/5/2022 7:30:25 AM
6/5/2022 7:30:25 AM :  ### 
6/5/2022 7:30:25 AM : UNLINKEDSALES Record Count Before --->> 4 ### 6/5/2022 7:30:25 AM
6/5/2022 7:30:25 AM : UNLINKEDSALES_DEL Record Count Before --->> 12 ### 6/5/2022 7:30:25 AM
6/5/2022 7:47:08 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '05/Jun/2022' ### 6/5/2022 7:47:08 AM
6/5/2022 7:47:08 AM : UNLINKEDSALES Record Count After --->> 0 ### 6/5/2022 7:47:08 AM
6/5/2022 7:47:08 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 6/5/2022 7:47:08 AM
6/5/2022 7:47:08 AM :  ### 
6/5/2022 7:47:08 AM : Posting Supplierlink Query for Purchases --->>  ### 6/5/2022 7:47:08 AM
6/5/2022 7:47:15 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '05/Jun/2022' ### 6/5/2022 7:47:15 AM
6/5/2022 7:47:22 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '05/Jun/2022' ### 6/5/2022 7:47:22 AM
6/5/2022 7:47:22 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 6/5/2022 7:47:22 AM
6/5/2022 7:47:22 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '05/Jun/2022' ### 6/5/2022 7:47:22 AM
6/5/2022 7:47:22 AM : Posting ClosingStock Successful --->>  ### 6/5/2022 7:47:22 AM
6/5/2022 7:47:22 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 6/5/2022 7:47:22 AM
6/5/2022 7:47:22 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
6/5/2022 7:47:22 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 6/5/2022 7:47:22 AM
6/5/2022 7:47:22 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/5/2022 7:47:22 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 6/5/2022 7:47:22 AM
6/5/2022 7:47:22 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/5/2022 7:47:22 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 6/5/2022 7:47:22 AM
6/5/2022 7:47:22 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/5/2022 7:47:22 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 6/5/2022 7:47:22 AM
6/5/2022 7:47:22 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/5/2022 7:47:22 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 6/5/2022 7:47:22 AM
6/5/2022 7:47:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/5/2022 7:47:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3559252_TEMPLATE1.TXT ### 6/5/2022 7:47:23 AM
6/5/2022 7:47:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/5/2022 7:47:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 6/5/2022 7:47:23 AM
6/5/2022 7:47:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/5/2022 7:47:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 6/5/2022 7:47:23 AM
6/5/2022 7:47:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/5/2022 7:47:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 6/5/2022 7:47:23 AM
6/5/2022 7:47:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/5/2022 7:47:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 6/5/2022 7:47:23 AM
6/5/2022 7:47:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/5/2022 7:47:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 6/5/2022 7:47:23 AM
6/5/2022 7:47:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/5/2022 7:47:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 6/5/2022 7:47:23 AM
6/5/2022 7:47:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/5/2022 7:47:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 6/5/2022 7:47:23 AM
6/5/2022 7:47:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/5/2022 7:47:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_722734_TEMPLATE1.TXT ### 6/5/2022 7:47:23 AM
6/5/2022 7:47:23 AM : Count:: ### TEMPLATE1:1
6/5/2022 7:47:23 AM : SP_DistributorTemplatePosting Successful --->>  ### 6/5/2022 7:47:23 AM
6/5/2022 7:47:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060893_TEMPLATE1.txt ### 6/5/2022 7:47:23 AM
6/5/2022 7:47:23 AM : Count:: ### TEMPLATE1:103
6/5/2022 7:47:40 AM : SP_DistributorTemplatePosting Successful --->>  ### 6/5/2022 7:47:40 AM
6/5/2022 7:47:40 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 6/5/2022 7:47:40 AM
6/5/2022 7:47:40 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/5/2022 7:47:40 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 6/5/2022 7:47:40 AM
6/5/2022 7:47:40 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/5/2022 7:47:40 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 6/5/2022 7:47:40 AM
6/5/2022 7:47:40 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/5/2022 7:47:40 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 6/5/2022 7:47:40 AM
6/5/2022 7:47:40 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/5/2022 7:47:40 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 6/5/2022 7:47:40 AM
6/5/2022 7:47:40 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/5/2022 7:47:40 AM : Error in file  ### TEMPLATE1 (1) at Line 124
6/5/2022 7:47:40 AM : Template Import Complete  ### 6/5/2022 7:47:40 AM
6/5/2022 7:47:43 AM : Completed Updating Has Transaction Flag  ### 6/5/2022 7:47:43 AM
6/5/2022 7:47:43 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 6/5/2022 7:47:43 AM
6/5/2022 7:47:43 AM : Zylem Access Unblocked  ### 6/5/2022 7:47:43 AM
6/5/2022 7:47:43 AM : Application Ended  ### 6/5/2022 7:47:43 AM

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

6/5/2022 2:30:03 PM : 11  ### 6/5/2022 2:30:03 PM

6/5/2022 2:30:03 PM : 22  ### 6/5/2022 2:30:03 PM

6/5/2022 2:30:03 PM : 33  ### 6/5/2022 2:30:03 PM

6/5/2022 2:30:03 PM : Application Started  ### 6/5/2022 2:30:03 PM

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