7/31/2022 2:30:01 AM : Start Process : checkAllTablesExists()  ### Start
7/31/2022 2:30:01 AM : StartProcess  ### 7/31/2022 2:30:01 AM

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

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

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

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

7/31/2022 2:30:01 AM : 11  ### 7/31/2022 2:30:01 AM

7/31/2022 2:30:01 AM : 22  ### 7/31/2022 2:30:01 AM

7/31/2022 2:30:01 AM : 33  ### 7/31/2022 2:30:01 AM

7/31/2022 2:30:01 AM : Application Started  ### 7/31/2022 2:30:01 AM

7/31/2022 2:30:01 AM : Start Process : checkAllTablesExists()  ### Start
7/31/2022 2:30:02 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 7/31/2022 2:30:02 AM
7/31/2022 2:30:02 AM : MainForm_Load  ### AlertSystem ON
7/31/2022 2:30:02 AM : No. of Files to import (RECEIVEFINAL):  ### 1
7/31/2022 2:30:02 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
7/31/2022 2:30:02 AM : PostData() --->>  ### 7/31/2022 2:30:02 AM
7/31/2022 2:30:02 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 7/31/2022 2:30:02 AM
7/31/2022 2:30:02 AM : SupplierLink Successful --->> exec SP_SupplierLinkDiff '31/Jul/2022' ### 7/31/2022 2:30:02 AM
7/31/2022 2:30:03 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '31/Jul/2022' ### 7/31/2022 2:30:03 AM
7/31/2022 2:30:03 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '31/Jul/2022' ### 7/31/2022 2:30:03 AM
7/31/2022 2:30:03 AM :  ### 
7/31/2022 2:30:03 AM : UNLINKEDSALES Record Count Before --->> 0 ### 7/31/2022 2:30:03 AM
7/31/2022 2:30:03 AM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 7/31/2022 2:30:03 AM
7/31/2022 2:30:13 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '31/Jul/2022' ### 7/31/2022 2:30:13 AM
7/31/2022 2:30:13 AM : UNLINKEDSALES Record Count After --->> 0 ### 7/31/2022 2:30:13 AM
7/31/2022 2:30:13 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 7/31/2022 2:30:13 AM
7/31/2022 2:30:13 AM :  ### 
7/31/2022 2:30:19 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '31/Jul/2022' ### 7/31/2022 2:30:19 AM
7/31/2022 2:30:26 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '31/Jul/2022' ### 7/31/2022 2:30:26 AM
7/31/2022 2:30:26 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-31 02:30:26','2022-07-31 02:30:26',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/31/2022 2:30:26 AM
7/31/2022 2:30:26 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '31/Jul/2022' ### 7/31/2022 2:30:26 AM
7/31/2022 2:30:26 AM : Posting ClosingStock Successful --->>  ### 7/31/2022 2:30:26 AM
7/31/2022 2:30:26 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 7/31/2022 2:30:26 AM
7/31/2022 2:30:27 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
7/31/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 7/31/2022 2:30:27 AM
7/31/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 7/31/2022 2:30:27 AM
7/31/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 7/31/2022 2:30:27 AM
7/31/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 7/31/2022 2:30:27 AM
7/31/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 7/31/2022 2:30:27 AM
7/31/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3559252_TEMPLATE1.TXT ### 7/31/2022 2:30:27 AM
7/31/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 7/31/2022 2:30:27 AM
7/31/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 7/31/2022 2:30:27 AM
7/31/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 7/31/2022 2:30:27 AM
7/31/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 7/31/2022 2:30:27 AM
7/31/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 7/31/2022 2:30:27 AM
7/31/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 7/31/2022 2:30:27 AM
7/31/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 7/31/2022 2:30:27 AM
7/31/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 7/31/2022 2:30:27 AM
7/31/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 7/31/2022 2:30:27 AM
7/31/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 7/31/2022 2:30:27 AM
7/31/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062898_TEMPLATE1.TXT ### 7/31/2022 2:30:27 AM
7/31/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 7/31/2022 2:30:27 AM
7/31/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 7/31/2022 2:30:27 AM
7/31/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:27 AM : Error in file  ### TEMPLATE1 (1) at Line 124
7/31/2022 2:30:27 AM : Template Import Complete  ### 7/31/2022 2:30:27 AM
7/31/2022 2:30:30 AM : Completed Updating Has Transaction Flag  ### 7/31/2022 2:30:30 AM
7/31/2022 2:30:30 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 7/31/2022 2:30:30 AM
7/31/2022 2:30:30 AM : Zylem Access Unblocked  ### 7/31/2022 2:30:30 AM
7/31/2022 2:30:30 AM : MainForm_Load  ### Before Add Entry In Monitoring database
7/31/2022 2:30:30 AM : MainForm_Load  ### After Add Entry In Monitoring database
7/31/2022 2:30:30 AM : StartProcess for importing Closing stock file from ClosingStock folder  ### 7/31/2022 2:30:30 AM

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

