7/25/2022 2:30:02 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 2:30:03 AM : StartProcess  ### 7/25/2022 2:30:03 AM

7/25/2022 2:30:03 AM : Importing Running from Zylem App, Wait for some time. Value of BlockImportingProcess - 0 ### 7/25/2022 2:30:03 AM

7/25/2022 2:30:03 AM : Max No Of Retry In Minutes For WaitingState. MaxNoOfRetryInMinForWaitingState - 2 ### Expected waiting time is 7/25/2022 2:32:03 AM

7/25/2022 2:30:03 AM : Importing Running from Zylem App End. Value of BlockImportingProcess - 0 ### 7/25/2022 2:30:03 AM

7/25/2022 2:30:03 AM : Importing started from WinZylemImport exe. Updated Value of BlockImportingProcess - 1 in Settings table ### 7/25/2022 2:30:03 AM

7/25/2022 2:30:03 AM : 11  ### 7/25/2022 2:30:03 AM

7/25/2022 2:30:03 AM : 22  ### 7/25/2022 2:30:03 AM

7/25/2022 2:30:03 AM : 33  ### 7/25/2022 2:30:03 AM

7/25/2022 2:30:03 AM : Application Started  ### 7/25/2022 2:30:03 AM

7/25/2022 2:30:03 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 2:30:03 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 7/25/2022 2:30:03 AM
7/25/2022 2:30:03 AM : MainForm_Load  ### AlertSystem ON
7/25/2022 2:30:04 AM : No. of Files to import (RECEIVEFINAL):  ### 1
7/25/2022 2:30:04 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
7/25/2022 2:30:04 AM : PostData() --->>  ### 7/25/2022 2:30:04 AM
7/25/2022 2:30:04 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 7/25/2022 2:30:04 AM
7/25/2022 2:30:04 AM : SupplierLink Successful --->> exec SP_SupplierLinkDiff '25/Jul/2022' ### 7/25/2022 2:30:04 AM
7/25/2022 2:30:05 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '25/Jul/2022' ### 7/25/2022 2:30:05 AM
7/25/2022 2:30:05 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '25/Jul/2022' ### 7/25/2022 2:30:05 AM
7/25/2022 2:30:05 AM :  ### 
7/25/2022 2:30:05 AM : UNLINKEDSALES Record Count Before --->> 0 ### 7/25/2022 2:30:05 AM
7/25/2022 2:30:05 AM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 7/25/2022 2:30:05 AM
7/25/2022 2:30:15 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '25/Jul/2022' ### 7/25/2022 2:30:15 AM
7/25/2022 2:30:15 AM : UNLINKEDSALES Record Count After --->> 0 ### 7/25/2022 2:30:15 AM
7/25/2022 2:30:15 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 7/25/2022 2:30:15 AM
7/25/2022 2:30:15 AM :  ### 
7/25/2022 2:30:21 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '25/Jul/2022' ### 7/25/2022 2:30:21 AM
7/25/2022 2:30:28 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '25/Jul/2022' ### 7/25/2022 2:30:28 AM
7/25/2022 2:30:28 AM : Posting Supplierlink Query for CompanyPurchases --->> insert into supplierlink (code,distributorid,name,InsertDate,InsertedDate,LastEditDate,targetid)
                   select distinct suppliercode,PDistributor.distributorid,'' as name, '1900-01-01','2022-07-25 02:30:28','2022-07-25 02:30:28',PDistributor.UnkSupplierId as targetid from UNLINKEDCOMPANYPURCHASES,PDistributor where UNLINKEDCOMPANYPURCHASES.erpcode=PDistributor.erpcode and PDistributor.distributorid+unlinkedcompanypurchases.suppliercode not in (select distinct distributorid+code from supplierlink where code is not null) ### 7/25/2022 2:30:28 AM
7/25/2022 2:30:28 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '25/Jul/2022' ### 7/25/2022 2:30:28 AM
7/25/2022 2:30:29 AM : Posting ClosingStock Successful --->>  ### 7/25/2022 2:30:29 AM
7/25/2022 2:30:29 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 7/25/2022 2:30:29 AM
7/25/2022 2:30:29 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
7/25/2022 2:30:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 7/25/2022 2:30:29 AM
7/25/2022 2:30:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:30:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 7/25/2022 2:30:29 AM
7/25/2022 2:30:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:30:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 7/25/2022 2:30:29 AM
7/25/2022 2:30:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:30:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 7/25/2022 2:30:29 AM
7/25/2022 2:30:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:30:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 7/25/2022 2:30:29 AM
7/25/2022 2:30:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:30:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3559252_TEMPLATE1.TXT ### 7/25/2022 2:30:29 AM
7/25/2022 2:30:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:30:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 7/25/2022 2:30:29 AM
7/25/2022 2:30:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:30:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 7/25/2022 2:30:29 AM
7/25/2022 2:30:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:30:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 7/25/2022 2:30:29 AM
7/25/2022 2:30:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:30:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 7/25/2022 2:30:29 AM
7/25/2022 2:30:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:30:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 7/25/2022 2:30:29 AM
7/25/2022 2:30:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:30:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 7/25/2022 2:30:29 AM
7/25/2022 2:30:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:30:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 7/25/2022 2:30:29 AM
7/25/2022 2:30:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:30:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 7/25/2022 2:30:29 AM
7/25/2022 2:30:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:30:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 7/25/2022 2:30:29 AM
7/25/2022 2:30:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:30:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 7/25/2022 2:30:29 AM
7/25/2022 2:30:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:30:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062898_TEMPLATE1.TXT ### 7/25/2022 2:30:29 AM
7/25/2022 2:30:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:30:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 7/25/2022 2:30:29 AM
7/25/2022 2:30:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:30:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 7/25/2022 2:30:29 AM
7/25/2022 2:30:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:30:29 AM : Error in file  ### TEMPLATE1 (1) at Line 124
7/25/2022 2:30:29 AM : Template Import Complete  ### 7/25/2022 2:30:29 AM
7/25/2022 2:30:32 AM : Completed Updating Has Transaction Flag  ### 7/25/2022 2:30:32 AM
7/25/2022 2:30:32 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 7/25/2022 2:30:32 AM
7/25/2022 2:30:32 AM : Zylem Access Unblocked  ### 7/25/2022 2:30:32 AM
7/25/2022 2:30:32 AM : MainForm_Load  ### Before Add Entry In Monitoring database
7/25/2022 2:30:32 AM : MainForm_Load  ### After Add Entry In Monitoring database
7/25/2022 2:30:32 AM : StartProcess for importing Closing stock file from ClosingStock folder  ### 7/25/2022 2:30:32 AM

7/25/2022 2:30:32 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 2:30:32 AM : Validation Start For All  ### 7/25/2022 2:30:32 AM
7/25/2022 2:30:32 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 2:30:32 AM : BAYER_2155816_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 1 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 2 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 3 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 4 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 5 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 6 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 7 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 8 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 9 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 10 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 11 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 12 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 13 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 14 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 15 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 16 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 17 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 18 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 19 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 20 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 21 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 22 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 23 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 24 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 25 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 26 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 27 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 28 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 29 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 30 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 31 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 32 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 33 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 34 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 35 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 36 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 37 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 38 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 39 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 40 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 41 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 42 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 43 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 44 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 45 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 46 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 47 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 48 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 49 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 50 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 51 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 52 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 53 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 54 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 55 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 56 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 57 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 58 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 59 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 60 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 61 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 62 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 63 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 64 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 65 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 66 ### 
7/25/2022 2:30:32 AM : File Not Valid for Distributor ERPCode-2155816 ### BAYER_2155816_CLOSINGSTOCK.TXT
7/25/2022 2:30:32 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 2:30:32 AM : BAYER_3888864_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 1 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 2 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 3 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 4 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 5 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 6 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 7 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 8 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 9 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 10 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 11 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 12 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 13 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 14 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 15 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 16 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 17 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 18 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 19 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 20 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 21 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 22 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 23 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 24 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 25 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 26 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 27 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 28 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 29 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 30 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 31 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 32 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 33 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 34 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 35 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 36 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 37 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 38 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 39 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 40 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 41 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 42 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 43 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 44 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 45 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 46 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 47 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 48 ### 
7/25/2022 2:30:32 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 49 ### 
7/25/2022 2:30:33 AM : File Not Valid for Distributor ERPCode-3888864 ### BAYER_3888864_CLOSINGSTOCK.TXT
7/25/2022 2:30:33 AM : End Process for importing Closing stock file from ClosingStock folder End Time----------- ### 7/25/2022 2:30:33 AM
7/25/2022 2:30:33 AM : Importing ended from WinZylemImport exe. Updated Value of BlockImportingProcess - 0 in Settings table ### 7/25/2022 2:30:33 AM

7/25/2022 2:30:33 AM : Application Ended  ### 7/25/2022 2:30:33 AM

7/25/2022 7:30:05 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 7:30:06 AM : StartProcess  ### 7/25/2022 7:30:06 AM

