5/3/2022 2:30:04 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/3/2022 2:30:05 AM : StartProcess  ### 5/3/2022 2:30:05 AM

5/3/2022 2:30:05 AM : 11  ### 5/3/2022 2:30:05 AM

5/3/2022 2:30:05 AM : 22  ### 5/3/2022 2:30:05 AM

5/3/2022 2:30:05 AM : 33  ### 5/3/2022 2:30:05 AM

5/3/2022 2:30:05 AM : Application Started  ### 5/3/2022 2:30:05 AM

5/3/2022 2:30:05 AM : Start Process : checkAllTablesExists()  ### 
5/3/2022 2:30:05 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 5/3/2022 2:30:05 AM
5/3/2022 2:30:05 AM : MainForm_Load  ### AlertSystem ON
5/3/2022 2:30:06 AM : No. of Files to import (RECEIVEFINAL):  ### 1
5/3/2022 2:30:06 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
5/3/2022 2:30:06 AM : PostData() --->>  ### 5/3/2022 2:30:06 AM
5/3/2022 2:30:06 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 5/3/2022 2:30:06 AM
5/3/2022 2:30:06 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '03/May/2022' ### 5/3/2022 2:30:06 AM
5/3/2022 2:30:07 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '03/May/2022' ### 5/3/2022 2:30:07 AM
5/3/2022 2:30:07 AM :  ### 
5/3/2022 2:30:07 AM : UNLINKEDSALES Record Count Before --->> 0 ### 5/3/2022 2:30:07 AM
5/3/2022 2:30:07 AM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 5/3/2022 2:30:07 AM
5/3/2022 2:30:14 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '03/May/2022' ### 5/3/2022 2:30:14 AM
5/3/2022 2:30:14 AM : UNLINKEDSALES Record Count After --->> 0 ### 5/3/2022 2:30:14 AM
5/3/2022 2:30:14 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 5/3/2022 2:30:14 AM
5/3/2022 2:30:14 AM :  ### 
5/3/2022 2:30:14 AM : Posting Supplierlink Query for Purchases --->>  ### 5/3/2022 2:30:14 AM
5/3/2022 2:30:20 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '03/May/2022' ### 5/3/2022 2:30:20 AM
5/3/2022 2:30:27 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '03/May/2022' ### 5/3/2022 2:30:27 AM
5/3/2022 2:30:27 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 5/3/2022 2:30:27 AM
5/3/2022 2:30:27 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '03/May/2022' ### 5/3/2022 2:30:27 AM
5/3/2022 2:30:27 AM : Posting ClosingStock Successful --->>  ### 5/3/2022 2:30:27 AM
5/3/2022 2:30:27 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 5/3/2022 2:30:27 AM
5/3/2022 2:30:27 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
5/3/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 5/3/2022 2:30:27 AM
5/3/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 5/3/2022 2:30:27 AM
5/3/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 5/3/2022 2:30:27 AM
5/3/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 5/3/2022 2:30:27 AM
5/3/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 5/3/2022 2:30:28 AM
5/3/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 5/3/2022 2:30:28 AM
5/3/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 5/3/2022 2:30:28 AM
5/3/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 5/3/2022 2:30:28 AM
5/3/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 5/3/2022 2:30:28 AM
5/3/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 5/3/2022 2:30:28 AM
5/3/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 5/3/2022 2:30:28 AM
5/3/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 5/3/2022 2:30:28 AM
5/3/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 5/3/2022 2:30:28 AM
5/3/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 5/3/2022 2:30:28 AM
5/3/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 5/3/2022 2:30:28 AM
5/3/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 5/3/2022 2:30:28 AM
5/3/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 5/3/2022 2:30:28 AM
5/3/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_948223_TEMPLATE1.TXT ### 5/3/2022 2:30:28 AM
5/3/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 2:30:28 AM : Template Import Complete  ### 5/3/2022 2:30:28 AM
5/3/2022 2:30:31 AM : Completed Updating Has Transaction Flag  ### 5/3/2022 2:30:31 AM
5/3/2022 2:30:31 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 5/3/2022 2:30:31 AM
5/3/2022 2:30:31 AM : Zylem Access Unblocked  ### 5/3/2022 2:30:31 AM
5/3/2022 2:30:31 AM : Application Ended  ### 5/3/2022 2:30:31 AM

5/3/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/3/2022 7:30:02 AM : StartProcess  ### 5/3/2022 7:30:02 AM

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

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

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

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