7/31/2022 2:30:30 AM : Application Ended  ### 7/31/2022 2:30:30 AM

7/31/2022 7:30:06 AM : Start Process : checkAllTablesExists()  ### Start
7/31/2022 7:30:07 AM : StartProcess  ### 7/31/2022 7:30:07 AM

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

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

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

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

7/31/2022 7:30:07 AM : 11  ### 7/31/2022 7:30:07 AM

7/31/2022 7:30:07 AM : 22  ### 7/31/2022 7:30:07 AM

7/31/2022 7:30:07 AM : 33  ### 7/31/2022 7:30:07 AM

7/31/2022 7:30:07 AM : Application Started  ### 7/31/2022 7:30:07 AM

7/31/2022 7:30:07 AM : Start Process : checkAllTablesExists()  ### Start
7/31/2022 7:30:07 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 7/31/2022 7:30:07 AM
7/31/2022 7:30:07 AM : MainForm_Load  ### AlertSystem ON
7/31/2022 7:30:07 AM : No. of Files to import (RECEIVEFINAL):  ### 524
7/31/2022 7:30:07 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
7/31/2022 7:30:08 AM : For Distributor 000000000001026 Insert Count::1 ### Delete Count::0
7/31/2022 7:30:08 AM : Import AD File --->> AD_1026_20220731_73e26fe18a6cd3c11ef4497908f2bf77.TXT ### 7/31/2022 7:30:08 AM
7/31/2022 7:30:39 AM : For Distributor 000000000000365 Insert Count::1 ### Delete Count::0
7/31/2022 7:30:39 AM : Import DN File --->> DN_365_20220728_bc91714b0ebf6dcc144dd0a0b0c49451.TXT ### 7/31/2022 7:30:39 AM
7/31/2022 7:30:50 AM : For Distributor 000000000001026 Insert Count::16 ### Delete Count::0
7/31/2022 7:30:50 AM : Import IN File --->> IN_1026_20220730_7ae1f18ff60d3d0b0d50d82a219acda0.TXT ### 7/31/2022 7:30:50 AM
7/31/2022 7:30:57 AM : PostData() --->>  ### 7/31/2022 7:30:57 AM
7/31/2022 7:30:57 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 7/31/2022 7:30:57 AM
7/31/2022 7:30:58 AM : SupplierLink Successful --->> exec SP_SupplierLinkDiff '31/Jul/2022' ### 7/31/2022 7:30:58 AM
7/31/2022 7:30:59 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '31/Jul/2022' ### 7/31/2022 7:30:59 AM
7/31/2022 7:30:59 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '31/Jul/2022' ### 7/31/2022 7:30:59 AM
7/31/2022 7:30:59 AM :  ### 
7/31/2022 7:30:59 AM : UNLINKEDSALES Record Count Before --->> 16 ### 7/31/2022 7:30:59 AM
7/31/2022 7:30:59 AM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 7/31/2022 7:30:59 AM
7/31/2022 7:31:09 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '31/Jul/2022' ### 7/31/2022 7:31:09 AM
7/31/2022 7:31:09 AM : UNLINKEDSALES Record Count After --->> 0 ### 7/31/2022 7:31:09 AM
7/31/2022 7:31:09 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 7/31/2022 7:31:09 AM
7/31/2022 7:31:09 AM :  ### 
7/31/2022 7:31:15 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '31/Jul/2022' ### 7/31/2022 7:31:15 AM
7/31/2022 7:31:22 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '31/Jul/2022' ### 7/31/2022 7:31:22 AM
7/31/2022 7:31:22 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-31 07:31:22','2022-07-31 07:31:22',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/31/2022 7:31:22 AM
7/31/2022 7:31:22 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '31/Jul/2022' ### 7/31/2022 7:31:22 AM
7/31/2022 7:31:22 AM : Posting ClosingStock Successful --->>  ### 7/31/2022 7:31:22 AM
7/31/2022 7:31:22 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 7/31/2022 7:31:22 AM
7/31/2022 7:31:22 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
7/31/2022 7:31:22 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 7/31/2022 7:31:22 AM
7/31/2022 7:31:22 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 7:31:22 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 7/31/2022 7:31:22 AM
7/31/2022 7:31:22 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 7:31:22 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 7/31/2022 7:31:22 AM
7/31/2022 7:31:22 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 7:31:22 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 7/31/2022 7:31:22 AM
7/31/2022 7:31:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 7:31:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 7/31/2022 7:31:23 AM
7/31/2022 7:31:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 7:31:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3559252_TEMPLATE1.TXT ### 7/31/2022 7:31:23 AM
7/31/2022 7:31:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 7:31:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 7/31/2022 7:31:23 AM
7/31/2022 7:31:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 7:31:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 7/31/2022 7:31:23 AM
7/31/2022 7:31:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 7:31:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 7/31/2022 7:31:23 AM
7/31/2022 7:31:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 7:31:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 7/31/2022 7:31:23 AM
7/31/2022 7:31:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 7:31:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 7/31/2022 7:31:23 AM
7/31/2022 7:31:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 7:31:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 7/31/2022 7:31:23 AM
7/31/2022 7:31:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 7:31:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 7/31/2022 7:31:23 AM
7/31/2022 7:31:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 7:31:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 7/31/2022 7:31:23 AM
7/31/2022 7:31:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 7:31:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 7/31/2022 7:31:23 AM
7/31/2022 7:31:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 7:31:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 7/31/2022 7:31:23 AM
7/31/2022 7:31:23 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 7:31:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062642_TEMPLATE1.txt ### 7/31/2022 7:31:23 AM
7/31/2022 7:31:23 AM : Count:: ### TEMPLATE1:38
7/31/2022 7:31:25 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/31/2022 7:31:25 AM
7/31/2022 7:31:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062898_TEMPLATE1.TXT ### 7/31/2022 7:31:25 AM
7/31/2022 7:31:25 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 7:31:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 7/31/2022 7:31:25 AM
7/31/2022 7:31:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 7:31:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 7/31/2022 7:31:26 AM
7/31/2022 7:31:26 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 7:31:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9064126_TEMPLATE1.TXT ### 7/31/2022 7:31:26 AM
7/31/2022 7:31:26 AM : Count:: ### TEMPLATE1:2
7/31/2022 7:31:26 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/31/2022 7:31:26 AM
7/31/2022 7:31:26 AM : Error in file  ### TEMPLATE1 (1) at Line 2
7/31/2022 7:31:26 AM : Template Import Complete  ### 7/31/2022 7:31:26 AM
7/31/2022 7:31:29 AM : Completed Updating Has Transaction Flag  ### 7/31/2022 7:31:29 AM
7/31/2022 7:31:29 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 7/31/2022 7:31:29 AM
7/31/2022 7:31:29 AM : Zylem Access Unblocked  ### 7/31/2022 7:31:29 AM
7/31/2022 7:31:29 AM : MainForm_Load  ### Before Add Entry In Monitoring database
7/31/2022 7:31:29 AM : MainForm_Load  ### After Add Entry In Monitoring database
7/31/2022 7:31:29 AM : StartProcess for importing Closing stock file from ClosingStock folder  ### 7/31/2022 7:31:29 AM

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

