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

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

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

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

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

7/24/2022 2:30:02 AM : 11  ### 7/24/2022 2:30:02 AM

7/24/2022 2:30:02 AM : 22  ### 7/24/2022 2:30:02 AM

7/24/2022 2:30:02 AM : 33  ### 7/24/2022 2:30:02 AM

7/24/2022 2:30:02 AM : Application Started  ### 7/24/2022 2:30:02 AM

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

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

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

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

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

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

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

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

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

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

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

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

7/24/2022 7:30:06 AM : Start Process : checkAllTablesExists()  ### Start
7/24/2022 7:30:06 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 7/24/2022 7:30:06 AM
7/24/2022 7:30:06 AM : MainForm_Load  ### AlertSystem ON
7/24/2022 7:30:06 AM : No. of Files to import (RECEIVEFINAL):  ### 780
7/24/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/24/2022 7:30:06 AM : For Distributor 000000000001026 Insert Count::1 ### Delete Count::0
7/24/2022 7:30:06 AM : Import AD File --->> AD_1026_20220724_77e93072cb8b64c79803fa353a329ec9.TXT ### 7/24/2022 7:30:06 AM
7/24/2022 7:30:07 AM : For Distributor 000000000000424 Insert Count::1 ### Delete Count::0
7/24/2022 7:30:07 AM : Import AD File --->> AD_424_20220724_98aeafb76d173aad9ea7feb392cd4357.TXT ### 7/24/2022 7:30:07 AM
7/24/2022 7:30:22 AM : For Distributor 000000000000424 Insert Count::3 ### Delete Count::0
7/24/2022 7:30:22 AM : Import DN File --->> DN_424_20220721_63333fab3c04e0f43b64f1a098133765.TXT ### 7/24/2022 7:30:22 AM
7/24/2022 7:30:23 AM : For Distributor 000000000000424 Insert Count::2 ### Delete Count::0
7/24/2022 7:30:23 AM : Import DN File --->> DN_424_20220722_453efc5c99e92327d5bef47225c07c4a.TXT ### 7/24/2022 7:30:23 AM
7/24/2022 7:30:27 AM : For Distributor 000000000001026 Insert Count::1 ### Delete Count::0
7/24/2022 7:30:27 AM : Import IN File --->> IN_1026_20220723_3827df5c801d646fcf871429bea1ab72.TXT ### 7/24/2022 7:30:27 AM
7/24/2022 7:30:38 AM : For Distributor 000000000000424 Insert Count::19 ### Delete Count::0
7/24/2022 7:30:38 AM : Import IN File --->> IN_424_20220723_c62b8b8e8dd8ca4871f39db17332a4fb.TXT ### 7/24/2022 7:30:38 AM
7/24/2022 7:30:40 AM : PostData() --->>  ### 7/24/2022 7:30:40 AM
7/24/2022 7:30:41 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 7/24/2022 7:30:41 AM
7/24/2022 7:30:41 AM : SupplierLink Successful --->> exec SP_SupplierLinkDiff '24/Jul/2022' ### 7/24/2022 7:30:41 AM
7/24/2022 7:30:42 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '24/Jul/2022' ### 7/24/2022 7:30:42 AM
7/24/2022 7:30:43 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '24/Jul/2022' ### 7/24/2022 7:30:43 AM
7/24/2022 7:30:43 AM :  ### 
7/24/2022 7:30:43 AM : UNLINKEDSALES Record Count Before --->> 20 ### 7/24/2022 7:30:43 AM
7/24/2022 7:30:43 AM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 7/24/2022 7:30:43 AM
7/24/2022 7:30:52 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '24/Jul/2022' ### 7/24/2022 7:30:52 AM
7/24/2022 7:30:52 AM : UNLINKEDSALES Record Count After --->> 0 ### 7/24/2022 7:30:52 AM
7/24/2022 7:30:52 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 7/24/2022 7:30:52 AM
7/24/2022 7:30:52 AM :  ### 
7/24/2022 7:30:58 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '24/Jul/2022' ### 7/24/2022 7:30:58 AM
7/24/2022 7:31:05 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '24/Jul/2022' ### 7/24/2022 7:31:05 AM
7/24/2022 7:31:05 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-24 07:31:05','2022-07-24 07:31:05',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/24/2022 7:31:05 AM
7/24/2022 7:31:05 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '24/Jul/2022' ### 7/24/2022 7:31:05 AM
7/24/2022 7:31:05 AM : Posting ClosingStock Successful --->>  ### 7/24/2022 7:31:05 AM
7/24/2022 7:31:05 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 7/24/2022 7:31:05 AM
7/24/2022 7:31:06 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
7/24/2022 7:31:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 7/24/2022 7:31:06 AM
7/24/2022 7:31:06 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/24/2022 7:31:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 7/24/2022 7:31:06 AM
7/24/2022 7:31:06 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/24/2022 7:31:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 7/24/2022 7:31:06 AM
7/24/2022 7:31:06 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/24/2022 7:31:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 7/24/2022 7:31:06 AM
7/24/2022 7:31:06 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/24/2022 7:31:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 7/24/2022 7:31:06 AM
7/24/2022 7:31:06 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/24/2022 7:31:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3559252_TEMPLATE1.TXT ### 7/24/2022 7:31:06 AM
7/24/2022 7:31:06 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/24/2022 7:31:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 7/24/2022 7:31:06 AM
7/24/2022 7:31:06 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/24/2022 7:31:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 7/24/2022 7:31:06 AM
7/24/2022 7:31:06 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/24/2022 7:31:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 7/24/2022 7:31:06 AM
7/24/2022 7:31:06 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/24/2022 7:31:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 7/24/2022 7:31:06 AM
7/24/2022 7:31:06 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/24/2022 7:31:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 7/24/2022 7:31:06 AM
7/24/2022 7:31:06 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/24/2022 7:31:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 7/24/2022 7:31:06 AM
7/24/2022 7:31:06 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/24/2022 7:31:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 7/24/2022 7:31:06 AM
7/24/2022 7:31:06 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/24/2022 7:31:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060893_TEMPLATE1.txt ### 7/24/2022 7:31:06 AM
7/24/2022 7:31:06 AM : Count:: ### TEMPLATE1:229
7/24/2022 7:31:22 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/24/2022 7:31:22 AM
7/24/2022 7:31:22 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 7/24/2022 7:31:22 AM
7/24/2022 7:31:22 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/24/2022 7:31:22 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 7/24/2022 7:31:22 AM
7/24/2022 7:31:22 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/24/2022 7:31:22 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 7/24/2022 7:31:22 AM
7/24/2022 7:31:22 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/24/2022 7:31:22 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062642_TEMPLATE1.txt ### 7/24/2022 7:31:22 AM
7/24/2022 7:31:22 AM : Count:: ### TEMPLATE1:36
7/24/2022 7:31:24 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/24/2022 7:31:24 AM
7/24/2022 7:31:24 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062898_TEMPLATE1.TXT ### 7/24/2022 7:31:24 AM
7/24/2022 7:31:24 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/24/2022 7:31:24 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 7/24/2022 7:31:24 AM
7/24/2022 7:31:24 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/24/2022 7:31:24 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 7/24/2022 7:31:24 AM
7/24/2022 7:31:24 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/24/2022 7:31:24 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9064126_TEMPLATE1.TXT ### 7/24/2022 7:31:24 AM
7/24/2022 7:31:24 AM : Count:: ### TEMPLATE1:2
7/24/2022 7:31:25 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/24/2022 7:31:25 AM
7/24/2022 7:31:25 AM : Error in file  ### TEMPLATE1 (1) at Line 2
7/24/2022 7:31:25 AM : Template Import Complete  ### 7/24/2022 7:31:25 AM
7/24/2022 7:31:27 AM : Completed Updating Has Transaction Flag  ### 7/24/2022 7:31:27 AM
7/24/2022 7:31:27 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 7/24/2022 7:31:27 AM
7/24/2022 7:31:27 AM : Zylem Access Unblocked  ### 7/24/2022 7:31:27 AM
7/24/2022 7:31:28 AM : MainForm_Load  ### Before Add Entry In Monitoring database
7/24/2022 7:31:28 AM : MainForm_Load  ### After Add Entry In Monitoring database
7/24/2022 7:31:28 AM : StartProcess for importing Closing stock file from ClosingStock folder  ### 7/24/2022 7:31:28 AM

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

7/24/2022 7:31:29 AM : Application Ended  ### 7/24/2022 7:31:29 AM

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

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

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

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

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

7/24/2022 2:30:02 PM : 11  ### 7/24/2022 2:30:02 PM

7/24/2022 2:30:02 PM : 22  ### 7/24/2022 2:30:02 PM

7/24/2022 2:30:02 PM : 33  ### 7/24/2022 2:30:02 PM

7/24/2022 2:30:02 PM : Application Started  ### 7/24/2022 2:30:02 PM

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

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

7/24/2022 2:30:30 PM : Application Ended  ### 7/24/2022 2:30:30 PM