5/30/2022 3:42:09 AM : Start Process : checkAllTablesExists()  ### Start
5/30/2022 6:12:15 AM : Start Process : checkAllTablesExists()  ### Start
5/30/2022 6:12:15 AM : Import Start Time (NEW) For Ajanta Trading(1960388) ### 5/30/2022 6:12:15 AM
5/30/2022 6:12:16 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
5/30/2022 6:12:16 AM : For Distributor 000000000000359 Insert Count::4 ### Delete Count::4
5/30/2022 6:12:16 AM : Import AD File --->> AD_359_20220530_e9a1ff5fc61e20cca881ff968b20c8e3.TXT ### 5/30/2022 6:12:16 AM
5/30/2022 6:12:16 AM : Exception  ### Access to the path 'D:\BAYER\Zylem\ZylemImportFolders\//BeforeImportBackup//30-May-2022//AD_359_20220504_32c23a62d3bd5a1d82ca827540a43f2f.TXT' is denied.
5/30/2022 6:12:16 AM : Error ### Access to the path 'D:\BAYER\Zylem\ZylemImportFolders\//BeforeImportBackup//30-May-2022//AD_359_20220504_32c23a62d3bd5a1d82ca827540a43f2f.TXT' is denied. Line 
5/30/2022 6:12:16 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
5/30/2022 6:12:16 AM : For Distributor 000000000000359 Insert Count::15 ### Delete Count::18
5/30/2022 6:12:16 AM : Import PR File --->> PR_359_20220530_6d109bf3d4514715e97c048049f74839.TXT ### 5/30/2022 6:12:16 AM
5/30/2022 6:12:16 AM : Exception  ### Access to the path 'D:\BAYER\Zylem\ZylemImportFolders\//BeforeImportBackup//30-May-2022//PR_359_20220504_8cb427af56d285bea590e66062753aab.TXT' is denied.
5/30/2022 6:12:16 AM : Error ### Access to the path 'D:\BAYER\Zylem\ZylemImportFolders\//BeforeImportBackup//30-May-2022//PR_359_20220504_8cb427af56d285bea590e66062753aab.TXT' is denied. Line 
5/30/2022 6:12:16 AM : Import Masters Completed Ajanta Trading(1960388) ### 5/30/2022 6:12:16 AM
5/30/2022 6:12:16 AM : Start Process : ImportSplittedFilesOldDeleteInsert()  ###  called 
5/30/2022 6:12:16 AM : splitFileDaywiseNewNaming  ###  called 
5/30/2022 6:12:16 AM : splitFileDaywiseNewNaming  ###  called 
5/30/2022 6:12:16 AM : splitFileDaywiseNewNaming  ###  called 
5/30/2022 6:12:16 AM : command:: ### Delete Unlinked IN
5/30/2022 6:12:16 AM : command:: ### Delete Unlinked IN
5/30/2022 6:12:16 AM : command:: ### Delete SPLITFILEINFO IN
5/30/2022 6:12:16 AM : Import IN File --->> IN_359_20210706_1ab5e48e91af2fe258bcd747d3316ffb.TXT ### 5/30/2022 6:12:16 AM
5/30/2022 6:12:16 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::6
5/30/2022 6:12:16 AM : Import IN File --->> IN_359_20210707_406fbe3a487baf4698d636ef3794b013.TXT ### 5/30/2022 6:12:16 AM
5/30/2022 6:12:16 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::18
5/30/2022 6:12:16 AM : Import IN File --->> IN_359_20210708_77907d115707f9c84ba2313b5858a630.TXT ### 5/30/2022 6:12:16 AM
5/30/2022 6:12:16 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::13
5/30/2022 6:12:16 AM : Import IN File --->> IN_359_20210709_b6ab8dd0f04e3d28ec6bcb5c8bd93396.TXT ### 5/30/2022 6:12:16 AM
5/30/2022 6:12:16 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::26
5/30/2022 6:12:16 AM : Import IN File --->> IN_359_20210710_7c0f0ed9f0ba744f5efdb4d420d9676b.TXT ### 5/30/2022 6:12:16 AM
5/30/2022 6:12:16 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::3
5/30/2022 6:12:16 AM : Import IN File --->> IN_359_20210712_36d71872b654971781e5f2d797d0e05d.TXT ### 5/30/2022 6:12:16 AM
5/30/2022 6:12:16 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::28
5/30/2022 6:12:17 AM : Import IN File --->> IN_359_20210714_bba48c48f5e835152a3319f9b17ada1f.TXT ### 5/30/2022 6:12:17 AM
5/30/2022 6:12:17 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::5
5/30/2022 6:12:17 AM : Import IN File --->> IN_359_20210716_77f9e36b8bf467c514d6bb3ceac27051.TXT ### 5/30/2022 6:12:17 AM
5/30/2022 6:12:17 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::24
5/30/2022 6:12:17 AM : Import IN File --->> IN_359_20210722_09919f041e6bb3776314f2d85a5d8411.TXT ### 5/30/2022 6:12:17 AM
5/30/2022 6:12:17 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::13
5/30/2022 6:12:17 AM : Import IN File --->> IN_359_20210728_a947eb26d823a10f262fca1cb31c3a30.TXT ### 5/30/2022 6:12:17 AM
5/30/2022 6:12:17 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::28
5/30/2022 6:12:17 AM : Import IN File --->> IN_359_20210729_671c3309a7ece21fb181e46e60d8732c.TXT ### 5/30/2022 6:12:17 AM
5/30/2022 6:12:17 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::6
5/30/2022 6:12:17 AM : Import IN File --->> IN_359_20210805_0eeb5ca33b7df5bfe663af03ee25092b.TXT ### 5/30/2022 6:12:17 AM
5/30/2022 6:12:17 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::1
5/30/2022 6:12:17 AM : Import IN File --->> IN_359_20210806_cee44192d6b4956160a01305a708ce8f.TXT ### 5/30/2022 6:12:17 AM
5/30/2022 6:12:17 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::9
5/30/2022 6:12:17 AM : Import IN File --->> IN_359_20210807_4de5b13472369afc4a4b6e3c59143490.TXT ### 5/30/2022 6:12:17 AM
5/30/2022 6:12:17 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::5
5/30/2022 6:12:17 AM : Import IN File --->> IN_359_20210809_365f58842603ac8b0d7d38bb973732f7.TXT ### 5/30/2022 6:12:17 AM
5/30/2022 6:12:17 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::12
5/30/2022 6:12:17 AM : Import IN File --->> IN_359_20210812_161a164d21e77c3071bda44d296d10e3.TXT ### 5/30/2022 6:12:17 AM
5/30/2022 6:12:17 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::27
5/30/2022 6:12:17 AM : Import IN File --->> IN_359_20210813_dc11b348c62b217840b3e83d1ec2bbb7.TXT ### 5/30/2022 6:12:17 AM
5/30/2022 6:12:17 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::31
5/30/2022 6:12:17 AM : Import IN File --->> IN_359_20210816_b3585ab14c74934bbd1abe3bccc95bbb.TXT ### 5/30/2022 6:12:17 AM
5/30/2022 6:12:17 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::10
5/30/2022 6:12:17 AM : Import IN File --->> IN_359_20210819_8244d1f3f1ff1a45a4dc8bcfccef9024.TXT ### 5/30/2022 6:12:17 AM
5/30/2022 6:12:17 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::16
5/30/2022 6:12:17 AM : Import IN File --->> IN_359_20210820_ca632529799136b5ae12b84ac0ef53e5.TXT ### 5/30/2022 6:12:17 AM
5/30/2022 6:12:17 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::2
5/30/2022 6:12:17 AM : Import IN File --->> IN_359_20210825_d1db9fe475ff1551f96048b61958ebab.TXT ### 5/30/2022 6:12:17 AM
5/30/2022 6:12:17 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::5
5/30/2022 6:12:17 AM : Import IN File --->> IN_359_20210827_4f6eeb69ea788722c3e106b09c5e3811.TXT ### 5/30/2022 6:12:17 AM
5/30/2022 6:12:17 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::8
5/30/2022 6:12:17 AM : Import IN File --->> IN_359_20210828_86523a448e404b6f11d759c8462048f6.TXT ### 5/30/2022 6:12:17 AM
5/30/2022 6:12:17 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::4
5/30/2022 6:12:17 AM : Import IN File --->> IN_359_20210831_2126e82794bc7b2bcc992f7d4079d101.TXT ### 5/30/2022 6:12:17 AM
5/30/2022 6:12:17 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::2
5/30/2022 6:12:17 AM : command:: flagImportPosting =  ### True
5/30/2022 6:12:17 AM : command:: minDate =  ### 7/6/2021 12:00:00 AM
5/30/2022 6:12:28 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 5/30/2022 6:12:28 AM
5/30/2022 6:12:29 AM : CustomerLink Diff Successful --->>  ### 5/30/2022 6:12:29 AM
5/30/2022 6:12:30 AM : ItemLink Diff Successful --->>  ### 5/30/2022 6:12:30 AM
5/30/2022 6:12:30 AM : Supplierlink Query Successful --->>  ### 5/30/2022 6:12:30 AM
5/30/2022 6:12:30 AM : Posting Purchases 'true' Successful --->>  ### 5/30/2022 6:12:30 AM
5/30/2022 6:12:30 AM : Posting OtherTransaction 'true' Successful --->>  ### 5/30/2022 6:12:30 AM
5/30/2022 6:55:39 AM : Posting Sales 'true' Successful --->>  ### 5/30/2022 6:55:39 AM
5/30/2022 6:55:42 AM : Completed Updating Has Transaction Flag  ### 5/30/2022 6:55:42 AM
5/30/2022 6:55:42 AM : command :: PostDataDeleteInsert  ###  Done 
5/30/2022 6:55:42 AM : command :: set DiffCutOffDate  ###  Done 
5/30/2022 6:55:42 AM : End Process : ImportSplittedFilesOldDeleteInsert()  ### 