7/31/2022 7:31:30 AM : Application Ended  ### 7/31/2022 7:31:30 AM

7/31/2022 2:30:03 PM : Start Process : checkAllTablesExists()  ### Start
7/31/2022 2:30:03 PM : StartProcess  ### 7/31/2022 2:30:03 PM

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

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

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

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

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

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

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

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

7/31/2022 2:30:03 PM : Start Process : checkAllTablesExists()  ### Start
7/31/2022 2:30:03 PM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 7/31/2022 2:30:03 PM
7/31/2022 2:30:03 PM : MainForm_Load  ### AlertSystem ON
7/31/2022 2:30:03 PM : No. of Files to import (RECEIVEFINAL):  ### 490
7/31/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/31/2022 2:30:04 PM : For Distributor 000000000000525 Insert Count::1 ### Delete Count::0
7/31/2022 2:30:04 PM : Import AD File --->> AD_525_20220731_d7e3010920f174c0f3e381641c618ac9.TXT ### 7/31/2022 2:30:04 PM
7/31/2022 2:30:23 PM : For Distributor 000000000000525 Insert Count::3 ### Delete Count::0
7/31/2022 2:30:23 PM : Import IN File --->> IN_525_20220712_7ac18c604cf4a026b304cb81bd4d0887.TXT ### 7/31/2022 2:30:23 PM
7/31/2022 2:30:23 PM : For Distributor 000000000000525 Insert Count::3 ### Delete Count::0
7/31/2022 2:30:23 PM : Import IN File --->> IN_525_20220713_094fa47be917ad1da5359c0bfc0a6ee1.TXT ### 7/31/2022 2:30:23 PM
7/31/2022 2:30:23 PM : For Distributor 000000000000525 Insert Count::3 ### Delete Count::0
7/31/2022 2:30:23 PM : Import IN File --->> IN_525_20220714_14431c16f3417c604cd3c691378e7995.TXT ### 7/31/2022 2:30:23 PM
7/31/2022 2:30:23 PM : For Distributor 000000000000525 Insert Count::3 ### Delete Count::0
7/31/2022 2:30:23 PM : Import IN File --->> IN_525_20220715_4b78a6ffe9910eaed0c1c03688f323e6.TXT ### 7/31/2022 2:30:23 PM
7/31/2022 2:30:23 PM : For Distributor 000000000000525 Insert Count::8 ### Delete Count::0
7/31/2022 2:30:23 PM : Import IN File --->> IN_525_20220716_d3b60171c4aa3912b258a052e05716ba.TXT ### 7/31/2022 2:30:23 PM
7/31/2022 2:30:24 PM : For Distributor 000000000000525 Insert Count::3 ### Delete Count::0
7/31/2022 2:30:24 PM : Import IN File --->> IN_525_20220718_c587ee5e006ed1d46341668e3d1db845.TXT ### 7/31/2022 2:30:24 PM
7/31/2022 2:30:24 PM : For Distributor 000000000000525 Insert Count::2 ### Delete Count::0
7/31/2022 2:30:24 PM : Import IN File --->> IN_525_20220719_a760f94b76cbb10e9688bd9b362b7780.TXT ### 7/31/2022 2:30:24 PM
7/31/2022 2:30:24 PM : For Distributor 000000000000525 Insert Count::2 ### Delete Count::0
7/31/2022 2:30:24 PM : Import IN File --->> IN_525_20220727_9efcb5ee19f285401c978c9b8edfbdd0.TXT ### 7/31/2022 2:30:24 PM
7/31/2022 2:30:24 PM : For Distributor 000000000000525 Insert Count::1 ### Delete Count::0
7/31/2022 2:30:24 PM : Import IN File --->> IN_525_20220730_3b901ab23969eef9e14ad9054e6ddcf2.TXT ### 7/31/2022 2:30:24 PM
7/31/2022 2:30:24 PM : Import IN File --->> IN_525_20220731_0ad1ead4150390eb2f9ee2bfca1785ae.TXT ### 7/31/2022 2:30:24 PM
7/31/2022 2:30:24 PM : NO Previous File For Distributor 000000000000525 ### Insert Count::1
7/31/2022 2:30:24 PM : PostData() --->>  ### 7/31/2022 2:30:24 PM
7/31/2022 2:30:25 PM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 7/31/2022 2:30:25 PM
7/31/2022 2:30:26 PM : SupplierLink Successful --->> exec SP_SupplierLinkDiff '31/Jul/2022' ### 7/31/2022 2:30:26 PM
7/31/2022 2:30:27 PM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '31/Jul/2022' ### 7/31/2022 2:30:27 PM
7/31/2022 2:30:28 PM : ItemLink Successful --->> exec SP_ItemLinkDiff '31/Jul/2022' ### 7/31/2022 2:30:28 PM
7/31/2022 2:30:28 PM :  ### 
7/31/2022 2:30:28 PM : UNLINKEDSALES Record Count Before --->> 29 ### 7/31/2022 2:30:28 PM
7/31/2022 2:30:28 PM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 7/31/2022 2:30:28 PM
7/31/2022 2:30:37 PM : Posting Sales Successful --->> exec prPostLinkedDiffSales '31/Jul/2022' ### 7/31/2022 2:30:37 PM
7/31/2022 2:30:37 PM : UNLINKEDSALES Record Count After --->> 0 ### 7/31/2022 2:30:37 PM
7/31/2022 2:30:37 PM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 7/31/2022 2:30:37 PM
7/31/2022 2:30:37 PM :  ### 
7/31/2022 2:30:43 PM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '31/Jul/2022' ### 7/31/2022 2:30:43 PM
7/31/2022 2:30:50 PM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '31/Jul/2022' ### 7/31/2022 2:30:50 PM
7/31/2022 2:30:50 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-31 14:30:50','2022-07-31 14:30:50',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/31/2022 2:30:50 PM
7/31/2022 2:30:50 PM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '31/Jul/2022' ### 7/31/2022 2:30:50 PM
7/31/2022 2:30:51 PM : Posting ClosingStock Successful --->>  ### 7/31/2022 2:30:51 PM
7/31/2022 2:30:51 PM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 7/31/2022 2:30:51 PM
7/31/2022 2:30:51 PM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
7/31/2022 2:30:51 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 7/31/2022 2:30:51 PM
7/31/2022 2:30:51 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:51 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 7/31/2022 2:30:51 PM
7/31/2022 2:30:51 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:51 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 7/31/2022 2:30:51 PM
7/31/2022 2:30:51 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:51 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 7/31/2022 2:30:51 PM
7/31/2022 2:30:51 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:51 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 7/31/2022 2:30:51 PM
7/31/2022 2:30:51 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:51 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3559252_TEMPLATE1.TXT ### 7/31/2022 2:30:51 PM
7/31/2022 2:30:51 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:51 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 7/31/2022 2:30:51 PM
7/31/2022 2:30:51 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:51 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 7/31/2022 2:30:51 PM
7/31/2022 2:30:51 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:51 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 7/31/2022 2:30:51 PM
7/31/2022 2:30:51 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:51 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 7/31/2022 2:30:51 PM
7/31/2022 2:30:51 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:51 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 7/31/2022 2:30:51 PM
7/31/2022 2:30:51 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:51 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 7/31/2022 2:30:51 PM
7/31/2022 2:30:51 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:51 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 7/31/2022 2:30:51 PM
7/31/2022 2:30:51 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:51 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 7/31/2022 2:30:51 PM
7/31/2022 2:30:51 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:51 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061033_TEMPLATE1.TXT ### 7/31/2022 2:30:51 PM
7/31/2022 2:30:51 PM : Count:: ### TEMPLATE1:117
7/31/2022 2:30:59 PM : SP_DistributorTemplatePosting Successful --->>  ### 7/31/2022 2:30:59 PM
7/31/2022 2:30:59 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 7/31/2022 2:30:59 PM
7/31/2022 2:30:59 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:59 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 7/31/2022 2:30:59 PM
7/31/2022 2:30:59 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:59 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062898_TEMPLATE1.TXT ### 7/31/2022 2:30:59 PM
7/31/2022 2:30:59 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:59 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 7/31/2022 2:30:59 PM
7/31/2022 2:30:59 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:59 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 7/31/2022 2:30:59 PM
7/31/2022 2:30:59 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/31/2022 2:30:59 PM : Error in file  ### TEMPLATE1 (1) at Line 124
7/31/2022 2:30:59 PM : Template Import Complete  ### 7/31/2022 2:30:59 PM
7/31/2022 2:31:01 PM : Completed Updating Has Transaction Flag  ### 7/31/2022 2:31:01 PM
7/31/2022 2:31:01 PM : Transaction Table lastEdiDate Update on BrandAlias Update ### 7/31/2022 2:31:01 PM
7/31/2022 2:31:01 PM : Zylem Access Unblocked  ### 7/31/2022 2:31:01 PM
7/31/2022 2:31:02 PM : MainForm_Load  ### Before Add Entry In Monitoring database
7/31/2022 2:31:02 PM : MainForm_Load  ### After Add Entry In Monitoring database
7/31/2022 2:31:02 PM : StartProcess for importing Closing stock file from ClosingStock folder  ### 7/31/2022 2:31:02 PM