5/3/2022 7:30:02 AM : Start Process : checkAllTablesExists()  ### 
5/3/2022 7:30:02 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 5/3/2022 7:30:02 AM
5/3/2022 7:30:02 AM : MainForm_Load  ### AlertSystem ON
5/3/2022 7:30:02 AM : No. of Files to import (RECEIVEFINAL):  ### 848
5/3/2022 7:30:02 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
5/3/2022 7:30:03 AM : For Distributor 000000000000011 Insert Count::4 ### Delete Count::0
5/3/2022 7:30:03 AM : Import AD File --->> AD_11_20220503_47240e8c61c582b82334024cd40acb47.TXT ### 5/3/2022 7:30:03 AM
5/3/2022 7:30:03 AM : For Distributor 000000000001313 Insert Count::12 ### Delete Count::3
5/3/2022 7:30:03 AM : Import AD File --->> AD_1313_20220503_b468f924e711681d3a2a878e765716db.TXT ### 5/3/2022 7:30:03 AM
5/3/2022 7:30:03 AM : For Distributor 000000000001325 Insert Count::3 ### Delete Count::3
5/3/2022 7:30:03 AM : Import AD File --->> AD_1325_20220503_a550e687a2b0ebb0eb8bc076048c3264.TXT ### 5/3/2022 7:30:03 AM
5/3/2022 7:30:04 AM : For Distributor 000000000000351 Insert Count::4 ### Delete Count::0
5/3/2022 7:30:04 AM : Import AD File --->> AD_351_20220503_80d1197ea0bba14154f0ea445684665f.TXT ### 5/3/2022 7:30:04 AM
5/3/2022 7:30:04 AM : For Distributor 000000000000366 Insert Count::4 ### Delete Count::0
5/3/2022 7:30:04 AM : Import AD File --->> AD_366_20220503_4cd10a936dee919c6e006a7b5017edd4.TXT ### 5/3/2022 7:30:04 AM
5/3/2022 7:30:04 AM : For Distributor 000000000000492 Insert Count::1 ### Delete Count::3
5/3/2022 7:30:04 AM : Import AD File --->> AD_492_20220503_23760224085c415bc25cd81255b2de54.TXT ### 5/3/2022 7:30:04 AM
5/3/2022 7:30:04 AM : For Distributor 000000000000810 Insert Count::6 ### Delete Count::0
5/3/2022 7:30:04 AM : Import AD File --->> AD_810_20220503_c64623c6d6edf867491a85caec3bdb4d.TXT ### 5/3/2022 7:30:04 AM
5/3/2022 7:30:05 AM : For Distributor 000000000000820 Insert Count::0 ### Delete Count::32
5/3/2022 7:30:05 AM : Import AD File --->> AD_820_20220503_8c50d3ef7efa531aff33fa8a0ecc8f11.TXT ### 5/3/2022 7:30:05 AM
5/3/2022 7:30:12 AM : Import DN File --->> DN_1313_20220429_d595d2ce9bbd176bf442d1ec5d088c02.TXT ### 5/3/2022 7:30:12 AM
5/3/2022 7:30:12 AM : NO Previous File For Distributor 000000000001313 ### Insert Count::1
5/3/2022 7:30:12 AM : Import DN File --->> DN_1313_20220430_1af2d8300fed47f6d01b9f005eabd47e.TXT ### 5/3/2022 7:30:12 AM
5/3/2022 7:30:12 AM : NO Previous File For Distributor 000000000001313 ### Insert Count::1
5/3/2022 7:30:13 AM : Import DN File --->> DN_1313_20220502_c57e1a54c56d09c3e307f75a5e73f3fa.TXT ### 5/3/2022 7:30:13 AM
5/3/2022 7:30:13 AM : NO Previous File For Distributor 000000000001313 ### Insert Count::3
5/3/2022 7:30:14 AM : Import DN File --->> DN_1325_20220427_4faf00e068abe50502f2252db11d3e10.TXT ### 5/3/2022 7:30:14 AM
5/3/2022 7:30:14 AM : NO Previous File For Distributor 000000000001325 ### Insert Count::2
5/3/2022 7:30:16 AM : For Distributor 000000000000351 Insert Count::1 ### Delete Count::0
5/3/2022 7:30:16 AM : Import DN File --->> DN_351_20220427_35a60d4f1a5c70ec2f648bb65408239f.TXT ### 5/3/2022 7:30:16 AM
5/3/2022 7:30:21 AM : Import DN File --->> DN_366_20220430_7922a0fcb65926ec2208b7f8a8082a8a.TXT ### 5/3/2022 7:30:21 AM
5/3/2022 7:30:21 AM : NO Previous File For Distributor 000000000000366 ### Insert Count::12
5/3/2022 7:30:30 AM : For Distributor 000000000000820 Insert Count::1 ### Delete Count::1
5/3/2022 7:30:30 AM : Import DN File --->> DN_820_20220414_9c5098a01912ca0578389b3ea33aa906.TXT ### 5/3/2022 7:30:30 AM
5/3/2022 7:30:30 AM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::2
5/3/2022 7:30:30 AM : Import DN File --->> DN_820_20220419_dfe44c5f4851ae2dd2ec8d8032887e2c.TXT ### 5/3/2022 7:30:30 AM
5/3/2022 7:30:30 AM : For Distributor 000000000000820 Insert Count::5 ### Delete Count::5
5/3/2022 7:30:30 AM : Import DN File --->> DN_820_20220420_08d933bd143a124127b63fc15cc57533.TXT ### 5/3/2022 7:30:30 AM
5/3/2022 7:30:31 AM : For Distributor 000000000000820 Insert Count::3 ### Delete Count::3
5/3/2022 7:30:31 AM : Import DN File --->> DN_820_20220425_357b94ab1508a01e174ac3e2b45f0436.TXT ### 5/3/2022 7:30:31 AM
5/3/2022 7:30:33 AM : For Distributor 000000000001026 Insert Count::0 ### Delete Count::1
5/3/2022 7:30:33 AM : Import IN File --->> IN_1026_20220428_43436b219dc8942cfaf175a68990f6ae.TXT ### 5/3/2022 7:30:33 AM
5/3/2022 7:30:33 AM : For Distributor 000000000001026 Insert Count::4 ### Delete Count::0
5/3/2022 7:30:33 AM : Import IN File --->> IN_1026_20220430_fed8bdc052d1678ee866940cdef41e65.TXT ### 5/3/2022 7:30:33 AM
5/3/2022 7:30:33 AM : For Distributor 000000000001026 Insert Count::5 ### Delete Count::0
5/3/2022 7:30:33 AM : Import IN File --->> IN_1026_20220501_45b02e41f7238e59c98919c5789a20fc.TXT ### 5/3/2022 7:30:33 AM
5/3/2022 7:30:34 AM : For Distributor 000000000001026 Insert Count::11 ### Delete Count::0
5/3/2022 7:30:34 AM : Import IN File --->> IN_1026_20220502_7f85e97ff00c4d4c9903312b866b305b.TXT ### 5/3/2022 7:30:34 AM
5/3/2022 7:30:34 AM : Import IN File --->> IN_1026_20220503_d92a67370f2bd21224856f5653d8b8b5.TXT ### 5/3/2022 7:30:34 AM
5/3/2022 7:30:34 AM : NO Previous File For Distributor 000000000001026 ### Insert Count::2
5/3/2022 7:30:36 AM : For Distributor 000000000000011 Insert Count::9 ### Delete Count::0
5/3/2022 7:30:36 AM : Import IN File --->> IN_11_20220502_92eb448bd7b2f0a85b58ad683c8a0aa1.TXT ### 5/3/2022 7:30:36 AM
5/3/2022 7:30:38 AM : For Distributor 000000000001313 Insert Count::17 ### Delete Count::0
5/3/2022 7:30:38 AM : Import IN File --->> IN_1313_20220428_59f345c61223bedc7054cb545d8c0fc1.TXT ### 5/3/2022 7:30:38 AM
5/3/2022 7:30:38 AM : Import IN File --->> IN_1313_20220429_33176072bdce153d5b2b169dd1c451c8.TXT ### 5/3/2022 7:30:38 AM
5/3/2022 7:30:38 AM : NO Previous File For Distributor 000000000001313 ### Insert Count::5
5/3/2022 7:30:38 AM : Import IN File --->> IN_1313_20220430_ce4f67a70404c60e8bf4789d6a6c4b81.TXT ### 5/3/2022 7:30:38 AM
5/3/2022 7:30:38 AM : NO Previous File For Distributor 000000000001313 ### Insert Count::4
5/3/2022 7:30:38 AM : Import IN File --->> IN_1313_20220502_7b790adcad8b0805fda96980e892264b.TXT ### 5/3/2022 7:30:38 AM
5/3/2022 7:30:38 AM : NO Previous File For Distributor 000000000001313 ### Insert Count::16
5/3/2022 7:30:38 AM : Import IN File --->> IN_1313_20220503_0f6b0cd112bb4b778e76fa62929429eb.TXT ### 5/3/2022 7:30:38 AM
5/3/2022 7:30:38 AM : NO Previous File For Distributor 000000000001313 ### Insert Count::3
5/3/2022 7:30:39 AM : Import IN File --->> IN_1325_20220422_920e62e75f477d198938228a1e26ea73.TXT ### 5/3/2022 7:30:39 AM
5/3/2022 7:30:39 AM : NO Previous File For Distributor 000000000001325 ### Insert Count::2
5/3/2022 7:30:39 AM : Import IN File --->> IN_1325_20220502_b4b32b0514b4b6492f6685145eb7b64b.TXT ### 5/3/2022 7:30:39 AM
5/3/2022 7:30:39 AM : NO Previous File For Distributor 000000000001325 ### Insert Count::1
5/3/2022 7:30:42 AM : For Distributor 000000000000351 Insert Count::2 ### Delete Count::0
5/3/2022 7:30:42 AM : Import IN File --->> IN_351_20220429_1692e8c34cacca9be86bc4dc8b91545f.TXT ### 5/3/2022 7:30:42 AM
5/3/2022 7:30:42 AM : For Distributor 000000000000351 Insert Count::1 ### Delete Count::0
5/3/2022 7:30:42 AM : Import IN File --->> IN_351_20220430_3f23eddd89751b3bed480e760a9cab8d.TXT ### 5/3/2022 7:30:42 AM
5/3/2022 7:30:46 AM : For Distributor 000000000000366 Insert Count::16 ### Delete Count::0
5/3/2022 7:30:46 AM : Import IN File --->> IN_366_20220502_785be93a7ea83b5483f4bd1c15cf3c17.TXT ### 5/3/2022 7:30:46 AM
5/3/2022 7:30:48 AM : Import IN File --->> IN_424_20220503_aa7550e5bb842d5dbae43435497352a7.TXT ### 5/3/2022 7:30:48 AM
5/3/2022 7:30:48 AM : NO Previous File For Distributor 000000000000424 ### Insert Count::1
5/3/2022 7:30:50 AM : Exception  ### Index was outside the bounds of the array.
5/3/2022 7:30:50 AM : Error ### Index was outside the bounds of the array. Line 
5/3/2022 7:30:51 AM : For Distributor 000000000000492 Insert Count::0 ### Delete Count::1
5/3/2022 7:30:51 AM : Import IN File --->> IN_492_20220421_32fbb23f548d8463526bbdde930bce0a.TXT ### 5/3/2022 7:30:51 AM
5/3/2022 7:30:52 AM : For Distributor 000000000000492 Insert Count::0 ### Delete Count::1
5/3/2022 7:30:52 AM : Import IN File --->> IN_492_20220422_b1a72c409e0afcd07fe79ea4a5bc7720.TXT ### 5/3/2022 7:30:52 AM
5/3/2022 7:30:53 AM : For Distributor 000000000000492 Insert Count::0 ### Delete Count::1
5/3/2022 7:30:53 AM : Import IN File --->> IN_492_20220427_4d19e53e9cd67533dfdb203e4ba98201.TXT ### 5/3/2022 7:30:53 AM
5/3/2022 7:30:54 AM : For Distributor 000000000000492 Insert Count::1 ### Delete Count::0
5/3/2022 7:30:54 AM : Import IN File --->> IN_492_20220430_f521535b887de689c5ab312cabe27fbf.TXT ### 5/3/2022 7:30:54 AM
5/3/2022 7:30:59 AM : For Distributor 000000000000810 Insert Count::7 ### Delete Count::0
5/3/2022 7:30:59 AM : Import IN File --->> IN_810_20220406_1133966191fe75d7e2fcbf52424fe962.TXT ### 5/3/2022 7:30:59 AM
5/3/2022 7:30:59 AM : For Distributor 000000000000810 Insert Count::12 ### Delete Count::0
5/3/2022 7:30:59 AM : Import IN File --->> IN_810_20220407_5869e6b7f7b80d7df9bb1275425ee111.TXT ### 5/3/2022 7:30:59 AM
5/3/2022 7:30:59 AM : For Distributor 000000000000810 Insert Count::8 ### Delete Count::0
5/3/2022 7:30:59 AM : Import IN File --->> IN_810_20220408_d58c58a2a58f98dc047b7590ad1e7198.TXT ### 5/3/2022 7:30:59 AM
5/3/2022 7:30:59 AM : For Distributor 000000000000810 Insert Count::4 ### Delete Count::0
5/3/2022 7:30:59 AM : Import IN File --->> IN_810_20220409_a0d7f90b401254e1425e87e1292954a3.TXT ### 5/3/2022 7:30:59 AM
5/3/2022 7:31:02 AM : For Distributor 000000000000820 Insert Count::15 ### Delete Count::15
5/3/2022 7:31:02 AM : Import IN File --->> IN_820_20220405_0ef26a57d313349cac7ef710eaf124fa.TXT ### 5/3/2022 7:31:02 AM
5/3/2022 7:31:02 AM : For Distributor 000000000000820 Insert Count::7 ### Delete Count::7
5/3/2022 7:31:02 AM : Import IN File --->> IN_820_20220406_1292677b48c492e0eaffa6ead383b58b.TXT ### 5/3/2022 7:31:02 AM
5/3/2022 7:31:02 AM : For Distributor 000000000000820 Insert Count::11 ### Delete Count::11
5/3/2022 7:31:02 AM : Import IN File --->> IN_820_20220407_8b1ace5543c045381ab150b4804c8d4c.TXT ### 5/3/2022 7:31:02 AM
5/3/2022 7:31:03 AM : For Distributor 000000000000820 Insert Count::8 ### Delete Count::8
5/3/2022 7:31:03 AM : Import IN File --->> IN_820_20220408_7eedca766144d58f2c665adbf158f39a.TXT ### 5/3/2022 7:31:03 AM
5/3/2022 7:31:03 AM : For Distributor 000000000000820 Insert Count::11 ### Delete Count::11
5/3/2022 7:31:03 AM : Import IN File --->> IN_820_20220409_307f4a6623ee380dcd2101d00879a2e3.TXT ### 5/3/2022 7:31:03 AM
5/3/2022 7:31:03 AM : For Distributor 000000000000820 Insert Count::6 ### Delete Count::6
5/3/2022 7:31:03 AM : Import IN File --->> IN_820_20220411_a06b0fa8204f1dd301d29cc0a7efd648.TXT ### 5/3/2022 7:31:03 AM
5/3/2022 7:31:04 AM : For Distributor 000000000000820 Insert Count::7 ### Delete Count::7
5/3/2022 7:31:04 AM : Import IN File --->> IN_820_20220412_82c5ef4f1afb0b33d13344d8294c1d3c.TXT ### 5/3/2022 7:31:04 AM
5/3/2022 7:31:04 AM : For Distributor 000000000000820 Insert Count::6 ### Delete Count::6
5/3/2022 7:31:04 AM : Import IN File --->> IN_820_20220414_505d28c485f096bdce96a46bc9502b29.TXT ### 5/3/2022 7:31:04 AM
5/3/2022 7:31:04 AM : For Distributor 000000000000820 Insert Count::6 ### Delete Count::6
5/3/2022 7:31:04 AM : Import IN File --->> IN_820_20220416_d0b642e57fe28b8bde48f8fc8de8f182.TXT ### 5/3/2022 7:31:04 AM
5/3/2022 7:31:04 AM : For Distributor 000000000000820 Insert Count::5 ### Delete Count::5
5/3/2022 7:31:04 AM : Import IN File --->> IN_820_20220418_2b2ead2b41e5ae5e90a02bf400cd7e77.TXT ### 5/3/2022 7:31:04 AM
5/3/2022 7:31:06 AM : For Distributor 000000000000820 Insert Count::8 ### Delete Count::8
5/3/2022 7:31:06 AM : Import IN File --->> IN_820_20220419_8684fcbacc962879bc39ac3354d5e97f.TXT ### 5/3/2022 7:31:06 AM
5/3/2022 7:31:06 AM : For Distributor 000000000000820 Insert Count::5 ### Delete Count::5
5/3/2022 7:31:06 AM : Import IN File --->> IN_820_20220420_e40eab813fcadb531a4f5e370e927d96.TXT ### 5/3/2022 7:31:06 AM
5/3/2022 7:31:06 AM : For Distributor 000000000000820 Insert Count::11 ### Delete Count::11
5/3/2022 7:31:06 AM : Import IN File --->> IN_820_20220421_4c5a4a1caa70fbb17847819c1f056513.TXT ### 5/3/2022 7:31:06 AM
5/3/2022 7:31:06 AM : For Distributor 000000000000820 Insert Count::14 ### Delete Count::14
5/3/2022 7:31:06 AM : Import IN File --->> IN_820_20220422_76bef8318066c81b47156fb096a11f09.TXT ### 5/3/2022 7:31:06 AM
5/3/2022 7:31:07 AM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::2
5/3/2022 7:31:07 AM : Import IN File --->> IN_820_20220423_551cfeed22c233edfcb0ec374cfef7eb.TXT ### 5/3/2022 7:31:07 AM
5/3/2022 7:31:08 AM : For Distributor 000000000000820 Insert Count::9 ### Delete Count::9
5/3/2022 7:31:08 AM : Import IN File --->> IN_820_20220425_b0aabf4cc04b77c1f720dff3547c3522.TXT ### 5/3/2022 7:31:08 AM
5/3/2022 7:31:08 AM : For Distributor 000000000000820 Insert Count::9 ### Delete Count::9
5/3/2022 7:31:08 AM : Import IN File --->> IN_820_20220426_646b051c8042ed8911db5c8ae1b06ed2.TXT ### 5/3/2022 7:31:08 AM
5/3/2022 7:31:08 AM : For Distributor 000000000000820 Insert Count::15 ### Delete Count::15
5/3/2022 7:31:08 AM : Import IN File --->> IN_820_20220427_51d64be6fc41faf7e2b0e897a5082c8d.TXT ### 5/3/2022 7:31:08 AM
5/3/2022 7:31:09 AM : For Distributor 000000000000820 Insert Count::3 ### Delete Count::3
5/3/2022 7:31:09 AM : Import IN File --->> IN_820_20220428_b79aa3c5f3a99a9f4cd9aeb620905bef.TXT ### 5/3/2022 7:31:09 AM
5/3/2022 7:31:09 AM : For Distributor 000000000000820 Insert Count::3 ### Delete Count::3
5/3/2022 7:31:09 AM : Import IN File --->> IN_820_20220429_d6828a49914651c83e5b08c053a5f5ec.TXT ### 5/3/2022 7:31:09 AM
5/3/2022 7:31:09 AM : For Distributor 000000000000820 Insert Count::13 ### Delete Count::13
5/3/2022 7:31:09 AM : Import IN File --->> IN_820_20220430_f0272e6372f65b9ecfb940f5fbbea3f2.TXT ### 5/3/2022 7:31:09 AM
5/3/2022 7:31:15 AM : For Distributor 000000000000820 Insert Count::4 ### Delete Count::4
5/3/2022 7:31:15 AM : Import OT File --->> OT_820_20220405_c290d97a918a6fb80df087b22ec88961.TXT ### 5/3/2022 7:31:15 AM
5/3/2022 7:31:16 AM : For Distributor 000000000000820 Insert Count::6 ### Delete Count::6
5/3/2022 7:31:16 AM : Import OT File --->> OT_820_20220408_2732e5155f9f8555eac787220de2041e.TXT ### 5/3/2022 7:31:16 AM
5/3/2022 7:31:17 AM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::2
5/3/2022 7:31:17 AM : Import OT File --->> OT_820_20220414_9bd30a2bcb707f505d236ebbccc05224.TXT ### 5/3/2022 7:31:17 AM
5/3/2022 7:31:17 AM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::2
5/3/2022 7:31:17 AM : Import OT File --->> OT_820_20220416_99dfdf5cb6af552a9bfac650d12b39b3.TXT ### 5/3/2022 7:31:17 AM
5/3/2022 7:31:17 AM : For Distributor 000000000000820 Insert Count::8 ### Delete Count::8
5/3/2022 7:31:17 AM : Import OT File --->> OT_820_20220418_7fa291def961e4f2d172e3de7a79ed8a.TXT ### 5/3/2022 7:31:17 AM
5/3/2022 7:31:17 AM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::2
5/3/2022 7:31:17 AM : Import OT File --->> OT_820_20220419_3fe9032da41caad64d689cc197614f68.TXT ### 5/3/2022 7:31:17 AM
5/3/2022 7:31:18 AM : For Distributor 000000000000820 Insert Count::6 ### Delete Count::6
5/3/2022 7:31:18 AM : Import OT File --->> OT_820_20220420_2d81e2da12d1e1bab2765bb70f0b94e9.TXT ### 5/3/2022 7:31:18 AM
5/3/2022 7:31:18 AM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::2
5/3/2022 7:31:18 AM : Import OT File --->> OT_820_20220421_20ce3188e78278c3818b067bd8e9eaa1.TXT ### 5/3/2022 7:31:18 AM
5/3/2022 7:31:19 AM : For Distributor 000000000000820 Insert Count::4 ### Delete Count::4
5/3/2022 7:31:19 AM : Import OT File --->> OT_820_20220426_50ddeb316f9afd9e5cd03b2a8ca207da.TXT ### 5/3/2022 7:31:19 AM
5/3/2022 7:31:19 AM : For Distributor 000000000000820 Insert Count::16 ### Delete Count::16
5/3/2022 7:31:19 AM : Import OT File --->> OT_820_20220427_6b2147d1ef6c8a49d3b9238448c252dd.TXT ### 5/3/2022 7:31:19 AM
5/3/2022 7:31:19 AM : For Distributor 000000000000820 Insert Count::8 ### Delete Count::0
5/3/2022 7:31:19 AM : Import OT File --->> OT_820_20220429_b573b5ec0e3cc16350026d218150f8fb.TXT ### 5/3/2022 7:31:19 AM
5/3/2022 7:31:20 AM : For Distributor 000000000000820 Insert Count::12 ### Delete Count::6
5/3/2022 7:31:20 AM : Import OT File --->> OT_820_20220430_bed2f70700554be7f74f344f1d1b3cd5.TXT ### 5/3/2022 7:31:20 AM
5/3/2022 7:31:20 AM : For Distributor 000000000001325 Insert Count::2 ### Delete Count::0
5/3/2022 7:31:20 AM : Import PR File --->> PR_1325_20220503_02f78688b415498dbab939d1dfd085d7.TXT ### 5/3/2022 7:31:20 AM
5/3/2022 7:31:21 AM : PostData() --->>  ### 5/3/2022 7:31:21 AM
5/3/2022 7:31:30 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 5/3/2022 7:31:30 AM
5/3/2022 7:31:35 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '03/May/2022' ### 5/3/2022 7:31:35 AM
5/3/2022 7:31:36 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '03/May/2022' ### 5/3/2022 7:31:36 AM
5/3/2022 7:31:36 AM :  ### 
5/3/2022 7:31:36 AM : UNLINKEDSALES Record Count Before --->> 305 ### 5/3/2022 7:31:36 AM
5/3/2022 7:31:36 AM : UNLINKEDSALES_DEL Record Count Before --->> 178 ### 5/3/2022 7:31:36 AM
5/3/2022 8:36:01 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '03/May/2022' ### 5/3/2022 8:36:01 AM
5/3/2022 8:36:01 AM : UNLINKEDSALES Record Count After --->> 0 ### 5/3/2022 8:36:01 AM
5/3/2022 8:36:01 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 5/3/2022 8:36:01 AM
5/3/2022 8:36:01 AM :  ### 
5/3/2022 8:36:01 AM : Posting Supplierlink Query for Purchases --->>  ### 5/3/2022 8:36:01 AM
5/3/2022 8:36:09 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '03/May/2022' ### 5/3/2022 8:36:09 AM
5/3/2022 8:36:17 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '03/May/2022' ### 5/3/2022 8:36:17 AM
5/3/2022 8:36:17 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 5/3/2022 8:36:17 AM
5/3/2022 8:36:17 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '03/May/2022' ### 5/3/2022 8:36:17 AM
5/3/2022 8:36:18 AM : Posting ClosingStock Successful --->>  ### 5/3/2022 8:36:18 AM
5/3/2022 8:36:18 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 5/3/2022 8:36:18 AM
5/3/2022 8:36:18 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
5/3/2022 8:36:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1224500_TEMPLATE1.TXT ### 5/3/2022 8:36:18 AM
5/3/2022 8:36:18 AM : Count:: ### TEMPLATE1:8
5/3/2022 8:36:18 AM : SP_DistributorTemplatePosting Successful --->>  ### 5/3/2022 8:36:18 AM
5/3/2022 8:36:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 5/3/2022 8:36:18 AM
5/3/2022 8:36:18 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 8:36:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 5/3/2022 8:36:18 AM
5/3/2022 8:36:18 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 8:36:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 5/3/2022 8:36:18 AM
5/3/2022 8:36:18 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 8:36:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 5/3/2022 8:36:18 AM
5/3/2022 8:36:18 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 8:36:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 5/3/2022 8:36:18 AM
5/3/2022 8:36:18 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 8:36:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2848065_TEMPLATE1.TXT ### 5/3/2022 8:36:18 AM
5/3/2022 8:36:18 AM : Count:: ### TEMPLATE1:48
5/3/2022 8:36:24 AM : SP_DistributorTemplatePosting Successful --->>  ### 5/3/2022 8:36:24 AM
5/3/2022 8:36:24 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3224985_TEMPLATE1.TXT ### 5/3/2022 8:36:24 AM
5/3/2022 8:36:24 AM : Count:: ### TEMPLATE1:106
5/3/2022 8:36:31 AM : SP_DistributorTemplatePosting Successful --->>  ### 5/3/2022 8:36:31 AM
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A101","A101","ASARPOTA CORPORATION","NR. SAMRATNAGARISHANPUR HIGHWAY CROSS ROAD|24ABIPS3595H1Z9|98240 75672|","AHMEDABAD","GUJARAT","0","98240 75672","","98240 75672","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1014","A1014","ALFA PEST CONTROL","201SAGAR COMPLEXB/H. SAWAN HOTELSARKHEJ-SANAND CROSS ROAD|24AMGPS0979N1ZD|99799 75500|","AHMEDABAD","GUJARAT","0","99799 75500","MAMTA SHAH  MILIND SHAH","99799 75500","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1036","A1036","MARUTI DOOR & PLY (GUJ) PVT LTD","54-AZAK INDUSTRIAL AREA PO-PARDHOL|24AACCM3234H1ZU|98259 27022|","DEHGAM","GUJARAT","0","98259 27022","ASHIVN SHAH","98259 27022","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A108","A108","SARTHI AGROCHEM","PLOT NO. 1306/5PHASE - IV GIDC|24AAXPP3368F2Z7|22820228|","AHMEDABAD","GUJARAT","382 330","22820228","RAJUBHAI PATEL","22820228","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1093","A1093","CURE PEST CONTROL","||78747 63032|","AHMEDABAD","GUJARAT","0","78747 63032","KAMLESH BHAI","78747 63032","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1146","A1146","KOMAL PEST CONTROL","A-407 ADITYA FLATNR. MRF SHOW ROOM|24AGHPV5586H1ZU|94265 25266|","AHMEDABAD","GUJARAT","380 022","94265 25266","JAGDISH BHAI","94265 25266","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1190","A1190","REAL LINE PEST MANAGMENT SERVICE","FF/5 SANJIVNI COMPLEXOPP. SRINAND NAGAR-1|24BBWPS4257B1ZD|97277 50920|","AHMEDABAD","GUJARAT","380051","97277 50920","NIKHILBHAI","97277 50920","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1268","A1268","GIS PEST MANAGMENT SERVICES","G-6 NAVKAR APPARTMENTNR. PALLAV CROSS ROAD|24AVAPM3971F1ZQ|84607 83084|","AHMEDABAD","GUJARAT","380 013","84607 83084","AMIT MECKWAN","84607 83084","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1340","A1340","PEST CONTROL SOLUTION","5/A ROYAL SHOPPING CENTERMODHERA ROAD|24AASFP0714E1ZG|99245 77395|","MEHSANA","GUJARAT","384 002","99245 77395","ANIMESH THAKKAR","99245 77395","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1342","A1342","RAJENDRA ROHIT","B-402 SHREEJI VANDAN B/H. AMBIKA NAGAR WATER TANK ROAD||96389 45728|","BARODA","GUJARAT","390021","96389 45728","RAJENDRA ROHIT","96389 45728","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1471","A1471","BITCO INTEGRATED PEST MANA. LLP","13 D-1302 SWATI GARDENIA NR. TORRENT POWER SUB STATION|24AAUFB4449A1ZK|78745 80175|","AHMEDABAD","GUJARAT","0","78745 80175","MITESH AGRAWAL JAYESH RATHOD","78745 80175","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1508","A1508","WELLKNOWN INDUSTRIES","SURVEY NO:108/109 MEGHAVI TIMBER MARKETNR. 66 KV SUB STATION KAMLA ROAD |24AAAFW3790R1ZI|93755 13310|","KHEDA","GUJARAT","387320","93755 13310","DINESH PATEL","93755 13310","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1520","A1520","YADAV AGRO CENTER","SHOP NO. 4 SAVASAR NAKANEAR SWAMINARAYAN CIRCLE|24BRJPK1951R1Z9|99130 03951|","KUTCH","GUJARAT","370 110","99130 03951","VIJAYBHAI & SUNILBHAI","99130 03951","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A154","A154","SAMIR JANI","F-3 CHANDRIKA PARK SOCIETYNR. JAYMALA BUS-STOP||98244 10373|","AHMEDABAD","GUJARAT","0","98244 10373","MR. SAMIRBHAI","98244 10373","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1547","A1547","ASIA PACIFIC PEST MANAGEMENT","201/A-1 L.B. PARK  NEAR TURNING POINT CIRCLE |24ABLFA7725J1Z8|93747 10718|","SURAT","GUJARAT","0","93747 10718","MANOJ BHAI TEJASBHAI JARIWALA","93747 10718","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1674","A1674","URBAN JUNGGLE PRIVATE LIMITED","C-302 INDRAPRASTH TOWERNR. HIMALAYA MALL|24AACCU4909M1Z3|90999 19323|","AHMEDABAD","GUJARAT","0","90999 19323","TEJAS PATEL","90999 19323","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line KRISHNA MANSION
5/3/2022 8:36:31 AM : Exception  ### Exception of type 'System.Exception' was thrown.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line GHEE BAZAAR
5/3/2022 8:36:31 AM : Exception  ### Exception of type 'System.Exception' was thrown.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line |24AKXPA1540L1Z3|98980 08767|","AHMEDABAD","GUJARAT","390002","98980 08767","SUSHILBHAI AGRAWAL","98980 08767","0","0"
5/3/2022 8:36:31 AM : Exception  ### Exception of type 'System.Exception' was thrown.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1750","A1750","GREEN PEST CONTROL","F.F. - 4  PARAMNEAR PUSHTY|24AATFG7159D1Z5|95103 94052|","BARODA","GUJARAT","391 410","95103 94052","MANISH PATEL","95103 94052","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1909","A1909","NEW 24 SEVEN PEST CONTROL","DARSHAN COMPLEXBOPAL-GHUMA ROAD||9608739328|","AHMEDABAD","GUJARAT","380 058","9608739328","DEEPAK KUMAR","9608739328","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A191","A191","REX ENVIRONMENT SCIENCE PVT LTD","B-503 & 504 TITANIUM HEIGHTSOPP. VODAFONE HOUSE|24AAECR3383G1ZF|9898 33 8888|","AHMEDABAD","GUJARAT","0","9898 33 8888","DHAVAL BHATI","9898 33 8888","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A1993","A1993","YAMRAJ.COM PRIVATE LIMITED","602 IVORY TERRACEOPP. CIRCUIT HOUSE R.C. DUTT ROAD|24AABCY1730F1ZQ|9825326936|","BARODA","GUJARAT","390007","9825326936","VIPUL SONI","9825326936","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2005","A2005","DNA PEST CONTROL TECHNOLOGIES","B-401 & 404 TIMES SQUARE-II BESIDE AVALON HOTEL OFF. SINDHUBHAVAN ROAD|24ALCPC1479J1ZA|74900 12344 |","AHMEDABAD","GUJARAT","0","74900 12344","PRADEEP LAL","74900 12344","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2011","A2011","THE 7 WAVES","OPP THE WATER SIDES.G HIGHWAY||9925856556|","AHMEDABAD","GUJARAT","0","9925856556","","9925856556","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2047","A2047","PRINCE PEST CONTROL","PLOT NO. 41 & 42/12B\H. ICE FACTORY||74054 09840|","HALOL","GUJARAT","389350","74054 09840","GIRISHBHAI","74054 09840","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2280","A2280","TATA PEST CONTROL","3 KADAMBARI SOCIETYNR. ASHAPURI MANDIR|24LGZPS8726F1ZC|76009 17565|","AHMEDABAD","GUJARAT","380 051","76009 17565","NARESHBHAI SUTARIYA","76009 17565","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A230","A230","H.P.C. CORPORATION","SECOND FLOOR SOPAN PALADIUMNR. METROPOLE HOTEL|24AACFH0765R1Z2|98250 31711|","AHMEDABAD","GUJARAT","0","98250 31711","JIGNESH TRIVEDI","98250 31711","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2311","A2311","SECURE SOLUTIONS","B/801 KAVERI TRISARANR. S.P. RING ROAD|24CNHPS7847D1ZO|9924099080|","AHMEDABAD","GUJARAT","0","9924099080","KRUNAL SHAH","9924099080","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2324","A2324","URBAN PEST CONTROL SERVICE","PLOT NO: 1608/S1 2ND FLOOR LABH COMPLEX |24AAGFU6566K1ZO|99245 01246(CHETANBHAI)|","GANDHINAGAR","GUJARAT","382006","99245 01246(CHETANBHAI)","CHETANBHAI","99245 01246(CHETANBHAI)","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2351","A2351","MODERN GRAMODYOG","BLOCK NO : 272 ZAK INDUSTRIAL AREA  VAHELAL - ZAK ROAD |24AHPPP5151P1ZO|97268 00570|","DEHGAM","GUJARAT","382330","97268 00570","HITESHBHAI (REF-N.K.SATPATHI ZAK)","97268 00570","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A236","A236","ITEM SECURE PVT LTD","601 & 602 IVORY TERRACER.C. DUTT ROAD OPP. CIRCUIT HOUSE|24AABCI8558F1ZI|98253 26936|","BARODA","GUJARAT","393 002","98253 26936","VIPUL SONI","98253 26936","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A239","A239","JALARAM FERTILISERS","NR. S.T.STANDDEHGAM ROAD|24AKGPP3890F1Z1|98257 02555|","AHMEDABAD","GUJARAT","0","98257 02555","","98257 02555","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2400","A2400","PESTOKIL INDIA","SHOP NO. 28 PLOT NO. 633FIRST FLOOR (OPP. HOTEL SLEEP INN.)|24EPOPR3432E1ZT|97253 60228|","GANDHINAGAR","GUJARAT","382421","97253 60228","PANKAJ YADAV","97253 60228","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2420","A2420","SAANVI PEST CONTROL","SHOP NO - 3 BUILDING NOB SAI SRUSHTI RESIDENCY|24EUXPP1878Q1Z9| 70690 75959|","VAPI","GUJARAT","396191","70690 75959","AJY BHAI PATEL","70690 75959","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2426","A2426","HANDY HOME SOLUTIONS PVT LTD","424 & 425 INDRAPRASTHA BUSINESS PARKMAKARBA|24AADCH5217L1ZM|87790 79753(SHAIL)|","AHMEDABAD","GUJARAT","380051","87790 79753(SHAIL)","","87790 79753(SHAIL)","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2468","A2468","MOTHER INDUSTRIES","BLOCK NO. 120ZAK - JALUNDRA ROAD|24AAUFM4776B1Z1|97268 00570|","DEHGAM","GUJARAT","382330","97268 00570","HITESHBHAI (REF. N K SATPATI)","97268 00570","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2645","A2645","SARASWATI PEST CONTROL","PLOT NO :238 SHOP NO: 06WARD NO: DC02||99787 03772|","GANDHIDHAM","GUJARAT","370201","99787 03772","VIVEK SAHANI","99787 03772","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A267","A267","NEW PATEL PEST CONTROL COMPANY","14 JIVAN PRAKASH SOC.NR.DARPAN SIX ROAD ||98250 19681|","AHMEDABAD","GUJARAT","0","98250 19681","PULIN PATEL","98250 19681","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2688","A2688","JAY YOGESHWAR PEST CONTROL","OPP. SARDAR MARKETKEVDABAUG||98240 59902|","BARODA","GUJARAT","0","98240 59902","YOGESHBHAI (JAY YOGESHWAR AGRO AGENCY)","98240 59902","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A270","A270","NILKANTH TRADERS","KRISHNA COMPLEXOPP. DHARA PETROL PUMP|24AATFN3046Q1ZL|99099 83028|","THOL","GUJARAT","0","99099 83028","ARVIND BHAI","99099 83028","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2741","A2741","ASIA PACIFIC PEST MANAGEMENT - BIHAR","POSTAL PARKROAD NO. 3A|10AWAPB1576E1ZD|70795 07048|","PATNA","BIHAR","800001","70795 07048","MANOJKUMAR BHAGAT","70795 07048","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2758","A2758","SHIVANI FINTRADE PVT.LTD.","KRISHNA HOUSE 8 D RAJHANS SOCIETYNEAR NABARD VIHAR HL COMMERCE COLLEGE|24AACCS1016M1ZL|98984 99935|","AHMEDABAD","GUJARAT","0","98984 99935","AMIT BHAI","98984 99935","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2823","A2823","AMERICAN PEST CONTROL","559/16 VRAJ NAGARI COMPLEXNR. TITANIUM CITY CENTRE||92652 55471|","AHMEDABAD","GUJARAT","380015","92652 55471","NILESH THAKOR","92652 55471","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2831","A2831","DEEP PEST MANAGEMENT PROFESSIONALS","7 GAUTAM COMPLEXNR SARASWATI COMPLEX BH HANS PARTY PLOT|24AMAPP7250P1ZO|95373 78484|","BARODA","GUJARAT","390011","95373 78484","MANISH PATEL","95373 78484","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2833","A2833","SHRI SAHJANAND SALES","||98243 02757|","GANDHINAGAR","GUJARAT","0","98243 02757","","98243 02757","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2839","A2839","KAILASH WOOD PRODUCT","R S NO:-815VILLAGE GHODASARNENPUR HALDARVAS ROAD|24AGSPL8912G2Z2|98252 30602|","MAHEMDABAD","GUJARAT","387110","98252 30602","NIRAV LIMABANI","98252 30602","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2850","A2850","PEST CONTROL ASSOCIATES (AMB) PVT LTD","ROOM NO. 4 3RD FLOOR7/10 BOTAWALA BUILDING|27AAFCP0260P1Z5|88793 35245|","MUMBAI","MAHARASTHRA","400 001","88793 35245","STEPHEN (VIREN MERCHANT MBI)","88793 35245","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A2851","A2851","KRUSHI VIKASH BHANDAR","8 GROUND FLOORSURAT TRADE HOUSE|24AACFK9237B2ZM|9898293670  |","SURAT","GUJARAT","395004","9898293670","JAYDEEP J KADIVAR","9898293670","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A302","A302","PESTOP SERVICES","9 SHILPI SOCIETYB\H. ARUNACHAL SOCIETY |24AAEFP8917F1Z7|98792 43434|","BARODA","GUJARAT","0","98792 43434","NILESH  BHAI","98792 43434","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A331","A331","THE AMDAVAD CO OP F & V UNION",""KHEDUT SABHA"SARDAR PATEL MARKET|24AAAJT0298H1Z0|25323719|","AHMEDABAD","GUJARAT","0","25323719","AMARATBHAI PATEL","25323719","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A340","A340","APNA SEEDS & PESTICIDES","16-17 SARDAR PATEL MARKETJAMALPUR CROSS ROAD|24ALLPP1535F1Z8|98250 57248|","AHMEDABAD","GUJARAT","0","98250 57248","DHARMESH BHAI","98250 57248","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A349","A349","EXCELLENT PEST CONTROL","8/9 SWAMINARAYAN GURUKUL SHOPNR. G.E. BOARD|24AELPC5017L1ZM|98253 80385|AELPC5017L","SIDDHPUR","GUJARAT","0","98253 80385","MR. SAVIN CHATURVEDI","98253 80385","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A352","A352","EXPERT PEST CONTROL","PLOT NO 58SURVEY NO. 39 RAVECHIDHAM 2|24AXOPP3902H1ZE|94291 23338|","ADIPUR","GUJARAT","370205","94291 23338","NILESH PARMAR","94291 23338","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A356","A356","GUJARAT PEST CONTROL SERVICE","405 ANAND MILAN COMPLEXOPP. JAIN TEMPLE|24AINPB3049F1ZL|98243 10043|","AHMEDABAD","GUJARAT","0","98243 10043","NITIN BHAI","98243 10043","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A387","A387","SRI SIDDHI VINAYAK ENTERPRISE","B-2 VINAYAK PARKB/H. SHAIWALI BUS-STOP|24ADNPB4820F1ZZ|94261 82943|","AHMEDABAD","GUJARAT","0","94261 82943","PRAVINBHAI","94261 82943","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A411","A411","THAKOR PEST CONTROL SERVICES PVT LTD","51 CELLARNIRAV COMPLEX||98250 05838|","AHMEDABAD","GUJARAT","0","98250 05838","MR. DINESHBHAI THAKOR","98250 05838","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A436","A436","SANTOSH PEST CONTROL","23 ARJUN TOWERNR. PAYAL PARTY PLOT||98258 70030|","AHMEDABAD","GUJARAT","0","98258 70030","HITESH PATEL","98258 70030","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A438","A438","BAYER CROPSCIENCE LIMITED","E/1-3 TIRUPATI ESTATEDASKROI TALUKA|24AAACB9651K1ZJ||AAACB9651K","AHMEDABAD","GUJARAT","0","","","","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A440","A440","KARNAVATI PEST CONTROL","FIRST FLOOR MAVDI COMPLEXNR. RAMJI MANDIR||99987 62498|","AHMEDABAD","GUJARAT","0","99987 62498","KARTIK PRAJAPATI","99987 62498","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A526","A526","VAMAKSHI CONSULTANCY & SERVICE","G - BLOCK TARA BAUGHINSIDE POLYTECHNIC||93741 04090|","BARODA","GUJARAT","390 002","93741 04090","DHARMESH PUJARI","93741 04090","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A579","A579","ORCHEED INDIA PEST MANAGEMENT PVT LTD","711 VANIJAYA BHAVANDIVAN BALLUBHAI MARG|24AACCO4336J1ZI|98984 17300|AACCO4336J","AHMEDABAD","GUJARAT","0","98984 17300","KALPESH KOSHIT","98984 17300","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A588","A588","S & P PEST CONTROL SERVICE","C - GF 31 VICTORY SUNRISENR. WATER TANK|24ATLPT8233G1ZD|98983 15571|","AHMEDABAD","GUJARAT","","98983 15571","PRANV TRIVEDI","98983 15571","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A619","A619","HARI OM PEST CONTROL","21 1ST FLOOR VASUDEV PLAZA NR. UMIYA MATA MANDIR|24CCYPR5535H1ZY|85302 50302|","AHMEDABAD","GUJARAT","380058","85302 50302","JHORAWAR SING","85302 50302","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A680","A680","HARIOM WOOD PRODUCTS","18/A VILAGE -ZAKZAK INDUSTRIAL AREA |24AABFH8405P1Z6|96872 47201|","DEHGAM","GUJARAT","382325","96872 47201","","96872 47201","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A717","A717","ABHIYAN DECORATIVE INDIA LLP","SURVEY NO. 357TALUKA : DEHGAM|24ABLFA1693H1ZE|99790 00557|","KADADARA","GUJARAT","0","99790 00557","","99790 00557","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A776","A776","ALL IN ONE HOSPITALITIES SERVICES","F/201 FIRST FLOOR ANMOL AAGMAN CO.OP.HOU SOCIETY |24AHIPY6781H2ZO|98986 55129|","AHMEDABAD","GUJARAT","382 481.","98986 55129","AJAY YARDI","98986 55129","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A867","A867","PESTCARE INDIA PVT LTD","215/2 GANESH PLAZANR. AJIT MILL CROSS ROAD|24AAJCP0707F1ZS|98989 55586|","AHMEDABAD","GUJARAT","0","98989 55586","ABRAR RAJPUT","98989 55586","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A880","A880","HOME PEST CONTROL","B-27 SECTOR - 4NANDIGRAM OPP. NOBLE NAGAR|24AUEPC5159L1ZL|94091 74870|","AHMEDABAD","GUJARAT","0","94091 74870","HITESH KANTIBHAI CHAUHAN","94091 74870","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A95","A95","SURTI PEST CONTROL SERVICE","514\D SHIROMANI COMPLEXOPP. OCEAN PARK|24AEKFS5119L1ZP|079 26760106|AOBPS7340N","AHMEDABAD","GUJARAT","0","079 26760106","DHAVALBHAI SURTI","079 26760106","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A963","A963","JALARAM TRADING CORPORATION","FF - 3 NAVNEETPARK SOCIETYNR. SARVANAND HALL|24AMKPP3952E1Z0|98791 43553|","BARODA","GUJARAT","390 022","98791 43553","SHAILESH PANCHAL","98791 43553","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Error in file  ### TEMPLATE1 at Line 000000000000011","A965","A965","ARYAN PEST MANAGEMENT","613 LOHA BHAVANOPP.OLD HIGH COURT|24AAXFA5820D1ZJ|98250 24936|","AHMEDABAD","GUJARAT","0","98250 24936","","98250 24936","0","0
5/3/2022 8:36:31 AM : Exception  ### Input array is longer than the number of columns in this table.
5/3/2022 8:36:31 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3228822_TEMPLATE1.txt ### 5/3/2022 8:36:31 AM
5/3/2022 8:36:31 AM : Count:: ### TEMPLATE1:1
5/3/2022 8:36:31 AM : SP_DistributorTemplatePosting Successful --->>  ### 5/3/2022 8:36:31 AM
5/3/2022 8:36:31 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 5/3/2022 8:36:31 AM
5/3/2022 8:36:31 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 8:36:31 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 5/3/2022 8:36:31 AM
5/3/2022 8:36:31 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 8:36:31 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 5/3/2022 8:36:31 AM
5/3/2022 8:36:31 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 8:36:31 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 5/3/2022 8:36:31 AM
5/3/2022 8:36:31 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 8:36:31 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3913537_TEMPLATE1.TXT ### 5/3/2022 8:36:31 AM
5/3/2022 8:36:31 AM : Count:: ### TEMPLATE1:87
5/3/2022 8:36:42 AM : SP_DistributorTemplatePosting Successful --->>  ### 5/3/2022 8:36:42 AM
5/3/2022 8:36:42 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3989239_TEMPLATE1.TXT ### 5/3/2022 8:36:42 AM
5/3/2022 8:36:42 AM : Count:: ### TEMPLATE1:196
5/3/2022 8:36:47 AM : SP_DistributorTemplatePosting Successful --->>  ### 5/3/2022 8:36:47 AM
5/3/2022 8:36:47 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 5/3/2022 8:36:47 AM
5/3/2022 8:36:47 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 8:36:47 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 5/3/2022 8:36:47 AM
5/3/2022 8:36:47 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 8:36:47 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 5/3/2022 8:36:47 AM
5/3/2022 8:36:47 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 8:36:47 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060893_TEMPLATE1.txt ### 5/3/2022 8:36:47 AM
5/3/2022 8:36:47 AM : Count:: ### TEMPLATE1:63
5/3/2022 8:36:56 AM : SP_DistributorTemplatePosting Successful --->>  ### 5/3/2022 8:36:56 AM
5/3/2022 8:36:56 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 5/3/2022 8:36:56 AM
5/3/2022 8:36:56 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 8:36:56 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 5/3/2022 8:36:56 AM
5/3/2022 8:36:56 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 8:36:56 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 5/3/2022 8:36:56 AM
5/3/2022 8:36:56 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 8:36:56 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062891_TEMPLATE1.TXT ### 5/3/2022 8:36:56 AM
5/3/2022 8:36:56 AM : Count:: ### TEMPLATE1:100
5/3/2022 8:37:02 AM : SP_DistributorTemplatePosting Successful --->>  ### 5/3/2022 8:37:02 AM
5/3/2022 8:37:02 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 5/3/2022 8:37:02 AM
5/3/2022 8:37:02 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 8:37:02 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 5/3/2022 8:37:02 AM
5/3/2022 8:37:02 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 8:37:02 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9064126_TEMPLATE1.txt ### 5/3/2022 8:37:02 AM
5/3/2022 8:37:02 AM : Count:: ### TEMPLATE1:2
5/3/2022 8:37:02 AM : SP_DistributorTemplatePosting Successful --->>  ### 5/3/2022 8:37:02 AM
5/3/2022 8:37:03 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067109_TEMPLATE1.TXT ### 5/3/2022 8:37:03 AM
5/3/2022 8:37:03 AM : Count:: ### TEMPLATE1:42
5/3/2022 8:37:08 AM : SP_DistributorTemplatePosting Successful --->>  ### 5/3/2022 8:37:08 AM
5/3/2022 8:37:08 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067110_TEMPLATE1.TXT ### 5/3/2022 8:37:08 AM
5/3/2022 8:37:08 AM : Count:: ### TEMPLATE1:22
5/3/2022 8:37:08 AM : SP_DistributorTemplatePosting Successful --->>  ### 5/3/2022 8:37:08 AM
5/3/2022 8:37:08 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067123_TEMPLATE1.txt ### 5/3/2022 8:37:08 AM
5/3/2022 8:37:08 AM : Count:: ### TEMPLATE1:26
5/3/2022 8:37:12 AM : SP_DistributorTemplatePosting Successful --->>  ### 5/3/2022 8:37:12 AM
5/3/2022 8:37:12 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_948223_TEMPLATE1.TXT ### 5/3/2022 8:37:12 AM
5/3/2022 8:37:12 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 8:37:12 AM : Template Import Complete  ### 5/3/2022 8:37:12 AM
5/3/2022 8:37:15 AM : Completed Updating Has Transaction Flag  ### 5/3/2022 8:37:15 AM
5/3/2022 8:37:15 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 5/3/2022 8:37:15 AM
5/3/2022 8:37:15 AM : Zylem Access Unblocked  ### 5/3/2022 8:37:15 AM
5/3/2022 8:37:15 AM : Application Ended  ### 5/3/2022 8:37:15 AM

