9/5/2021 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
9/5/2021 2:30:03 AM : StartProcess  ### 9/5/2021 2:30:03 AM

9/5/2021 2:30:03 AM : 11  ### 9/5/2021 2:30:03 AM

9/5/2021 2:30:03 AM : 22  ### 9/5/2021 2:30:03 AM

9/5/2021 2:30:03 AM : 33  ### 9/5/2021 2:30:03 AM

9/5/2021 2:30:03 AM : Application Started  ### 9/5/2021 2:30:03 AM

9/5/2021 2:30:03 AM : Start Process : checkAllTablesExists()  ### 
9/5/2021 2:30:03 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 9/5/2021 2:30:03 AM
9/5/2021 2:30:04 AM : MainForm_Load  ### AlertSystem ON
9/5/2021 2:30:04 AM : No. of Files to import (RECEIVEFINAL):  ### 387
9/5/2021 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
9/5/2021 2:30:05 AM : Import DN File --->> DN_265_20210903_4ef4c0cc53daaa9b13a5c576e714fd49.TXT ### 9/5/2021 2:30:05 AM
9/5/2021 2:30:05 AM : NO Previous File For Distributor 000000000000265 ### Insert Count::7
9/5/2021 2:30:12 AM : For Distributor 000000000000265 Insert Count::2 ### Delete Count::2
9/5/2021 2:30:12 AM : Import IN File --->> IN_265_20210828_58491c572997f26cec25e00867dd0472.TXT ### 9/5/2021 2:30:12 AM
9/5/2021 2:30:12 AM : For Distributor 000000000000265 Insert Count::1 ### Delete Count::1
9/5/2021 2:30:12 AM : Import IN File --->> IN_265_20210830_6e4fef3d53c66f66a858ed7997305ee8.TXT ### 9/5/2021 2:30:12 AM
9/5/2021 2:30:12 AM : For Distributor 000000000000265 Insert Count::1 ### Delete Count::0
9/5/2021 2:30:12 AM : Import IN File --->> IN_265_20210902_52935dbf8f25c2925a438db900d4ee3c.TXT ### 9/5/2021 2:30:12 AM
9/5/2021 2:30:12 AM : Import IN File --->> IN_265_20210903_54b1ea1a7bfc78ee0f0d7e85419f5f40.TXT ### 9/5/2021 2:30:12 AM
9/5/2021 2:30:12 AM : NO Previous File For Distributor 000000000000265 ### Insert Count::3
9/5/2021 2:30:18 AM : PostData() --->>  ### 9/5/2021 2:30:18 AM
9/5/2021 2:30:18 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 9/5/2021 2:30:18 AM
9/5/2021 2:30:19 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '05/Sep/2021' ### 9/5/2021 2:30:19 AM
9/5/2021 2:30:19 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '05/Sep/2021' ### 9/5/2021 2:30:19 AM
9/5/2021 2:30:19 AM :  ### 
9/5/2021 2:30:19 AM : UNLINKEDSALES Record Count Before --->> 7 ### 9/5/2021 2:30:19 AM
9/5/2021 2:30:19 AM : UNLINKEDSALES_DEL Record Count Before --->> 3 ### 9/5/2021 2:30:19 AM
9/5/2021 2:30:26 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '05/Sep/2021' ### 9/5/2021 2:30:26 AM
9/5/2021 2:30:26 AM : UNLINKEDSALES Record Count After --->> 0 ### 9/5/2021 2:30:26 AM
9/5/2021 2:30:26 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 9/5/2021 2:30:26 AM
9/5/2021 2:30:26 AM :  ### 
9/5/2021 2:30:26 AM : Posting Supplierlink Query for Purchases --->>  ### 9/5/2021 2:30:26 AM
9/5/2021 2:30:32 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '05/Sep/2021' ### 9/5/2021 2:30:32 AM
9/5/2021 2:30:37 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '05/Sep/2021' ### 9/5/2021 2:30:37 AM
9/5/2021 2:30:37 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 9/5/2021 2:30:37 AM
9/5/2021 2:30:37 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '05/Sep/2021' ### 9/5/2021 2:30:37 AM
9/5/2021 2:30:38 AM : Posting ClosingStock Successful --->>  ### 9/5/2021 2:30:38 AM
9/5/2021 2:30:38 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 9/5/2021 2:30:38 AM
9/5/2021 2:30:38 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
9/5/2021 2:30:38 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 9/5/2021 2:30:38 AM
9/5/2021 2:30:38 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:30:38 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 9/5/2021 2:30:38 AM
9/5/2021 2:30:38 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:30:38 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 9/5/2021 2:30:38 AM
9/5/2021 2:30:38 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:30:38 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 9/5/2021 2:30:38 AM
9/5/2021 2:30:38 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:30:38 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2838040_TEMPLATE1.TXT ### 9/5/2021 2:30:38 AM
9/5/2021 2:30:38 AM : Count:: ### TEMPLATE1:155
9/5/2021 2:30:47 AM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 2:30:47 AM
9/5/2021 2:30:47 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3272418_TEMPLATE1.TXT ### 9/5/2021 2:30:47 AM
9/5/2021 2:30:47 AM : Count:: ### TEMPLATE1:71
9/5/2021 2:30:55 AM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 2:30:55 AM
9/5/2021 2:30:55 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3482211_TEMPLATE1.txt ### 9/5/2021 2:30:55 AM
9/5/2021 2:30:55 AM : Count:: ### TEMPLATE1:57
9/5/2021 2:31:00 AM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 2:31:00 AM
9/5/2021 2:31:00 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 9/5/2021 2:31:00 AM
9/5/2021 2:31:00 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:31:00 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 9/5/2021 2:31:00 AM
9/5/2021 2:31:00 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:31:00 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3800230_TEMPLATE1.txt ### 9/5/2021 2:31:00 AM
9/5/2021 2:31:00 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:31:00 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 9/5/2021 2:31:00 AM
9/5/2021 2:31:00 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:31:00 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 9/5/2021 2:31:00 AM
9/5/2021 2:31:00 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:31:00 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 9/5/2021 2:31:00 AM
9/5/2021 2:31:00 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:31:00 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 9/5/2021 2:31:00 AM
9/5/2021 2:31:00 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:31:00 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 9/5/2021 2:31:00 AM
9/5/2021 2:31:00 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:31:00 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 9/5/2021 2:31:00 AM
9/5/2021 2:31:00 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:31:00 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 9/5/2021 2:31:00 AM
9/5/2021 2:31:00 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:31:00 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 9/5/2021 2:31:00 AM
9/5/2021 2:31:00 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:31:00 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 9/5/2021 2:31:00 AM
9/5/2021 2:31:00 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:31:00 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 9/5/2021 2:31:00 AM
9/5/2021 2:31:00 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:31:00 AM : Template Import Complete  ### 9/5/2021 2:31:00 AM
9/5/2021 2:31:03 AM : Completed Updating Has Transaction Flag  ### 9/5/2021 2:31:03 AM
9/5/2021 2:31:03 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 9/5/2021 2:31:03 AM
9/5/2021 2:31:03 AM : Zylem Access Unblocked  ### 9/5/2021 2:31:03 AM
9/5/2021 2:31:03 AM : Application Ended  ### 9/5/2021 2:31:03 AM

