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

11/2/2020 4:00:04 AM : 11  ### 11/2/2020 4:00:04 AM

11/2/2020 4:00:04 AM : 22  ### 11/2/2020 4:00:04 AM

11/2/2020 4:00:04 AM : 33  ### 11/2/2020 4:00:04 AM

11/2/2020 4:00:04 AM : Application Started  ### 11/2/2020 4:00:04 AM

11/2/2020 4:00:04 AM : Start Process : checkAllTablesExists()  ### 
11/2/2020 4:00:04 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 11/2/2020 4:00:04 AM
11/2/2020 4:00:04 AM : MainForm_Load  ### AlertSystem ON
11/2/2020 4:00:04 AM : No. of Files to import (RECEIVEFINAL):  ### 948
11/2/2020 4:00:04 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
11/2/2020 4:00:04 AM : For Distributor 000000000000012 Insert Count::1 ### Delete Count::0
11/2/2020 4:00:04 AM : Import AD File --->> AD_12_20201102_d6fed284b0533374db07960873bd7878.TXT ### 11/2/2020 4:00:04 AM
11/2/2020 4:00:04 AM : For Distributor 000000000000180 Insert Count::6 ### Delete Count::12
11/2/2020 4:00:04 AM : Import AD File --->> AD_180_20201101_bdeea22826a2ea90ed4805d927190883.TXT ### 11/2/2020 4:00:04 AM
11/2/2020 4:00:04 AM : For Distributor 000000000000020 Insert Count::1 ### Delete Count::1
11/2/2020 4:00:04 AM : Import AD File --->> AD_20_20201101_2755a33b756cb1c95f30adc4d98f5c5b.TXT ### 11/2/2020 4:00:04 AM
11/2/2020 4:00:04 AM : For Distributor 000000000000035 Insert Count::2 ### Delete Count::119
11/2/2020 4:00:04 AM : Import AD File --->> AD_35_20201102_b76d0def856b1def19022363378fc4cc.TXT ### 11/2/2020 4:00:04 AM
11/2/2020 4:00:05 AM : For Distributor 000000000000425 Insert Count::6 ### Delete Count::3
11/2/2020 4:00:05 AM : Import AD File --->> AD_425_20201101_a7e8bfe05a45e784fc6f31bbf9b2dcac.TXT ### 11/2/2020 4:00:05 AM
11/2/2020 4:00:05 AM : For Distributor 000000000000452 Insert Count::1 ### Delete Count::11
11/2/2020 4:00:05 AM : Import AD File --->> AD_452_20201101_7ed718bfb700a9106694c53d87227c2a.TXT ### 11/2/2020 4:00:05 AM
11/2/2020 4:00:05 AM : For Distributor 000000000000004 Insert Count::1 ### Delete Count::64
11/2/2020 4:00:05 AM : Import AD File --->> AD_4_20201102_99979f1f1bd0ee1121c5303ee60950c3.TXT ### 11/2/2020 4:00:05 AM
11/2/2020 4:00:06 AM : For Distributor 000000000000180 Insert Count::1 ### Delete Count::0
11/2/2020 4:00:06 AM : Import DN File --->> DN_180_20201028_94ed523164918283e29c691c8b12be8d.TXT ### 11/2/2020 4:00:06 AM
11/2/2020 4:00:08 AM : For Distributor 000000000000035 Insert Count::2 ### Delete Count::0
11/2/2020 4:00:08 AM : Import DN File --->> DN_35_20201030_c73823225c05d3cfd53cd8a2c9c9f0ca.TXT ### 11/2/2020 4:00:08 AM
11/2/2020 4:00:10 AM : For Distributor 000000000000004 Insert Count::2 ### Delete Count::0
11/2/2020 4:00:10 AM : Import DN File --->> DN_4_20201029_e8fcd21ce0468f8a66244b24787c2305.TXT ### 11/2/2020 4:00:10 AM
11/2/2020 4:00:11 AM : For Distributor 000000000000012 Insert Count::1 ### Delete Count::0
11/2/2020 4:00:11 AM : Import IN File --->> IN_12_20201028_2a47c2478a4cf79ce369959b5621fb5c.TXT ### 11/2/2020 4:00:11 AM
11/2/2020 4:00:11 AM : For Distributor 000000000000012 Insert Count::4 ### Delete Count::0
11/2/2020 4:00:11 AM : Import IN File --->> IN_12_20201029_a49ededcd0ff677d7ec5c9d6707f006d.TXT ### 11/2/2020 4:00:11 AM
11/2/2020 4:00:11 AM : For Distributor 000000000000012 Insert Count::2 ### Delete Count::0
11/2/2020 4:00:11 AM : Import IN File --->> IN_12_20201030_02b5c5c6fa2536128c566640935ca565.TXT ### 11/2/2020 4:00:11 AM
11/2/2020 4:00:11 AM : For Distributor 000000000000012 Insert Count::4 ### Delete Count::0
11/2/2020 4:00:11 AM : Import IN File --->> IN_12_20201031_97d7863977f4d0b0f2ee7ebfc1980a27.TXT ### 11/2/2020 4:00:11 AM
11/2/2020 4:00:11 AM : For Distributor 000000000000180 Insert Count::0 ### Delete Count::6
11/2/2020 4:00:11 AM : Import IN File --->> IN_180_20200923_e1f39511cf756806df31b4e9bffeaf92.TXT ### 11/2/2020 4:00:11 AM
11/2/2020 4:00:11 AM : For Distributor 000000000000180 Insert Count::0 ### Delete Count::1
11/2/2020 4:00:11 AM : Import IN File --->> IN_180_20200924_a154450ea2bdea200cf4374ddeff1aee.TXT ### 11/2/2020 4:00:11 AM
11/2/2020 4:00:12 AM : For Distributor 000000000000180 Insert Count::0 ### Delete Count::3
11/2/2020 4:00:12 AM : Import IN File --->> IN_180_20200925_d41d8cd98f00b204e9800998ecf8427e.TXT ### 11/2/2020 4:00:12 AM
11/2/2020 4:00:12 AM : For Distributor 000000000000180 Insert Count::0 ### Delete Count::14
11/2/2020 4:00:12 AM : Import IN File --->> IN_180_20200926_d41d8cd98f00b204e9800998ecf8427e.TXT ### 11/2/2020 4:00:12 AM
11/2/2020 4:00:12 AM : For Distributor 000000000000180 Insert Count::0 ### Delete Count::9
11/2/2020 4:00:12 AM : Import IN File --->> IN_180_20200927_d41d8cd98f00b204e9800998ecf8427e.TXT ### 11/2/2020 4:00:12 AM
11/2/2020 4:00:12 AM : For Distributor 000000000000180 Insert Count::0 ### Delete Count::6
11/2/2020 4:00:12 AM : Import IN File --->> IN_180_20200928_d41d8cd98f00b204e9800998ecf8427e.TXT ### 11/2/2020 4:00:12 AM
11/2/2020 4:00:12 AM : For Distributor 000000000000180 Insert Count::0 ### Delete Count::5
11/2/2020 4:00:12 AM : Import IN File --->> IN_180_20200929_d41d8cd98f00b204e9800998ecf8427e.TXT ### 11/2/2020 4:00:12 AM
11/2/2020 4:00:12 AM : For Distributor 000000000000180 Insert Count::0 ### Delete Count::5
11/2/2020 4:00:12 AM : Import IN File --->> IN_180_20200930_d41d8cd98f00b204e9800998ecf8427e.TXT ### 11/2/2020 4:00:12 AM
11/2/2020 4:00:12 AM : For Distributor 000000000000180 Insert Count::2 ### Delete Count::0
11/2/2020 4:00:12 AM : Import IN File --->> IN_180_20201001_a3146409827fd74aa9a7a2ccee324ca7.TXT ### 11/2/2020 4:00:12 AM
11/2/2020 4:00:12 AM : For Distributor 000000000000180 Insert Count::1 ### Delete Count::0
11/2/2020 4:00:12 AM : Import IN File --->> IN_180_20201002_d24288a35c68ba4586b9dea572d05e8c.TXT ### 11/2/2020 4:00:12 AM
11/2/2020 4:00:12 AM : For Distributor 000000000000180 Insert Count::1 ### Delete Count::0
11/2/2020 4:00:12 AM : Import IN File --->> IN_180_20201003_ff2eaced269dcd62af3153c57b4204f1.TXT ### 11/2/2020 4:00:12 AM
11/2/2020 4:00:12 AM : For Distributor 000000000000180 Insert Count::1 ### Delete Count::0
11/2/2020 4:00:12 AM : Import IN File --->> IN_180_20201007_542885d64dc76b5425f68fb65ac0ca21.TXT ### 11/2/2020 4:00:12 AM
11/2/2020 4:00:13 AM : For Distributor 000000000000180 Insert Count::1 ### Delete Count::0
11/2/2020 4:00:13 AM : Import IN File --->> IN_180_20201030_06f7cebfbfbe2270dbf58adc8411b761.TXT ### 11/2/2020 4:00:13 AM
11/2/2020 4:00:13 AM : Import IN File --->> IN_180_20201031_17f2e9286c4aaae99beb6f6c535996fb.TXT ### 11/2/2020 4:00:13 AM
11/2/2020 4:00:13 AM : NO Previous File For Distributor 000000000000180 ### Insert Count::1
11/2/2020 4:00:14 AM : For Distributor 000000000000020 Insert Count::1 ### Delete Count::0
11/2/2020 4:00:14 AM : Import IN File --->> IN_20_20201024_dd725da8e05de35b2e971b7622fb7be1.TXT ### 11/2/2020 4:00:14 AM
11/2/2020 4:00:14 AM : Import IN File --->> IN_20_20201029_9dc982b16ca41ea17ebab7fe2625bd1b.TXT ### 11/2/2020 4:00:14 AM
11/2/2020 4:00:14 AM : NO Previous File For Distributor 000000000000020 ### Insert Count::31
11/2/2020 4:00:14 AM : Import IN File --->> IN_20_20201030_63887b2998f83fe4e86fb34206917741.TXT ### 11/2/2020 4:00:14 AM
11/2/2020 4:00:14 AM : NO Previous File For Distributor 000000000000020 ### Insert Count::15
11/2/2020 4:00:14 AM : Import IN File --->> IN_20_20201031_76247bdeefc1ba9c17a75a8541e40730.TXT ### 11/2/2020 4:00:14 AM
11/2/2020 4:00:14 AM : NO Previous File For Distributor 000000000000020 ### Insert Count::6
11/2/2020 4:00:15 AM : The process failed: {0}  ### System.IndexOutOfRangeException: Index was outside the bounds of the array.
   at ZylemImport.ZylemImportClass.ImportINFile(String connectionstring, String Selection, String user) in e:\PROJECTS_SVN\ZylemMIS_Release_1.1.0\slnESpirit\ZylemImport\ZylemImportClass.cs:line 1418
