4/13/2022 2:30:03 AM : Start Process : checkAllTablesExists()  ### Driver={SQL Server};Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
4/13/2022 2:30:04 AM : StartProcess  ### 4/13/2022 2:30:04 AM

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

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

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

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

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

4/13/2022 7:30:02 AM : Start Process : checkAllTablesExists()  ### Driver={SQL Server};Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
4/13/2022 7:30:02 AM : StartProcess  ### 4/13/2022 7:30:02 AM

4/13/2022 7:30:02 AM : 11  ### 4/13/2022 7:30:02 AM

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

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

4/13/2022 7:30:03 AM : Application Started  ### 4/13/2022 7:30:03 AM

4/13/2022 7:30:03 AM : Start Process : checkAllTablesExists()  ### 
4/13/2022 7:30:03 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 4/13/2022 7:30:03 AM
4/13/2022 7:30:03 AM : MainForm_Load  ### AlertSystem ON
4/13/2022 7:30:03 AM : No. of Files to import (RECEIVEFINAL):  ### 994
4/13/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
4/13/2022 7:30:04 AM : For Distributor 000000000001025 Insert Count::2 ### Delete Count::0
4/13/2022 7:30:04 AM : Import AD File --->> AD_1025_20220413_b89b98125a10f531386f89d248285736.TXT ### 4/13/2022 7:30:04 AM
4/13/2022 7:30:04 AM : For Distributor 000000000001316 Insert Count::4 ### Delete Count::0
4/13/2022 7:30:04 AM : Import AD File --->> AD_1316_20220413_37b487616a1b687154cd518cd7489552.TXT ### 4/13/2022 7:30:04 AM
4/13/2022 7:30:04 AM : For Distributor 000000000000665 Insert Count::1 ### Delete Count::1
4/13/2022 7:30:04 AM : Import AD File --->> AD_665_20220413_97c8a7f0719f0b57f468498a0b357579.TXT ### 4/13/2022 7:30:04 AM
4/13/2022 7:30:04 AM : For Distributor 000000000000809 Insert Count::9 ### Delete Count::4
4/13/2022 7:30:04 AM : Import AD File --->> AD_809_20220413_2f4602cf1e82aada98d5957fe182d098.TXT ### 4/13/2022 7:30:04 AM
4/13/2022 7:30:05 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::3
4/13/2022 7:30:05 AM : Import AD File --->> AD_810_20220413_ec28f489c551078161f02dce3d387ef7.TXT ### 4/13/2022 7:30:05 AM
4/13/2022 7:30:05 AM : For Distributor 000000000000820 Insert Count::1 ### Delete Count::0
4/13/2022 7:30:05 AM : Import AD File --->> AD_820_20220413_d2795e403cf07cc7d15e8adc447b51b2.TXT ### 4/13/2022 7:30:05 AM
4/13/2022 7:30:21 AM : For Distributor 000000000000665 Insert Count::8 ### Delete Count::0
4/13/2022 7:30:21 AM : Import DN File --->> DN_665_20220401_5204d470b0bd5b74b41c8441eb69a251.TXT ### 4/13/2022 7:30:21 AM
4/13/2022 7:30:21 AM : For Distributor 000000000000665 Insert Count::0 ### Delete Count::8
4/13/2022 7:30:21 AM : Import DN File --->> DN_665_20220404_56b170c16fa04de659d0d411b3fa538e.TXT ### 4/13/2022 7:30:21 AM
4/13/2022 7:30:22 AM : For Distributor 000000000000665 Insert Count::11 ### Delete Count::0
4/13/2022 7:30:22 AM : Import DN File --->> DN_665_20220408_b6def817c73ea00285500f1d548970c6.TXT ### 4/13/2022 7:30:22 AM
4/13/2022 7:30:26 AM : For Distributor 000000000000810 Insert Count::12 ### Delete Count::12
4/13/2022 7:30:26 AM : Import DN File --->> DN_810_20220308_2d0d86f1dbe364b825cf6f1472302a9f.TXT ### 4/13/2022 7:30:26 AM
4/13/2022 7:30:26 AM : For Distributor 000000000000810 Insert Count::3 ### Delete Count::3
4/13/2022 7:30:26 AM : Import DN File --->> DN_810_20220310_4b4a09af5b67170c1e1deffdce2d0dc1.TXT ### 4/13/2022 7:30:26 AM
4/13/2022 7:30:26 AM : For Distributor 000000000000810 Insert Count::5 ### Delete Count::5
4/13/2022 7:30:26 AM : Import DN File --->> DN_810_20220311_221211e56b7c8b2a627d0009d1ecfe8a.TXT ### 4/13/2022 7:30:26 AM
4/13/2022 7:30:27 AM : For Distributor 000000000000810 Insert Count::1 ### Delete Count::1
4/13/2022 7:30:27 AM : Import DN File --->> DN_810_20220314_09d8e2a660aadbb1c790bf077162e500.TXT ### 4/13/2022 7:30:27 AM
4/13/2022 7:30:27 AM : For Distributor 000000000000810 Insert Count::4 ### Delete Count::4
4/13/2022 7:30:27 AM : Import DN File --->> DN_810_20220315_f384b93c4419d4e8989ad2b0b033cd76.TXT ### 4/13/2022 7:30:27 AM
4/13/2022 7:30:27 AM : For Distributor 000000000000810 Insert Count::1 ### Delete Count::1
4/13/2022 7:30:27 AM : Import DN File --->> DN_810_20220319_ac06dbeccf366efc887cd35451745413.TXT ### 4/13/2022 7:30:27 AM
4/13/2022 7:30:28 AM : For Distributor 000000000000810 Insert Count::5 ### Delete Count::5
4/13/2022 7:30:28 AM : Import DN File --->> DN_810_20220321_f3db6a7e4169041da2dfa4fa30491ffa.TXT ### 4/13/2022 7:30:28 AM
4/13/2022 7:30:28 AM : For Distributor 000000000000810 Insert Count::3 ### Delete Count::3
4/13/2022 7:30:28 AM : Import DN File --->> DN_810_20220322_602a5902fd9558aa25c11b4a4ffdc7e2.TXT ### 4/13/2022 7:30:28 AM
4/13/2022 7:30:28 AM : For Distributor 000000000000810 Insert Count::3 ### Delete Count::3
4/13/2022 7:30:28 AM : Import DN File --->> DN_810_20220324_678aaa90fb941ac5a2cb31ab947476d7.TXT ### 4/13/2022 7:30:28 AM
4/13/2022 7:30:29 AM : For Distributor 000000000000810 Insert Count::1 ### Delete Count::1
4/13/2022 7:30:29 AM : Import DN File --->> DN_810_20220325_3dd388cf0464ad6620dcd4542ccc9998.TXT ### 4/13/2022 7:30:29 AM
4/13/2022 7:30:29 AM : For Distributor 000000000000810 Insert Count::2 ### Delete Count::2
4/13/2022 7:30:29 AM : Import DN File --->> DN_810_20220326_5c0e14f2b9b3ca56e94064a169f9ef1f.TXT ### 4/13/2022 7:30:29 AM
4/13/2022 7:30:29 AM : For Distributor 000000000000810 Insert Count::10 ### Delete Count::10
4/13/2022 7:30:29 AM : Import DN File --->> DN_810_20220328_97671268cbd5f966aeece62822df966b.TXT ### 4/13/2022 7:30:29 AM
4/13/2022 7:30:30 AM : For Distributor 000000000000810 Insert Count::2 ### Delete Count::2
4/13/2022 7:30:30 AM : Import DN File --->> DN_810_20220329_0efba1eb636dd049561de1d3bb022ab4.TXT ### 4/13/2022 7:30:30 AM
4/13/2022 7:30:30 AM : For Distributor 000000000000810 Insert Count::1 ### Delete Count::1
4/13/2022 7:30:30 AM : Import DN File --->> DN_810_20220330_9571f448c15fd150e2eccbb0f8e3f386.TXT ### 4/13/2022 7:30:30 AM
4/13/2022 7:30:50 AM : Import IN File --->> IN_1025_20220409_97575d475b3a98446963cea630d21510.TXT ### 4/13/2022 7:30:50 AM
4/13/2022 7:30:50 AM : NO Previous File For Distributor 000000000001025 ### Insert Count::1
4/13/2022 7:30:50 AM : Import IN File --->> IN_1025_20220411_0cc9f6febfa902e69f7c9f1c276129a6.TXT ### 4/13/2022 7:30:50 AM
4/13/2022 7:30:50 AM : NO Previous File For Distributor 000000000001025 ### Insert Count::2
4/13/2022 7:30:57 AM : For Distributor 000000000001316 Insert Count::4 ### Delete Count::0
4/13/2022 7:30:57 AM : Import IN File --->> IN_1316_20220412_601535a6525615117a384ee0ca103eb3.TXT ### 4/13/2022 7:30:57 AM
4/13/2022 7:31:07 AM : For Distributor 000000000000665 Insert Count::19 ### Delete Count::0
4/13/2022 7:31:07 AM : Import IN File --->> IN_665_20220409_ac8a22b6a4e01e1e13f3a2a872c129c5.TXT ### 4/13/2022 7:31:07 AM
4/13/2022 7:31:10 AM : For Distributor 000000000000809 Insert Count::19 ### Delete Count::0
4/13/2022 7:31:10 AM : Import IN File --->> IN_809_20220412_28d27224b83d02e7537db7997cb6f521.TXT ### 4/13/2022 7:31:10 AM
4/13/2022 7:31:10 AM : Import IN File --->> IN_809_20220413_01a6e9cdbe0d132d60ac7f219c020aca.TXT ### 4/13/2022 7:31:10 AM
4/13/2022 7:31:10 AM : NO Previous File For Distributor 000000000000809 ### Insert Count::3
4/13/2022 7:31:12 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::14
4/13/2022 7:31:12 AM : Import IN File --->> IN_810_20220411_d41d8cd98f00b204e9800998ecf8427e.TXT ### 4/13/2022 7:31:12 AM
4/13/2022 7:31:15 AM : Import IN File --->> IN_820_20220413_28f6e494d0a691b2bfa57f858ea975fc.TXT ### 4/13/2022 7:31:15 AM
4/13/2022 7:31:15 AM : NO Previous File For Distributor 000000000000820 ### Insert Count::1
4/13/2022 7:31:19 AM : For Distributor 000000000000665 Insert Count::0 ### Delete Count::1
4/13/2022 7:31:19 AM : Import PR File --->> PR_665_20220413_786a007511ff762d7d1c0de81c84fb2c.TXT ### 4/13/2022 7:31:19 AM
4/13/2022 7:31:19 AM : PostData() --->>  ### 4/13/2022 7:31:19 AM
4/13/2022 7:31:20 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 4/13/2022 7:31:20 AM
4/13/2022 7:31:23 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '13/Apr/2022' ### 4/13/2022 7:31:23 AM
4/13/2022 7:31:23 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '13/Apr/2022' ### 4/13/2022 7:31:23 AM
4/13/2022 7:31:23 AM :  ### 
4/13/2022 7:31:23 AM : UNLINKEDSALES Record Count Before --->> 49 ### 4/13/2022 7:31:23 AM
4/13/2022 7:31:24 AM : UNLINKEDSALES_DEL Record Count Before --->> 14 ### 4/13/2022 7:31:24 AM
4/13/2022 7:31:32 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '13/Apr/2022' ### 4/13/2022 7:31:32 AM
4/13/2022 7:31:32 AM : UNLINKEDSALES Record Count After --->> 0 ### 4/13/2022 7:31:32 AM
4/13/2022 7:31:32 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 4/13/2022 7:31:32 AM
4/13/2022 7:31:32 AM :  ### 
4/13/2022 7:31:32 AM : Posting Supplierlink Query for Purchases --->>  ### 4/13/2022 7:31:32 AM
4/13/2022 7:31:40 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '13/Apr/2022' ### 4/13/2022 7:31:40 AM
4/13/2022 7:31:45 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '13/Apr/2022' ### 4/13/2022 7:31:45 AM
4/13/2022 7:31:45 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 4/13/2022 7:31:45 AM
4/13/2022 7:31:45 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '13/Apr/2022' ### 4/13/2022 7:31:45 AM
4/13/2022 7:31:46 AM : Posting ClosingStock Successful --->>  ### 4/13/2022 7:31:46 AM
4/13/2022 7:31:46 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 4/13/2022 7:31:46 AM
4/13/2022 7:31:46 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
4/13/2022 7:31:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 4/13/2022 7:31:46 AM
4/13/2022 7:31:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 7:31:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 4/13/2022 7:31:46 AM
4/13/2022 7:31:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 7:31:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 4/13/2022 7:31:46 AM
4/13/2022 7:31:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 7:31:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 4/13/2022 7:31:46 AM
4/13/2022 7:31:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 7:31:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 4/13/2022 7:31:46 AM
4/13/2022 7:31:46 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 7:31:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2848065_TEMPLATE1.TXT ### 4/13/2022 7:31:46 AM
4/13/2022 7:31:46 AM : Count:: ### TEMPLATE1:60
4/13/2022 7:31:50 AM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 7:31:50 AM
4/13/2022 7:31:50 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3224985_TEMPLATE1.TXT ### 4/13/2022 7:31:50 AM
4/13/2022 7:31:50 AM : Count:: ### TEMPLATE1:115
4/13/2022 7:32:06 AM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 7:32:06 AM
4/13/2022 7:32:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 4/13/2022 7:32:06 AM
4/13/2022 7:32:06 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 7:32:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 4/13/2022 7:32:06 AM
4/13/2022 7:32:06 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 7:32:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 4/13/2022 7:32:06 AM
4/13/2022 7:32:06 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 7:32:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 4/13/2022 7:32:06 AM
4/13/2022 7:32:06 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 7:32:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3985879_TEMPLATE1.txt ### 4/13/2022 7:32:06 AM
4/13/2022 7:32:06 AM : Count:: ### TEMPLATE1:94
4/13/2022 7:32:25 AM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 7:32:25 AM
4/13/2022 7:32:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 4/13/2022 7:32:25 AM
4/13/2022 7:32:25 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 7:32:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 4/13/2022 7:32:25 AM
4/13/2022 7:32:25 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 7:32:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 4/13/2022 7:32:25 AM
4/13/2022 7:32:25 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 7:32:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_722734_TEMPLATE1.TXT ### 4/13/2022 7:32:25 AM
4/13/2022 7:32:25 AM : Count:: ### TEMPLATE1:10
4/13/2022 7:32:26 AM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 7:32:26 AM
4/13/2022 7:32:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060893_TEMPLATE1.txt ### 4/13/2022 7:32:26 AM
4/13/2022 7:32:26 AM : Count:: ### TEMPLATE1:502
4/13/2022 7:33:00 AM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 7:33:00 AM
4/13/2022 7:33:00 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 4/13/2022 7:33:00 AM
4/13/2022 7:33:00 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 7:33:00 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 4/13/2022 7:33:00 AM
4/13/2022 7:33:00 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 7:33:00 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 4/13/2022 7:33:00 AM
4/13/2022 7:33:00 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 7:33:00 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062891_TEMPLATE1.TXT ### 4/13/2022 7:33:00 AM
4/13/2022 7:33:00 AM : Count:: ### TEMPLATE1:116
4/13/2022 7:33:08 AM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 7:33:08 AM
4/13/2022 7:33:08 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 4/13/2022 7:33:08 AM
4/13/2022 7:33:08 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 7:33:08 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063177_TEMPLATE1.TXT ### 4/13/2022 7:33:08 AM
4/13/2022 7:33:08 AM : Count:: ### TEMPLATE1:191
4/13/2022 7:33:35 AM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 7:33:35 AM
4/13/2022 7:33:35 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 4/13/2022 7:33:35 AM
4/13/2022 7:33:35 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 7:33:35 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9064126_TEMPLATE1.txt ### 4/13/2022 7:33:35 AM
4/13/2022 7:33:35 AM : Count:: ### TEMPLATE1:2
4/13/2022 7:33:35 AM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 7:33:35 AM
4/13/2022 7:33:35 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067122_TEMPLATE1.TXT ### 4/13/2022 7:33:35 AM
4/13/2022 7:33:35 AM : Count:: ### TEMPLATE1:28
4/13/2022 7:33:39 AM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 7:33:39 AM
4/13/2022 7:33:39 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067130_TEMPLATE1.TXT ### 4/13/2022 7:33:39 AM
4/13/2022 7:33:39 AM : Count:: ### TEMPLATE1:2001
4/13/2022 7:35:51 AM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 7:35:51 AM
4/13/2022 7:35:51 AM : Template Import Complete  ### 4/13/2022 7:35:51 AM
4/13/2022 7:35:54 AM : Completed Updating Has Transaction Flag  ### 4/13/2022 7:35:54 AM
4/13/2022 7:35:54 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 4/13/2022 7:35:54 AM
4/13/2022 7:35:54 AM : Zylem Access Unblocked  ### 4/13/2022 7:35:54 AM
4/13/2022 7:35:54 AM : Application Ended  ### 4/13/2022 7:35:54 AM

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