5/3/2022 10:13:53 AM : Start Process : checkAllTablesExists()  ### Start
5/3/2022 10:13:53 AM : Import Start Time (NEW) For Ag Build Pest Control Services(3927669) ### 5/3/2022 10:13:53 AM
5/3/2022 10:13:53 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
5/3/2022 10:13:53 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
5/3/2022 10:13:53 AM : Import Masters Completed Ag Build Pest Control Services(3927669) ### 5/3/2022 10:13:53 AM
5/3/2022 10:13:53 AM : Start Process : ImportSplittedFilesOldDeleteInsert()  ###  called 
5/3/2022 10:13:53 AM : splitFileDaywiseNewNaming  ###  called 
5/3/2022 10:13:53 AM : splitFileDaywiseNewNaming  ###  called 
5/3/2022 10:13:53 AM : splitFileDaywiseNewNaming  ###  called 
5/3/2022 10:13:54 AM : command:: ### Delete Unlinked IN
5/3/2022 10:13:54 AM : command:: ### Delete Unlinked IN
5/3/2022 10:13:54 AM : command:: ### Delete SPLITFILEINFO IN
5/3/2022 10:13:54 AM : Import IN File --->> IN_1327_20210109_546843851e73e8eda0c00babe2069eaa.TXT ### 5/3/2022 10:13:54 AM
5/3/2022 10:13:54 AM : NO Previous File For Distributor 000000000001327 ### Insert Count::2
5/3/2022 10:13:55 AM : Import IN File --->> IN_1327_20210303_2fda6f596e438848016a01cfbf8d517b.TXT ### 5/3/2022 10:13:55 AM
5/3/2022 10:13:55 AM : NO Previous File For Distributor 000000000001327 ### Insert Count::3
5/3/2022 10:13:55 AM : Import IN File --->> IN_1327_20210504_db06a5df56f5773fe12384a861b778a3.TXT ### 5/3/2022 10:13:55 AM
5/3/2022 10:13:55 AM : NO Previous File For Distributor 000000000001327 ### Insert Count::1
5/3/2022 10:13:55 AM : Import IN File --->> IN_1327_20210610_eb29843d5ea54a26496f406a665d15de.TXT ### 5/3/2022 10:13:55 AM
5/3/2022 10:13:56 AM : NO Previous File For Distributor 000000000001327 ### Insert Count::1
5/3/2022 10:13:56 AM : Import IN File --->> IN_1327_20210717_4925609895b8fe9db7cc2ae2e46810d9.TXT ### 5/3/2022 10:13:56 AM
5/3/2022 10:13:56 AM : NO Previous File For Distributor 000000000001327 ### Insert Count::4
5/3/2022 10:13:56 AM : Import IN File --->> IN_1327_20210807_1fc9abac45748e640e76e7ee3e8276fe.TXT ### 5/3/2022 10:13:56 AM
5/3/2022 10:13:56 AM : NO Previous File For Distributor 000000000001327 ### Insert Count::1
5/3/2022 10:13:56 AM : Import IN File --->> IN_1327_20210817_f62ec33bb192579f5af55f8f9b74ed4c.TXT ### 5/3/2022 10:13:56 AM
5/3/2022 10:13:56 AM : NO Previous File For Distributor 000000000001327 ### Insert Count::1
5/3/2022 10:13:56 AM : Import IN File --->> IN_1327_20210827_1aaeb4b6023c320b0cdadb9c5b8c9cd5.TXT ### 5/3/2022 10:13:56 AM
5/3/2022 10:13:56 AM : NO Previous File For Distributor 000000000001327 ### Insert Count::1
5/3/2022 10:13:56 AM : Import IN File --->> IN_1327_20210829_2c3f4fc49e2ae3449f44462b5264a374.TXT ### 5/3/2022 10:13:56 AM
5/3/2022 10:13:56 AM : NO Previous File For Distributor 000000000001327 ### Insert Count::1
5/3/2022 10:13:56 AM : Import IN File --->> IN_1327_20210901_455162f7b4babd4fa7092129a532ccc2.TXT ### 5/3/2022 10:13:56 AM
5/3/2022 10:13:56 AM : NO Previous File For Distributor 000000000001327 ### Insert Count::4
5/3/2022 10:13:57 AM : Import IN File --->> IN_1327_20210922_d86cfcce5ad6799a21a1a12ce0583496.TXT ### 5/3/2022 10:13:57 AM
5/3/2022 10:13:57 AM : NO Previous File For Distributor 000000000001327 ### Insert Count::1
5/3/2022 10:13:57 AM : Import IN File --->> IN_1327_20211021_86ce38502e6f2f94eca18ce877208ae9.TXT ### 5/3/2022 10:13:57 AM
5/3/2022 10:13:57 AM : NO Previous File For Distributor 000000000001327 ### Insert Count::1
5/3/2022 10:13:57 AM : Import IN File --->> IN_1327_20211026_b5ad9d73b78ec4bf99f1f811555db3b9.TXT ### 5/3/2022 10:13:57 AM
5/3/2022 10:13:57 AM : NO Previous File For Distributor 000000000001327 ### Insert Count::2
5/3/2022 10:13:57 AM : Import IN File --->> IN_1327_20211112_cfe81fa534a31689606ad35dc33f271e.TXT ### 5/3/2022 10:13:57 AM
5/3/2022 10:13:57 AM : NO Previous File For Distributor 000000000001327 ### Insert Count::1
5/3/2022 10:13:57 AM : Import IN File --->> IN_1327_20211115_7a8645c6aa6d6abaf0989144f5ef7f9e.TXT ### 5/3/2022 10:13:57 AM
5/3/2022 10:13:57 AM : NO Previous File For Distributor 000000000001327 ### Insert Count::1
5/3/2022 10:13:57 AM : Import IN File --->> IN_1327_20211116_e70a9d1193191e1fbb22424819546175.TXT ### 5/3/2022 10:13:57 AM
5/3/2022 10:13:57 AM : NO Previous File For Distributor 000000000001327 ### Insert Count::1
5/3/2022 10:13:57 AM : command:: flagImportPosting =  ### True
5/3/2022 10:13:57 AM : command:: minDate =  ### 1/9/2021 12:00:00 AM
5/3/2022 10:13:58 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 5/3/2022 10:13:58 AM
5/3/2022 10:13:59 AM : CustomerLink Diff Successful --->>  ### 5/3/2022 10:13:59 AM
5/3/2022 10:13:59 AM : ItemLink Diff Successful --->>  ### 5/3/2022 10:13:59 AM
5/3/2022 10:13:59 AM : Supplierlink Query Successful --->>  ### 5/3/2022 10:13:59 AM
5/3/2022 10:14:00 AM : Posting Purchases 'true' Successful --->>  ### 5/3/2022 10:14:00 AM
5/3/2022 10:14:00 AM : Posting OtherTransaction 'true' Successful --->>  ### 5/3/2022 10:14:00 AM
5/3/2022 10:14:05 AM : Posting Sales 'true' Successful --->>  ### 5/3/2022 10:14:05 AM
5/3/2022 10:14:08 AM : Completed Updating Has Transaction Flag  ### 5/3/2022 10:14:08 AM
5/3/2022 10:14:08 AM : command :: PostDataDeleteInsert  ###  Done 
5/3/2022 10:14:08 AM : command :: set DiffCutOffDate  ###  Done 
5/3/2022 10:14:08 AM : End Process : ImportSplittedFilesOldDeleteInsert()  ### 