9/5/2021 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
9/5/2021 7:30:02 AM : StartProcess  ### 9/5/2021 7:30:02 AM

9/5/2021 7:30:02 AM : 11  ### 9/5/2021 7:30:02 AM

9/5/2021 7:30:02 AM : 22  ### 9/5/2021 7:30:02 AM

9/5/2021 7:30:02 AM : 33  ### 9/5/2021 7:30:02 AM

9/5/2021 7:30:02 AM : Application Started  ### 9/5/2021 7:30:02 AM

9/5/2021 7:30:02 AM : Start Process : checkAllTablesExists()  ### 
9/5/2021 7:30:02 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 9/5/2021 7:30:02 AM
9/5/2021 7:30:02 AM : MainForm_Load  ### AlertSystem ON
9/5/2021 7:30:02 AM : No. of Files to import (RECEIVEFINAL):  ### 2191
9/5/2021 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
9/5/2021 7:30:02 AM : For Distributor 000000000001047 Insert Count::2 ### Delete Count::0
9/5/2021 7:30:02 AM : Import AD File --->> AD_1047_20210905_4a28f43a205f92577f8d0e9b1c6810d4.TXT ### 9/5/2021 7:30:02 AM
9/5/2021 7:30:03 AM : For Distributor 000000000001142 Insert Count::12 ### Delete Count::0
9/5/2021 7:30:03 AM : Import AD File --->> AD_1142_20210905_be42801b721b1d3b46f2b8dee80c1372.TXT ### 9/5/2021 7:30:03 AM
9/5/2021 7:30:03 AM : For Distributor 000000000001170 Insert Count::0 ### Delete Count::25
9/5/2021 7:30:03 AM : Import AD File --->> AD_1170_20210905_15e6a32d0e3ebabeb25ba588109c2dbd.TXT ### 9/5/2021 7:30:03 AM
9/5/2021 7:30:03 AM : For Distributor 000000000001185 Insert Count::2 ### Delete Count::0
9/5/2021 7:30:03 AM : Import AD File --->> AD_1185_20210905_ad37762fa099fa92e79eeaa6cef52b5e.TXT ### 9/5/2021 7:30:03 AM
9/5/2021 7:30:03 AM : For Distributor 000000000000424 Insert Count::3 ### Delete Count::0
9/5/2021 7:30:03 AM : Import AD File --->> AD_424_20210905_785bc53f8872fea97fdba448fa17138c.TXT ### 9/5/2021 7:30:03 AM
9/5/2021 7:30:03 AM : For Distributor 000000000000499 Insert Count::2 ### Delete Count::0
9/5/2021 7:30:03 AM : Import AD File --->> AD_499_20210905_7af58864db0b45e17a592d72393094eb.TXT ### 9/5/2021 7:30:03 AM
9/5/2021 7:30:04 AM : For Distributor 000000000000519 Insert Count::7 ### Delete Count::0
9/5/2021 7:30:04 AM : Import AD File --->> AD_519_20210905_cb1c7b28188a4c88ab4ce6e0f37e4bf7.TXT ### 9/5/2021 7:30:04 AM
9/5/2021 7:30:16 AM : For Distributor 000000000001142 Insert Count::7 ### Delete Count::0
9/5/2021 7:30:16 AM : Import DN File --->> DN_1142_20210826_c0a17346790c5a9ba5e6fb5d8f7ed3d2.TXT ### 9/5/2021 7:30:16 AM
9/5/2021 7:30:16 AM : For Distributor 000000000001142 Insert Count::1 ### Delete Count::0
9/5/2021 7:30:16 AM : Import DN File --->> DN_1142_20210827_d6c75d54647c45a74869c32d8db37094.TXT ### 9/5/2021 7:30:16 AM
9/5/2021 7:30:16 AM : Import DN File --->> DN_1142_20210828_aacf03f5d8e09f9a23949df06345f161.TXT ### 9/5/2021 7:30:16 AM
9/5/2021 7:30:16 AM : NO Previous File For Distributor 000000000001142 ### Insert Count::1
9/5/2021 7:30:27 AM : For Distributor 000000000000424 Insert Count::14 ### Delete Count::0
9/5/2021 7:30:27 AM : Import DN File --->> DN_424_20210901_aa9c4948f47fd9665922475c928f3b58.TXT ### 9/5/2021 7:30:27 AM
9/5/2021 7:30:32 AM : For Distributor 000000000000499 Insert Count::2 ### Delete Count::0
9/5/2021 7:30:32 AM : Import DN File --->> DN_499_20210903_927e1e58397ecddc1bcc2d707c23212d.TXT ### 9/5/2021 7:30:32 AM
9/5/2021 7:30:44 AM : For Distributor 000000000001026 Insert Count::1 ### Delete Count::0
9/5/2021 7:30:44 AM : Import IN File --->> IN_1026_20210903_d0258ef9b390bdca8e4e121349c903e8.TXT ### 9/5/2021 7:30:44 AM
9/5/2021 7:30:44 AM : For Distributor 000000000001026 Insert Count::9 ### Delete Count::0
9/5/2021 7:30:44 AM : Import IN File --->> IN_1026_20210904_492c2176273797f96d5f44a4b0425e34.TXT ### 9/5/2021 7:30:44 AM
9/5/2021 7:30:45 AM : For Distributor 000000000001047 Insert Count::0 ### Delete Count::1
9/5/2021 7:30:45 AM : Import IN File --->> IN_1047_20210831_40278218aa2a039e5abd7874214368aa.TXT ### 9/5/2021 7:30:45 AM
9/5/2021 7:30:46 AM : For Distributor 000000000001047 Insert Count::0 ### Delete Count::1
9/5/2021 7:30:46 AM : Import IN File --->> IN_1047_20210903_fecd4b87b0cc2f3debbb71c34463faff.TXT ### 9/5/2021 7:30:46 AM
9/5/2021 7:30:46 AM : For Distributor 000000000001047 Insert Count::33 ### Delete Count::0
9/5/2021 7:30:46 AM : Import IN File --->> IN_1047_20210904_1f03220fe3a736eedec893301ac95a01.TXT ### 9/5/2021 7:30:46 AM
9/5/2021 7:30:50 AM : For Distributor 000000000001142 Insert Count::1 ### Delete Count::0
9/5/2021 7:30:50 AM : Import IN File --->> IN_1142_20210802_6c9ae841dea537d3de991f93aa393080.TXT ### 9/5/2021 7:30:50 AM
9/5/2021 7:30:50 AM : For Distributor 000000000001142 Insert Count::1 ### Delete Count::0
9/5/2021 7:30:50 AM : Import IN File --->> IN_1142_20210803_10cb9ce80a022a527ccc688b1921bc2c.TXT ### 9/5/2021 7:30:50 AM
9/5/2021 7:30:50 AM : For Distributor 000000000001142 Insert Count::1 ### Delete Count::0
9/5/2021 7:30:50 AM : Import IN File --->> IN_1142_20210804_d6b5af5be8a0b59b9f289ba90ea76348.TXT ### 9/5/2021 7:30:50 AM
9/5/2021 7:30:50 AM : For Distributor 000000000001142 Insert Count::1 ### Delete Count::0
9/5/2021 7:30:50 AM : Import IN File --->> IN_1142_20210805_cf100b4638240a0168ebef1a432ce6e2.TXT ### 9/5/2021 7:30:50 AM
9/5/2021 7:30:51 AM : For Distributor 000000000001142 Insert Count::1 ### Delete Count::0
9/5/2021 7:30:51 AM : Import IN File --->> IN_1142_20210811_9c713e3f4d2ea5312e46bb70dc943768.TXT ### 9/5/2021 7:30:51 AM
9/5/2021 7:30:51 AM : For Distributor 000000000001142 Insert Count::3 ### Delete Count::0
9/5/2021 7:30:51 AM : Import IN File --->> IN_1142_20210816_b825362f8d587eb706b8bd963a4966d5.TXT ### 9/5/2021 7:30:51 AM
9/5/2021 7:30:51 AM : For Distributor 000000000001142 Insert Count::1 ### Delete Count::0
9/5/2021 7:30:51 AM : Import IN File --->> IN_1142_20210817_55604573067a92d2e105dfc91348a92a.TXT ### 9/5/2021 7:30:51 AM
9/5/2021 7:30:51 AM : For Distributor 000000000001142 Insert Count::2 ### Delete Count::2
9/5/2021 7:30:51 AM : Import IN File --->> IN_1142_20210819_aa8214b18fff56f920dd940e6fd46891.TXT ### 9/5/2021 7:30:51 AM
9/5/2021 7:30:51 AM : For Distributor 000000000001142 Insert Count::1 ### Delete Count::0
9/5/2021 7:30:51 AM : Import IN File --->> IN_1142_20210820_3115066875bc4aa91fef6b5667c51c87.TXT ### 9/5/2021 7:30:51 AM
9/5/2021 7:30:51 AM : For Distributor 000000000001142 Insert Count::2 ### Delete Count::0
9/5/2021 7:30:51 AM : Import IN File --->> IN_1142_20210825_70a087b03d9cc9d31535a8456a8ad2e0.TXT ### 9/5/2021 7:30:51 AM
9/5/2021 7:30:52 AM : For Distributor 000000000001142 Insert Count::13 ### Delete Count::0
9/5/2021 7:30:52 AM : Import IN File --->> IN_1142_20210827_cb7671e47c1b5108bbd208a65aefd23b.TXT ### 9/5/2021 7:30:52 AM
9/5/2021 7:30:52 AM : Import IN File --->> IN_1142_20210828_b1c6771d8c5239b672d5e1a883ff150a.TXT ### 9/5/2021 7:30:52 AM
9/5/2021 7:30:52 AM : NO Previous File For Distributor 000000000001142 ### Insert Count::17
9/5/2021 7:30:52 AM : Import IN File --->> IN_1142_20210829_fd3ad71ac41422423b112fd679c33113.TXT ### 9/5/2021 7:30:52 AM
9/5/2021 7:30:52 AM : NO Previous File For Distributor 000000000001142 ### Insert Count::5
9/5/2021 7:30:52 AM : Import IN File --->> IN_1142_20210830_32110e6348dbe13f38b85badc01c9f77.TXT ### 9/5/2021 7:30:52 AM
9/5/2021 7:30:52 AM : NO Previous File For Distributor 000000000001142 ### Insert Count::26
9/5/2021 7:30:52 AM : Import IN File --->> IN_1142_20210831_2eb11b1fc90b1f905510222225768c16.TXT ### 9/5/2021 7:30:52 AM
9/5/2021 7:30:52 AM : NO Previous File For Distributor 000000000001142 ### Insert Count::5
9/5/2021 7:30:52 AM : Import IN File --->> IN_1142_20210901_d15971f73432711a7b11d00e4056b309.TXT ### 9/5/2021 7:30:52 AM
9/5/2021 7:30:52 AM : NO Previous File For Distributor 000000000001142 ### Insert Count::20
9/5/2021 7:30:52 AM : Import IN File --->> IN_1142_20210902_bd0a752df89bd9d35d7ba27cda291a8e.TXT ### 9/5/2021 7:30:52 AM
9/5/2021 7:30:52 AM : NO Previous File For Distributor 000000000001142 ### Insert Count::22
9/5/2021 7:30:52 AM : Import IN File --->> IN_1142_20210903_a5e77915d1a1771e6fd49bc445bc4b2a.TXT ### 9/5/2021 7:30:52 AM
9/5/2021 7:30:52 AM : NO Previous File For Distributor 000000000001142 ### Insert Count::14
9/5/2021 7:30:52 AM : Import IN File --->> IN_1142_20210904_543584ee879eacebbe056781e53e56d8.TXT ### 9/5/2021 7:30:52 AM
9/5/2021 7:30:52 AM : NO Previous File For Distributor 000000000001142 ### Insert Count::17
9/5/2021 7:30:52 AM : Exception  ### Index was outside the bounds of the array.
9/5/2021 7:30:52 AM : Error ### Index was outside the bounds of the array. Line 
9/5/2021 7:30:52 AM : For Distributor 000000000001170 Insert Count::0 ### Delete Count::6
9/5/2021 7:30:52 AM : Import IN File --->> IN_1170_20210811_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 7:30:52 AM
9/5/2021 7:30:53 AM : For Distributor 000000000001170 Insert Count::0 ### Delete Count::9
9/5/2021 7:30:53 AM : Import IN File --->> IN_1170_20210812_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 7:30:53 AM
9/5/2021 7:30:53 AM : For Distributor 000000000001170 Insert Count::0 ### Delete Count::9
9/5/2021 7:30:53 AM : Import IN File --->> IN_1170_20210813_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 7:30:53 AM
9/5/2021 7:30:53 AM : For Distributor 000000000001170 Insert Count::0 ### Delete Count::4
9/5/2021 7:30:53 AM : Import IN File --->> IN_1170_20210814_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 7:30:53 AM
9/5/2021 7:30:53 AM : For Distributor 000000000001170 Insert Count::0 ### Delete Count::3
9/5/2021 7:30:53 AM : Import IN File --->> IN_1170_20210815_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 7:30:53 AM
9/5/2021 7:30:53 AM : For Distributor 000000000001170 Insert Count::0 ### Delete Count::8
9/5/2021 7:30:53 AM : Import IN File --->> IN_1170_20210816_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 7:30:53 AM
9/5/2021 7:30:53 AM : For Distributor 000000000001170 Insert Count::0 ### Delete Count::9
9/5/2021 7:30:53 AM : Import IN File --->> IN_1170_20210817_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 7:30:53 AM
9/5/2021 7:30:53 AM : For Distributor 000000000001170 Insert Count::0 ### Delete Count::7
9/5/2021 7:30:53 AM : Import IN File --->> IN_1170_20210818_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 7:30:53 AM
9/5/2021 7:30:53 AM : For Distributor 000000000001170 Insert Count::0 ### Delete Count::7
9/5/2021 7:30:53 AM : Import IN File --->> IN_1170_20210819_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 7:30:53 AM
9/5/2021 7:30:53 AM : For Distributor 000000000001170 Insert Count::0 ### Delete Count::6
9/5/2021 7:30:53 AM : Import IN File --->> IN_1170_20210820_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 7:30:53 AM
9/5/2021 7:30:54 AM : For Distributor 000000000001170 Insert Count::0 ### Delete Count::15
9/5/2021 7:30:54 AM : Import IN File --->> IN_1170_20210821_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 7:30:54 AM
9/5/2021 7:30:54 AM : For Distributor 000000000001170 Insert Count::0 ### Delete Count::2
9/5/2021 7:30:54 AM : Import IN File --->> IN_1170_20210822_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 7:30:54 AM
9/5/2021 7:30:54 AM : For Distributor 000000000001170 Insert Count::0 ### Delete Count::17
9/5/2021 7:30:54 AM : Import IN File --->> IN_1170_20210823_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 7:30:54 AM
9/5/2021 7:30:54 AM : For Distributor 000000000001170 Insert Count::0 ### Delete Count::39
9/5/2021 7:30:54 AM : Import IN File --->> IN_1170_20210824_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 7:30:54 AM
9/5/2021 7:30:54 AM : For Distributor 000000000001170 Insert Count::0 ### Delete Count::12
9/5/2021 7:30:54 AM : Import IN File --->> IN_1170_20210825_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 7:30:54 AM
9/5/2021 7:30:54 AM : For Distributor 000000000001170 Insert Count::0 ### Delete Count::16
9/5/2021 7:30:54 AM : Import IN File --->> IN_1170_20210826_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 7:30:54 AM
9/5/2021 7:30:54 AM : For Distributor 000000000001170 Insert Count::0 ### Delete Count::11
9/5/2021 7:30:54 AM : Import IN File --->> IN_1170_20210827_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 7:30:54 AM
9/5/2021 7:30:54 AM : For Distributor 000000000001170 Insert Count::0 ### Delete Count::16
9/5/2021 7:30:54 AM : Import IN File --->> IN_1170_20210828_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 7:30:54 AM
9/5/2021 7:30:54 AM : For Distributor 000000000001170 Insert Count::0 ### Delete Count::22
9/5/2021 7:30:54 AM : Import IN File --->> IN_1170_20210829_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 7:30:54 AM
9/5/2021 7:30:54 AM : For Distributor 000000000001170 Insert Count::0 ### Delete Count::11
9/5/2021 7:30:54 AM : Import IN File --->> IN_1170_20210830_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 7:30:54 AM
9/5/2021 7:30:55 AM : For Distributor 000000000001170 Insert Count::0 ### Delete Count::5
9/5/2021 7:30:55 AM : Import IN File --->> IN_1170_20210831_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 7:30:55 AM
9/5/2021 7:30:55 AM : For Distributor 000000000001170 Insert Count::0 ### Delete Count::10
9/5/2021 7:30:55 AM : Import IN File --->> IN_1170_20210901_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 7:30:55 AM
9/5/2021 7:30:55 AM : For Distributor 000000000001170 Insert Count::0 ### Delete Count::3
9/5/2021 7:30:55 AM : Import IN File --->> IN_1170_20210902_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 7:30:55 AM
9/5/2021 7:30:55 AM : For Distributor 000000000001170 Insert Count::0 ### Delete Count::6
9/5/2021 7:30:55 AM : Import IN File --->> IN_1170_20210903_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 7:30:55 AM
9/5/2021 7:30:59 AM : Import IN File --->> IN_1185_20210904_d0daf771e85846eb85a5705d731e15d6.TXT ### 9/5/2021 7:30:59 AM
9/5/2021 7:30:59 AM : NO Previous File For Distributor 000000000001185 ### Insert Count::6
9/5/2021 7:31:00 AM : For Distributor 000000000001215 Insert Count::0 ### Delete Count::1
9/5/2021 7:31:00 AM : Import IN File --->> IN_1215_20210823_785e7fbc46c53df47168b987694653f5.TXT ### 9/5/2021 7:31:00 AM
9/5/2021 7:31:03 AM : For Distributor 000000000000405 Insert Count::1 ### Delete Count::0
9/5/2021 7:31:03 AM : Import IN File --->> IN_405_20210904_9a654d32c1371406027abe6855e9f89a.TXT ### 9/5/2021 7:31:03 AM
9/5/2021 7:31:06 AM : For Distributor 000000000000424 Insert Count::0 ### Delete Count::1
9/5/2021 7:31:06 AM : Import IN File --->> IN_424_20210901_86441f830efd8bf564333e43cf6b3bd6.TXT ### 9/5/2021 7:31:06 AM
9/5/2021 7:31:06 AM : For Distributor 000000000000424 Insert Count::33 ### Delete Count::0
9/5/2021 7:31:06 AM : Import IN File --->> IN_424_20210903_e106d33104430b215e2c4f1b1ea8b50a.TXT ### 9/5/2021 7:31:06 AM
9/5/2021 7:31:06 AM : Import IN File --->> IN_424_20210904_26d3c9badf4e0949f3e4066ee032322f.TXT ### 9/5/2021 7:31:06 AM
9/5/2021 7:31:06 AM : NO Previous File For Distributor 000000000000424 ### Insert Count::25
9/5/2021 7:31:11 AM : For Distributor 000000000000499 Insert Count::12 ### Delete Count::0
9/5/2021 7:31:11 AM : Import IN File --->> IN_499_20210904_cfbacd7ebf536dcc0c94f39f619af06f.TXT ### 9/5/2021 7:31:11 AM
9/5/2021 7:31:11 AM : Import IN File --->> IN_499_20210905_9de4519f3a3381dd61908c324f51414d.TXT ### 9/5/2021 7:31:11 AM
9/5/2021 7:31:11 AM : NO Previous File For Distributor 000000000000499 ### Insert Count::4
9/5/2021 7:31:17 AM : For Distributor 000000000000519 Insert Count::29 ### Delete Count::0
9/5/2021 7:31:17 AM : Import IN File --->> IN_519_20210904_6a3b9584a43afe509c4fd05d51ab61d9.TXT ### 9/5/2021 7:31:17 AM
9/5/2021 7:31:18 AM : For Distributor 000000000000099 Insert Count::4 ### Delete Count::0
9/5/2021 7:31:18 AM : Import IN File --->> IN_99_20210831_3e00f89cb74ce2c568566259be68b6c0.TXT ### 9/5/2021 7:31:18 AM
9/5/2021 7:31:23 AM : For Distributor 000000000001142 Insert Count::3 ### Delete Count::0
9/5/2021 7:31:23 AM : Import PR File --->> PR_1142_20210905_2d09832ca08dcf4f9fbaf8ed222e4559.TXT ### 9/5/2021 7:31:23 AM
9/5/2021 7:31:23 AM : Exception  ### Index was outside the bounds of the array.
9/5/2021 7:31:23 AM : Error ### Index was outside the bounds of the array. Line 
9/5/2021 7:31:23 AM : PostData() --->>  ### 9/5/2021 7:31:23 AM
9/5/2021 7:31:27 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 9/5/2021 7:31:27 AM
9/5/2021 7:31:30 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '05/Sep/2021' ### 9/5/2021 7:31:30 AM
9/5/2021 7:31:31 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '05/Sep/2021' ### 9/5/2021 7:31:31 AM
9/5/2021 7:31:31 AM :  ### 
9/5/2021 7:31:31 AM : UNLINKEDSALES Record Count Before --->> 310 ### 9/5/2021 7:31:31 AM
9/5/2021 7:31:31 AM : UNLINKEDSALES_DEL Record Count Before --->> 259 ### 9/5/2021 7:31:31 AM
9/5/2021 7:32:00 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '05/Sep/2021' ### 9/5/2021 7:32:00 AM
9/5/2021 7:32:00 AM : UNLINKEDSALES Record Count After --->> 0 ### 9/5/2021 7:32:00 AM
9/5/2021 7:32:00 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 9/5/2021 7:32:00 AM
9/5/2021 7:32:00 AM :  ### 
9/5/2021 7:32:00 AM : Posting Supplierlink Query for Purchases --->>  ### 9/5/2021 7:32:00 AM
9/5/2021 7:32:06 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '05/Sep/2021' ### 9/5/2021 7:32:06 AM
9/5/2021 7:32:12 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '05/Sep/2021' ### 9/5/2021 7:32:12 AM
9/5/2021 7:32:12 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 9/5/2021 7:32:12 AM
9/5/2021 7:32:12 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '05/Sep/2021' ### 9/5/2021 7:32:12 AM
9/5/2021 7:32:12 AM : Posting ClosingStock Successful --->>  ### 9/5/2021 7:32:12 AM
9/5/2021 7:32:12 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 9/5/2021 7:32:12 AM
9/5/2021 7:32:12 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
9/5/2021 7:32:12 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 9/5/2021 7:32:12 AM
9/5/2021 7:32:12 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 7:32:12 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 9/5/2021 7:32:12 AM
9/5/2021 7:32:12 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 7:32:12 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 9/5/2021 7:32:12 AM
9/5/2021 7:32:12 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 7:32:12 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 9/5/2021 7:32:12 AM
9/5/2021 7:32:12 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 7:32:12 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2838040_TEMPLATE1.TXT ### 9/5/2021 7:32:12 AM
9/5/2021 7:32:12 AM : Count:: ### TEMPLATE1:155
9/5/2021 7:32:21 AM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 7:32:21 AM
9/5/2021 7:32:21 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3596136_TEMPLATE1.txt ### 9/5/2021 7:32:21 AM
9/5/2021 7:32:21 AM : Count:: ### TEMPLATE1:36
9/5/2021 7:32:26 AM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 7:32:26 AM
9/5/2021 7:32:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 9/5/2021 7:32:26 AM
9/5/2021 7:32:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 7:32:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 9/5/2021 7:32:26 AM
9/5/2021 7:32:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 7:32:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3675389_TEMPLATE1.txt ### 9/5/2021 7:32:26 AM
9/5/2021 7:32:26 AM : Count:: ### TEMPLATE1:1973
9/5/2021 7:34:18 AM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 7:34:18 AM
9/5/2021 7:34:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3800230_TEMPLATE1.txt ### 9/5/2021 7:34:18 AM
9/5/2021 7:34:18 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 7:34:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 9/5/2021 7:34:18 AM
9/5/2021 7:34:18 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 7:34:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 9/5/2021 7:34:18 AM
9/5/2021 7:34:18 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 7:34:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3893818_TEMPLATE1.txt ### 9/5/2021 7:34:18 AM
9/5/2021 7:34:18 AM : Count:: ### TEMPLATE1:120
9/5/2021 7:34:25 AM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 7:34:25 AM
9/5/2021 7:34:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3937444_TEMPLATE1.txt ### 9/5/2021 7:34:25 AM
9/5/2021 7:34:25 AM : Count:: ### TEMPLATE1:398
9/5/2021 7:34:48 AM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 7:34:48 AM
9/5/2021 7:34:48 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3993798_TEMPLATE1.TXT ### 9/5/2021 7:34:48 AM
9/5/2021 7:34:48 AM : Count:: ### TEMPLATE1:6
9/5/2021 7:34:49 AM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 7:34:49 AM
9/5/2021 7:34:49 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 9/5/2021 7:34:49 AM
9/5/2021 7:34:49 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 7:34:49 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4068242_TEMPLATE1.TXT ### 9/5/2021 7:34:49 AM
9/5/2021 7:34:49 AM : Count:: ### TEMPLATE1:15
9/5/2021 7:34:50 AM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 7:34:50 AM
9/5/2021 7:34:50 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 9/5/2021 7:34:50 AM
9/5/2021 7:34:50 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 7:34:50 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 9/5/2021 7:34:50 AM
9/5/2021 7:34:50 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 7:34:50 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060273_TEMPLATE1.TXT ### 9/5/2021 7:34:50 AM
9/5/2021 7:34:50 AM : Count:: ### TEMPLATE1:2
9/5/2021 7:34:50 AM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 7:34:50 AM
9/5/2021 7:34:50 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060653_TEMPLATE1.txt ### 9/5/2021 7:34:50 AM
9/5/2021 7:34:50 AM : Count:: ### TEMPLATE1:51
9/5/2021 7:34:57 AM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 7:34:57 AM
9/5/2021 7:34:57 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060893_TEMPLATE1.txt ### 9/5/2021 7:34:57 AM
9/5/2021 7:34:57 AM : Count:: ### TEMPLATE1:306
9/5/2021 7:35:35 AM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 7:35:35 AM
9/5/2021 7:35:35 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 9/5/2021 7:35:35 AM
9/5/2021 7:35:35 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 7:35:35 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061058_TEMPLATE1.txt ### 9/5/2021 7:35:35 AM
9/5/2021 7:35:35 AM : Count:: ### TEMPLATE1:57
9/5/2021 7:35:37 AM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 7:35:37 AM
9/5/2021 7:35:37 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061385_TEMPLATE1.TXT ### 9/5/2021 7:35:37 AM
9/5/2021 7:35:37 AM : Count:: ### TEMPLATE1:310
9/5/2021 7:36:18 AM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 7:36:18 AM
9/5/2021 7:36:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 9/5/2021 7:36:18 AM
9/5/2021 7:36:18 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 7:36:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 9/5/2021 7:36:18 AM
9/5/2021 7:36:18 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 7:36:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061625_TEMPLATE1.txt ### 9/5/2021 7:36:18 AM
9/5/2021 7:36:18 AM : Count:: ### TEMPLATE1:158
9/5/2021 7:36:27 AM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 7:36:27 AM
9/5/2021 7:36:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062686_TEMPLATE1.TXT ### 9/5/2021 7:36:27 AM
9/5/2021 7:36:27 AM : Count:: ### TEMPLATE1:30
9/5/2021 7:36:31 AM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 7:36:31 AM
9/5/2021 7:36:31 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 9/5/2021 7:36:31 AM
9/5/2021 7:36:31 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 7:36:31 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063093_TEMPLATE1.txt ### 9/5/2021 7:36:31 AM
9/5/2021 7:36:31 AM : Count:: ### TEMPLATE1:126
9/5/2021 7:36:52 AM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 7:36:52 AM
9/5/2021 7:36:52 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 9/5/2021 7:36:52 AM
9/5/2021 7:36:52 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 7:36:52 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9068225_TEMPLATE1.txt ### 9/5/2021 7:36:52 AM
9/5/2021 7:36:52 AM : Count:: ### TEMPLATE1:303
9/5/2021 7:36:58 AM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 7:36:58 AM
9/5/2021 7:36:58 AM : Template Import Complete  ### 9/5/2021 7:36:58 AM
9/5/2021 7:37:00 AM : Completed Updating Has Transaction Flag  ### 9/5/2021 7:37:00 AM
9/5/2021 7:37:00 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 9/5/2021 7:37:00 AM
9/5/2021 7:37:00 AM : Zylem Access Unblocked  ### 9/5/2021 7:37:00 AM
9/5/2021 7:37:01 AM : Application Ended  ### 9/5/2021 7:37:01 AM

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