5/30/2022 6:55:42 AM : Import End Time (NEW) Ajanta Trading(1960388) ### 5/30/2022 6:55:42 AM
5/30/2022 6:55:42 AM : -------------Import One Distributor End Time----------- ### 5/30/2022 6:55:42 AM
5/30/2022 7:30:01 AM : Start Process : checkAllTablesExists()  ### Driver={SQL Server};Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
5/30/2022 7:30:02 AM : StartProcess  ### 5/30/2022 7:30:02 AM

5/30/2022 7:30:02 AM : 11  ### 5/30/2022 7:30:02 AM

5/30/2022 7:30:02 AM : 22  ### 5/30/2022 7:30:02 AM

5/30/2022 7:30:02 AM : 33  ### 5/30/2022 7:30:02 AM

5/30/2022 7:30:02 AM : Application Started  ### 5/30/2022 7:30:02 AM

5/30/2022 7:30:02 AM : Start Process : checkAllTablesExists()  ### 
5/30/2022 7:30:02 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 5/30/2022 7:30:02 AM
5/30/2022 7:30:02 AM : MainForm_Load  ### AlertSystem ON
5/30/2022 7:30:02 AM : Exception  ### Access to the path 'D:\BAYER\Zylem\ZylemImportFolders\Inspected' is denied.