5/3/2022 10:14:08 AM : Import End Time (NEW) Ag Build Pest Control Services(3927669) ### 5/3/2022 10:14:08 AM
5/3/2022 10:14:08 AM : -------------Import One Distributor End Time----------- ### 5/3/2022 10:14:08 AM
5/3/2022 10:30:19 AM : Start Process : checkAllTablesExists()  ### Start
5/3/2022 10:30:19 AM : Import Start Time (NEW) For Awadh Krishi Kendra(9062642) ### 5/3/2022 10:30:19 AM
5/3/2022 10:30:19 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
5/3/2022 10:30:19 AM : For Distributor 000000000000365 Insert Count::53 ### Delete Count::7
5/3/2022 10:30:19 AM : Import AD File --->> AD_365_20220503_6eba750553982ab515996660a8a0d79f.TXT ### 5/3/2022 10:30:19 AM
5/3/2022 10:30:20 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
5/3/2022 10:30:20 AM : For Distributor 000000000000365 Insert Count::1 ### Delete Count::0
5/3/2022 10:30:20 AM : Import PR File --->> PR_365_20220503_61628caf0cfdba408cd3b7af91c5ef14.TXT ### 5/3/2022 10:30:20 AM
5/3/2022 10:30:20 AM : Import Masters Completed Awadh Krishi Kendra(9062642) ### 5/3/2022 10:30:20 AM
5/3/2022 10:30:20 AM : Start Process : ImportSplittedFilesOldDeleteInsert()  ###  called 
5/3/2022 10:30:20 AM : splitFileDaywiseNewNaming  ###  called 
5/3/2022 10:30:20 AM : splitFileDaywiseNewNaming  ###  called 
5/3/2022 10:30:20 AM : command:: ### Delete Unlinked DN
5/3/2022 10:30:20 AM : command:: ### Delete Unlinked DN
5/3/2022 10:30:20 AM : command:: ### Delete SPLITFILEINFO DN
5/3/2022 10:30:20 AM : Import DN File --->> DN_365_20220407_e107ddf008f18142c4ce5fd71c28d338.TXT ### 5/3/2022 10:30:20 AM
5/3/2022 10:30:20 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 10:30:20 AM : Import DN File --->> DN_365_20220416_7eddc454711cb6ecab9d3fd6f9f494f5.TXT ### 5/3/2022 10:30:20 AM
5/3/2022 10:30:20 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 10:30:20 AM : Import DN File --->> DN_365_20220426_936aa78c342d4bf0fa5a4598768e663c.TXT ### 5/3/2022 10:30:20 AM
5/3/2022 10:30:20 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 10:30:20 AM : Import DN File --->> DN_365_20220427_05239fdee643cdff27a4f8b9f9beccd9.TXT ### 5/3/2022 10:30:20 AM
5/3/2022 10:30:20 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 10:30:20 AM : command:: flagImportPosting =  ### True
5/3/2022 10:30:20 AM : command:: minDate =  ### 4/1/2022 12:00:00 AM
5/3/2022 10:30:20 AM : splitFileDaywiseNewNaming  ###  called 
5/3/2022 10:30:20 AM : command:: ### Delete Unlinked IN
5/3/2022 10:30:20 AM : command:: ### Delete Unlinked IN
5/3/2022 10:30:20 AM : command:: ### Delete SPLITFILEINFO IN
5/3/2022 10:30:21 AM : Import IN File --->> IN_365_20220404_4002eec264e4b1700efa7fee748c21a5.TXT ### 5/3/2022 10:30:21 AM
5/3/2022 10:30:21 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 10:30:21 AM : Import IN File --->> IN_365_20220405_d6b5e5d8f5727d89ad9349f863c67e97.TXT ### 5/3/2022 10:30:21 AM
5/3/2022 10:30:21 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 10:30:21 AM : Import IN File --->> IN_365_20220407_ccb9ce9624e588852f23fbd83fea72b3.TXT ### 5/3/2022 10:30:21 AM
5/3/2022 10:30:21 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 10:30:21 AM : Import IN File --->> IN_365_20220408_b9af1570861bf02e3b2f28ac2ad28761.TXT ### 5/3/2022 10:30:21 AM
5/3/2022 10:30:21 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 10:30:21 AM : Import IN File --->> IN_365_20220414_00278a7c3de834e4df7fe55eaa0ecb33.TXT ### 5/3/2022 10:30:21 AM
5/3/2022 10:30:21 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 10:30:21 AM : Import IN File --->> IN_365_20220421_fd4743c87d0d3221b2f3730b41a332ba.TXT ### 5/3/2022 10:30:21 AM
5/3/2022 10:30:21 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::5
5/3/2022 10:30:21 AM : Import IN File --->> IN_365_20220427_1008122fbe7ed8d38a5cb2885d99087e.TXT ### 5/3/2022 10:30:21 AM
5/3/2022 10:30:21 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 10:30:21 AM : Import IN File --->> IN_365_20220429_8b4754e0923c3d8e809743b79788c6ac.TXT ### 5/3/2022 10:30:21 AM
5/3/2022 10:30:21 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::5
5/3/2022 10:30:21 AM : command:: flagImportPosting =  ### True
5/3/2022 10:30:21 AM : command:: minDate =  ### 4/1/2022 12:00:00 AM
5/3/2022 10:30:22 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 5/3/2022 10:30:22 AM
5/3/2022 10:30:23 AM : CustomerLink Diff Successful --->>  ### 5/3/2022 10:30:23 AM
5/3/2022 10:30:23 AM : ItemLink Diff Successful --->>  ### 5/3/2022 10:30:23 AM
5/3/2022 10:30:23 AM : Supplierlink Query Successful --->>  ### 5/3/2022 10:30:23 AM
5/3/2022 10:30:24 AM : Posting Purchases 'true' Successful --->>  ### 5/3/2022 10:30:24 AM
5/3/2022 10:30:24 AM : Posting OtherTransaction 'true' Successful --->>  ### 5/3/2022 10:30:24 AM
5/3/2022 11:06:00 AM : Posting Sales 'true' Successful --->>  ### 5/3/2022 11:06:00 AM
5/3/2022 11:06:02 AM : Completed Updating Has Transaction Flag  ### 5/3/2022 11:06:02 AM
5/3/2022 11:06:02 AM : command :: PostDataDeleteInsert  ###  Done 
5/3/2022 11:06:02 AM : command :: set DiffCutOffDate  ###  Done 
5/3/2022 11:06:02 AM : End Process : ImportSplittedFilesOldDeleteInsert()  ### 