7/25/2022 7:30:06 AM : Importing Running from Zylem App, Wait for some time. Value of BlockImportingProcess - 0 ### 7/25/2022 7:30:06 AM

7/25/2022 7:30:06 AM : Max No Of Retry In Minutes For WaitingState. MaxNoOfRetryInMinForWaitingState - 2 ### Expected waiting time is 7/25/2022 7:32:06 AM

7/25/2022 7:30:06 AM : Importing Running from Zylem App End. Value of BlockImportingProcess - 0 ### 7/25/2022 7:30:06 AM

7/25/2022 7:30:06 AM : Importing started from WinZylemImport exe. Updated Value of BlockImportingProcess - 1 in Settings table ### 7/25/2022 7:30:06 AM

7/25/2022 7:30:06 AM : 11  ### 7/25/2022 7:30:06 AM

7/25/2022 7:30:06 AM : 22  ### 7/25/2022 7:30:06 AM

7/25/2022 7:30:06 AM : 33  ### 7/25/2022 7:30:06 AM

7/25/2022 7:30:06 AM : Application Started  ### 7/25/2022 7:30:06 AM

7/25/2022 7:30:06 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 7:30:06 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 7/25/2022 7:30:06 AM
7/25/2022 7:30:06 AM : MainForm_Load  ### AlertSystem ON
7/25/2022 7:30:06 AM : No. of Files to import (RECEIVEFINAL):  ### 3462
7/25/2022 7:30:06 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
7/25/2022 7:30:07 AM : For Distributor 000000000000353 Insert Count::10 ### Delete Count::5
7/25/2022 7:30:07 AM : Import AD File --->> AD_353_20220725_e0bb87a3ce0c793559e1cb163f57075d.TXT ### 7/25/2022 7:30:07 AM
7/25/2022 7:30:07 AM : For Distributor 000000000000665 Insert Count::1 ### Delete Count::0
7/25/2022 7:30:07 AM : Import AD File --->> AD_665_20220725_8eb2c24c754627868d0493bf48c794da.TXT ### 7/25/2022 7:30:07 AM
7/25/2022 7:30:07 AM : For Distributor 000000000000809 Insert Count::9 ### Delete Count::0
7/25/2022 7:30:07 AM : Import AD File --->> AD_809_20220725_11de03d3986620829d775c8109c21487.TXT ### 7/25/2022 7:30:07 AM
7/25/2022 7:30:49 AM : For Distributor 000000000000809 Insert Count::4 ### Delete Count::0
7/25/2022 7:30:49 AM : Import DN File --->> DN_809_20220722_e75a11cb748811aca5237d533cc58b9d.TXT ### 7/25/2022 7:30:49 AM
7/25/2022 7:31:20 AM : For Distributor 000000000001026 Insert Count::3 ### Delete Count::0
7/25/2022 7:31:20 AM : Import IN File --->> IN_1026_20220723_e52280929cbf308b7354847ad1e0e8b0.TXT ### 7/25/2022 7:31:20 AM
7/25/2022 7:31:20 AM : For Distributor 000000000001026 Insert Count::2 ### Delete Count::0
7/25/2022 7:31:20 AM : Import IN File --->> IN_1026_20220724_3040b2919965b91bfc5be76415062fd9.TXT ### 7/25/2022 7:31:20 AM
7/25/2022 7:31:27 AM : For Distributor 000000000001317 Insert Count::1 ### Delete Count::0
7/25/2022 7:31:27 AM : Import IN File --->> IN_1317_20220723_889cfe0715e05ddc6ddb479ee923fb6a.TXT ### 7/25/2022 7:31:27 AM
7/25/2022 7:31:32 AM : For Distributor 000000000000353 Insert Count::2 ### Delete Count::2
7/25/2022 7:31:32 AM : Import IN File --->> IN_353_20220604_dd19ace6da5203704db3fa540ec037a3.TXT ### 7/25/2022 7:31:32 AM
7/25/2022 7:31:33 AM : For Distributor 000000000000353 Insert Count::2 ### Delete Count::2
7/25/2022 7:31:33 AM : Import IN File --->> IN_353_20220623_942a16240abc981f82e0fac8414bba2b.TXT ### 7/25/2022 7:31:33 AM
7/25/2022 7:31:34 AM : For Distributor 000000000000353 Insert Count::1 ### Delete Count::1
7/25/2022 7:31:34 AM : Import IN File --->> IN_353_20220713_b52ace163db39159484340add0dac9dd.TXT ### 7/25/2022 7:31:34 AM
7/25/2022 7:31:34 AM : For Distributor 000000000000353 Insert Count::3 ### Delete Count::3
7/25/2022 7:31:34 AM : Import IN File --->> IN_353_20220720_b8cdfbcaed30d2bc2bb309611df82380.TXT ### 7/25/2022 7:31:34 AM
7/25/2022 7:31:34 AM : For Distributor 000000000000353 Insert Count::5 ### Delete Count::0
7/25/2022 7:31:34 AM : Import IN File --->> IN_353_20220721_6b1153c8c0b50c20c944d2f7e9f949d0.TXT ### 7/25/2022 7:31:34 AM
7/25/2022 7:31:34 AM : For Distributor 000000000000353 Insert Count::4 ### Delete Count::0
7/25/2022 7:31:34 AM : Import IN File --->> IN_353_20220722_c3ab9c94f8b4e17606d86ecdc2372b84.TXT ### 7/25/2022 7:31:34 AM
7/25/2022 7:31:34 AM : For Distributor 000000000000353 Insert Count::3 ### Delete Count::0
7/25/2022 7:31:34 AM : Import IN File --->> IN_353_20220723_4b6df901a101e69a11ded5be79563714.TXT ### 7/25/2022 7:31:34 AM
7/25/2022 7:31:44 AM : For Distributor 000000000000371 Insert Count::13 ### Delete Count::4
7/25/2022 7:31:44 AM : Import IN File --->> IN_371_20220723_b1c1970ee6198d5b8d12ebb73eb78c02.TXT ### 7/25/2022 7:31:44 AM
7/25/2022 7:31:50 AM : For Distributor 000000000000424 Insert Count::2 ### Delete Count::0
7/25/2022 7:31:50 AM : Import IN File --->> IN_424_20220724_f3f681aaa8223e0769d56e7bc6963b1b.TXT ### 7/25/2022 7:31:50 AM
7/25/2022 7:31:50 AM : Import IN File --->> IN_424_20220725_a47c809fd9a17e0fa0a1f384a93bd4e6.TXT ### 7/25/2022 7:31:50 AM
7/25/2022 7:31:50 AM : NO Previous File For Distributor 000000000000424 ### Insert Count::1
7/25/2022 7:31:57 AM : For Distributor 000000000000665 Insert Count::1 ### Delete Count::0
7/25/2022 7:31:57 AM : Import IN File --->> IN_665_20220723_c7108fb3709a074458b616cbf2ca14db.TXT ### 7/25/2022 7:31:57 AM
7/25/2022 7:31:59 AM : For Distributor 000000000000809 Insert Count::18 ### Delete Count::5
7/25/2022 7:31:59 AM : Import IN File --->> IN_809_20220722_079949e4a1f82881133a74471359ed75.TXT ### 7/25/2022 7:31:59 AM
7/25/2022 7:31:59 AM : Import IN File --->> IN_809_20220723_6add18a71175fa13482fa26040b7917c.TXT ### 7/25/2022 7:31:59 AM
7/25/2022 7:31:59 AM : NO Previous File For Distributor 000000000000809 ### Insert Count::18
7/25/2022 7:31:59 AM : Import IN File --->> IN_809_20220725_8393a6876edf93466dbce769b387d857.TXT ### 7/25/2022 7:31:59 AM
7/25/2022 7:31:59 AM : NO Previous File For Distributor 000000000000809 ### Insert Count::1
7/25/2022 7:32:11 AM : For Distributor 000000000000815 Insert Count::1 ### Delete Count::0
7/25/2022 7:32:11 AM : Import IN File --->> IN_815_20220709_f6055be7a0c0b3708da2ee57116977a3.TXT ### 7/25/2022 7:32:11 AM
7/25/2022 7:32:12 AM : Import IN File --->> IN_815_20220723_1881a93b1502f8b8da519ce3047ed780.TXT ### 7/25/2022 7:32:12 AM
7/25/2022 7:32:12 AM : NO Previous File For Distributor 000000000000815 ### Insert Count::1
7/25/2022 7:32:14 AM : For Distributor 000000000000820 Insert Count::3 ### Delete Count::0
7/25/2022 7:32:14 AM : Import IN File --->> IN_820_20220723_12f3dbfaeba16d67b2621888f2b726f0.TXT ### 7/25/2022 7:32:14 AM
7/25/2022 7:32:30 AM : For Distributor 000000000000820 Insert Count::4 ### Delete Count::4
7/25/2022 7:32:30 AM : Import OT File --->> OT_820_20220601_b4d255ec66e3bbb56e815ceded33a49c.TXT ### 7/25/2022 7:32:30 AM
7/25/2022 7:32:31 AM : For Distributor 000000000000820 Insert Count::6 ### Delete Count::6
7/25/2022 7:32:31 AM : Import OT File --->> OT_820_20220602_22bd37a0b7a595b15aadb27b85bef6d7.TXT ### 7/25/2022 7:32:31 AM
7/25/2022 7:32:31 AM : For Distributor 000000000000820 Insert Count::4 ### Delete Count::4
7/25/2022 7:32:31 AM : Import OT File --->> OT_820_20220604_e8df1337c86b1e8f96b84f5cc3436d49.TXT ### 7/25/2022 7:32:31 AM
7/25/2022 7:32:31 AM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::2
7/25/2022 7:32:31 AM : Import OT File --->> OT_820_20220606_082b15f6c9d5ad922574b73e41c3ba34.TXT ### 7/25/2022 7:32:31 AM
7/25/2022 7:32:31 AM : For Distributor 000000000000820 Insert Count::8 ### Delete Count::8
7/25/2022 7:32:31 AM : Import OT File --->> OT_820_20220608_393261b0a9543751dac752236811e81a.TXT ### 7/25/2022 7:32:31 AM
7/25/2022 7:32:31 AM : For Distributor 000000000000820 Insert Count::6 ### Delete Count::6
7/25/2022 7:32:31 AM : Import OT File --->> OT_820_20220610_5ebe8ce250cb03e9c29f4f17a74156d8.TXT ### 7/25/2022 7:32:31 AM
7/25/2022 7:32:31 AM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::2
7/25/2022 7:32:31 AM : Import OT File --->> OT_820_20220611_5a90775198883da105c27e60e187d392.TXT ### 7/25/2022 7:32:31 AM
7/25/2022 7:32:32 AM : For Distributor 000000000000820 Insert Count::4 ### Delete Count::4
7/25/2022 7:32:32 AM : Import OT File --->> OT_820_20220615_0e43f77879aa063cdc7da465762b8ecf.TXT ### 7/25/2022 7:32:32 AM
7/25/2022 7:32:32 AM : For Distributor 000000000000820 Insert Count::6 ### Delete Count::6
7/25/2022 7:32:32 AM : Import OT File --->> OT_820_20220616_c7db63cbba519b273b7d73b906063e33.TXT ### 7/25/2022 7:32:32 AM
7/25/2022 7:32:32 AM : For Distributor 000000000000820 Insert Count::6 ### Delete Count::6
7/25/2022 7:32:32 AM : Import OT File --->> OT_820_20220617_1650aa989b691efc96b8bf0206058a14.TXT ### 7/25/2022 7:32:32 AM
7/25/2022 7:32:32 AM : For Distributor 000000000000820 Insert Count::10 ### Delete Count::10
7/25/2022 7:32:32 AM : Import OT File --->> OT_820_20220618_5f998476af9ea1c29fec14480799274f.TXT ### 7/25/2022 7:32:32 AM
7/25/2022 7:32:32 AM : For Distributor 000000000000820 Insert Count::8 ### Delete Count::8
7/25/2022 7:32:32 AM : Import OT File --->> OT_820_20220620_996722c52f842f20828c7337c080889c.TXT ### 7/25/2022 7:32:32 AM
7/25/2022 7:32:32 AM : For Distributor 000000000000820 Insert Count::6 ### Delete Count::6
7/25/2022 7:32:32 AM : Import OT File --->> OT_820_20220622_ff79a6a1b5b40d7c6c37316c477056fb.TXT ### 7/25/2022 7:32:32 AM
7/25/2022 7:32:33 AM : For Distributor 000000000000820 Insert Count::4 ### Delete Count::4
7/25/2022 7:32:33 AM : Import OT File --->> OT_820_20220623_ae56bedbeb214a5a1c04d35ee17820aa.TXT ### 7/25/2022 7:32:33 AM
7/25/2022 7:32:33 AM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::2
7/25/2022 7:32:33 AM : Import OT File --->> OT_820_20220625_508bc1ee70f7fb6c95a451b88ae3474c.TXT ### 7/25/2022 7:32:33 AM
7/25/2022 7:32:33 AM : For Distributor 000000000000820 Insert Count::10 ### Delete Count::10
7/25/2022 7:32:33 AM : Import OT File --->> OT_820_20220627_9b3606b7db03399e3114f62f8d37a26e.TXT ### 7/25/2022 7:32:33 AM
7/25/2022 7:32:33 AM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::2
7/25/2022 7:32:33 AM : Import OT File --->> OT_820_20220629_5da5617f1bdf072a2811d2643a11e264.TXT ### 7/25/2022 7:32:33 AM
7/25/2022 7:32:33 AM : For Distributor 000000000000820 Insert Count::6 ### Delete Count::6
7/25/2022 7:32:33 AM : Import OT File --->> OT_820_20220630_76dc89f432428dd05b396c70c157f5fe.TXT ### 7/25/2022 7:32:33 AM
7/25/2022 7:32:33 AM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::2
7/25/2022 7:32:33 AM : Import OT File --->> OT_820_20220702_0382a6489ecc0ae633c8b0ff9d0e7bb7.TXT ### 7/25/2022 7:32:33 AM
7/25/2022 7:32:34 AM : For Distributor 000000000000820 Insert Count::6 ### Delete Count::6
7/25/2022 7:32:34 AM : Import OT File --->> OT_820_20220704_3b5ab88a22cd0b5ed994bd9d4a5325a3.TXT ### 7/25/2022 7:32:34 AM
7/25/2022 7:32:34 AM : For Distributor 000000000000820 Insert Count::4 ### Delete Count::4
7/25/2022 7:32:34 AM : Import OT File --->> OT_820_20220705_df0f2dada385ce719e78253bf19ce7d9.TXT ### 7/25/2022 7:32:34 AM
7/25/2022 7:32:34 AM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::2
7/25/2022 7:32:34 AM : Import OT File --->> OT_820_20220707_cf6cb93ad93b299305dfad22e9dca73f.TXT ### 7/25/2022 7:32:34 AM
7/25/2022 7:32:34 AM : For Distributor 000000000000820 Insert Count::6 ### Delete Count::6
7/25/2022 7:32:34 AM : Import OT File --->> OT_820_20220709_968340d62a12bd76f9346c596788c95c.TXT ### 7/25/2022 7:32:34 AM
7/25/2022 7:32:34 AM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::2
7/25/2022 7:32:34 AM : Import OT File --->> OT_820_20220711_e8b1e8fdcd0ff22a7f191804150402a1.TXT ### 7/25/2022 7:32:34 AM
7/25/2022 7:32:34 AM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::2
7/25/2022 7:32:34 AM : Import OT File --->> OT_820_20220712_88214d32a01eab53d25c96cb58ecee30.TXT ### 7/25/2022 7:32:34 AM
7/25/2022 7:32:34 AM : For Distributor 000000000000820 Insert Count::12 ### Delete Count::12
7/25/2022 7:32:34 AM : Import OT File --->> OT_820_20220713_6dc44136cbcfd71e51df9817f2b5bf12.TXT ### 7/25/2022 7:32:34 AM
7/25/2022 7:32:35 AM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::2
7/25/2022 7:32:35 AM : Import OT File --->> OT_820_20220716_992ccd1db3c9e4748b803cd30fab8b44.TXT ### 7/25/2022 7:32:35 AM
7/25/2022 7:32:35 AM : For Distributor 000000000000820 Insert Count::4 ### Delete Count::4
7/25/2022 7:32:35 AM : Import OT File --->> OT_820_20220718_5f4a6eeae6b0f436b925245f1c5b58fc.TXT ### 7/25/2022 7:32:35 AM
7/25/2022 7:32:35 AM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::2
7/25/2022 7:32:35 AM : Import OT File --->> OT_820_20220719_123de17770ac110a4c5f2cc97f0ce24c.TXT ### 7/25/2022 7:32:35 AM
7/25/2022 7:32:35 AM : For Distributor 000000000000820 Insert Count::8 ### Delete Count::8
7/25/2022 7:32:35 AM : Import OT File --->> OT_820_20220721_a3f845fc8e899145c747977bbee8aa10.TXT ### 7/25/2022 7:32:35 AM
7/25/2022 7:32:35 AM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::2
7/25/2022 7:32:35 AM : Import OT File --->> OT_820_20220722_2992db285d1694732fd873b7da5e0a34.TXT ### 7/25/2022 7:32:35 AM
7/25/2022 7:32:35 AM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::0
7/25/2022 7:32:35 AM : Import OT File --->> OT_820_20220723_6566afd5abb6cf2950053e0ceb1b6507.TXT ### 7/25/2022 7:32:35 AM
7/25/2022 7:32:36 AM : PostData() --->>  ### 7/25/2022 7:32:36 AM
7/25/2022 7:32:38 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 7/25/2022 7:32:38 AM
7/25/2022 7:32:39 AM : SupplierLink Successful --->> exec SP_SupplierLinkDiff '25/Jul/2022' ### 7/25/2022 7:32:39 AM
7/25/2022 7:32:41 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '25/Jul/2022' ### 7/25/2022 7:32:41 AM
7/25/2022 7:32:41 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '25/Jul/2022' ### 7/25/2022 7:32:41 AM
7/25/2022 7:32:41 AM :  ### 
7/25/2022 7:32:41 AM : UNLINKEDSALES Record Count Before --->> 85 ### 7/25/2022 7:32:41 AM
7/25/2022 7:32:41 AM : UNLINKEDSALES_DEL Record Count Before --->> 17 ### 7/25/2022 7:32:41 AM
7/25/2022 7:32:53 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '25/Jul/2022' ### 7/25/2022 7:32:53 AM
7/25/2022 7:32:53 AM : UNLINKEDSALES Record Count After --->> 0 ### 7/25/2022 7:32:53 AM
7/25/2022 7:32:53 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 7/25/2022 7:32:53 AM
7/25/2022 7:32:53 AM :  ### 
7/25/2022 7:32:59 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '25/Jul/2022' ### 7/25/2022 7:32:59 AM
7/25/2022 7:33:08 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '25/Jul/2022' ### 7/25/2022 7:33:08 AM
7/25/2022 7:33:08 AM : Posting Supplierlink Query for CompanyPurchases --->> insert into supplierlink (code,distributorid,name,InsertDate,InsertedDate,LastEditDate,targetid)
                   select distinct suppliercode,PDistributor.distributorid,'' as name, '1900-01-01','2022-07-25 07:33:08','2022-07-25 07:33:08',PDistributor.UnkSupplierId as targetid from UNLINKEDCOMPANYPURCHASES,PDistributor where UNLINKEDCOMPANYPURCHASES.erpcode=PDistributor.erpcode and PDistributor.distributorid+unlinkedcompanypurchases.suppliercode not in (select distinct distributorid+code from supplierlink where code is not null) ### 7/25/2022 7:33:08 AM