4/13/2022 2:30:03 PM : 11  ### 4/13/2022 2:30:03 PM

4/13/2022 2:30:03 PM : 22  ### 4/13/2022 2:30:03 PM

4/13/2022 2:30:03 PM : 33  ### 4/13/2022 2:30:03 PM

4/13/2022 2:30:03 PM : Application Started  ### 4/13/2022 2:30:03 PM

4/13/2022 2:30:03 PM : Start Process : checkAllTablesExists()  ### 
4/13/2022 2:30:03 PM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 4/13/2022 2:30:03 PM
4/13/2022 2:30:03 PM : MainForm_Load  ### AlertSystem ON
4/13/2022 2:30:03 PM : No. of Files to import (RECEIVEFINAL):  ### 981
4/13/2022 2:30:03 PM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
4/13/2022 2:30:04 PM : For Distributor 000000000001316 Insert Count::5 ### Delete Count::0
4/13/2022 2:30:04 PM : Import AD File --->> AD_1316_20220413_8f39ae8f9b59d8f3336129d62712fa31.TXT ### 4/13/2022 2:30:04 PM
4/13/2022 2:30:04 PM : For Distributor 000000000000352 Insert Count::1 ### Delete Count::0
4/13/2022 2:30:04 PM : Import AD File --->> AD_352_20220413_e99d257c8758fc4faffef3b95c03d6fb.TXT ### 4/13/2022 2:30:04 PM
4/13/2022 2:30:04 PM : For Distributor 000000000000356 Insert Count::10 ### Delete Count::0
4/13/2022 2:30:04 PM : Import AD File --->> AD_356_20220413_b923dd860f3ce9f17146e1839522925a.TXT ### 4/13/2022 2:30:04 PM
4/13/2022 2:30:04 PM : For Distributor 000000000000369 Insert Count::2 ### Delete Count::2
4/13/2022 2:30:04 PM : Import AD File --->> AD_369_20220413_e460a3bc74cebccfc7ca018764799270.TXT ### 4/13/2022 2:30:04 PM
4/13/2022 2:30:05 PM : For Distributor 000000000000371 Insert Count::0 ### Delete Count::3
4/13/2022 2:30:05 PM : Import AD File --->> AD_371_20220413_02898b4421f6c4d454df285b1b8419ef.TXT ### 4/13/2022 2:30:05 PM
4/13/2022 2:30:05 PM : For Distributor 000000000000372 Insert Count::4 ### Delete Count::1
4/13/2022 2:30:05 PM : Import AD File --->> AD_372_20220413_307db269813a2adc4ca7c54eea1c8b0f.TXT ### 4/13/2022 2:30:05 PM
4/13/2022 2:30:05 PM : For Distributor 000000000000373 Insert Count::6 ### Delete Count::0
4/13/2022 2:30:05 PM : Import AD File --->> AD_373_20220413_cbfa42ad9b3a9baeadeb2cd31f52f145.TXT ### 4/13/2022 2:30:05 PM
4/13/2022 2:30:06 PM : For Distributor 000000000000492 Insert Count::4 ### Delete Count::0
4/13/2022 2:30:06 PM : Import AD File --->> AD_492_20220413_84da4658ed5fc77b5594ec525212bbb4.TXT ### 4/13/2022 2:30:06 PM
4/13/2022 2:30:06 PM : For Distributor 000000000000815 Insert Count::11 ### Delete Count::0
4/13/2022 2:30:06 PM : Import AD File --->> AD_815_20220413_50ad51abb0862e7174c60b7303950657.TXT ### 4/13/2022 2:30:06 PM
4/13/2022 2:30:10 PM : For Distributor 000000000000356 Insert Count::1 ### Delete Count::0
4/13/2022 2:30:10 PM : Import DN File --->> DN_356_20220411_d33a6958f6513746e37f2468c506aa13.TXT ### 4/13/2022 2:30:10 PM
4/13/2022 2:30:10 PM : For Distributor 000000000000356 Insert Count::4 ### Delete Count::0
4/13/2022 2:30:10 PM : Import DN File --->> DN_356_20220412_0d4461ec0715a088412defec955fb916.TXT ### 4/13/2022 2:30:10 PM
4/13/2022 2:30:17 PM : For Distributor 000000000000372 Insert Count::4 ### Delete Count::0
4/13/2022 2:30:17 PM : Import DN File --->> DN_372_20220408_6773309f8818c4dd2971d345a5000838.TXT ### 4/13/2022 2:30:17 PM
4/13/2022 2:30:20 PM : For Distributor 000000000000812 Insert Count::6 ### Delete Count::6
4/13/2022 2:30:20 PM : Import DN File --->> DN_812_20220325_09ccc00a5385f8c6d2df0667f496497f.TXT ### 4/13/2022 2:30:20 PM
4/13/2022 2:30:23 PM : Import DN File --->> DN_815_20220411_f539a2df328bb5b8a4070e8a4bbdf96b.TXT ### 4/13/2022 2:30:23 PM
4/13/2022 2:30:23 PM : NO Previous File For Distributor 000000000000815 ### Insert Count::4
4/13/2022 2:30:24 PM : For Distributor 000000000001316 Insert Count::6 ### Delete Count::0
4/13/2022 2:30:25 PM : Import IN File --->> IN_1316_20220413_71c460cdd382a094f609133892f90471.TXT ### 4/13/2022 2:30:24 PM
4/13/2022 2:30:26 PM : Import IN File --->> IN_352_20220413_b9e207f45003077d0eef7b9e503dfbd9.TXT ### 4/13/2022 2:30:26 PM
4/13/2022 2:30:26 PM : NO Previous File For Distributor 000000000000352 ### Insert Count::8
4/13/2022 2:30:28 PM : For Distributor 000000000000353 Insert Count::1 ### Delete Count::0
4/13/2022 2:30:28 PM : Import IN File --->> IN_353_20220401_a2d52c5bee9aec6f4c525bf75660c09b.TXT ### 4/13/2022 2:30:28 PM
4/13/2022 2:30:29 PM : For Distributor 000000000000356 Insert Count::41 ### Delete Count::0
4/13/2022 2:30:29 PM : Import IN File --->> IN_356_20220412_58adae66f4f100c1b6249bbb000a9919.TXT ### 4/13/2022 2:30:29 PM
4/13/2022 2:30:29 PM : Import IN File --->> IN_356_20220413_b4297b03f90daf8d866224f4760e2ad6.TXT ### 4/13/2022 2:30:29 PM
4/13/2022 2:30:29 PM : NO Previous File For Distributor 000000000000356 ### Insert Count::7
4/13/2022 2:30:31 PM : For Distributor 000000000000369 Insert Count::5 ### Delete Count::5
4/13/2022 2:30:31 PM : Import IN File --->> IN_369_20220303_134e62154fa333ce12e95d9c190de538.TXT ### 4/13/2022 2:30:31 PM
4/13/2022 2:30:32 PM : For Distributor 000000000000369 Insert Count::1 ### Delete Count::1
4/13/2022 2:30:32 PM : Import IN File --->> IN_369_20220308_4562b971f109181a1cc4a56dafe47a82.TXT ### 4/13/2022 2:30:32 PM
4/13/2022 2:30:32 PM : For Distributor 000000000000369 Insert Count::2 ### Delete Count::2
4/13/2022 2:30:32 PM : Import IN File --->> IN_369_20220310_88095017c09e3be9b2b1dd593c39f52a.TXT ### 4/13/2022 2:30:32 PM
4/13/2022 2:30:32 PM : For Distributor 000000000000369 Insert Count::2 ### Delete Count::2
4/13/2022 2:30:32 PM : Import IN File --->> IN_369_20220312_05dd874f6f050c0677f1085091100a1c.TXT ### 4/13/2022 2:30:32 PM
4/13/2022 2:30:32 PM : For Distributor 000000000000369 Insert Count::2 ### Delete Count::2
4/13/2022 2:30:32 PM : Import IN File --->> IN_369_20220317_f4f5ccba4459fcdcca3d2d13e40afad8.TXT ### 4/13/2022 2:30:32 PM
4/13/2022 2:30:33 PM : For Distributor 000000000000369 Insert Count::0 ### Delete Count::0
4/13/2022 2:30:33 PM : Import IN File --->> IN_369_20220321_fb2be25571e19a2fdffa58d081f692d7.TXT ### 4/13/2022 2:30:33 PM
4/13/2022 2:30:33 PM : For Distributor 000000000000369 Insert Count::5 ### Delete Count::5
4/13/2022 2:30:33 PM : Import IN File --->> IN_369_20220322_6be442e0d60e968927690402614863ac.TXT ### 4/13/2022 2:30:33 PM
4/13/2022 2:30:33 PM : For Distributor 000000000000369 Insert Count::0 ### Delete Count::0
4/13/2022 2:30:33 PM : Import IN File --->> IN_369_20220323_8e941d53299943fb04c83978f09cfd32.TXT ### 4/13/2022 2:30:33 PM
4/13/2022 2:30:33 PM : For Distributor 000000000000369 Insert Count::1 ### Delete Count::1
4/13/2022 2:30:33 PM : Import IN File --->> IN_369_20220326_a96d4f5efa4ac179c6f3bf54ceee12a3.TXT ### 4/13/2022 2:30:33 PM
4/13/2022 2:30:33 PM : For Distributor 000000000000369 Insert Count::0 ### Delete Count::0
4/13/2022 2:30:33 PM : Import IN File --->> IN_369_20220328_50b95a075be8189fa64b0d6833bfbc02.TXT ### 4/13/2022 2:30:33 PM
4/13/2022 2:30:36 PM : For Distributor 000000000000371 Insert Count::0 ### Delete Count::34
4/13/2022 2:30:36 PM : Import IN File --->> IN_371_20220411_802c0bfb1b1770c132455895f799c160.TXT ### 4/13/2022 2:30:36 PM
4/13/2022 2:30:36 PM : For Distributor 000000000000371 Insert Count::0 ### Delete Count::14
4/13/2022 2:30:36 PM : Import IN File --->> IN_371_20220412_d41d8cd98f00b204e9800998ecf8427e.TXT ### 4/13/2022 2:30:36 PM
4/13/2022 2:30:38 PM : Import IN File --->> IN_372_20220411_ce4b58f9d458a8f48723c8e5ff9e8e7a.TXT ### 4/13/2022 2:30:38 PM
4/13/2022 2:30:38 PM : NO Previous File For Distributor 000000000000372 ### Insert Count::10
4/13/2022 2:30:38 PM : Import IN File --->> IN_372_20220412_b30af60618fddfb7b2d30eef700c652c.TXT ### 4/13/2022 2:30:38 PM
4/13/2022 2:30:38 PM : NO Previous File For Distributor 000000000000372 ### Insert Count::8
4/13/2022 2:30:39 PM : Import IN File --->> IN_373_20220413_4fe476efcb1e5af4fa79961ac82b860f.TXT ### 4/13/2022 2:30:39 PM
4/13/2022 2:30:39 PM : NO Previous File For Distributor 000000000000373 ### Insert Count::8
4/13/2022 2:30:41 PM : Exception  ### Index was outside the bounds of the array.
4/13/2022 2:30:41 PM : Error ### Index was outside the bounds of the array. Line 
4/13/2022 2:30:41 PM : For Distributor 000000000000492 Insert Count::2 ### Delete Count::0
4/13/2022 2:30:41 PM : Import IN File --->> IN_492_20220413_c813f244c9fc6ef2b80aa2092e14599f.TXT ### 4/13/2022 2:30:41 PM
4/13/2022 2:30:43 PM : For Distributor 000000000000665 Insert Count::3 ### Delete Count::3
4/13/2022 2:30:43 PM : Import IN File --->> IN_665_20220409_72d5c0ebb173e7ab37f15cd4683d915b.TXT ### 4/13/2022 2:30:43 PM
4/13/2022 2:30:46 PM : For Distributor 000000000000815 Insert Count::1 ### Delete Count::0
4/13/2022 2:30:46 PM : Import IN File --->> IN_815_20220404_d28e555e40564fc4d1656df217ea70a4.TXT ### 4/13/2022 2:30:46 PM
4/13/2022 2:30:46 PM : For Distributor 000000000000815 Insert Count::1 ### Delete Count::0
4/13/2022 2:30:46 PM : Import IN File --->> IN_815_20220405_f39a7dd3e28823d75646ac67f25af22d.TXT ### 4/13/2022 2:30:46 PM
4/13/2022 2:30:46 PM : For Distributor 000000000000815 Insert Count::7 ### Delete Count::0
4/13/2022 2:30:46 PM : Import IN File --->> IN_815_20220406_3f1398a20ed92996ece7ae28e26b3b19.TXT ### 4/13/2022 2:30:46 PM
4/13/2022 2:30:46 PM : For Distributor 000000000000815 Insert Count::9 ### Delete Count::0
4/13/2022 2:30:46 PM : Import IN File --->> IN_815_20220407_9903f2a6ee5091bf123f8da2ad04a97b.TXT ### 4/13/2022 2:30:46 PM
4/13/2022 2:30:46 PM : For Distributor 000000000000815 Insert Count::2 ### Delete Count::0
4/13/2022 2:30:46 PM : Import IN File --->> IN_815_20220408_9869ec365b9c100f4937f6ffd7f9581c.TXT ### 4/13/2022 2:30:46 PM
4/13/2022 2:30:46 PM : Import IN File --->> IN_815_20220409_1dec38ef9673d77c9e9f5bd00838078d.TXT ### 4/13/2022 2:30:46 PM
4/13/2022 2:30:46 PM : NO Previous File For Distributor 000000000000815 ### Insert Count::3
4/13/2022 2:30:47 PM : Import IN File --->> IN_815_20220411_0b5c087c217e893beb35526015013a1a.TXT ### 4/13/2022 2:30:47 PM
4/13/2022 2:30:47 PM : NO Previous File For Distributor 000000000000815 ### Insert Count::1
4/13/2022 2:30:48 PM : For Distributor 000000000000820 Insert Count::1 ### Delete Count::1
4/13/2022 2:30:48 PM : Import IN File --->> IN_820_20220412_3cb384a514b1a26da573317c830ec310.TXT ### 4/13/2022 2:30:48 PM
4/13/2022 2:30:49 PM : For Distributor 000000000000820 Insert Count::0 ### Delete Count::1
4/13/2022 2:30:49 PM : Import IN File --->> IN_820_20220413_d41d8cd98f00b204e9800998ecf8427e.TXT ### 4/13/2022 2:30:49 PM
4/13/2022 2:30:49 PM : For Distributor 000000000000820 Insert Count::6 ### Delete Count::6
4/13/2022 2:30:49 PM : Import OT File --->> OT_820_20220408_2732e5155f9f8555eac787220de2041e.TXT ### 4/13/2022 2:30:49 PM
4/13/2022 2:30:49 PM : PostData() --->>  ### 4/13/2022 2:30:49 PM
4/13/2022 2:30:52 PM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 4/13/2022 2:30:52 PM
4/13/2022 2:30:57 PM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '13/Apr/2022' ### 4/13/2022 2:30:57 PM
4/13/2022 2:30:57 PM : ItemLink Successful --->> exec SP_ItemLinkDiff '13/Apr/2022' ### 4/13/2022 2:30:57 PM
4/13/2022 2:30:57 PM :  ### 
4/13/2022 2:30:57 PM : UNLINKEDSALES Record Count Before --->> 137 ### 4/13/2022 2:30:57 PM
4/13/2022 2:30:57 PM : UNLINKEDSALES_DEL Record Count Before --->> 71 ### 4/13/2022 2:30:57 PM
4/13/2022 2:31:09 PM : Posting Sales Successful --->> exec prPostLinkedDiffSales '13/Apr/2022' ### 4/13/2022 2:31:09 PM
4/13/2022 2:31:09 PM : UNLINKEDSALES Record Count After --->> 0 ### 4/13/2022 2:31:09 PM
4/13/2022 2:31:09 PM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 4/13/2022 2:31:09 PM
4/13/2022 2:31:09 PM :  ### 
4/13/2022 2:31:09 PM : Posting Supplierlink Query for Purchases --->>  ### 4/13/2022 2:31:09 PM
4/13/2022 2:31:17 PM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '13/Apr/2022' ### 4/13/2022 2:31:17 PM
4/13/2022 2:31:23 PM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '13/Apr/2022' ### 4/13/2022 2:31:23 PM
4/13/2022 2:31:23 PM : Posting Supplierlink Query for CompanyPurchases --->>  ### 4/13/2022 2:31:23 PM
4/13/2022 2:31:23 PM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '13/Apr/2022' ### 4/13/2022 2:31:23 PM
4/13/2022 2:31:23 PM : Posting ClosingStock Successful --->>  ### 4/13/2022 2:31:23 PM
4/13/2022 2:31:23 PM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 4/13/2022 2:31:23 PM
4/13/2022 2:31:23 PM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
4/13/2022 2:31:23 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1025789_TEMPLATE1.TXT ### 4/13/2022 2:31:23 PM
4/13/2022 2:31:24 PM : Count:: ### TEMPLATE1:135
4/13/2022 2:31:32 PM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 2:31:32 PM
4/13/2022 2:31:32 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1123438_TEMPLATE1.TXT ### 4/13/2022 2:31:32 PM
4/13/2022 2:31:32 PM : Count:: ### TEMPLATE1:50
4/13/2022 2:31:39 PM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 2:31:39 PM
4/13/2022 2:31:39 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1224500_TEMPLATE1.TXT ### 4/13/2022 2:31:39 PM
4/13/2022 2:31:39 PM : Count:: ### TEMPLATE1:13
4/13/2022 2:31:41 PM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 2:31:41 PM
4/13/2022 2:31:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 4/13/2022 2:31:41 PM
4/13/2022 2:31:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 2:31:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1986218_TEMPLATE1.TXT ### 4/13/2022 2:31:41 PM
4/13/2022 2:31:41 PM : Count:: ### TEMPLATE1:58
4/13/2022 2:31:49 PM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 2:31:49 PM
4/13/2022 2:31:49 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 4/13/2022 2:31:49 PM
4/13/2022 2:31:49 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 2:31:49 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 4/13/2022 2:31:49 PM
4/13/2022 2:31:49 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 2:31:49 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 4/13/2022 2:31:49 PM
4/13/2022 2:31:49 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 2:31:49 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 4/13/2022 2:31:49 PM
4/13/2022 2:31:49 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 2:31:49 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2848065_TEMPLATE1.TXT ### 4/13/2022 2:31:49 PM
4/13/2022 2:31:49 PM : Count:: ### TEMPLATE1:59
4/13/2022 2:31:53 PM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 2:31:53 PM
4/13/2022 2:31:53 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3513087_TEMPLATE1.TXT ### 4/13/2022 2:31:53 PM
4/13/2022 2:31:53 PM : Count:: ### TEMPLATE1:64
4/13/2022 2:32:01 PM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 2:32:01 PM
4/13/2022 2:32:01 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 4/13/2022 2:32:01 PM
4/13/2022 2:32:01 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 2:32:01 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 4/13/2022 2:32:01 PM
4/13/2022 2:32:01 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 2:32:01 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 4/13/2022 2:32:01 PM
4/13/2022 2:32:01 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 2:32:01 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 4/13/2022 2:32:01 PM
4/13/2022 2:32:01 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 2:32:01 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3985879_TEMPLATE1.txt ### 4/13/2022 2:32:01 PM
4/13/2022 2:32:01 PM : Count:: ### TEMPLATE1:94
4/13/2022 2:32:20 PM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 2:32:20 PM
4/13/2022 2:32:20 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 4/13/2022 2:32:20 PM
4/13/2022 2:32:20 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 2:32:20 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 4/13/2022 2:32:20 PM
4/13/2022 2:32:20 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 2:32:20 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 4/13/2022 2:32:20 PM
4/13/2022 2:32:20 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 2:32:20 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060305_TEMPLATE1.TXT ### 4/13/2022 2:32:20 PM
4/13/2022 2:32:20 PM : Count:: ### TEMPLATE1:93
4/13/2022 2:32:23 PM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 2:32:23 PM
4/13/2022 2:32:23 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060893_TEMPLATE1.txt ### 4/13/2022 2:32:23 PM
4/13/2022 2:32:23 PM : Count:: ### TEMPLATE1:502
4/13/2022 2:32:54 PM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 2:32:54 PM
4/13/2022 2:32:54 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 4/13/2022 2:32:54 PM
4/13/2022 2:32:54 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 2:32:54 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061358_TEMPLATE1.TXT ### 4/13/2022 2:32:54 PM
4/13/2022 2:32:54 PM : Count:: ### TEMPLATE1:73
4/13/2022 2:33:04 PM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 2:33:04 PM
4/13/2022 2:33:04 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 4/13/2022 2:33:04 PM
4/13/2022 2:33:04 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 2:33:04 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 4/13/2022 2:33:04 PM
4/13/2022 2:33:04 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 2:33:04 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 4/13/2022 2:33:04 PM
4/13/2022 2:33:04 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 2:33:04 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063177_TEMPLATE1.TXT ### 4/13/2022 2:33:04 PM
4/13/2022 2:33:04 PM : Count:: ### TEMPLATE1:191
4/13/2022 2:33:16 PM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 2:33:16 PM
4/13/2022 2:33:16 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 4/13/2022 2:33:16 PM
4/13/2022 2:33:16 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/13/2022 2:33:16 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9064126_TEMPLATE1.txt ### 4/13/2022 2:33:16 PM
4/13/2022 2:33:16 PM : Count:: ### TEMPLATE1:2
4/13/2022 2:33:16 PM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 2:33:16 PM
4/13/2022 2:33:16 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9066916_TEMPLATE1.TXT ### 4/13/2022 2:33:16 PM
4/13/2022 2:33:16 PM : Count:: ### TEMPLATE1:68
4/13/2022 2:33:26 PM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 2:33:26 PM
4/13/2022 2:33:26 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067041_TEMPLATE1.TXT ### 4/13/2022 2:33:26 PM
4/13/2022 2:33:26 PM : Count:: ### TEMPLATE1:80
4/13/2022 2:33:37 PM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 2:33:37 PM
4/13/2022 2:33:37 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067092_TEMPLATE1.TXT ### 4/13/2022 2:33:37 PM
4/13/2022 2:33:37 PM : Count:: ### TEMPLATE1:125
4/13/2022 2:33:45 PM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 2:33:45 PM
4/13/2022 2:33:45 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067109_TEMPLATE1.TXT ### 4/13/2022 2:33:45 PM
4/13/2022 2:33:45 PM : Count:: ### TEMPLATE1:44
4/13/2022 2:33:51 PM : SP_DistributorTemplatePosting Successful --->>  ### 4/13/2022 2:33:51 PM
4/13/2022 2:33:51 PM : Template Import Complete  ### 4/13/2022 2:33:51 PM
4/13/2022 2:33:53 PM : Completed Updating Has Transaction Flag  ### 4/13/2022 2:33:53 PM
4/13/2022 2:33:53 PM : Transaction Table lastEdiDate Update on BrandAlias Update ### 4/13/2022 2:33:53 PM
4/13/2022 2:33:53 PM : Zylem Access Unblocked  ### 4/13/2022 2:33:53 PM
4/13/2022 2:33:54 PM : Application Ended  ### 4/13/2022 2:33:54 PM