5/30/2022 4:16:53 PM : Start Process : checkAllTablesExists()  ### Start
5/30/2022 4:16:53 PM : Import Start Time (NEW) For Rahul Agencies(1015312) ### 5/30/2022 4:16:53 PM
5/30/2022 4:16:53 PM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
5/30/2022 4:16:53 PM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
5/30/2022 4:16:53 PM : Import Masters Completed Rahul Agencies(1015312) ### 5/30/2022 4:16:53 PM
5/30/2022 4:16:53 PM : Import BAYER_1015312_PURCHASE.TXT Start Time ### 5/30/2022 4:16:53 PM
5/30/2022 4:16:53 PM : command:: ### Delete Unlinked PURCHASE
5/30/2022 4:16:53 PM : command:: ### Delete Query Delete DistributorDeletePeriod where Distributorid='000000000000816' and FileType = 'PURCHASE'
5/30/2022 4:16:53 PM : command:: ### Insert Query insert into DistributorDeletePeriod values ('000000000000816','01/Sep/2021','26/Oct/2021','PURCHASE','false')
5/30/2022 4:16:53 PM : command:: ### Delete Unlinked PURCHASE
5/30/2022 4:16:54 PM : Count:: ### PURCHASE:73
5/30/2022 4:16:54 PM : Import BAYER_1015312_PURCHASE.TXT End Time ### 5/30/2022 4:16:54 PM
5/30/2022 4:16:54 PM : Import BAYER_1015312_SALE.TXT Start Time ### 5/30/2022 4:16:54 PM
5/30/2022 4:16:54 PM : command:: ### Delete Unlinked SALE
5/30/2022 4:16:54 PM : command:: ### Delete Query Delete DistributorDeletePeriod where Distributorid='000000000000816' and FileType = 'SALE'
5/30/2022 4:16:54 PM : command:: ### Insert Query insert into DistributorDeletePeriod values ('000000000000816','01/Sep/2021','30/Oct/2021','SALE','false')
5/30/2022 4:16:54 PM : command:: ### Delete Unlinked SALE
5/30/2022 4:17:03 PM : Count:: ### SALE:723
5/30/2022 4:17:03 PM : Import BAYER_1015312_SALE.TXT End Time ### 5/30/2022 4:17:03 PM
5/30/2022 4:17:03 PM : --------Import Linking from UI Start------- ### 5/30/2022 4:17:03 PM
5/30/2022 4:17:17 PM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 5/30/2022 4:17:17 PM
5/30/2022 4:17:18 PM : CustomerLink Diff Successful --->>  ### 5/30/2022 4:17:18 PM
5/30/2022 4:17:19 PM : ItemLink Diff Successful --->>  ### 5/30/2022 4:17:19 PM
5/30/2022 4:17:19 PM : Supplierlink Query Successful --->>  ### 5/30/2022 4:17:19 PM
5/30/2022 4:17:19 PM : Posting Purchases 'true' Successful --->>  ### 5/30/2022 4:17:19 PM
5/30/2022 4:17:20 PM : Posting OtherTransaction 'true' Successful --->>  ### 5/30/2022 4:17:20 PM
5/30/2022 7:10:59 PM : Posting Sales 'true' Successful --->>  ### 5/30/2022 7:10:59 PM
5/30/2022 7:11:02 PM : Completed Updating Has Transaction Flag  ### 5/30/2022 7:11:02 PM
5/30/2022 7:11:02 PM : --------Import Linking from UI End------- ### 5/30/2022 7:11:02 PM
5/30/2022 7:11:06 PM : Import End Time (NEW) Rahul Agencies(1015312) ### 5/30/2022 7:11:06 PM
5/30/2022 7:11:06 PM : -------------Import One Distributor End Time----------- ### 5/30/2022 7:11:06 PM