7/31/2022 2:31:02 PM : Start Process : checkAllTablesExists()  ### Start
7/31/2022 2:31:02 PM : Validation Start For All  ### 7/31/2022 2:31:02 PM
7/31/2022 2:31:02 PM : Start Process : checkAllTablesExists()  ### Start
7/31/2022 2:31:02 PM : BAYER_2155816_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 1 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 2 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 3 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 4 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 5 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 6 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 7 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 8 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 9 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 10 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 11 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 12 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 13 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 14 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 15 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 16 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 17 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 18 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 19 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 20 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 21 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 22 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 23 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 24 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 25 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 26 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 27 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 28 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 29 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 30 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 31 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 32 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 33 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 34 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 35 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 36 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 37 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 38 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 39 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 40 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 41 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 42 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 43 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 44 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 45 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 46 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 47 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 48 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 49 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 50 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 51 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 52 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 53 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 54 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 55 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 56 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 57 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 58 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 59 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 60 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 61 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 62 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 63 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 64 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 65 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT  at column=code : row= 66 ### 
7/31/2022 2:31:02 PM : File Not Valid for Distributor ERPCode-2155816 ### BAYER_2155816_CLOSINGSTOCK.TXT
7/31/2022 2:31:02 PM : Start Process : checkAllTablesExists()  ### Start
7/31/2022 2:31:02 PM : BAYER_3576162_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/31/2022 2:31:02 PM : splitFileDaywiseNewNaming  ###  called 
7/31/2022 2:31:02 PM : Start Process : checkAllTablesExists()  ### Start
7/31/2022 2:31:02 PM : BAYER_3888864_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 1 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 2 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 3 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 4 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 5 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 6 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 7 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 8 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 9 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 10 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 11 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 12 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 13 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 14 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 15 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 16 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 17 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 18 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 19 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 20 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 21 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 22 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 23 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 24 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 25 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 26 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 27 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 28 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 29 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 30 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 31 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 32 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 33 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 34 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 35 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 36 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 37 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 38 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 39 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 40 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 41 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 42 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 43 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 44 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 45 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 46 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 47 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 48 ### 
7/31/2022 2:31:02 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT  at column=code : row= 49 ### 
7/31/2022 2:31:02 PM : File Not Valid for Distributor ERPCode-3888864 ### BAYER_3888864_CLOSINGSTOCK.TXT
7/31/2022 2:31:02 PM : Start Process : checkAllTablesExists()  ### Start
7/31/2022 2:31:02 PM : BAYER_9061033_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/31/2022 2:31:02 PM : splitFileDaywiseNewNaming  ###  called 
7/31/2022 2:31:02 PM : Start Process : checkAllTablesExists()  ### Start
7/31/2022 2:31:02 PM : BAYER_9067049_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV
7/31/2022 2:31:02 PM : splitFileDaywiseNewNaming  ###  called 
7/31/2022 2:31:02 PM : Import Start For All  ### 7/31/2022 2:31:02 PM
7/31/2022 2:31:02 PM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
7/31/2022 2:31:03 PM : Import ClosingStock File --->> CL_525_20220731_25a9535ad0f5a9a6375c937566335688.TXT ### 7/31/2022 2:31:03 PM
7/31/2022 2:31:03 PM : File For Distributor 000000000000525 ### Insert Count::14
7/31/2022 2:31:03 PM : Procedure Name - exec prPostItemClosingStock ### 7/31/2022 2:31:03 PM
7/31/2022 2:31:03 PM : Posting Closing Stock Successful --->>  ### 7/31/2022 2:31:03 PM
7/31/2022 2:31:03 PM : End Process for importing Closing stock file from ClosingStock folder End Time----------- ### 7/31/2022 2:31:03 PM
7/31/2022 2:31:03 PM : Importing ended from WinZylemImport exe. Updated Value of BlockImportingProcess - 0 in Settings table ### 7/31/2022 2:31:03 PM

7/31/2022 2:31:03 PM : Application Ended  ### 7/31/2022 2:31:03 PM