5/3/2022 11:06:02 AM : Import End Time (NEW) Awadh Krishi Kendra(9062642) ### 5/3/2022 11:06:02 AM
5/3/2022 11:06:02 AM : -------------Import One Distributor End Time----------- ### 5/3/2022 11:06:02 AM
5/3/2022 11:22:00 AM : Start Process : checkAllTablesExists()  ### Start
5/3/2022 11:22:00 AM : Import Start Time (NEW) For Awadh Krishi Kendra(9062642) ### 5/3/2022 11:22:00 AM
5/3/2022 11:22:00 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
5/3/2022 11:22:00 AM : For Distributor 000000000000365 Insert Count::40 ### Delete Count::32
5/3/2022 11:22:00 AM : Import AD File --->> AD_365_20220503_fda7861f25c44c8fc5b8d82b5065f773.TXT ### 5/3/2022 11:22:00 AM
5/3/2022 11:22:00 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
5/3/2022 11:22:00 AM : Import Masters Completed Awadh Krishi Kendra(9062642) ### 5/3/2022 11:22:00 AM
5/3/2022 11:22:00 AM : Start Process : ImportSplittedFilesOldDeleteInsert()  ###  called 
5/3/2022 11:22:00 AM : splitFileDaywiseNewNaming  ###  called 
5/3/2022 11:22:00 AM : splitFileDaywiseNewNaming  ###  called 
5/3/2022 11:22:01 AM : command:: ### Delete Unlinked DN
5/3/2022 11:22:01 AM : command:: ### Delete Unlinked DN
5/3/2022 11:22:01 AM : command:: ### Delete SPLITFILEINFO DN
5/3/2022 11:22:01 AM : Import DN File --->> DN_365_20200402_557f1c6c436fc6519516d53555b4cf1b.TXT ### 5/3/2022 11:22:01 AM
5/3/2022 11:22:01 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:01 AM : Import DN File --->> DN_365_20200408_4b88d194fba898a0809158bf2456faf2.TXT ### 5/3/2022 11:22:01 AM
5/3/2022 11:22:01 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:01 AM : Import DN File --->> DN_365_20200416_ccda434ab221e7f5aa37b27654e893d7.TXT ### 5/3/2022 11:22:01 AM
5/3/2022 11:22:01 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:02 AM : Import DN File --->> DN_365_20200616_5796214e4bb6c4be558bdcfb34514718.TXT ### 5/3/2022 11:22:02 AM
5/3/2022 11:22:02 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:02 AM : Import DN File --->> DN_365_20200624_8e91071b1b3bf5fa20f3c3b636cc278b.TXT ### 5/3/2022 11:22:02 AM
5/3/2022 11:22:02 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:02 AM : Import DN File --->> DN_365_20200625_7d30bdf538b5b8286d121bff710df0a7.TXT ### 5/3/2022 11:22:02 AM
5/3/2022 11:22:02 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:02 AM : Import DN File --->> DN_365_20200804_2f5de5a00dbcfd90d709519de5256eda.TXT ### 5/3/2022 11:22:02 AM
5/3/2022 11:22:02 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:02 AM : Import DN File --->> DN_365_20200814_9d58fb6c247af6855ab182e590c80a23.TXT ### 5/3/2022 11:22:02 AM
5/3/2022 11:22:02 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::4
5/3/2022 11:22:03 AM : Import DN File --->> DN_365_20200826_3717fc0102e5c6ce8319fce93a1555cc.TXT ### 5/3/2022 11:22:03 AM
5/3/2022 11:22:03 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:03 AM : Import DN File --->> DN_365_20200904_fe9d91819c7f7fe9097897dfbddb11de.TXT ### 5/3/2022 11:22:03 AM
5/3/2022 11:22:03 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:03 AM : Import DN File --->> DN_365_20200911_6b24484c90bf7627eef16e64e28b7dff.TXT ### 5/3/2022 11:22:03 AM
5/3/2022 11:22:03 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:03 AM : Import DN File --->> DN_365_20200914_8fd1e842e0986895b3cb4a60f2f09182.TXT ### 5/3/2022 11:22:03 AM
5/3/2022 11:22:03 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:22:03 AM : Import DN File --->> DN_365_20200915_15a070f57332ced195a60a9c2a59228e.TXT ### 5/3/2022 11:22:03 AM
5/3/2022 11:22:03 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:03 AM : Import DN File --->> DN_365_20200925_461488661165cb9b1af3b7fb46be2f3e.TXT ### 5/3/2022 11:22:03 AM
5/3/2022 11:22:03 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:03 AM : Import DN File --->> DN_365_20201005_7762dae68bf6af5cd43c559383964785.TXT ### 5/3/2022 11:22:03 AM
5/3/2022 11:22:03 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:03 AM : Import DN File --->> DN_365_20201010_ea96cdac4b16c260976b35312e32fda1.TXT ### 5/3/2022 11:22:03 AM
5/3/2022 11:22:03 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:03 AM : Import DN File --->> DN_365_20201015_b1166519c65f63bc59965043f6ae795d.TXT ### 5/3/2022 11:22:03 AM
5/3/2022 11:22:03 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:03 AM : Import DN File --->> DN_365_20201016_04c7e6e1bf46140f45ed32dd94eb7a12.TXT ### 5/3/2022 11:22:03 AM
5/3/2022 11:22:03 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:03 AM : Import DN File --->> DN_365_20201019_dff1dc2e19f76aa858c1f59b98c31127.TXT ### 5/3/2022 11:22:03 AM
5/3/2022 11:22:03 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:03 AM : Import DN File --->> DN_365_20201027_25ed811afd00158105207c7cb1b8450d.TXT ### 5/3/2022 11:22:03 AM
5/3/2022 11:22:03 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:22:04 AM : Import DN File --->> DN_365_20201127_e291ed307ec690adb8783d3475686050.TXT ### 5/3/2022 11:22:04 AM
5/3/2022 11:22:04 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:04 AM : Import DN File --->> DN_365_20201201_aa759d18c5427cfe325383221b90adf5.TXT ### 5/3/2022 11:22:04 AM
5/3/2022 11:22:04 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:04 AM : Import DN File --->> DN_365_20201204_1a25e27f664dd066c5775d9c790c9916.TXT ### 5/3/2022 11:22:04 AM
5/3/2022 11:22:04 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:04 AM : Import DN File --->> DN_365_20201208_5ef99f31ca4549046f69c15644b59baa.TXT ### 5/3/2022 11:22:04 AM
5/3/2022 11:22:04 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::4
5/3/2022 11:22:04 AM : Import DN File --->> DN_365_20201210_d60334b6be9220213b004dda0b798f18.TXT ### 5/3/2022 11:22:04 AM
5/3/2022 11:22:04 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:04 AM : Import DN File --->> DN_365_20201225_32e50791ef30dc0259d02c6c839efc77.TXT ### 5/3/2022 11:22:04 AM
5/3/2022 11:22:04 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:04 AM : Import DN File --->> DN_365_20201226_f2944dc15dbd0d84b343a3b7a562d207.TXT ### 5/3/2022 11:22:04 AM
5/3/2022 11:22:04 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:04 AM : Import DN File --->> DN_365_20210131_d004c392b43521a2a9ea8bb4696d71be.TXT ### 5/3/2022 11:22:04 AM
5/3/2022 11:22:04 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:04 AM : Import DN File --->> DN_365_20210203_41159044b25009495f99269b33c70bc1.TXT ### 5/3/2022 11:22:04 AM
5/3/2022 11:22:04 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:04 AM : Import DN File --->> DN_365_20210208_aee05e095d05d6c970b08a9fb1c4e24e.TXT ### 5/3/2022 11:22:04 AM
5/3/2022 11:22:04 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:04 AM : Import DN File --->> DN_365_20210212_f614414423bf332d613bf09792901f06.TXT ### 5/3/2022 11:22:04 AM
5/3/2022 11:22:04 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:05 AM : Import DN File --->> DN_365_20210217_a59286e15b8da8e10b9f6a339cf88704.TXT ### 5/3/2022 11:22:05 AM
5/3/2022 11:22:05 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:05 AM : Import DN File --->> DN_365_20210218_ebe38f98a080e81b819194b8fbac24b3.TXT ### 5/3/2022 11:22:05 AM
5/3/2022 11:22:05 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:22:05 AM : Import DN File --->> DN_365_20210224_88982be0d58a14d5bdcb6b28aa6cafd7.TXT ### 5/3/2022 11:22:05 AM
5/3/2022 11:22:05 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:22:05 AM : Import DN File --->> DN_365_20210225_7a62ce14fdab05fb803c4a2c280c8f01.TXT ### 5/3/2022 11:22:05 AM
5/3/2022 11:22:05 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:05 AM : Import DN File --->> DN_365_20210302_fab5dc8bd8a91faca4c4ba2b92ece2e2.TXT ### 5/3/2022 11:22:05 AM
5/3/2022 11:22:05 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:05 AM : Import DN File --->> DN_365_20210303_cf413157253cb3afa2e092a345ef2e64.TXT ### 5/3/2022 11:22:05 AM
5/3/2022 11:22:05 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:05 AM : Import DN File --->> DN_365_20210306_32624afecb5397524937c33c77881573.TXT ### 5/3/2022 11:22:05 AM
5/3/2022 11:22:05 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:05 AM : Import DN File --->> DN_365_20210317_c4462f856ea7d392116a5ab311fa1edd.TXT ### 5/3/2022 11:22:05 AM
5/3/2022 11:22:05 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:05 AM : Import DN File --->> DN_365_20210318_bf51417162f0cc8dfc7e5e412a3f5c38.TXT ### 5/3/2022 11:22:05 AM
5/3/2022 11:22:05 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:05 AM : Import DN File --->> DN_365_20210322_5843803213d2fd10f3dab7515f8b119f.TXT ### 5/3/2022 11:22:05 AM
5/3/2022 11:22:05 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:05 AM : command:: flagImportPosting =  ### True
5/3/2022 11:22:05 AM : command:: minDate =  ### 4/1/2020 12:00:00 AM
5/3/2022 11:22:05 AM : splitFileDaywiseNewNaming  ###  called 
5/3/2022 11:22:06 AM : command:: ### Delete Unlinked IN
5/3/2022 11:22:06 AM : command:: ### Delete Unlinked IN
5/3/2022 11:22:06 AM : command:: ### Delete SPLITFILEINFO IN
5/3/2022 11:22:06 AM : Import IN File --->> IN_365_20200413_7ee4182adfa7e80f4806dd77ebff1858.TXT ### 5/3/2022 11:22:06 AM
5/3/2022 11:22:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:06 AM : Import IN File --->> IN_365_20200415_19fd0538a50a87dd352e0cbe4b23c6e6.TXT ### 5/3/2022 11:22:06 AM
5/3/2022 11:22:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:06 AM : Import IN File --->> IN_365_20200417_341bf423e412169b719044ad412a69d3.TXT ### 5/3/2022 11:22:06 AM
5/3/2022 11:22:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:06 AM : Import IN File --->> IN_365_20200420_d6483dbc6018abf1c6afd163a2c76045.TXT ### 5/3/2022 11:22:06 AM
5/3/2022 11:22:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:22:06 AM : Import IN File --->> IN_365_20200427_5eaeda889884ec94dcba2c0e5a28138b.TXT ### 5/3/2022 11:22:06 AM
5/3/2022 11:22:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:06 AM : Import IN File --->> IN_365_20200430_cd87c9bd0bbc49614d76ebd50f7d6519.TXT ### 5/3/2022 11:22:06 AM
5/3/2022 11:22:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:06 AM : Import IN File --->> IN_365_20200511_8f9e95915f68fb4b931039f25958a989.TXT ### 5/3/2022 11:22:06 AM
5/3/2022 11:22:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:07 AM : Import IN File --->> IN_365_20200523_6cab90a578ab10f2d944f6bb1608ca2f.TXT ### 5/3/2022 11:22:07 AM
5/3/2022 11:22:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:22:07 AM : Import IN File --->> IN_365_20200524_63a60409a00799e5bb4f5b89b21c09ac.TXT ### 5/3/2022 11:22:07 AM
5/3/2022 11:22:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:07 AM : Import IN File --->> IN_365_20200531_28693bc04c3a14036423f8faf6f13aa2.TXT ### 5/3/2022 11:22:07 AM
5/3/2022 11:22:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:07 AM : Import IN File --->> IN_365_20200603_0bcf043d3feab20daaddcf142992a099.TXT ### 5/3/2022 11:22:07 AM
5/3/2022 11:22:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:07 AM : Import IN File --->> IN_365_20200609_fc13e38bb1d81a312edcf9d400156753.TXT ### 5/3/2022 11:22:07 AM
5/3/2022 11:22:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:07 AM : Import IN File --->> IN_365_20200614_922e07bd57cfc5c3f258768470788662.TXT ### 5/3/2022 11:22:07 AM
5/3/2022 11:22:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::4
5/3/2022 11:22:07 AM : Import IN File --->> IN_365_20200620_ab3b319da32983e04c283ef4947419a9.TXT ### 5/3/2022 11:22:07 AM
5/3/2022 11:22:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::5
5/3/2022 11:22:07 AM : Import IN File --->> IN_365_20200701_7eef33040242735f49a789a90b561cbe.TXT ### 5/3/2022 11:22:07 AM
5/3/2022 11:22:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:08 AM : Import IN File --->> IN_365_20200728_5681c6816b8685f2d485fb2145cc7ff0.TXT ### 5/3/2022 11:22:08 AM
5/3/2022 11:22:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:08 AM : Import IN File --->> IN_365_20200801_b42a3bbc5751fe5220a55d65b1aa1d79.TXT ### 5/3/2022 11:22:08 AM
5/3/2022 11:22:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:08 AM : Import IN File --->> IN_365_20200804_88023b5e36508389d566d512bf8e86e6.TXT ### 5/3/2022 11:22:08 AM
5/3/2022 11:22:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::4
5/3/2022 11:22:08 AM : Import IN File --->> IN_365_20200810_fb49a463226c2e8faf18cba12f799734.TXT ### 5/3/2022 11:22:08 AM
5/3/2022 11:22:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:08 AM : Import IN File --->> IN_365_20200818_413a1137c83215ffd6e6be94f4b335d8.TXT ### 5/3/2022 11:22:08 AM
5/3/2022 11:22:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:08 AM : Import IN File --->> IN_365_20200819_284295c8ee54a111530e28a362fe9164.TXT ### 5/3/2022 11:22:08 AM
5/3/2022 11:22:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:08 AM : Import IN File --->> IN_365_20200821_3ac5c7065860b9e0095ef02fcf753832.TXT ### 5/3/2022 11:22:08 AM
5/3/2022 11:22:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:08 AM : Import IN File --->> IN_365_20200823_dfda066d71426db2a05af1224855e5e4.TXT ### 5/3/2022 11:22:08 AM
5/3/2022 11:22:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:08 AM : Import IN File --->> IN_365_20200824_95e1582bbfefba6d8bae7177dadc41e4.TXT ### 5/3/2022 11:22:08 AM
5/3/2022 11:22:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:22:08 AM : Import IN File --->> IN_365_20200826_0da0ca618cbe381c26e266969b6b09d8.TXT ### 5/3/2022 11:22:08 AM
5/3/2022 11:22:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:08 AM : Import IN File --->> IN_365_20200827_b6347acb5bf4322dcd2264f7ee35e90a.TXT ### 5/3/2022 11:22:08 AM
5/3/2022 11:22:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::7
5/3/2022 11:22:08 AM : Import IN File --->> IN_365_20200902_71e9fd35e976ae074175ea3ebccc2028.TXT ### 5/3/2022 11:22:08 AM
5/3/2022 11:22:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:08 AM : Import IN File --->> IN_365_20200904_ef0c655a7a3048e457da8d12d882225a.TXT ### 5/3/2022 11:22:08 AM
5/3/2022 11:22:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:08 AM : Import IN File --->> IN_365_20200908_0752e9f1454ad9ebf764d3afd5ae9364.TXT ### 5/3/2022 11:22:08 AM
5/3/2022 11:22:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:22:08 AM : Import IN File --->> IN_365_20200912_96ef8a8ec505dac15d731d090963a804.TXT ### 5/3/2022 11:22:08 AM
5/3/2022 11:22:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:08 AM : Import IN File --->> IN_365_20200915_519bbd6e11af9e0bc1d4241a54cd6e15.TXT ### 5/3/2022 11:22:08 AM
5/3/2022 11:22:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:08 AM : Import IN File --->> IN_365_20200917_0eac8df12b06143dbbc29bc40c3d406e.TXT ### 5/3/2022 11:22:08 AM
5/3/2022 11:22:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:22:08 AM : Import IN File --->> IN_365_20200920_54c4cf209a1bb780387da1a0104d06a8.TXT ### 5/3/2022 11:22:08 AM
5/3/2022 11:22:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:22:08 AM : Import IN File --->> IN_365_20200923_147c928f289d11f59103732226b7fe9d.TXT ### 5/3/2022 11:22:08 AM
5/3/2022 11:22:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:08 AM : Import IN File --->> IN_365_20200924_4bd74d5347f77a0be114d3fe8ee90181.TXT ### 5/3/2022 11:22:08 AM
5/3/2022 11:22:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:08 AM : Import IN File --->> IN_365_20200927_c832a353f173f45bcc9f5920978984bd.TXT ### 5/3/2022 11:22:08 AM
5/3/2022 11:22:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20200928_ff9bf418c48613e739fb64b722de77fd.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20200930_502c47ca1e93ea4b339c646e79545072.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20201003_bb73deabdb60e8a35f12df73b02916a3.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::5
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20201005_b7303553ced451d0c05c511d9a2d15c2.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20201006_69a89ec4eaac3ee4961f66a3677c9796.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20201007_d21d35ee97eec1d36457de0cfde14180.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::4
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20201010_58a563c076803a752444f281fbdf95bc.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20201013_53b254743a8d90b0cfc977b157af2685.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::4
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20201016_36f21332144071c71249fe628923a159.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20201017_b5175f52e19f008773c319a237b7bb05.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20201020_679dc3388421d2724c34ade99eb75549.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::5
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20201026_2592aeadc4a5d36270742ea21188e3a7.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20201028_cdf452c70001039f2ed428c06213388f.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20201103_0e862a428104550181993d82e59e3faa.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20201104_9b5c6406fff60c3dde25b03382da5e17.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20201110_c2492f98b59594b5f80dbd22c45f3679.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20201111_909214b4c6f1b4d54f0b41fc08f6a8ee.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20201121_c72bf52058d42bbb4d9bb79334076e75.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20201126_2a765a6900726fabda15dfe37534298a.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::6
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20201128_2c1ba711333102e63677f023215a6a45.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20201203_7ce9608949474ad7ae5d72afbd088702.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20201204_cb9bdf465a686d2f105056a5a5b99b0b.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20201205_21f64d720c70d4aacc7a3725e7e6be5b.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20201208_a35793ffd5f22180eaa6d447008584cf.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20201209_63aa7d5fcf95951a6049ce57c591819f.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20201210_86c15c4ef26c9f23fd89df25dcd0491d.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:09 AM : Import IN File --->> IN_365_20201211_3fa4f5519fc38da78025b2795b383ccf.TXT ### 5/3/2022 11:22:09 AM
5/3/2022 11:22:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:10 AM : Import IN File --->> IN_365_20201215_f91e567a21ed553041de0b27529c013b.TXT ### 5/3/2022 11:22:10 AM
5/3/2022 11:22:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:10 AM : Import IN File --->> IN_365_20201221_e0ff65a603b046d6ca5ca2e0b3070bf8.TXT ### 5/3/2022 11:22:10 AM
5/3/2022 11:22:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:10 AM : Import IN File --->> IN_365_20201223_72cbc14f8f64b358132b79390103a00f.TXT ### 5/3/2022 11:22:10 AM
5/3/2022 11:22:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:10 AM : Import IN File --->> IN_365_20201224_62f0574cfd86780b4c5a9eabc31458b8.TXT ### 5/3/2022 11:22:10 AM
5/3/2022 11:22:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:10 AM : Import IN File --->> IN_365_20201227_a35926aadace6cf019d0aa1f2bf9b02c.TXT ### 5/3/2022 11:22:10 AM
5/3/2022 11:22:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:10 AM : Import IN File --->> IN_365_20201228_356cdbda720dcd44529b1519286fa32c.TXT ### 5/3/2022 11:22:10 AM
5/3/2022 11:22:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:10 AM : Import IN File --->> IN_365_20201229_231bd194ee0117ab4fa77f78bf62ed29.TXT ### 5/3/2022 11:22:10 AM
5/3/2022 11:22:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::10
5/3/2022 11:22:10 AM : Import IN File --->> IN_365_20201231_43ce3359f857e21deac3a3018f7d1277.TXT ### 5/3/2022 11:22:10 AM
5/3/2022 11:22:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:10 AM : Import IN File --->> IN_365_20210112_fb114c026e9497805840770322136ead.TXT ### 5/3/2022 11:22:10 AM
5/3/2022 11:22:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:10 AM : Import IN File --->> IN_365_20210118_0b0c42f62a764124eb82b82976fcec0d.TXT ### 5/3/2022 11:22:10 AM
5/3/2022 11:22:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:10 AM : Import IN File --->> IN_365_20210119_7b742499c8ce0e862e5ea764e8c45cac.TXT ### 5/3/2022 11:22:10 AM
5/3/2022 11:22:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:10 AM : Import IN File --->> IN_365_20210202_3a25324d33a78007aa5bed6a1c6e4caf.TXT ### 5/3/2022 11:22:10 AM
5/3/2022 11:22:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:10 AM : Import IN File --->> IN_365_20210204_8f51c9767b4b0bffe9cbbc034e5eb447.TXT ### 5/3/2022 11:22:10 AM
5/3/2022 11:22:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::5
5/3/2022 11:22:10 AM : Import IN File --->> IN_365_20210209_b138701136cfeeb5533878c7926098bf.TXT ### 5/3/2022 11:22:10 AM
5/3/2022 11:22:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:10 AM : Import IN File --->> IN_365_20210210_9cabff2c640cf417a0d365b6f6adbf98.TXT ### 5/3/2022 11:22:10 AM
5/3/2022 11:22:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:10 AM : Import IN File --->> IN_365_20210213_214ba65707cf06e50cfba36661c07721.TXT ### 5/3/2022 11:22:10 AM
5/3/2022 11:22:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:10 AM : Import IN File --->> IN_365_20210217_35bc449fe46485fd231fde4a0f0380f3.TXT ### 5/3/2022 11:22:10 AM
5/3/2022 11:22:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::4
5/3/2022 11:22:10 AM : Import IN File --->> IN_365_20210218_4507a22113eaca3056601426e573e465.TXT ### 5/3/2022 11:22:10 AM
5/3/2022 11:22:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::7
5/3/2022 11:22:10 AM : Import IN File --->> IN_365_20210222_2862a44d6b9107ff4ddbbe1a6279d3db.TXT ### 5/3/2022 11:22:10 AM
5/3/2022 11:22:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:10 AM : Import IN File --->> IN_365_20210223_4a6960ae7a570c36b6d208c8f66b40c7.TXT ### 5/3/2022 11:22:10 AM
5/3/2022 11:22:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:10 AM : Import IN File --->> IN_365_20210224_5ff472321d0683ca94eea51c0f35cc3b.TXT ### 5/3/2022 11:22:10 AM
5/3/2022 11:22:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:11 AM : Import IN File --->> IN_365_20210227_91c69e9c1edd9419d9db8997295ff913.TXT ### 5/3/2022 11:22:11 AM
5/3/2022 11:22:11 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:11 AM : Import IN File --->> IN_365_20210302_05039b5c14e95d2ee1041cf4fec426b3.TXT ### 5/3/2022 11:22:11 AM
5/3/2022 11:22:11 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:11 AM : Import IN File --->> IN_365_20210304_cb79debd54971457ab4c10293cae353f.TXT ### 5/3/2022 11:22:11 AM
5/3/2022 11:22:11 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:11 AM : Import IN File --->> IN_365_20210305_bd3826546c6935d6c1ad27f855a787cc.TXT ### 5/3/2022 11:22:11 AM
5/3/2022 11:22:11 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:11 AM : Import IN File --->> IN_365_20210306_58487fa0ecee4d39a79277268af4d360.TXT ### 5/3/2022 11:22:11 AM
5/3/2022 11:22:11 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::4
5/3/2022 11:22:11 AM : Import IN File --->> IN_365_20210308_3d33f7509ee7dfb28a8c7c456d4aa2e4.TXT ### 5/3/2022 11:22:11 AM
5/3/2022 11:22:11 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:11 AM : Import IN File --->> IN_365_20210311_310422c337f0093da2bbc86996d3ff31.TXT ### 5/3/2022 11:22:11 AM
5/3/2022 11:22:11 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:11 AM : Import IN File --->> IN_365_20210315_6b2a2c9a6066a60464a57b2f33cabe15.TXT ### 5/3/2022 11:22:11 AM
5/3/2022 11:22:11 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:11 AM : Import IN File --->> IN_365_20210316_abbb5d8fcffe4d1f2a80b5263e81deba.TXT ### 5/3/2022 11:22:11 AM
5/3/2022 11:22:11 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:11 AM : Import IN File --->> IN_365_20210317_b763e68eb664558745a1cee7eaa7352b.TXT ### 5/3/2022 11:22:11 AM
5/3/2022 11:22:11 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:22:11 AM : Import IN File --->> IN_365_20210318_5585453a2515cbfb5faaaa348c931335.TXT ### 5/3/2022 11:22:11 AM
5/3/2022 11:22:11 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:22:11 AM : Import IN File --->> IN_365_20210319_b41f21cb6a0183eec58dc6e3c54e0498.TXT ### 5/3/2022 11:22:11 AM
5/3/2022 11:22:11 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:22:11 AM : Import IN File --->> IN_365_20210321_2e83a4466bb4c0cc6abe0f76afbedfca.TXT ### 5/3/2022 11:22:11 AM
5/3/2022 11:22:11 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:11 AM : Import IN File --->> IN_365_20210323_0f38aa856582db83a2608620082cbaa8.TXT ### 5/3/2022 11:22:11 AM
5/3/2022 11:22:11 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:22:11 AM : Import IN File --->> IN_365_20210325_dc34d5e60cf32da2fd65b6fd62de03b2.TXT ### 5/3/2022 11:22:11 AM
5/3/2022 11:22:11 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:11 AM : Import IN File --->> IN_365_20210330_2a456f8083f170a1bfbaffb16b738e8a.TXT ### 5/3/2022 11:22:11 AM
5/3/2022 11:22:11 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:22:11 AM : command:: flagImportPosting =  ### True
5/3/2022 11:22:11 AM : command:: minDate =  ### 4/1/2020 12:00:00 AM
5/3/2022 11:22:12 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 5/3/2022 11:22:12 AM
5/3/2022 11:22:13 AM : CustomerLink Diff Successful --->>  ### 5/3/2022 11:22:13 AM
5/3/2022 11:22:13 AM : ItemLink Diff Successful --->>  ### 5/3/2022 11:22:13 AM
5/3/2022 11:22:13 AM : Supplierlink Query Successful --->>  ### 5/3/2022 11:22:13 AM
5/3/2022 11:22:14 AM : Posting Purchases 'true' Successful --->>  ### 5/3/2022 11:22:14 AM
5/3/2022 11:22:14 AM : Posting OtherTransaction 'true' Successful --->>  ### 5/3/2022 11:22:14 AM
5/3/2022 11:22:20 AM : Posting Sales 'true' Successful --->>  ### 5/3/2022 11:22:20 AM
5/3/2022 11:22:22 AM : Completed Updating Has Transaction Flag  ### 5/3/2022 11:22:22 AM
5/3/2022 11:22:22 AM : command :: PostDataDeleteInsert  ###  Done 
5/3/2022 11:22:22 AM : command :: set DiffCutOffDate  ###  Done 
5/3/2022 11:22:22 AM : End Process : ImportSplittedFilesOldDeleteInsert()  ### 