7/25/2022 7:33:08 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '25/Jul/2022' ### 7/25/2022 7:33:08 AM
7/25/2022 7:33:08 AM : Posting ClosingStock Successful --->>  ### 7/25/2022 7:33:08 AM
7/25/2022 7:33:08 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 7/25/2022 7:33:08 AM
7/25/2022 7:33:08 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
7/25/2022 7:33:08 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1025789_TEMPLATE1.TXT ### 7/25/2022 7:33:08 AM
7/25/2022 7:33:08 AM : Count:: ### TEMPLATE1:205
7/25/2022 7:33:22 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/25/2022 7:33:22 AM
7/25/2022 7:33:22 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1123438_TEMPLATE1.TXT ### 7/25/2022 7:33:22 AM
7/25/2022 7:33:22 AM : Count:: ### TEMPLATE1:104
7/25/2022 7:33:35 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/25/2022 7:33:35 AM
7/25/2022 7:33:35 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 7/25/2022 7:33:35 AM
7/25/2022 7:33:35 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 7:33:35 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1998851_TEMPLATE1.TXT ### 7/25/2022 7:33:35 AM
7/25/2022 7:33:35 AM : Count:: ### TEMPLATE1:32
7/25/2022 7:33:39 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/25/2022 7:33:39 AM
7/25/2022 7:33:39 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 7/25/2022 7:33:39 AM
7/25/2022 7:33:40 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 7:33:40 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 7/25/2022 7:33:40 AM
7/25/2022 7:33:40 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 7:33:40 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2743253_TEMPLATE1.TXT ### 7/25/2022 7:33:40 AM
7/25/2022 7:33:40 AM : Count:: ### TEMPLATE1:16
7/25/2022 7:33:41 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/25/2022 7:33:41 AM
7/25/2022 7:33:41 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 7/25/2022 7:33:41 AM
7/25/2022 7:33:41 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 7:33:41 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 7/25/2022 7:33:41 AM
7/25/2022 7:33:41 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 7:33:41 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2848065_TEMPLATE1.TXT ### 7/25/2022 7:33:41 AM
7/25/2022 7:33:41 AM : Count:: ### TEMPLATE1:71
7/25/2022 7:33:54 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/25/2022 7:33:54 AM
7/25/2022 7:33:54 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3559252_TEMPLATE1.TXT ### 7/25/2022 7:33:54 AM
7/25/2022 7:33:54 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 7:33:54 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 7/25/2022 7:33:54 AM
7/25/2022 7:33:54 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 7:33:54 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 7/25/2022 7:33:54 AM
7/25/2022 7:33:54 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 7:33:54 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3662360_TEMPLATE1.TXT ### 7/25/2022 7:33:54 AM
7/25/2022 7:33:54 AM : Count:: ### TEMPLATE1:74
7/25/2022 7:33:58 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/25/2022 7:33:58 AM
7/25/2022 7:33:58 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 7/25/2022 7:33:58 AM
7/25/2022 7:33:58 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 7:33:58 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 7/25/2022 7:33:58 AM
7/25/2022 7:33:58 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 7:33:58 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3985879_TEMPLATE1.txt ### 7/25/2022 7:33:58 AM
7/25/2022 7:33:58 AM : Count:: ### TEMPLATE1:58
7/25/2022 7:33:58 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/25/2022 7:33:58 AM
7/25/2022 7:33:58 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 7/25/2022 7:33:58 AM
7/25/2022 7:33:58 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 7:33:58 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 7/25/2022 7:33:58 AM
7/25/2022 7:33:58 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 7:33:58 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 7/25/2022 7:33:58 AM
7/25/2022 7:33:58 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 7:33:58 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_722734_TEMPLATE1.TXT ### 7/25/2022 7:33:58 AM
7/25/2022 7:33:58 AM : Count:: ### TEMPLATE1:20
7/25/2022 7:34:04 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/25/2022 7:34:04 AM
7/25/2022 7:34:04 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060893_TEMPLATE1.txt ### 7/25/2022 7:34:04 AM
7/25/2022 7:34:04 AM : Count:: ### TEMPLATE1:229
7/25/2022 7:34:20 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/25/2022 7:34:20 AM
7/25/2022 7:34:20 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 7/25/2022 7:34:20 AM
7/25/2022 7:34:20 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 7:34:20 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 7/25/2022 7:34:20 AM
7/25/2022 7:34:20 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 7:34:20 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 7/25/2022 7:34:20 AM
7/25/2022 7:34:20 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 7:34:20 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062462_TEMPLATE1.TXT ### 7/25/2022 7:34:20 AM
7/25/2022 7:34:20 AM : Count:: ### TEMPLATE1:8
7/25/2022 7:34:20 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/25/2022 7:34:20 AM
7/25/2022 7:34:20 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062898_TEMPLATE1.TXT ### 7/25/2022 7:34:20 AM
7/25/2022 7:34:20 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 7:34:20 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 7/25/2022 7:34:20 AM
7/25/2022 7:34:20 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 7:34:20 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063177_TEMPLATE1.TXT ### 7/25/2022 7:34:20 AM
7/25/2022 7:34:20 AM : Count:: ### TEMPLATE1:148
7/25/2022 7:34:40 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/25/2022 7:34:40 AM
7/25/2022 7:34:40 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 7/25/2022 7:34:40 AM
7/25/2022 7:34:40 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 7:34:40 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9064126_TEMPLATE1.TXT ### 7/25/2022 7:34:40 AM
7/25/2022 7:34:40 AM : Count:: ### TEMPLATE1:2
7/25/2022 7:34:40 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/25/2022 7:34:40 AM
7/25/2022 7:34:40 AM : Error in file  ### TEMPLATE1 (1) at Line 2
7/25/2022 7:34:40 AM : Template Import Complete  ### 7/25/2022 7:34:40 AM
7/25/2022 7:34:43 AM : Completed Updating Has Transaction Flag  ### 7/25/2022 7:34:43 AM
7/25/2022 7:34:43 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 7/25/2022 7:34:43 AM
7/25/2022 7:34:43 AM : Zylem Access Unblocked  ### 7/25/2022 7:34:43 AM
7/25/2022 7:34:43 AM : MainForm_Load  ### Before Add Entry In Monitoring database
7/25/2022 7:34:43 AM : MainForm_Load  ### After Add Entry In Monitoring database
7/25/2022 7:34:43 AM : StartProcess for importing Closing stock file from ClosingStock folder  ### 7/25/2022 7:34:43 AM

