11/15/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/15/2020 4:00:04 AM : StartProcess  ### 11/15/2020 4:00:04 AM

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

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

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

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

11/15/2020 4:00:04 AM : Start Process : checkAllTablesExists()  ### 
11/15/2020 4:00:04 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 11/15/2020 4:00:04 AM
11/15/2020 4:00:04 AM : MainForm_Load  ### AlertSystem ON
11/15/2020 4:00:04 AM : No. of Files to import (RECEIVEFINAL):  ### 1113
11/15/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/15/2020 4:00:05 AM : For Distributor 000000000000035 Insert Count::3 ### Delete Count::0
11/15/2020 4:00:05 AM : Import AD File --->> AD_35_20201114_9f0873d70252c0cc3b4a1c652c98811a.TXT ### 11/15/2020 4:00:05 AM
11/15/2020 4:00:07 AM : For Distributor 000000000000025 Insert Count::1 ### Delete Count::1
11/15/2020 4:00:07 AM : Import DN File --->> DN_25_20201014_54f38190f0c253362149a0acb4fc48a7.TXT ### 11/15/2020 4:00:07 AM
11/15/2020 4:00:07 AM : For Distributor 000000000000025 Insert Count::1 ### Delete Count::1
11/15/2020 4:00:07 AM : Import DN File --->> DN_25_20201019_dfb1a4cb223f21b7b6fef30345854211.TXT ### 11/15/2020 4:00:07 AM
11/15/2020 4:00:07 AM : For Distributor 000000000000025 Insert Count::1 ### Delete Count::1
11/15/2020 4:00:07 AM : Import DN File --->> DN_25_20201027_16ee4e43bf451a52cef54e7954bdccce.TXT ### 11/15/2020 4:00:07 AM
11/15/2020 4:00:07 AM : For Distributor 000000000000025 Insert Count::1 ### Delete Count::1
11/15/2020 4:00:07 AM : Import DN File --->> DN_25_20201028_462b80c936c8ce9582688677769db106.TXT ### 11/15/2020 4:00:07 AM
11/15/2020 4:00:10 AM : For Distributor 000000000000357 Insert Count::1 ### Delete Count::0
11/15/2020 4:00:10 AM : Import DN File --->> DN_357_20201109_6a753e186a53144859a3e63898728289.TXT ### 11/15/2020 4:00:10 AM
11/15/2020 4:00:14 AM : For Distributor 000000000000180 Insert Count::4 ### Delete Count::0
11/15/2020 4:00:14 AM : Import IN File --->> IN_180_20201015_8a75a0257ef75ff931afdda3737f2f67.TXT ### 11/15/2020 4:00:14 AM
11/15/2020 4:00:14 AM : For Distributor 000000000000180 Insert Count::2 ### Delete Count::0
11/15/2020 4:00:14 AM : Import IN File --->> IN_180_20201016_bfb08da6806b31ce0575b3e52c34d51b.TXT ### 11/15/2020 4:00:14 AM
11/15/2020 4:00:14 AM : For Distributor 000000000000180 Insert Count::9 ### Delete Count::0
11/15/2020 4:00:14 AM : Import IN File --->> IN_180_20201017_6aef92fef48ee0079edfd07c68564758.TXT ### 11/15/2020 4:00:14 AM
11/15/2020 4:00:14 AM : For Distributor 000000000000180 Insert Count::1 ### Delete Count::0
11/15/2020 4:00:14 AM : Import IN File --->> IN_180_20201020_947d8a296de5fd05cb85dc09d27f939f.TXT ### 11/15/2020 4:00:14 AM
11/15/2020 4:00:14 AM : For Distributor 000000000000180 Insert Count::2 ### Delete Count::0
11/15/2020 4:00:14 AM : Import IN File --->> IN_180_20201021_e6933cb6011dc0a99529ef1a28d2df3c.TXT ### 11/15/2020 4:00:14 AM
11/15/2020 4:00:15 AM : For Distributor 000000000000180 Insert Count::3 ### Delete Count::0
11/15/2020 4:00:15 AM : Import IN File --->> IN_180_20201022_91fd45da3f6c81513b043c102ee3ae67.TXT ### 11/15/2020 4:00:15 AM
11/15/2020 4:00:15 AM : For Distributor 000000000000180 Insert Count::1 ### Delete Count::0
11/15/2020 4:00:15 AM : Import IN File --->> IN_180_20201024_fe4605948238595031b89a9549f86652.TXT ### 11/15/2020 4:00:15 AM
11/15/2020 4:00:15 AM : For Distributor 000000000000180 Insert Count::5 ### Delete Count::0
11/15/2020 4:00:15 AM : Import IN File --->> IN_180_20201026_4834e439fde45b9757da9812af4c765d.TXT ### 11/15/2020 4:00:15 AM
11/15/2020 4:00:15 AM : For Distributor 000000000000180 Insert Count::2 ### Delete Count::0
11/15/2020 4:00:15 AM : Import IN File --->> IN_180_20201027_3f60a9397aef1a371909cf40fbd809f8.TXT ### 11/15/2020 4:00:15 AM
11/15/2020 4:00:15 AM : For Distributor 000000000000025 Insert Count::6 ### Delete Count::0
11/15/2020 4:00:15 AM : Import IN File --->> IN_25_20201001_6e812888e8ebd9469986d4c06895f968.TXT ### 11/15/2020 4:00:15 AM
11/15/2020 4:00:16 AM : For Distributor 000000000000025 Insert Count::1 ### Delete Count::0
11/15/2020 4:00:16 AM : Import IN File --->> IN_25_20201019_28c17ed1ddd166dd08a7585e99067052.TXT ### 11/15/2020 4:00:16 AM
11/15/2020 4:00:16 AM : For Distributor 000000000000025 Insert Count::1 ### Delete Count::0
11/15/2020 4:00:16 AM : Import IN File --->> IN_25_20201026_dda660d77b0b75558b5bf3f1bd3e38db.TXT ### 11/15/2020 4:00:16 AM
11/15/2020 4:00:16 AM : For Distributor 000000000000025 Insert Count::1 ### Delete Count::0
11/15/2020 4:00:16 AM : Import IN File --->> IN_25_20201030_3f8189905f416b5633f75a8d416ccb57.TXT ### 11/15/2020 4:00:16 AM
11/15/2020 4:00:18 AM : For Distributor 000000000000357 Insert Count::1 ### Delete Count::0
11/15/2020 4:00:18 AM : Import IN File --->> IN_357_20201113_83321c8afcac353e03acc33deea0dec7.TXT ### 11/15/2020 4:00:18 AM
11/15/2020 4:00:19 AM : For Distributor 000000000000035 Insert Count::1 ### Delete Count::1
11/15/2020 4:00:19 AM : Import IN File --->> IN_35_20201105_5aa732e8b407a82e723b41ae97225ea1.TXT ### 11/15/2020 4:00:19 AM
11/15/2020 4:00:19 AM : For Distributor 000000000000035 Insert Count::20 ### Delete Count::0
11/15/2020 4:00:19 AM : Import IN File --->> IN_35_20201113_31ea9c19aba864a18695f742e34d4074.TXT ### 11/15/2020 4:00:19 AM
11/15/2020 4:00:20 AM : Exception  ### Index was outside the bounds of the array.
11/15/2020 4:00:20 AM : Error ### Index was outside the bounds of the array. Line 
11/15/2020 4:00:23 AM : PostData() --->>  ### 11/15/2020 4:00:23 AM
11/15/2020 4:00:23 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 11/15/2020 4:00:23 AM
11/15/2020 4:00:23 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '15/Nov/2020' ### 11/15/2020 4:00:23 AM
11/15/2020 4:00:23 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '15/Nov/2020' ### 11/15/2020 4:00:23 AM
11/15/2020 4:00:23 AM :  ### 
11/15/2020 4:00:23 AM : UNLINKEDSALES Record Count Before --->> 60 ### 11/15/2020 4:00:23 AM
11/15/2020 4:00:23 AM : UNLINKEDSALES_DEL Record Count Before --->> 1 ### 11/15/2020 4:00:23 AM
11/15/2020 4:00:29 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '15/Nov/2020' ### 11/15/2020 4:00:29 AM
11/15/2020 4:00:29 AM : UNLINKEDSALES Record Count After --->> 0 ### 11/15/2020 4:00:29 AM
11/15/2020 4:00:29 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 11/15/2020 4:00:29 AM
11/15/2020 4:00:29 AM :  ### 
11/15/2020 4:00:29 AM : Posting Supplierlink Query for Purchases --->>  ### 11/15/2020 4:00:29 AM
11/15/2020 4:00:34 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '15/Nov/2020' ### 11/15/2020 4:00:34 AM
11/15/2020 4:00:38 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '15/Nov/2020' ### 11/15/2020 4:00:38 AM
11/15/2020 4:00:38 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 11/15/2020 4:00:38 AM
11/15/2020 4:00:39 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '15/Nov/2020' ### 11/15/2020 4:00:39 AM
11/15/2020 4:00:39 AM : Posting ClosingStock Successful --->>  ### 11/15/2020 4:00:39 AM
11/15/2020 4:00:39 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 11/15/2020 4:00:39 AM
11/15/2020 4:00:39 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
11/15/2020 4:00:39 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1988040_TEMPLATE1.txt ### 11/15/2020 4:00:39 AM
11/15/2020 4:00:39 AM : Count:: ### TEMPLATE1:231
11/15/2020 4:00:42 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/15/2020 4:00:42 AM
11/15/2020 4:00:42 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2838040_TEMPLATE1.TXT ### 11/15/2020 4:00:42 AM
11/15/2020 4:00:42 AM : Count:: ### TEMPLATE1:151
11/15/2020 4:00:43 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/15/2020 4:00:43 AM
11/15/2020 4:00:43 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3573015_TEMPLATE1.txt ### 11/15/2020 4:00:43 AM
11/15/2020 4:00:43 AM : Count:: ### TEMPLATE1:3
11/15/2020 4:00:43 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/15/2020 4:00:43 AM
11/15/2020 4:00:43 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3596136_TEMPLATE1.txt ### 11/15/2020 4:00:43 AM
11/15/2020 4:00:43 AM : Count:: ### TEMPLATE1:60
11/15/2020 4:00:44 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/15/2020 4:00:44 AM
11/15/2020 4:00:44 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3952308_TEMPLATE1.txt ### 11/15/2020 4:00:44 AM
11/15/2020 4:00:44 AM : Count:: ### TEMPLATE1:63
11/15/2020 4:00:45 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/15/2020 4:00:45 AM
11/15/2020 4:00:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3963576_TEMPLATE1.txt ### 11/15/2020 4:00:45 AM
11/15/2020 4:00:45 AM : Count:: ### TEMPLATE1:22
11/15/2020 4:00:45 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/15/2020 4:00:45 AM
11/15/2020 4:00:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3966389_TEMPLATE1.txt ### 11/15/2020 4:00:45 AM
11/15/2020 4:00:45 AM : Count:: ### TEMPLATE1:40
11/15/2020 4:00:46 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/15/2020 4:00:46 AM
11/15/2020 4:00:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4277134_TEMPLATE1.txt ### 11/15/2020 4:00:46 AM
11/15/2020 4:00:46 AM : Count:: ### TEMPLATE1:148
11/15/2020 4:00:47 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/15/2020 4:00:47 AM
11/15/2020 4:00:47 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4526825_TEMPLATE1.txt ### 11/15/2020 4:00:47 AM
11/15/2020 4:00:47 AM : Count:: ### TEMPLATE1:17
11/15/2020 4:00:47 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/15/2020 4:00:47 AM
11/15/2020 4:00:47 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4529171_TEMPLATE1.txt ### 11/15/2020 4:00:47 AM
11/15/2020 4:00:47 AM : Count:: ### TEMPLATE1:34
11/15/2020 4:00:48 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/15/2020 4:00:48 AM
11/15/2020 4:00:48 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060613_TEMPLATE1.txt ### 11/15/2020 4:00:48 AM
11/15/2020 4:00:48 AM : Count:: ### TEMPLATE1:3132
11/15/2020 4:00:48 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/15/2020 4:00:48 AM
11/15/2020 4:00:48 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061385_TEMPLATE1.TXT ### 11/15/2020 4:00:48 AM
11/15/2020 4:00:48 AM : Count:: ### TEMPLATE1:41
11/15/2020 4:00:48 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/15/2020 4:00:48 AM
11/15/2020 4:00:48 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061625_TEMPLATE1.txt ### 11/15/2020 4:00:48 AM
11/15/2020 4:00:48 AM : Count:: ### TEMPLATE1:146
11/15/2020 4:00:51 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/15/2020 4:00:51 AM
11/15/2020 4:00:51 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062804_TEMPLATE1.txt ### 11/15/2020 4:00:51 AM
11/15/2020 4:00:51 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
11/15/2020 4:00:51 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067092_TEMPLATE1.TXT ### 11/15/2020 4:00:51 AM
11/15/2020 4:00:51 AM : Count:: ### TEMPLATE1:65
11/15/2020 4:00:52 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/15/2020 4:00:52 AM
11/15/2020 4:00:52 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9068225_TEMPLATE1.txt ### 11/15/2020 4:00:52 AM
11/15/2020 4:00:52 AM : Count:: ### TEMPLATE1:162
11/15/2020 4:00:53 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/15/2020 4:00:53 AM
11/15/2020 4:00:53 AM : Template Import Complete  ### 11/15/2020 4:00:53 AM
11/15/2020 4:00:54 AM : Completed Updating Has Transaction Flag  ### 11/15/2020 4:00:54 AM
11/15/2020 4:00:54 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 11/15/2020 4:00:54 AM
11/15/2020 4:00:54 AM : Zylem Access Unblocked  ### 11/15/2020 4:00:54 AM
11/15/2020 4:00:54 AM : Application Ended  ### 11/15/2020 4:00:54 AM