5/3/2022 11:22:22 AM : Import End Time (NEW) Awadh Krishi Kendra(9062642) ### 5/3/2022 11:22:22 AM
5/3/2022 11:22:22 AM : -------------Import One Distributor End Time----------- ### 5/3/2022 11:22:22 AM
5/3/2022 11:31:59 AM : Start Process : checkAllTablesExists()  ### Start
5/3/2022 11:31:59 AM : Import Start Time (NEW) For Awadh Krishi Kendra(9062642) ### 5/3/2022 11:31:59 AM
5/3/2022 11:31:59 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
5/3/2022 11:31:59 AM : For Distributor 000000000000365 Insert Count::32 ### Delete Count::40
5/3/2022 11:31:59 AM : Import AD File --->> AD_365_20220503_6eba750553982ab515996660a8a0d79f.TXT ### 5/3/2022 11:31:59 AM
5/3/2022 11:31:59 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
5/3/2022 11:31:59 AM : Import Masters Completed Awadh Krishi Kendra(9062642) ### 5/3/2022 11:31:59 AM
5/3/2022 11:31:59 AM : Start Process : ImportSplittedFilesOldDeleteInsert()  ###  called 
5/3/2022 11:31:59 AM : splitFileDaywiseNewNaming  ###  called 
5/3/2022 11:32:00 AM : splitFileDaywiseNewNaming  ###  called 
5/3/2022 11:32:00 AM : splitFileDaywiseNewNaming  ### FileRangeMonthYear = '4-2021' and FileDataMonthYear= '5-2021' of MinDate mismatched
5/3/2022 11:32:00 AM : command:: ### Delete Unlinked DN
5/3/2022 11:32:00 AM : command:: ### Delete Unlinked DN
5/3/2022 11:32:00 AM : command:: ### Delete SPLITFILEINFO DN
5/3/2022 11:32:00 AM : Import DN File --->> DN_365_20210513_4e5bc682bea4f8da4736a982aa1d61ce.TXT ### 5/3/2022 11:32:00 AM
5/3/2022 11:32:00 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:00 AM : Import DN File --->> DN_365_20210525_4bfe1b0e361494f3f7d25776c0042f57.TXT ### 5/3/2022 11:32:00 AM
5/3/2022 11:32:00 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:00 AM : Import DN File --->> DN_365_20210526_128c4571fe78a623e36466a58d2baf08.TXT ### 5/3/2022 11:32:00 AM
5/3/2022 11:32:00 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:01 AM : Import DN File --->> DN_365_20210607_7d6dad027846fd22635f0c6220b0b3b8.TXT ### 5/3/2022 11:32:01 AM
5/3/2022 11:32:01 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:01 AM : Import DN File --->> DN_365_20210608_6e2bc325fc77ca036031c23d7623adef.TXT ### 5/3/2022 11:32:01 AM
5/3/2022 11:32:01 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:32:01 AM : Import DN File --->> DN_365_20210616_7db9479a2fbfda80c780202dc4eed88c.TXT ### 5/3/2022 11:32:01 AM
5/3/2022 11:32:01 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:01 AM : Import DN File --->> DN_365_20210618_81605beae056c6710c3a57afeb4036df.TXT ### 5/3/2022 11:32:01 AM
5/3/2022 11:32:01 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:01 AM : Import DN File --->> DN_365_20210622_34e08afb287e8799ec77d768446af08c.TXT ### 5/3/2022 11:32:01 AM
5/3/2022 11:32:01 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:32:01 AM : Import DN File --->> DN_365_20210623_425ef8f089b940f452b8802fab44e5c7.TXT ### 5/3/2022 11:32:01 AM
5/3/2022 11:32:01 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:01 AM : Import DN File --->> DN_365_20210625_e6fc1f51acc5d0afba7d98e00d477d9d.TXT ### 5/3/2022 11:32:01 AM
5/3/2022 11:32:01 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:01 AM : Import DN File --->> DN_365_20210702_41474d3fcca2df8d1c7bb47747c5e434.TXT ### 5/3/2022 11:32:01 AM
5/3/2022 11:32:01 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:32:01 AM : Import DN File --->> DN_365_20210706_8c45ff79e00801fc25e86c5f53a1d2ab.TXT ### 5/3/2022 11:32:01 AM
5/3/2022 11:32:01 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:32:01 AM : Import DN File --->> DN_365_20210713_672ccf5a747674583dc7cb2d93e4ec02.TXT ### 5/3/2022 11:32:01 AM
5/3/2022 11:32:01 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::4
5/3/2022 11:32:01 AM : Import DN File --->> DN_365_20210719_eda1c3a26b1b8fd8309adf6b8e5ca840.TXT ### 5/3/2022 11:32:01 AM
5/3/2022 11:32:01 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:32:01 AM : Import DN File --->> DN_365_20210724_5a6d0dd96159426d44dc9aa8ca1381f4.TXT ### 5/3/2022 11:32:01 AM
5/3/2022 11:32:01 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:01 AM : Import DN File --->> DN_365_20210802_fc34d62c0a0e19654a2a34ff3e61ab3e.TXT ### 5/3/2022 11:32:01 AM
5/3/2022 11:32:01 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::4
5/3/2022 11:32:01 AM : Import DN File --->> DN_365_20210811_fd5739a9c576ea5c38a4626bbdc4496b.TXT ### 5/3/2022 11:32:01 AM
5/3/2022 11:32:01 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:01 AM : Import DN File --->> DN_365_20210813_f199e2c561bf00f31809692ebd501009.TXT ### 5/3/2022 11:32:01 AM
5/3/2022 11:32:01 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:01 AM : Import DN File --->> DN_365_20210814_0fa704dfb2dbd79e9dcca1777e591232.TXT ### 5/3/2022 11:32:01 AM
5/3/2022 11:32:01 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:01 AM : Import DN File --->> DN_365_20210816_a236e4b5d9a44ff2ff1e11d2c639573f.TXT ### 5/3/2022 11:32:01 AM
5/3/2022 11:32:01 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::4
5/3/2022 11:32:02 AM : Import DN File --->> DN_365_20210818_0e2b9cef667721852cdbb40bc7cf07b4.TXT ### 5/3/2022 11:32:02 AM
5/3/2022 11:32:02 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:32:02 AM : Import DN File --->> DN_365_20210825_63948682524b34a77c48f7dd65eb43f5.TXT ### 5/3/2022 11:32:02 AM
5/3/2022 11:32:02 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:02 AM : Import DN File --->> DN_365_20210827_e97e5817ed6ecaf0f1469239256e469a.TXT ### 5/3/2022 11:32:02 AM
5/3/2022 11:32:02 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:02 AM : Import DN File --->> DN_365_20210901_c3ecdf3f2a200c67cf85b5c3890af681.TXT ### 5/3/2022 11:32:02 AM
5/3/2022 11:32:02 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:02 AM : Import DN File --->> DN_365_20210903_3c7d2301bea9b45a65a30e3c822e9c21.TXT ### 5/3/2022 11:32:02 AM
5/3/2022 11:32:02 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:02 AM : Import DN File --->> DN_365_20210904_f982263b7e36ad5a5b7f6c824f7a43af.TXT ### 5/3/2022 11:32:02 AM
5/3/2022 11:32:02 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:02 AM : Import DN File --->> DN_365_20210908_b853b2ffba600b813d6c92709c2757a7.TXT ### 5/3/2022 11:32:02 AM
5/3/2022 11:32:02 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:02 AM : Import DN File --->> DN_365_20210915_8faf79c46ba067a765cef83fe5c70e02.TXT ### 5/3/2022 11:32:02 AM
5/3/2022 11:32:02 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:32:02 AM : Import DN File --->> DN_365_20210920_fdb148a13fea60c8c43253d5b8e1b621.TXT ### 5/3/2022 11:32:02 AM
5/3/2022 11:32:02 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:02 AM : Import DN File --->> DN_365_20210927_e1b63ea51ddd0d41816183dcbddcf2cd.TXT ### 5/3/2022 11:32:02 AM
5/3/2022 11:32:02 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:02 AM : Import DN File --->> DN_365_20210928_36ab511f33ba5620f8364bf5d0111d7d.TXT ### 5/3/2022 11:32:02 AM
5/3/2022 11:32:02 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:02 AM : Import DN File --->> DN_365_20210929_3e061e6ed7828a20aaa602cfbd7dfdea.TXT ### 5/3/2022 11:32:02 AM
5/3/2022 11:32:02 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:32:02 AM : Import DN File --->> DN_365_20211009_4c0806c6c4f2115549908d542c44f878.TXT ### 5/3/2022 11:32:02 AM
5/3/2022 11:32:02 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:02 AM : Import DN File --->> DN_365_20211016_17e26dc12019a32fc177154f59511276.TXT ### 5/3/2022 11:32:02 AM
5/3/2022 11:32:02 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:02 AM : Import DN File --->> DN_365_20211025_72a65759c1a61721f323fb62dc832b9e.TXT ### 5/3/2022 11:32:02 AM
5/3/2022 11:32:02 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:32:02 AM : Import DN File --->> DN_365_20211101_1a527001e3207aa254a2211671b624a5.TXT ### 5/3/2022 11:32:02 AM
5/3/2022 11:32:03 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:03 AM : Import DN File --->> DN_365_20211110_cbe9b30c6eb6c063c4bf68e13738d9bf.TXT ### 5/3/2022 11:32:03 AM
5/3/2022 11:32:03 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:03 AM : Import DN File --->> DN_365_20211118_8e9150a19bbf3a83342054bcb7f7564b.TXT ### 5/3/2022 11:32:03 AM
5/3/2022 11:32:03 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:32:03 AM : Import DN File --->> DN_365_20211122_b033327d13c00d1f6df994a338d3502e.TXT ### 5/3/2022 11:32:03 AM
5/3/2022 11:32:03 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:03 AM : Import DN File --->> DN_365_20211213_6b076055cf235ed7f90188ed2e8eae35.TXT ### 5/3/2022 11:32:03 AM
5/3/2022 11:32:03 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::4
5/3/2022 11:32:03 AM : Import DN File --->> DN_365_20211227_f9d1ef7fe09a8eabcfd8ef7738beb78a.TXT ### 5/3/2022 11:32:03 AM
5/3/2022 11:32:03 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:03 AM : Import DN File --->> DN_365_20220106_45dab35845b3aeae5fe3e20a329f0955.TXT ### 5/3/2022 11:32:03 AM
5/3/2022 11:32:03 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:03 AM : Import DN File --->> DN_365_20220110_f63e3b03769cf98263c14f0a64aeae0b.TXT ### 5/3/2022 11:32:03 AM
5/3/2022 11:32:03 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:03 AM : Import DN File --->> DN_365_20220113_5b54ba564b26a2443979d58e6a5da14c.TXT ### 5/3/2022 11:32:03 AM
5/3/2022 11:32:03 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:04 AM : Import DN File --->> DN_365_20220203_d825d453eca13d2f13a2ef1c1c836076.TXT ### 5/3/2022 11:32:04 AM
5/3/2022 11:32:04 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:04 AM : Import DN File --->> DN_365_20220314_382e74f5991ac782805c65a084f3b468.TXT ### 5/3/2022 11:32:04 AM
5/3/2022 11:32:04 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:04 AM : Import DN File --->> DN_365_20220315_297fa95da06814c662cc6b193f615bdd.TXT ### 5/3/2022 11:32:04 AM
5/3/2022 11:32:04 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:04 AM : command:: flagImportPosting =  ### True
5/3/2022 11:32:04 AM : command:: minDate =  ### 5/13/2021 12:00:00 AM
5/3/2022 11:32:04 AM : splitFileDaywiseNewNaming  ###  called 
5/3/2022 11:32:05 AM : command:: ### Delete Unlinked IN
5/3/2022 11:32:05 AM : command:: ### Delete Unlinked IN
5/3/2022 11:32:05 AM : command:: ### Delete SPLITFILEINFO IN
5/3/2022 11:32:05 AM : Import IN File --->> IN_365_20210401_3390dfb55b9e4541aa1ee94f58b515a9.TXT ### 5/3/2022 11:32:05 AM
5/3/2022 11:32:05 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:05 AM : Import IN File --->> IN_365_20210402_c8438d65524515e6f83c9b22d6f813f7.TXT ### 5/3/2022 11:32:05 AM
5/3/2022 11:32:05 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:05 AM : Import IN File --->> IN_365_20210403_1f21d920326af79583e0da7f60298a4b.TXT ### 5/3/2022 11:32:05 AM
5/3/2022 11:32:05 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::4
5/3/2022 11:32:05 AM : Import IN File --->> IN_365_20210408_0f88df783ca4475fbde954edfbf14ba3.TXT ### 5/3/2022 11:32:05 AM
5/3/2022 11:32:05 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:05 AM : Import IN File --->> IN_365_20210410_897434d0ad0408b97f05baba2f25f0e1.TXT ### 5/3/2022 11:32:05 AM
5/3/2022 11:32:05 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:05 AM : Import IN File --->> IN_365_20210411_963499daf3cd411bd71bff6a7e5a5287.TXT ### 5/3/2022 11:32:05 AM
5/3/2022 11:32:05 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:05 AM : Import IN File --->> IN_365_20210412_7106a0267bdbb5724e95e84d1d5fb2ea.TXT ### 5/3/2022 11:32:05 AM
5/3/2022 11:32:05 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:05 AM : Import IN File --->> IN_365_20210413_98a264569530e277877af77bc777c015.TXT ### 5/3/2022 11:32:05 AM
5/3/2022 11:32:05 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:05 AM : Import IN File --->> IN_365_20210421_9a24862877e4017c6f2c082a80085ef0.TXT ### 5/3/2022 11:32:05 AM
5/3/2022 11:32:05 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::6
5/3/2022 11:32:05 AM : Import IN File --->> IN_365_20210427_e062d45868a35dbef44240f754f9f68c.TXT ### 5/3/2022 11:32:05 AM
5/3/2022 11:32:05 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:05 AM : Import IN File --->> IN_365_20210510_5a22fd83c85c4ce8f026ea6086a5faf2.TXT ### 5/3/2022 11:32:05 AM
5/3/2022 11:32:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::6
5/3/2022 11:32:06 AM : Import IN File --->> IN_365_20210515_29e9c33a946f3dfb3846f46eeff8e750.TXT ### 5/3/2022 11:32:06 AM
5/3/2022 11:32:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:06 AM : Import IN File --->> IN_365_20210519_b146c6135ffa66c36f0670520aa321ac.TXT ### 5/3/2022 11:32:06 AM
5/3/2022 11:32:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:06 AM : Import IN File --->> IN_365_20210521_f5db91ec94ab29b76883eff1d7479c29.TXT ### 5/3/2022 11:32:06 AM
5/3/2022 11:32:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:32:06 AM : Import IN File --->> IN_365_20210522_5e9b0da6a7eb39a05426ae877205d9c1.TXT ### 5/3/2022 11:32:06 AM
5/3/2022 11:32:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:06 AM : Import IN File --->> IN_365_20210603_d96fd1dbd57db0b994e6ce3fef987f57.TXT ### 5/3/2022 11:32:06 AM
5/3/2022 11:32:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::7
5/3/2022 11:32:06 AM : Import IN File --->> IN_365_20210606_2ec63fac541c69313812021187005349.TXT ### 5/3/2022 11:32:06 AM
5/3/2022 11:32:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::4
5/3/2022 11:32:06 AM : Import IN File --->> IN_365_20210614_2213dd65c62ddba526da289b0cde7e26.TXT ### 5/3/2022 11:32:06 AM
5/3/2022 11:32:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:32:06 AM : Import IN File --->> IN_365_20210618_f8aff53f5ab87834b6e9db02115c5d61.TXT ### 5/3/2022 11:32:06 AM
5/3/2022 11:32:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:06 AM : Import IN File --->> IN_365_20210621_2890493c9bb21b4bff5f69b14e2abde6.TXT ### 5/3/2022 11:32:06 AM
5/3/2022 11:32:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:06 AM : Import IN File --->> IN_365_20210623_d9e914363c7fc822a0d7401ef32a6f77.TXT ### 5/3/2022 11:32:06 AM
5/3/2022 11:32:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:06 AM : Import IN File --->> IN_365_20210625_90051ae560df04a4d96da60acf198601.TXT ### 5/3/2022 11:32:06 AM
5/3/2022 11:32:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::5
5/3/2022 11:32:06 AM : Import IN File --->> IN_365_20210626_4c191145586cbca3d076c5eee605327d.TXT ### 5/3/2022 11:32:06 AM
5/3/2022 11:32:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:06 AM : Import IN File --->> IN_365_20210627_ca887d4c90939c7938bb14e8a2318ccc.TXT ### 5/3/2022 11:32:06 AM
5/3/2022 11:32:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:32:06 AM : Import IN File --->> IN_365_20210629_2c6c5c98a4a1d247d1f56f4bab387d66.TXT ### 5/3/2022 11:32:06 AM
5/3/2022 11:32:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::5
5/3/2022 11:32:06 AM : Import IN File --->> IN_365_20210702_e533c88cc3493c4b5289d674e8ffac09.TXT ### 5/3/2022 11:32:06 AM
5/3/2022 11:32:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::7
5/3/2022 11:32:06 AM : Import IN File --->> IN_365_20210703_ee3e902f02c0a2f3e533c193e3f3597e.TXT ### 5/3/2022 11:32:06 AM
5/3/2022 11:32:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:06 AM : Import IN File --->> IN_365_20210707_87bc8ddb27830ae4c5e61492a39b12a3.TXT ### 5/3/2022 11:32:06 AM
5/3/2022 11:32:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:06 AM : Import IN File --->> IN_365_20210708_600a9ca48057df4ab363cab352f4558a.TXT ### 5/3/2022 11:32:06 AM
5/3/2022 11:32:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::4
5/3/2022 11:32:06 AM : Import IN File --->> IN_365_20210712_c0213ce23f8b19a22bc845508fdc0546.TXT ### 5/3/2022 11:32:06 AM
5/3/2022 11:32:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::6
5/3/2022 11:32:06 AM : Import IN File --->> IN_365_20210715_d4d3b5df494946f642daad879eab77f3.TXT ### 5/3/2022 11:32:06 AM
5/3/2022 11:32:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::4
5/3/2022 11:32:06 AM : Import IN File --->> IN_365_20210716_18cbf3346c73cdf264da734e82afac6d.TXT ### 5/3/2022 11:32:06 AM
5/3/2022 11:32:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::4
5/3/2022 11:32:06 AM : Import IN File --->> IN_365_20210719_3c2ff0cd447ad3a90a3b101ecdc85ff4.TXT ### 5/3/2022 11:32:06 AM
5/3/2022 11:32:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:06 AM : Import IN File --->> IN_365_20210721_9f48d158a53ed7eff69382687486df59.TXT ### 5/3/2022 11:32:06 AM
5/3/2022 11:32:06 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210723_801ff12693d7ac9d6dc2b84e6b0c9eaf.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210726_0d17c261b060e531db744835a335c73e.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::5
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210728_2b785996337b3539b213ffe199023faf.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210729_b6ef22e38f0f2b90ed07f887ccf34fae.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210802_d9952bdbec9e90c7b5a80cef85ef8387.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::4
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210803_87445cf7bc31dd42b4ed0c46674a53a3.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210804_ae81792265ff6ac1518f68c8ee854b9e.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210806_b582ff78437c661d75b063d6da0f0861.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::5
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210809_a7104d586f8cffef40ad4568e857d1ae.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210810_c88f4ef790ed9bbf6d89bc21932f63f0.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::7
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210811_b47d4ef99b32cf4a5389feabf7997526.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210815_7e351bc4f34c5956a470e90b1e946f49.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210816_6f874a2375a837f3e654c12c6d410443.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::8
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210817_9abe034ba9155ea357e224efe054e94b.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210819_f2809e46fe1f7eaea460835424336da3.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210821_2ea0d8430b875a334b3ad797360305ef.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210823_d31c26995829227d6cd169f424f17b67.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210824_0c54ed01867b74433d1159b87aa646e6.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210825_98c181e7569a73817a85b43860dc101c.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::5
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210826_0e558fb42ead368e825ca5f7c19b465e.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210828_496603ae95b7b5b56df4c98eecac049a.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210829_f2711ffff8d1b44c1bf41e021451f3ae.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210901_69960e55e6e293c2cc2b38f40f3af246.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::6
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210902_2188667ed64719b01456aef71c821026.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::4
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210904_60c52deb3bd9433af2f078c33bade0b7.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210906_3ebcf8e33e8ebf41fd34181c5f3b9910.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210909_0eb7475bb90e777601137bb75bf1953e.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210910_863d254102f4523839afe516fb0856a4.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210913_f864a415ec03ec23846f56f29515f040.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210915_5c5a751867ddb8d29e5b4681bd775970.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210918_66993fba72fddbf62ae451927c853340.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210921_68f98530ebd25d7013b7763d2a773340.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210922_357745443af3d8e45746e8f49d5f0512.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:07 AM : Import IN File --->> IN_365_20210923_93a43026da5e5538ac8e4a20837a2fc9.TXT ### 5/3/2022 11:32:07 AM
5/3/2022 11:32:07 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20210928_3cd5fb43f6994a858d1fe3e042d4fdda.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::6
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211001_170763a57bd08f4a777a007b222f024e.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211004_1e0c48f03bf2fa57cd193a1bc95fbb2d.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211005_8b3f2e9ef180b0a6c4c81d40e7a4ace6.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211006_ba91d94f403f8017c46a565083ad5fae.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211008_b394fb038b1a77d402d902928d735fbf.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211009_2ebb7858cfc2e6157fa2bc6bbc524f25.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211010_ed4073bb7f767b9001d7ca9738f50321.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211011_bb4a29b4b031146eb5cc94888ab814a5.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211012_c174b84e52537ff0739d5f11321ddcc4.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::4
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211020_53fcc22388df5117a0e8f1e4f62adb7c.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211021_0ca529b428e69d8daaa9c6ff27d3aedd.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211022_392341a885c3ac3f6c63de23871b0890.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::5
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211023_7cadf2fb1464de778f9d30e9de411777.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211025_4922c454973abdc5683892573feb1690.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211026_ed588004202ce47db83daf2c6ebf361b.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::4
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211027_30d95640af51cf6e65d4d1e076f2bdd9.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211028_3f4fe6edd5ac3849ce82450ff9aca4f8.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211101_a68efd7ce096cf35b7cd8e6b0ab9de2a.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211102_0f88862246092a80eafb61b041a680e3.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211107_f5a7843b233d6dc504e30358e12f0b65.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211111_1dc1a89eeffef2d256a100d7cc20733e.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211113_bf1e0f6ff73f78791d37fe8f6109c1fb.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::5
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211117_fedc4b0df38441155c9fdf790f5258c3.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211120_aa9c2fa92a9c56b1733238382cbac8ff.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211123_bd96d50c1e9bf9c6ec79ce3b3026bd29.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211126_09d42e4e55ddddc711ee65a44d60987c.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211129_7c4d11a8d39cc2c38c616fdc89b76f41.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::5
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211130_3487583be7e6db543d2bda8221cf8183.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:08 AM : Import IN File --->> IN_365_20211202_0db38713aec7d29b22c8c634625eff98.TXT ### 5/3/2022 11:32:08 AM
5/3/2022 11:32:08 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:09 AM : Import IN File --->> IN_365_20211204_5ccbd0ae93dd1f2ad92e185566c17bb3.TXT ### 5/3/2022 11:32:09 AM
5/3/2022 11:32:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:32:09 AM : Import IN File --->> IN_365_20211211_7f063109f9b560339c366d368c81323a.TXT ### 5/3/2022 11:32:09 AM
5/3/2022 11:32:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:09 AM : Import IN File --->> IN_365_20211216_f2630515a3548d2e54ecb73fea306dc4.TXT ### 5/3/2022 11:32:09 AM
5/3/2022 11:32:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:09 AM : Import IN File --->> IN_365_20211218_76c8d1ea506c64ba0dca6cce7819de7a.TXT ### 5/3/2022 11:32:09 AM
5/3/2022 11:32:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:09 AM : Import IN File --->> IN_365_20211222_a832dcc5103a2864ee2dcbf52c953136.TXT ### 5/3/2022 11:32:09 AM
5/3/2022 11:32:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:32:09 AM : Import IN File --->> IN_365_20211227_916a1690b936abca9374d0bc99554230.TXT ### 5/3/2022 11:32:09 AM
5/3/2022 11:32:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::6
5/3/2022 11:32:09 AM : Import IN File --->> IN_365_20211228_c586137248fffdc3e4bc00585dfbe2ab.TXT ### 5/3/2022 11:32:09 AM
5/3/2022 11:32:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:09 AM : Import IN File --->> IN_365_20211231_f6bda78a5eef73882056fcb7346ea5a0.TXT ### 5/3/2022 11:32:09 AM
5/3/2022 11:32:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:32:09 AM : Import IN File --->> IN_365_20220106_8ec77d8ea24b0e870c3d76600ecdd904.TXT ### 5/3/2022 11:32:09 AM
5/3/2022 11:32:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:09 AM : Import IN File --->> IN_365_20220108_88ba79a113c71b551031571960c04266.TXT ### 5/3/2022 11:32:09 AM
5/3/2022 11:32:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::4
5/3/2022 11:32:09 AM : Import IN File --->> IN_365_20220121_8db5b29a1a1b1389b0b1855c622d9747.TXT ### 5/3/2022 11:32:09 AM
5/3/2022 11:32:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:09 AM : Import IN File --->> IN_365_20220208_61f011e99894720e3d8a25748e235ad8.TXT ### 5/3/2022 11:32:09 AM
5/3/2022 11:32:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:09 AM : Import IN File --->> IN_365_20220209_e81d37ca0c7fce5efd7ae30940d7a25c.TXT ### 5/3/2022 11:32:09 AM
5/3/2022 11:32:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:09 AM : Import IN File --->> IN_365_20220214_27058a9785eb7da89582443873486732.TXT ### 5/3/2022 11:32:09 AM
5/3/2022 11:32:09 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:10 AM : Import IN File --->> IN_365_20220227_ac081cc1c94574687deb20d60c74eb6c.TXT ### 5/3/2022 11:32:10 AM
5/3/2022 11:32:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::3
5/3/2022 11:32:10 AM : Import IN File --->> IN_365_20220303_ec3682e7262f7e279052bca4c9b0a89e.TXT ### 5/3/2022 11:32:10 AM
5/3/2022 11:32:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:10 AM : Import IN File --->> IN_365_20220307_c1dbbacbde1a8115af3beb412b531d2f.TXT ### 5/3/2022 11:32:10 AM
5/3/2022 11:32:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::1
5/3/2022 11:32:10 AM : Import IN File --->> IN_365_20220316_a7f52833e94efd1d01a3cdfe3fc31ac3.TXT ### 5/3/2022 11:32:10 AM
5/3/2022 11:32:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::2
5/3/2022 11:32:10 AM : Import IN File --->> IN_365_20220323_1e6a3455c9c8f3fab235718520b0b28e.TXT ### 5/3/2022 11:32:10 AM
5/3/2022 11:32:10 AM : NO Previous File For Distributor 000000000000365 ### Insert Count::7
5/3/2022 11:32:10 AM : command:: flagImportPosting =  ### True
5/3/2022 11:32:10 AM : command:: minDate =  ### 4/1/2021 12:00:00 AM
5/3/2022 11:32:12 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 5/3/2022 11:32:12 AM
5/3/2022 11:32:13 AM : CustomerLink Diff Successful --->>  ### 5/3/2022 11:32:13 AM
5/3/2022 11:32:13 AM : ItemLink Diff Successful --->>  ### 5/3/2022 11:32:13 AM
5/3/2022 11:32:13 AM : Supplierlink Query Successful --->>  ### 5/3/2022 11:32:13 AM
5/3/2022 11:32:13 AM : Posting Purchases 'true' Successful --->>  ### 5/3/2022 11:32:13 AM
5/3/2022 11:32:14 AM : Posting OtherTransaction 'true' Successful --->>  ### 5/3/2022 11:32:14 AM
5/3/2022 11:32:19 AM : Posting Sales 'true' Successful --->>  ### 5/3/2022 11:32:19 AM
5/3/2022 11:32:21 AM : Completed Updating Has Transaction Flag  ### 5/3/2022 11:32:21 AM
5/3/2022 11:32:21 AM : command :: PostDataDeleteInsert  ###  Done 
5/3/2022 11:32:21 AM : command :: set DiffCutOffDate  ###  Done 
5/3/2022 11:32:21 AM : End Process : ImportSplittedFilesOldDeleteInsert()  ### 