7/25/2022 7:34:43 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 7:34:43 AM : Validation Start For All  ### 7/25/2022 7:34:43 AM
7/25/2022 7:34:44 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 7:34:44 AM : BAYER_1025789_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 7:34:44 AM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 7:34:44 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 7:34:44 AM : BAYER_1123438_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 7:34:44 AM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 7:34:44 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 7:34:44 AM : BAYER_1986218_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 7:34:44 AM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 7:34:44 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 7:34:44 AM : BAYER_1998851_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 7:34:44 AM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 7:34:44 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 7:34:44 AM : BAYER_2155816_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 1 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 2 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 3 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 4 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 5 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 6 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 7 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 8 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 9 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 10 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 11 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 12 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 13 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 14 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 15 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 16 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 17 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 18 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 19 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 20 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 21 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 22 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 23 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 24 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 25 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 26 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 27 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 28 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 29 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 30 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 31 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 32 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 33 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 34 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 35 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 36 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 37 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 38 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 39 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 40 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 41 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 42 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 43 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 44 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 45 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 46 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 47 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 48 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 49 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 50 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 51 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 52 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 53 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 54 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 55 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 56 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 57 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 58 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 59 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 60 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 61 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 62 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 63 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 64 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 65 ### 
7/25/2022 7:34:44 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 66 ### 
7/25/2022 7:34:44 AM : File Not Valid for Distributor ERPCode-2155816 ### BAYER_2155816_CLOSINGSTOCK.TXT
7/25/2022 7:34:44 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 7:34:44 AM : BAYER_2221168_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 7:34:44 AM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 7:34:44 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 7:34:44 AM : BAYER_2743253_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 7:34:44 AM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 7:34:44 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 7:34:44 AM : BAYER_2779314_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 7:34:44 AM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 7:34:44 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 7:34:44 AM : BAYER_2848065_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 7:34:44 AM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 7:34:44 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 7:34:44 AM : BAYER_3559252_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 7:34:44 AM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 7:34:44 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 7:34:44 AM : BAYER_3576162_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 7:34:44 AM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 7:34:44 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 7:34:45 AM : BAYER_3662360_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 7:34:45 AM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 7:34:45 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 7:34:45 AM : BAYER_3888864_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 1 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 2 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 3 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 4 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 5 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 6 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 7 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 8 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 9 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 10 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 11 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 12 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 13 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 14 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 15 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 16 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 17 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 18 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 19 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 20 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 21 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 22 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 23 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 24 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 25 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 26 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 27 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 28 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 29 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 30 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 31 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 32 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 33 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 34 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 35 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 36 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 37 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 38 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 39 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 40 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 41 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 42 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 43 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 44 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 45 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 46 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 47 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 48 ### 
7/25/2022 7:34:45 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 49 ### 
7/25/2022 7:34:45 AM : File Not Valid for Distributor ERPCode-3888864 ### BAYER_3888864_CLOSINGSTOCK.TXT
7/25/2022 7:34:45 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 7:34:45 AM : BAYER_3985879_CLOSINGSTOCK.txt, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 7:34:45 AM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 7:34:45 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 7:34:45 AM : BAYER_722734_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 7:34:45 AM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 7:34:45 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 7:34:45 AM : BAYER_9060893_CLOSINGSTOCK.txt, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 7:34:45 AM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 7:34:45 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 7:34:45 AM : BAYER_9062462_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 7:34:45 AM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 7:34:45 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 7:34:45 AM : BAYER_9063177_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 7:34:45 AM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 7:34:45 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 7:34:45 AM : BAYER_9064126_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 7:34:45 AM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 7:34:45 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 7:34:45 AM : BAYER_9067041_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 7:34:45 AM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 7:34:45 AM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 7:34:45 AM : BAYER_9067122_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 7:34:45 AM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 7:34:45 AM : Import Start For All  ### 7/25/2022 7:34:45 AM
7/25/2022 7:34:45 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
7/25/2022 7:34:45 AM : Import ClosingStock File --->> CL_1025_20220725_dfd948ee738026c3b7d241f613b0d794.TXT ### 7/25/2022 7:34:45 AM
7/25/2022 7:34:45 AM : File For Distributor 000000000001025 ### Insert Count::13
7/25/2022 7:34:46 AM : Import ClosingStock File --->> CL_1316_20220725_2f86994ec587fb3b47a22a34a1588d86.TXT ### 7/25/2022 7:34:46 AM
7/25/2022 7:34:46 AM : File For Distributor 000000000001316 ### Insert Count::16
7/25/2022 7:34:46 AM : Import ClosingStock File --->> CL_1317_20220725_cd245a80fad478b48bb865e88d960567.TXT ### 7/25/2022 7:34:46 AM
7/25/2022 7:34:46 AM : File For Distributor 000000000001317 ### Insert Count::18
7/25/2022 7:34:46 AM : Import ClosingStock File --->> CL_353_20220725_1e55da1407a6d5bd68845d9961b83039.TXT ### 7/25/2022 7:34:46 AM
7/25/2022 7:34:46 AM : File For Distributor 000000000000353 ### Insert Count::28
7/25/2022 7:34:46 AM : Import ClosingStock File --->> CL_371_20220725_f2edb2107bf2356b489d18c5730fec10.TXT ### 7/25/2022 7:34:46 AM
7/25/2022 7:34:46 AM : File For Distributor 000000000000371 ### Insert Count::156
7/25/2022 7:34:47 AM : Import ClosingStock File --->> CL_424_20220725_fc08e31f7493c8c8af8ca0520b18d2bf.TXT ### 7/25/2022 7:34:47 AM
7/25/2022 7:34:47 AM : File For Distributor 000000000000424 ### Insert Count::107
7/25/2022 7:34:47 AM : Import ClosingStock File --->> CL_665_20220725_b9ba71f9c3333d77ed7d4973a013726a.TXT ### 7/25/2022 7:34:47 AM
7/25/2022 7:34:47 AM : File For Distributor 000000000000665 ### Insert Count::175
7/25/2022 7:34:47 AM : Import ClosingStock File --->> CL_809_20220725_d7f35d1accb35e8fd7a6c997dd95b8ec.TXT ### 7/25/2022 7:34:47 AM
7/25/2022 7:34:47 AM : File For Distributor 000000000000809 ### Insert Count::38
7/25/2022 7:34:47 AM : Import ClosingStock File --->> CL_814_20220725_3d00375efd34d4664d4348a53663a077.TXT ### 7/25/2022 7:34:47 AM
7/25/2022 7:34:47 AM : File For Distributor 000000000000814 ### Insert Count::13
7/25/2022 7:34:48 AM : Import ClosingStock File --->> CL_815_20220725_362ca2898859282b9508a2b0103f5f84.TXT ### 7/25/2022 7:34:48 AM
7/25/2022 7:34:48 AM : File For Distributor 000000000000815 ### Insert Count::21
7/25/2022 7:34:48 AM : Import ClosingStock File --->> CL_820_20220725_474533358ce76948306a1d0e8ec67e88.TXT ### 7/25/2022 7:34:48 AM
7/25/2022 7:34:48 AM : File For Distributor 000000000000820 ### Insert Count::39
7/25/2022 7:34:48 AM : Procedure Name - exec prPostItemClosingStock ### 7/25/2022 7:34:48 AM
7/25/2022 7:34:49 AM : Posting Closing Stock Successful --->>  ### 7/25/2022 7:34:49 AM
7/25/2022 7:34:49 AM : End Process for importing Closing stock file from ClosingStock folder End Time----------- ### 7/25/2022 7:34:49 AM
7/25/2022 7:34:49 AM : Importing ended from WinZylemImport exe. Updated Value of BlockImportingProcess - 0 in Settings table ### 7/25/2022 7:34:49 AM

