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

5/5/2022 2:30:05 AM : 11  ### 5/5/2022 2:30:05 AM

5/5/2022 2:30:05 AM : 22  ### 5/5/2022 2:30:05 AM

5/5/2022 2:30:05 AM : 33  ### 5/5/2022 2:30:05 AM

5/5/2022 2:30:05 AM : Application Started  ### 5/5/2022 2:30:05 AM

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

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

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

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

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

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

5/5/2022 7:30:02 AM : Start Process : checkAllTablesExists()  ### 
5/5/2022 7:30:02 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 5/5/2022 7:30:02 AM
5/5/2022 7:30:02 AM : MainForm_Load  ### AlertSystem ON
5/5/2022 7:30:02 AM : No. of Files to import (RECEIVEFINAL):  ### 602
5/5/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
5/5/2022 7:30:03 AM : For Distributor 000000000000011 Insert Count::1 ### Delete Count::0
5/5/2022 7:30:03 AM : Import AD File --->> AD_11_20220505_2a595da99173e2bfd3969e7600738e19.TXT ### 5/5/2022 7:30:03 AM
5/5/2022 7:30:03 AM : For Distributor 000000000001316 Insert Count::2 ### Delete Count::1
5/5/2022 7:30:03 AM : Import AD File --->> AD_1316_20220505_8f3f70e4a9250ed2a149b61252fc7ba0.TXT ### 5/5/2022 7:30:03 AM
5/5/2022 7:30:03 AM : For Distributor 000000000000353 Insert Count::10 ### Delete Count::0
5/5/2022 7:30:03 AM : Import AD File --->> AD_353_20220505_ef0fa940bc9e0889de551ae78af1e24d.TXT ### 5/5/2022 7:30:03 AM
5/5/2022 7:30:04 AM : For Distributor 000000000000369 Insert Count::6 ### Delete Count::1
5/5/2022 7:30:04 AM : Import AD File --->> AD_369_20220505_6fc9e0ebd268805a8b87d710e03eceb8.TXT ### 5/5/2022 7:30:04 AM
5/5/2022 7:30:04 AM : For Distributor 000000000000809 Insert Count::14 ### Delete Count::0
5/5/2022 7:30:04 AM : Import AD File --->> AD_809_20220505_e64a2902a94791bee16c04283efbce49.TXT ### 5/5/2022 7:30:04 AM
5/5/2022 7:30:06 AM : For Distributor 000000000001026 Insert Count::1 ### Delete Count::0
5/5/2022 7:30:06 AM : Import DN File --->> DN_1026_20220504_97318688bdf6639780e31f8b1bc21aca.TXT ### 5/5/2022 7:30:06 AM
5/5/2022 7:30:26 AM : For Distributor 000000000000011 Insert Count::4 ### Delete Count::0
5/5/2022 7:30:26 AM : Import IN File --->> IN_11_20220504_e9743c8a59b8b4a98459ad9ff5d961a2.TXT ### 5/5/2022 7:30:26 AM
5/5/2022 7:30:28 AM : For Distributor 000000000001316 Insert Count::1 ### Delete Count::0
5/5/2022 7:30:28 AM : Import IN File --->> IN_1316_20220504_752063aa859fe06d9de21cac05acf89f.TXT ### 5/5/2022 7:30:28 AM
5/5/2022 7:30:28 AM : Import IN File --->> IN_1316_20220505_4ef5111113b54b9097bb236193df1e2f.TXT ### 5/5/2022 7:30:28 AM
5/5/2022 7:30:28 AM : NO Previous File For Distributor 000000000001316 ### Insert Count::1
5/5/2022 7:30:29 AM : For Distributor 000000000000353 Insert Count::2 ### Delete Count::2
5/5/2022 7:30:29 AM : Import IN File --->> IN_353_20220411_0650c1045925cec1e01da9790ae7eb1c.TXT ### 5/5/2022 7:30:29 AM
5/5/2022 7:30:30 AM : For Distributor 000000000000353 Insert Count::2 ### Delete Count::0
5/5/2022 7:30:30 AM : Import IN File --->> IN_353_20220430_2af0f0682f199c9fd8b9be069e12d7b6.TXT ### 5/5/2022 7:30:30 AM
5/5/2022 7:30:30 AM : For Distributor 000000000000353 Insert Count::5 ### Delete Count::0
5/5/2022 7:30:30 AM : Import IN File --->> IN_353_20220502_f86a403c47f5ce24b0c49274cc0fac0c.TXT ### 5/5/2022 7:30:30 AM
5/5/2022 7:30:31 AM : For Distributor 000000000000353 Insert Count::11 ### Delete Count::0
5/5/2022 7:30:31 AM : Import IN File --->> IN_353_20220504_1d92de16324174f026f338b821eb23e8.TXT ### 5/5/2022 7:30:31 AM
5/5/2022 7:30:33 AM : For Distributor 000000000000369 Insert Count::10 ### Delete Count::0
5/5/2022 7:30:33 AM : Import IN File --->> IN_369_20220502_f1ebb89398c92480450da7b1be5bb9ba.TXT ### 5/5/2022 7:30:33 AM
5/5/2022 7:30:33 AM : For Distributor 000000000000369 Insert Count::13 ### Delete Count::0
5/5/2022 7:30:33 AM : Import IN File --->> IN_369_20220504_c6dbbb7b1458ad69f40b3688d0b72045.TXT ### 5/5/2022 7:30:33 AM
5/5/2022 7:30:35 AM : For Distributor 000000000000424 Insert Count::2 ### Delete Count::0
5/5/2022 7:30:35 AM : Import IN File --->> IN_424_20220504_a185c45f272909b984bbbb5b51dcfeeb.TXT ### 5/5/2022 7:30:35 AM
5/5/2022 7:30:35 AM : Import IN File --->> IN_424_20220505_647d0a44ee96078e1c1efc5ee36989fe.TXT ### 5/5/2022 7:30:35 AM
5/5/2022 7:30:35 AM : NO Previous File For Distributor 000000000000424 ### Insert Count::1
5/5/2022 7:30:37 AM : For Distributor 000000000000809 Insert Count::5 ### Delete Count::3
5/5/2022 7:30:37 AM : Import IN File --->> IN_809_20220429_d5a15144ad781ab31091724ae92f9f47.TXT ### 5/5/2022 7:30:37 AM
5/5/2022 7:30:38 AM : For Distributor 000000000000809 Insert Count::21 ### Delete Count::0
5/5/2022 7:30:38 AM : Import IN File --->> IN_809_20220502_87c50cbfd8181c65e3bf3a7ad4ea2046.TXT ### 5/5/2022 7:30:38 AM
5/5/2022 7:30:38 AM : For Distributor 000000000000809 Insert Count::22 ### Delete Count::0
5/5/2022 7:30:38 AM : Import IN File --->> IN_809_20220503_cf9e246b2a4ef9063b2e4b51f516ce1a.TXT ### 5/5/2022 7:30:38 AM
5/5/2022 7:30:38 AM : For Distributor 000000000000809 Insert Count::13 ### Delete Count::0
5/5/2022 7:30:38 AM : Import IN File --->> IN_809_20220504_389680ad60c8d12a506e89c1a307783a.TXT ### 5/5/2022 7:30:38 AM
5/5/2022 7:30:38 AM : Import IN File --->> IN_809_20220505_15e6ffa34ad5fb3c9e7adc0baadf1a00.TXT ### 5/5/2022 7:30:38 AM
5/5/2022 7:30:38 AM : NO Previous File For Distributor 000000000000809 ### Insert Count::1
5/5/2022 7:30:43 AM : For Distributor 000000000000369 Insert Count::1 ### Delete Count::0
5/5/2022 7:30:43 AM : Import OT File --->> OT_369_20220504_dfd497c539001b9f12833bfd4936bfce.TXT ### 5/5/2022 7:30:43 AM
5/5/2022 7:30:43 AM : PostData() --->>  ### 5/5/2022 7:30:43 AM
5/5/2022 7:30:46 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 5/5/2022 7:30:46 AM
5/5/2022 7:30:49 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '05/May/2022' ### 5/5/2022 7:30:49 AM
5/5/2022 7:30:49 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '05/May/2022' ### 5/5/2022 7:30:49 AM
5/5/2022 7:30:49 AM :  ### 
5/5/2022 7:30:49 AM : UNLINKEDSALES Record Count Before --->> 114 ### 5/5/2022 7:30:49 AM
5/5/2022 7:30:49 AM : UNLINKEDSALES_DEL Record Count Before --->> 5 ### 5/5/2022 7:30:49 AM
5/5/2022 9:12:48 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '05/May/2022' ### 5/5/2022 9:12:48 AM
5/5/2022 9:12:48 AM : UNLINKEDSALES Record Count After --->> 0 ### 5/5/2022 9:12:48 AM
5/5/2022 9:12:48 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 5/5/2022 9:12:48 AM
5/5/2022 9:12:49 AM :  ### 
5/5/2022 9:12:49 AM : Posting Supplierlink Query for Purchases --->>  ### 5/5/2022 9:12:49 AM
5/5/2022 9:12:55 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '05/May/2022' ### 5/5/2022 9:12:55 AM
5/5/2022 9:13:01 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '05/May/2022' ### 5/5/2022 9:13:01 AM
5/5/2022 9:13:01 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 5/5/2022 9:13:01 AM
5/5/2022 9:13:01 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '05/May/2022' ### 5/5/2022 9:13:01 AM
5/5/2022 9:13:01 AM : Posting ClosingStock Successful --->>  ### 5/5/2022 9:13:01 AM
5/5/2022 9:13:01 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 5/5/2022 9:13:01 AM
5/5/2022 9:13:01 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
5/5/2022 9:13:01 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1123438_TEMPLATE1.TXT ### 5/5/2022 9:13:01 AM
5/5/2022 9:13:02 AM : Count:: ### TEMPLATE1:67
5/5/2022 9:13:06 AM : SP_DistributorTemplatePosting Successful --->>  ### 5/5/2022 9:13:06 AM
5/5/2022 9:13:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1224500_TEMPLATE1.TXT ### 5/5/2022 9:13:06 AM
5/5/2022 9:13:06 AM : Count:: ### TEMPLATE1:8
5/5/2022 9:13:06 AM : SP_DistributorTemplatePosting Successful --->>  ### 5/5/2022 9:13:06 AM
5/5/2022 9:13:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 5/5/2022 9:13:06 AM
5/5/2022 9:13:06 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 9:13:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 5/5/2022 9:13:06 AM
5/5/2022 9:13:06 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 9:13:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 5/5/2022 9:13:06 AM
5/5/2022 9:13:06 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 9:13:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 5/5/2022 9:13:06 AM
5/5/2022 9:13:06 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 9:13:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 5/5/2022 9:13:06 AM
5/5/2022 9:13:06 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 9:13:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2848065_TEMPLATE1.TXT ### 5/5/2022 9:13:06 AM
5/5/2022 9:13:06 AM : Count:: ### TEMPLATE1:48
5/5/2022 9:13:10 AM : SP_DistributorTemplatePosting Successful --->>  ### 5/5/2022 9:13:10 AM
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A101","A101","ASARPOTA CORPORATION","NR. SAMRATNAGARISHANPUR HIGHWAY CROSS ROAD|24ABIPS3595H1Z9|98240 75672|","AHMEDABAD","GUJARAT","0","98240 75672","","98240 75672","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1014","A1014","ALFA PEST CONTROL","201SAGAR COMPLEXB/H. SAWAN HOTELSARKHEJ-SANAND CROSS ROAD|24AMGPS0979N1ZD|99799 75500|","AHMEDABAD","GUJARAT","0","99799 75500","MAMTA SHAH  MILIND SHAH","99799 75500","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1036","A1036","MARUTI DOOR & PLY (GUJ) PVT LTD","54-AZAK INDUSTRIAL AREA PO-PARDHOL|24AACCM3234H1ZU|98259 27022|","DEHGAM","GUJARAT","0","98259 27022","ASHIVN SHAH","98259 27022","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A108","A108","SARTHI AGROCHEM","PLOT NO. 1306/5PHASE - IV GIDC|24AAXPP3368F2Z7|22820228|","AHMEDABAD","GUJARAT","382 330","22820228","RAJUBHAI PATEL","22820228","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1093","A1093","CURE PEST CONTROL","||78747 63032|","AHMEDABAD","GUJARAT","0","78747 63032","KAMLESH BHAI","78747 63032","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1146","A1146","KOMAL PEST CONTROL","A-407 ADITYA FLATNR. MRF SHOW ROOM|24AGHPV5586H1ZU|94265 25266|","AHMEDABAD","GUJARAT","380 022","94265 25266","JAGDISH BHAI","94265 25266","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1190","A1190","REAL LINE PEST MANAGMENT SERVICE","FF/5 SANJIVNI COMPLEXOPP. SRINAND NAGAR-1|24BBWPS4257B1ZD|97277 50920|","AHMEDABAD","GUJARAT","380051","97277 50920","NIKHILBHAI","97277 50920","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1268","A1268","GIS PEST MANAGMENT SERVICES","G-6 NAVKAR APPARTMENTNR. PALLAV CROSS ROAD|24AVAPM3971F1ZQ|84607 83084|","AHMEDABAD","GUJARAT","380 013","84607 83084","AMIT MECKWAN","84607 83084","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1340","A1340","PEST CONTROL SOLUTION","5/A ROYAL SHOPPING CENTERMODHERA ROAD|24AASFP0714E1ZG|99245 77395|","MEHSANA","GUJARAT","384 002","99245 77395","ANIMESH THAKKAR","99245 77395","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1342","A1342","RAJENDRA ROHIT","B-402 SHREEJI VANDAN B/H. AMBIKA NAGAR WATER TANK ROAD||96389 45728|","BARODA","GUJARAT","390021","96389 45728","RAJENDRA ROHIT","96389 45728","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1471","A1471","BITCO INTEGRATED PEST MANA. LLP","13 D-1302 SWATI GARDENIA NR. TORRENT POWER SUB STATION|24AAUFB4449A1ZK|78745 80175|","AHMEDABAD","GUJARAT","0","78745 80175","MITESH AGRAWAL JAYESH RATHOD","78745 80175","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1508","A1508","WELLKNOWN INDUSTRIES","SURVEY NO:108/109 MEGHAVI TIMBER MARKETNR. 66 KV SUB STATION KAMLA ROAD |24AAAFW3790R1ZI|93755 13310|","KHEDA","GUJARAT","387320","93755 13310","DINESH PATEL","93755 13310","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1520","A1520","YADAV AGRO CENTER","SHOP NO. 4 SAVASAR NAKANEAR SWAMINARAYAN CIRCLE|24BRJPK1951R1Z9|99130 03951|","KUTCH","GUJARAT","370 110","99130 03951","VIJAYBHAI & SUNILBHAI","99130 03951","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A154","A154","SAMIR JANI","F-3 CHANDRIKA PARK SOCIETYNR. JAYMALA BUS-STOP||98244 10373|","AHMEDABAD","GUJARAT","0","98244 10373","MR. SAMIRBHAI","98244 10373","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1547","A1547","ASIA PACIFIC PEST MANAGEMENT","201/A-1 L.B. PARK  NEAR TURNING POINT CIRCLE |24ABLFA7725J1Z8|93747 10718|","SURAT","GUJARAT","0","93747 10718","MANOJ BHAI TEJASBHAI JARIWALA","93747 10718","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1674","A1674","URBAN JUNGGLE PRIVATE LIMITED","C-302 INDRAPRASTH TOWERNR. HIMALAYA MALL|24AACCU4909M1Z3|90999 19323|","AHMEDABAD","GUJARAT","0","90999 19323","TEJAS PATEL","90999 19323","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line KRISHNA MANSION
5/5/2022 9:13:10 AM : Exception  ### Exception of type 'System.Exception' was thrown.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line GHEE BAZAAR
5/5/2022 9:13:10 AM : Exception  ### Exception of type 'System.Exception' was thrown.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line |24AKXPA1540L1Z3|98980 08767|","AHMEDABAD","GUJARAT","390002","98980 08767","SUSHILBHAI AGRAWAL","98980 08767","0","0"
5/5/2022 9:13:10 AM : Exception  ### Exception of type 'System.Exception' was thrown.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1750","A1750","GREEN PEST CONTROL","F.F. - 4  PARAMNEAR PUSHTY|24AATFG7159D1Z5|95103 94052|","BARODA","GUJARAT","391 410","95103 94052","MANISH PATEL","95103 94052","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1909","A1909","NEW 24 SEVEN PEST CONTROL","DARSHAN COMPLEXBOPAL-GHUMA ROAD||9608739328|","AHMEDABAD","GUJARAT","380 058","9608739328","DEEPAK KUMAR","9608739328","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A191","A191","REX ENVIRONMENT SCIENCE PVT LTD","B-503 & 504 TITANIUM HEIGHTSOPP. VODAFONE HOUSE|24AAECR3383G1ZF|9898 33 8888|","AHMEDABAD","GUJARAT","0","9898 33 8888","DHAVAL BHATI","9898 33 8888","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1993","A1993","YAMRAJ.COM PRIVATE LIMITED","602 IVORY TERRACEOPP. CIRCUIT HOUSE R.C. DUTT ROAD|24AABCY1730F1ZQ|9825326936|","BARODA","GUJARAT","390007","9825326936","VIPUL SONI","9825326936","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2005","A2005","DNA PEST CONTROL TECHNOLOGIES","B-401 & 404 TIMES SQUARE-II BESIDE AVALON HOTEL OFF. SINDHUBHAVAN ROAD|24ALCPC1479J1ZA|74900 12344 |","AHMEDABAD","GUJARAT","0","74900 12344","PRADEEP LAL","74900 12344","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2011","A2011","THE 7 WAVES","OPP THE WATER SIDES.G HIGHWAY||9925856556|","AHMEDABAD","GUJARAT","0","9925856556","","9925856556","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2047","A2047","PRINCE PEST CONTROL","PLOT NO. 41 & 42/12B\H. ICE FACTORY||74054 09840|","HALOL","GUJARAT","389350","74054 09840","GIRISHBHAI","74054 09840","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2077","A2077","PHOENIX PEST MANAGEMENT SERVICES","A-601 LIFESTYLE ROYALE VAPI-DAMAN ROAD||8758142453|","VAPI","GUJARAT","396191","8758142453","SUMEET BENEGAL","8758142453","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2280","A2280","TATA PEST CONTROL","3 KADAMBARI SOCIETYNR. ASHAPURI MANDIR|24LGZPS8726F1ZC|76009 17565|","AHMEDABAD","GUJARAT","380 051","76009 17565","NARESHBHAI SUTARIYA","76009 17565","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A230","A230","H.P.C. CORPORATION","SECOND FLOOR SOPAN PALADIUMNR. METROPOLE HOTEL|24AACFH0765R1Z2|98250 31711|","AHMEDABAD","GUJARAT","0","98250 31711","JIGNESH TRIVEDI","98250 31711","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2311","A2311","SECURE SOLUTIONS","B/801 KAVERI TRISARANR. S.P. RING ROAD|24CNHPS7847D1ZO|9924099080|","AHMEDABAD","GUJARAT","0","9924099080","KRUNAL SHAH","9924099080","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2324","A2324","URBAN PEST CONTROL SERVICE","PLOT NO: 1608/S1 2ND FLOOR LABH COMPLEX |24AAGFU6566K1ZO|99245 01246(CHETANBHAI)|","GANDHINAGAR","GUJARAT","382006","99245 01246(CHETANBHAI)","CHETANBHAI","99245 01246(CHETANBHAI)","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2351","A2351","MODERN GRAMODYOG","BLOCK NO : 272 ZAK INDUSTRIAL AREA  VAHELAL - ZAK ROAD |24AHPPP5151P1ZO|97268 00570|","DEHGAM","GUJARAT","382330","97268 00570","HITESHBHAI (REF-N.K.SATPATHI ZAK)","97268 00570","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A236","A236","ITEM SECURE PVT LTD","601 & 602 IVORY TERRACER.C. DUTT ROAD OPP. CIRCUIT HOUSE|24AABCI8558F1ZI|98253 26936|","BARODA","GUJARAT","393 002","98253 26936","VIPUL SONI","98253 26936","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A239","A239","JALARAM FERTILISERS","NR. S.T.STANDDEHGAM ROAD|24AKGPP3890F1Z1|98257 02555|","AHMEDABAD","GUJARAT","0","98257 02555","","98257 02555","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2400","A2400","PESTOKIL INDIA","SHOP NO. 28 PLOT NO. 633FIRST FLOOR (OPP. HOTEL SLEEP INN.)|24EPOPR3432E1ZT|97253 60228|","GANDHINAGAR","GUJARAT","382421","97253 60228","PANKAJ YADAV","97253 60228","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2420","A2420","SAANVI PEST CONTROL","SHOP NO - 3 BUILDING NOB SAI SRUSHTI RESIDENCY|24EUXPP1878Q1Z9| 70690 75959|","VAPI","GUJARAT","396191","70690 75959","AJY BHAI PATEL","70690 75959","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2426","A2426","HANDY HOME SOLUTIONS PVT LTD","424 & 425 INDRAPRASTHA BUSINESS PARKMAKARBA|24AADCH5217L1ZM|87790 79753(SHAIL)|","AHMEDABAD","GUJARAT","380051","87790 79753(SHAIL)","","87790 79753(SHAIL)","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2468","A2468","MOTHER INDUSTRIES","BLOCK NO. 120ZAK - JALUNDRA ROAD|24AAUFM4776B1Z1|97268 00570|","DEHGAM","GUJARAT","382330","97268 00570","HITESHBHAI (REF. N K SATPATI)","97268 00570","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2645","A2645","SARASWATI PEST CONTROL","PLOT NO :238 SHOP NO: 06WARD NO: DC02||99787 03772|","GANDHIDHAM","GUJARAT","370201","99787 03772","VIVEK SAHANI","99787 03772","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A267","A267","NEW PATEL PEST CONTROL COMPANY","14 JIVAN PRAKASH SOC.NR.DARPAN SIX ROAD ||98250 19681|","AHMEDABAD","GUJARAT","0","98250 19681","PULIN PATEL","98250 19681","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2688","A2688","JAY YOGESHWAR PEST CONTROL","OPP. SARDAR MARKETKEVDABAUG||98240 59902|","BARODA","GUJARAT","0","98240 59902","YOGESHBHAI (JAY YOGESHWAR AGRO AGENCY)","98240 59902","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A270","A270","NILKANTH TRADERS","KRISHNA COMPLEXOPP. DHARA PETROL PUMP|24AATFN3046Q1ZL|99099 83028|","THOL","GUJARAT","0","99099 83028","ARVIND BHAI","99099 83028","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2741","A2741","ASIA PACIFIC PEST MANAGEMENT - BIHAR","POSTAL PARKROAD NO. 3A|10AWAPB1576E1ZD|70795 07048|","PATNA","BIHAR","800001","70795 07048","MANOJKUMAR BHAGAT","70795 07048","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2758","A2758","SHIVANI FINTRADE PVT.LTD.","KRISHNA HOUSE 8 D RAJHANS SOCIETYNEAR NABARD VIHAR HL COMMERCE COLLEGE|24AACCS1016M1ZL|98984 99935|","AHMEDABAD","GUJARAT","0","98984 99935","AMIT BHAI","98984 99935","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2823","A2823","AMERICAN PEST CONTROL","559/16 VRAJ NAGARI COMPLEXNR. TITANIUM CITY CENTRE||92652 55471|","AHMEDABAD","GUJARAT","380015","92652 55471","NILESH THAKOR","92652 55471","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2831","A2831","DEEP PEST MANAGEMENT PROFESSIONALS","7 GAUTAM COMPLEXNR SARASWATI COMPLEX BH HANS PARTY PLOT|24AMAPP7250P1ZO|95373 78484|","BARODA","GUJARAT","390011","95373 78484","MANISH PATEL","95373 78484","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2833","A2833","SHRI SAHJANAND SALES","||98243 02757|","GANDHINAGAR","GUJARAT","0","98243 02757","","98243 02757","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2839","A2839","KAILASH WOOD PRODUCT","R S NO:-815VILLAGE GHODASARNENPUR HALDARVAS ROAD|24AGSPL8912G2Z2|98252 30602|","MAHEMDABAD","GUJARAT","387110","98252 30602","NIRAV LIMABANI","98252 30602","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2850","A2850","PEST CONTROL ASSOCIATES (AMB) PVT LTD","ROOM NO. 4 3RD FLOOR7/10 BOTAWALA BUILDING|27AAFCP0260P1Z5|88793 35245|","MUMBAI","MAHARASTHRA","400 001","88793 35245","STEPHEN (VIREN MERCHANT MBI)","88793 35245","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2851","A2851","KRUSHI VIKASH BHANDAR","8 GROUND FLOORSURAT TRADE HOUSE|24AACFK9237B2ZM|9898293670  |","SURAT","GUJARAT","395004","9898293670","JAYDEEP J KADIVAR","9898293670","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A302","A302","PESTOP SERVICES","9 SHILPI SOCIETYB\H. ARUNACHAL SOCIETY |24AAEFP8917F1Z7|98792 43434|","BARODA","GUJARAT","0","98792 43434","NILESH  BHAI","98792 43434","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A331","A331","THE AMDAVAD CO OP F & V UNION",""KHEDUT SABHA"SARDAR PATEL MARKET|24AAAJT0298H1Z0|25323719|","AHMEDABAD","GUJARAT","0","25323719","AMARATBHAI PATEL","25323719","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A340","A340","APNA SEEDS & PESTICIDES","16-17 SARDAR PATEL MARKETJAMALPUR CROSS ROAD|24ALLPP1535F1Z8|98250 57248|","AHMEDABAD","GUJARAT","0","98250 57248","DHARMESH BHAI","98250 57248","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A349","A349","EXCELLENT PEST CONTROL","8/9 SWAMINARAYAN GURUKUL SHOPNR. G.E. BOARD|24AELPC5017L1ZM|98253 80385|AELPC5017L","SIDDHPUR","GUJARAT","0","98253 80385","MR. SAVIN CHATURVEDI","98253 80385","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A352","A352","EXPERT PEST CONTROL","PLOT NO 58SURVEY NO. 39 RAVECHIDHAM 2|24AXOPP3902H1ZE|94291 23338|","ADIPUR","GUJARAT","370205","94291 23338","NILESH PARMAR","94291 23338","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A356","A356","GUJARAT PEST CONTROL SERVICE","405 ANAND MILAN COMPLEXOPP. JAIN TEMPLE|24AINPB3049F1ZL|98243 10043|","AHMEDABAD","GUJARAT","0","98243 10043","NITIN BHAI","98243 10043","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A387","A387","SRI SIDDHI VINAYAK ENTERPRISE","B-2 VINAYAK PARKB/H. SHAIWALI BUS-STOP|24ADNPB4820F1ZZ|94261 82943|","AHMEDABAD","GUJARAT","0","94261 82943","PRAVINBHAI","94261 82943","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A411","A411","THAKOR PEST CONTROL SERVICES PVT LTD","51 CELLARNIRAV COMPLEX||98250 05838|","AHMEDABAD","GUJARAT","0","98250 05838","MR. DINESHBHAI THAKOR","98250 05838","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A436","A436","SANTOSH PEST CONTROL","23 ARJUN TOWERNR. PAYAL PARTY PLOT||98258 70030|","AHMEDABAD","GUJARAT","0","98258 70030","HITESH PATEL","98258 70030","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A438","A438","BAYER CROPSCIENCE LIMITED","E/1-3 TIRUPATI ESTATEDASKROI TALUKA|24AAACB9651K1ZJ||AAACB9651K","AHMEDABAD","GUJARAT","0","","","","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A440","A440","KARNAVATI PEST CONTROL","FIRST FLOOR MAVDI COMPLEXNR. RAMJI MANDIR||99987 62498|","AHMEDABAD","GUJARAT","0","99987 62498","KARTIK PRAJAPATI","99987 62498","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A526","A526","VAMAKSHI CONSULTANCY & SERVICE","G - BLOCK TARA BAUGHINSIDE POLYTECHNIC||93741 04090|","BARODA","GUJARAT","390 002","93741 04090","DHARMESH PUJARI","93741 04090","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A579","A579","ORCHEED INDIA PEST MANAGEMENT PVT LTD","711 VANIJAYA BHAVANDIVAN BALLUBHAI MARG|24AACCO4336J1ZI|98984 17300|AACCO4336J","AHMEDABAD","GUJARAT","0","98984 17300","KALPESH KOSHIT","98984 17300","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A588","A588","S & P PEST CONTROL SERVICE","C - GF 31 VICTORY SUNRISENR. WATER TANK|24ATLPT8233G1ZD|98983 15571|","AHMEDABAD","GUJARAT","","98983 15571","PRANV TRIVEDI","98983 15571","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A619","A619","HARI OM PEST CONTROL","21 1ST FLOOR VASUDEV PLAZA NR. UMIYA MATA MANDIR|24CCYPR5535H1ZY|85302 50302|","AHMEDABAD","GUJARAT","380058","85302 50302","JHORAWAR SING","85302 50302","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A680","A680","HARIOM WOOD PRODUCTS","18/A VILAGE -ZAKZAK INDUSTRIAL AREA |24AABFH8405P1Z6|96872 47201|","DEHGAM","GUJARAT","382325","96872 47201","","96872 47201","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A717","A717","ABHIYAN DECORATIVE INDIA LLP","SURVEY NO. 357TALUKA : DEHGAM|24ABLFA1693H1ZE|99790 00557|","KADADARA","GUJARAT","0","99790 00557","","99790 00557","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A776","A776","ALL IN ONE HOSPITALITIES SERVICES","F/201 FIRST FLOOR ANMOL AAGMAN CO.OP.HOU SOCIETY |24AHIPY6781H2ZO|98986 55129|","AHMEDABAD","GUJARAT","382 481.","98986 55129","AJAY YARDI","98986 55129","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A867","A867","PESTCARE INDIA PVT LTD","215/2 GANESH PLAZANR. AJIT MILL CROSS ROAD|24AAJCP0707F1ZS|98989 55586|","AHMEDABAD","GUJARAT","0","98989 55586","ABRAR RAJPUT","98989 55586","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A880","A880","HOME PEST CONTROL","B-27 SECTOR - 4NANDIGRAM OPP. NOBLE NAGAR|24AUEPC5159L1ZL|94091 74870|","AHMEDABAD","GUJARAT","0","94091 74870","HITESH KANTIBHAI CHAUHAN","94091 74870","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A95","A95","SURTI PEST CONTROL SERVICE","514\D SHIROMANI COMPLEXOPP. OCEAN PARK|24AEKFS5119L1ZP|079 26760106|AOBPS7340N","AHMEDABAD","GUJARAT","0","079 26760106","DHAVALBHAI SURTI","079 26760106","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A963","A963","JALARAM TRADING CORPORATION","FF - 3 NAVNEETPARK SOCIETYNR. SARVANAND HALL|24AMKPP3952E1Z0|98791 43553|","BARODA","GUJARAT","390 022","98791 43553","SHAILESH PANCHAL","98791 43553","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A965","A965","ARYAN PEST MANAGEMENT","613 LOHA BHAVANOPP.OLD HIGH COURT|24AAXFA5820D1ZJ|98250 24936|","AHMEDABAD","GUJARAT","0","98250 24936","","98250 24936","0","0
5/5/2022 9:13:10 AM : Exception  ### Input array is longer than the number of columns in this table.
5/5/2022 9:13:10 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3228822_TEMPLATE1.txt ### 5/5/2022 9:13:10 AM
5/5/2022 9:13:10 AM : Count:: ### TEMPLATE1:1
5/5/2022 9:13:10 AM : SP_DistributorTemplatePosting Successful --->>  ### 5/5/2022 9:13:10 AM
5/5/2022 9:13:10 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3513087_TEMPLATE1.TXT ### 5/5/2022 9:13:10 AM
5/5/2022 9:13:10 AM : Count:: ### TEMPLATE1:46
5/5/2022 9:13:16 AM : SP_DistributorTemplatePosting Successful --->>  ### 5/5/2022 9:13:16 AM
5/5/2022 9:13:16 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 5/5/2022 9:13:16 AM
5/5/2022 9:13:16 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 9:13:16 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 5/5/2022 9:13:16 AM
5/5/2022 9:13:16 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 9:13:16 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 5/5/2022 9:13:16 AM
5/5/2022 9:13:16 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 9:13:16 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 5/5/2022 9:13:16 AM
5/5/2022 9:13:16 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 9:13:16 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 5/5/2022 9:13:16 AM
5/5/2022 9:13:16 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 9:13:16 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 5/5/2022 9:13:16 AM
5/5/2022 9:13:16 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 9:13:16 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 5/5/2022 9:13:16 AM
5/5/2022 9:13:16 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 9:13:16 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060893_TEMPLATE1.txt ### 5/5/2022 9:13:16 AM
5/5/2022 9:13:16 AM : Count:: ### TEMPLATE1:63
5/5/2022 9:13:25 AM : SP_DistributorTemplatePosting Successful --->>  ### 5/5/2022 9:13:25 AM
5/5/2022 9:13:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 5/5/2022 9:13:25 AM
5/5/2022 9:13:25 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 9:13:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 5/5/2022 9:13:25 AM
5/5/2022 9:13:25 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 9:13:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 5/5/2022 9:13:25 AM
5/5/2022 9:13:25 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 9:13:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 5/5/2022 9:13:25 AM
5/5/2022 9:13:25 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 9:13:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 5/5/2022 9:13:25 AM
5/5/2022 9:13:25 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 9:13:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9064126_TEMPLATE1.txt ### 5/5/2022 9:13:25 AM
5/5/2022 9:13:25 AM : Count:: ### TEMPLATE1:2
5/5/2022 9:13:25 AM : SP_DistributorTemplatePosting Successful --->>  ### 5/5/2022 9:13:25 AM
5/5/2022 9:13:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_948223_TEMPLATE1.TXT ### 5/5/2022 9:13:25 AM
5/5/2022 9:13:25 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 9:13:25 AM : Template Import Complete  ### 5/5/2022 9:13:25 AM
5/5/2022 9:13:28 AM : Completed Updating Has Transaction Flag  ### 5/5/2022 9:13:28 AM
5/5/2022 9:13:28 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 5/5/2022 9:13:28 AM
5/5/2022 9:13:28 AM : Zylem Access Unblocked  ### 5/5/2022 9:13:28 AM
5/5/2022 9:13:28 AM : Application Ended  ### 5/5/2022 9:13:28 AM

