4/27/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 4/27/2022 2:30:05 AM : StartProcess ### 4/27/2022 2:30:05 AM 4/27/2022 2:30:05 AM : 11 ### 4/27/2022 2:30:05 AM 4/27/2022 2:30:05 AM : 22 ### 4/27/2022 2:30:05 AM 4/27/2022 2:30:05 AM : 33 ### 4/27/2022 2:30:05 AM 4/27/2022 2:30:05 AM : Application Started ### 4/27/2022 2:30:05 AM 4/27/2022 2:30:05 AM : Start Process : checkAllTablesExists() ### 4/27/2022 2:30:05 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 4/27/2022 2:30:05 AM 4/27/2022 2:30:05 AM : MainForm_Load ### AlertSystem ON 4/27/2022 2:30:05 AM : No. of Files to import (RECEIVEFINAL): ### 1 4/27/2022 2:30:05 AM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 4/27/2022 2:30:05 AM : PostData() --->> ### 4/27/2022 2:30:05 AM 4/27/2022 2:30:05 AM : SP_CreateUnkCustomerUnkItem Successful --->> ### 4/27/2022 2:30:05 AM 4/27/2022 2:30:06 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '27/Apr/2022' ### 4/27/2022 2:30:06 AM 4/27/2022 2:30:06 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '27/Apr/2022' ### 4/27/2022 2:30:06 AM 4/27/2022 2:30:06 AM : ### 4/27/2022 2:30:06 AM : UNLINKEDSALES Record Count Before --->> 0 ### 4/27/2022 2:30:06 AM 4/27/2022 2:30:06 AM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 4/27/2022 2:30:06 AM 4/27/2022 2:30:14 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '27/Apr/2022' ### 4/27/2022 2:30:14 AM 4/27/2022 2:30:14 AM : UNLINKEDSALES Record Count After --->> 0 ### 4/27/2022 2:30:14 AM 4/27/2022 2:30:14 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 4/27/2022 2:30:14 AM 4/27/2022 2:30:14 AM : ### 4/27/2022 2:30:14 AM : Posting Supplierlink Query for Purchases --->> ### 4/27/2022 2:30:14 AM 4/27/2022 2:30:20 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '27/Apr/2022' ### 4/27/2022 2:30:20 AM 4/27/2022 2:30:26 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '27/Apr/2022' ### 4/27/2022 2:30:26 AM 4/27/2022 2:30:26 AM : Posting Supplierlink Query for CompanyPurchases --->> ### 4/27/2022 2:30:26 AM 4/27/2022 2:30:26 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '27/Apr/2022' ### 4/27/2022 2:30:26 AM 4/27/2022 2:30:27 AM : Posting ClosingStock Successful --->> ### 4/27/2022 2:30:27 AM 4/27/2022 2:30:27 AM : FileWiseHashCode Updated for FlagImport=true records --->> ### 4/27/2022 2:30:27 AM 4/27/2022 2:30:27 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\ 4/27/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 4/27/2022 2:30:27 AM 4/27/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 4/27/2022 2:30:27 AM 4/27/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 4/27/2022 2:30:27 AM 4/27/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 4/27/2022 2:30:27 AM 4/27/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 4/27/2022 2:30:27 AM 4/27/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 4/27/2022 2:30:27 AM 4/27/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 4/27/2022 2:30:27 AM 4/27/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 4/27/2022 2:30:27 AM 4/27/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 4/27/2022 2:30:27 AM 4/27/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 4/27/2022 2:30:27 AM 4/27/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 4/27/2022 2:30:27 AM 4/27/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 4/27/2022 2:30:27 AM 4/27/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 4/27/2022 2:30:27 AM 4/27/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 4/27/2022 2:30:27 AM 4/27/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 4/27/2022 2:30:27 AM 4/27/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 4/27/2022 2:30:27 AM 4/27/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 4/27/2022 2:30:27 AM 4/27/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:30:27 AM : Template Import Complete ### 4/27/2022 2:30:27 AM 4/27/2022 2:30:31 AM : Completed Updating Has Transaction Flag ### 4/27/2022 2:30:31 AM 4/27/2022 2:30:31 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 4/27/2022 2:30:31 AM 4/27/2022 2:30:31 AM : Zylem Access Unblocked ### 4/27/2022 2:30:31 AM 4/27/2022 2:30:31 AM : Application Ended ### 4/27/2022 2:30:31 AM 4/27/2022 7:30:02 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 4/27/2022 7:30:03 AM : StartProcess ### 4/27/2022 7:30:03 AM 4/27/2022 7:30:03 AM : 11 ### 4/27/2022 7:30:03 AM 4/27/2022 7:30:03 AM : 22 ### 4/27/2022 7:30:03 AM 4/27/2022 7:30:03 AM : 33 ### 4/27/2022 7:30:03 AM 4/27/2022 7:30:03 AM : Application Started ### 4/27/2022 7:30:03 AM 4/27/2022 7:30:03 AM : Start Process : checkAllTablesExists() ### 4/27/2022 7:30:03 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 4/27/2022 7:30:03 AM 4/27/2022 7:30:04 AM : MainForm_Load ### AlertSystem ON 4/27/2022 7:30:04 AM : No. of Files to import (RECEIVEFINAL): ### 1380 4/27/2022 7:30:04 AM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 4/27/2022 7:30:04 AM : For Distributor 000000000001026 Insert Count::1 ### Delete Count::0 4/27/2022 7:30:04 AM : Import AD File --->> AD_1026_20220427_c23c9ebbadb33e870a2e9a38b8d874da.TXT ### 4/27/2022 7:30:04 AM 4/27/2022 7:30:05 AM : For Distributor 000000000000011 Insert Count::4 ### Delete Count::1 4/27/2022 7:30:05 AM : Import AD File --->> AD_11_20220427_d1cd2b08ea30584fc91251c560d5f92f.TXT ### 4/27/2022 7:30:05 AM 4/27/2022 7:30:05 AM : For Distributor 000000000001316 Insert Count::3 ### Delete Count::0 4/27/2022 7:30:05 AM : Import AD File --->> AD_1316_20220427_486b107095bc11fab9d18b4bd1f8c74c.TXT ### 4/27/2022 7:30:05 AM 4/27/2022 7:30:05 AM : For Distributor 000000000000362 Insert Count::1 ### Delete Count::0 4/27/2022 7:30:05 AM : Import AD File --->> AD_362_20220427_05a0906171a0eca74865735faf2b7709.TXT ### 4/27/2022 7:30:05 AM 4/27/2022 7:30:06 AM : For Distributor 000000000000366 Insert Count::4 ### Delete Count::1 4/27/2022 7:30:06 AM : Import AD File --->> AD_366_20220427_af8fd9c68f669c3257ea246de8acd320.TXT ### 4/27/2022 7:30:06 AM 4/27/2022 7:30:06 AM : For Distributor 000000000000424 Insert Count::1 ### Delete Count::1 4/27/2022 7:30:06 AM : Import AD File --->> AD_424_20220427_cedf26ec776c88c401501c19673ba4c3.TXT ### 4/27/2022 7:30:06 AM 4/27/2022 7:30:07 AM : For Distributor 000000000000492 Insert Count::1 ### Delete Count::0 4/27/2022 7:30:07 AM : Import AD File --->> AD_492_20220427_50e1c93f9f32bc0ae1e8fc60f0378df3.TXT ### 4/27/2022 7:30:07 AM 4/27/2022 7:30:07 AM : For Distributor 000000000000809 Insert Count::5 ### Delete Count::0 4/27/2022 7:30:07 AM : Import AD File --->> AD_809_20220427_f7cc37c6ec0e88b1a2084cc9bfafd8c6.TXT ### 4/27/2022 7:30:07 AM 4/27/2022 7:30:07 AM : For Distributor 000000000000810 Insert Count::2 ### Delete Count::0 4/27/2022 7:30:07 AM : Import AD File --->> AD_810_20220427_467cc2e0f6988071b66388d18de754d0.TXT ### 4/27/2022 7:30:07 AM 4/27/2022 7:30:08 AM : For Distributor 000000000000820 Insert Count::4 ### Delete Count::0 4/27/2022 7:30:08 AM : Import AD File --->> AD_820_20220427_2d47c3c05f9423328424966c6f49492f.TXT ### 4/27/2022 7:30:08 AM 4/27/2022 7:30:18 AM : For Distributor 000000000001324 Insert Count::2 ### Delete Count::0 4/27/2022 7:30:18 AM : Import DN File --->> DN_1324_20220421_fc783a8108b978cf39e6f74d2bb2e938.TXT ### 4/27/2022 7:30:18 AM 4/27/2022 7:30:23 AM : For Distributor 000000000000362 Insert Count::1 ### Delete Count::0 4/27/2022 7:30:23 AM : Import DN File --->> DN_362_20220418_eafaba01ef7eec2b8f527ab0e0f8c2d2.TXT ### 4/27/2022 7:30:23 AM 4/27/2022 7:31:04 AM : For Distributor 000000000001026 Insert Count::1 ### Delete Count::0 4/27/2022 7:31:04 AM : Import IN File --->> IN_1026_20220426_c11a3adf9a769befa1ab2106c1050635.TXT ### 4/27/2022 7:31:04 AM 4/27/2022 7:31:06 AM : For Distributor 000000000000011 Insert Count::0 ### Delete Count::2 4/27/2022 7:31:06 AM : Import IN File --->> IN_11_20220422_6023808e368b1f44ca5c3f24afd05f3b.TXT ### 4/27/2022 7:31:06 AM 4/27/2022 7:31:06 AM : For Distributor 000000000000011 Insert Count::5 ### Delete Count::0 4/27/2022 7:31:06 AM : Import IN File --->> IN_11_20220426_cd5af6153291a23ef4693cb1beb614da.TXT ### 4/27/2022 7:31:06 AM 4/27/2022 7:31:09 AM : For Distributor 000000000001316 Insert Count::3 ### Delete Count::0 4/27/2022 7:31:09 AM : Import IN File --->> IN_1316_20220426_c7d6120c79925a6c20ad5a67492c7055.TXT ### 4/27/2022 7:31:09 AM 4/27/2022 7:31:09 AM : Import IN File --->> IN_1316_20220427_1de19b8f2f0504ee7295bc6843404bf5.TXT ### 4/27/2022 7:31:09 AM 4/27/2022 7:31:09 AM : NO Previous File For Distributor 000000000001316 ### Insert Count::2 4/27/2022 7:31:13 AM : For Distributor 000000000001324 Insert Count::1 ### Delete Count::0 4/27/2022 7:31:13 AM : Import IN File --->> IN_1324_20220419_54312425d035c2858b8d60a161306873.TXT ### 4/27/2022 7:31:13 AM 4/27/2022 7:31:13 AM : For Distributor 000000000001324 Insert Count::7 ### Delete Count::0 4/27/2022 7:31:13 AM : Import IN File --->> IN_1324_20220420_ee9ec32f6e35855a24ab36c60f593e1e.TXT ### 4/27/2022 7:31:13 AM 4/27/2022 7:31:13 AM : For Distributor 000000000001324 Insert Count::1 ### Delete Count::0 4/27/2022 7:31:13 AM : Import IN File --->> IN_1324_20220421_3ebd338e38b700212fa8e302f8c7f427.TXT ### 4/27/2022 7:31:13 AM 4/27/2022 7:31:13 AM : For Distributor 000000000001324 Insert Count::7 ### Delete Count::0 4/27/2022 7:31:13 AM : Import IN File --->> IN_1324_20220423_ced07d0758516c6926e8b37220c0618f.TXT ### 4/27/2022 7:31:13 AM 4/27/2022 7:31:18 AM : For Distributor 000000000000366 Insert Count::0 ### Delete Count::2 4/27/2022 7:31:18 AM : Import IN File --->> IN_366_20220425_050a25bcd163d47f4b20a075f4be443f.TXT ### 4/27/2022 7:31:18 AM 4/27/2022 7:31:18 AM : For Distributor 000000000000366 Insert Count::9 ### Delete Count::0 4/27/2022 7:31:18 AM : Import IN File --->> IN_366_20220426_bf56922bfdd475ca901f317901d39529.TXT ### 4/27/2022 7:31:18 AM 4/27/2022 7:31:21 AM : For Distributor 000000000000371 Insert Count::1 ### Delete Count::0 4/27/2022 7:31:21 AM : Import IN File --->> IN_371_20220426_e629d7e46079225ce2942b7dcdf120d6.TXT ### 4/27/2022 7:31:21 AM 4/27/2022 7:31:22 AM : For Distributor 000000000000424 Insert Count::2 ### Delete Count::2 4/27/2022 7:31:22 AM : Import IN File --->> IN_424_20220322_280baa2057f0ed36bad849694163863f.TXT ### 4/27/2022 7:31:22 AM 4/27/2022 7:31:22 AM : For Distributor 000000000000424 Insert Count::2 ### Delete Count::2 4/27/2022 7:31:22 AM : Import IN File --->> IN_424_20220326_3a95af26afebd2814c2531e997aebdc6.TXT ### 4/27/2022 7:31:22 AM 4/27/2022 7:31:22 AM : For Distributor 000000000000424 Insert Count::3 ### Delete Count::3 4/27/2022 7:31:22 AM : Import IN File --->> IN_424_20220331_db92d991864eafe69e21294ee8bfd6e3.TXT ### 4/27/2022 7:31:22 AM 4/27/2022 7:31:25 AM : Exception ### Index was outside the bounds of the array. 4/27/2022 7:31:25 AM : Error ### Index was outside the bounds of the array. Line 4/27/2022 7:31:26 AM : For Distributor 000000000000492 Insert Count::3 ### Delete Count::0 4/27/2022 7:31:26 AM : Import IN File --->> IN_492_20220426_dacd10d1f6b7b14c9437a5684a203bdb.TXT ### 4/27/2022 7:31:26 AM 4/27/2022 7:31:26 AM : Import IN File --->> IN_492_20220427_d90c91851de66bbbd6ee355f337075c5.TXT ### 4/27/2022 7:31:26 AM 4/27/2022 7:31:26 AM : NO Previous File For Distributor 000000000000492 ### Insert Count::1 4/27/2022 7:31:28 AM : For Distributor 000000000000809 Insert Count::16 ### Delete Count::0 4/27/2022 7:31:28 AM : Import IN File --->> IN_809_20220426_4b1f9c74236152b11572e39ca5bce56a.TXT ### 4/27/2022 7:31:28 AM 4/27/2022 7:31:28 AM : Import IN File --->> IN_809_20220427_0a747475867dd92c21c6a482ac0ecd02.TXT ### 4/27/2022 7:31:28 AM 4/27/2022 7:31:28 AM : NO Previous File For Distributor 000000000000809 ### Insert Count::1 4/27/2022 7:31:29 AM : For Distributor 000000000000810 Insert Count::2 ### Delete Count::2 4/27/2022 7:31:29 AM : Import IN File --->> IN_810_20220301_3b2c377f4a8216bdb8aa534ce563f479.TXT ### 4/27/2022 7:31:29 AM 4/27/2022 7:31:31 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::1 4/27/2022 7:31:31 AM : Import IN File --->> IN_810_20220422_77767197937965c9cdbca702fb0c12fe.TXT ### 4/27/2022 7:31:31 AM 4/27/2022 7:31:31 AM : For Distributor 000000000000810 Insert Count::18 ### Delete Count::0 4/27/2022 7:31:31 AM : Import IN File --->> IN_810_20220426_ea799d2da28f89bbc76b93d52685c0d2.TXT ### 4/27/2022 7:31:31 AM 4/27/2022 7:31:33 AM : For Distributor 000000000000820 Insert Count::1 ### Delete Count::0 4/27/2022 7:31:33 AM : Import IN File --->> IN_820_20220426_646b051c8042ed8911db5c8ae1b06ed2.TXT ### 4/27/2022 7:31:33 AM 4/27/2022 7:31:33 AM : Import IN File --->> IN_820_20220427_150c2423aea0b6a0822e81a0b4ea5d7d.TXT ### 4/27/2022 7:31:33 AM 4/27/2022 7:31:33 AM : NO Previous File For Distributor 000000000000820 ### Insert Count::9 4/27/2022 7:31:38 AM : For Distributor 000000000000355 Insert Count::0 ### Delete Count::13 4/27/2022 7:31:38 AM : Import PR File --->> PR_355_20220427_ca48d0218999745bf54069bdd9d41337.TXT ### 4/27/2022 7:31:38 AM 4/27/2022 7:31:38 AM : PostData() --->> ### 4/27/2022 7:31:38 AM 4/27/2022 7:31:42 AM : SP_CreateUnkCustomerUnkItem Successful --->> ### 4/27/2022 7:31:42 AM 4/27/2022 7:31:46 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '27/Apr/2022' ### 4/27/2022 7:31:46 AM 4/27/2022 7:31:46 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '27/Apr/2022' ### 4/27/2022 7:31:46 AM 4/27/2022 7:31:46 AM : ### 4/27/2022 7:31:46 AM : UNLINKEDSALES Record Count Before --->> 95 ### 4/27/2022 7:31:46 AM 4/27/2022 7:31:46 AM : UNLINKEDSALES_DEL Record Count Before --->> 14 ### 4/27/2022 7:31:46 AM 4/27/2022 7:31:55 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '27/Apr/2022' ### 4/27/2022 7:31:55 AM 4/27/2022 7:31:55 AM : UNLINKEDSALES Record Count After --->> 0 ### 4/27/2022 7:31:55 AM 4/27/2022 7:31:55 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 4/27/2022 7:31:55 AM 4/27/2022 7:31:55 AM : ### 4/27/2022 7:31:55 AM : Posting Supplierlink Query for Purchases --->> ### 4/27/2022 7:31:55 AM 4/27/2022 7:32:01 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '27/Apr/2022' ### 4/27/2022 7:32:01 AM 4/27/2022 7:32:07 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '27/Apr/2022' ### 4/27/2022 7:32:07 AM 4/27/2022 7:32:08 AM : Posting Supplierlink Query for CompanyPurchases --->> ### 4/27/2022 7:32:08 AM 4/27/2022 7:32:08 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '27/Apr/2022' ### 4/27/2022 7:32:08 AM 4/27/2022 7:32:08 AM : Posting ClosingStock Successful --->> ### 4/27/2022 7:32:08 AM 4/27/2022 7:32:08 AM : FileWiseHashCode Updated for FlagImport=true records --->> ### 4/27/2022 7:32:08 AM 4/27/2022 7:32:08 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\ 4/27/2022 7:32:08 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1025789_TEMPLATE1.TXT ### 4/27/2022 7:32:08 AM 4/27/2022 7:32:08 AM : Count:: ### TEMPLATE1:165 4/27/2022 7:32:18 AM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 7:32:18 AM 4/27/2022 7:32:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 4/27/2022 7:32:18 AM 4/27/2022 7:32:19 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 7:32:19 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1990080_TEMPLATE1.TXT ### 4/27/2022 7:32:19 AM 4/27/2022 7:32:19 AM : Count:: ### TEMPLATE1:21 4/27/2022 7:32:19 AM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 7:32:19 AM 4/27/2022 7:32:19 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 4/27/2022 7:32:19 AM 4/27/2022 7:32:19 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 7:32:19 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 4/27/2022 7:32:19 AM 4/27/2022 7:32:19 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 7:32:19 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 4/27/2022 7:32:19 AM 4/27/2022 7:32:19 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 7:32:19 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 4/27/2022 7:32:19 AM 4/27/2022 7:32:19 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 7:32:19 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2848065_TEMPLATE1.TXT ### 4/27/2022 7:32:19 AM 4/27/2022 7:32:19 AM : Count:: ### TEMPLATE1:76 4/27/2022 7:32:21 AM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 7:32:21 AM 4/27/2022 7:32:21 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3224985_TEMPLATE1.TXT ### 4/27/2022 7:32:21 AM 4/27/2022 7:32:21 AM : Count:: ### TEMPLATE1:87 4/27/2022 7:32:32 AM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 7:32:32 AM 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 AM : Error in file ### TEMPLATE1 at Line KRISHNA MANSION 4/27/2022 7:32:32 AM : Exception ### Exception of type 'System.Exception' was thrown. 4/27/2022 7:32:32 AM : Error in file ### TEMPLATE1 at Line GHEE BAZAAR 4/27/2022 7:32:32 AM : Exception ### Exception of type 'System.Exception' was thrown. 4/27/2022 7:32:32 AM : Error in file ### TEMPLATE1 at Line |24AKXPA1540L1Z3|98980 08767|","AHMEDABAD","GUJARAT","390002","98980 08767","SUSHILBHAI AGRAWAL","98980 08767","0","0" 4/27/2022 7:32:32 AM : Exception ### Exception of type 'System.Exception' was thrown. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 AM : Error in file ### TEMPLATE1 at Line 000000000000011","A2833","A2833","SHRI SAHJANAND SALES","||98243 02757|","GANDHINAGAR","GUJARAT","0","98243 02757","","98243 02757","0","0 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 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 4/27/2022 7:32:32 AM : Exception ### Input array is longer than the number of columns in this table. 4/27/2022 7:32:32 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3228822_TEMPLATE1.txt ### 4/27/2022 7:32:32 AM 4/27/2022 7:32:32 AM : Count:: ### TEMPLATE1:1 4/27/2022 7:32:32 AM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 7:32:32 AM 4/27/2022 7:32:32 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 4/27/2022 7:32:32 AM 4/27/2022 7:32:32 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 7:32:32 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 4/27/2022 7:32:32 AM 4/27/2022 7:32:32 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 7:32:32 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 4/27/2022 7:32:32 AM 4/27/2022 7:32:32 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 7:32:32 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 4/27/2022 7:32:32 AM 4/27/2022 7:32:32 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 7:32:32 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3985879_TEMPLATE1.txt ### 4/27/2022 7:32:32 AM 4/27/2022 7:32:32 AM : Count:: ### TEMPLATE1:15 4/27/2022 7:32:32 AM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 7:32:32 AM 4/27/2022 7:32:32 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 4/27/2022 7:32:32 AM 4/27/2022 7:32:32 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 7:32:32 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 4/27/2022 7:32:32 AM 4/27/2022 7:32:32 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 7:32:32 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 4/27/2022 7:32:32 AM 4/27/2022 7:32:32 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 7:32:32 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060310_TEMPLATE1.TXT ### 4/27/2022 7:32:32 AM 4/27/2022 7:32:32 AM : Count:: ### TEMPLATE1:19 4/27/2022 7:32:33 AM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 7:32:33 AM 4/27/2022 7:32:33 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060893_TEMPLATE1.txt ### 4/27/2022 7:32:33 AM 4/27/2022 7:32:33 AM : Count:: ### TEMPLATE1:503 4/27/2022 7:33:04 AM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 7:33:04 AM 4/27/2022 7:33:04 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 4/27/2022 7:33:04 AM 4/27/2022 7:33:04 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 7:33:04 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 4/27/2022 7:33:04 AM 4/27/2022 7:33:04 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 7:33:04 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 4/27/2022 7:33:04 AM 4/27/2022 7:33:04 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 7:33:04 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062891_TEMPLATE1.TXT ### 4/27/2022 7:33:04 AM 4/27/2022 7:33:04 AM : Count:: ### TEMPLATE1:140 4/27/2022 7:33:13 AM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 7:33:13 AM 4/27/2022 7:33:13 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 4/27/2022 7:33:13 AM 4/27/2022 7:33:13 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 7:33:14 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 4/27/2022 7:33:14 AM 4/27/2022 7:33:14 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 7:33:14 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9064126_TEMPLATE1.txt ### 4/27/2022 7:33:14 AM 4/27/2022 7:33:14 AM : Count:: ### TEMPLATE1:2 4/27/2022 7:33:14 AM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 7:33:14 AM 4/27/2022 7:33:14 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067109_TEMPLATE1.TXT ### 4/27/2022 7:33:14 AM 4/27/2022 7:33:14 AM : Count:: ### TEMPLATE1:54 4/27/2022 7:33:21 AM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 7:33:21 AM 4/27/2022 7:33:21 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067123_TEMPLATE1.txt ### 4/27/2022 7:33:21 AM 4/27/2022 7:33:21 AM : Count:: ### TEMPLATE1:37 4/27/2022 7:33:26 AM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 7:33:26 AM 4/27/2022 7:33:26 AM : Template Import Complete ### 4/27/2022 7:33:26 AM 4/27/2022 7:33:29 AM : Completed Updating Has Transaction Flag ### 4/27/2022 7:33:29 AM 4/27/2022 7:33:29 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 4/27/2022 7:33:29 AM 4/27/2022 7:33:29 AM : Zylem Access Unblocked ### 4/27/2022 7:33:29 AM 4/27/2022 7:33:29 AM : Application Ended ### 4/27/2022 7:33:29 AM 4/27/2022 10:04:01 AM : Start Process : checkAllTablesExists() ### Start 4/27/2022 10:04:01 AM : Import Start Time (NEW) For Sri Usha Enterprises(3513087) ### 4/27/2022 10:04:01 AM 4/27/2022 10:04:01 AM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 4/27/2022 10:04:02 AM : For Distributor 000000000000369 Insert Count::41 ### Delete Count::38 4/27/2022 10:04:02 AM : Import AD File --->> AD_369_20220427_4b19b8753a260be0f861ffd02efcb4bc.TXT ### 4/27/2022 10:04:02 AM 4/27/2022 10:04:02 AM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 4/27/2022 10:04:02 AM : For Distributor 000000000000369 Insert Count::4 ### Delete Count::0 4/27/2022 10:04:02 AM : Import PR File --->> PR_369_20220427_9eef803b495b484fe5ff7e534c465475.TXT ### 4/27/2022 10:04:02 AM 4/27/2022 10:04:02 AM : Import Masters Completed Sri Usha Enterprises(3513087) ### 4/27/2022 10:04:02 AM 4/27/2022 10:04:02 AM : Start Process : ImportSplittedFilesOldDeleteInsert() ### called 4/27/2022 10:04:02 AM : splitFileDaywiseNewNaming ### called 4/27/2022 10:04:02 AM : splitFileDaywiseNewNaming ### called 4/27/2022 10:04:02 AM : command:: ### Delete Unlinked DN 4/27/2022 10:04:02 AM : command:: ### Delete Unlinked DN 4/27/2022 10:04:02 AM : command:: ### Delete SPLITFILEINFO DN 4/27/2022 10:04:02 AM : Import DN File --->> DN_369_20210111_a39cbb9d71828add15ff36c934c4ba92.TXT ### 4/27/2022 10:04:02 AM 4/27/2022 10:04:02 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::6 4/27/2022 10:04:02 AM : Import DN File --->> DN_369_20210113_99ca8ff41efecb4623ab688c79a70c2b.TXT ### 4/27/2022 10:04:02 AM 4/27/2022 10:04:02 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 10:04:02 AM : Import DN File --->> DN_369_20210127_5208e166e253cfb0ce24051cd21c62df.TXT ### 4/27/2022 10:04:02 AM 4/27/2022 10:04:02 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::10 4/27/2022 10:04:03 AM : Import DN File --->> DN_369_20210202_c7d7de5ff233a5ac227625ad321ee82a.TXT ### 4/27/2022 10:04:03 AM 4/27/2022 10:04:03 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::4 4/27/2022 10:04:03 AM : Import DN File --->> DN_369_20210215_3cc02006c1b2524f15cc1261a5c69bcd.TXT ### 4/27/2022 10:04:03 AM 4/27/2022 10:04:03 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::11 4/27/2022 10:04:03 AM : Import DN File --->> DN_369_20210223_3ba3c17baf01d340fdf3ab18dd345679.TXT ### 4/27/2022 10:04:03 AM 4/27/2022 10:04:03 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 10:04:03 AM : Import DN File --->> DN_369_20210225_4a19817ab877000ca40fa819654e94f9.TXT ### 4/27/2022 10:04:03 AM 4/27/2022 10:04:03 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::5 4/27/2022 10:04:03 AM : Import DN File --->> DN_369_20210305_67206b74729d72d42d6ed705c869c915.TXT ### 4/27/2022 10:04:03 AM 4/27/2022 10:04:03 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::5 4/27/2022 10:04:03 AM : Import DN File --->> DN_369_20210324_f5ed5bfc499bdcf502ddfb6e13fea80f.TXT ### 4/27/2022 10:04:03 AM 4/27/2022 10:04:03 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::7 4/27/2022 10:04:03 AM : Import DN File --->> DN_369_20210325_2d62be6ae4938ad3d30579211a424094.TXT ### 4/27/2022 10:04:03 AM 4/27/2022 10:04:03 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 10:04:03 AM : command:: flagImportPosting = ### True 4/27/2022 10:04:03 AM : command:: minDate = ### 1/1/2021 12:00:00 AM 4/27/2022 10:04:03 AM : splitFileDaywiseNewNaming ### called 4/27/2022 10:04:03 AM : command:: ### Delete Unlinked IN 4/27/2022 10:04:03 AM : command:: ### Delete Unlinked IN 4/27/2022 10:04:03 AM : command:: ### Delete SPLITFILEINFO IN 4/27/2022 10:04:03 AM : Import IN File --->> IN_369_20210104_8764804e606e5195d57cafeb18fcdaa3.TXT ### 4/27/2022 10:04:03 AM 4/27/2022 10:04:03 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::6 4/27/2022 10:04:03 AM : Import IN File --->> IN_369_20210105_69c68d25aab3c96a71a919bd0a4167c9.TXT ### 4/27/2022 10:04:03 AM 4/27/2022 10:04:03 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 10:04:03 AM : Import IN File --->> IN_369_20210106_022b15b192f16586f25dcb54b36548c7.TXT ### 4/27/2022 10:04:03 AM 4/27/2022 10:04:03 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::6 4/27/2022 10:04:03 AM : Import IN File --->> IN_369_20210107_25bdda31a007dad7348d4f1f88924394.TXT ### 4/27/2022 10:04:03 AM 4/27/2022 10:04:03 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 10:04:03 AM : Import IN File --->> IN_369_20210109_2a8cd33ade7d578fc24a8dc89bc47568.TXT ### 4/27/2022 10:04:03 AM 4/27/2022 10:04:03 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210112_86976b3a7ebbaaebb3af4bc8cc12e7b6.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210113_37c3efc807741980036346da94c55128.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210114_ed54e184108173d604602278212cb49b.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210118_3b9aa922fe72ecfba7b2094b67ba22c2.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::11 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210119_f81400f3009c0396e9d9a58ace379bcb.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::5 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210120_72af74adb5ff5e5458b9e285d37a9589.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::11 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210121_8b6fc64e4502db8ec6365cd006933464.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210122_7a77ca093207a23b6c1dcf3325f673c6.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210123_5459339da4a7edffd902705328a83c15.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210126_38ff9b17edf65d7457300f79618de277.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::3 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210127_7272cbe17f31127c098169d5ec386871.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::10 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210128_ab0496fcd08ecbde7b4ac3b1e71eaa4c.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::3 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210129_863ffa8bbc0e201c97655b8b45cb93be.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::5 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210130_a4904a22db9d34f07322e8aa01915454.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::14 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210131_5f3c456c3b10c29bc0bccdf0805bf32e.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::6 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210201_78087580bbe7d179ffe9145a546460dc.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::9 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210202_e350b892834fdaea940765e4e6c4c45d.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::9 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210203_3cdeb88cdc1a00a6ae50fc7ea8c65003.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::5 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210204_dc03ccfad52d20bd3c98d128f4b99616.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::3 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210205_0583aacbe200d26f7458b6b359527d02.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210206_13aeee0efd9d68b673cdfb9d0138a53a.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::9 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210208_9d0748e5b6792905bfdc139d0e4542b5.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::3 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210209_9affbd1f32e61a06b2a969624d490b33.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210210_c850af6c4dd8200b4d9dc1abcb71d1d1.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::5 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210211_14199044fc24907752c2979f47c40904.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210212_ab71eecdb801600167885226eb5088be.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::3 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210213_761188a42954b0566e82fffb510c91d8.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::7 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210215_426b1bbbeb05df8836090deeed05851a.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::3 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210218_b5bcd7a4bb8219d9a5b8c5f3db8b99b4.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210219_6aedc4b69501fbc5722e4616c139d0e8.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210220_9253e1f7fde780a1573e170ca5e4ce1c.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210222_e532e875e71fb475f8895e17df78062f.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::28 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210223_1415169922cc86c7fb5810e6d7a7b369.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::6 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210224_4a640c47833b9188567c1f8a34a8b7e1.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::7 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210227_c7118b27f7cdc4ec8146878b42970d5e.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::5 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210228_bed2ab1aa37900f71f88bc48788ec9d0.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210301_0d93e2372b299e2247d8265ce5a4dbde.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210302_13dd66a79fc9595d32cef1e88e7a5774.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::7 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210303_4b7401cf1170865b85a0ad9cbf446871.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::3 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210304_1ca63d41d431694e533755f6c8d47701.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::19 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210306_cf1eff4f071b8f22b2e50d29d65a4a96.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::3 4/27/2022 10:04:04 AM : Import IN File --->> IN_369_20210309_3ea89c1aebce2587d8ffd6368bf19ff3.TXT ### 4/27/2022 10:04:04 AM 4/27/2022 10:04:04 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::4 4/27/2022 10:04:05 AM : Import IN File --->> IN_369_20210311_b402f31f7184bf52827467aa847c7aae.TXT ### 4/27/2022 10:04:05 AM 4/27/2022 10:04:05 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 10:04:05 AM : Import IN File --->> IN_369_20210312_41a7dde7073857fda0c4d30050e0894a.TXT ### 4/27/2022 10:04:05 AM 4/27/2022 10:04:05 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 10:04:05 AM : Import IN File --->> IN_369_20210313_a325631b9c1eba578f56a6774e99a166.TXT ### 4/27/2022 10:04:05 AM 4/27/2022 10:04:05 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::22 4/27/2022 10:04:05 AM : Import IN File --->> IN_369_20210315_26b2d82e7a20dbb1bab109e9661aa31c.TXT ### 4/27/2022 10:04:05 AM 4/27/2022 10:04:05 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::4 4/27/2022 10:04:05 AM : Import IN File --->> IN_369_20210317_214a4efef816c972f3da7b058f6335e8.TXT ### 4/27/2022 10:04:05 AM 4/27/2022 10:04:05 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::7 4/27/2022 10:04:05 AM : Import IN File --->> IN_369_20210318_b39cab737109987479d08726211e3f77.TXT ### 4/27/2022 10:04:05 AM 4/27/2022 10:04:05 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::8 4/27/2022 10:04:05 AM : Import IN File --->> IN_369_20210319_f99b0fb186709a004f8dc157bf584aee.TXT ### 4/27/2022 10:04:05 AM 4/27/2022 10:04:05 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::10 4/27/2022 10:04:05 AM : Import IN File --->> IN_369_20210320_97f3f101166ccab3c8d07381a635d461.TXT ### 4/27/2022 10:04:05 AM 4/27/2022 10:04:05 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 10:04:05 AM : Import IN File --->> IN_369_20210322_08718b744ceaca595dab862b318229e7.TXT ### 4/27/2022 10:04:05 AM 4/27/2022 10:04:05 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::8 4/27/2022 10:04:05 AM : Import IN File --->> IN_369_20210323_cf90b3a478dd9ef1a767ab92a9105a3c.TXT ### 4/27/2022 10:04:05 AM 4/27/2022 10:04:05 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::15 4/27/2022 10:04:05 AM : Import IN File --->> IN_369_20210324_71269fbc895dd1af679d68bdb99ded19.TXT ### 4/27/2022 10:04:05 AM 4/27/2022 10:04:05 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 10:04:05 AM : Import IN File --->> IN_369_20210325_8c4a8feec687f96b9a2ded458bd6c850.TXT ### 4/27/2022 10:04:05 AM 4/27/2022 10:04:05 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 10:04:05 AM : Import IN File --->> IN_369_20210327_4414853cd594653f0046a60ff722e67d.TXT ### 4/27/2022 10:04:05 AM 4/27/2022 10:04:05 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 10:04:05 AM : Import IN File --->> IN_369_20210329_87c6a3cb739e77665a1fb1bb857d8e16.TXT ### 4/27/2022 10:04:05 AM 4/27/2022 10:04:05 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::7 4/27/2022 10:04:05 AM : Import IN File --->> IN_369_20210330_2df201b1dd01b5f39e8f587504051c3a.TXT ### 4/27/2022 10:04:05 AM 4/27/2022 10:04:05 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 10:04:05 AM : Import IN File --->> IN_369_20210331_54d101cf716a9c304b3e89c301e63ddf.TXT ### 4/27/2022 10:04:05 AM 4/27/2022 10:04:05 AM : NO Previous File For Distributor 000000000000369 ### Insert Count::13 4/27/2022 10:04:05 AM : command:: flagImportPosting = ### True 4/27/2022 10:04:05 AM : command:: minDate = ### 1/1/2021 12:00:00 AM 4/27/2022 10:04:09 AM : SP_CreateUnkCustomerUnkItem Successful --->> ### 4/27/2022 10:04:09 AM 4/27/2022 10:04:10 AM : CustomerLink Diff Successful --->> ### 4/27/2022 10:04:10 AM 4/27/2022 10:04:11 AM : ItemLink Diff Successful --->> ### 4/27/2022 10:04:11 AM 4/27/2022 10:04:11 AM : Supplierlink Query Successful --->> ### 4/27/2022 10:04:11 AM 4/27/2022 10:04:11 AM : Posting Purchases 'true' Successful --->> ### 4/27/2022 10:04:11 AM 4/27/2022 10:04:12 AM : Posting OtherTransaction 'true' Successful --->> ### 4/27/2022 10:04:12 AM 4/27/2022 10:04:16 AM : Posting Sales 'true' Successful --->> ### 4/27/2022 10:04:16 AM 4/27/2022 10:04:20 AM : Completed Updating Has Transaction Flag ### 4/27/2022 10:04:20 AM 4/27/2022 10:04:20 AM : command :: PostDataDeleteInsert ### Done 4/27/2022 10:04:20 AM : command :: set DiffCutOffDate ### Done 4/27/2022 10:04:20 AM : End Process : ImportSplittedFilesOldDeleteInsert() ### 4/27/2022 10:04:20 AM : Import End Time (NEW) Sri Usha Enterprises(3513087) ### 4/27/2022 10:04:20 AM 4/27/2022 10:04:20 AM : -------------Import One Distributor End Time----------- ### 4/27/2022 10:04:20 AM 4/27/2022 12:26:35 PM : Start Process : checkAllTablesExists() ### Start 4/27/2022 12:26:35 PM : Import Start Time (NEW) For Sri Usha Enterprises(3513087) ### 4/27/2022 12:26:35 PM 4/27/2022 12:26:35 PM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 4/27/2022 12:26:35 PM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 4/27/2022 12:26:35 PM : Import Masters Completed Sri Usha Enterprises(3513087) ### 4/27/2022 12:26:35 PM 4/27/2022 12:26:35 PM : Start Process : ImportSplittedFilesOldDeleteInsert() ### called 4/27/2022 12:26:36 PM : splitFileDaywiseNewNaming ### called 4/27/2022 12:26:36 PM : splitFileDaywiseNewNaming ### called 4/27/2022 12:26:36 PM : splitFileDaywiseNewNaming ### FileRangeMonthYear = '3-2022' and FileDataMonthYear= '1-2021' of MinDate mismatched 4/27/2022 12:26:36 PM : command:: ### Delete Unlinked DN 4/27/2022 12:26:36 PM : command:: ### Delete Unlinked DN 4/27/2022 12:26:36 PM : command:: ### Delete SPLITFILEINFO DN 4/27/2022 12:26:36 PM : Import DN File --->> DN_369_20210111_7254c8e5674d57de0f06b0df226d0ea8.TXT ### 4/27/2022 12:26:36 PM 4/27/2022 12:26:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::6 4/27/2022 12:26:36 PM : Import DN File --->> DN_369_20210113_ccb2f3471e8247bf450ca8b64ec23336.TXT ### 4/27/2022 12:26:36 PM 4/27/2022 12:26:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 12:26:36 PM : Import DN File --->> DN_369_20210127_3e65052e1531ad91164a9a73a6007f0c.TXT ### 4/27/2022 12:26:36 PM 4/27/2022 12:26:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::10 4/27/2022 12:26:36 PM : Import DN File --->> DN_369_20210202_4a660fcc52e429321677343450ab6aef.TXT ### 4/27/2022 12:26:36 PM 4/27/2022 12:26:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::4 4/27/2022 12:26:36 PM : Import DN File --->> DN_369_20210215_67d3346bb7195b04480a9fb60c4198a9.TXT ### 4/27/2022 12:26:36 PM 4/27/2022 12:26:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::11 4/27/2022 12:26:36 PM : Import DN File --->> DN_369_20210223_c9bb4df8759ef2849209e79382a2d2ba.TXT ### 4/27/2022 12:26:36 PM 4/27/2022 12:26:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 12:26:36 PM : Import DN File --->> DN_369_20210225_4a19817ab877000ca40fa819654e94f9.TXT ### 4/27/2022 12:26:36 PM 4/27/2022 12:26:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::5 4/27/2022 12:26:36 PM : Import DN File --->> DN_369_20210305_08119ec276c15dec49b70c8defbdf9af.TXT ### 4/27/2022 12:26:36 PM 4/27/2022 12:26:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::5 4/27/2022 12:26:37 PM : Import DN File --->> DN_369_20210324_26ef7546c68620d289cd5c9be5f0b4ad.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::7 4/27/2022 12:26:37 PM : Import DN File --->> DN_369_20210325_e4908782a962079ceb928586ba0a9707.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 12:26:37 PM : command:: flagImportPosting = ### True 4/27/2022 12:26:37 PM : command:: minDate = ### 1/11/2021 12:00:00 AM 4/27/2022 12:26:37 PM : splitFileDaywiseNewNaming ### called 4/27/2022 12:26:37 PM : splitFileDaywiseNewNaming ### FileRangeMonthYear = '3-2022' and FileDataMonthYear= '1-2021' of MinDate mismatched 4/27/2022 12:26:37 PM : command:: ### Delete Unlinked IN 4/27/2022 12:26:37 PM : command:: ### Delete Unlinked IN 4/27/2022 12:26:37 PM : command:: ### Delete SPLITFILEINFO IN 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210104_09d69e05431c9255cbbf66b13561ebc1.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::6 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210105_0a73031af3c6a07a8f3d5827376e1b0a.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210106_ee05b6207e0705dedaa3f3d4a2cb5a16.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::6 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210107_7f1dacec2599fa177b1e18da6f451505.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210109_f4babae0baf15f34ace28a6a890cd2dc.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210112_0985dd99ce21bed3459afc971b7a9bee.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210113_8e5a779d48dcfd4324b2e68bbc146d04.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210114_5d2a695c776b9c3eb1ed4b29f56308a3.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210118_ac438f8e63e62e2a5842d65448b6fa14.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::11 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210119_d5fb698396e556c72b3042a9b10303e3.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::5 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210120_e2cb779939bbadd113a051b755116c87.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::11 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210121_59e6b1c3d98e25eac62ad9315eaffb4e.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210122_9e4f679284204b7c9e995e10653d93ec.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210123_b889b9e68da0ed4b9b479d995b19bbba.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210126_460c07ed5195ac978a2047d89ac381f9.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::3 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210127_55f35baf91a48eada2bce07721efd229.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::10 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210128_f058e1e162c8578f5ff8bb77fcfbc212.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::3 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210129_3fa0b6d2c1b36e66719e12c836b3c71b.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::5 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210130_1de9d046ac7e4f98a478659534e740e7.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::14 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210131_2381b8b218ae01c12f45720e599df791.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::6 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210201_d0bb19eb57b92c54f189b78f2b6a18d3.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::9 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210202_d49242ee2c386b3396598f0df19e996c.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::9 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210203_8187fd1a331764258dccb41e9ae357b2.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::5 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210204_7a0f8ed2ec03a26e4e8c8ab4fb3bb7df.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::3 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210205_d1da5a3f88a71272af43463e546c5355.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210206_42982346f5544a5e5bd5e5a6b562547a.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::9 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210208_73972443ccfabc2e4d5d6715ed6a0b3c.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::3 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210209_f7c939ce212e129bfd333f91341c2887.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210210_b00e659691b604152d5565e9409de7ec.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::5 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210211_6e6f7a19f9d10e8c5ae1fc01dd92b3ee.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210212_bbf87e9d1e545a38cda61662b0d7ade7.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::3 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210213_7f55578354b0ff8187c3e9f4267d0df4.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::7 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210215_ea857536009e3784160305b820d489f5.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::3 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210218_23b7b22794e88e67f0652aa492d7be64.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210219_cea18d7c155e2bdb352c975647bcde22.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210220_9ea5d277ccbbbc4146777229a5cad3e7.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210222_59458b93948fdcfd3d38f865ba689f78.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::28 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210223_74a517ab3505712bca705905fd79729d.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::6 4/27/2022 12:26:37 PM : Import IN File --->> IN_369_20210224_d3fdc3c8c7069c2f5e0d4c8c1534945c.TXT ### 4/27/2022 12:26:37 PM 4/27/2022 12:26:37 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::7 4/27/2022 12:26:38 PM : Import IN File --->> IN_369_20210227_a57a25b63ab277d0026460764357801f.TXT ### 4/27/2022 12:26:38 PM 4/27/2022 12:26:38 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::5 4/27/2022 12:26:38 PM : Import IN File --->> IN_369_20210228_53cee71ba2872af6ac4790178cace641.TXT ### 4/27/2022 12:26:38 PM 4/27/2022 12:26:38 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 12:26:38 PM : Import IN File --->> IN_369_20210301_158ada5a38cdf563bd75523a96f9f457.TXT ### 4/27/2022 12:26:38 PM 4/27/2022 12:26:38 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:26:38 PM : Import IN File --->> IN_369_20210302_93fda10078a32244c43f22ef51cc994b.TXT ### 4/27/2022 12:26:38 PM 4/27/2022 12:26:38 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::7 4/27/2022 12:26:38 PM : Import IN File --->> IN_369_20210303_f01fcfc7982948f7e1d29aa1c477e697.TXT ### 4/27/2022 12:26:38 PM 4/27/2022 12:26:38 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::3 4/27/2022 12:26:38 PM : Import IN File --->> IN_369_20210304_720ea722d21618d645248251eec4083b.TXT ### 4/27/2022 12:26:38 PM 4/27/2022 12:26:38 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::19 4/27/2022 12:26:38 PM : Import IN File --->> IN_369_20210306_c3056679e8e39421c0a41b405ba55900.TXT ### 4/27/2022 12:26:38 PM 4/27/2022 12:26:38 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::3 4/27/2022 12:26:38 PM : Import IN File --->> IN_369_20210309_952e81c3bd19b4005270271cce46eef1.TXT ### 4/27/2022 12:26:38 PM 4/27/2022 12:26:38 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::4 4/27/2022 12:26:38 PM : Import IN File --->> IN_369_20210311_8d8339e066b2cb8aeda777b7b604580d.TXT ### 4/27/2022 12:26:38 PM 4/27/2022 12:26:38 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 12:26:38 PM : Import IN File --->> IN_369_20210312_edc5a1c1f3f4d6289d184ea6dfa083f0.TXT ### 4/27/2022 12:26:38 PM 4/27/2022 12:26:38 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:26:38 PM : Import IN File --->> IN_369_20210313_7cebdce37f5e2e1f687c22ed9ac3e0ac.TXT ### 4/27/2022 12:26:38 PM 4/27/2022 12:26:38 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::22 4/27/2022 12:26:38 PM : Import IN File --->> IN_369_20210315_8d5139901c2dad431348dfab2023648d.TXT ### 4/27/2022 12:26:38 PM 4/27/2022 12:26:38 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::4 4/27/2022 12:26:38 PM : Import IN File --->> IN_369_20210317_4666de78c320d889ca9be2086c0c8ffc.TXT ### 4/27/2022 12:26:38 PM 4/27/2022 12:26:38 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::7 4/27/2022 12:26:38 PM : Import IN File --->> IN_369_20210318_9fc4aea505d9eb24e296be901868d042.TXT ### 4/27/2022 12:26:38 PM 4/27/2022 12:26:38 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::8 4/27/2022 12:26:38 PM : Import IN File --->> IN_369_20210319_e2097c4d95ad9ab7e53bd9a4bbc5e778.TXT ### 4/27/2022 12:26:38 PM 4/27/2022 12:26:38 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::10 4/27/2022 12:26:38 PM : Import IN File --->> IN_369_20210320_384543be950a6ebeb263beae99a26f1e.TXT ### 4/27/2022 12:26:38 PM 4/27/2022 12:26:38 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:26:38 PM : Import IN File --->> IN_369_20210322_9118267eba6cfae452084b558b0ab585.TXT ### 4/27/2022 12:26:38 PM 4/27/2022 12:26:38 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::8 4/27/2022 12:26:38 PM : Import IN File --->> IN_369_20210323_f9aa8a071e67c4bf225a50fbaa87545f.TXT ### 4/27/2022 12:26:38 PM 4/27/2022 12:26:38 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::15 4/27/2022 12:26:38 PM : Import IN File --->> IN_369_20210324_1c3a93f58677d9e6f288455b215506ea.TXT ### 4/27/2022 12:26:38 PM 4/27/2022 12:26:38 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:26:38 PM : Import IN File --->> IN_369_20210325_47c3b89e6ff2713352c243a6b5d937f2.TXT ### 4/27/2022 12:26:38 PM 4/27/2022 12:26:38 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:26:38 PM : Import IN File --->> IN_369_20210327_ed442ac5b325c2f84bc7c294d046b163.TXT ### 4/27/2022 12:26:38 PM 4/27/2022 12:26:38 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 12:26:38 PM : Import IN File --->> IN_369_20210329_a1da976fcb90789652774df85782a3b1.TXT ### 4/27/2022 12:26:38 PM 4/27/2022 12:26:38 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::7 4/27/2022 12:26:38 PM : Import IN File --->> IN_369_20210330_88086f9a03a87b06091c90a1e50e7b4f.TXT ### 4/27/2022 12:26:38 PM 4/27/2022 12:26:38 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:26:38 PM : Import IN File --->> IN_369_20210331_fe97920c52fe514907a856de1fa39d03.TXT ### 4/27/2022 12:26:38 PM 4/27/2022 12:26:38 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::13 4/27/2022 12:26:38 PM : command:: flagImportPosting = ### True 4/27/2022 12:26:38 PM : command:: minDate = ### 1/4/2021 12:00:00 AM 4/27/2022 12:26:53 PM : SP_CreateUnkCustomerUnkItem Successful --->> ### 4/27/2022 12:26:53 PM 4/27/2022 12:26:54 PM : CustomerLink Diff Successful --->> ### 4/27/2022 12:26:53 PM 4/27/2022 12:26:54 PM : ItemLink Diff Successful --->> ### 4/27/2022 12:26:54 PM 4/27/2022 12:26:54 PM : Supplierlink Query Successful --->> ### 4/27/2022 12:26:54 PM 4/27/2022 12:26:54 PM : Posting Purchases 'true' Successful --->> ### 4/27/2022 12:26:54 PM 4/27/2022 12:26:55 PM : Posting OtherTransaction 'true' Successful --->> ### 4/27/2022 12:26:55 PM 4/27/2022 12:26:59 PM : Posting Sales 'true' Successful --->> ### 4/27/2022 12:26:59 PM 4/27/2022 12:27:02 PM : Completed Updating Has Transaction Flag ### 4/27/2022 12:27:02 PM 4/27/2022 12:27:02 PM : command :: PostDataDeleteInsert ### Done 4/27/2022 12:27:02 PM : command :: set DiffCutOffDate ### Done 4/27/2022 12:27:02 PM : End Process : ImportSplittedFilesOldDeleteInsert() ### 4/27/2022 12:27:02 PM : Import End Time (NEW) Sri Usha Enterprises(3513087) ### 4/27/2022 12:27:02 PM 4/27/2022 12:27:02 PM : -------------Import One Distributor End Time----------- ### 4/27/2022 12:27:02 PM 4/27/2022 12:28:33 PM : Start Process : checkAllTablesExists() ### Start 4/27/2022 12:28:33 PM : Import Start Time (NEW) For Sri Usha Enterprises(3513087) ### 4/27/2022 12:28:33 PM 4/27/2022 12:28:33 PM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 4/27/2022 12:28:33 PM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 4/27/2022 12:28:33 PM : Import Masters Completed Sri Usha Enterprises(3513087) ### 4/27/2022 12:28:33 PM 4/27/2022 12:28:33 PM : Start Process : ImportSplittedFilesOldDeleteInsert() ### called 4/27/2022 12:28:33 PM : splitFileDaywiseNewNaming ### called 4/27/2022 12:28:33 PM : splitFileDaywiseNewNaming ### called 4/27/2022 12:28:34 PM : command:: ### Delete Unlinked DN 4/27/2022 12:28:34 PM : command:: ### Delete Unlinked DN 4/27/2022 12:28:34 PM : command:: ### Delete SPLITFILEINFO DN 4/27/2022 12:28:34 PM : Import DN File --->> DN_369_20210111_7254c8e5674d57de0f06b0df226d0ea8.TXT ### 4/27/2022 12:28:34 PM 4/27/2022 12:28:34 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::6 4/27/2022 12:28:34 PM : Import DN File --->> DN_369_20210113_ccb2f3471e8247bf450ca8b64ec23336.TXT ### 4/27/2022 12:28:34 PM 4/27/2022 12:28:34 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 12:28:34 PM : Import DN File --->> DN_369_20210127_3e65052e1531ad91164a9a73a6007f0c.TXT ### 4/27/2022 12:28:34 PM 4/27/2022 12:28:34 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::10 4/27/2022 12:28:34 PM : Import DN File --->> DN_369_20210202_4a660fcc52e429321677343450ab6aef.TXT ### 4/27/2022 12:28:34 PM 4/27/2022 12:28:34 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::4 4/27/2022 12:28:34 PM : Import DN File --->> DN_369_20210215_67d3346bb7195b04480a9fb60c4198a9.TXT ### 4/27/2022 12:28:34 PM 4/27/2022 12:28:34 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::11 4/27/2022 12:28:34 PM : Import DN File --->> DN_369_20210223_c9bb4df8759ef2849209e79382a2d2ba.TXT ### 4/27/2022 12:28:34 PM 4/27/2022 12:28:34 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 12:28:34 PM : Import DN File --->> DN_369_20210225_4a19817ab877000ca40fa819654e94f9.TXT ### 4/27/2022 12:28:34 PM 4/27/2022 12:28:34 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::5 4/27/2022 12:28:34 PM : Import DN File --->> DN_369_20210305_08119ec276c15dec49b70c8defbdf9af.TXT ### 4/27/2022 12:28:34 PM 4/27/2022 12:28:34 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::5 4/27/2022 12:28:35 PM : Import DN File --->> DN_369_20210324_26ef7546c68620d289cd5c9be5f0b4ad.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::7 4/27/2022 12:28:35 PM : Import DN File --->> DN_369_20210325_e4908782a962079ceb928586ba0a9707.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 12:28:35 PM : command:: flagImportPosting = ### True 4/27/2022 12:28:35 PM : command:: minDate = ### 1/1/2021 12:00:00 AM 4/27/2022 12:28:35 PM : splitFileDaywiseNewNaming ### called 4/27/2022 12:28:35 PM : command:: ### Delete Unlinked IN 4/27/2022 12:28:35 PM : command:: ### Delete Unlinked IN 4/27/2022 12:28:35 PM : command:: ### Delete SPLITFILEINFO IN 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210104_09d69e05431c9255cbbf66b13561ebc1.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::6 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210105_0a73031af3c6a07a8f3d5827376e1b0a.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210106_ee05b6207e0705dedaa3f3d4a2cb5a16.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::6 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210107_7f1dacec2599fa177b1e18da6f451505.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210109_f4babae0baf15f34ace28a6a890cd2dc.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210112_0985dd99ce21bed3459afc971b7a9bee.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210113_8e5a779d48dcfd4324b2e68bbc146d04.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210114_5d2a695c776b9c3eb1ed4b29f56308a3.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210118_ac438f8e63e62e2a5842d65448b6fa14.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::11 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210119_d5fb698396e556c72b3042a9b10303e3.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::5 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210120_e2cb779939bbadd113a051b755116c87.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::11 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210121_59e6b1c3d98e25eac62ad9315eaffb4e.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210122_9e4f679284204b7c9e995e10653d93ec.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210123_b889b9e68da0ed4b9b479d995b19bbba.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210126_460c07ed5195ac978a2047d89ac381f9.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::3 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210127_55f35baf91a48eada2bce07721efd229.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::10 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210128_f058e1e162c8578f5ff8bb77fcfbc212.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::3 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210129_3fa0b6d2c1b36e66719e12c836b3c71b.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::5 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210130_1de9d046ac7e4f98a478659534e740e7.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::14 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210131_2381b8b218ae01c12f45720e599df791.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::6 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210201_d0bb19eb57b92c54f189b78f2b6a18d3.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::9 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210202_d49242ee2c386b3396598f0df19e996c.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::9 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210203_8187fd1a331764258dccb41e9ae357b2.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::5 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210204_7a0f8ed2ec03a26e4e8c8ab4fb3bb7df.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::3 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210205_d1da5a3f88a71272af43463e546c5355.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210206_42982346f5544a5e5bd5e5a6b562547a.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::9 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210208_73972443ccfabc2e4d5d6715ed6a0b3c.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::3 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210209_f7c939ce212e129bfd333f91341c2887.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210210_b00e659691b604152d5565e9409de7ec.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::5 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210211_6e6f7a19f9d10e8c5ae1fc01dd92b3ee.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210212_bbf87e9d1e545a38cda61662b0d7ade7.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::3 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210213_7f55578354b0ff8187c3e9f4267d0df4.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:35 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::7 4/27/2022 12:28:35 PM : Import IN File --->> IN_369_20210215_ea857536009e3784160305b820d489f5.TXT ### 4/27/2022 12:28:35 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::3 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210218_23b7b22794e88e67f0652aa492d7be64.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210219_cea18d7c155e2bdb352c975647bcde22.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210220_9ea5d277ccbbbc4146777229a5cad3e7.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210222_59458b93948fdcfd3d38f865ba689f78.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::28 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210223_74a517ab3505712bca705905fd79729d.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::6 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210224_d3fdc3c8c7069c2f5e0d4c8c1534945c.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::7 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210227_a57a25b63ab277d0026460764357801f.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::5 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210228_53cee71ba2872af6ac4790178cace641.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210301_158ada5a38cdf563bd75523a96f9f457.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210302_93fda10078a32244c43f22ef51cc994b.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::7 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210303_f01fcfc7982948f7e1d29aa1c477e697.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::3 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210304_720ea722d21618d645248251eec4083b.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::19 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210306_c3056679e8e39421c0a41b405ba55900.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::3 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210309_952e81c3bd19b4005270271cce46eef1.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::4 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210311_8d8339e066b2cb8aeda777b7b604580d.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210312_edc5a1c1f3f4d6289d184ea6dfa083f0.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210313_7cebdce37f5e2e1f687c22ed9ac3e0ac.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::22 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210315_8d5139901c2dad431348dfab2023648d.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::4 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210317_4666de78c320d889ca9be2086c0c8ffc.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::7 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210318_9fc4aea505d9eb24e296be901868d042.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::8 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210319_e2097c4d95ad9ab7e53bd9a4bbc5e778.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::10 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210320_384543be950a6ebeb263beae99a26f1e.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210322_9118267eba6cfae452084b558b0ab585.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::8 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210323_f9aa8a071e67c4bf225a50fbaa87545f.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::15 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210324_1c3a93f58677d9e6f288455b215506ea.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210325_47c3b89e6ff2713352c243a6b5d937f2.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210327_ed442ac5b325c2f84bc7c294d046b163.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210329_a1da976fcb90789652774df85782a3b1.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::7 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210330_88086f9a03a87b06091c90a1e50e7b4f.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 12:28:36 PM : Import IN File --->> IN_369_20210331_fe97920c52fe514907a856de1fa39d03.TXT ### 4/27/2022 12:28:36 PM 4/27/2022 12:28:36 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::13 4/27/2022 12:28:36 PM : command:: flagImportPosting = ### True 4/27/2022 12:28:36 PM : command:: minDate = ### 1/1/2021 12:00:00 AM 4/27/2022 12:28:40 PM : SP_CreateUnkCustomerUnkItem Successful --->> ### 4/27/2022 12:28:40 PM 4/27/2022 12:28:41 PM : CustomerLink Diff Successful --->> ### 4/27/2022 12:28:41 PM 4/27/2022 12:28:41 PM : ItemLink Diff Successful --->> ### 4/27/2022 12:28:41 PM 4/27/2022 12:28:41 PM : Supplierlink Query Successful --->> ### 4/27/2022 12:28:41 PM 4/27/2022 12:28:41 PM : Posting Purchases 'true' Successful --->> ### 4/27/2022 12:28:41 PM 4/27/2022 12:28:42 PM : Posting OtherTransaction 'true' Successful --->> ### 4/27/2022 12:28:42 PM 4/27/2022 12:28:46 PM : Posting Sales 'true' Successful --->> ### 4/27/2022 12:28:46 PM 4/27/2022 12:28:49 PM : Completed Updating Has Transaction Flag ### 4/27/2022 12:28:49 PM 4/27/2022 12:28:49 PM : command :: PostDataDeleteInsert ### Done 4/27/2022 12:28:49 PM : command :: set DiffCutOffDate ### Done 4/27/2022 12:28:49 PM : End Process : ImportSplittedFilesOldDeleteInsert() ### 4/27/2022 12:28:49 PM : Import End Time (NEW) Sri Usha Enterprises(3513087) ### 4/27/2022 12:28:49 PM 4/27/2022 12:28:49 PM : -------------Import One Distributor End Time----------- ### 4/27/2022 12:28:49 PM 4/27/2022 1:59:09 PM : Start Process : checkAllTablesExists() ### Start 4/27/2022 1:59:09 PM : Import Start Time (NEW) For Awadh Krishi Kendra(9062642) ### 4/27/2022 1:59:09 PM 4/27/2022 1:59:09 PM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 4/27/2022 1:59:09 PM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 4/27/2022 1:59:09 PM : Import Masters Completed Awadh Krishi Kendra(9062642) ### 4/27/2022 1:59:09 PM 4/27/2022 1:59:09 PM : Start Process : ImportSplittedFilesOldDeleteInsert() ### called 4/27/2022 1:59:09 PM : splitFileDaywiseNewNaming ### called 4/27/2022 1:59:09 PM : splitFileDaywiseNewNaming ### called 4/27/2022 1:59:09 PM : splitFileDaywiseNewNaming ### called 4/27/2022 1:59:09 PM : command:: ### Delete Unlinked IN 4/27/2022 1:59:09 PM : command:: ### Delete Unlinked IN 4/27/2022 1:59:09 PM : command:: ### Delete SPLITFILEINFO IN 4/27/2022 1:59:09 PM : Import IN File --->> IN_365_20210112_fb114c026e9497805840770322136ead.TXT ### 4/27/2022 1:59:09 PM 4/27/2022 1:59:10 PM : NO Previous File For Distributor 000000000000365 ### Insert Count::1 4/27/2022 1:59:10 PM : Import IN File --->> IN_365_20210118_62cb054788976d6de15d153b66373d5f.TXT ### 4/27/2022 1:59:10 PM 4/27/2022 1:59:10 PM : NO Previous File For Distributor 000000000000365 ### Insert Count::1 4/27/2022 1:59:10 PM : Import IN File --->> IN_365_20210119_7b742499c8ce0e862e5ea764e8c45cac.TXT ### 4/27/2022 1:59:10 PM 4/27/2022 1:59:10 PM : NO Previous File For Distributor 000000000000365 ### Insert Count::1 4/27/2022 1:59:10 PM : command:: flagImportPosting = ### True 4/27/2022 1:59:10 PM : command:: minDate = ### 1/12/2021 12:00:00 AM 4/27/2022 1:59:10 PM : SP_CreateUnkCustomerUnkItem Successful --->> ### 4/27/2022 1:59:10 PM 4/27/2022 1:59:10 PM : CustomerLink Diff Successful --->> ### 4/27/2022 1:59:10 PM 4/27/2022 1:59:11 PM : ItemLink Diff Successful --->> ### 4/27/2022 1:59:11 PM 4/27/2022 1:59:11 PM : Supplierlink Query Successful --->> ### 4/27/2022 1:59:11 PM 4/27/2022 1:59:11 PM : Posting Purchases 'true' Successful --->> ### 4/27/2022 1:59:11 PM 4/27/2022 1:59:12 PM : Posting OtherTransaction 'true' Successful --->> ### 4/27/2022 1:59:12 PM 4/27/2022 1:59:16 PM : Posting Sales 'true' Successful --->> ### 4/27/2022 1:59:16 PM 4/27/2022 1:59:19 PM : Completed Updating Has Transaction Flag ### 4/27/2022 1:59:19 PM 4/27/2022 1:59:19 PM : command :: PostDataDeleteInsert ### Done 4/27/2022 1:59:19 PM : command :: set DiffCutOffDate ### Done 4/27/2022 1:59:19 PM : End Process : ImportSplittedFilesOldDeleteInsert() ### 4/27/2022 1:59:19 PM : Import End Time (NEW) Awadh Krishi Kendra(9062642) ### 4/27/2022 1:59:19 PM 4/27/2022 1:59:19 PM : -------------Import One Distributor End Time----------- ### 4/27/2022 1:59:19 PM 4/27/2022 2:11:41 PM : Start Process : checkAllTablesExists() ### Start 4/27/2022 2:11:41 PM : Import Start Time (NEW) For Termite Control (India)(948223) ### 4/27/2022 2:11:41 PM 4/27/2022 2:11:41 PM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 4/27/2022 2:11:41 PM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 4/27/2022 2:11:41 PM : Import Masters Completed Termite Control (India)(948223) ### 4/27/2022 2:11:41 PM 4/27/2022 2:11:41 PM : Start Process : ImportSplittedFilesOldDeleteInsert() ### called 4/27/2022 2:11:41 PM : splitFileDaywiseNewNaming ### called 4/27/2022 2:11:41 PM : splitFileDaywiseNewNaming ### called 4/27/2022 2:11:41 PM : splitFileDaywiseNewNaming ### called 4/27/2022 2:11:41 PM : command:: ### Delete Unlinked IN 4/27/2022 2:11:41 PM : command:: ### Delete Unlinked IN 4/27/2022 2:11:41 PM : command:: ### Delete SPLITFILEINFO IN 4/27/2022 2:11:41 PM : Import IN File --->> IN_891_20210710_117036587e015f112bcc7449504ade61.TXT ### 4/27/2022 2:11:41 PM 4/27/2022 2:11:41 PM : NO Previous File For Distributor 000000000000891 ### Insert Count::6 4/27/2022 2:11:41 PM : command:: flagImportPosting = ### True 4/27/2022 2:11:41 PM : command:: minDate = ### 7/10/2021 12:00:00 AM 4/27/2022 2:11:42 PM : SP_CreateUnkCustomerUnkItem Successful --->> ### 4/27/2022 2:11:42 PM 4/27/2022 2:11:42 PM : CustomerLink Diff Successful --->> ### 4/27/2022 2:11:42 PM 4/27/2022 2:11:43 PM : ItemLink Diff Successful --->> ### 4/27/2022 2:11:43 PM 4/27/2022 2:11:43 PM : Supplierlink Query Successful --->> ### 4/27/2022 2:11:43 PM 4/27/2022 2:11:43 PM : Posting Purchases 'true' Successful --->> ### 4/27/2022 2:11:43 PM 4/27/2022 2:11:43 PM : Posting OtherTransaction 'true' Successful --->> ### 4/27/2022 2:11:43 PM 4/27/2022 2:11:48 PM : Posting Sales 'true' Successful --->> ### 4/27/2022 2:11:48 PM 4/27/2022 2:11:51 PM : Completed Updating Has Transaction Flag ### 4/27/2022 2:11:51 PM 4/27/2022 2:11:51 PM : command :: PostDataDeleteInsert ### Done 4/27/2022 2:11:51 PM : command :: set DiffCutOffDate ### Done 4/27/2022 2:11:51 PM : End Process : ImportSplittedFilesOldDeleteInsert() ### 4/27/2022 2:11:51 PM : Import End Time (NEW) Termite Control (India)(948223) ### 4/27/2022 2:11:51 PM 4/27/2022 2:11:51 PM : -------------Import One Distributor End Time----------- ### 4/27/2022 2:11:51 PM 4/27/2022 2:30:02 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 4/27/2022 2:30:03 PM : StartProcess ### 4/27/2022 2:30:03 PM 4/27/2022 2:30:03 PM : 11 ### 4/27/2022 2:30:03 PM 4/27/2022 2:30:03 PM : 22 ### 4/27/2022 2:30:03 PM 4/27/2022 2:30:03 PM : 33 ### 4/27/2022 2:30:03 PM 4/27/2022 2:30:03 PM : Application Started ### 4/27/2022 2:30:03 PM 4/27/2022 2:30:03 PM : Start Process : checkAllTablesExists() ### 4/27/2022 2:30:04 PM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 4/27/2022 2:30:04 PM 4/27/2022 2:30:04 PM : MainForm_Load ### AlertSystem ON 4/27/2022 2:30:04 PM : No. of Files to import (RECEIVEFINAL): ### 1023 4/27/2022 2:30:04 PM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 4/27/2022 2:30:05 PM : For Distributor 000000000001316 Insert Count::1 ### Delete Count::0 4/27/2022 2:30:05 PM : Import AD File --->> AD_1316_20220427_3526500e868a57b5889aad72a18e0c7a.TXT ### 4/27/2022 2:30:05 PM 4/27/2022 2:30:06 PM : For Distributor 000000000000360 Insert Count::1 ### Delete Count::0 4/27/2022 2:30:06 PM : Import AD File --->> AD_360_20220427_5ab0099e6049cf3af24997f15ea87315.TXT ### 4/27/2022 2:30:06 PM 4/27/2022 2:30:06 PM : For Distributor 000000000000363 Insert Count::9 ### Delete Count::3 4/27/2022 2:30:06 PM : Import AD File --->> AD_363_20220427_c4e26cd7c23a1027d7e6056090140f2e.TXT ### 4/27/2022 2:30:06 PM 4/27/2022 2:30:06 PM : For Distributor 000000000000369 Insert Count::37 ### Delete Count::65 4/27/2022 2:30:06 PM : Import AD File --->> AD_369_20220427_c21e2a40724b09d34c1a1790209acf62.TXT ### 4/27/2022 2:30:06 PM 4/27/2022 2:30:07 PM : For Distributor 000000000000373 Insert Count::3 ### Delete Count::0 4/27/2022 2:30:07 PM : Import AD File --->> AD_373_20220427_7072a3d5ba21a067d4cad17460c6b349.TXT ### 4/27/2022 2:30:07 PM 4/27/2022 2:30:07 PM : For Distributor 000000000000665 Insert Count::13 ### Delete Count::0 4/27/2022 2:30:07 PM : Import AD File --->> AD_665_20220427_251048642c1e8b64e4c223ea9dde8d21.TXT ### 4/27/2022 2:30:07 PM 4/27/2022 2:30:07 PM : For Distributor 000000000000815 Insert Count::1 ### Delete Count::0 4/27/2022 2:30:07 PM : Import AD File --->> AD_815_20220427_4f152a830331678d6bd242aa596959cd.TXT ### 4/27/2022 2:30:07 PM 4/27/2022 2:30:07 PM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::0 4/27/2022 2:30:07 PM : Import AD File --->> AD_820_20220427_c132459fe0701453f0b59a483f3936f2.TXT ### 4/27/2022 2:30:07 PM 4/27/2022 2:30:08 PM : For Distributor 000000000001314 Insert Count::3 ### Delete Count::3 4/27/2022 2:30:08 PM : Import DN File --->> DN_1314_20220323_3f30f9275f9b65d189fc789caf7e44e6.TXT ### 4/27/2022 2:30:08 PM 4/27/2022 2:30:09 PM : For Distributor 000000000001314 Insert Count::5 ### Delete Count::0 4/27/2022 2:30:09 PM : Import DN File --->> DN_1314_20220413_4d35b243f8f306f5473e2b296a927fdc.TXT ### 4/27/2022 2:30:09 PM 4/27/2022 2:30:13 PM : For Distributor 000000000000363 Insert Count::2 ### Delete Count::2 4/27/2022 2:30:13 PM : Import DN File --->> DN_363_20220310_c8b290827b8048e29692212b15c01cd3.TXT ### 4/27/2022 2:30:13 PM 4/27/2022 2:30:13 PM : For Distributor 000000000000363 Insert Count::4 ### Delete Count::4 4/27/2022 2:30:13 PM : Import DN File --->> DN_363_20220325_986024b8f04f656ca0c5640617843820.TXT ### 4/27/2022 2:30:13 PM 4/27/2022 2:30:14 PM : For Distributor 000000000000365 Insert Count::1 ### Delete Count::0 4/27/2022 2:30:14 PM : Import DN File --->> DN_365_20220416_5fc08f065ad51475f59bbfda52b77265.TXT ### 4/27/2022 2:30:14 PM 4/27/2022 2:30:15 PM : For Distributor 000000000000369 Insert Count::1 ### Delete Count::1 4/27/2022 2:30:15 PM : Import DN File --->> DN_369_20220304_61ef9a2224d7b5a27696521225b1bdbd.TXT ### 4/27/2022 2:30:15 PM 4/27/2022 2:30:16 PM : For Distributor 000000000000369 Insert Count::1 ### Delete Count::1 4/27/2022 2:30:16 PM : Import DN File --->> DN_369_20220321_40401513154ae607d0c19ab13226d8d0.TXT ### 4/27/2022 2:30:16 PM 4/27/2022 2:30:17 PM : For Distributor 000000000000369 Insert Count::6 ### Delete Count::0 4/27/2022 2:30:17 PM : Import DN File --->> DN_369_20220420_01cd80d3917648172b192c18adcdd84a.TXT ### 4/27/2022 2:30:17 PM 4/27/2022 2:30:20 PM : For Distributor 000000000000665 Insert Count::15 ### Delete Count::0 4/27/2022 2:30:20 PM : Import DN File --->> DN_665_20220422_6087de0557cd92e5511f2461ccc6d532.TXT ### 4/27/2022 2:30:20 PM 4/27/2022 2:30:20 PM : For Distributor 000000000000665 Insert Count::1 ### Delete Count::0 4/27/2022 2:30:20 PM : Import DN File --->> DN_665_20220423_fa2361569b861988b7fe93f14c861df0.TXT ### 4/27/2022 2:30:20 PM 4/27/2022 2:30:22 PM : For Distributor 000000000000815 Insert Count::5 ### Delete Count::5 4/27/2022 2:30:22 PM : Import DN File --->> DN_815_20220425_2d1a0129102bb7bf9642d6ab9fa0d293.TXT ### 4/27/2022 2:30:22 PM 4/27/2022 2:30:24 PM : For Distributor 000000000001026 Insert Count::2 ### Delete Count::0 4/27/2022 2:30:24 PM : Import IN File --->> IN_1026_20220427_d56d2be5f1ec50cb7b35f1be7a094463.TXT ### 4/27/2022 2:30:24 PM 4/27/2022 2:30:24 PM : For Distributor 000000000001314 Insert Count::1 ### Delete Count::1 4/27/2022 2:30:24 PM : Import IN File --->> IN_1314_20220301_0f020d7a2b38e474ce537927ef264760.TXT ### 4/27/2022 2:30:24 PM 4/27/2022 2:30:24 PM : For Distributor 000000000001314 Insert Count::3 ### Delete Count::3 4/27/2022 2:30:24 PM : Import IN File --->> IN_1314_20220302_bdc6839e450635fd1d3b96fdb8163e65.TXT ### 4/27/2022 2:30:24 PM 4/27/2022 2:30:24 PM : For Distributor 000000000001314 Insert Count::2 ### Delete Count::2 4/27/2022 2:30:24 PM : Import IN File --->> IN_1314_20220303_575afd2073991c92efe8d000c8f291e8.TXT ### 4/27/2022 2:30:24 PM 4/27/2022 2:30:24 PM : For Distributor 000000000001314 Insert Count::3 ### Delete Count::3 4/27/2022 2:30:24 PM : Import IN File --->> IN_1314_20220304_9f238866c3937172c1f6dcbf898bb4f9.TXT ### 4/27/2022 2:30:24 PM 4/27/2022 2:30:24 PM : For Distributor 000000000001314 Insert Count::1 ### Delete Count::1 4/27/2022 2:30:24 PM : Import IN File --->> IN_1314_20220305_a90124ab028a4a66079a85e56456674f.TXT ### 4/27/2022 2:30:24 PM 4/27/2022 2:30:24 PM : For Distributor 000000000001314 Insert Count::1 ### Delete Count::1 4/27/2022 2:30:24 PM : Import IN File --->> IN_1314_20220307_52c879f0231d2a688f6f37d112d7328a.TXT ### 4/27/2022 2:30:24 PM 4/27/2022 2:30:25 PM : For Distributor 000000000001314 Insert Count::4 ### Delete Count::4 4/27/2022 2:30:25 PM : Import IN File --->> IN_1314_20220308_03dc8dcc701b9014469151f910c9e59b.TXT ### 4/27/2022 2:30:25 PM 4/27/2022 2:30:25 PM : For Distributor 000000000001314 Insert Count::3 ### Delete Count::3 4/27/2022 2:30:25 PM : Import IN File --->> IN_1314_20220310_fd1e7fc06d7b7fe677155f4938bb062d.TXT ### 4/27/2022 2:30:25 PM 4/27/2022 2:30:25 PM : For Distributor 000000000001314 Insert Count::2 ### Delete Count::2 4/27/2022 2:30:25 PM : Import IN File --->> IN_1314_20220311_f8feb95013e79088c8b4a9bd59e3ac49.TXT ### 4/27/2022 2:30:25 PM 4/27/2022 2:30:25 PM : For Distributor 000000000001314 Insert Count::5 ### Delete Count::5 4/27/2022 2:30:25 PM : Import IN File --->> IN_1314_20220314_123bfeaccd6854fe6ac9810552512b1f.TXT ### 4/27/2022 2:30:25 PM 4/27/2022 2:30:25 PM : For Distributor 000000000001314 Insert Count::2 ### Delete Count::2 4/27/2022 2:30:25 PM : Import IN File --->> IN_1314_20220315_eab5f63c1477aa913f9884a8ae329e75.TXT ### 4/27/2022 2:30:25 PM 4/27/2022 2:30:25 PM : For Distributor 000000000001314 Insert Count::3 ### Delete Count::3 4/27/2022 2:30:25 PM : Import IN File --->> IN_1314_20220316_70e90eb2331eb5aadf265c7a0f8be1b3.TXT ### 4/27/2022 2:30:25 PM 4/27/2022 2:30:26 PM : For Distributor 000000000001314 Insert Count::2 ### Delete Count::2 4/27/2022 2:30:26 PM : Import IN File --->> IN_1314_20220317_6c891071aa99424b297902334c14a006.TXT ### 4/27/2022 2:30:26 PM 4/27/2022 2:30:26 PM : For Distributor 000000000001314 Insert Count::1 ### Delete Count::1 4/27/2022 2:30:26 PM : Import IN File --->> IN_1314_20220319_93516082585a881180bf5de5d1956f9c.TXT ### 4/27/2022 2:30:26 PM 4/27/2022 2:30:26 PM : For Distributor 000000000001314 Insert Count::1 ### Delete Count::1 4/27/2022 2:30:26 PM : Import IN File --->> IN_1314_20220321_687c504a17e30e8bdd89735e9504385f.TXT ### 4/27/2022 2:30:26 PM 4/27/2022 2:30:26 PM : For Distributor 000000000001314 Insert Count::1 ### Delete Count::1 4/27/2022 2:30:26 PM : Import IN File --->> IN_1314_20220322_69ddfee8710440622a6f5c510fa431a5.TXT ### 4/27/2022 2:30:26 PM 4/27/2022 2:30:26 PM : For Distributor 000000000001314 Insert Count::2 ### Delete Count::2 4/27/2022 2:30:26 PM : Import IN File --->> IN_1314_20220323_25c55d612e2452cd017b035c538c602d.TXT ### 4/27/2022 2:30:26 PM 4/27/2022 2:30:26 PM : For Distributor 000000000001314 Insert Count::4 ### Delete Count::4 4/27/2022 2:30:26 PM : Import IN File --->> IN_1314_20220325_4c00812615d31428144ef880fd50b794.TXT ### 4/27/2022 2:30:26 PM 4/27/2022 2:30:26 PM : For Distributor 000000000001314 Insert Count::2 ### Delete Count::2 4/27/2022 2:30:26 PM : Import IN File --->> IN_1314_20220326_63784d6244b5b16f5aa50b93c7b90723.TXT ### 4/27/2022 2:30:26 PM 4/27/2022 2:30:27 PM : For Distributor 000000000001314 Insert Count::3 ### Delete Count::3 4/27/2022 2:30:27 PM : Import IN File --->> IN_1314_20220328_aed004a80d9035cf602906460089ecef.TXT ### 4/27/2022 2:30:27 PM 4/27/2022 2:30:27 PM : For Distributor 000000000001314 Insert Count::2 ### Delete Count::2 4/27/2022 2:30:27 PM : Import IN File --->> IN_1314_20220329_29fc6f097f316d9d6d807140a61468d8.TXT ### 4/27/2022 2:30:27 PM 4/27/2022 2:30:27 PM : For Distributor 000000000001314 Insert Count::3 ### Delete Count::3 4/27/2022 2:30:27 PM : Import IN File --->> IN_1314_20220330_6bda6ab97ef380dab8fb013871cb901e.TXT ### 4/27/2022 2:30:27 PM 4/27/2022 2:30:27 PM : For Distributor 000000000001314 Insert Count::2 ### Delete Count::2 4/27/2022 2:30:27 PM : Import IN File --->> IN_1314_20220331_cc59335c0b9c16b8bd9e395603fe2d4b.TXT ### 4/27/2022 2:30:27 PM 4/27/2022 2:30:27 PM : For Distributor 000000000001314 Insert Count::1 ### Delete Count::1 4/27/2022 2:30:27 PM : Import IN File --->> IN_1314_20220401_449b2c3ac020d817f3b6cc7d6aac4808.TXT ### 4/27/2022 2:30:27 PM 4/27/2022 2:30:27 PM : For Distributor 000000000001314 Insert Count::1 ### Delete Count::1 4/27/2022 2:30:27 PM : Import IN File --->> IN_1314_20220404_4154e61f1158034fadf474566323b2e9.TXT ### 4/27/2022 2:30:27 PM 4/27/2022 2:30:28 PM : For Distributor 000000000001314 Insert Count::6 ### Delete Count::0 4/27/2022 2:30:28 PM : Import IN File --->> IN_1314_20220405_238486f107d67b9b9214cae6e2cc45cb.TXT ### 4/27/2022 2:30:28 PM 4/27/2022 2:30:28 PM : For Distributor 000000000001314 Insert Count::2 ### Delete Count::0 4/27/2022 2:30:28 PM : Import IN File --->> IN_1314_20220406_76c0e21fd6ae4b9bc1d8dee9af53f168.TXT ### 4/27/2022 2:30:28 PM 4/27/2022 2:30:28 PM : For Distributor 000000000001314 Insert Count::1 ### Delete Count::0 4/27/2022 2:30:28 PM : Import IN File --->> IN_1314_20220407_2d1f6789f11648432d10e04a4666015e.TXT ### 4/27/2022 2:30:28 PM 4/27/2022 2:30:28 PM : For Distributor 000000000001314 Insert Count::4 ### Delete Count::0 4/27/2022 2:30:28 PM : Import IN File --->> IN_1314_20220408_bc664d77cea215d4e87636dcc0683e35.TXT ### 4/27/2022 2:30:28 PM 4/27/2022 2:30:28 PM : For Distributor 000000000001314 Insert Count::5 ### Delete Count::0 4/27/2022 2:30:28 PM : Import IN File --->> IN_1314_20220409_203b8a2b03758151ae51e60addbc975b.TXT ### 4/27/2022 2:30:28 PM 4/27/2022 2:30:28 PM : For Distributor 000000000001314 Insert Count::3 ### Delete Count::3 4/27/2022 2:30:28 PM : Import IN File --->> IN_1314_20220411_a97f2ded66fec62f17e6e8db9fecb4e6.TXT ### 4/27/2022 2:30:28 PM 4/27/2022 2:30:28 PM : For Distributor 000000000001314 Insert Count::4 ### Delete Count::4 4/27/2022 2:30:28 PM : Import IN File --->> IN_1314_20220412_7b052ce054a9790e416d052578a5a508.TXT ### 4/27/2022 2:30:28 PM 4/27/2022 2:30:28 PM : For Distributor 000000000001314 Insert Count::4 ### Delete Count::4 4/27/2022 2:30:28 PM : Import IN File --->> IN_1314_20220413_2c43596bda0f8051610bdc0953c0c3d5.TXT ### 4/27/2022 2:30:28 PM 4/27/2022 2:30:31 PM : For Distributor 000000000001316 Insert Count::1 ### Delete Count::0 4/27/2022 2:30:31 PM : Import IN File --->> IN_1316_20220427_1771d77a6cc911d05937e961d5d14dfd.TXT ### 4/27/2022 2:30:31 PM 4/27/2022 2:30:32 PM : For Distributor 000000000001317 Insert Count::2 ### Delete Count::2 4/27/2022 2:30:32 PM : Import IN File --->> IN_1317_20220406_1a98c706458efed412f79a960290c3d4.TXT ### 4/27/2022 2:30:32 PM 4/27/2022 2:30:32 PM : For Distributor 000000000001317 Insert Count::2 ### Delete Count::2 4/27/2022 2:30:32 PM : Import IN File --->> IN_1317_20220407_f01291e8651e824470b98a40d7462269.TXT ### 4/27/2022 2:30:32 PM 4/27/2022 2:30:32 PM : For Distributor 000000000001317 Insert Count::2 ### Delete Count::2 4/27/2022 2:30:32 PM : Import IN File --->> IN_1317_20220408_59c34d9bf262fb9f8a2ba368952e2f88.TXT ### 4/27/2022 2:30:32 PM 4/27/2022 2:30:32 PM : For Distributor 000000000001317 Insert Count::5 ### Delete Count::5 4/27/2022 2:30:32 PM : Import IN File --->> IN_1317_20220411_fda7c0ea0e93790630e2952b1fa7348d.TXT ### 4/27/2022 2:30:32 PM 4/27/2022 2:30:33 PM : For Distributor 000000000001317 Insert Count::1 ### Delete Count::1 4/27/2022 2:30:33 PM : Import IN File --->> IN_1317_20220415_1a3cf1ef34c1aaf9ef2473aa8eaf3eb5.TXT ### 4/27/2022 2:30:33 PM 4/27/2022 2:30:33 PM : For Distributor 000000000001317 Insert Count::1 ### Delete Count::1 4/27/2022 2:30:33 PM : Import IN File --->> IN_1317_20220416_23df6b0a30cf095eeaa44ec6331b6f3c.TXT ### 4/27/2022 2:30:33 PM 4/27/2022 2:30:33 PM : For Distributor 000000000001317 Insert Count::3 ### Delete Count::3 4/27/2022 2:30:33 PM : Import IN File --->> IN_1317_20220418_46c497ab8d097ff68789a54796b0bce7.TXT ### 4/27/2022 2:30:33 PM 4/27/2022 2:30:33 PM : For Distributor 000000000001317 Insert Count::1 ### Delete Count::1 4/27/2022 2:30:33 PM : Import IN File --->> IN_1317_20220419_1a2ba54454d8feafa79ab255ddd5910c.TXT ### 4/27/2022 2:30:33 PM 4/27/2022 2:30:33 PM : For Distributor 000000000001317 Insert Count::1 ### Delete Count::1 4/27/2022 2:30:33 PM : Import IN File --->> IN_1317_20220420_1a1935d01bc99e76917bf208dcd656bf.TXT ### 4/27/2022 2:30:33 PM 4/27/2022 2:30:38 PM : For Distributor 000000000000360 Insert Count::1 ### Delete Count::0 4/27/2022 2:30:38 PM : Import IN File --->> IN_360_20220426_3ba56d685c8f21c3b907d2063ad51336.TXT ### 4/27/2022 2:30:38 PM 4/27/2022 2:30:38 PM : For Distributor 000000000000363 Insert Count::1 ### Delete Count::1 4/27/2022 2:30:38 PM : Import IN File --->> IN_363_20220302_2afc9a25389063552fb5b1cca86a2834.TXT ### 4/27/2022 2:30:38 PM 4/27/2022 2:30:38 PM : For Distributor 000000000000363 Insert Count::2 ### Delete Count::2 4/27/2022 2:30:38 PM : Import IN File --->> IN_363_20220303_b5d1e881fe805bd198c698f7902980a1.TXT ### 4/27/2022 2:30:38 PM 4/27/2022 2:30:39 PM : For Distributor 000000000000363 Insert Count::1 ### Delete Count::1 4/27/2022 2:30:39 PM : Import IN File --->> IN_363_20220305_0317f8ac31eeea44797d0b074fbbd7c0.TXT ### 4/27/2022 2:30:39 PM 4/27/2022 2:30:39 PM : For Distributor 000000000000363 Insert Count::2 ### Delete Count::2 4/27/2022 2:30:39 PM : Import IN File --->> IN_363_20220309_28b8710928a1fc4b2078117a18c866fa.TXT ### 4/27/2022 2:30:39 PM 4/27/2022 2:30:39 PM : For Distributor 000000000000363 Insert Count::1 ### Delete Count::1 4/27/2022 2:30:39 PM : Import IN File --->> IN_363_20220310_bd1e9e55328639665544553c665b640b.TXT ### 4/27/2022 2:30:39 PM 4/27/2022 2:30:39 PM : For Distributor 000000000000363 Insert Count::1 ### Delete Count::1 4/27/2022 2:30:39 PM : Import IN File --->> IN_363_20220311_c8eb6f0e6739e412bed523d35134bbe7.TXT ### 4/27/2022 2:30:39 PM 4/27/2022 2:30:39 PM : For Distributor 000000000000363 Insert Count::1 ### Delete Count::1 4/27/2022 2:30:39 PM : Import IN File --->> IN_363_20220312_a6d783960f84ad378b70b4cc571f2678.TXT ### 4/27/2022 2:30:39 PM 4/27/2022 2:30:39 PM : For Distributor 000000000000363 Insert Count::3 ### Delete Count::3 4/27/2022 2:30:39 PM : Import IN File --->> IN_363_20220317_94eacae14b4cd7c8af91b42f061b81f6.TXT ### 4/27/2022 2:30:39 PM 4/27/2022 2:30:40 PM : For Distributor 000000000000363 Insert Count::5 ### Delete Count::5 4/27/2022 2:30:40 PM : Import IN File --->> IN_363_20220318_2a31b81321deae3296dd7cdd225d05b4.TXT ### 4/27/2022 2:30:40 PM 4/27/2022 2:30:40 PM : For Distributor 000000000000363 Insert Count::1 ### Delete Count::1 4/27/2022 2:30:40 PM : Import IN File --->> IN_363_20220322_f39f8acd015cd8f4e3ea8ae04b1757e5.TXT ### 4/27/2022 2:30:40 PM 4/27/2022 2:30:40 PM : For Distributor 000000000000363 Insert Count::4 ### Delete Count::4 4/27/2022 2:30:40 PM : Import IN File --->> IN_363_20220323_ba7f8a99a16d95d63d7f95ffc304a222.TXT ### 4/27/2022 2:30:40 PM 4/27/2022 2:30:41 PM : For Distributor 000000000000363 Insert Count::4 ### Delete Count::4 4/27/2022 2:30:41 PM : Import IN File --->> IN_363_20220329_695ffdaf7b574413d298e2389a45f6fb.TXT ### 4/27/2022 2:30:41 PM 4/27/2022 2:30:41 PM : For Distributor 000000000000363 Insert Count::3 ### Delete Count::0 4/27/2022 2:30:41 PM : Import IN File --->> IN_363_20220331_7ca730caf603a057b315fcf746afdbec.TXT ### 4/27/2022 2:30:41 PM 4/27/2022 2:30:41 PM : For Distributor 000000000000363 Insert Count::2 ### Delete Count::0 4/27/2022 2:30:41 PM : Import IN File --->> IN_363_20220401_75c320af562a7eb3407400913ca91806.TXT ### 4/27/2022 2:30:41 PM 4/27/2022 2:30:41 PM : For Distributor 000000000000363 Insert Count::4 ### Delete Count::0 4/27/2022 2:30:41 PM : Import IN File --->> IN_363_20220404_6d750ec88f2aa5e5ff007014d2756efe.TXT ### 4/27/2022 2:30:41 PM 4/27/2022 2:30:41 PM : For Distributor 000000000000363 Insert Count::4 ### Delete Count::0 4/27/2022 2:30:41 PM : Import IN File --->> IN_363_20220405_b77af7e4b1d75cfa3a8ae2efd6bade14.TXT ### 4/27/2022 2:30:41 PM 4/27/2022 2:30:41 PM : For Distributor 000000000000363 Insert Count::1 ### Delete Count::0 4/27/2022 2:30:41 PM : Import IN File --->> IN_363_20220406_9a42bcce4321a1dd78af32762911f00c.TXT ### 4/27/2022 2:30:41 PM 4/27/2022 2:30:41 PM : Import IN File --->> IN_363_20220409_7f5356fc6537d137531a875eab7e7d5c.TXT ### 4/27/2022 2:30:41 PM 4/27/2022 2:30:41 PM : NO Previous File For Distributor 000000000000363 ### Insert Count::2 4/27/2022 2:30:41 PM : Import IN File --->> IN_363_20220411_e1081cf914288332d90b7f1dda8f4e96.TXT ### 4/27/2022 2:30:41 PM 4/27/2022 2:30:41 PM : NO Previous File For Distributor 000000000000363 ### Insert Count::2 4/27/2022 2:30:41 PM : Import IN File --->> IN_363_20220412_b18ce21ee1e3f98a98398319787027d5.TXT ### 4/27/2022 2:30:41 PM 4/27/2022 2:30:42 PM : NO Previous File For Distributor 000000000000363 ### Insert Count::1 4/27/2022 2:30:42 PM : Import IN File --->> IN_363_20220413_631ebda0b71fd7a8fffc5b8e999a26cf.TXT ### 4/27/2022 2:30:42 PM 4/27/2022 2:30:42 PM : NO Previous File For Distributor 000000000000363 ### Insert Count::5 4/27/2022 2:30:42 PM : Import IN File --->> IN_363_20220414_0e3c15ad20245e709b70239024ba073a.TXT ### 4/27/2022 2:30:42 PM 4/27/2022 2:30:42 PM : NO Previous File For Distributor 000000000000363 ### Insert Count::1 4/27/2022 2:30:42 PM : Import IN File --->> IN_363_20220415_c16f74a3785b1caf35dad0df5b497ce4.TXT ### 4/27/2022 2:30:42 PM 4/27/2022 2:30:42 PM : NO Previous File For Distributor 000000000000363 ### Insert Count::1 4/27/2022 2:30:42 PM : Import IN File --->> IN_363_20220418_5257e849c2f419714f9e3003177fa8b4.TXT ### 4/27/2022 2:30:42 PM 4/27/2022 2:30:42 PM : NO Previous File For Distributor 000000000000363 ### Insert Count::2 4/27/2022 2:30:42 PM : Import IN File --->> IN_363_20220419_1e4a7327147b05495391fc22d7c3fe37.TXT ### 4/27/2022 2:30:42 PM 4/27/2022 2:30:42 PM : NO Previous File For Distributor 000000000000363 ### Insert Count::4 4/27/2022 2:30:42 PM : Import IN File --->> IN_363_20220420_6aab6a90c25b81024629e08ef9cc77a0.TXT ### 4/27/2022 2:30:42 PM 4/27/2022 2:30:42 PM : NO Previous File For Distributor 000000000000363 ### Insert Count::2 4/27/2022 2:30:42 PM : Import IN File --->> IN_363_20220421_fc9d52f52c78cd44ecec5c1dbaa00e6c.TXT ### 4/27/2022 2:30:42 PM 4/27/2022 2:30:42 PM : NO Previous File For Distributor 000000000000363 ### Insert Count::2 4/27/2022 2:30:42 PM : Import IN File --->> IN_363_20220422_f6936ebd07b94db72b432ef836cafaa1.TXT ### 4/27/2022 2:30:42 PM 4/27/2022 2:30:42 PM : NO Previous File For Distributor 000000000000363 ### Insert Count::4 4/27/2022 2:30:42 PM : Import IN File --->> IN_363_20220423_d3b6cc3eb3df46bac222e2dafdc4ea7d.TXT ### 4/27/2022 2:30:42 PM 4/27/2022 2:30:42 PM : NO Previous File For Distributor 000000000000363 ### Insert Count::4 4/27/2022 2:30:42 PM : Import IN File --->> IN_363_20220425_762946d1a2486d28027ce14e79f45184.TXT ### 4/27/2022 2:30:42 PM 4/27/2022 2:30:42 PM : NO Previous File For Distributor 000000000000363 ### Insert Count::4 4/27/2022 2:30:43 PM : Import IN File --->> IN_365_20220421_fd4743c87d0d3221b2f3730b41a332ba.TXT ### 4/27/2022 2:30:43 PM 4/27/2022 2:30:43 PM : NO Previous File For Distributor 000000000000365 ### Insert Count::5 4/27/2022 2:30:44 PM : For Distributor 000000000000369 Insert Count::2 ### Delete Count::2 4/27/2022 2:30:44 PM : Import IN File --->> IN_369_20220302_f36bd271d81af4e2922f9e9dfa5f33a7.TXT ### 4/27/2022 2:30:44 PM 4/27/2022 2:30:44 PM : For Distributor 000000000000369 Insert Count::7 ### Delete Count::7 4/27/2022 2:30:44 PM : Import IN File --->> IN_369_20220303_9bc9911e69d9225ac9fc6321b2a5e245.TXT ### 4/27/2022 2:30:44 PM 4/27/2022 2:30:44 PM : For Distributor 000000000000369 Insert Count::1 ### Delete Count::1 4/27/2022 2:30:44 PM : Import IN File --->> IN_369_20220304_c82dfd64abdb8fb5d108a6fb734996e8.TXT ### 4/27/2022 2:30:44 PM 4/27/2022 2:30:44 PM : For Distributor 000000000000369 Insert Count::1 ### Delete Count::1 4/27/2022 2:30:44 PM : Import IN File --->> IN_369_20220307_defd7862bf726d3dce9a145ff0168d50.TXT ### 4/27/2022 2:30:44 PM 4/27/2022 2:30:44 PM : For Distributor 000000000000369 Insert Count::2 ### Delete Count::2 4/27/2022 2:30:44 PM : Import IN File --->> IN_369_20220308_b1fcd1cbd8d1cccf27405156b9187da7.TXT ### 4/27/2022 2:30:44 PM 4/27/2022 2:30:44 PM : For Distributor 000000000000369 Insert Count::3 ### Delete Count::3 4/27/2022 2:30:44 PM : Import IN File --->> IN_369_20220310_d5c801b561575f4779ed70815d0e936a.TXT ### 4/27/2022 2:30:44 PM 4/27/2022 2:30:45 PM : For Distributor 000000000000369 Insert Count::1 ### Delete Count::1 4/27/2022 2:30:45 PM : Import IN File --->> IN_369_20220311_5c4b4f4d6742979c24429dc9b795aecf.TXT ### 4/27/2022 2:30:45 PM 4/27/2022 2:30:45 PM : For Distributor 000000000000369 Insert Count::2 ### Delete Count::2 4/27/2022 2:30:45 PM : Import IN File --->> IN_369_20220312_91fe80df9a108fed7d3f2fc00ceae05a.TXT ### 4/27/2022 2:30:45 PM 4/27/2022 2:30:45 PM : For Distributor 000000000000369 Insert Count::3 ### Delete Count::3 4/27/2022 2:30:45 PM : Import IN File --->> IN_369_20220317_02874be6f74171664c340edc68418d15.TXT ### 4/27/2022 2:30:45 PM 4/27/2022 2:30:45 PM : For Distributor 000000000000369 Insert Count::1 ### Delete Count::1 4/27/2022 2:30:45 PM : Import IN File --->> IN_369_20220318_c4cb5f02928c00a9992ff1217264e05d.TXT ### 4/27/2022 2:30:45 PM 4/27/2022 2:30:45 PM : For Distributor 000000000000369 Insert Count::2 ### Delete Count::2 4/27/2022 2:30:45 PM : Import IN File --->> IN_369_20220321_ee9ac085ada0983f9f6a658b118bbd4e.TXT ### 4/27/2022 2:30:45 PM 4/27/2022 2:30:46 PM : For Distributor 000000000000369 Insert Count::6 ### Delete Count::6 4/27/2022 2:30:46 PM : Import IN File --->> IN_369_20220322_56f9528aac7c8da1b77a49f45e47af22.TXT ### 4/27/2022 2:30:46 PM 4/27/2022 2:30:46 PM : For Distributor 000000000000369 Insert Count::4 ### Delete Count::4 4/27/2022 2:30:46 PM : Import IN File --->> IN_369_20220323_263bff5fc4ffe6f2e597a52c4dab23b3.TXT ### 4/27/2022 2:30:46 PM 4/27/2022 2:30:46 PM : For Distributor 000000000000369 Insert Count::7 ### Delete Count::7 4/27/2022 2:30:46 PM : Import IN File --->> IN_369_20220324_2a11607623b11bc3cbae30f6d9fbdd6e.TXT ### 4/27/2022 2:30:46 PM 4/27/2022 2:30:46 PM : For Distributor 000000000000369 Insert Count::2 ### Delete Count::2 4/27/2022 2:30:46 PM : Import IN File --->> IN_369_20220326_e4a1c72a4286a7d901d43bf82fb79f50.TXT ### 4/27/2022 2:30:46 PM 4/27/2022 2:30:46 PM : For Distributor 000000000000369 Insert Count::6 ### Delete Count::6 4/27/2022 2:30:46 PM : Import IN File --->> IN_369_20220328_7aab5b65b1b06f24052b901a158a692f.TXT ### 4/27/2022 2:30:46 PM 4/27/2022 2:30:46 PM : For Distributor 000000000000369 Insert Count::2 ### Delete Count::2 4/27/2022 2:30:46 PM : Import IN File --->> IN_369_20220330_43f811dc36df81950bf32454786eeba6.TXT ### 4/27/2022 2:30:46 PM 4/27/2022 2:30:47 PM : For Distributor 000000000000369 Insert Count::5 ### Delete Count::0 4/27/2022 2:30:47 PM : Import IN File --->> IN_369_20220401_fc5b02c40ca050be712c5cfe7bac8a9e.TXT ### 4/27/2022 2:30:47 PM 4/27/2022 2:30:47 PM : For Distributor 000000000000369 Insert Count::7 ### Delete Count::0 4/27/2022 2:30:47 PM : Import IN File --->> IN_369_20220405_59d93071d5a5af450d13e3d34ca1b1a0.TXT ### 4/27/2022 2:30:47 PM 4/27/2022 2:30:47 PM : For Distributor 000000000000369 Insert Count::8 ### Delete Count::0 4/27/2022 2:30:47 PM : Import IN File --->> IN_369_20220406_50ff5e502f62df3f73455a4d658bef7c.TXT ### 4/27/2022 2:30:47 PM 4/27/2022 2:30:47 PM : For Distributor 000000000000369 Insert Count::4 ### Delete Count::0 4/27/2022 2:30:47 PM : Import IN File --->> IN_369_20220407_7249c2ce82768afc1a34b07fe750806f.TXT ### 4/27/2022 2:30:47 PM 4/27/2022 2:30:47 PM : For Distributor 000000000000369 Insert Count::17 ### Delete Count::0 4/27/2022 2:30:47 PM : Import IN File --->> IN_369_20220408_58acbea245c664ce0479e88d8db57758.TXT ### 4/27/2022 2:30:47 PM 4/27/2022 2:30:47 PM : For Distributor 000000000000369 Insert Count::5 ### Delete Count::0 4/27/2022 2:30:47 PM : Import IN File --->> IN_369_20220411_3dbd745bbd17bd287722203f0a546fae.TXT ### 4/27/2022 2:30:47 PM 4/27/2022 2:30:48 PM : For Distributor 000000000000369 Insert Count::6 ### Delete Count::0 4/27/2022 2:30:48 PM : Import IN File --->> IN_369_20220412_344d35be978e5011208cb3c97c1f0e5a.TXT ### 4/27/2022 2:30:48 PM 4/27/2022 2:30:48 PM : For Distributor 000000000000369 Insert Count::4 ### Delete Count::0 4/27/2022 2:30:48 PM : Import IN File --->> IN_369_20220413_6a6e728b2297b39682ce4c2abfb94d69.TXT ### 4/27/2022 2:30:48 PM 4/27/2022 2:30:48 PM : For Distributor 000000000000369 Insert Count::9 ### Delete Count::0 4/27/2022 2:30:48 PM : Import IN File --->> IN_369_20220414_463d6db07ca85a0f8643569fe3ed8301.TXT ### 4/27/2022 2:30:48 PM 4/27/2022 2:30:48 PM : For Distributor 000000000000369 Insert Count::4 ### Delete Count::0 4/27/2022 2:30:48 PM : Import IN File --->> IN_369_20220415_e09e510a3901042d67a623fc0845dcd6.TXT ### 4/27/2022 2:30:48 PM 4/27/2022 2:30:48 PM : For Distributor 000000000000369 Insert Count::7 ### Delete Count::0 4/27/2022 2:30:48 PM : Import IN File --->> IN_369_20220416_956095b63c30b84ae0d62d3c557d2cff.TXT ### 4/27/2022 2:30:48 PM 4/27/2022 2:30:48 PM : For Distributor 000000000000369 Insert Count::2 ### Delete Count::0 4/27/2022 2:30:48 PM : Import IN File --->> IN_369_20220418_a1d9dd668e090615fad2a86c21e310e0.TXT ### 4/27/2022 2:30:48 PM 4/27/2022 2:30:48 PM : For Distributor 000000000000369 Insert Count::4 ### Delete Count::0 4/27/2022 2:30:48 PM : Import IN File --->> IN_369_20220419_047f30468c05389b896bafbe596fb9f2.TXT ### 4/27/2022 2:30:48 PM 4/27/2022 2:30:48 PM : For Distributor 000000000000369 Insert Count::5 ### Delete Count::0 4/27/2022 2:30:48 PM : Import IN File --->> IN_369_20220420_1c4721ba09c2c77b198b6becfd133bcf.TXT ### 4/27/2022 2:30:48 PM 4/27/2022 2:30:48 PM : For Distributor 000000000000369 Insert Count::8 ### Delete Count::0 4/27/2022 2:30:48 PM : Import IN File --->> IN_369_20220421_2af449981f6b2396669ad98ec94717a4.TXT ### 4/27/2022 2:30:48 PM 4/27/2022 2:30:49 PM : For Distributor 000000000000369 Insert Count::6 ### Delete Count::0 4/27/2022 2:30:49 PM : Import IN File --->> IN_369_20220423_352ce5ba373c52b6187f3dd4985fd0d2.TXT ### 4/27/2022 2:30:49 PM 4/27/2022 2:30:49 PM : For Distributor 000000000000369 Insert Count::20 ### Delete Count::0 4/27/2022 2:30:49 PM : Import IN File --->> IN_369_20220425_7ee7f6ce810aeeea5a8e3d19ed829de6.TXT ### 4/27/2022 2:30:49 PM 4/27/2022 2:30:49 PM : For Distributor 000000000000369 Insert Count::1 ### Delete Count::0 4/27/2022 2:30:49 PM : Import IN File --->> IN_369_20220426_ea2a0a442e0f13ee894ecedd37e5abe1.TXT ### 4/27/2022 2:30:49 PM 4/27/2022 2:30:49 PM : Import IN File --->> IN_369_20220427_c47d1a416c8b0f3b6c8e161e9945189e.TXT ### 4/27/2022 2:30:49 PM 4/27/2022 2:30:49 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::4 4/27/2022 2:30:50 PM : Import IN File --->> IN_373_20220427_0b923e261996ed677b4f256ef543ad00.TXT ### 4/27/2022 2:30:50 PM 4/27/2022 2:30:50 PM : NO Previous File For Distributor 000000000000373 ### Insert Count::4 4/27/2022 2:30:52 PM : For Distributor 000000000000665 Insert Count::10 ### Delete Count::0 4/27/2022 2:30:52 PM : Import IN File --->> IN_665_20220426_f0e6383153f8ed538786b9195e922ba1.TXT ### 4/27/2022 2:30:52 PM 4/27/2022 2:30:52 PM : Import IN File --->> IN_665_20220427_6dd4a2d0808dfee87c68fb62b308d01f.TXT ### 4/27/2022 2:30:52 PM 4/27/2022 2:30:52 PM : NO Previous File For Distributor 000000000000665 ### Insert Count::15 4/27/2022 2:30:55 PM : For Distributor 000000000000815 Insert Count::1 ### Delete Count::0 4/27/2022 2:30:55 PM : Import IN File --->> IN_815_20220426_db15d19923ddca5141d3efbd0336ee2b.TXT ### 4/27/2022 2:30:55 PM 4/27/2022 2:30:55 PM : Import IN File --->> IN_815_20220427_dc56e6f0703e9e115e188fd042c86f2c.TXT ### 4/27/2022 2:30:55 PM 4/27/2022 2:30:55 PM : NO Previous File For Distributor 000000000000815 ### Insert Count::1 4/27/2022 2:30:57 PM : For Distributor 000000000000820 Insert Count::3 ### Delete Count::0 4/27/2022 2:30:57 PM : Import IN File --->> IN_820_20220405_0ef26a57d313349cac7ef710eaf124fa.TXT ### 4/27/2022 2:30:57 PM 4/27/2022 2:30:58 PM : For Distributor 000000000000820 Insert Count::4 ### Delete Count::0 4/27/2022 2:30:58 PM : Import IN File --->> IN_820_20220427_53b873aaa161c7e07a2187749b4a1a5e.TXT ### 4/27/2022 2:30:58 PM 4/27/2022 2:30:58 PM : Import OT File --->> OT_369_20220411_c0df1c8c15173c736968226a46df1fbd.TXT ### 4/27/2022 2:30:58 PM 4/27/2022 2:30:58 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::1 4/27/2022 2:30:59 PM : Import OT File --->> OT_369_20220426_508479cf56096afda75073216a6271d0.TXT ### 4/27/2022 2:30:59 PM 4/27/2022 2:30:59 PM : NO Previous File For Distributor 000000000000369 ### Insert Count::2 4/27/2022 2:31:00 PM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::0 4/27/2022 2:31:00 PM : Import OT File --->> OT_820_20220426_50ddeb316f9afd9e5cd03b2a8ca207da.TXT ### 4/27/2022 2:31:00 PM 4/27/2022 2:31:00 PM : Import OT File --->> OT_820_20220427_cd99df1c0d5d19bf9673033d7a69cdac.TXT ### 4/27/2022 2:31:00 PM 4/27/2022 2:31:00 PM : NO Previous File For Distributor 000000000000820 ### Insert Count::10 4/27/2022 2:31:00 PM : For Distributor 000000000001321 Insert Count::4 ### Delete Count::0 4/27/2022 2:31:00 PM : Import PR File --->> PR_1321_20220427_de5c55f7877cfa0d23400baa3ec340a7.TXT ### 4/27/2022 2:31:00 PM 4/27/2022 2:31:01 PM : For Distributor 000000000000369 Insert Count::14 ### Delete Count::18 4/27/2022 2:31:01 PM : Import PR File --->> PR_369_20220427_960cbfaab0f548ed3bb326acf9467100.TXT ### 4/27/2022 2:31:01 PM 4/27/2022 2:31:01 PM : PostData() --->> ### 4/27/2022 2:31:01 PM 4/27/2022 2:31:08 PM : SP_CreateUnkCustomerUnkItem Successful --->> ### 4/27/2022 2:31:08 PM 4/27/2022 2:31:11 PM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '27/Apr/2022' ### 4/27/2022 2:31:11 PM 4/27/2022 2:31:12 PM : ItemLink Successful --->> exec SP_ItemLinkDiff '27/Apr/2022' ### 4/27/2022 2:31:12 PM 4/27/2022 2:31:12 PM : ### 4/27/2022 2:31:12 PM : UNLINKEDSALES Record Count Before --->> 401 ### 4/27/2022 2:31:12 PM 4/27/2022 2:31:12 PM : UNLINKEDSALES_DEL Record Count Before --->> 162 ### 4/27/2022 2:31:12 PM 4/27/2022 2:31:26 PM : Posting Sales Successful --->> exec prPostLinkedDiffSales '27/Apr/2022' ### 4/27/2022 2:31:26 PM 4/27/2022 2:31:26 PM : UNLINKEDSALES Record Count After --->> 0 ### 4/27/2022 2:31:26 PM 4/27/2022 2:31:26 PM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 4/27/2022 2:31:26 PM 4/27/2022 2:31:26 PM : ### 4/27/2022 2:31:26 PM : Posting Supplierlink Query for Purchases --->> ### 4/27/2022 2:31:26 PM 4/27/2022 2:31:34 PM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '27/Apr/2022' ### 4/27/2022 2:31:34 PM 4/27/2022 2:31:41 PM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '27/Apr/2022' ### 4/27/2022 2:31:41 PM 4/27/2022 2:31:41 PM : Posting Supplierlink Query for CompanyPurchases --->> ### 4/27/2022 2:31:41 PM 4/27/2022 2:31:41 PM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '27/Apr/2022' ### 4/27/2022 2:31:41 PM 4/27/2022 2:31:41 PM : Posting ClosingStock Successful --->> ### 4/27/2022 2:31:41 PM 4/27/2022 2:31:41 PM : FileWiseHashCode Updated for FlagImport=true records --->> ### 4/27/2022 2:31:41 PM 4/27/2022 2:31:41 PM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\ 4/27/2022 2:31:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 4/27/2022 2:31:41 PM 4/27/2022 2:31:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:31:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1986218_TEMPLATE1.TXT ### 4/27/2022 2:31:41 PM 4/27/2022 2:31:41 PM : Count:: ### TEMPLATE1:105 4/27/2022 2:31:48 PM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 2:31:48 PM 4/27/2022 2:31:48 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 4/27/2022 2:31:48 PM 4/27/2022 2:31:48 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:31:48 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 4/27/2022 2:31:48 PM 4/27/2022 2:31:48 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:31:48 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 4/27/2022 2:31:48 PM 4/27/2022 2:31:48 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:31:48 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 4/27/2022 2:31:48 PM 4/27/2022 2:31:48 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:31:48 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2848065_TEMPLATE1.TXT ### 4/27/2022 2:31:48 PM 4/27/2022 2:31:48 PM : Count:: ### TEMPLATE1:78 4/27/2022 2:31:50 PM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 2:31:50 PM 4/27/2022 2:31:50 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3513087_TEMPLATE1.TXT ### 4/27/2022 2:31:50 PM 4/27/2022 2:31:50 PM : Count:: ### TEMPLATE1:39 4/27/2022 2:31:55 PM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 2:31:55 PM 4/27/2022 2:31:55 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 4/27/2022 2:31:55 PM 4/27/2022 2:31:55 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:31:55 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3612379_TEMPLATE1.TXT ### 4/27/2022 2:31:55 PM 4/27/2022 2:31:55 PM : Count:: ### TEMPLATE1:18 4/27/2022 2:31:55 PM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 2:31:55 PM 4/27/2022 2:31:55 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 4/27/2022 2:31:55 PM 4/27/2022 2:31:55 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:31:55 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 4/27/2022 2:31:55 PM 4/27/2022 2:31:55 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:31:55 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 4/27/2022 2:31:55 PM 4/27/2022 2:31:55 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:31:55 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3985879_TEMPLATE1.txt ### 4/27/2022 2:31:55 PM 4/27/2022 2:31:55 PM : Count:: ### TEMPLATE1:15 4/27/2022 2:31:56 PM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 2:31:56 PM 4/27/2022 2:31:56 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 4/27/2022 2:31:56 PM 4/27/2022 2:31:56 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:31:56 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 4/27/2022 2:31:56 PM 4/27/2022 2:31:56 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:31:56 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 4/27/2022 2:31:56 PM 4/27/2022 2:31:56 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:31:56 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060542_TEMPLATE1.TXT ### 4/27/2022 2:31:56 PM 4/27/2022 2:31:56 PM : Count:: ### TEMPLATE1:28 4/27/2022 2:31:59 PM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 2:31:59 PM 4/27/2022 2:31:59 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060893_TEMPLATE1.txt ### 4/27/2022 2:31:59 PM 4/27/2022 2:31:59 PM : Count:: ### TEMPLATE1:503 4/27/2022 2:32:32 PM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 2:32:32 PM 4/27/2022 2:32:32 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 4/27/2022 2:32:32 PM 4/27/2022 2:32:32 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:32:32 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 4/27/2022 2:32:32 PM 4/27/2022 2:32:32 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:32:32 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 4/27/2022 2:32:32 PM 4/27/2022 2:32:32 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:32:32 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062642_TEMPLATE1.txt ### 4/27/2022 2:32:32 PM 4/27/2022 2:32:32 PM : Count:: ### TEMPLATE1:9 4/27/2022 2:32:33 PM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 2:32:33 PM 4/27/2022 2:32:33 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062898_TEMPLATE1.TXT ### 4/27/2022 2:32:33 PM 4/27/2022 2:32:33 PM : Count:: ### TEMPLATE1:32 4/27/2022 2:32:33 PM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 2:32:33 PM 4/27/2022 2:32:33 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 4/27/2022 2:32:33 PM 4/27/2022 2:32:33 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:32:33 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063177_TEMPLATE1.TXT ### 4/27/2022 2:32:33 PM 4/27/2022 2:32:33 PM : Count:: ### TEMPLATE1:233 4/27/2022 2:33:03 PM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 2:33:03 PM 4/27/2022 2:33:03 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 4/27/2022 2:33:03 PM 4/27/2022 2:33:03 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/27/2022 2:33:03 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9064126_TEMPLATE1.txt ### 4/27/2022 2:33:03 PM 4/27/2022 2:33:03 PM : Count:: ### TEMPLATE1:2 4/27/2022 2:33:03 PM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 2:33:03 PM 4/27/2022 2:33:03 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067041_TEMPLATE1.TXT ### 4/27/2022 2:33:03 PM 4/27/2022 2:33:03 PM : Count:: ### TEMPLATE1:96 4/27/2022 2:33:16 PM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 2:33:16 PM 4/27/2022 2:33:16 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067092_TEMPLATE1.TXT ### 4/27/2022 2:33:16 PM 4/27/2022 2:33:16 PM : Count:: ### TEMPLATE1:24 4/27/2022 2:33:19 PM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 2:33:19 PM 4/27/2022 2:33:19 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067111_TEMPLATE1.TXT ### 4/27/2022 2:33:19 PM 4/27/2022 2:33:19 PM : Count:: ### TEMPLATE1:17 4/27/2022 2:33:21 PM : SP_DistributorTemplatePosting Successful --->> ### 4/27/2022 2:33:21 PM 4/27/2022 2:33:21 PM : Template Import Complete ### 4/27/2022 2:33:21 PM 4/27/2022 2:33:24 PM : Completed Updating Has Transaction Flag ### 4/27/2022 2:33:24 PM 4/27/2022 2:33:24 PM : Transaction Table lastEdiDate Update on BrandAlias Update ### 4/27/2022 2:33:24 PM 4/27/2022 2:33:24 PM : Zylem Access Unblocked ### 4/27/2022 2:33:24 PM 4/27/2022 2:33:25 PM : Application Ended ### 4/27/2022 2:33:25 PM