11/2/2020 4:00:15 AM : PostData() --->>  ### 11/2/2020 4:00:15 AM
11/2/2020 4:00:15 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 11/2/2020 4:00:15 AM
11/2/2020 4:00:16 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '02/Nov/2020' ### 11/2/2020 4:00:16 AM
11/2/2020 4:00:16 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '02/Nov/2020' ### 11/2/2020 4:00:16 AM
11/2/2020 4:00:16 AM :  ### 
11/2/2020 4:00:16 AM : UNLINKEDSALES Record Count Before --->> 71 ### 11/2/2020 4:00:16 AM
11/2/2020 4:00:16 AM : UNLINKEDSALES_DEL Record Count Before --->> 49 ### 11/2/2020 4:00:16 AM
11/2/2020 4:00:22 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '02/Nov/2020' ### 11/2/2020 4:00:22 AM
11/2/2020 4:00:22 AM : UNLINKEDSALES Record Count After --->> 0 ### 11/2/2020 4:00:22 AM
11/2/2020 4:00:22 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 11/2/2020 4:00:22 AM
11/2/2020 4:00:22 AM :  ### 
11/2/2020 4:00:22 AM : Posting Supplierlink Query for Purchases --->>  ### 11/2/2020 4:00:22 AM
11/2/2020 4:00:26 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '02/Nov/2020' ### 11/2/2020 4:00:26 AM
11/2/2020 4:00:31 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '02/Nov/2020' ### 11/2/2020 4:00:31 AM
11/2/2020 4:00:31 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 11/2/2020 4:00:31 AM
11/2/2020 4:00:31 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '02/Nov/2020' ### 11/2/2020 4:00:31 AM
11/2/2020 4:00:31 AM : Posting ClosingStock Successful --->>  ### 11/2/2020 4:00:31 AM
11/2/2020 4:00:31 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 11/2/2020 4:00:31 AM
11/2/2020 4:00:31 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
11/2/2020 4:00:31 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2186196_TEMPLATE1.txt ### 11/2/2020 4:00:31 AM
11/2/2020 4:00:31 AM : Count:: ### TEMPLATE1:22
11/2/2020 4:00:31 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/2/2020 4:00:31 AM
11/2/2020 4:00:31 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3555953_TEMPLATE1.txt ### 11/2/2020 4:00:31 AM
11/2/2020 4:00:31 AM : Count:: ### TEMPLATE1:54
11/2/2020 4:00:32 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/2/2020 4:00:32 AM
11/2/2020 4:00:32 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3912945_TEMPLATE1.txt ### 11/2/2020 4:00:32 AM
11/2/2020 4:00:32 AM : Count:: ### TEMPLATE1:70
11/2/2020 4:00:33 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/2/2020 4:00:33 AM
11/2/2020 4:00:33 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3952308_TEMPLATE1.txt ### 11/2/2020 4:00:33 AM
11/2/2020 4:00:33 AM : Count:: ### TEMPLATE1:62
11/2/2020 4:00:33 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/2/2020 4:00:33 AM
11/2/2020 4:00:33 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3963576_TEMPLATE1.txt ### 11/2/2020 4:00:33 AM
11/2/2020 4:00:33 AM : Count:: ### TEMPLATE1:17
11/2/2020 4:00:33 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/2/2020 4:00:33 AM
11/2/2020 4:00:33 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4194755_TEMPLATE1.txt ### 11/2/2020 4:00:33 AM
11/2/2020 4:00:33 AM : Count:: ### TEMPLATE1:479
11/2/2020 4:00:35 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/2/2020 4:00:35 AM
11/2/2020 4:00:35 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4222558_TEMPLATE1.txt ### 11/2/2020 4:00:35 AM
11/2/2020 4:00:35 AM : Count:: ### TEMPLATE1:71
11/2/2020 4:00:35 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/2/2020 4:00:35 AM
11/2/2020 4:00:35 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4277134_TEMPLATE1.txt ### 11/2/2020 4:00:35 AM
11/2/2020 4:00:35 AM : Count:: ### TEMPLATE1:149
11/2/2020 4:00:36 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/2/2020 4:00:36 AM
11/2/2020 4:00:36 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4529171_TEMPLATE1.txt ### 11/2/2020 4:00:36 AM
11/2/2020 4:00:36 AM : Count:: ### TEMPLATE1:34
11/2/2020 4:00:37 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/2/2020 4:00:37 AM
11/2/2020 4:00:37 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060613_TEMPLATE1.txt ### 11/2/2020 4:00:37 AM
11/2/2020 4:00:37 AM : Count:: ### TEMPLATE1:3124
11/2/2020 4:00:37 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/2/2020 4:00:37 AM
11/2/2020 4:00:37 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062778_TEMPLATE1.txt ### 11/2/2020 4:00:37 AM
11/2/2020 4:00:37 AM : Count:: ### TEMPLATE1:347
11/2/2020 4:00:38 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/2/2020 4:00:38 AM
11/2/2020 4:00:38 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062804_TEMPLATE1.txt ### 11/2/2020 4:00:38 AM
11/2/2020 4:00:38 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
11/2/2020 4:00:38 AM : Template Import Complete  ### 11/2/2020 4:00:38 AM
11/2/2020 4:00:39 AM : Completed Updating Has Transaction Flag  ### 11/2/2020 4:00:39 AM
11/2/2020 4:00:39 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 11/2/2020 4:00:39 AM
11/2/2020 4:00:39 AM : Zylem Access Unblocked  ### 11/2/2020 4:00:39 AM
11/2/2020 4:00:39 AM : Application Ended  ### 11/2/2020 4:00:39 AM