5/5/2022 10:45:16 AM : Start Process : checkAllTablesExists()  ### Start
5/5/2022 10:45:16 AM : Import Start Time (NEW) For Nidhi Enterprises(3612379) ### 5/5/2022 10:45:16 AM
5/5/2022 10:45:16 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
5/5/2022 10:45:17 AM : For Distributor 000000000001321 Insert Count::32 ### Delete Count::0
5/5/2022 10:45:17 AM : Import AD File --->> AD_1321_20220505_bc1bc0f89d4ca6ba6bf86c67c296dfbf.TXT ### 5/5/2022 10:45:17 AM
5/5/2022 10:45:17 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
5/5/2022 10:45:17 AM : Import Masters Completed Nidhi Enterprises(3612379) ### 5/5/2022 10:45:17 AM
5/5/2022 10:45:17 AM : Start Process : ImportSplittedFilesOldDeleteInsert()  ###  called 
5/5/2022 10:45:17 AM : splitFileDaywiseNewNaming  ###  called 
5/5/2022 10:45:17 AM : splitFileDaywiseNewNaming  ###  called 
5/5/2022 10:45:17 AM : command:: ### Delete Unlinked DN
5/5/2022 10:45:17 AM : command:: ### Delete Unlinked DN
5/5/2022 10:45:17 AM : command:: ### Delete SPLITFILEINFO DN
5/5/2022 10:45:17 AM : Import DN File --->> DN_1321_20211008_f8bdcbf0e2fd41e8bf4a3f554965ee14.TXT ### 5/5/2022 10:45:17 AM
5/5/2022 10:45:17 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:17 AM : Import DN File --->> DN_1321_20211009_0b968580a44f88280badfedba9f60839.TXT ### 5/5/2022 10:45:17 AM
5/5/2022 10:45:17 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:17 AM : Import DN File --->> DN_1321_20211018_19c37990cbbee9b4daf44760ac019cd3.TXT ### 5/5/2022 10:45:17 AM
5/5/2022 10:45:17 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:18 AM : Import DN File --->> DN_1321_20211110_3f705f868225ce567ef7576ce5c8c036.TXT ### 5/5/2022 10:45:18 AM
5/5/2022 10:45:18 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::2
5/5/2022 10:45:18 AM : Import DN File --->> DN_1321_20211118_cddb1720f8cd02532f49d45b07dc408d.TXT ### 5/5/2022 10:45:18 AM
5/5/2022 10:45:18 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::5
5/5/2022 10:45:18 AM : Import DN File --->> DN_1321_20211125_fa409a18290b74ed275998c51eab7d0c.TXT ### 5/5/2022 10:45:18 AM
5/5/2022 10:45:18 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:18 AM : Import DN File --->> DN_1321_20220120_ae25fa4eb6a945c93062fbbca48ba4f9.TXT ### 5/5/2022 10:45:18 AM
5/5/2022 10:45:18 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::2
5/5/2022 10:45:19 AM : Import DN File --->> DN_1321_20220217_c46c783319e5bd347ba229456ae1d2d1.TXT ### 5/5/2022 10:45:19 AM
5/5/2022 10:45:19 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::2
5/5/2022 10:45:19 AM : command:: flagImportPosting =  ### True
5/5/2022 10:45:19 AM : command:: minDate =  ### 10/1/2021 12:00:00 AM
5/5/2022 10:45:19 AM : splitFileDaywiseNewNaming  ###  called 
5/5/2022 10:45:20 AM : command:: ### Delete Unlinked IN
5/5/2022 10:45:20 AM : command:: ### Delete Unlinked IN
5/5/2022 10:45:20 AM : command:: ### Delete SPLITFILEINFO IN
5/5/2022 10:45:20 AM : Import IN File --->> IN_1321_20211002_e5e35632822e6ed6d6c61e69cae188c8.TXT ### 5/5/2022 10:45:20 AM
5/5/2022 10:45:20 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::10
5/5/2022 10:45:20 AM : Import IN File --->> IN_1321_20211005_15cb50e256e487042e60a27728bcc9d6.TXT ### 5/5/2022 10:45:20 AM
5/5/2022 10:45:20 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::6
5/5/2022 10:45:20 AM : Import IN File --->> IN_1321_20211006_b447419671520377ba6d0885227ce300.TXT ### 5/5/2022 10:45:20 AM
5/5/2022 10:45:20 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::6
5/5/2022 10:45:20 AM : Import IN File --->> IN_1321_20211007_e10891aa3d92d6ad0be5f9a30e35c8d3.TXT ### 5/5/2022 10:45:20 AM
5/5/2022 10:45:20 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::3
5/5/2022 10:45:20 AM : Import IN File --->> IN_1321_20211008_90c17387ce6f8700cf78cb59b7511793.TXT ### 5/5/2022 10:45:20 AM
5/5/2022 10:45:20 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::6
5/5/2022 10:45:20 AM : Import IN File --->> IN_1321_20211009_ec1a009edd90282c4d1c16e40d9c3f4a.TXT ### 5/5/2022 10:45:20 AM
5/5/2022 10:45:20 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::4
5/5/2022 10:45:20 AM : Import IN File --->> IN_1321_20211011_f24cf575c10d49d46eaf8582bb03229f.TXT ### 5/5/2022 10:45:20 AM
5/5/2022 10:45:20 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::4
5/5/2022 10:45:20 AM : Import IN File --->> IN_1321_20211012_2a0ceb8f7fd330bd968f8b27d1c63ca4.TXT ### 5/5/2022 10:45:20 AM
5/5/2022 10:45:20 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::3
5/5/2022 10:45:20 AM : Import IN File --->> IN_1321_20211013_0f4d6f7065d2fd0d0a3fba89e2320cbd.TXT ### 5/5/2022 10:45:20 AM
5/5/2022 10:45:20 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::2
5/5/2022 10:45:20 AM : Import IN File --->> IN_1321_20211014_562762301f66978c4643c36d3a4b0800.TXT ### 5/5/2022 10:45:20 AM
5/5/2022 10:45:20 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::4
5/5/2022 10:45:20 AM : Import IN File --->> IN_1321_20211016_2172170f198af5d53d07fd31e41b695e.TXT ### 5/5/2022 10:45:20 AM
5/5/2022 10:45:20 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:20 AM : Import IN File --->> IN_1321_20211020_0f4c3a960e50a828613f59d607cf0c8d.TXT ### 5/5/2022 10:45:20 AM
5/5/2022 10:45:20 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::6
5/5/2022 10:45:20 AM : Import IN File --->> IN_1321_20211021_e179030dea5a925333d35e872608bac2.TXT ### 5/5/2022 10:45:20 AM
5/5/2022 10:45:20 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::3
5/5/2022 10:45:20 AM : Import IN File --->> IN_1321_20211022_c9eaf41c13833549391c69e62ee540cc.TXT ### 5/5/2022 10:45:20 AM
5/5/2022 10:45:20 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::2
5/5/2022 10:45:20 AM : Import IN File --->> IN_1321_20211023_72750ff2a5a11f9fa5bce2ee1d73a811.TXT ### 5/5/2022 10:45:20 AM
5/5/2022 10:45:20 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::3
5/5/2022 10:45:20 AM : Import IN File --->> IN_1321_20211025_74a0ee627bcf45d06f1ec5128d8af6f5.TXT ### 5/5/2022 10:45:20 AM
5/5/2022 10:45:20 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:20 AM : Import IN File --->> IN_1321_20211027_115bc4fddb770f5131efc1b87eea573e.TXT ### 5/5/2022 10:45:20 AM
5/5/2022 10:45:20 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::2
5/5/2022 10:45:20 AM : Import IN File --->> IN_1321_20211028_4b0bc1eb09f81b5ebf318d46f0f71742.TXT ### 5/5/2022 10:45:20 AM
5/5/2022 10:45:20 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::2
5/5/2022 10:45:20 AM : Import IN File --->> IN_1321_20211029_3858ad38bb95fe342ee26326e7bc3787.TXT ### 5/5/2022 10:45:20 AM
5/5/2022 10:45:20 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:20 AM : Import IN File --->> IN_1321_20211101_9bc07a28724b85d5258865c444938e14.TXT ### 5/5/2022 10:45:20 AM
5/5/2022 10:45:20 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::4
5/5/2022 10:45:20 AM : Import IN File --->> IN_1321_20211102_25f704b2ee6340e960dc6d08beae6cbd.TXT ### 5/5/2022 10:45:20 AM
5/5/2022 10:45:20 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::3
5/5/2022 10:45:20 AM : Import IN File --->> IN_1321_20211103_544117979a04198a822248ec1dea3630.TXT ### 5/5/2022 10:45:20 AM
5/5/2022 10:45:20 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::2
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20211108_329681c757ce2164a3d807a009f231fb.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::5
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20211109_28c5cc11bb6384c3b91d0e10c9e927d8.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::8
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20211110_3c6867cbaf4f503ecd4a7ee10f77ec12.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::4
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20211111_8525a277a69d2b0855357cb85aa342de.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::2
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20211116_634d48573b2c3a94c0fa87c746793b21.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20211119_904a96fa062808c9eac581bef5a4253c.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20211122_0d31f35dae747a852688cc6106412c25.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::3
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20211129_6fa597455a3e94bf3e96cb172ebadd4d.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::2
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20211130_aa4a8364408c65cf07c07420bd4ca59f.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20211201_8204fab76a49c3d353df148b98bb29da.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::5
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20211203_c7805249e396bf651871039495e51021.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::3
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20211204_7237c7c65b5467051624fcc9b314757a.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::2
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20211206_4c265361cb934ccdbfddb507e6aaadd2.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::4
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20211208_d13d39c6842d96a64ad104c7365112a5.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20211209_2be6bcc4baa5f40dd05401dcb015626c.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20211211_07164e0381df1b9705eb2b921aefe3d1.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::4
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20211213_4f7803705aeb9e99df1d586e124b167a.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::2
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20211214_c8fd5065ebb41002a9e35786f26864f8.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::13
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20211216_6c38e3f3b487dfbc9e949bee6380f1eb.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20211217_6535524325e8b16fce53d4eb37a4cce8.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::3
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20211220_c114e3dd620507b92eeeb5d861135681.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::5
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20211221_1cc19cf9b4b9a7cef39ca9a230090129.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20211222_2ba433ad9f4366797ce94c1240c5aee7.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::3
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20211230_292da955920ca6ea4275e4baac5acf0e.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::5
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20211231_ec3ff9ee53f0bcfcd5f91232c1c7ad8d.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::6
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20220103_e09652bbf7bc03272550802fab7bc2fe.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20220104_abe7822062e9231c7b5fcd1711c7a22c.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:21 AM : Import IN File --->> IN_1321_20220111_6910e4291fdd1f4a54fb4537941892b8.TXT ### 5/5/2022 10:45:21 AM
5/5/2022 10:45:21 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220114_a933f1a1b60ed4efaae5a57de7607c9b.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::7
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220115_268e80c6594fa61e925c014e643f92d9.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::7
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220117_de73573822d96be05dae0e9e97c655a2.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::4
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220118_9b8717d811379fd3900d1e8e39f6e1c9.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::3
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220120_abc24f4ab7ece53d3325fb9e78aef0e8.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::2
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220128_001baa034a38c042b19b633f466def03.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220131_5f037838220b00993d2bca2ccf7afc5d.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220208_43553188304698f830b614ea02aacfd1.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::2
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220212_ff6532f6fdef8bc6fdade79012945afc.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220215_3b338eed6b6a6a4e90024d4169275212.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220219_09d7a4358477ec6c816f28fd58bb324c.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220222_e20657f4f31e532d3113f6b1e9f0e485.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::2
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220301_433fc6b355d9ed6048de79f730cea0d3.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220303_ad38a5a5c7d0c79ad8b614eedd268211.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::2
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220307_067dad28cc374734fec0d03f2652e9f3.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220309_9ee7126613814203487b918df3fe0981.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220311_e5a5a845cc15f7bab0ca4a15ef8c168e.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::2
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220312_8eb9aeb3ef6321dbce69bec27a67099e.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::6
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220314_99dabd28f378c206c66aa74801df8dfa.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220315_8c307504385c04df3ecd19b464262c52.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::2
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220317_dab6cbf5fc338a9ddcc6a626a9d860fd.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220319_afeda06fe71adf4818d9a460272e4571.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220321_c4418c01532c88380349e28d14b848b8.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::4
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220322_d846352d2150f8620ed4cf0391c66c37.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220323_49399c180eb4b14de92bb86d7f09a051.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::4
5/5/2022 10:45:22 AM : Import IN File --->> IN_1321_20220324_aaa70a467d41e3ccb80b1ce03ebc2087.TXT ### 5/5/2022 10:45:22 AM
5/5/2022 10:45:22 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::3
5/5/2022 10:45:23 AM : Import IN File --->> IN_1321_20220325_505eaa210c9a610f0459bf6ae9768b2b.TXT ### 5/5/2022 10:45:23 AM
5/5/2022 10:45:23 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:23 AM : Import IN File --->> IN_1321_20220326_32a3f9a51f4663774305203b0d2afe5e.TXT ### 5/5/2022 10:45:23 AM
5/5/2022 10:45:23 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:23 AM : Import IN File --->> IN_1321_20220328_91cefc5ada2ddc5931a57144ebefd7dc.TXT ### 5/5/2022 10:45:23 AM
5/5/2022 10:45:23 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 10:45:23 AM : Import IN File --->> IN_1321_20220330_47ae428583657dfe237fc3649ee9c41c.TXT ### 5/5/2022 10:45:23 AM
5/5/2022 10:45:23 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::2
5/5/2022 10:45:23 AM : Import IN File --->> IN_1321_20220331_a5812c91982fb873b0d734d6c4ee209c.TXT ### 5/5/2022 10:45:23 AM
5/5/2022 10:45:23 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::3
5/5/2022 10:45:23 AM : command:: flagImportPosting =  ### True
5/5/2022 10:45:23 AM : command:: minDate =  ### 10/1/2021 12:00:00 AM
5/5/2022 10:45:24 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 5/5/2022 10:45:24 AM
5/5/2022 10:45:25 AM : CustomerLink Diff Successful --->>  ### 5/5/2022 10:45:25 AM
5/5/2022 10:45:26 AM : ItemLink Diff Successful --->>  ### 5/5/2022 10:45:26 AM
5/5/2022 10:45:26 AM : Supplierlink Query Successful --->>  ### 5/5/2022 10:45:26 AM
5/5/2022 10:45:26 AM : Posting Purchases 'true' Successful --->>  ### 5/5/2022 10:45:26 AM
5/5/2022 10:45:27 AM : Posting OtherTransaction 'true' Successful --->>  ### 5/5/2022 10:45:27 AM
5/5/2022 10:50:07 AM : Posting Sales 'true' Successful --->>  ### 5/5/2022 10:50:07 AM
5/5/2022 10:50:10 AM : Completed Updating Has Transaction Flag  ### 5/5/2022 10:50:10 AM
5/5/2022 10:50:10 AM : command :: PostDataDeleteInsert  ###  Done 
5/5/2022 10:50:10 AM : command :: set DiffCutOffDate  ###  Done 
5/5/2022 10:50:10 AM : End Process : ImportSplittedFilesOldDeleteInsert()  ### 