7/25/2022 7:34:49 AM : Application Ended  ### 7/25/2022 7:34:49 AM

7/25/2022 2:30:02 PM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 2:30:02 PM : StartProcess  ### 7/25/2022 2:30:02 PM

7/25/2022 2:30:02 PM : Importing Running from Zylem App, Wait for some time. Value of BlockImportingProcess - 0 ### 7/25/2022 2:30:02 PM

7/25/2022 2:30:02 PM : Max No Of Retry In Minutes For WaitingState. MaxNoOfRetryInMinForWaitingState - 2 ### Expected waiting time is 7/25/2022 2:32:02 PM

7/25/2022 2:30:02 PM : Importing Running from Zylem App End. Value of BlockImportingProcess - 0 ### 7/25/2022 2:30:02 PM

7/25/2022 2:30:02 PM : Importing started from WinZylemImport exe. Updated Value of BlockImportingProcess - 1 in Settings table ### 7/25/2022 2:30:02 PM

7/25/2022 2:30:03 PM : 11  ### 7/25/2022 2:30:03 PM

7/25/2022 2:30:03 PM : 22  ### 7/25/2022 2:30:03 PM

7/25/2022 2:30:03 PM : 33  ### 7/25/2022 2:30:03 PM

7/25/2022 2:30:03 PM : Application Started  ### 7/25/2022 2:30:03 PM

