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

11/16/2020 4:00:03 AM : 11  ### 11/16/2020 4:00:03 AM

11/16/2020 4:00:03 AM : 22  ### 11/16/2020 4:00:03 AM

11/16/2020 4:00:03 AM : 33  ### 11/16/2020 4:00:03 AM

11/16/2020 4:00:03 AM : Application Started  ### 11/16/2020 4:00:03 AM

11/16/2020 4:00:03 AM : Start Process : checkAllTablesExists()  ### 
11/16/2020 4:00:03 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 11/16/2020 4:00:03 AM
11/16/2020 4:00:03 AM : MainForm_Load  ### AlertSystem ON
11/16/2020 4:00:04 AM : No. of Files to import (RECEIVEFINAL):  ### 792
11/16/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/16/2020 4:00:04 AM : For Distributor 000000000000186 Insert Count::29 ### Delete Count::0
11/16/2020 4:00:04 AM : Import AD File --->> AD_186_20201116_cbcdeb393a905c2c201a03e133d0e423.TXT ### 11/16/2020 4:00:04 AM
11/16/2020 4:00:04 AM : For Distributor 000000000000320 Insert Count::5 ### Delete Count::0
11/16/2020 4:00:04 AM : Import AD File --->> AD_320_20201115_b440ac19cc2826e6c374181cf6675cb4.TXT ### 11/16/2020 4:00:04 AM
11/16/2020 4:00:04 AM : For Distributor 000000000000361 Insert Count::1 ### Delete Count::0
11/16/2020 4:00:04 AM : Import AD File --->> AD_361_20201116_6598d63ac7c76c85a8477d00b4bad184.TXT ### 11/16/2020 4:00:04 AM
11/16/2020 4:00:04 AM : For Distributor 000000000000465 Insert Count::1 ### Delete Count::0
11/16/2020 4:00:04 AM : Import AD File --->> AD_465_20201115_9ab56d148aaeb96a319563e241fd907a.TXT ### 11/16/2020 4:00:04 AM
11/16/2020 4:00:05 AM : For Distributor 000000000000320 Insert Count::1 ### Delete Count::1
11/16/2020 4:00:05 AM : Import DN File --->> DN_320_20201008_fa174df3558362d9c1e7d26ce30fe223.TXT ### 11/16/2020 4:00:05 AM
11/16/2020 4:00:06 AM : For Distributor 000000000000320 Insert Count::1 ### Delete Count::1
11/16/2020 4:00:06 AM : Import DN File --->> DN_320_20201014_bc1e1ddcdd45efab7b41345f4f6a02cb.TXT ### 11/16/2020 4:00:06 AM
11/16/2020 4:00:06 AM : Import DN File --->> DN_320_20201027_3537a8c343f929c1a1e73bcb7dd120d1.TXT ### 11/16/2020 4:00:06 AM
11/16/2020 4:00:06 AM : NO Previous File For Distributor 000000000000320 ### Insert Count::1
11/16/2020 4:00:10 AM : For Distributor 000000000000465 Insert Count::4 ### Delete Count::0
11/16/2020 4:00:10 AM : Import DN File --->> DN_465_20201106_63340431990e2a6106d55d697fda06dd.TXT ### 11/16/2020 4:00:10 AM
11/16/2020 4:00:11 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/16/2020 4:00:11 AM : For Distributor 000000000000320 Insert Count::1 ### Delete Count::0
11/16/2020 4:00:11 AM : Import IN File --->> IN_320_20201001_043b4648bea479c416c626f295e3b6cc.TXT ### 11/16/2020 4:00:11 AM
11/16/2020 4:00:12 AM : Import IN File --->> IN_320_20201022_54abf9124291a84482ab774cf9b3b966.TXT ### 11/16/2020 4:00:12 AM
11/16/2020 4:00:12 AM : NO Previous File For Distributor 000000000000320 ### Insert Count::5
11/16/2020 4:00:12 AM : Import IN File --->> IN_320_20201026_374073564df4b3628d83b74ed3d8dc67.TXT ### 11/16/2020 4:00:12 AM
11/16/2020 4:00:12 AM : NO Previous File For Distributor 000000000000320 ### Insert Count::1
11/16/2020 4:00:12 AM : Import IN File --->> IN_320_20201027_961e973db6b1f38955f33dea6ddc01f1.TXT ### 11/16/2020 4:00:12 AM
11/16/2020 4:00:12 AM : NO Previous File For Distributor 000000000000320 ### Insert Count::2
11/16/2020 4:00:12 AM : Import IN File --->> IN_320_20201028_8a3d137c18914fa1e0da1ed99a497777.TXT ### 11/16/2020 4:00:12 AM
11/16/2020 4:00:12 AM : NO Previous File For Distributor 000000000000320 ### Insert Count::1
11/16/2020 4:00:12 AM : Import IN File --->> IN_320_20201029_76537d636ea0b03b3afd9d9ebdbf1744.TXT ### 11/16/2020 4:00:12 AM
11/16/2020 4:00:12 AM : NO Previous File For Distributor 000000000000320 ### Insert Count::1
11/16/2020 4:00:12 AM : Import IN File --->> IN_320_20201030_f9d2034eb15b128f473f0401b4eb145b.TXT ### 11/16/2020 4:00:12 AM
11/16/2020 4:00:12 AM : NO Previous File For Distributor 000000000000320 ### Insert Count::4
11/16/2020 4:00:12 AM : Import IN File --->> IN_320_20201031_6c4f2ebb468edfe36d532a4e03e04410.TXT ### 11/16/2020 4:00:12 AM
11/16/2020 4:00:12 AM : NO Previous File For Distributor 000000000000320 ### Insert Count::1
11/16/2020 4:00:12 AM : Import IN File --->> IN_320_20201103_890cd991cfec33cdf9fd114bf43ce108.TXT ### 11/16/2020 4:00:12 AM
11/16/2020 4:00:12 AM : NO Previous File For Distributor 000000000000320 ### Insert Count::9
11/16/2020 4:00:12 AM : Import IN File --->> IN_320_20201104_a4dbdef25ddb30ac61afada3fae68a5d.TXT ### 11/16/2020 4:00:12 AM
11/16/2020 4:00:12 AM : NO Previous File For Distributor 000000000000320 ### Insert Count::2
11/16/2020 4:00:12 AM : Import IN File --->> IN_320_20201105_09c29b45edea3257f8790ea96eafd708.TXT ### 11/16/2020 4:00:12 AM
11/16/2020 4:00:12 AM : NO Previous File For Distributor 000000000000320 ### Insert Count::8
11/16/2020 4:00:12 AM : Import IN File --->> IN_320_20201107_3d8886bdba6ca36d5c728e47128a0223.TXT ### 11/16/2020 4:00:12 AM
11/16/2020 4:00:12 AM : NO Previous File For Distributor 000000000000320 ### Insert Count::6
11/16/2020 4:00:12 AM : Import IN File --->> IN_320_20201109_6626e54864579af38b9276ded88af0fe.TXT ### 11/16/2020 4:00:12 AM
11/16/2020 4:00:12 AM : NO Previous File For Distributor 000000000000320 ### Insert Count::3
11/16/2020 4:00:12 AM : Import IN File --->> IN_320_20201110_83ac5817ac1d4a3aa52b8b4362b3f839.TXT ### 11/16/2020 4:00:12 AM
11/16/2020 4:00:12 AM : NO Previous File For Distributor 000000000000320 ### Insert Count::3
11/16/2020 4:00:12 AM : Import IN File --->> IN_320_20201111_b2d1ba7464d89798fea62b57dcf4eb07.TXT ### 11/16/2020 4:00:12 AM
11/16/2020 4:00:12 AM : NO Previous File For Distributor 000000000000320 ### Insert Count::3
11/16/2020 4:00:13 AM : For Distributor 000000000000361 Insert Count::1 ### Delete Count::0
11/16/2020 4:00:13 AM : Import IN File --->> IN_361_20201107_f7d88e81649311b6f34766094bafa818.TXT ### 11/16/2020 4:00:13 AM
11/16/2020 4:00:13 AM : Import IN File --->> IN_361_20201113_91aff75ca96dbebb70f5a3fde2a97436.TXT ### 11/16/2020 4:00:13 AM
11/16/2020 4:00:13 AM : NO Previous File For Distributor 000000000000361 ### Insert Count::3
11/16/2020 4:00:15 AM : Exception  ### Index was outside the bounds of the array.
11/16/2020 4:00:15 AM : Error ### Index was outside the bounds of the array. Line 
11/16/2020 4:00:16 AM : Import IN File --->> IN_465_20201108_8bedf052b6cf81b3407b26766f63ea1b.TXT ### 11/16/2020 4:00:16 AM
11/16/2020 4:00:16 AM : NO Previous File For Distributor 000000000000465 ### Insert Count::2
11/16/2020 4:00:16 AM : Import IN File --->> IN_465_20201109_f2e1878fb92051a87e2f3b907291bb00.TXT ### 11/16/2020 4:00:16 AM
11/16/2020 4:00:16 AM : NO Previous File For Distributor 000000000000465 ### Insert Count::15
11/16/2020 4:00:16 AM : Import IN File --->> IN_465_20201110_f2e039ef1de8528ecc3945799ff2d005.TXT ### 11/16/2020 4:00:16 AM
11/16/2020 4:00:16 AM : NO Previous File For Distributor 000000000000465 ### Insert Count::3
11/16/2020 4:00:16 AM : Import IN File --->> IN_465_20201111_f8a82f28cd3f2570f3424bd6d2817e31.TXT ### 11/16/2020 4:00:16 AM
11/16/2020 4:00:16 AM : NO Previous File For Distributor 000000000000465 ### Insert Count::3
11/16/2020 4:00:16 AM : Import IN File --->> IN_465_20201112_c99b096a9ff3a210800c2d51d28af596.TXT ### 11/16/2020 4:00:16 AM
11/16/2020 4:00:17 AM : NO Previous File For Distributor 000000000000465 ### Insert Count::2
11/16/2020 4:00:17 AM : For Distributor 000000000000186 Insert Count::70 ### Delete Count::0
11/16/2020 4:00:17 AM : Import PR File --->> PR_186_20201116_ab79a1bdab27436433f4b700e4733fb8.TXT ### 11/16/2020 4:00:17 AM
11/16/2020 4:00:17 AM : PostData() --->>  ### 11/16/2020 4:00:17 AM
11/16/2020 4:00:18 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 11/16/2020 4:00:18 AM
11/16/2020 4:00:19 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '16/Nov/2020' ### 11/16/2020 4:00:19 AM
11/16/2020 4:00:19 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '16/Nov/2020' ### 11/16/2020 4:00:19 AM
11/16/2020 4:00:19 AM :  ### 
11/16/2020 4:00:19 AM : UNLINKEDSALES Record Count Before --->> 79 ### 11/16/2020 4:00:19 AM
11/16/2020 4:00:19 AM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 11/16/2020 4:00:19 AM
11/16/2020 4:00:24 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '16/Nov/2020' ### 11/16/2020 4:00:24 AM
11/16/2020 4:00:24 AM : UNLINKEDSALES Record Count After --->> 0 ### 11/16/2020 4:00:24 AM
11/16/2020 4:00:24 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 11/16/2020 4:00:24 AM
11/16/2020 4:00:24 AM :  ### 
11/16/2020 4:00:24 AM : Posting Supplierlink Query for Purchases --->>  ### 11/16/2020 4:00:24 AM
11/16/2020 4:00:29 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '16/Nov/2020' ### 11/16/2020 4:00:29 AM
11/16/2020 4:00:34 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '16/Nov/2020' ### 11/16/2020 4:00:34 AM
11/16/2020 4:00:34 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 11/16/2020 4:00:34 AM
11/16/2020 4:00:34 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '16/Nov/2020' ### 11/16/2020 4:00:34 AM
11/16/2020 4:00:34 AM : Posting ClosingStock Successful --->>  ### 11/16/2020 4:00:34 AM
11/16/2020 4:00:34 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 11/16/2020 4:00:34 AM
11/16/2020 4:00:34 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
11/16/2020 4:00:34 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1988040_TEMPLATE1.txt ### 11/16/2020 4:00:34 AM
11/16/2020 4:00:34 AM : Count:: ### TEMPLATE1:231
11/16/2020 4:00:37 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/16/2020 4:00:37 AM
11/16/2020 4:00:37 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3557224_TEMPLATE1.txt ### 11/16/2020 4:00:37 AM
11/16/2020 4:00:37 AM : Count:: ### TEMPLATE1:7
11/16/2020 4:00:37 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/16/2020 4:00:37 AM
11/16/2020 4:00:37 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3596136_TEMPLATE1.txt ### 11/16/2020 4:00:37 AM
11/16/2020 4:00:37 AM : Count:: ### TEMPLATE1:60
11/16/2020 4:00:37 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/16/2020 4:00:37 AM
11/16/2020 4:00:37 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3814332_TEMPLATE1.txt ### 11/16/2020 4:00:37 AM
11/16/2020 4:00:37 AM : Count:: ### TEMPLATE1:13
11/16/2020 4:00:37 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/16/2020 4:00:37 AM
11/16/2020 4:00:37 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3831146_TEMPLATE1.txt ### 11/16/2020 4:00:37 AM
11/16/2020 4:00:37 AM : Count:: ### TEMPLATE1:16
11/16/2020 4:00:38 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/16/2020 4:00:38 AM
11/16/2020 4:00:38 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3966389_TEMPLATE1.txt ### 11/16/2020 4:00:38 AM
11/16/2020 4:00:38 AM : Count:: ### TEMPLATE1:40
11/16/2020 4:00:38 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/16/2020 4:00:38 AM
11/16/2020 4:00:38 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4082314_TEMPLATE1.TXT ### 11/16/2020 4:00:38 AM
11/16/2020 4:00:38 AM : Count:: ### TEMPLATE1:60
11/16/2020 4:00:39 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/16/2020 4:00:39 AM
11/16/2020 4:00:39 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4277134_TEMPLATE1.txt ### 11/16/2020 4:00:39 AM
11/16/2020 4:00:39 AM : Count:: ### TEMPLATE1:148
11/16/2020 4:00:40 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/16/2020 4:00:40 AM
11/16/2020 4:00:40 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4526825_TEMPLATE1.txt ### 11/16/2020 4:00:40 AM
11/16/2020 4:00:40 AM : Count:: ### TEMPLATE1:17
11/16/2020 4:00:40 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/16/2020 4:00:40 AM
11/16/2020 4:00:40 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4529171_TEMPLATE1.txt ### 11/16/2020 4:00:40 AM
11/16/2020 4:00:40 AM : Count:: ### TEMPLATE1:34
11/16/2020 4:00:41 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/16/2020 4:00:41 AM
11/16/2020 4:00:41 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060559_TEMPLATE1.txt ### 11/16/2020 4:00:41 AM
11/16/2020 4:00:41 AM : Count:: ### TEMPLATE1:133
11/16/2020 4:00:43 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/16/2020 4:00:43 AM
11/16/2020 4:00:43 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062599_TEMPLATE1.txt ### 11/16/2020 4:00:43 AM
11/16/2020 4:00:43 AM : Count:: ### TEMPLATE1:155
11/16/2020 4:00:44 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/16/2020 4:00:44 AM
11/16/2020 4:00:44 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062804_TEMPLATE1.txt ### 11/16/2020 4:00:44 AM
11/16/2020 4:00:44 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
11/16/2020 4:00:44 AM : Template Import Complete  ### 11/16/2020 4:00:44 AM
11/16/2020 4:00:45 AM : Completed Updating Has Transaction Flag  ### 11/16/2020 4:00:45 AM
11/16/2020 4:00:45 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 11/16/2020 4:00:45 AM
11/16/2020 4:00:45 AM : Zylem Access Unblocked  ### 11/16/2020 4:00:45 AM
11/16/2020 4:00:45 AM : Application Ended  ### 11/16/2020 4:00:45 AM