9/5/2021 2:30:03 PM : 11  ### 9/5/2021 2:30:03 PM

9/5/2021 2:30:03 PM : 22  ### 9/5/2021 2:30:03 PM

9/5/2021 2:30:03 PM : 33  ### 9/5/2021 2:30:03 PM

9/5/2021 2:30:03 PM : Application Started  ### 9/5/2021 2:30:03 PM

9/5/2021 2:30:03 PM : Start Process : checkAllTablesExists()  ### 
9/5/2021 2:30:03 PM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 9/5/2021 2:30:03 PM
9/5/2021 2:30:03 PM : MainForm_Load  ### AlertSystem ON
9/5/2021 2:30:04 PM : No. of Files to import (RECEIVEFINAL):  ### 1153
9/5/2021 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
9/5/2021 2:30:04 PM : For Distributor 000000000001119 Insert Count::0 ### Delete Count::1
9/5/2021 2:30:04 PM : Import AD File --->> AD_1119_20210905_f8534735a3abb530f8b09a41bf6361b3.TXT ### 9/5/2021 2:30:04 PM
9/5/2021 2:30:04 PM : For Distributor 000000000000447 Insert Count::2 ### Delete Count::0
9/5/2021 2:30:04 PM : Import AD File --->> AD_447_20210905_3ddb63fe5ba5a035739eb017f6f8314e.TXT ### 9/5/2021 2:30:04 PM
9/5/2021 2:30:04 PM : For Distributor 000000000000892 Insert Count::24 ### Delete Count::37
9/5/2021 2:30:04 PM : Import AD File --->> AD_892_20210905_97bc5854aecc2c7b00237c6223d4d738.TXT ### 9/5/2021 2:30:04 PM
9/5/2021 2:30:09 PM : For Distributor 000000000001119 Insert Count::1 ### Delete Count::0
9/5/2021 2:30:09 PM : Import DN File --->> DN_1119_20210828_a9064793e0ce68b128f0913cac286fb6.TXT ### 9/5/2021 2:30:09 PM
9/5/2021 2:30:10 PM : For Distributor 000000000001119 Insert Count::4 ### Delete Count::0
9/5/2021 2:30:10 PM : Import DN File --->> DN_1119_20210903_fc286c102a3949336fc6ce5ded8f9ffc.TXT ### 9/5/2021 2:30:10 PM
9/5/2021 2:30:22 PM : For Distributor 000000000000892 Insert Count::0 ### Delete Count::4
9/5/2021 2:30:22 PM : Import DN File --->> DN_892_20210806_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 2:30:22 PM
9/5/2021 2:30:22 PM : For Distributor 000000000000892 Insert Count::0 ### Delete Count::3
9/5/2021 2:30:22 PM : Import DN File --->> DN_892_20210810_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 2:30:22 PM
9/5/2021 2:30:22 PM : For Distributor 000000000000892 Insert Count::4 ### Delete Count::0
9/5/2021 2:30:22 PM : Import DN File --->> DN_892_20210811_a99e4dcf7ebfb02e1b1dc330631dd977.TXT ### 9/5/2021 2:30:22 PM
9/5/2021 2:30:23 PM : For Distributor 000000000000892 Insert Count::0 ### Delete Count::9
9/5/2021 2:30:23 PM : Import DN File --->> DN_892_20210821_d41d8cd98f00b204e9800998ecf8427e.TXT ### 9/5/2021 2:30:23 PM
9/5/2021 2:30:23 PM : For Distributor 000000000000892 Insert Count::2 ### Delete Count::0
9/5/2021 2:30:23 PM : Import DN File --->> DN_892_20210823_3942c2c360371097fe02533fb12e918d.TXT ### 9/5/2021 2:30:23 PM
9/5/2021 2:30:23 PM : For Distributor 000000000001038 Insert Count::2 ### Delete Count::1
9/5/2021 2:30:23 PM : Import IN File --->> IN_1038_20210801_e7f91b1b379558b261692a0d08ed239e.TXT ### 9/5/2021 2:30:23 PM
9/5/2021 2:30:24 PM : For Distributor 000000000001038 Insert Count::16 ### Delete Count::7
9/5/2021 2:30:24 PM : Import IN File --->> IN_1038_20210802_747b20c420aeff52e8e0ae925f85fc8e.TXT ### 9/5/2021 2:30:24 PM
9/5/2021 2:30:24 PM : For Distributor 000000000001038 Insert Count::1 ### Delete Count::1
9/5/2021 2:30:24 PM : Import IN File --->> IN_1038_20210803_7c3f3dfc7b36e726ab1ad0d0029d470e.TXT ### 9/5/2021 2:30:24 PM
9/5/2021 2:30:24 PM : For Distributor 000000000001038 Insert Count::14 ### Delete Count::3
9/5/2021 2:30:24 PM : Import IN File --->> IN_1038_20210804_44f9fe32bd47e0721aff128953afcb85.TXT ### 9/5/2021 2:30:24 PM
9/5/2021 2:30:24 PM : For Distributor 000000000001038 Insert Count::10 ### Delete Count::10
9/5/2021 2:30:24 PM : Import IN File --->> IN_1038_20210805_d694cf699f20c80e4fd251f982b09d8c.TXT ### 9/5/2021 2:30:24 PM
9/5/2021 2:30:24 PM : For Distributor 000000000001038 Insert Count::14 ### Delete Count::4
9/5/2021 2:30:24 PM : Import IN File --->> IN_1038_20210806_fbd3ad76f1968a9efbd362a1a7ca2e2f.TXT ### 9/5/2021 2:30:24 PM
9/5/2021 2:30:24 PM : For Distributor 000000000001038 Insert Count::8 ### Delete Count::8
9/5/2021 2:30:24 PM : Import IN File --->> IN_1038_20210807_8b98c5ccf8be29b90c2b597cb3659cfe.TXT ### 9/5/2021 2:30:24 PM
9/5/2021 2:30:24 PM : For Distributor 000000000001038 Insert Count::9 ### Delete Count::3
9/5/2021 2:30:24 PM : Import IN File --->> IN_1038_20210808_8e69bba16f17ca6dc2216d177fad25fa.TXT ### 9/5/2021 2:30:24 PM
9/5/2021 2:30:24 PM : For Distributor 000000000001038 Insert Count::10 ### Delete Count::10
9/5/2021 2:30:24 PM : Import IN File --->> IN_1038_20210810_72f3e28516ad3a9515ece05d343d0316.TXT ### 9/5/2021 2:30:24 PM
9/5/2021 2:30:32 PM : For Distributor 000000000001119 Insert Count::1 ### Delete Count::1
9/5/2021 2:30:32 PM : Import IN File --->> IN_1119_20210903_a8932c55b13126c866fd82496065cd15.TXT ### 9/5/2021 2:30:32 PM
9/5/2021 2:30:32 PM : For Distributor 000000000001119 Insert Count::31 ### Delete Count::0
9/5/2021 2:30:32 PM : Import IN File --->> IN_1119_20210904_b0f70e9fb51a6da559d338474e9de7cc.TXT ### 9/5/2021 2:30:32 PM
9/5/2021 2:30:32 PM : Import IN File --->> IN_1119_20210905_9162577ab87f5304eeabf94c942ec128.TXT ### 9/5/2021 2:30:32 PM
9/5/2021 2:30:32 PM : NO Previous File For Distributor 000000000001119 ### Insert Count::22
9/5/2021 2:30:37 PM : For Distributor 000000000001178 Insert Count::1 ### Delete Count::0
9/5/2021 2:30:37 PM : Import IN File --->> IN_1178_20210902_61f8e5e2bbf9e684dcfc0e4f52352973.TXT ### 9/5/2021 2:30:37 PM
9/5/2021 2:30:37 PM : For Distributor 000000000001178 Insert Count::1 ### Delete Count::1
9/5/2021 2:30:37 PM : Import IN File --->> IN_1178_20210903_8cb9be8a9aa46b82c0dee3ec6b7e565e.TXT ### 9/5/2021 2:30:37 PM
9/5/2021 2:30:44 PM : Import IN File --->> IN_447_20210903_cfd414d3f85ddd645ee8e91dc42d1f6d.TXT ### 9/5/2021 2:30:44 PM
9/5/2021 2:30:44 PM : NO Previous File For Distributor 000000000000447 ### Insert Count::2
9/5/2021 2:30:44 PM : Import IN File --->> IN_447_20210904_7564957408eedbd4fe6a32ee33801de2.TXT ### 9/5/2021 2:30:44 PM
9/5/2021 2:30:44 PM : NO Previous File For Distributor 000000000000447 ### Insert Count::1
9/5/2021 2:30:44 PM : Import IN File --->> IN_892_20210803_51beca920d30aeb79b0d0fc0c2ab6492.TXT ### 9/5/2021 2:30:44 PM
9/5/2021 2:30:44 PM : NO Previous File For Distributor 000000000000892 ### Insert Count::1
9/5/2021 2:30:44 PM : Import IN File --->> IN_892_20210809_8f10b7410d071418429da67e1ccfb1bf.TXT ### 9/5/2021 2:30:44 PM
9/5/2021 2:30:44 PM : NO Previous File For Distributor 000000000000892 ### Insert Count::1
9/5/2021 2:30:44 PM : Import IN File --->> IN_892_20210810_f52c95a28e6b4f7e3fab0a769cb6937e.TXT ### 9/5/2021 2:30:44 PM
9/5/2021 2:30:44 PM : NO Previous File For Distributor 000000000000892 ### Insert Count::2
9/5/2021 2:30:45 PM : Import IN File --->> IN_892_20210812_366a6927b9141cd9347927c40c313310.TXT ### 9/5/2021 2:30:45 PM
9/5/2021 2:30:45 PM : NO Previous File For Distributor 000000000000892 ### Insert Count::2
9/5/2021 2:30:45 PM : Import IN File --->> IN_892_20210813_691d7743c5bd616a2eaa96659698fa62.TXT ### 9/5/2021 2:30:45 PM
9/5/2021 2:30:45 PM : NO Previous File For Distributor 000000000000892 ### Insert Count::1
9/5/2021 2:30:45 PM : Import IN File --->> IN_892_20210816_34cf95d0a5a640b36e187393224cdf0a.TXT ### 9/5/2021 2:30:45 PM
9/5/2021 2:30:45 PM : NO Previous File For Distributor 000000000000892 ### Insert Count::3
9/5/2021 2:30:45 PM : Import IN File --->> IN_892_20210817_35f6031280a3bcb5419c3c6da8b30f08.TXT ### 9/5/2021 2:30:45 PM
9/5/2021 2:30:45 PM : NO Previous File For Distributor 000000000000892 ### Insert Count::2
9/5/2021 2:30:45 PM : Import IN File --->> IN_892_20210818_99db049759b9673f608f83f691449edf.TXT ### 9/5/2021 2:30:45 PM
9/5/2021 2:30:45 PM : NO Previous File For Distributor 000000000000892 ### Insert Count::2
9/5/2021 2:30:45 PM : Import IN File --->> IN_892_20210820_dcca8f8feedc4869e7184d38a95bba1a.TXT ### 9/5/2021 2:30:45 PM
9/5/2021 2:30:45 PM : NO Previous File For Distributor 000000000000892 ### Insert Count::4
9/5/2021 2:30:45 PM : Import IN File --->> IN_892_20210821_9482f6decfdf2ba194aeafb794f24cf7.TXT ### 9/5/2021 2:30:45 PM
9/5/2021 2:30:45 PM : NO Previous File For Distributor 000000000000892 ### Insert Count::1
9/5/2021 2:30:45 PM : Import IN File --->> IN_892_20210823_1e5c8cd34e08104cff7389e45884684f.TXT ### 9/5/2021 2:30:45 PM
9/5/2021 2:30:45 PM : NO Previous File For Distributor 000000000000892 ### Insert Count::3
9/5/2021 2:30:45 PM : Import IN File --->> IN_892_20210824_21fcf7087d499c19faa9de10a50d8576.TXT ### 9/5/2021 2:30:45 PM
9/5/2021 2:30:45 PM : NO Previous File For Distributor 000000000000892 ### Insert Count::2
9/5/2021 2:30:45 PM : Import IN File --->> IN_892_20210826_6530763b148a2b882e1bd28b2f5a8dd5.TXT ### 9/5/2021 2:30:45 PM
9/5/2021 2:30:45 PM : NO Previous File For Distributor 000000000000892 ### Insert Count::1
9/5/2021 2:30:45 PM : Import IN File --->> IN_892_20210827_d646d9f343521ab59349a3ba8c09e9e4.TXT ### 9/5/2021 2:30:45 PM
9/5/2021 2:30:45 PM : NO Previous File For Distributor 000000000000892 ### Insert Count::1
9/5/2021 2:30:45 PM : Import IN File --->> IN_892_20210828_c9b27c9566e48bbb512742ec9094954b.TXT ### 9/5/2021 2:30:45 PM
9/5/2021 2:30:45 PM : NO Previous File For Distributor 000000000000892 ### Insert Count::3
9/5/2021 2:30:45 PM : Import IN File --->> IN_892_20210830_4b984adb16ab17b85deee3fce27b9034.TXT ### 9/5/2021 2:30:45 PM
9/5/2021 2:30:45 PM : NO Previous File For Distributor 000000000000892 ### Insert Count::1
9/5/2021 2:30:45 PM : Import IN File --->> IN_892_20210831_e53f7bba645cbf951b161f6bdd4faec7.TXT ### 9/5/2021 2:30:45 PM
9/5/2021 2:30:45 PM : NO Previous File For Distributor 000000000000892 ### Insert Count::8
9/5/2021 2:30:46 PM : For Distributor 000000000000892 Insert Count::12 ### Delete Count::18
9/5/2021 2:30:46 PM : Import PR File --->> PR_892_20210905_b63218530d249ffd7ae8d9b1a96fbb18.TXT ### 9/5/2021 2:30:46 PM
9/5/2021 2:30:46 PM : PostData() --->>  ### 9/5/2021 2:30:46 PM
9/5/2021 2:30:51 PM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 9/5/2021 2:30:51 PM
9/5/2021 2:30:52 PM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '05/Sep/2021' ### 9/5/2021 2:30:52 PM
9/5/2021 2:30:53 PM : ItemLink Successful --->> exec SP_ItemLinkDiff '05/Sep/2021' ### 9/5/2021 2:30:53 PM
9/5/2021 2:30:53 PM :  ### 
9/5/2021 2:30:53 PM : UNLINKEDSALES Record Count Before --->> 181 ### 9/5/2021 2:30:53 PM
9/5/2021 2:30:53 PM : UNLINKEDSALES_DEL Record Count Before --->> 49 ### 9/5/2021 2:30:53 PM
9/5/2021 2:31:03 PM : Posting Sales Successful --->> exec prPostLinkedDiffSales '05/Sep/2021' ### 9/5/2021 2:31:03 PM
9/5/2021 2:31:03 PM : UNLINKEDSALES Record Count After --->> 0 ### 9/5/2021 2:31:03 PM
9/5/2021 2:31:03 PM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 9/5/2021 2:31:03 PM
9/5/2021 2:31:03 PM :  ### 
9/5/2021 2:31:03 PM : Posting Supplierlink Query for Purchases --->>  ### 9/5/2021 2:31:03 PM
9/5/2021 2:31:10 PM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '05/Sep/2021' ### 9/5/2021 2:31:10 PM
9/5/2021 2:31:16 PM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '05/Sep/2021' ### 9/5/2021 2:31:16 PM
9/5/2021 2:31:16 PM : Posting Supplierlink Query for CompanyPurchases --->>  ### 9/5/2021 2:31:16 PM
9/5/2021 2:31:16 PM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '05/Sep/2021' ### 9/5/2021 2:31:16 PM
9/5/2021 2:31:16 PM : Posting ClosingStock Successful --->>  ### 9/5/2021 2:31:16 PM
9/5/2021 2:31:17 PM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 9/5/2021 2:31:17 PM
9/5/2021 2:31:17 PM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
9/5/2021 2:31:17 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 9/5/2021 2:31:17 PM
9/5/2021 2:31:17 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:31:17 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2043239_TEMPLATE1.txt ### 9/5/2021 2:31:17 PM
9/5/2021 2:31:17 PM : Count:: ### TEMPLATE1:129
9/5/2021 2:31:33 PM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 2:31:33 PM
9/5/2021 2:31:33 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 9/5/2021 2:31:33 PM
9/5/2021 2:31:33 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:31:33 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 9/5/2021 2:31:33 PM
9/5/2021 2:31:33 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:31:33 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 9/5/2021 2:31:33 PM
9/5/2021 2:31:33 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:31:33 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3559252_TEMPLATE1.TXT ### 9/5/2021 2:31:33 PM
9/5/2021 2:31:33 PM : Count:: ### TEMPLATE1:24
9/5/2021 2:31:35 PM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 2:31:35 PM
9/5/2021 2:31:35 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3601731_TEMPLATE1.txt ### 9/5/2021 2:31:35 PM
9/5/2021 2:31:35 PM : Count:: ### TEMPLATE1:608
9/5/2021 2:32:09 PM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 2:32:09 PM
9/5/2021 2:32:09 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 9/5/2021 2:32:09 PM
9/5/2021 2:32:09 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:32:09 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 9/5/2021 2:32:09 PM
9/5/2021 2:32:09 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:32:09 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3643365_TEMPLATE1.TXT ### 9/5/2021 2:32:09 PM
9/5/2021 2:32:09 PM : Count:: ### TEMPLATE1:21
9/5/2021 2:32:10 PM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 2:32:10 PM
9/5/2021 2:32:10 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3643369_TEMPLATE1.TXT ### 9/5/2021 2:32:10 PM
9/5/2021 2:32:10 PM : Count:: ### TEMPLATE1:178
9/5/2021 2:32:41 PM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 2:32:41 PM
9/5/2021 2:32:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3800230_TEMPLATE1.txt ### 9/5/2021 2:32:41 PM
9/5/2021 2:32:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:32:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 9/5/2021 2:32:41 PM
9/5/2021 2:32:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:32:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 9/5/2021 2:32:41 PM
9/5/2021 2:32:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:32:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 9/5/2021 2:32:41 PM
9/5/2021 2:32:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:32:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 9/5/2021 2:32:41 PM
9/5/2021 2:32:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:32:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4529171_TEMPLATE1.txt ### 9/5/2021 2:32:41 PM
9/5/2021 2:32:41 PM : Count:: ### TEMPLATE1:103
9/5/2021 2:32:47 PM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 2:32:47 PM
9/5/2021 2:32:47 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 9/5/2021 2:32:47 PM
9/5/2021 2:32:47 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:32:47 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060273_TEMPLATE1.TXT ### 9/5/2021 2:32:47 PM
9/5/2021 2:32:47 PM : Count:: ### TEMPLATE1:2
9/5/2021 2:32:48 PM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 2:32:48 PM
9/5/2021 2:32:48 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060886_TEMPLATE1.TXT ### 9/5/2021 2:32:48 PM
9/5/2021 2:32:48 PM : Count:: ### TEMPLATE1:4
9/5/2021 2:32:48 PM : SP_DistributorTemplatePosting Successful --->>  ### 9/5/2021 2:32:48 PM
9/5/2021 2:32:48 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 9/5/2021 2:32:48 PM
9/5/2021 2:32:48 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:32:48 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 9/5/2021 2:32:48 PM
9/5/2021 2:32:48 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:32:48 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 9/5/2021 2:32:48 PM
9/5/2021 2:32:48 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:32:48 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 9/5/2021 2:32:48 PM
9/5/2021 2:32:48 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:32:48 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 9/5/2021 2:32:48 PM
9/5/2021 2:32:48 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
9/5/2021 2:32:48 PM : Template Import Complete  ### 9/5/2021 2:32:48 PM
9/5/2021 2:32:51 PM : Completed Updating Has Transaction Flag  ### 9/5/2021 2:32:51 PM
9/5/2021 2:32:51 PM : Transaction Table lastEdiDate Update on BrandAlias Update ### 9/5/2021 2:32:51 PM
9/5/2021 2:32:51 PM : Zylem Access Unblocked  ### 9/5/2021 2:32:51 PM
9/5/2021 2:32:51 PM : Application Ended  ### 9/5/2021 2:32:51 PM