5/3/2022 11:32:21 AM : Import End Time (NEW) Awadh Krishi Kendra(9062642) ### 5/3/2022 11:32:21 AM
5/3/2022 11:32:21 AM : -------------Import One Distributor End Time----------- ### 5/3/2022 11:32:21 AM
5/3/2022 2:30:01 PM : 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/3/2022 2:30:02 PM : StartProcess  ### 5/3/2022 2:30:02 PM

5/3/2022 2:30:02 PM : 11  ### 5/3/2022 2:30:02 PM

5/3/2022 2:30:02 PM : 22  ### 5/3/2022 2:30:02 PM

5/3/2022 2:30:02 PM : 33  ### 5/3/2022 2:30:02 PM

5/3/2022 2:30:02 PM : Application Started  ### 5/3/2022 2:30:02 PM

5/3/2022 2:30:02 PM : Start Process : checkAllTablesExists()  ### 
5/3/2022 2:30:02 PM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 5/3/2022 2:30:02 PM
5/3/2022 2:30:02 PM : MainForm_Load  ### AlertSystem ON
5/3/2022 2:30:02 PM : No. of Files to import (RECEIVEFINAL):  ### 1074
5/3/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
5/3/2022 2:30:03 PM : For Distributor 000000000001025 Insert Count::1 ### Delete Count::15
5/3/2022 2:30:03 PM : Import AD File --->> AD_1025_20220503_4b1559c4c3d442d6cc65e1525819e731.TXT ### 5/3/2022 2:30:03 PM
5/3/2022 2:30:03 PM : For Distributor 000000000000353 Insert Count::1 ### Delete Count::18
5/3/2022 2:30:03 PM : Import AD File --->> AD_353_20220503_8033df658d62c59b8b0c7532e2e04797.TXT ### 5/3/2022 2:30:03 PM
5/3/2022 2:30:05 PM : For Distributor 000000000001025 Insert Count::1 ### Delete Count::0
5/3/2022 2:30:05 PM : Import DN File --->> DN_1025_20220420_8fe0908127857d6b17288de7f639ec8d.TXT ### 5/3/2022 2:30:05 PM
5/3/2022 2:30:32 PM : For Distributor 000000000001025 Insert Count::1 ### Delete Count::0
5/3/2022 2:30:32 PM : Import IN File --->> IN_1025_20220404_8148b006e638d880069e89d498f6f8a0.TXT ### 5/3/2022 2:30:32 PM
5/3/2022 2:30:32 PM : For Distributor 000000000001025 Insert Count::1 ### Delete Count::0
5/3/2022 2:30:32 PM : Import IN File --->> IN_1025_20220405_aa06684d83fd408d17d979034ac1deaf.TXT ### 5/3/2022 2:30:32 PM
5/3/2022 2:30:32 PM : For Distributor 000000000001025 Insert Count::1 ### Delete Count::0
5/3/2022 2:30:32 PM : Import IN File --->> IN_1025_20220409_f476369f2b533f9e033b6a56a04e6c35.TXT ### 5/3/2022 2:30:32 PM
5/3/2022 2:30:32 PM : For Distributor 000000000001025 Insert Count::1 ### Delete Count::0
5/3/2022 2:30:32 PM : Import IN File --->> IN_1025_20220412_5f19510e6334ee2399455db15e1e8547.TXT ### 5/3/2022 2:30:32 PM
5/3/2022 2:30:33 PM : For Distributor 000000000001025 Insert Count::1 ### Delete Count::0
5/3/2022 2:30:33 PM : Import IN File --->> IN_1025_20220418_e60e64be9fbba2d29feeab0c644c06d3.TXT ### 5/3/2022 2:30:33 PM
5/3/2022 2:30:33 PM : For Distributor 000000000001025 Insert Count::1 ### Delete Count::0
5/3/2022 2:30:33 PM : Import IN File --->> IN_1025_20220422_ad7bff71b9b4a8b5a9c77c11f7fa006d.TXT ### 5/3/2022 2:30:33 PM
5/3/2022 2:30:36 PM : For Distributor 000000000001026 Insert Count::4 ### Delete Count::0
5/3/2022 2:30:36 PM : Import IN File --->> IN_1026_20220503_32508343f4052b603d55ae9a071f479d.TXT ### 5/3/2022 2:30:36 PM
5/3/2022 2:30:37 PM : For Distributor 000000000000353 Insert Count::1 ### Delete Count::1
5/3/2022 2:30:37 PM : Import IN File --->> IN_353_20220418_adf9f4d67eeb2a9535fc4daacffe2e65.TXT ### 5/3/2022 2:30:37 PM
5/3/2022 2:30:38 PM : For Distributor 000000000000353 Insert Count::6 ### Delete Count::4
5/3/2022 2:30:38 PM : Import IN File --->> IN_353_20220425_d0305e626365a2f681a179c5d28f1915.TXT ### 5/3/2022 2:30:38 PM
5/3/2022 2:30:38 PM : For Distributor 000000000000353 Insert Count::7 ### Delete Count::0
5/3/2022 2:30:38 PM : Import IN File --->> IN_353_20220430_a73a7eddfb779f65d46b59e4392c7bb0.TXT ### 5/3/2022 2:30:38 PM
5/3/2022 2:30:41 PM : For Distributor 000000000000360 Insert Count::5 ### Delete Count::0
5/3/2022 2:30:41 PM : Import IN File --->> IN_360_20220502_9fe850b3b5178ea6914f1e5a66e15f02.TXT ### 5/3/2022 2:30:41 PM
5/3/2022 2:30:41 PM : Import IN File --->> IN_360_20220503_acd24f14335befe95719f4b8177d0738.TXT ### 5/3/2022 2:30:41 PM
5/3/2022 2:30:41 PM : NO Previous File For Distributor 000000000000360 ### Insert Count::1
5/3/2022 2:31:09 PM : For Distributor 000000000000424 Insert Count::3 ### Delete Count::0
5/3/2022 2:31:09 PM : Import IN File --->> IN_424_20220503_cc4420c212f8b0df82dd5863d7493b09.TXT ### 5/3/2022 2:31:09 PM
5/3/2022 2:31:18 PM : PostData() --->>  ### 5/3/2022 2:31:18 PM
5/3/2022 2:31:19 PM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 5/3/2022 2:31:19 PM
5/3/2022 2:31:20 PM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '03/May/2022' ### 5/3/2022 2:31:20 PM
5/3/2022 2:31:21 PM : ItemLink Successful --->> exec SP_ItemLinkDiff '03/May/2022' ### 5/3/2022 2:31:21 PM
5/3/2022 2:31:21 PM :  ### 
5/3/2022 2:31:21 PM : UNLINKEDSALES Record Count Before --->> 33 ### 5/3/2022 2:31:21 PM
5/3/2022 2:31:21 PM : UNLINKEDSALES_DEL Record Count Before --->> 5 ### 5/3/2022 2:31:21 PM
5/3/2022 3:04:53 PM : Posting Sales Successful --->> exec prPostLinkedDiffSales '03/May/2022' ### 5/3/2022 3:04:53 PM
5/3/2022 3:04:53 PM : UNLINKEDSALES Record Count After --->> 0 ### 5/3/2022 3:04:53 PM
5/3/2022 3:04:53 PM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 5/3/2022 3:04:53 PM
5/3/2022 3:04:53 PM :  ### 
5/3/2022 3:04:53 PM : Posting Supplierlink Query for Purchases --->>  ### 5/3/2022 3:04:53 PM
5/3/2022 3:04:59 PM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '03/May/2022' ### 5/3/2022 3:04:59 PM
5/3/2022 3:05:07 PM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '03/May/2022' ### 5/3/2022 3:05:07 PM
5/3/2022 3:05:07 PM : Posting Supplierlink Query for CompanyPurchases --->>  ### 5/3/2022 3:05:07 PM
5/3/2022 3:05:07 PM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '03/May/2022' ### 5/3/2022 3:05:07 PM
5/3/2022 3:05:07 PM : Posting ClosingStock Successful --->>  ### 5/3/2022 3:05:07 PM
5/3/2022 3:05:07 PM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 5/3/2022 3:05:07 PM
5/3/2022 3:05:07 PM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
5/3/2022 3:05:07 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1123438_TEMPLATE1.TXT ### 5/3/2022 3:05:07 PM
5/3/2022 3:05:07 PM : Count:: ### TEMPLATE1:57
5/3/2022 3:05:11 PM : SP_DistributorTemplatePosting Successful --->>  ### 5/3/2022 3:05:11 PM
5/3/2022 3:05:11 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 5/3/2022 3:05:11 PM
5/3/2022 3:05:11 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 3:05:11 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 5/3/2022 3:05:11 PM
5/3/2022 3:05:11 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 3:05:11 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 5/3/2022 3:05:11 PM
5/3/2022 3:05:11 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 3:05:11 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 5/3/2022 3:05:11 PM
5/3/2022 3:05:11 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 3:05:11 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 5/3/2022 3:05:11 PM
5/3/2022 3:05:11 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 3:05:11 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 5/3/2022 3:05:11 PM
5/3/2022 3:05:11 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 3:05:11 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 5/3/2022 3:05:11 PM
5/3/2022 3:05:11 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 3:05:11 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 5/3/2022 3:05:11 PM
5/3/2022 3:05:11 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 3:05:11 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3831146_TEMPLATE1.TXT ### 5/3/2022 3:05:11 PM
5/3/2022 3:05:11 PM : Count:: ### TEMPLATE1:141
5/3/2022 3:05:17 PM : SP_DistributorTemplatePosting Successful --->>  ### 5/3/2022 3:05:17 PM
5/3/2022 3:05:17 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 5/3/2022 3:05:17 PM
5/3/2022 3:05:17 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 3:05:17 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 5/3/2022 3:05:17 PM
5/3/2022 3:05:17 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 3:05:17 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 5/3/2022 3:05:17 PM
5/3/2022 3:05:17 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 3:05:17 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 5/3/2022 3:05:17 PM
5/3/2022 3:05:17 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 3:05:17 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060542_TEMPLATE1.TXT ### 5/3/2022 3:05:17 PM
5/3/2022 3:05:17 PM : Count:: ### TEMPLATE1:32
5/3/2022 3:05:17 PM : SP_DistributorTemplatePosting Successful --->>  ### 5/3/2022 3:05:17 PM
5/3/2022 3:05:17 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060893_TEMPLATE1.txt ### 5/3/2022 3:05:17 PM
5/3/2022 3:05:17 PM : Count:: ### TEMPLATE1:63
5/3/2022 3:05:26 PM : SP_DistributorTemplatePosting Successful --->>  ### 5/3/2022 3:05:26 PM
5/3/2022 3:05:26 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 5/3/2022 3:05:26 PM
5/3/2022 3:05:26 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 3:05:26 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 5/3/2022 3:05:26 PM
5/3/2022 3:05:26 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 3:05:26 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 5/3/2022 3:05:26 PM
5/3/2022 3:05:26 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 3:05:26 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062642_TEMPLATE1.txt ### 5/3/2022 3:05:26 PM
5/3/2022 3:05:26 PM : Count:: ### TEMPLATE1:60
5/3/2022 3:05:30 PM : SP_DistributorTemplatePosting Successful --->>  ### 5/3/2022 3:05:30 PM
5/3/2022 3:05:30 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 5/3/2022 3:05:30 PM
5/3/2022 3:05:30 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 3:05:30 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 5/3/2022 3:05:30 PM
5/3/2022 3:05:30 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 3:05:30 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067122_TEMPLATE1.TXT ### 5/3/2022 3:05:30 PM
5/3/2022 3:05:30 PM : Count:: ### TEMPLATE1:33
5/3/2022 3:05:34 PM : SP_DistributorTemplatePosting Successful --->>  ### 5/3/2022 3:05:34 PM
5/3/2022 3:05:34 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_948223_TEMPLATE1.TXT ### 5/3/2022 3:05:34 PM
5/3/2022 3:05:35 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
5/3/2022 3:05:35 PM : Template Import Complete  ### 5/3/2022 3:05:35 PM
5/3/2022 3:05:37 PM : Completed Updating Has Transaction Flag  ### 5/3/2022 3:05:37 PM
5/3/2022 3:05:37 PM : Transaction Table lastEdiDate Update on BrandAlias Update ### 5/3/2022 3:05:37 PM
5/3/2022 3:05:37 PM : Zylem Access Unblocked  ### 5/3/2022 3:05:37 PM
5/3/2022 3:05:38 PM : Application Ended  ### 5/3/2022 3:05:38 PM