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

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

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

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

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

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

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

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

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

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

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

2/6/2022 7:30:02 AM : Start Process : checkAllTablesExists()  ### 
2/6/2022 7:30:03 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 2/6/2022 7:30:03 AM
2/6/2022 7:30:03 AM : MainForm_Load  ### AlertSystem ON
2/6/2022 7:30:03 AM : No. of Files to import (RECEIVEFINAL):  ### 775
2/6/2022 7:30:03 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
2/6/2022 7:30:03 AM : For Distributor 000000000001321 Insert Count::0 ### Delete Count::17
2/6/2022 7:30:03 AM : Import AD File --->> AD_1321_20220206_fcfcf97eaf2d45d2f026fa7572688e63.TXT ### 2/6/2022 7:30:03 AM
2/6/2022 7:30:31 AM : For Distributor 000000000001026 Insert Count::6 ### Delete Count::0
2/6/2022 7:30:31 AM : Import IN File --->> IN_1026_20220205_57a450ed551181ff8f705c395c029442.TXT ### 2/6/2022 7:30:31 AM
2/6/2022 7:30:32 AM : Import IN File --->> IN_1321_20220131_5f037838220b00993d2bca2ccf7afc5d.TXT ### 2/6/2022 7:30:32 AM
2/6/2022 7:30:32 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
2/6/2022 7:30:34 AM : For Distributor 000000000000739 Insert Count::4 ### Delete Count::0
2/6/2022 7:30:34 AM : Import IN File --->> IN_739_20220205_a0b813a146ffb213b0f7f032e2ce7076.TXT ### 2/6/2022 7:30:34 AM
2/6/2022 7:30:34 AM : PostData() --->>  ### 2/6/2022 7:30:34 AM
2/6/2022 7:30:34 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 2/6/2022 7:30:34 AM
2/6/2022 7:30:35 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '06/Feb/2022' ### 2/6/2022 7:30:35 AM
2/6/2022 7:30:35 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '06/Feb/2022' ### 2/6/2022 7:30:35 AM
2/6/2022 7:30:35 AM :  ### 
2/6/2022 7:30:35 AM : UNLINKEDSALES Record Count Before --->> 11 ### 2/6/2022 7:30:35 AM
2/6/2022 7:30:35 AM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 2/6/2022 7:30:35 AM
2/6/2022 7:30:43 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '06/Feb/2022' ### 2/6/2022 7:30:43 AM
2/6/2022 7:30:43 AM : UNLINKEDSALES Record Count After --->> 0 ### 2/6/2022 7:30:43 AM
2/6/2022 7:30:43 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 2/6/2022 7:30:43 AM
2/6/2022 7:30:43 AM :  ### 
2/6/2022 7:30:43 AM : Posting Supplierlink Query for Purchases --->>  ### 2/6/2022 7:30:43 AM
2/6/2022 7:30:49 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '06/Feb/2022' ### 2/6/2022 7:30:49 AM
2/6/2022 7:30:54 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '06/Feb/2022' ### 2/6/2022 7:30:54 AM
2/6/2022 7:30:54 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 2/6/2022 7:30:54 AM
2/6/2022 7:30:54 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '06/Feb/2022' ### 2/6/2022 7:30:54 AM
2/6/2022 7:30:55 AM : Posting ClosingStock Successful --->>  ### 2/6/2022 7:30:55 AM
2/6/2022 7:30:55 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 2/6/2022 7:30:55 AM
2/6/2022 7:30:55 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
2/6/2022 7:30:55 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 2/6/2022 7:30:55 AM
2/6/2022 7:30:55 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/6/2022 7:30:55 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 2/6/2022 7:30:55 AM
2/6/2022 7:30:55 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/6/2022 7:30:55 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 2/6/2022 7:30:55 AM
2/6/2022 7:30:55 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/6/2022 7:30:55 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 2/6/2022 7:30:55 AM
2/6/2022 7:30:55 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/6/2022 7:30:55 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 2/6/2022 7:30:55 AM
2/6/2022 7:30:55 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/6/2022 7:30:55 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3482327_TEMPLATE1.TXT ### 2/6/2022 7:30:55 AM
2/6/2022 7:30:55 AM : Count:: ### TEMPLATE1:27
2/6/2022 7:30:56 AM : SP_DistributorTemplatePosting Successful --->>  ### 2/6/2022 7:30:56 AM
2/6/2022 7:30:56 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 2/6/2022 7:30:56 AM
2/6/2022 7:30:56 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/6/2022 7:30:56 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3612379_TEMPLATE1.TXT ### 2/6/2022 7:30:56 AM
2/6/2022 7:30:56 AM : Count:: ### TEMPLATE1:8
2/6/2022 7:30:57 AM : SP_DistributorTemplatePosting Successful --->>  ### 2/6/2022 7:30:57 AM
2/6/2022 7:30:57 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 2/6/2022 7:30:57 AM
2/6/2022 7:30:57 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/6/2022 7:30:57 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 2/6/2022 7:30:57 AM
2/6/2022 7:30:57 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/6/2022 7:30:57 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 2/6/2022 7:30:57 AM
2/6/2022 7:30:57 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/6/2022 7:30:57 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 2/6/2022 7:30:57 AM
2/6/2022 7:30:57 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/6/2022 7:30:57 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 2/6/2022 7:30:57 AM
2/6/2022 7:30:57 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/6/2022 7:30:57 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 2/6/2022 7:30:57 AM
2/6/2022 7:30:57 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/6/2022 7:30:57 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 2/6/2022 7:30:57 AM
2/6/2022 7:30:57 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/6/2022 7:30:57 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 2/6/2022 7:30:57 AM
2/6/2022 7:30:57 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/6/2022 7:30:57 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 2/6/2022 7:30:57 AM
2/6/2022 7:30:57 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/6/2022 7:30:57 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061625_TEMPLATE1.txt ### 2/6/2022 7:30:57 AM
2/6/2022 7:30:57 AM : Count:: ### TEMPLATE1:158
2/6/2022 7:31:07 AM : SP_DistributorTemplatePosting Successful --->>  ### 2/6/2022 7:31:07 AM
2/6/2022 7:31:07 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 2/6/2022 7:31:07 AM
2/6/2022 7:31:07 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/6/2022 7:31:07 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 2/6/2022 7:31:07 AM
2/6/2022 7:31:07 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
2/6/2022 7:31:07 AM : Template Import Complete  ### 2/6/2022 7:31:07 AM
2/6/2022 7:31:10 AM : Completed Updating Has Transaction Flag  ### 2/6/2022 7:31:10 AM
2/6/2022 7:31:10 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 2/6/2022 7:31:10 AM
2/6/2022 7:31:10 AM : Zylem Access Unblocked  ### 2/6/2022 7:31:10 AM
2/6/2022 7:31:10 AM : Application Ended  ### 2/6/2022 7:31:10 AM

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

2/6/2022 2:30:04 PM : 11  ### 2/6/2022 2:30:04 PM

2/6/2022 2:30:04 PM : 22  ### 2/6/2022 2:30:04 PM

2/6/2022 2:30:04 PM : 33  ### 2/6/2022 2:30:04 PM

2/6/2022 2:30:04 PM : Application Started  ### 2/6/2022 2:30:04 PM

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