5/5/2022 10:50:10 AM : Import End Time (NEW) Nidhi Enterprises(3612379) ### 5/5/2022 10:50:10 AM
5/5/2022 10:50:10 AM : -------------Import One Distributor End Time----------- ### 5/5/2022 10:50:10 AM
5/5/2022 2:30:03 PM : Start Process : checkAllTablesExists()  ### Driver={SQL Server};Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
5/5/2022 2:30:09 PM : StartProcess  ### 5/5/2022 2:30:09 PM

5/5/2022 2:30:09 PM : 11  ### 5/5/2022 2:30:09 PM

5/5/2022 2:30:09 PM : 22  ### 5/5/2022 2:30:09 PM

5/5/2022 2:30:09 PM : 33  ### 5/5/2022 2:30:09 PM

5/5/2022 2:30:09 PM : Application Started  ### 5/5/2022 2:30:09 PM

5/5/2022 2:30:09 PM : Start Process : checkAllTablesExists()  ### 
5/5/2022 2:30:11 PM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 5/5/2022 2:30:11 PM
5/5/2022 2:30:11 PM : MainForm_Load  ### AlertSystem ON
5/5/2022 2:30:12 PM : No. of Files to import (RECEIVEFINAL):  ### 1267
5/5/2022 2:30:12 PM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
5/5/2022 2:30:15 PM : For Distributor 000000000001316 Insert Count::4 ### Delete Count::0
5/5/2022 2:30:15 PM : Import AD File --->> AD_1316_20220505_63e84912b43b0b1edecd89c90f417214.TXT ### 5/5/2022 2:30:15 PM
5/5/2022 2:30:18 PM : For Distributor 000000000001321 Insert Count::8 ### Delete Count::38
5/5/2022 2:30:18 PM : Import AD File --->> AD_1321_20220505_3a35e7be68e6a05830143b13a56b9ba6.TXT ### 5/5/2022 2:30:18 PM
5/5/2022 2:30:21 PM : For Distributor 000000000001324 Insert Count::1 ### Delete Count::0
5/5/2022 2:30:21 PM : Import AD File --->> AD_1324_20220505_621077951eb7a85c297696db778490b5.TXT ### 5/5/2022 2:30:21 PM
5/5/2022 2:30:23 PM : For Distributor 000000000000354 Insert Count::7 ### Delete Count::7
5/5/2022 2:30:23 PM : Import AD File --->> AD_354_20220505_54ad0656f7f334a4e91dee2bc6fba89a.TXT ### 5/5/2022 2:30:23 PM
5/5/2022 2:30:26 PM : For Distributor 000000000000366 Insert Count::5 ### Delete Count::0
5/5/2022 2:30:26 PM : Import AD File --->> AD_366_20220505_70dc6af62f65b26922ef263a7172f7f3.TXT ### 5/5/2022 2:30:26 PM
5/5/2022 2:30:28 PM : For Distributor 000000000000371 Insert Count::9 ### Delete Count::0
5/5/2022 2:30:28 PM : Import AD File --->> AD_371_20220505_a963438110d3e93e7a5a324d6393847e.TXT ### 5/5/2022 2:30:28 PM
5/5/2022 2:30:30 PM : For Distributor 000000000000372 Insert Count::11 ### Delete Count::24
5/5/2022 2:30:30 PM : Import AD File --->> AD_372_20220505_90a6957cc844373bccbcd0020bded97c.TXT ### 5/5/2022 2:30:30 PM
5/5/2022 2:30:34 PM : For Distributor 000000000000373 Insert Count::5 ### Delete Count::0
5/5/2022 2:30:34 PM : Import AD File --->> AD_373_20220505_32cd47ae7662abd72a34f30e7c945794.TXT ### 5/5/2022 2:30:34 PM
5/5/2022 2:30:36 PM : For Distributor 000000000000424 Insert Count::1 ### Delete Count::0
5/5/2022 2:30:36 PM : Import AD File --->> AD_424_20220505_8e7a53053be11e4c45e6c29ec192af7e.TXT ### 5/5/2022 2:30:36 PM
5/5/2022 2:30:38 PM : For Distributor 000000000000665 Insert Count::7 ### Delete Count::0
5/5/2022 2:30:38 PM : Import AD File --->> AD_665_20220505_e9a53b3d7bc3406d8475e9558423a86f.TXT ### 5/5/2022 2:30:38 PM
5/5/2022 2:30:41 PM : For Distributor 000000000000815 Insert Count::1 ### Delete Count::30
5/5/2022 2:30:41 PM : Import AD File --->> AD_815_20220505_54613247537eed35c8c51ddbf7e98722.TXT ### 5/5/2022 2:30:41 PM
5/5/2022 2:31:11 PM : For Distributor 000000000001321 Insert Count::7 ### Delete Count::7
5/5/2022 2:31:11 PM : Import DN File --->> DN_1321_20220407_81ed4b717d33f9d6bb9739612be88dce.TXT ### 5/5/2022 2:31:11 PM
5/5/2022 2:31:55 PM : Import DN File --->> DN_354_20220310_0aca62c006c5f407c3d5c60616f1c2cc.TXT ### 5/5/2022 2:31:55 PM
5/5/2022 2:31:55 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::8
5/5/2022 2:31:57 PM : Import DN File --->> DN_354_20220312_8763eb7909dd5ae2cf63c0b4da3f8ff6.TXT ### 5/5/2022 2:31:57 PM
5/5/2022 2:31:57 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::1
5/5/2022 2:32:16 PM : Import DN File --->> DN_354_20220406_f3f481d7e1b01b16d240a2c35a2b934e.TXT ### 5/5/2022 2:32:16 PM
5/5/2022 2:32:16 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::2
5/5/2022 2:32:21 PM : Import DN File --->> DN_354_20220427_929af8c35bfedc7a4878613ad8887df3.TXT ### 5/5/2022 2:32:21 PM
5/5/2022 2:32:21 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::4
5/5/2022 2:32:38 PM : Import DN File --->> DN_360_20220505_30d2743f3535fcd4ca6cea979f692202.TXT ### 5/5/2022 2:32:38 PM
5/5/2022 2:32:38 PM : NO Previous File For Distributor 000000000000360 ### Insert Count::1
5/5/2022 2:32:45 PM : For Distributor 000000000000365 Insert Count::1 ### Delete Count::0
5/5/2022 2:32:45 PM : Import DN File --->> DN_365_20220427_35a3751c459654127d0588f7a64307ce.TXT ### 5/5/2022 2:32:45 PM
5/5/2022 2:33:03 PM : For Distributor 000000000000371 Insert Count::14 ### Delete Count::0
5/5/2022 2:33:03 PM : Import DN File --->> DN_371_20220503_843aea9542cd546c643e8639b349e2c3.TXT ### 5/5/2022 2:33:03 PM
5/5/2022 2:33:43 PM : Import DN File --->> DN_815_20220504_c653d9c4245cc4003d908d2c38d683b7.TXT ### 5/5/2022 2:33:43 PM
5/5/2022 2:33:43 PM : NO Previous File For Distributor 000000000000815 ### Insert Count::5
5/5/2022 2:33:59 PM : For Distributor 000000000001316 Insert Count::9 ### Delete Count::0
5/5/2022 2:33:59 PM : Import IN File --->> IN_1316_20220505_6fa2199665bc0c7ae3c74db8427622af.TXT ### 5/5/2022 2:33:59 PM
5/5/2022 2:34:11 PM : For Distributor 000000000001321 Insert Count::4 ### Delete Count::0
5/5/2022 2:34:11 PM : Import IN File --->> IN_1321_20220409_564f6e33c4d6334613cd5b3f9a6c461c.TXT ### 5/5/2022 2:34:11 PM
5/5/2022 2:34:11 PM : For Distributor 000000000001321 Insert Count::2 ### Delete Count::0
5/5/2022 2:34:11 PM : Import IN File --->> IN_1321_20220411_623cd4806dfeb291b679d5a63786091e.TXT ### 5/5/2022 2:34:11 PM
5/5/2022 2:34:12 PM : For Distributor 000000000001321 Insert Count::2 ### Delete Count::0
5/5/2022 2:34:12 PM : Import IN File --->> IN_1321_20220412_660b904d47a825243817839e879d2192.TXT ### 5/5/2022 2:34:12 PM
5/5/2022 2:34:12 PM : For Distributor 000000000001321 Insert Count::1 ### Delete Count::0
5/5/2022 2:34:12 PM : Import IN File --->> IN_1321_20220413_5b23c2a1efca59bace03322ffddedc73.TXT ### 5/5/2022 2:34:12 PM
5/5/2022 2:34:13 PM : For Distributor 000000000001321 Insert Count::1 ### Delete Count::0
5/5/2022 2:34:13 PM : Import IN File --->> IN_1321_20220414_d3d17d473ad16ebfe7b50a325e4bc18e.TXT ### 5/5/2022 2:34:13 PM
5/5/2022 2:34:14 PM : For Distributor 000000000001321 Insert Count::6 ### Delete Count::0
5/5/2022 2:34:14 PM : Import IN File --->> IN_1321_20220415_71d97f0ffaf36fef78789fc67606f37a.TXT ### 5/5/2022 2:34:14 PM
5/5/2022 2:34:14 PM : For Distributor 000000000001321 Insert Count::1 ### Delete Count::0
5/5/2022 2:34:14 PM : Import IN File --->> IN_1321_20220416_37ce47b18d832e2c4ac3286f2e90dd99.TXT ### 5/5/2022 2:34:14 PM
5/5/2022 2:34:15 PM : For Distributor 000000000001321 Insert Count::2 ### Delete Count::0
5/5/2022 2:34:15 PM : Import IN File --->> IN_1321_20220419_b9a40c104a4cbe41d278bef631f9e77d.TXT ### 5/5/2022 2:34:15 PM
5/5/2022 2:34:16 PM : For Distributor 000000000001321 Insert Count::1 ### Delete Count::0
5/5/2022 2:34:16 PM : Import IN File --->> IN_1321_20220421_64439fdc998e4965de8d5ad471b7f68d.TXT ### 5/5/2022 2:34:16 PM
5/5/2022 2:34:17 PM : For Distributor 000000000001321 Insert Count::1 ### Delete Count::0
5/5/2022 2:34:17 PM : Import IN File --->> IN_1321_20220423_f785fbc27d2385cff5e83054cc838e51.TXT ### 5/5/2022 2:34:17 PM
5/5/2022 2:34:18 PM : For Distributor 000000000001321 Insert Count::2 ### Delete Count::0
5/5/2022 2:34:18 PM : Import IN File --->> IN_1321_20220425_ef62c7dc36dbb82d206f0944369667e3.TXT ### 5/5/2022 2:34:18 PM
5/5/2022 2:34:18 PM : For Distributor 000000000001321 Insert Count::1 ### Delete Count::0
5/5/2022 2:34:18 PM : Import IN File --->> IN_1321_20220427_321d3a76b705a1c3d849ca0bdaf200eb.TXT ### 5/5/2022 2:34:18 PM
5/5/2022 2:34:19 PM : Import IN File --->> IN_1321_20220429_52220bc9d0c341869b5d64729a1dcb1e.TXT ### 5/5/2022 2:34:19 PM
5/5/2022 2:34:19 PM : NO Previous File For Distributor 000000000001321 ### Insert Count::2
5/5/2022 2:34:19 PM : Import IN File --->> IN_1321_20220430_406fec470aac13a408b7d1ea117f270b.TXT ### 5/5/2022 2:34:19 PM
5/5/2022 2:34:19 PM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 2:34:20 PM : Import IN File --->> IN_1321_20220502_19d238864329bb4602ce2d36f48a822a.TXT ### 5/5/2022 2:34:20 PM
5/5/2022 2:34:20 PM : NO Previous File For Distributor 000000000001321 ### Insert Count::3
5/5/2022 2:34:20 PM : Import IN File --->> IN_1321_20220504_c7030566317a000f8f3079c3a549c47f.TXT ### 5/5/2022 2:34:20 PM
5/5/2022 2:34:20 PM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
5/5/2022 2:34:26 PM : For Distributor 000000000001324 Insert Count::1 ### Delete Count::0
5/5/2022 2:34:26 PM : Import IN File --->> IN_1324_20220424_45767b17089ce800fb03df29f0945c68.TXT ### 5/5/2022 2:34:26 PM
5/5/2022 2:34:27 PM : For Distributor 000000000001324 Insert Count::4 ### Delete Count::0
5/5/2022 2:34:27 PM : Import IN File --->> IN_1324_20220427_be128e7f5639ce283e37f92fd4a0bc47.TXT ### 5/5/2022 2:34:27 PM
5/5/2022 2:34:28 PM : For Distributor 000000000001324 Insert Count::1 ### Delete Count::0
5/5/2022 2:34:28 PM : Import IN File --->> IN_1324_20220428_28c2017abb185153ab750743c525c6c1.TXT ### 5/5/2022 2:34:28 PM
5/5/2022 2:34:28 PM : For Distributor 000000000001324 Insert Count::7 ### Delete Count::0
5/5/2022 2:34:28 PM : Import IN File --->> IN_1324_20220430_d52881f8ddcdef46c9875f56091f4485.TXT ### 5/5/2022 2:34:28 PM
5/5/2022 2:34:29 PM : For Distributor 000000000001324 Insert Count::9 ### Delete Count::0
5/5/2022 2:34:29 PM : Import IN File --->> IN_1324_20220504_88e67ce94269f663db6d60835cb6519b.TXT ### 5/5/2022 2:34:29 PM
5/5/2022 2:34:31 PM : For Distributor 000000000000354 Insert Count::1 ### Delete Count::0
5/5/2022 2:34:31 PM : Import IN File --->> IN_354_20220304_d54545f2af2bfce93fcb1d9dd5d2e4d4.TXT ### 5/5/2022 2:34:31 PM
5/5/2022 2:34:31 PM : For Distributor 000000000000354 Insert Count::8 ### Delete Count::0
5/5/2022 2:34:31 PM : Import IN File --->> IN_354_20220305_8b82b4b4145222238283beb5ac35fd12.TXT ### 5/5/2022 2:34:31 PM
5/5/2022 2:34:33 PM : For Distributor 000000000000354 Insert Count::4 ### Delete Count::0
5/5/2022 2:34:33 PM : Import IN File --->> IN_354_20220307_714b662bb9bab692085563f855ae2e14.TXT ### 5/5/2022 2:34:33 PM
5/5/2022 2:34:33 PM : Import IN File --->> IN_354_20220309_26197d2b06f2c3f36f36659cb2e7c4bc.TXT ### 5/5/2022 2:34:33 PM
5/5/2022 2:34:33 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::3
5/5/2022 2:34:34 PM : Import IN File --->> IN_354_20220310_037fd2f3c5354d2a900b79a037e86a56.TXT ### 5/5/2022 2:34:34 PM
5/5/2022 2:34:34 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::3
5/5/2022 2:34:35 PM : Import IN File --->> IN_354_20220314_d5d57c06a092a1574ff8512a110c882f.TXT ### 5/5/2022 2:34:35 PM
5/5/2022 2:34:35 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::6
5/5/2022 2:34:35 PM : Import IN File --->> IN_354_20220315_90e6ed1f7d61a80b8323c67b574c2a70.TXT ### 5/5/2022 2:34:35 PM
5/5/2022 2:34:35 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::2
5/5/2022 2:34:36 PM : Import IN File --->> IN_354_20220318_f99279c7a3b6c15df289f04e2425c610.TXT ### 5/5/2022 2:34:36 PM
5/5/2022 2:34:36 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::1
5/5/2022 2:34:37 PM : Import IN File --->> IN_354_20220319_fa67ba3dd7b23604e775ba2dd1176a86.TXT ### 5/5/2022 2:34:37 PM
5/5/2022 2:34:37 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::2
5/5/2022 2:34:37 PM : Import IN File --->> IN_354_20220322_ce4e80661512e0047ad145afdd371de6.TXT ### 5/5/2022 2:34:37 PM
5/5/2022 2:34:37 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::2
5/5/2022 2:34:37 PM : Import IN File --->> IN_354_20220323_ead052356600697aefc3d25cc9b5503b.TXT ### 5/5/2022 2:34:37 PM
5/5/2022 2:34:37 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::4
5/5/2022 2:34:38 PM : Import IN File --->> IN_354_20220325_1ed8e4168235fcb782574ac74614a93b.TXT ### 5/5/2022 2:34:38 PM
5/5/2022 2:34:38 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::3
5/5/2022 2:34:38 PM : Import IN File --->> IN_354_20220326_419a359b13452248c411f1d96b04f7ad.TXT ### 5/5/2022 2:34:38 PM
5/5/2022 2:34:38 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::2
5/5/2022 2:34:38 PM : Import IN File --->> IN_354_20220330_6737c10d974a6d03174f788b7378fd8b.TXT ### 5/5/2022 2:34:38 PM
5/5/2022 2:34:38 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::2
5/5/2022 2:34:39 PM : Import IN File --->> IN_354_20220401_885f5244efbe7995fa2d73163bfd8f51.TXT ### 5/5/2022 2:34:39 PM
5/5/2022 2:34:39 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::2
5/5/2022 2:34:39 PM : Import IN File --->> IN_354_20220402_df88b78a729202fc44c408d494a59dc6.TXT ### 5/5/2022 2:34:39 PM
5/5/2022 2:34:39 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::1
5/5/2022 2:34:39 PM : Import IN File --->> IN_354_20220404_b30c31057c777d8f4814402839e0bb7c.TXT ### 5/5/2022 2:34:39 PM
5/5/2022 2:34:39 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::1
5/5/2022 2:34:40 PM : Import IN File --->> IN_354_20220405_aea2e50a76fda2543b5f64cbb53bf24d.TXT ### 5/5/2022 2:34:40 PM
5/5/2022 2:34:40 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::2
5/5/2022 2:34:40 PM : Import IN File --->> IN_354_20220406_f817d3228ccf983a63b38a89c43a16e7.TXT ### 5/5/2022 2:34:40 PM
5/5/2022 2:34:40 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::1
5/5/2022 2:34:41 PM : Import IN File --->> IN_354_20220408_2f779ce86a28dd655cb7a91e332892f6.TXT ### 5/5/2022 2:34:41 PM
5/5/2022 2:34:41 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::2
5/5/2022 2:34:41 PM : Import IN File --->> IN_354_20220409_ece1c6c58fb0a81b05d15a05994bbb5f.TXT ### 5/5/2022 2:34:41 PM
5/5/2022 2:34:41 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::1
5/5/2022 2:34:41 PM : Import IN File --->> IN_354_20220412_01c0419d4badbc3849268170ab434d2e.TXT ### 5/5/2022 2:34:41 PM
5/5/2022 2:34:41 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::1
5/5/2022 2:34:42 PM : Import IN File --->> IN_354_20220416_17808d196358368302e4ff8dc7f6d195.TXT ### 5/5/2022 2:34:42 PM
5/5/2022 2:34:42 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::1
5/5/2022 2:34:43 PM : Import IN File --->> IN_354_20220418_32c7ee98ed14e0fcbfd87a8651762cbf.TXT ### 5/5/2022 2:34:43 PM
5/5/2022 2:34:43 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::3
5/5/2022 2:34:43 PM : Import IN File --->> IN_354_20220419_5cff5ecb3077e896f355d2285a80f7c0.TXT ### 5/5/2022 2:34:43 PM
5/5/2022 2:34:43 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::1
5/5/2022 2:34:43 PM : Import IN File --->> IN_354_20220420_a90b8be656967ae6156c3f3c4f0f0178.TXT ### 5/5/2022 2:34:43 PM
5/5/2022 2:34:43 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::2
5/5/2022 2:34:43 PM : Import IN File --->> IN_354_20220421_c0f5fdb90a75f053fc8ddd5d6770c7ff.TXT ### 5/5/2022 2:34:43 PM
5/5/2022 2:34:43 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::1
5/5/2022 2:34:43 PM : Import IN File --->> IN_354_20220422_0b821c495e7319f5556214598b8b29b6.TXT ### 5/5/2022 2:34:43 PM
5/5/2022 2:34:43 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::5
5/5/2022 2:34:44 PM : Import IN File --->> IN_354_20220423_e3d685513dbaabdd98d1182198f83d25.TXT ### 5/5/2022 2:34:44 PM
5/5/2022 2:34:44 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::2
5/5/2022 2:34:44 PM : Import IN File --->> IN_354_20220425_1570e0bd51535be828b07e74e8fdff3a.TXT ### 5/5/2022 2:34:44 PM
5/5/2022 2:34:44 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::1
5/5/2022 2:34:44 PM : Import IN File --->> IN_354_20220426_07c6966a55c0c7a94537a00b987031da.TXT ### 5/5/2022 2:34:44 PM
5/5/2022 2:34:44 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::1
5/5/2022 2:34:44 PM : Import IN File --->> IN_354_20220427_2d158326ba10ee81d013c67a1652918e.TXT ### 5/5/2022 2:34:44 PM
5/5/2022 2:34:44 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::3
5/5/2022 2:34:44 PM : Import IN File --->> IN_354_20220428_a193648af491433b03596bb5e19225b4.TXT ### 5/5/2022 2:34:44 PM
5/5/2022 2:34:44 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::2
5/5/2022 2:34:45 PM : Import IN File --->> IN_354_20220429_4c45fd1ed859ddeb788d91e9944801db.TXT ### 5/5/2022 2:34:45 PM
5/5/2022 2:34:45 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::2
5/5/2022 2:34:45 PM : Import IN File --->> IN_354_20220504_a54f745aa3cad203743e26691705dce7.TXT ### 5/5/2022 2:34:45 PM
5/5/2022 2:34:46 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::3
5/5/2022 2:34:46 PM : Import IN File --->> IN_354_20220505_d71d3341c19245281fa367bb5974688c.TXT ### 5/5/2022 2:34:46 PM
5/5/2022 2:34:46 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::1
5/5/2022 2:34:57 PM : Import IN File --->> IN_360_20220505_9da3086ba3c20cdbbaf1a843fa383f04.TXT ### 5/5/2022 2:34:57 PM
5/5/2022 2:34:57 PM : NO Previous File For Distributor 000000000000360 ### Insert Count::7
5/5/2022 2:35:11 PM : Import IN File --->> IN_365_20220505_6bb6e71b1879c6aea5fe2289202a9d05.TXT ### 5/5/2022 2:35:11 PM
5/5/2022 2:35:11 PM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/5/2022 2:35:15 PM : For Distributor 000000000000366 Insert Count::0 ### Delete Count::3
5/5/2022 2:35:15 PM : Import IN File --->> IN_366_20220427_c2d461af6f36b7f0ff27c69ddb5d1ab5.TXT ### 5/5/2022 2:35:15 PM
5/5/2022 2:35:16 PM : For Distributor 000000000000366 Insert Count::1 ### Delete Count::1
5/5/2022 2:35:16 PM : Import IN File --->> IN_366_20220430_2afd34912b6c95cae60010646a621383.TXT ### 5/5/2022 2:35:16 PM
5/5/2022 2:35:17 PM : For Distributor 000000000000366 Insert Count::13 ### Delete Count::0
5/5/2022 2:35:17 PM : Import IN File --->> IN_366_20220503_61e9da750f90c47a98796feeccfd10b3.TXT ### 5/5/2022 2:35:17 PM
5/5/2022 2:35:18 PM : Import IN File --->> IN_366_20220504_6ad0bd07504cfc52e4fe97c0b2539719.TXT ### 5/5/2022 2:35:18 PM
5/5/2022 2:35:18 PM : NO Previous File For Distributor 000000000000366 ### Insert Count::3
5/5/2022 2:35:18 PM : Import IN File --->> IN_366_20220505_6fa569bd0e4fdeb80a845a2d5162d187.TXT ### 5/5/2022 2:35:18 PM
5/5/2022 2:35:18 PM : NO Previous File For Distributor 000000000000366 ### Insert Count::22
5/5/2022 2:35:24 PM : For Distributor 000000000000371 Insert Count::22 ### Delete Count::0
5/5/2022 2:35:24 PM : Import IN File --->> IN_371_20220502_ac5e5d29437ba1c2579fec9a2c913b27.TXT ### 5/5/2022 2:35:24 PM
5/5/2022 2:35:24 PM : For Distributor 000000000000371 Insert Count::12 ### Delete Count::0
5/5/2022 2:35:24 PM : Import IN File --->> IN_371_20220503_9c81fc35e213e9aa682dec1bbf24f638.TXT ### 5/5/2022 2:35:24 PM
5/5/2022 2:35:24 PM : For Distributor 000000000000371 Insert Count::31 ### Delete Count::0
5/5/2022 2:35:24 PM : Import IN File --->> IN_371_20220504_81d571e9922f6ae0503a5d7edba3f0bb.TXT ### 5/5/2022 2:35:24 PM
5/5/2022 2:35:25 PM : Import IN File --->> IN_371_20220505_1021441188abc63ddec12d523d09b859.TXT ### 5/5/2022 2:35:25 PM
5/5/2022 2:35:25 PM : NO Previous File For Distributor 000000000000371 ### Insert Count::14
5/5/2022 2:35:29 PM : For Distributor 000000000000372 Insert Count::3 ### Delete Count::0
5/5/2022 2:35:29 PM : Import IN File --->> IN_372_20220425_ff1607005f3cc540a756c6c781e021f1.TXT ### 5/5/2022 2:35:29 PM
5/5/2022 2:35:29 PM : For Distributor 000000000000372 Insert Count::5 ### Delete Count::0
5/5/2022 2:35:29 PM : Import IN File --->> IN_372_20220426_15c5ecadbe45d942688381b4467b5a6e.TXT ### 5/5/2022 2:35:29 PM
5/5/2022 2:35:29 PM : For Distributor 000000000000372 Insert Count::8 ### Delete Count::0
5/5/2022 2:35:29 PM : Import IN File --->> IN_372_20220427_6eef417aa1d269b5ef15e48db1efd46f.TXT ### 5/5/2022 2:35:29 PM
5/5/2022 2:35:30 PM : For Distributor 000000000000372 Insert Count::3 ### Delete Count::0
5/5/2022 2:35:30 PM : Import IN File --->> IN_372_20220428_e32eacd63c9ab7e461901808dfded0f1.TXT ### 5/5/2022 2:35:30 PM
5/5/2022 2:35:30 PM : For Distributor 000000000000372 Insert Count::8 ### Delete Count::0
5/5/2022 2:35:30 PM : Import IN File --->> IN_372_20220429_a600b59eac95212e2a1e2b925ab5614a.TXT ### 5/5/2022 2:35:30 PM
5/5/2022 2:35:30 PM : Import IN File --->> IN_372_20220430_838d2854c8748d7d51fdb8bbfc577e68.TXT ### 5/5/2022 2:35:30 PM
5/5/2022 2:35:30 PM : NO Previous File For Distributor 000000000000372 ### Insert Count::2
5/5/2022 2:35:31 PM : Import IN File --->> IN_372_20220502_e6d830084537fd1a46752f6fdece22a7.TXT ### 5/5/2022 2:35:31 PM
5/5/2022 2:35:31 PM : NO Previous File For Distributor 000000000000372 ### Insert Count::18
5/5/2022 2:35:31 PM : Import IN File --->> IN_372_20220503_c3181486b335add433836efbbd07d935.TXT ### 5/5/2022 2:35:31 PM
5/5/2022 2:35:31 PM : NO Previous File For Distributor 000000000000372 ### Insert Count::12
5/5/2022 2:35:36 PM : Import IN File --->> IN_373_20220505_d35f9d9f2f55457313a8268770139e73.TXT ### 5/5/2022 2:35:36 PM
5/5/2022 2:35:36 PM : NO Previous File For Distributor 000000000000373 ### Insert Count::9
5/5/2022 2:35:41 PM : For Distributor 000000000000424 Insert Count::2 ### Delete Count::0
5/5/2022 2:35:41 PM : Import IN File --->> IN_424_20220504_b4abf2e1b9dd77c29315647ce811e252.TXT ### 5/5/2022 2:35:41 PM
5/5/2022 2:35:42 PM : For Distributor 000000000000424 Insert Count::2 ### Delete Count::0
5/5/2022 2:35:42 PM : Import IN File --->> IN_424_20220505_6ef9bf47de4d0fd43ce1657634b1ee7e.TXT ### 5/5/2022 2:35:42 PM
5/5/2022 2:35:46 PM : For Distributor 000000000000665 Insert Count::25 ### Delete Count::0
5/5/2022 2:35:46 PM : Import IN File --->> IN_665_20220502_fe6b3fbadd52ca2902640eec2993bfa3.TXT ### 5/5/2022 2:35:46 PM
5/5/2022 2:35:47 PM : For Distributor 000000000000665 Insert Count::6 ### Delete Count::0
5/5/2022 2:35:47 PM : Import IN File --->> IN_665_20220503_23ff901076ef4e148af3b77e295193da.TXT ### 5/5/2022 2:35:47 PM
5/5/2022 2:35:47 PM : For Distributor 000000000000665 Insert Count::9 ### Delete Count::0
5/5/2022 2:35:47 PM : Import IN File --->> IN_665_20220504_c9427067cec9ce8e496149fb79909194.TXT ### 5/5/2022 2:35:47 PM
5/5/2022 2:35:56 PM : For Distributor 000000000000815 Insert Count::1 ### Delete Count::0
5/5/2022 2:35:56 PM : Import IN File --->> IN_815_20220429_21cab7c7c028a01bac077886120ce06b.TXT ### 5/5/2022 2:35:56 PM
5/5/2022 2:35:56 PM : For Distributor 000000000000815 Insert Count::69 ### Delete Count::0
5/5/2022 2:35:56 PM : Import IN File --->> IN_815_20220430_fa495321dd69b2d994ee7ccef35c51f5.TXT ### 5/5/2022 2:35:56 PM
5/5/2022 2:35:56 PM : Import IN File --->> IN_815_20220502_ef6b169ea68bf375adc9a49673163efa.TXT ### 5/5/2022 2:35:56 PM
5/5/2022 2:35:56 PM : NO Previous File For Distributor 000000000000815 ### Insert Count::15
5/5/2022 2:35:57 PM : Import IN File --->> IN_815_20220504_acaa180902136d85d395bdb27fdced4e.TXT ### 5/5/2022 2:35:57 PM
5/5/2022 2:35:57 PM : NO Previous File For Distributor 000000000000815 ### Insert Count::8
5/5/2022 2:35:57 PM : Import IN File --->> IN_815_20220505_798d9d4ec7a2c0ba45b6131b457e1cba.TXT ### 5/5/2022 2:35:57 PM
5/5/2022 2:35:57 PM : NO Previous File For Distributor 000000000000815 ### Insert Count::2
5/5/2022 2:36:11 PM : For Distributor 000000000001321 Insert Count::7 ### Delete Count::0
5/5/2022 2:36:11 PM : Import PR File --->> PR_1321_20220505_1a6d69f15f15bba97c9f438126a849ce.TXT ### 5/5/2022 2:36:11 PM
5/5/2022 2:36:11 PM : For Distributor 000000000000354 Insert Count::11 ### Delete Count::0
5/5/2022 2:36:11 PM : Import PR File --->> PR_354_20220505_e0d1d3c29c922c40f4418560c2908ec4.TXT ### 5/5/2022 2:36:11 PM
5/5/2022 2:36:12 PM : PostData() --->>  ### 5/5/2022 2:36:12 PM
5/5/2022 2:36:40 PM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 5/5/2022 2:36:40 PM
5/5/2022 2:36:46 PM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '05/May/2022' ### 5/5/2022 2:36:46 PM
5/5/2022 2:36:47 PM : ItemLink Successful --->> exec SP_ItemLinkDiff '05/May/2022' ### 5/5/2022 2:36:47 PM
5/5/2022 2:36:47 PM :  ### 
5/5/2022 2:36:47 PM : UNLINKEDSALES Record Count Before --->> 477 ### 5/5/2022 2:36:47 PM
5/5/2022 2:36:47 PM : UNLINKEDSALES_DEL Record Count Before --->> 4 ### 5/5/2022 2:36:47 PM
5/5/2022 2:44:22 PM : Posting Sales Successful --->> exec prPostLinkedDiffSales '05/May/2022' ### 5/5/2022 2:44:22 PM
5/5/2022 2:44:22 PM : UNLINKEDSALES Record Count After --->> 0 ### 5/5/2022 2:44:22 PM
5/5/2022 2:44:22 PM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 5/5/2022 2:44:22 PM
5/5/2022 2:44:22 PM :  ### 
5/5/2022 2:44:22 PM : Posting Supplierlink Query for Purchases --->>  ### 5/5/2022 2:44:22 PM
5/5/2022 2:44:30 PM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '05/May/2022' ### 5/5/2022 2:44:30 PM
5/5/2022 2:44:36 PM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '05/May/2022' ### 5/5/2022 2:44:36 PM
5/5/2022 2:44:36 PM : Posting Supplierlink Query for CompanyPurchases --->>  ### 5/5/2022 2:44:36 PM
5/5/2022 2:44:36 PM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '05/May/2022' ### 5/5/2022 2:44:36 PM
5/5/2022 2:44:36 PM : Posting ClosingStock Successful --->>  ### 5/5/2022 2:44:36 PM
5/5/2022 2:44:36 PM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 5/5/2022 2:44:36 PM
5/5/2022 2:44:36 PM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
5/5/2022 2:44:36 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1025789_TEMPLATE1.TXT ### 5/5/2022 2:44:36 PM
5/5/2022 2:44:36 PM : Count:: ### TEMPLATE1:124
5/5/2022 2:44:52 PM : SP_DistributorTemplatePosting Successful --->>  ### 5/5/2022 2:44:52 PM
5/5/2022 2:44:52 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 5/5/2022 2:44:52 PM
5/5/2022 2:44:52 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 2:44:52 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1986218_TEMPLATE1.TXT ### 5/5/2022 2:44:52 PM
5/5/2022 2:44:52 PM : Count:: ### TEMPLATE1:143
5/5/2022 2:45:13 PM : SP_DistributorTemplatePosting Successful --->>  ### 5/5/2022 2:45:13 PM
5/5/2022 2:45:13 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1990080_TEMPLATE1.TXT ### 5/5/2022 2:45:13 PM
5/5/2022 2:45:13 PM : Count:: ### TEMPLATE1:13
5/5/2022 2:45:14 PM : SP_DistributorTemplatePosting Successful --->>  ### 5/5/2022 2:45:14 PM
5/5/2022 2:45:14 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 5/5/2022 2:45:14 PM
5/5/2022 2:45:14 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 2:45:14 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 5/5/2022 2:45:14 PM
5/5/2022 2:45:14 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 2:45:14 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2743253_TEMPLATE1.TXT ### 5/5/2022 2:45:14 PM
5/5/2022 2:45:14 PM : Count:: ### TEMPLATE1:16
5/5/2022 2:45:14 PM : SP_DistributorTemplatePosting Successful --->>  ### 5/5/2022 2:45:14 PM
5/5/2022 2:45:14 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 5/5/2022 2:45:14 PM
5/5/2022 2:45:14 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 2:45:14 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 5/5/2022 2:45:14 PM
5/5/2022 2:45:14 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 2:45:14 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3224985_TEMPLATE1.TXT ### 5/5/2022 2:45:14 PM
5/5/2022 2:45:14 PM : Count:: ### TEMPLATE1:111
5/5/2022 2:45:28 PM : SP_DistributorTemplatePosting Successful --->>  ### 5/5/2022 2:45:28 PM
5/5/2022 2:45:28 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 5/5/2022 2:45:28 PM
5/5/2022 2:45:28 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 2:45:28 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3612379_TEMPLATE1.TXT ### 5/5/2022 2:45:28 PM
5/5/2022 2:45:28 PM : Count:: ### TEMPLATE1:20
5/5/2022 2:45:29 PM : SP_DistributorTemplatePosting Successful --->>  ### 5/5/2022 2:45:29 PM
5/5/2022 2:45:29 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 5/5/2022 2:45:29 PM
5/5/2022 2:45:29 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 2:45:29 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 5/5/2022 2:45:29 PM
5/5/2022 2:45:29 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 2:45:29 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3831146_TEMPLATE1.TXT ### 5/5/2022 2:45:29 PM
5/5/2022 2:45:29 PM : Count:: ### TEMPLATE1:141
5/5/2022 2:45:46 PM : SP_DistributorTemplatePosting Successful --->>  ### 5/5/2022 2:45:46 PM
5/5/2022 2:45:46 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 5/5/2022 2:45:46 PM
5/5/2022 2:45:46 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 2:45:46 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3985879_TEMPLATE1.txt ### 5/5/2022 2:45:46 PM
5/5/2022 2:45:46 PM : Count:: ### TEMPLATE1:15
5/5/2022 2:45:47 PM : SP_DistributorTemplatePosting Successful --->>  ### 5/5/2022 2:45:47 PM
5/5/2022 2:45:47 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 5/5/2022 2:45:47 PM
5/5/2022 2:45:47 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 2:45:47 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 5/5/2022 2:45:47 PM
5/5/2022 2:45:47 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 2:45:47 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 5/5/2022 2:45:47 PM
5/5/2022 2:45:47 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 2:45:47 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060542_TEMPLATE1.TXT ### 5/5/2022 2:45:47 PM
5/5/2022 2:45:47 PM : Count:: ### TEMPLATE1:32
5/5/2022 2:45:47 PM : SP_DistributorTemplatePosting Successful --->>  ### 5/5/2022 2:45:47 PM
5/5/2022 2:45:47 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060893_TEMPLATE1.txt ### 5/5/2022 2:45:47 PM
5/5/2022 2:45:47 PM : Count:: ### TEMPLATE1:64
5/5/2022 2:45:56 PM : SP_DistributorTemplatePosting Successful --->>  ### 5/5/2022 2:45:56 PM
5/5/2022 2:45:56 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 5/5/2022 2:45:56 PM
5/5/2022 2:45:56 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 2:45:56 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 5/5/2022 2:45:56 PM
5/5/2022 2:45:56 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 2:45:56 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 5/5/2022 2:45:56 PM
5/5/2022 2:45:56 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 2:45:56 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062642_TEMPLATE1.txt ### 5/5/2022 2:45:56 PM
5/5/2022 2:45:56 PM : Count:: ### TEMPLATE1:14
5/5/2022 2:45:58 PM : SP_DistributorTemplatePosting Successful --->>  ### 5/5/2022 2:45:58 PM
5/5/2022 2:45:58 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 5/5/2022 2:45:58 PM
5/5/2022 2:45:58 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 2:45:58 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063177_TEMPLATE1.TXT ### 5/5/2022 2:45:58 PM
5/5/2022 2:45:58 PM : Count:: ### TEMPLATE1:117
5/5/2022 2:46:06 PM : SP_DistributorTemplatePosting Successful --->>  ### 5/5/2022 2:46:06 PM
5/5/2022 2:46:06 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 5/5/2022 2:46:06 PM
5/5/2022 2:46:06 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 2:46:06 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9064126_TEMPLATE1.txt ### 5/5/2022 2:46:06 PM
5/5/2022 2:46:06 PM : Count:: ### TEMPLATE1:2
5/5/2022 2:46:06 PM : SP_DistributorTemplatePosting Successful --->>  ### 5/5/2022 2:46:06 PM
5/5/2022 2:46:06 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9066916_TEMPLATE1.TXT ### 5/5/2022 2:46:06 PM
5/5/2022 2:46:06 PM : Count:: ### TEMPLATE1:58
5/5/2022 2:46:14 PM : SP_DistributorTemplatePosting Successful --->>  ### 5/5/2022 2:46:14 PM
5/5/2022 2:46:14 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067041_TEMPLATE1.TXT ### 5/5/2022 2:46:14 PM
5/5/2022 2:46:14 PM : Count:: ### TEMPLATE1:71
5/5/2022 2:46:23 PM : SP_DistributorTemplatePosting Successful --->>  ### 5/5/2022 2:46:23 PM
5/5/2022 2:46:23 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067092_TEMPLATE1.TXT ### 5/5/2022 2:46:23 PM
5/5/2022 2:46:23 PM : Count:: ### TEMPLATE1:24
5/5/2022 2:46:26 PM : SP_DistributorTemplatePosting Successful --->>  ### 5/5/2022 2:46:26 PM
5/5/2022 2:46:26 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067122_TEMPLATE1.TXT ### 5/5/2022 2:46:26 PM
5/5/2022 2:46:26 PM : Count:: ### TEMPLATE1:34
5/5/2022 2:46:27 PM : SP_DistributorTemplatePosting Successful --->>  ### 5/5/2022 2:46:27 PM
5/5/2022 2:46:27 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_948223_TEMPLATE1.TXT ### 5/5/2022 2:46:27 PM
5/5/2022 2:46:27 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/5/2022 2:46:27 PM : Template Import Complete  ### 5/5/2022 2:46:27 PM
5/5/2022 2:46:30 PM : Completed Updating Has Transaction Flag  ### 5/5/2022 2:46:30 PM
5/5/2022 2:46:30 PM : Transaction Table lastEdiDate Update on BrandAlias Update ### 5/5/2022 2:46:30 PM
5/5/2022 2:46:30 PM : Zylem Access Unblocked  ### 5/5/2022 2:46:30 PM
5/5/2022 2:46:30 PM : Application Ended  ### 5/5/2022 2:46:30 PM