7/25/2022 2:30:03 PM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 2:30:03 PM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 7/25/2022 2:30:03 PM
7/25/2022 2:30:03 PM : MainForm_Load  ### AlertSystem ON
7/25/2022 2:30:03 PM : No. of Files to import (RECEIVEFINAL):  ### 1725
7/25/2022 2:30:03 PM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
7/25/2022 2:30:03 PM : For Distributor 000000000001026 Insert Count::1 ### Delete Count::0
7/25/2022 2:30:03 PM : Import AD File --->> AD_1026_20220725_f7f7ba75ffc3c1147b4f0fcfb47d5588.TXT ### 7/25/2022 2:30:03 PM
7/25/2022 2:30:03 PM : For Distributor 000000000001316 Insert Count::4 ### Delete Count::0
7/25/2022 2:30:03 PM : Import AD File --->> AD_1316_20220725_3e944eb11f91478ad3565c0ed2335c5d.TXT ### 7/25/2022 2:30:03 PM
7/25/2022 2:30:04 PM : For Distributor 000000000000354 Insert Count::2 ### Delete Count::0
7/25/2022 2:30:04 PM : Import AD File --->> AD_354_20220725_3f9113023c0f04a671e528e34a022534.TXT ### 7/25/2022 2:30:04 PM
7/25/2022 2:30:04 PM : For Distributor 000000000000424 Insert Count::3 ### Delete Count::0
7/25/2022 2:30:04 PM : Import AD File --->> AD_424_20220725_2b1b9f290d641eca6de036f8221b8518.TXT ### 7/25/2022 2:30:04 PM
7/25/2022 2:30:04 PM : For Distributor 000000000000492 Insert Count::1 ### Delete Count::0
7/25/2022 2:30:04 PM : Import AD File --->> AD_492_20220725_c49ee3d27f76b848290bca2286e9e2ec.TXT ### 7/25/2022 2:30:04 PM
7/25/2022 2:30:04 PM : For Distributor 000000000000812 Insert Count::1 ### Delete Count::0
7/25/2022 2:30:04 PM : Import AD File --->> AD_812_20220725_37f88e1ae48017150e48617d583bbde0.TXT ### 7/25/2022 2:30:04 PM
7/25/2022 2:30:04 PM : For Distributor 000000000000817 Insert Count::2 ### Delete Count::0
7/25/2022 2:30:04 PM : Import AD File --->> AD_817_20220725_7d64c4ab08bb97f8bdbe4e85584041ee.TXT ### 7/25/2022 2:30:04 PM
7/25/2022 2:30:24 PM : For Distributor 000000000000424 Insert Count::5 ### Delete Count::0
7/25/2022 2:30:24 PM : Import DN File --->> DN_424_20220725_617169304fe776ba95b4d657838d677e.TXT ### 7/25/2022 2:30:24 PM
7/25/2022 2:30:27 PM : For Distributor 000000000000812 Insert Count::4 ### Delete Count::4
7/25/2022 2:30:27 PM : Import DN File --->> DN_812_20220622_f8b6f05c319dfa316c0600f26bd3ad59.TXT ### 7/25/2022 2:30:27 PM
7/25/2022 2:30:35 PM : For Distributor 000000000001026 Insert Count::4 ### Delete Count::0
7/25/2022 2:30:35 PM : Import IN File --->> IN_1026_20220725_a0aaee426c6962886d7a4ad30ee86f7f.TXT ### 7/25/2022 2:30:35 PM
7/25/2022 2:30:38 PM : For Distributor 000000000001316 Insert Count::5 ### Delete Count::0
7/25/2022 2:30:38 PM : Import IN File --->> IN_1316_20220725_54d6f033585ee87130542e64789946f5.TXT ### 7/25/2022 2:30:38 PM
7/25/2022 2:30:43 PM : For Distributor 000000000001317 Insert Count::3 ### Delete Count::0
7/25/2022 2:30:43 PM : Import IN File --->> IN_1317_20220725_4559551e39190d7f42ee9eda5932d721.TXT ### 7/25/2022 2:30:43 PM
7/25/2022 2:30:47 PM : For Distributor 000000000001320 Insert Count::5 ### Delete Count::0
7/25/2022 2:30:47 PM : Import IN File --->> IN_1320_20220723_d78a3f3843531968d87562cf84976bc2.TXT ### 7/25/2022 2:30:47 PM
7/25/2022 2:30:54 PM : For Distributor 000000000000354 Insert Count::1 ### Delete Count::0
7/25/2022 2:30:54 PM : Import IN File --->> IN_354_20220723_8e16afb148f90322f322a1a430cfac53.TXT ### 7/25/2022 2:30:54 PM
7/25/2022 2:30:54 PM : For Distributor 000000000000354 Insert Count::3 ### Delete Count::0
7/25/2022 2:30:54 PM : Import IN File --->> IN_354_20220725_b3eb2126b25de2e571e875f90af157b6.TXT ### 7/25/2022 2:30:54 PM
7/25/2022 2:31:08 PM : For Distributor 000000000000424 Insert Count::1 ### Delete Count::2
7/25/2022 2:31:08 PM : Import IN File --->> IN_424_20220712_5834856ad9c7dfa6f860ca6b217f1e24.TXT ### 7/25/2022 2:31:08 PM
7/25/2022 2:31:08 PM : For Distributor 000000000000424 Insert Count::26 ### Delete Count::0
7/25/2022 2:31:08 PM : Import IN File --->> IN_424_20220725_3f74992c6e822118233166a4ced581e8.TXT ### 7/25/2022 2:31:08 PM
7/25/2022 2:31:10 PM : For Distributor 000000000000492 Insert Count::2 ### Delete Count::2
7/25/2022 2:31:10 PM : Import IN File --->> IN_492_20220704_573988672d5fbe75c55555a1f92cae26.TXT ### 7/25/2022 2:31:10 PM
7/25/2022 2:31:10 PM : For Distributor 000000000000492 Insert Count::3 ### Delete Count::3
7/25/2022 2:31:10 PM : Import IN File --->> IN_492_20220705_ced935a1f0be9912630b897be74c13cc.TXT ### 7/25/2022 2:31:10 PM
7/25/2022 2:31:10 PM : For Distributor 000000000000492 Insert Count::3 ### Delete Count::3
7/25/2022 2:31:10 PM : Import IN File --->> IN_492_20220706_7e894b70939eaeb177b7be6eb63f8e6c.TXT ### 7/25/2022 2:31:10 PM
7/25/2022 2:31:10 PM : For Distributor 000000000000492 Insert Count::2 ### Delete Count::2
7/25/2022 2:31:10 PM : Import IN File --->> IN_492_20220707_8e63ae5144e113d203c6de27b2b8039e.TXT ### 7/25/2022 2:31:10 PM
7/25/2022 2:31:10 PM : For Distributor 000000000000492 Insert Count::4 ### Delete Count::4
7/25/2022 2:31:10 PM : Import IN File --->> IN_492_20220708_699e57bd1ba300c3efb3cc8bcf489479.TXT ### 7/25/2022 2:31:10 PM
7/25/2022 2:31:10 PM : For Distributor 000000000000492 Insert Count::6 ### Delete Count::6
7/25/2022 2:31:10 PM : Import IN File --->> IN_492_20220709_a97b6b235076d3e570e7faef67ca8d08.TXT ### 7/25/2022 2:31:10 PM
7/25/2022 2:31:11 PM : For Distributor 000000000000492 Insert Count::4 ### Delete Count::4
7/25/2022 2:31:11 PM : Import IN File --->> IN_492_20220711_fa00643e8b0f5963d15d004426448384.TXT ### 7/25/2022 2:31:11 PM
7/25/2022 2:31:11 PM : For Distributor 000000000000492 Insert Count::5 ### Delete Count::5
7/25/2022 2:31:11 PM : Import IN File --->> IN_492_20220712_236099f8333010ad043856324f6ab9f7.TXT ### 7/25/2022 2:31:11 PM
7/25/2022 2:31:11 PM : For Distributor 000000000000492 Insert Count::6 ### Delete Count::6
7/25/2022 2:31:11 PM : Import IN File --->> IN_492_20220713_b5efbbe1ad19becf8afe78b24fbd8de5.TXT ### 7/25/2022 2:31:11 PM
7/25/2022 2:31:11 PM : For Distributor 000000000000492 Insert Count::6 ### Delete Count::6
7/25/2022 2:31:11 PM : Import IN File --->> IN_492_20220714_c608306befaad3f11eecf5598100fcbf.TXT ### 7/25/2022 2:31:11 PM
7/25/2022 2:31:11 PM : For Distributor 000000000000492 Insert Count::3 ### Delete Count::3
7/25/2022 2:31:11 PM : Import IN File --->> IN_492_20220715_68b593ac34e9e12e36235c3ca23fab97.TXT ### 7/25/2022 2:31:11 PM
7/25/2022 2:31:11 PM : For Distributor 000000000000492 Insert Count::3 ### Delete Count::3
7/25/2022 2:31:11 PM : Import IN File --->> IN_492_20220716_787ffdd4dc0eddc9d2ab9b050d6e6c0e.TXT ### 7/25/2022 2:31:11 PM
7/25/2022 2:31:11 PM : For Distributor 000000000000492 Insert Count::2 ### Delete Count::2
7/25/2022 2:31:11 PM : Import IN File --->> IN_492_20220718_947e82ac599a4a47058b56fc39c3e494.TXT ### 7/25/2022 2:31:11 PM
7/25/2022 2:31:12 PM : For Distributor 000000000000492 Insert Count::4 ### Delete Count::4
7/25/2022 2:31:12 PM : Import IN File --->> IN_492_20220720_4880acf98457aa79c3a5c31b50423291.TXT ### 7/25/2022 2:31:12 PM
7/25/2022 2:31:12 PM : For Distributor 000000000000492 Insert Count::1 ### Delete Count::1
7/25/2022 2:31:12 PM : Import IN File --->> IN_492_20220721_05642c2bd0d85bb1a841b93869dfec25.TXT ### 7/25/2022 2:31:12 PM
7/25/2022 2:31:12 PM : For Distributor 000000000000492 Insert Count::1 ### Delete Count::1
7/25/2022 2:31:12 PM : Import IN File --->> IN_492_20220722_4a32c773824c02158a57482c96ebab75.TXT ### 7/25/2022 2:31:12 PM
7/25/2022 2:31:12 PM : For Distributor 000000000000492 Insert Count::5 ### Delete Count::0
7/25/2022 2:31:12 PM : Import IN File --->> IN_492_20220723_19253fbf5d2851025f239d3d2ea285b9.TXT ### 7/25/2022 2:31:12 PM
7/25/2022 2:31:12 PM : Import IN File --->> IN_492_20220725_7216a79d31806c0de1109110bf83ebae.TXT ### 7/25/2022 2:31:12 PM
7/25/2022 2:31:12 PM : NO Previous File For Distributor 000000000000492 ### Insert Count::1
7/25/2022 2:31:14 PM : For Distributor 000000000000812 Insert Count::1 ### Delete Count::0
7/25/2022 2:31:14 PM : Import IN File --->> IN_812_20220723_6135d7b2251e8776ff4dbb3c5e1de8fd.TXT ### 7/25/2022 2:31:14 PM
7/25/2022 2:31:15 PM : For Distributor 000000000000814 Insert Count::1 ### Delete Count::0
7/25/2022 2:31:15 PM : Import IN File --->> IN_814_20220723_361481d695230d7df68ec000041de32b.TXT ### 7/25/2022 2:31:15 PM
7/25/2022 2:31:16 PM : Import IN File --->> IN_817_20220718_9b80316b604b348fa6e4497ff58efa93.TXT ### 7/25/2022 2:31:16 PM
7/25/2022 2:31:16 PM : NO Previous File For Distributor 000000000000817 ### Insert Count::1
7/25/2022 2:31:17 PM : Import IN File --->> IN_817_20220721_426ad20ca4f62fea3a53505ed3081a80.TXT ### 7/25/2022 2:31:17 PM
7/25/2022 2:31:17 PM : NO Previous File For Distributor 000000000000817 ### Insert Count::1
7/25/2022 2:31:17 PM : Import IN File --->> IN_817_20220722_2079b0105200c6684c1fc6c2bad612dd.TXT ### 7/25/2022 2:31:17 PM
7/25/2022 2:31:17 PM : NO Previous File For Distributor 000000000000817 ### Insert Count::1
7/25/2022 2:31:17 PM : PostData() --->>  ### 7/25/2022 2:31:17 PM
7/25/2022 2:31:19 PM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 7/25/2022 2:31:19 PM
7/25/2022 2:31:21 PM : SupplierLink Successful --->> exec SP_SupplierLinkDiff '25/Jul/2022' ### 7/25/2022 2:31:21 PM
7/25/2022 2:31:24 PM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '25/Jul/2022' ### 7/25/2022 2:31:24 PM
7/25/2022 2:31:24 PM : ItemLink Successful --->> exec SP_ItemLinkDiff '25/Jul/2022' ### 7/25/2022 2:31:24 PM
7/25/2022 2:31:24 PM :  ### 
7/25/2022 2:31:24 PM : UNLINKEDSALES Record Count Before --->> 114 ### 7/25/2022 2:31:24 PM
7/25/2022 2:31:24 PM : UNLINKEDSALES_DEL Record Count Before --->> 57 ### 7/25/2022 2:31:24 PM
7/25/2022 2:31:37 PM : Posting Sales Successful --->> exec prPostLinkedDiffSales '25/Jul/2022' ### 7/25/2022 2:31:37 PM
7/25/2022 2:31:37 PM : UNLINKEDSALES Record Count After --->> 0 ### 7/25/2022 2:31:37 PM
7/25/2022 2:31:37 PM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 7/25/2022 2:31:37 PM
7/25/2022 2:31:37 PM :  ### 
7/25/2022 2:31:44 PM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '25/Jul/2022' ### 7/25/2022 2:31:44 PM
7/25/2022 2:31:51 PM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '25/Jul/2022' ### 7/25/2022 2:31:51 PM
7/25/2022 2:31:51 PM : Posting Supplierlink Query for CompanyPurchases --->> insert into supplierlink (code,distributorid,name,InsertDate,InsertedDate,LastEditDate,targetid)
                   select distinct suppliercode,PDistributor.distributorid,'' as name, '1900-01-01','2022-07-25 14:31:51','2022-07-25 14:31:51',PDistributor.UnkSupplierId as targetid from UNLINKEDCOMPANYPURCHASES,PDistributor where UNLINKEDCOMPANYPURCHASES.erpcode=PDistributor.erpcode and PDistributor.distributorid+unlinkedcompanypurchases.suppliercode not in (select distinct distributorid+code from supplierlink where code is not null) ### 7/25/2022 2:31:51 PM
