8/21/2022 2:30:02 AM : Start Process : checkAllTablesExists() ### Start 8/21/2022 2:30:02 AM : StartProcess ### 8/21/2022 2:30:02 AM 8/21/2022 2:30:02 AM : Importing Running from Zylem App, Wait for some time. Value of BlockImportingProcess - 0 ### 8/21/2022 2:30:02 AM 8/21/2022 2:30:02 AM : Max No Of Retry In Minutes For WaitingState. MaxNoOfRetryInMinForWaitingState - 2 ### Expected waiting time is 8/21/2022 2:32:02 AM 8/21/2022 2:30:02 AM : Importing Running from Zylem App End. Value of BlockImportingProcess - 0 ### 8/21/2022 2:30:02 AM 8/21/2022 2:30:02 AM : Importing started from WinZylemImport exe. Updated Value of BlockImportingProcess - 1 in Settings table ### 8/21/2022 2:30:02 AM 8/21/2022 2:30:02 AM : 11 ### 8/21/2022 2:30:02 AM 8/21/2022 2:30:02 AM : 22 ### 8/21/2022 2:30:02 AM 8/21/2022 2:30:02 AM : 33 ### 8/21/2022 2:30:02 AM 8/21/2022 2:30:02 AM : Application Started ### 8/21/2022 2:30:02 AM 8/21/2022 2:30:02 AM : Start Process : checkAllTablesExists() ### Start 8/21/2022 2:30:02 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 8/21/2022 2:30:02 AM 8/21/2022 2:30:02 AM : MainForm_Load ### AlertSystem ON 8/21/2022 2:30:03 AM : No. of Files to import (RECEIVEFINAL): ### 1 8/21/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 8/21/2022 2:30:03 AM : PostData() --->> ### 8/21/2022 2:30:03 AM 8/21/2022 2:30:03 AM : SP_CreateUnkCustomerUnkItem Successful --->> ### 8/21/2022 2:30:03 AM 8/21/2022 2:30:03 AM : SupplierLink Successful --->> exec SP_SupplierLinkDiff '21/Aug/2022' ### 8/21/2022 2:30:03 AM 8/21/2022 2:30:04 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '21/Aug/2022' ### 8/21/2022 2:30:04 AM 8/21/2022 2:30:04 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '21/Aug/2022' ### 8/21/2022 2:30:04 AM 8/21/2022 2:30:04 AM : ### 8/21/2022 2:30:04 AM : UNLINKEDSALES Record Count Before --->> 0 ### 8/21/2022 2:30:04 AM 8/21/2022 2:30:04 AM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 8/21/2022 2:30:04 AM 8/21/2022 2:30:14 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '21/Aug/2022' ### 8/21/2022 2:30:14 AM 8/21/2022 2:30:14 AM : UNLINKEDSALES Record Count After --->> 0 ### 8/21/2022 2:30:14 AM 8/21/2022 2:30:14 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 8/21/2022 2:30:14 AM 8/21/2022 2:30:14 AM : ### 8/21/2022 2:30:20 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '21/Aug/2022' ### 8/21/2022 2:30:20 AM 8/21/2022 2:30:27 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '21/Aug/2022' ### 8/21/2022 2:30:27 AM 8/21/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-08-21 02:30:27','2022-08-21 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) ### 8/21/2022 2:30:27 AM 8/21/2022 2:30:27 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '21/Aug/2022' ### 8/21/2022 2:30:27 AM 8/21/2022 2:30:28 AM : Posting ClosingStock Successful --->> ### 8/21/2022 2:30:28 AM 8/21/2022 2:30:28 AM : FileWiseHashCode Updated for FlagImport=true records --->> ### 8/21/2022 2:30:28 AM 8/21/2022 2:30:28 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\ 8/21/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1015312_TEMPLATE1.TXT ### 8/21/2022 2:30:28 AM 8/21/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 8/21/2022 2:30:28 AM 8/21/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 8/21/2022 2:30:28 AM 8/21/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 8/21/2022 2:30:28 AM 8/21/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 8/21/2022 2:30:28 AM 8/21/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 8/21/2022 2:30:28 AM 8/21/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3559252_TEMPLATE1.TXT ### 8/21/2022 2:30:28 AM 8/21/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 8/21/2022 2:30:28 AM 8/21/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 8/21/2022 2:30:28 AM 8/21/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 8/21/2022 2:30:28 AM 8/21/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 2:30:28 AM : Error in file ### 20220803023539 at Line 295 8/21/2022 2:30:28 AM : Template Import Complete ### 8/21/2022 2:30:28 AM 8/21/2022 2:30:31 AM : Completed Updating Has Transaction Flag ### 8/21/2022 2:30:31 AM 8/21/2022 2:30:31 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 8/21/2022 2:30:31 AM 8/21/2022 2:30:31 AM : Zylem Access Unblocked ### 8/21/2022 2:30:31 AM 8/21/2022 2:30:31 AM : MainForm_Load ### Before Add Entry In Monitoring database 8/21/2022 2:30:31 AM : MainForm_Load ### After Add Entry In Monitoring database 8/21/2022 2:30:31 AM : StartProcess for importing Closing stock file from ClosingStock folder ### 8/21/2022 2:30:31 AM 8/21/2022 2:30:31 AM : Start Process : checkAllTablesExists() ### Start 8/21/2022 2:30:31 AM : Validation Start For All ### 8/21/2022 2:30:31 AM 8/21/2022 2:30:31 AM : Start Process : checkAllTablesExists() ### Start 8/21/2022 2:30:31 AM : BAYER_2155816_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/2022 2:30:31 AM : File Not Valid for Distributor ERPCode-2155816 ### BAYER_2155816_CLOSINGSTOCK.TXT 8/21/2022 2:30:31 AM : Start Process : checkAllTablesExists() ### Start 8/21/2022 2:30:31 AM : BAYER_3888864_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/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 ### 8/21/2022 2:30:31 AM : File Not Valid for Distributor ERPCode-3888864 ### BAYER_3888864_CLOSINGSTOCK.TXT 8/21/2022 2:30:31 AM : End Process for importing Closing stock file from ClosingStock folder End Time----------- ### 8/21/2022 2:30:31 AM 8/21/2022 2:30:31 AM : Importing ended from WinZylemImport exe. Updated Value of BlockImportingProcess - 0 in Settings table ### 8/21/2022 2:30:31 AM 8/21/2022 2:30:31 AM : Application Ended ### 8/21/2022 2:30:31 AM 8/21/2022 7:30:06 AM : Start Process : checkAllTablesExists() ### Start 8/21/2022 7:30:07 AM : StartProcess ### 8/21/2022 7:30:07 AM 8/21/2022 7:30:07 AM : Importing Running from Zylem App, Wait for some time. Value of BlockImportingProcess - 0 ### 8/21/2022 7:30:07 AM 8/21/2022 7:30:07 AM : Max No Of Retry In Minutes For WaitingState. MaxNoOfRetryInMinForWaitingState - 2 ### Expected waiting time is 8/21/2022 7:32:07 AM 8/21/2022 7:30:07 AM : Importing Running from Zylem App End. Value of BlockImportingProcess - 0 ### 8/21/2022 7:30:07 AM 8/21/2022 7:30:07 AM : Importing started from WinZylemImport exe. Updated Value of BlockImportingProcess - 1 in Settings table ### 8/21/2022 7:30:07 AM 8/21/2022 7:30:07 AM : 11 ### 8/21/2022 7:30:07 AM 8/21/2022 7:30:07 AM : 22 ### 8/21/2022 7:30:07 AM 8/21/2022 7:30:07 AM : 33 ### 8/21/2022 7:30:07 AM 8/21/2022 7:30:07 AM : Application Started ### 8/21/2022 7:30:07 AM 8/21/2022 7:30:07 AM : Start Process : checkAllTablesExists() ### Start 8/21/2022 7:30:07 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 8/21/2022 7:30:07 AM 8/21/2022 7:30:07 AM : MainForm_Load ### AlertSystem ON 8/21/2022 7:30:07 AM : No. of Files to import (RECEIVEFINAL): ### 288 8/21/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 8/21/2022 7:30:08 AM : For Distributor 000000000001026 Insert Count::2 ### Delete Count::0 8/21/2022 7:30:08 AM : Import AD File --->> AD_1026_20220821_d6b3b824f638f93450dc7bd1d0a6913c.TXT ### 8/21/2022 7:30:08 AM 8/21/2022 7:30:42 AM : For Distributor 000000000001026 Insert Count::0 ### Delete Count::1 8/21/2022 7:30:42 AM : Import IN File --->> IN_1026_20220817_f970081bf7236d9a5b45c62dcc0b8ead.TXT ### 8/21/2022 7:30:42 AM 8/21/2022 7:30:43 AM : For Distributor 000000000001026 Insert Count::0 ### Delete Count::1 8/21/2022 7:30:43 AM : Import IN File --->> IN_1026_20220818_0ecaed5654eba22604fb986601521073.TXT ### 8/21/2022 7:30:43 AM 8/21/2022 7:30:44 AM : For Distributor 000000000001026 Insert Count::5 ### Delete Count::0 8/21/2022 7:30:44 AM : Import IN File --->> IN_1026_20220819_51875ea9c8b15f539c839a8a1675d41d.TXT ### 8/21/2022 7:30:44 AM 8/21/2022 7:30:44 AM : For Distributor 000000000001026 Insert Count::14 ### Delete Count::0 8/21/2022 7:30:44 AM : Import IN File --->> IN_1026_20220820_3eb517404d9dc24158d4e693f1e7ea47.TXT ### 8/21/2022 7:30:44 AM 8/21/2022 7:30:44 AM : PostData() --->> ### 8/21/2022 7:30:44 AM 8/21/2022 7:30:45 AM : SP_CreateUnkCustomerUnkItem Successful --->> ### 8/21/2022 7:30:45 AM 8/21/2022 7:30:46 AM : SupplierLink Successful --->> exec SP_SupplierLinkDiff '21/Aug/2022' ### 8/21/2022 7:30:46 AM 8/21/2022 7:30:47 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '21/Aug/2022' ### 8/21/2022 7:30:47 AM 8/21/2022 7:30:48 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '21/Aug/2022' ### 8/21/2022 7:30:48 AM 8/21/2022 7:30:48 AM : ### 8/21/2022 7:30:48 AM : UNLINKEDSALES Record Count Before --->> 19 ### 8/21/2022 7:30:48 AM 8/21/2022 7:30:48 AM : UNLINKEDSALES_DEL Record Count Before --->> 2 ### 8/21/2022 7:30:48 AM 8/21/2022 7:31:04 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '21/Aug/2022' ### 8/21/2022 7:31:04 AM 8/21/2022 7:31:04 AM : UNLINKEDSALES Record Count After --->> 0 ### 8/21/2022 7:31:04 AM 8/21/2022 7:31:04 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 8/21/2022 7:31:04 AM 8/21/2022 7:31:04 AM : ### 8/21/2022 7:31:11 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '21/Aug/2022' ### 8/21/2022 7:31:11 AM 8/21/2022 7:31:18 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '21/Aug/2022' ### 8/21/2022 7:31:18 AM 8/21/2022 7:31:18 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-08-21 07:31:18','2022-08-21 07:31:18',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) ### 8/21/2022 7:31:18 AM 8/21/2022 7:31:18 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '21/Aug/2022' ### 8/21/2022 7:31:18 AM 8/21/2022 7:31:18 AM : Posting ClosingStock Successful --->> ### 8/21/2022 7:31:18 AM 8/21/2022 7:31:18 AM : FileWiseHashCode Updated for FlagImport=true records --->> ### 8/21/2022 7:31:18 AM 8/21/2022 7:31:18 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\ 8/21/2022 7:31:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1015312_TEMPLATE1.TXT ### 8/21/2022 7:31:18 AM 8/21/2022 7:31:18 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 7:31:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 8/21/2022 7:31:18 AM 8/21/2022 7:31:18 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 7:31:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 8/21/2022 7:31:18 AM 8/21/2022 7:31:18 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 7:31:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 8/21/2022 7:31:18 AM 8/21/2022 7:31:18 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 7:31:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 8/21/2022 7:31:18 AM 8/21/2022 7:31:18 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 7:31:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 8/21/2022 7:31:18 AM 8/21/2022 7:31:18 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 7:31:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3559252_TEMPLATE1.TXT ### 8/21/2022 7:31:18 AM 8/21/2022 7:31:18 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 7:31:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 8/21/2022 7:31:18 AM 8/21/2022 7:31:18 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 7:31:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 8/21/2022 7:31:18 AM 8/21/2022 7:31:19 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 7:31:19 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 8/21/2022 7:31:19 AM 8/21/2022 7:31:19 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 7:31:19 AM : Error in file ### 20220803023539 at Line 295 8/21/2022 7:31:19 AM : Template Import Complete ### 8/21/2022 7:31:19 AM 8/21/2022 7:31:21 AM : Completed Updating Has Transaction Flag ### 8/21/2022 7:31:21 AM 8/21/2022 7:31:21 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 8/21/2022 7:31:21 AM 8/21/2022 7:31:21 AM : Zylem Access Unblocked ### 8/21/2022 7:31:21 AM 8/21/2022 7:31:21 AM : MainForm_Load ### Before Add Entry In Monitoring database 8/21/2022 7:31:21 AM : MainForm_Load ### After Add Entry In Monitoring database 8/21/2022 7:31:21 AM : StartProcess for importing Closing stock file from ClosingStock folder ### 8/21/2022 7:31:21 AM 8/21/2022 7:31:21 AM : Start Process : checkAllTablesExists() ### Start 8/21/2022 7:31:22 AM : Validation Start For All ### 8/21/2022 7:31:22 AM 8/21/2022 7:31:22 AM : Start Process : checkAllTablesExists() ### Start 8/21/2022 7:31:22 AM : BAYER_2155816_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 1 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 2 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 3 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 4 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 5 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 6 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 7 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 8 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 9 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 10 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 11 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 12 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 13 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 14 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 15 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 16 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 17 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 18 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 19 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 20 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 21 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 22 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 23 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 24 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 25 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 26 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 27 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 28 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 29 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 30 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 31 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 32 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 33 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 34 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 35 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 36 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 37 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 38 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 39 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 40 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 41 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 42 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 43 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 44 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 45 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 46 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 47 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 48 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 49 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 50 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 51 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 52 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 53 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 54 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 55 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 56 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 57 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 58 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 59 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 60 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 61 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 62 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 63 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 64 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 65 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 66 ### 8/21/2022 7:31:22 AM : File Not Valid for Distributor ERPCode-2155816 ### BAYER_2155816_CLOSINGSTOCK.TXT 8/21/2022 7:31:22 AM : Start Process : checkAllTablesExists() ### Start 8/21/2022 7:31:22 AM : BAYER_3576162_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV 8/21/2022 7:31:22 AM : splitFileDaywiseNewNaming ### called 8/21/2022 7:31:22 AM : Start Process : checkAllTablesExists() ### Start 8/21/2022 7:31:22 AM : BAYER_3888864_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 1 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 2 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 3 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 4 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 5 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 6 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 7 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 8 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 9 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 10 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 11 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 12 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 13 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 14 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 15 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 16 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 17 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 18 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 19 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 20 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 21 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 22 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 23 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 24 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 25 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 26 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 27 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 28 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 29 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 30 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 31 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 32 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 33 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 34 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 35 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 36 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 37 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 38 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 39 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 40 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 41 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 42 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 43 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 44 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 45 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 46 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 47 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 48 ### 8/21/2022 7:31:22 AM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 49 ### 8/21/2022 7:31:22 AM : File Not Valid for Distributor ERPCode-3888864 ### BAYER_3888864_CLOSINGSTOCK.TXT 8/21/2022 7:31:22 AM : Import Start For All ### 8/21/2022 7:31:22 AM 8/21/2022 7:31:22 AM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 8/21/2022 7:31:22 AM : Procedure Name - exec prPostItemClosingStock ### 8/21/2022 7:31:22 AM 8/21/2022 7:31:22 AM : Posting Closing Stock Successful --->> ### 8/21/2022 7:31:22 AM 8/21/2022 7:31:22 AM : End Process for importing Closing stock file from ClosingStock folder End Time----------- ### 8/21/2022 7:31:22 AM 8/21/2022 7:31:22 AM : Importing ended from WinZylemImport exe. Updated Value of BlockImportingProcess - 0 in Settings table ### 8/21/2022 7:31:22 AM 8/21/2022 7:31:22 AM : Application Ended ### 8/21/2022 7:31:22 AM 8/21/2022 2:30:01 PM : Start Process : checkAllTablesExists() ### Start 8/21/2022 2:30:02 PM : StartProcess ### 8/21/2022 2:30:02 PM 8/21/2022 2:30:02 PM : Importing Running from Zylem App, Wait for some time. Value of BlockImportingProcess - 0 ### 8/21/2022 2:30:02 PM 8/21/2022 2:30:02 PM : Max No Of Retry In Minutes For WaitingState. MaxNoOfRetryInMinForWaitingState - 2 ### Expected waiting time is 8/21/2022 2:32:02 PM 8/21/2022 2:30:02 PM : Importing Running from Zylem App End. Value of BlockImportingProcess - 0 ### 8/21/2022 2:30:02 PM 8/21/2022 2:30:02 PM : Importing started from WinZylemImport exe. Updated Value of BlockImportingProcess - 1 in Settings table ### 8/21/2022 2:30:02 PM 8/21/2022 2:30:02 PM : 11 ### 8/21/2022 2:30:02 PM 8/21/2022 2:30:02 PM : 22 ### 8/21/2022 2:30:02 PM 8/21/2022 2:30:02 PM : 33 ### 8/21/2022 2:30:02 PM 8/21/2022 2:30:02 PM : Application Started ### 8/21/2022 2:30:02 PM 8/21/2022 2:30:02 PM : Start Process : checkAllTablesExists() ### Start 8/21/2022 2:30:02 PM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 8/21/2022 2:30:02 PM 8/21/2022 2:30:02 PM : MainForm_Load ### AlertSystem ON 8/21/2022 2:30:02 PM : No. of Files to import (RECEIVEFINAL): ### 122 8/21/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 8/21/2022 2:30:02 PM : For Distributor 000000000001317 Insert Count::1 ### Delete Count::0 8/21/2022 2:30:02 PM : Import AD File --->> AD_1317_20220821_57c419cabbb4b6a57c6f5f8d2344d89b.TXT ### 8/21/2022 2:30:02 PM 8/21/2022 2:30:04 PM : For Distributor 000000000001317 Insert Count::1 ### Delete Count::0 8/21/2022 2:30:04 PM : Import IN File --->> IN_1317_20220820_82535ebd664b71498364f6d8dee09c7c.TXT ### 8/21/2022 2:30:04 PM 8/21/2022 2:30:07 PM : PostData() --->> ### 8/21/2022 2:30:07 PM 8/21/2022 2:30:07 PM : SP_CreateUnkCustomerUnkItem Successful --->> ### 8/21/2022 2:30:07 PM 8/21/2022 2:30:08 PM : SupplierLink Successful --->> exec SP_SupplierLinkDiff '21/Aug/2022' ### 8/21/2022 2:30:08 PM 8/21/2022 2:30:09 PM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '21/Aug/2022' ### 8/21/2022 2:30:09 PM 8/21/2022 2:30:09 PM : ItemLink Successful --->> exec SP_ItemLinkDiff '21/Aug/2022' ### 8/21/2022 2:30:09 PM 8/21/2022 2:30:09 PM : ### 8/21/2022 2:30:09 PM : UNLINKEDSALES Record Count Before --->> 1 ### 8/21/2022 2:30:09 PM 8/21/2022 2:30:09 PM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 8/21/2022 2:30:09 PM 8/21/2022 2:30:19 PM : Posting Sales Successful --->> exec prPostLinkedDiffSales '21/Aug/2022' ### 8/21/2022 2:30:19 PM 8/21/2022 2:30:19 PM : UNLINKEDSALES Record Count After --->> 0 ### 8/21/2022 2:30:19 PM 8/21/2022 2:30:19 PM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 8/21/2022 2:30:19 PM 8/21/2022 2:30:19 PM : ### 8/21/2022 2:30:25 PM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '21/Aug/2022' ### 8/21/2022 2:30:25 PM 8/21/2022 2:30:33 PM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '21/Aug/2022' ### 8/21/2022 2:30:33 PM 8/21/2022 2:30:33 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-08-21 14:30:33','2022-08-21 14:30:33',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) ### 8/21/2022 2:30:33 PM 8/21/2022 2:30:33 PM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '21/Aug/2022' ### 8/21/2022 2:30:33 PM 8/21/2022 2:30:33 PM : Posting ClosingStock Successful --->> ### 8/21/2022 2:30:33 PM 8/21/2022 2:30:33 PM : FileWiseHashCode Updated for FlagImport=true records --->> ### 8/21/2022 2:30:33 PM 8/21/2022 2:30:33 PM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\ 8/21/2022 2:30:33 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1015312_TEMPLATE1.TXT ### 8/21/2022 2:30:33 PM 8/21/2022 2:30:33 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 2:30:33 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 8/21/2022 2:30:33 PM 8/21/2022 2:30:33 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 2:30:33 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 8/21/2022 2:30:33 PM 8/21/2022 2:30:33 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 2:30:33 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 8/21/2022 2:30:33 PM 8/21/2022 2:30:33 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 2:30:33 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 8/21/2022 2:30:33 PM 8/21/2022 2:30:33 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 2:30:33 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 8/21/2022 2:30:33 PM 8/21/2022 2:30:33 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 2:30:33 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3559252_TEMPLATE1.TXT ### 8/21/2022 2:30:33 PM 8/21/2022 2:30:33 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 2:30:33 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 8/21/2022 2:30:33 PM 8/21/2022 2:30:33 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 2:30:33 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 8/21/2022 2:30:33 PM 8/21/2022 2:30:33 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 2:30:33 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 8/21/2022 2:30:33 PM 8/21/2022 2:30:33 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 8/21/2022 2:30:33 PM : Error in file ### 20220803023539 at Line 295 8/21/2022 2:30:33 PM : Template Import Complete ### 8/21/2022 2:30:33 PM 8/21/2022 2:30:36 PM : Completed Updating Has Transaction Flag ### 8/21/2022 2:30:36 PM 8/21/2022 2:30:36 PM : Transaction Table lastEdiDate Update on BrandAlias Update ### 8/21/2022 2:30:36 PM 8/21/2022 2:30:36 PM : Zylem Access Unblocked ### 8/21/2022 2:30:36 PM 8/21/2022 2:30:36 PM : MainForm_Load ### Before Add Entry In Monitoring database 8/21/2022 2:30:36 PM : MainForm_Load ### After Add Entry In Monitoring database 8/21/2022 2:30:36 PM : StartProcess for importing Closing stock file from ClosingStock folder ### 8/21/2022 2:30:36 PM 8/21/2022 2:30:36 PM : Start Process : checkAllTablesExists() ### Start 8/21/2022 2:30:36 PM : Validation Start For All ### 8/21/2022 2:30:36 PM 8/21/2022 2:30:37 PM : Start Process : checkAllTablesExists() ### Start 8/21/2022 2:30:37 PM : BAYER_2155816_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 1 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 2 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 3 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 4 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 5 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 6 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 7 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 8 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 9 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 10 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 11 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 12 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 13 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 14 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 15 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 16 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 17 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 18 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 19 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 20 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 21 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 22 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 23 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 24 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 25 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 26 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 27 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 28 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 29 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 30 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 31 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 32 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 33 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 34 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 35 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 36 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 37 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 38 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 39 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 40 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 41 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 42 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 43 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 44 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 45 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 46 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 47 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 48 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 49 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 50 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 51 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 52 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 53 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 54 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 55 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 56 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 57 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 58 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 59 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 60 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 61 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 62 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 63 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 64 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 65 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_2155816_CLOSINGSTOCK.TXT at column=code : row= 66 ### 8/21/2022 2:30:37 PM : File Not Valid for Distributor ERPCode-2155816 ### BAYER_2155816_CLOSINGSTOCK.TXT 8/21/2022 2:30:37 PM : Start Process : checkAllTablesExists() ### Start 8/21/2022 2:30:37 PM : BAYER_3888864_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 1 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 2 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 3 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 4 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 5 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 6 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 7 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 8 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 9 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 10 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 11 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 12 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 13 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 14 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 15 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 16 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 17 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 18 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 19 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 20 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 21 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 22 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 23 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 24 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 25 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 26 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 27 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 28 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 29 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 30 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 31 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 32 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 33 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 34 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 35 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 36 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 37 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 38 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 39 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 40 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 41 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 42 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 43 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 44 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 45 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 46 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 47 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 48 ### 8/21/2022 2:30:37 PM : validate File - Invalid Date 6, not in expected format dd/MMM/yyyy in BAYER_3888864_CLOSINGSTOCK.TXT at column=code : row= 49 ### 8/21/2022 2:30:37 PM : File Not Valid for Distributor ERPCode-3888864 ### BAYER_3888864_CLOSINGSTOCK.TXT 8/21/2022 2:30:37 PM : Start Process : checkAllTablesExists() ### Start 8/21/2022 2:30:37 PM : BAYER_3985879_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV 8/21/2022 2:30:37 PM : splitFileDaywiseNewNaming ### called 8/21/2022 2:30:37 PM : Start Process : checkAllTablesExists() ### Start 8/21/2022 2:30:37 PM : BAYER_9064126_CLOSINGSTOCK.TXT, File Format Windows-1252 ### validateCLFileCSV 8/21/2022 2:30:37 PM : splitFileDaywiseNewNaming ### called 8/21/2022 2:30:37 PM : Import Start For All ### 8/21/2022 2:30:37 PM 8/21/2022 2:30:37 PM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 8/21/2022 2:30:37 PM : Procedure Name - exec prPostItemClosingStock ### 8/21/2022 2:30:37 PM 8/21/2022 2:30:37 PM : Posting Closing Stock Successful --->> ### 8/21/2022 2:30:37 PM 8/21/2022 2:30:37 PM : End Process for importing Closing stock file from ClosingStock folder End Time----------- ### 8/21/2022 2:30:37 PM 8/21/2022 2:30:37 PM : Importing ended from WinZylemImport exe. Updated Value of BlockImportingProcess - 0 in Settings table ### 8/21/2022 2:30:37 PM 8/21/2022 2:30:37 PM : Application Ended ### 8/21/2022 2:30:37 PM