10/27/2020 4:00: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
10/27/2020 4:00:02 AM : StartProcess  ### 10/27/2020 4:00:02 AM

10/27/2020 4:00:02 AM : 11  ### 10/27/2020 4:00:02 AM

10/27/2020 4:00:02 AM : 22  ### 10/27/2020 4:00:02 AM

10/27/2020 4:00:02 AM : 33  ### 10/27/2020 4:00:02 AM

10/27/2020 4:00:02 AM : Application Started  ### 10/27/2020 4:00:02 AM

10/27/2020 4:00:02 AM : Start Process : checkAllTablesExists()  ### 
10/27/2020 4:00:02 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 10/27/2020 4:00:02 AM
10/27/2020 4:00:02 AM : MainForm_Load  ### AlertSystem ON
10/27/2020 4:00:02 AM : No. of Files to import (RECEIVEFINAL):  ### 570
10/27/2020 4:00:02 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
10/27/2020 4:00:03 AM : For Distributor 000000000000025 Insert Count::3 ### Delete Count::0
10/27/2020 4:00:03 AM : Import AD File --->> AD_25_20201026_6c04d67ba7e62fca7bc9128461ece63d.TXT ### 10/27/2020 4:00:03 AM
10/27/2020 4:00:03 AM : For Distributor 000000000000452 Insert Count::4 ### Delete Count::4
10/27/2020 4:00:03 AM : Import AD File --->> AD_452_20201027_3faba2ae829b46fdb4c3c4efdd7d0375.TXT ### 10/27/2020 4:00:03 AM
10/27/2020 4:00:04 AM : For Distributor 000000000000025 Insert Count::1 ### Delete Count::1
10/27/2020 4:00:04 AM : Import DN File --->> DN_25_20201014_e030326473d6d482f913cd0258bc19e1.TXT ### 10/27/2020 4:00:04 AM
10/27/2020 4:00:04 AM : For Distributor 000000000000025 Insert Count::1 ### Delete Count::0
10/27/2020 4:00:04 AM : Import DN File --->> DN_25_20201019_3448d6a7e4215631e22f4245ffdabf0e.TXT ### 10/27/2020 4:00:04 AM
10/27/2020 4:00:05 AM : Import DN File --->> DN_452_20201026_fa783ff22abd31824f1a7119bd08b82e.TXT ### 10/27/2020 4:00:05 AM
10/27/2020 4:00:05 AM : NO Previous File For Distributor 000000000000452 ### Insert Count::1
10/27/2020 4:00:06 AM : For Distributor 000000000000012 Insert Count::1 ### Delete Count::0
10/27/2020 4:00:06 AM : Import IN File --->> IN_12_20201022_a642d89c4680c5fe47c2bd369b16bc28.TXT ### 10/27/2020 4:00:06 AM
10/27/2020 4:00:06 AM : For Distributor 000000000000012 Insert Count::1 ### Delete Count::0
10/27/2020 4:00:06 AM : Import IN File --->> IN_12_20201023_151ac68f812f747129350c70911db8b3.TXT ### 10/27/2020 4:00:06 AM
10/27/2020 4:00:06 AM : For Distributor 000000000000012 Insert Count::1 ### Delete Count::0
10/27/2020 4:00:06 AM : Import IN File --->> IN_12_20201024_5275eeaa85a41836620d347e2bf845ff.TXT ### 10/27/2020 4:00:06 AM
10/27/2020 4:00:06 AM : For Distributor 000000000000012 Insert Count::2 ### Delete Count::0
10/27/2020 4:00:06 AM : Import IN File --->> IN_12_20201026_e4909e7c26383f6a277f799ca055740b.TXT ### 10/27/2020 4:00:06 AM
10/27/2020 4:00:06 AM : Import IN File --->> IN_25_20201026_fcf8770074727b31e1bf2b9268fbccbb.TXT ### 10/27/2020 4:00:06 AM
10/27/2020 4:00:07 AM : NO Previous File For Distributor 000000000000025 ### Insert Count::1
10/27/2020 4:00:08 AM : For Distributor 000000000000040 Insert Count::17 ### Delete Count::0
10/27/2020 4:00:08 AM : Import IN File --->> IN_40_20201026_f2aa50bc510bfabf4f5fc08c41fc5541.TXT ### 10/27/2020 4:00:08 AM
10/27/2020 4:00:08 AM : For Distributor 000000000000452 Insert Count::5 ### Delete Count::0
10/27/2020 4:00:08 AM : Import IN File --->> IN_452_20201024_15a9b59616dff876e9b5034778a3200a.TXT ### 10/27/2020 4:00:08 AM
10/27/2020 4:00:08 AM : Import IN File --->> IN_452_20201026_17a47713146e0269a44d645043b499c9.TXT ### 10/27/2020 4:00:08 AM
10/27/2020 4:00:08 AM : NO Previous File For Distributor 000000000000452 ### Insert Count::9
10/27/2020 4:00:09 AM : PostData() --->>  ### 10/27/2020 4:00:09 AM
10/27/2020 4:00:09 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 10/27/2020 4:00:09 AM
10/27/2020 4:00:09 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '27/Oct/2020' ### 10/27/2020 4:00:09 AM
10/27/2020 4:00:10 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '27/Oct/2020' ### 10/27/2020 4:00:10 AM
10/27/2020 4:00:10 AM :  ### 
10/27/2020 4:00:10 AM : UNLINKEDSALES Record Count Before --->> 37 ### 10/27/2020 4:00:10 AM
10/27/2020 4:00:10 AM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 10/27/2020 4:00:10 AM
10/27/2020 4:00:14 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '27/Oct/2020' ### 10/27/2020 4:00:14 AM
10/27/2020 4:00:14 AM : UNLINKEDSALES Record Count After --->> 0 ### 10/27/2020 4:00:14 AM
10/27/2020 4:00:14 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 10/27/2020 4:00:14 AM
10/27/2020 4:00:14 AM :  ### 
10/27/2020 4:00:14 AM : Posting Supplierlink Query for Purchases --->>  ### 10/27/2020 4:00:14 AM
10/27/2020 4:00:19 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '27/Oct/2020' ### 10/27/2020 4:00:19 AM
10/27/2020 4:00:24 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '27/Oct/2020' ### 10/27/2020 4:00:24 AM
10/27/2020 4:00:24 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 10/27/2020 4:00:24 AM
10/27/2020 4:00:24 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '27/Oct/2020' ### 10/27/2020 4:00:24 AM
10/27/2020 4:00:24 AM : Posting ClosingStock Successful --->>  ### 10/27/2020 4:00:24 AM
10/27/2020 4:00:24 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 10/27/2020 4:00:24 AM
10/27/2020 4:00:24 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
10/27/2020 4:00:24 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2186196_TEMPLATE1.txt ### 10/27/2020 4:00:24 AM
10/27/2020 4:00:24 AM : Count:: ### TEMPLATE1:28
10/27/2020 4:00:24 AM : SP_DistributorTemplatePosting Successful --->>  ### 10/27/2020 4:00:24 AM
10/27/2020 4:00:24 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3573015_TEMPLATE1.txt ### 10/27/2020 4:00:24 AM
10/27/2020 4:00:24 AM : Count:: ### TEMPLATE1:3
10/27/2020 4:00:24 AM : SP_DistributorTemplatePosting Successful --->>  ### 10/27/2020 4:00:24 AM
10/27/2020 4:00:24 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4277134_TEMPLATE1.txt ### 10/27/2020 4:00:24 AM
10/27/2020 4:00:24 AM : Count:: ### TEMPLATE1:148
10/27/2020 4:00:24 AM : SP_DistributorTemplatePosting Successful --->>  ### 10/27/2020 4:00:24 AM
10/27/2020 4:00:24 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062804_TEMPLATE1.txt ### 10/27/2020 4:00:24 AM
10/27/2020 4:00:24 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
10/27/2020 4:00:24 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9065122_TEMPLATE1.txt ### 10/27/2020 4:00:24 AM
10/27/2020 4:00:24 AM : Count:: ### TEMPLATE1:317
10/27/2020 4:00:24 AM : SP_DistributorTemplatePosting Successful --->>  ### 10/27/2020 4:00:24 AM
10/27/2020 4:00:24 AM : Template Import Complete  ### 10/27/2020 4:00:24 AM
10/27/2020 4:00:25 AM : Completed Updating Has Transaction Flag  ### 10/27/2020 4:00:25 AM
10/27/2020 4:00:25 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 10/27/2020 4:00:25 AM
10/27/2020 4:00:25 AM : Zylem Access Unblocked  ### 10/27/2020 4:00:25 AM
10/27/2020 4:00:25 AM : Application Ended  ### 10/27/2020 4:00:25 AM