7/25/2022 2:31:51 PM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '25/Jul/2022' ### 7/25/2022 2:31:51 PM
7/25/2022 2:31:51 PM : Posting ClosingStock Successful --->>  ### 7/25/2022 2:31:51 PM
7/25/2022 2:31:52 PM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 7/25/2022 2:31:52 PM
7/25/2022 2:31:52 PM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
7/25/2022 2:31:52 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1224500_TEMPLATE1.TXT ### 7/25/2022 2:31:52 PM
7/25/2022 2:31:52 PM : Count:: ### TEMPLATE1:16
7/25/2022 2:31:54 PM : SP_DistributorTemplatePosting Successful --->>  ### 7/25/2022 2:31:54 PM
7/25/2022 2:31:54 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 7/25/2022 2:31:54 PM
7/25/2022 2:31:54 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:31:54 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 7/25/2022 2:31:54 PM
7/25/2022 2:31:54 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:31:54 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 7/25/2022 2:31:54 PM
7/25/2022 2:31:54 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:31:54 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2743253_TEMPLATE1.TXT ### 7/25/2022 2:31:54 PM
7/25/2022 2:31:54 PM : Count:: ### TEMPLATE1:18
7/25/2022 2:31:55 PM : SP_DistributorTemplatePosting Successful --->>  ### 7/25/2022 2:31:55 PM
7/25/2022 2:31:55 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 7/25/2022 2:31:55 PM
7/25/2022 2:31:55 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:31:55 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 7/25/2022 2:31:55 PM
7/25/2022 2:31:55 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:31:55 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3559252_TEMPLATE1.TXT ### 7/25/2022 2:31:55 PM
7/25/2022 2:31:55 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:31:55 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 7/25/2022 2:31:55 PM
7/25/2022 2:31:55 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:31:55 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 7/25/2022 2:31:55 PM
7/25/2022 2:31:55 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:31:55 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3662360_TEMPLATE1.TXT ### 7/25/2022 2:31:55 PM
7/25/2022 2:31:55 PM : Count:: ### TEMPLATE1:74
7/25/2022 2:31:57 PM : SP_DistributorTemplatePosting Successful --->>  ### 7/25/2022 2:31:57 PM
7/25/2022 2:31:57 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 7/25/2022 2:31:57 PM
7/25/2022 2:31:57 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:31:57 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 7/25/2022 2:31:57 PM
7/25/2022 2:31:57 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:31:57 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3985879_TEMPLATE1.txt ### 7/25/2022 2:31:57 PM
7/25/2022 2:31:57 PM : Count:: ### TEMPLATE1:58
7/25/2022 2:31:57 PM : SP_DistributorTemplatePosting Successful --->>  ### 7/25/2022 2:31:57 PM
7/25/2022 2:31:57 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 7/25/2022 2:31:57 PM
7/25/2022 2:31:57 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:31:57 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 7/25/2022 2:31:57 PM
7/25/2022 2:31:57 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:31:57 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 7/25/2022 2:31:57 PM
7/25/2022 2:31:57 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:31:57 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060448_TEMPLATE1.TXT ### 7/25/2022 2:31:57 PM
7/25/2022 2:31:57 PM : Count:: ### TEMPLATE1:14
7/25/2022 2:31:59 PM : SP_DistributorTemplatePosting Successful --->>  ### 7/25/2022 2:31:59 PM
7/25/2022 2:31:59 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060893_TEMPLATE1.txt ### 7/25/2022 2:31:59 PM
7/25/2022 2:31:59 PM : Count:: ### TEMPLATE1:232
7/25/2022 2:32:14 PM : SP_DistributorTemplatePosting Successful --->>  ### 7/25/2022 2:32:14 PM
7/25/2022 2:32:14 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 7/25/2022 2:32:14 PM
7/25/2022 2:32:14 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:32:14 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061358_TEMPLATE1.TXT ### 7/25/2022 2:32:14 PM
7/25/2022 2:32:14 PM : Count:: ### TEMPLATE1:116
7/25/2022 2:32:30 PM : SP_DistributorTemplatePosting Successful --->>  ### 7/25/2022 2:32:30 PM
7/25/2022 2:32:30 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 7/25/2022 2:32:30 PM
7/25/2022 2:32:30 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:32:30 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 7/25/2022 2:32:30 PM
7/25/2022 2:32:30 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:32:30 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062898_TEMPLATE1.TXT ### 7/25/2022 2:32:30 PM
7/25/2022 2:32:30 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:32:30 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 7/25/2022 2:32:30 PM
7/25/2022 2:32:30 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:32:30 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 7/25/2022 2:32:30 PM
7/25/2022 2:32:30 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/25/2022 2:32:30 PM : Error in file  ### TEMPLATE1 (1) at Line 124
7/25/2022 2:32:30 PM : Template Import Complete  ### 7/25/2022 2:32:30 PM
7/25/2022 2:32:33 PM : Completed Updating Has Transaction Flag  ### 7/25/2022 2:32:33 PM
7/25/2022 2:32:33 PM : Transaction Table lastEdiDate Update on BrandAlias Update ### 7/25/2022 2:32:33 PM
7/25/2022 2:32:33 PM : Zylem Access Unblocked  ### 7/25/2022 2:32:33 PM
7/25/2022 2:32:33 PM : MainForm_Load  ### Before Add Entry In Monitoring database
7/25/2022 2:32:33 PM : MainForm_Load  ### After Add Entry In Monitoring database
7/25/2022 2:32:33 PM : StartProcess for importing Closing stock file from ClosingStock folder  ### 7/25/2022 2:32:33 PM

