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