7/25/2022 2:32:33 PM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 2:32:33 PM : Validation Start For All  ### 7/25/2022 2:32:33 PM
7/25/2022 2:32:34 PM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 2:32:34 PM : BAYER_1015312_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 2:32:34 PM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 2:32:34 PM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 2:32:34 PM : BAYER_1224500_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 2:32:34 PM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 2:32:34 PM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 2:32:34 PM : BAYER_2155816_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 1 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 2 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 3 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 4 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 5 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 6 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 7 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 8 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 9 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 10 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 11 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 12 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 13 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 14 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 15 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 16 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 17 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 18 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 19 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 20 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 21 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 22 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 23 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 24 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 25 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 26 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 27 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 28 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 29 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 30 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 31 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 32 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 33 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 34 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 35 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 36 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 37 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 38 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 39 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 40 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 41 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 42 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 43 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 44 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 45 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 46 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 47 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 48 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 49 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 50 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 51 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 52 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 53 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 54 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 55 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 56 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 57 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 58 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 59 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 60 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 61 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 62 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 63 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 64 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 65 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 66 ### 
7/25/2022 2:32:34 PM : File Not Valid for Distributor ERPCode-2155816 ### BAYER_2155816_CLOSINGSTOCK.TXT
7/25/2022 2:32:34 PM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 2:32:34 PM : BAYER_2221168_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 2:32:34 PM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 2:32:34 PM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 2:32:34 PM : BAYER_2743253_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 2:32:34 PM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 2:32:34 PM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 2:32:34 PM : BAYER_3559252_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 2:32:34 PM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 2:32:34 PM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 2:32:34 PM : BAYER_3576162_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 2:32:34 PM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 2:32:34 PM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 2:32:34 PM : BAYER_3662360_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 2:32:34 PM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 2:32:34 PM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 2:32:34 PM : BAYER_3888864_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 1 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 2 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 3 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 4 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 5 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 6 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 7 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 8 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 9 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 10 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 11 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 12 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 13 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 14 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 15 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 16 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 17 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 18 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 19 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 20 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 21 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 22 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 23 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 24 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 25 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 26 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 27 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 28 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 29 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 30 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 31 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 32 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 33 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 34 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 35 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 36 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 37 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 38 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 39 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 40 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 41 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 42 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 43 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 44 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 45 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 46 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 47 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 48 ### 
7/25/2022 2:32:34 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 49 ### 
7/25/2022 2:32:34 PM : File Not Valid for Distributor ERPCode-3888864 ### BAYER_3888864_CLOSINGSTOCK.TXT
7/25/2022 2:32:34 PM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 2:32:34 PM : BAYER_3985879_CLOSINGSTOCK.txt, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 2:32:34 PM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 2:32:34 PM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 2:32:34 PM : BAYER_9060448_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 2:32:34 PM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 2:32:34 PM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 2:32:34 PM : BAYER_9060893_CLOSINGSTOCK.txt, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 2:32:34 PM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 2:32:34 PM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 2:32:34 PM : BAYER_9061358_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 2:32:34 PM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 2:32:34 PM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 2:32:35 PM : BAYER_9066916_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 2:32:35 PM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 2:32:35 PM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 2:32:35 PM : BAYER_9067109_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 2:32:35 PM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 2:32:35 PM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 2:32:35 PM : BAYER_9067110_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 2:32:35 PM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 2:32:35 PM : Start Process : checkAllTablesExists()  ### Start
7/25/2022 2:32:35 PM : BAYER_9067111_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/25/2022 2:32:35 PM : splitFileDaywiseNewNaming  ###  called 
7/25/2022 2:32:35 PM : Import Start For All  ### 7/25/2022 2:32:35 PM
7/25/2022 2:32:35 PM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
7/25/2022 2:32:35 PM : Import ClosingStock File --->> CL_1316_20220725_e3805743c97d837005e4b364e02138ee.TXT ### 7/25/2022 2:32:35 PM
7/25/2022 2:32:35 PM : File For Distributor 000000000001316 ### Insert Count::16
7/25/2022 2:32:35 PM : Import ClosingStock File --->> CL_1317_20220725_cda6c217dee7c64340e3c898920ae9ba.TXT ### 7/25/2022 2:32:35 PM
7/25/2022 2:32:35 PM : File For Distributor 000000000001317 ### Insert Count::18
7/25/2022 2:32:35 PM : Import ClosingStock File --->> CL_1320_20220725_e4ac41e5b21adbb83fe113c3893dd1aa.TXT ### 7/25/2022 2:32:35 PM
7/25/2022 2:32:35 PM : File For Distributor 000000000001320 ### Insert Count::16
7/25/2022 2:32:36 PM : Import ClosingStock File --->> CL_351_20220725_671ea7efc0fa2944f027792061a09d89.TXT ### 7/25/2022 2:32:36 PM
7/25/2022 2:32:36 PM : File For Distributor 000000000000351 ### Insert Count::21
7/25/2022 2:32:36 PM : Import ClosingStock File --->> CL_354_20220725_7e0da4229b133fa9801b2d7ce545bd50.TXT ### 7/25/2022 2:32:36 PM
7/25/2022 2:32:36 PM : File For Distributor 000000000000354 ### Insert Count::18
7/25/2022 2:32:36 PM : Import ClosingStock File --->> CL_372_20220725_9daee8362745ff1c2674c3b0643e1245.TXT ### 7/25/2022 2:32:36 PM
7/25/2022 2:32:36 PM : File For Distributor 000000000000372 ### Insert Count::24
7/25/2022 2:32:36 PM : Import ClosingStock File --->> CL_424_20220725_6af8de4ce2afd15a6195dd4e7a4aa2b9.TXT ### 7/25/2022 2:32:36 PM
7/25/2022 2:32:36 PM : File For Distributor 000000000000424 ### Insert Count::107
7/25/2022 2:32:37 PM : Import ClosingStock File --->> CL_492_20220725_7156b381d6cedfbfcc3d2b637e34a0a2.TXT ### 7/25/2022 2:32:37 PM
7/25/2022 2:32:37 PM : File For Distributor 000000000000492 ### Insert Count::20
7/25/2022 2:32:37 PM : Import ClosingStock File --->> CL_812_20220725_425b0005512cd5fd535e67825b20e53b.TXT ### 7/25/2022 2:32:37 PM
7/25/2022 2:32:37 PM : File For Distributor 000000000000812 ### Insert Count::35
7/25/2022 2:32:37 PM : Import ClosingStock File --->> CL_817_20220725_677c50da5b35a3ab71da91e8d1e5c553.TXT ### 7/25/2022 2:32:37 PM
7/25/2022 2:32:37 PM : File For Distributor 000000000000817 ### Insert Count::43
7/25/2022 2:32:37 PM : Procedure Name - exec prPostItemClosingStock ### 7/25/2022 2:32:37 PM
7/25/2022 2:32:38 PM : Posting Closing Stock Successful --->>  ### 7/25/2022 2:32:38 PM
7/25/2022 2:32:38 PM : End Process for importing Closing stock file from ClosingStock folder End Time----------- ### 7/25/2022 2:32:38 PM
7/25/2022 2:32:38 PM : Importing ended from WinZylemImport exe. Updated Value of BlockImportingProcess - 0 in Settings table ### 7/25/2022 2:32:38 PM

7/25/2022 2:32:38 PM : Application Ended  ### 7/25/2022 2:32:38 PM