12/14/2021 2: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 12/14/2021 2:30:03 AM : StartProcess ### 12/14/2021 2:30:03 AM 12/14/2021 2:30:03 AM : 11 ### 12/14/2021 2:30:03 AM 12/14/2021 2:30:03 AM : 22 ### 12/14/2021 2:30:03 AM 12/14/2021 2:30:03 AM : 33 ### 12/14/2021 2:30:03 AM 12/14/2021 2:30:03 AM : Application Started ### 12/14/2021 2:30:03 AM 12/14/2021 2:30:03 AM : Start Process : checkAllTablesExists() ### 12/14/2021 2:30:03 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 12/14/2021 2:30:03 AM 12/14/2021 2:30:03 AM : MainForm_Load ### AlertSystem ON 12/14/2021 2:30:04 AM : No. of Files to import (RECEIVEFINAL): ### 693 12/14/2021 2:30:04 AM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 12/14/2021 2:30:04 AM : For Distributor 000000000001274 Insert Count::68 ### Delete Count::1 12/14/2021 2:30:04 AM : Import AD File --->> AD_1274_20211213_f0c864949e7b6332607c086a60df86dc.TXT ### 12/14/2021 2:30:04 AM 12/14/2021 2:30:04 AM : For Distributor 000000000000930 Insert Count::1 ### Delete Count::0 12/14/2021 2:30:04 AM : Import AD File --->> AD_930_20211213_07f98c5eb1ec0d2cbcf06d430ce8c16f.TXT ### 12/14/2021 2:30:04 AM 12/14/2021 2:30:08 AM : For Distributor 000000000000739 Insert Count::1 ### Delete Count::0 12/14/2021 2:30:08 AM : Import DN File --->> DN_739_20211210_394c955e42182cc7b701adb7deb51e7e.TXT ### 12/14/2021 2:30:08 AM 12/14/2021 2:30:08 AM : For Distributor 000000000000739 Insert Count::1 ### Delete Count::0 12/14/2021 2:30:08 AM : Import DN File --->> DN_739_20211211_45513905c8f9a15aa58c937950cf160d.TXT ### 12/14/2021 2:30:08 AM 12/14/2021 2:30:18 AM : For Distributor 000000000001274 Insert Count::9 ### Delete Count::0 12/14/2021 2:30:18 AM : Import IN File --->> IN_1274_20211101_96ac2102384c0db748eca898f17b9233.TXT ### 12/14/2021 2:30:18 AM 12/14/2021 2:30:18 AM : For Distributor 000000000001274 Insert Count::1 ### Delete Count::0 12/14/2021 2:30:18 AM : Import IN File --->> IN_1274_20211104_0b64dda7c178e2d886765a35c1c435e0.TXT ### 12/14/2021 2:30:18 AM 12/14/2021 2:30:18 AM : For Distributor 000000000001274 Insert Count::3 ### Delete Count::0 12/14/2021 2:30:18 AM : Import IN File --->> IN_1274_20211106_9d63941a91fa453923879e07b7c038d1.TXT ### 12/14/2021 2:30:18 AM 12/14/2021 2:30:19 AM : For Distributor 000000000001274 Insert Count::1 ### Delete Count::0 12/14/2021 2:30:19 AM : Import IN File --->> IN_1274_20211107_0a876ec81beb5e57d18ccf1a0ecc1a4b.TXT ### 12/14/2021 2:30:19 AM 12/14/2021 2:30:19 AM : For Distributor 000000000001274 Insert Count::1 ### Delete Count::0 12/14/2021 2:30:19 AM : Import IN File --->> IN_1274_20211108_3e5af229905da6ad53eb7b3a51083b36.TXT ### 12/14/2021 2:30:19 AM 12/14/2021 2:30:19 AM : For Distributor 000000000001274 Insert Count::2 ### Delete Count::0 12/14/2021 2:30:19 AM : Import IN File --->> IN_1274_20211109_52da76e550363e3d8224fa6836bc9d90.TXT ### 12/14/2021 2:30:19 AM 12/14/2021 2:30:19 AM : For Distributor 000000000001274 Insert Count::3 ### Delete Count::0 12/14/2021 2:30:19 AM : Import IN File --->> IN_1274_20211111_02a4d1787b8435759037c9e089e133e3.TXT ### 12/14/2021 2:30:19 AM 12/14/2021 2:30:19 AM : For Distributor 000000000001274 Insert Count::10 ### Delete Count::0 12/14/2021 2:30:19 AM : Import IN File --->> IN_1274_20211112_b4b272453ae5416996ca362488c9e11a.TXT ### 12/14/2021 2:30:19 AM 12/14/2021 2:30:19 AM : For Distributor 000000000001274 Insert Count::3 ### Delete Count::0 12/14/2021 2:30:19 AM : Import IN File --->> IN_1274_20211113_985c0bf0fe3c7b040bb808fbbc66c44a.TXT ### 12/14/2021 2:30:19 AM 12/14/2021 2:30:19 AM : For Distributor 000000000001274 Insert Count::3 ### Delete Count::0 12/14/2021 2:30:19 AM : Import IN File --->> IN_1274_20211114_dda65646b4b97516ac7c7b19364707e8.TXT ### 12/14/2021 2:30:19 AM 12/14/2021 2:30:19 AM : For Distributor 000000000001274 Insert Count::1 ### Delete Count::0 12/14/2021 2:30:19 AM : Import IN File --->> IN_1274_20211115_f52b53aa332395a8029ce29288428338.TXT ### 12/14/2021 2:30:19 AM 12/14/2021 2:30:20 AM : For Distributor 000000000001274 Insert Count::3 ### Delete Count::0 12/14/2021 2:30:20 AM : Import IN File --->> IN_1274_20211116_c435b3d8ad64acbbd778d7a45fd72b78.TXT ### 12/14/2021 2:30:20 AM 12/14/2021 2:30:20 AM : For Distributor 000000000001274 Insert Count::1 ### Delete Count::0 12/14/2021 2:30:20 AM : Import IN File --->> IN_1274_20211117_429f730204c3cb9c04f33352f796d02a.TXT ### 12/14/2021 2:30:20 AM 12/14/2021 2:30:20 AM : For Distributor 000000000001274 Insert Count::1 ### Delete Count::0 12/14/2021 2:30:20 AM : Import IN File --->> IN_1274_20211118_03e5bc8787193386fdb5ce7d3f1a99c2.TXT ### 12/14/2021 2:30:20 AM 12/14/2021 2:30:20 AM : For Distributor 000000000001274 Insert Count::1 ### Delete Count::0 12/14/2021 2:30:20 AM : Import IN File --->> IN_1274_20211119_c501dc5478cef0bc93ecd996a1114944.TXT ### 12/14/2021 2:30:20 AM 12/14/2021 2:30:20 AM : For Distributor 000000000001274 Insert Count::3 ### Delete Count::0 12/14/2021 2:30:20 AM : Import IN File --->> IN_1274_20211120_3e747d686be1b0e30d314d9120884407.TXT ### 12/14/2021 2:30:20 AM 12/14/2021 2:30:20 AM : For Distributor 000000000001274 Insert Count::4 ### Delete Count::0 12/14/2021 2:30:20 AM : Import IN File --->> IN_1274_20211121_c07571ecf2d53922d1e1d79e09ee3399.TXT ### 12/14/2021 2:30:20 AM 12/14/2021 2:30:20 AM : For Distributor 000000000001274 Insert Count::4 ### Delete Count::0 12/14/2021 2:30:20 AM : Import IN File --->> IN_1274_20211122_957173a977d66810c2e634d418af2a32.TXT ### 12/14/2021 2:30:20 AM 12/14/2021 2:30:20 AM : For Distributor 000000000001274 Insert Count::9 ### Delete Count::0 12/14/2021 2:30:20 AM : Import IN File --->> IN_1274_20211123_529e2b4af0f7d5e0a330ceb873cf5a51.TXT ### 12/14/2021 2:30:20 AM 12/14/2021 2:30:21 AM : For Distributor 000000000001274 Insert Count::12 ### Delete Count::0 12/14/2021 2:30:21 AM : Import IN File --->> IN_1274_20211124_dbdc393cfd6950d790e88be253c5fed7.TXT ### 12/14/2021 2:30:21 AM 12/14/2021 2:30:21 AM : For Distributor 000000000001274 Insert Count::6 ### Delete Count::0 12/14/2021 2:30:21 AM : Import IN File --->> IN_1274_20211125_3261a7e2e43342bf098b97aa3775b751.TXT ### 12/14/2021 2:30:21 AM 12/14/2021 2:30:21 AM : For Distributor 000000000001274 Insert Count::11 ### Delete Count::0 12/14/2021 2:30:21 AM : Import IN File --->> IN_1274_20211126_ccfdc71e0445f05c97a1080755296ae4.TXT ### 12/14/2021 2:30:21 AM 12/14/2021 2:30:21 AM : For Distributor 000000000001274 Insert Count::14 ### Delete Count::0 12/14/2021 2:30:21 AM : Import IN File --->> IN_1274_20211127_d4b15233c436931b755237c835363f72.TXT ### 12/14/2021 2:30:21 AM 12/14/2021 2:30:21 AM : For Distributor 000000000001274 Insert Count::10 ### Delete Count::0 12/14/2021 2:30:21 AM : Import IN File --->> IN_1274_20211128_cf741c53f2f02e62265f3bdb84489311.TXT ### 12/14/2021 2:30:21 AM 12/14/2021 2:30:21 AM : For Distributor 000000000001274 Insert Count::4 ### Delete Count::0 12/14/2021 2:30:21 AM : Import IN File --->> IN_1274_20211129_6061ea4eecf11838fbf0a82a27f25b8d.TXT ### 12/14/2021 2:30:21 AM 12/14/2021 2:30:21 AM : For Distributor 000000000001274 Insert Count::1 ### Delete Count::0 12/14/2021 2:30:21 AM : Import IN File --->> IN_1274_20211130_0c9689568c46a93292ea693b21fd1cb2.TXT ### 12/14/2021 2:30:21 AM 12/14/2021 2:30:23 AM : Exception ### Index was outside the bounds of the array. 12/14/2021 2:30:23 AM : Error ### Index was outside the bounds of the array. Line 12/14/2021 2:30:23 AM : For Distributor 000000000000739 Insert Count::17 ### Delete Count::0 12/14/2021 2:30:23 AM : Import IN File --->> IN_739_20211213_ba1d3bb62cae68a64b7f2c52acab10ee.TXT ### 12/14/2021 2:30:23 AM 12/14/2021 2:30:33 AM : For Distributor 000000000000930 Insert Count::7 ### Delete Count::0 12/14/2021 2:30:33 AM : Import IN File --->> IN_930_20211206_52c0c343a46d64e70653131af210a6f9.TXT ### 12/14/2021 2:30:33 AM 12/14/2021 2:30:33 AM : For Distributor 000000000000930 Insert Count::5 ### Delete Count::0 12/14/2021 2:30:33 AM : Import IN File --->> IN_930_20211207_71905b18ac7cf7cca701157ae136e580.TXT ### 12/14/2021 2:30:33 AM 12/14/2021 2:30:33 AM : For Distributor 000000000000930 Insert Count::9 ### Delete Count::0 12/14/2021 2:30:33 AM : Import IN File --->> IN_930_20211208_4090cc973f7981d8423c36cdd7cef769.TXT ### 12/14/2021 2:30:33 AM 12/14/2021 2:30:33 AM : For Distributor 000000000000930 Insert Count::1 ### Delete Count::0 12/14/2021 2:30:33 AM : Import IN File --->> IN_930_20211209_2b43176e44dd56fa76609d50fdf8060f.TXT ### 12/14/2021 2:30:33 AM 12/14/2021 2:30:33 AM : For Distributor 000000000000930 Insert Count::3 ### Delete Count::0 12/14/2021 2:30:33 AM : Import IN File --->> IN_930_20211210_fc684630d24d1e32e31da9b333e407db.TXT ### 12/14/2021 2:30:33 AM 12/14/2021 2:30:33 AM : For Distributor 000000000000930 Insert Count::6 ### Delete Count::0 12/14/2021 2:30:33 AM : Import IN File --->> IN_930_20211211_ee3f0c063adf59051e9b1c513242568d.TXT ### 12/14/2021 2:30:33 AM 12/14/2021 2:30:34 AM : For Distributor 000000000001274 Insert Count::5 ### Delete Count::0 12/14/2021 2:30:34 AM : Import PR File --->> PR_1274_20211213_abba65422bdf1d04654339230e6bcc89.TXT ### 12/14/2021 2:30:34 AM 12/14/2021 2:30:34 AM : PostData() --->> ### 12/14/2021 2:30:34 AM 12/14/2021 2:30:39 AM : SP_CreateUnkCustomerUnkItem Successful --->> ### 12/14/2021 2:30:39 AM 12/14/2021 2:30:43 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '14/Dec/2021' ### 12/14/2021 2:30:43 AM 12/14/2021 2:30:43 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '14/Dec/2021' ### 12/14/2021 2:30:43 AM 12/14/2021 2:30:43 AM : ### 12/14/2021 2:30:43 AM : UNLINKEDSALES Record Count Before --->> 169 ### 12/14/2021 2:30:43 AM 12/14/2021 2:30:43 AM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 12/14/2021 2:30:43 AM 12/14/2021 2:30:53 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '14/Dec/2021' ### 12/14/2021 2:30:53 AM 12/14/2021 2:30:53 AM : UNLINKEDSALES Record Count After --->> 0 ### 12/14/2021 2:30:53 AM 12/14/2021 2:30:53 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 12/14/2021 2:30:53 AM 12/14/2021 2:30:53 AM : ### 12/14/2021 2:30:53 AM : Posting Supplierlink Query for Purchases --->> ### 12/14/2021 2:30:53 AM 12/14/2021 2:30:59 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '14/Dec/2021' ### 12/14/2021 2:30:59 AM 12/14/2021 2:31:05 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '14/Dec/2021' ### 12/14/2021 2:31:05 AM 12/14/2021 2:31:05 AM : Posting Supplierlink Query for CompanyPurchases --->> ### 12/14/2021 2:31:05 AM 12/14/2021 2:31:05 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '14/Dec/2021' ### 12/14/2021 2:31:05 AM 12/14/2021 2:31:06 AM : Posting ClosingStock Successful --->> ### 12/14/2021 2:31:06 AM 12/14/2021 2:31:06 AM : FileWiseHashCode Updated for FlagImport=true records --->> ### 12/14/2021 2:31:06 AM 12/14/2021 2:31:06 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\ 12/14/2021 2:31:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1123438_TEMPLATE1.TXT ### 12/14/2021 2:31:06 AM 12/14/2021 2:31:06 AM : Count:: ### TEMPLATE1:53 12/14/2021 2:31:13 AM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 2:31:13 AM 12/14/2021 2:31:13 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 12/14/2021 2:31:13 AM 12/14/2021 2:31:13 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:31:13 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 12/14/2021 2:31:13 AM 12/14/2021 2:31:13 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:31:13 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 12/14/2021 2:31:13 AM 12/14/2021 2:31:13 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:31:13 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 12/14/2021 2:31:13 AM 12/14/2021 2:31:13 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:31:13 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 12/14/2021 2:31:13 AM 12/14/2021 2:31:13 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:31:14 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3482327_TEMPLATE1.TXT ### 12/14/2021 2:31:14 AM 12/14/2021 2:31:14 AM : Count:: ### TEMPLATE1:15 12/14/2021 2:31:15 AM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 2:31:15 AM 12/14/2021 2:31:15 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 12/14/2021 2:31:15 AM 12/14/2021 2:31:15 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:31:15 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 12/14/2021 2:31:15 AM 12/14/2021 2:31:15 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:31:15 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 12/14/2021 2:31:15 AM 12/14/2021 2:31:15 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:31:15 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 12/14/2021 2:31:15 AM 12/14/2021 2:31:15 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:31:15 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 12/14/2021 2:31:15 AM 12/14/2021 2:31:15 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:31:15 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4066351_TEMPLATE1.txt ### 12/14/2021 2:31:15 AM 12/14/2021 2:31:15 AM : Count:: ### TEMPLATE1:85 12/14/2021 2:31:27 AM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 2:31:27 AM 12/14/2021 2:31:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4070468_TEMPLATE1.txt ### 12/14/2021 2:31:27 AM 12/14/2021 2:31:27 AM : Count:: ### TEMPLATE1:123 12/14/2021 2:31:29 AM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 2:31:29 AM 12/14/2021 2:31:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 12/14/2021 2:31:29 AM 12/14/2021 2:31:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:31:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 12/14/2021 2:31:29 AM 12/14/2021 2:31:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:31:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 12/14/2021 2:31:29 AM 12/14/2021 2:31:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:31:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 12/14/2021 2:31:29 AM 12/14/2021 2:31:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:31:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 12/14/2021 2:31:29 AM 12/14/2021 2:31:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:31:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 12/14/2021 2:31:29 AM 12/14/2021 2:31:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:31:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 12/14/2021 2:31:29 AM 12/14/2021 2:31:29 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:31:29 AM : Template Import Complete ### 12/14/2021 2:31:29 AM 12/14/2021 2:31:32 AM : Completed Updating Has Transaction Flag ### 12/14/2021 2:31:32 AM 12/14/2021 2:31:32 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 12/14/2021 2:31:32 AM 12/14/2021 2:31:32 AM : Zylem Access Unblocked ### 12/14/2021 2:31:32 AM 12/14/2021 2:31:32 AM : Application Ended ### 12/14/2021 2:31:32 AM 12/14/2021 7:30:03 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 12/14/2021 7:30:04 AM : StartProcess ### 12/14/2021 7:30:04 AM 12/14/2021 7:30:04 AM : 11 ### 12/14/2021 7:30:04 AM 12/14/2021 7:30:04 AM : 22 ### 12/14/2021 7:30:04 AM 12/14/2021 7:30:04 AM : 33 ### 12/14/2021 7:30:04 AM 12/14/2021 7:30:04 AM : Application Started ### 12/14/2021 7:30:04 AM 12/14/2021 7:30:04 AM : Start Process : checkAllTablesExists() ### 12/14/2021 7:30:04 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 12/14/2021 7:30:04 AM 12/14/2021 7:30:04 AM : MainForm_Load ### AlertSystem ON 12/14/2021 7:30:04 AM : No. of Files to import (RECEIVEFINAL): ### 5827 12/14/2021 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 12/14/2021 7:30:05 AM : For Distributor 000000000001142 Insert Count::2 ### Delete Count::1 12/14/2021 7:30:05 AM : Import AD File --->> AD_1142_20211214_fb25cd7f262022797d47339b41c28491.TXT ### 12/14/2021 7:30:05 AM 12/14/2021 7:30:05 AM : For Distributor 000000000001178 Insert Count::1 ### Delete Count::0 12/14/2021 7:30:05 AM : Import AD File --->> AD_1178_20211214_fa2a6876ed732fd799de1cbd0242ea80.TXT ### 12/14/2021 7:30:05 AM 12/14/2021 7:30:05 AM : For Distributor 000000000001316 Insert Count::1 ### Delete Count::0 12/14/2021 7:30:05 AM : Import AD File --->> AD_1316_20211214_b597a53dc61b7515be67a1c2e9ed43e4.TXT ### 12/14/2021 7:30:05 AM 12/14/2021 7:30:05 AM : For Distributor 000000000000366 Insert Count::1 ### Delete Count::0 12/14/2021 7:30:05 AM : Import AD File --->> AD_366_20211214_e0fbfb5558f3fd9f2511876e85340b84.TXT ### 12/14/2021 7:30:05 AM 12/14/2021 7:30:06 AM : For Distributor 000000000000810 Insert Count::1 ### Delete Count::0 12/14/2021 7:30:06 AM : Import AD File --->> AD_810_20211214_87de37a20fca9dc059cb83bc01158a34.TXT ### 12/14/2021 7:30:06 AM 12/14/2021 7:30:06 AM : For Distributor 000000000000892 Insert Count::0 ### Delete Count::34 12/14/2021 7:30:06 AM : Import AD File --->> AD_892_20211214_e2b5b9fbfe793b7667339649f087bd2f.TXT ### 12/14/2021 7:30:06 AM 12/14/2021 7:30:36 AM : For Distributor 000000000001178 Insert Count::4 ### Delete Count::4 12/14/2021 7:30:36 AM : Import DN File --->> DN_1178_20211102_59b6623c3a8a077ac5c21dcc20148930.TXT ### 12/14/2021 7:30:36 AM 12/14/2021 7:30:36 AM : For Distributor 000000000001178 Insert Count::2 ### Delete Count::2 12/14/2021 7:30:36 AM : Import DN File --->> DN_1178_20211110_17d3472aa136d1f7fb87e27f2849c34b.TXT ### 12/14/2021 7:30:36 AM 12/14/2021 7:30:36 AM : For Distributor 000000000001178 Insert Count::1 ### Delete Count::1 12/14/2021 7:30:36 AM : Import DN File --->> DN_1178_20211112_cff2beaff63773409478df4977309f20.TXT ### 12/14/2021 7:30:36 AM 12/14/2021 7:30:37 AM : For Distributor 000000000001178 Insert Count::2 ### Delete Count::2 12/14/2021 7:30:37 AM : Import DN File --->> DN_1178_20211115_730a740d09fee3756f72f6d2c698ad30.TXT ### 12/14/2021 7:30:37 AM 12/14/2021 7:30:50 AM : For Distributor 000000000001316 Insert Count::1 ### Delete Count::0 12/14/2021 7:30:50 AM : Import DN File --->> DN_1316_20211207_46079d7c681d51957ab80c045a8a2ae5.TXT ### 12/14/2021 7:30:50 AM 12/14/2021 7:31:00 AM : For Distributor 000000000000351 Insert Count::2 ### Delete Count::0 12/14/2021 7:31:00 AM : Import DN File --->> DN_351_20211206_de7b451bc102d8750534194e9028c39d.TXT ### 12/14/2021 7:31:00 AM 12/14/2021 7:31:00 AM : For Distributor 000000000000351 Insert Count::4 ### Delete Count::4 12/14/2021 7:31:00 AM : Import DN File --->> DN_351_20211207_819ffb81e406f933de458a66a04a037f.TXT ### 12/14/2021 7:31:00 AM 12/14/2021 7:31:49 AM : For Distributor 000000000000892 Insert Count::1 ### Delete Count::0 12/14/2021 7:31:49 AM : Import DN File --->> DN_892_20211203_33661e5048737f02ec3c10f1b38b1644.TXT ### 12/14/2021 7:31:49 AM 12/14/2021 7:32:09 AM : For Distributor 000000000001026 Insert Count::1 ### Delete Count::0 12/14/2021 7:32:09 AM : Import IN File --->> IN_1026_20211211_e903e2468b3b4f87aed4bd5558cc91d5.TXT ### 12/14/2021 7:32:09 AM 12/14/2021 7:32:09 AM : For Distributor 000000000001026 Insert Count::0 ### Delete Count::1 12/14/2021 7:32:09 AM : Import IN File --->> IN_1026_20211213_d41d8cd98f00b204e9800998ecf8427e.TXT ### 12/14/2021 7:32:09 AM 12/14/2021 7:32:11 AM : For Distributor 000000000001047 Insert Count::1 ### Delete Count::0 12/14/2021 7:32:11 AM : Import IN File --->> IN_1047_20211213_e55de6b6c359272a9f809a0232e8e6aa.TXT ### 12/14/2021 7:32:11 AM 12/14/2021 7:32:20 AM : For Distributor 000000000001142 Insert Count::3 ### Delete Count::0 12/14/2021 7:32:20 AM : Import IN File --->> IN_1142_20211213_ee51d4f61145858c389cc2550dc98262.TXT ### 12/14/2021 7:32:20 AM 12/14/2021 7:32:20 AM : Import IN File --->> IN_1142_20211214_a657afc62c29d07d174600bc4ac611eb.TXT ### 12/14/2021 7:32:20 AM 12/14/2021 7:32:20 AM : NO Previous File For Distributor 000000000001142 ### Insert Count::8 12/14/2021 7:32:30 AM : For Distributor 000000000001178 Insert Count::4 ### Delete Count::0 12/14/2021 7:32:30 AM : Import IN File --->> IN_1178_20211213_0eefc0368868cbc96940be3d16b04706.TXT ### 12/14/2021 7:32:30 AM 12/14/2021 7:32:30 AM : Exception ### Index was outside the bounds of the array. 12/14/2021 7:32:30 AM : Error ### Index was outside the bounds of the array. Line 12/14/2021 7:32:43 AM : For Distributor 000000000001316 Insert Count::1 ### Delete Count::0 12/14/2021 7:32:43 AM : Import IN File --->> IN_1316_20211213_44162e1864e9961a59f48415fef4e373.TXT ### 12/14/2021 7:32:43 AM 12/14/2021 7:32:57 AM : For Distributor 000000000000355 Insert Count::1 ### Delete Count::0 12/14/2021 7:32:57 AM : Import IN File --->> IN_355_20211213_f83589abd2949f8d0192e26d3a20cf31.TXT ### 12/14/2021 7:32:57 AM 12/14/2021 7:33:00 AM : For Distributor 000000000000366 Insert Count::1 ### Delete Count::2 12/14/2021 7:33:00 AM : Import IN File --->> IN_366_20211130_cc028f59f19e25606b4a8b759cf99f4b.TXT ### 12/14/2021 7:33:00 AM 12/14/2021 7:33:00 AM : For Distributor 000000000000366 Insert Count::0 ### Delete Count::5 12/14/2021 7:33:00 AM : Import IN File --->> IN_366_20211201_a028bf7a4f3f74b40c7601fd3a570726.TXT ### 12/14/2021 7:33:00 AM 12/14/2021 7:33:01 AM : For Distributor 000000000000366 Insert Count::23 ### Delete Count::0 12/14/2021 7:33:01 AM : Import IN File --->> IN_366_20211211_7bd95072605e9702b2c586bd03d040da.TXT ### 12/14/2021 7:33:01 AM 12/14/2021 7:33:01 AM : Import IN File --->> IN_366_20211213_e799807eed1c292b4ee598dd8d95a220.TXT ### 12/14/2021 7:33:01 AM 12/14/2021 7:33:01 AM : NO Previous File For Distributor 000000000000366 ### Insert Count::6 12/14/2021 7:33:22 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:22 AM : Import IN File --->> IN_810_20211101_e3ef097d6eff143bf60e066ff6b25568.TXT ### 12/14/2021 7:33:22 AM 12/14/2021 7:33:22 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:22 AM : Import IN File --->> IN_810_20211102_58af148303fba6c5e88f42ac18cf923c.TXT ### 12/14/2021 7:33:22 AM 12/14/2021 7:33:23 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:23 AM : Import IN File --->> IN_810_20211106_c5c3e92bdb91729fe49fbd25983ec0a7.TXT ### 12/14/2021 7:33:23 AM 12/14/2021 7:33:23 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:23 AM : Import IN File --->> IN_810_20211108_42fee896776a96ae8917b66dbce8d161.TXT ### 12/14/2021 7:33:23 AM 12/14/2021 7:33:23 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:23 AM : Import IN File --->> IN_810_20211109_fbefb5573d28a3dd1b21e8ff9a529c09.TXT ### 12/14/2021 7:33:23 AM 12/14/2021 7:33:23 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:23 AM : Import IN File --->> IN_810_20211110_f10dd7a077a3d6eb822061a8c24db204.TXT ### 12/14/2021 7:33:23 AM 12/14/2021 7:33:23 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:23 AM : Import IN File --->> IN_810_20211112_3ccdec0e7ef6cd72ff854b426fc3e067.TXT ### 12/14/2021 7:33:23 AM 12/14/2021 7:33:23 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:23 AM : Import IN File --->> IN_810_20211113_85e539ecc2912d99560c96b33b5fcf01.TXT ### 12/14/2021 7:33:23 AM 12/14/2021 7:33:24 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:24 AM : Import IN File --->> IN_810_20211115_b47496857480ebdffee1988a0b65ddd9.TXT ### 12/14/2021 7:33:24 AM 12/14/2021 7:33:24 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:24 AM : Import IN File --->> IN_810_20211116_4e338efb3a14c3c6d49f0d2c07822227.TXT ### 12/14/2021 7:33:24 AM 12/14/2021 7:33:24 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:24 AM : Import IN File --->> IN_810_20211117_f175971c90ec3a14f02610e6705e4ab6.TXT ### 12/14/2021 7:33:24 AM 12/14/2021 7:33:24 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:24 AM : Import IN File --->> IN_810_20211118_06b5a6e334bb0639b373501bafb2f738.TXT ### 12/14/2021 7:33:24 AM 12/14/2021 7:33:24 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:24 AM : Import IN File --->> IN_810_20211119_b387314706e2c8a36b8a4715d3b84b18.TXT ### 12/14/2021 7:33:24 AM 12/14/2021 7:33:24 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:24 AM : Import IN File --->> IN_810_20211122_82a1f83810ab7613a8b5bce3358e9ea6.TXT ### 12/14/2021 7:33:24 AM 12/14/2021 7:33:24 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:24 AM : Import IN File --->> IN_810_20211123_18daf2ce88fe74081755666beaa14d0e.TXT ### 12/14/2021 7:33:24 AM 12/14/2021 7:33:24 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:24 AM : Import IN File --->> IN_810_20211124_9419c5ca932c6214d4d1da15267d19f0.TXT ### 12/14/2021 7:33:24 AM 12/14/2021 7:33:25 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:25 AM : Import IN File --->> IN_810_20211125_33a82542db5d0b19d533d7ef4f5dde7c.TXT ### 12/14/2021 7:33:25 AM 12/14/2021 7:33:25 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:25 AM : Import IN File --->> IN_810_20211126_3ce2d4ffaa88c313f23d292077bdd492.TXT ### 12/14/2021 7:33:25 AM 12/14/2021 7:33:25 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:25 AM : Import IN File --->> IN_810_20211127_f7fa1268b1efa4210f2e4437e36494a4.TXT ### 12/14/2021 7:33:25 AM 12/14/2021 7:33:25 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:25 AM : Import IN File --->> IN_810_20211129_b4dccdad7eb534a8b9e1eb683e2bd3b2.TXT ### 12/14/2021 7:33:25 AM 12/14/2021 7:33:25 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:25 AM : Import IN File --->> IN_810_20211130_c4e12fd8b0d0088e0e96649a587380a0.TXT ### 12/14/2021 7:33:25 AM 12/14/2021 7:33:25 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:25 AM : Import IN File --->> IN_810_20211201_8748949f28fa18a759dd4cd52586d2b2.TXT ### 12/14/2021 7:33:25 AM 12/14/2021 7:33:25 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:25 AM : Import IN File --->> IN_810_20211202_858e682bfa1b58ff88b48bdaafe21d33.TXT ### 12/14/2021 7:33:25 AM 12/14/2021 7:33:25 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:25 AM : Import IN File --->> IN_810_20211203_282c8bf48f261077a878eeeffcfbd31b.TXT ### 12/14/2021 7:33:25 AM 12/14/2021 7:33:26 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:26 AM : Import IN File --->> IN_810_20211206_efdff7f4a94e39a3ccc5a05ca076bffd.TXT ### 12/14/2021 7:33:26 AM 12/14/2021 7:33:26 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:26 AM : Import IN File --->> IN_810_20211207_74d9ea6fbeb9999e504a377303dbff4d.TXT ### 12/14/2021 7:33:26 AM 12/14/2021 7:33:26 AM : For Distributor 000000000000810 Insert Count::0 ### Delete Count::0 12/14/2021 7:33:26 AM : Import IN File --->> IN_810_20211208_75a3d62970471834bd9ab65de94e4b1b.TXT ### 12/14/2021 7:33:26 AM 12/14/2021 7:33:26 AM : For Distributor 000000000000810 Insert Count::7 ### Delete Count::0 12/14/2021 7:33:26 AM : Import IN File --->> IN_810_20211213_53f2f95079a6bc750158327fb1692025.TXT ### 12/14/2021 7:33:26 AM 12/14/2021 7:33:48 AM : PostData() --->> ### 12/14/2021 7:33:48 AM 12/14/2021 7:33:50 AM : SP_CreateUnkCustomerUnkItem Successful --->> ### 12/14/2021 7:33:50 AM 12/14/2021 7:33:52 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '14/Dec/2021' ### 12/14/2021 7:33:52 AM 12/14/2021 7:33:52 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '14/Dec/2021' ### 12/14/2021 7:33:52 AM 12/14/2021 7:33:52 AM : ### 12/14/2021 7:33:52 AM : UNLINKEDSALES Record Count Before --->> 56 ### 12/14/2021 7:33:52 AM 12/14/2021 7:33:52 AM : UNLINKEDSALES_DEL Record Count Before --->> 8 ### 12/14/2021 7:33:52 AM 12/14/2021 7:34:02 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '14/Dec/2021' ### 12/14/2021 7:34:02 AM 12/14/2021 7:34:02 AM : UNLINKEDSALES Record Count After --->> 0 ### 12/14/2021 7:34:02 AM 12/14/2021 7:34:02 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 12/14/2021 7:34:02 AM 12/14/2021 7:34:02 AM : ### 12/14/2021 7:34:02 AM : Posting Supplierlink Query for Purchases --->> ### 12/14/2021 7:34:02 AM 12/14/2021 7:34:09 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '14/Dec/2021' ### 12/14/2021 7:34:09 AM 12/14/2021 7:34:15 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '14/Dec/2021' ### 12/14/2021 7:34:15 AM 12/14/2021 7:34:15 AM : Posting Supplierlink Query for CompanyPurchases --->> ### 12/14/2021 7:34:15 AM 12/14/2021 7:34:15 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '14/Dec/2021' ### 12/14/2021 7:34:15 AM 12/14/2021 7:34:16 AM : Posting ClosingStock Successful --->> ### 12/14/2021 7:34:16 AM 12/14/2021 7:34:16 AM : FileWiseHashCode Updated for FlagImport=true records --->> ### 12/14/2021 7:34:16 AM 12/14/2021 7:34:16 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\ 12/14/2021 7:34:16 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1114446_TEMPLATE1.txt ### 12/14/2021 7:34:16 AM 12/14/2021 7:34:16 AM : Count:: ### TEMPLATE1:499 12/14/2021 7:34:46 AM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 7:34:46 AM 12/14/2021 7:34:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1123438_TEMPLATE1.TXT ### 12/14/2021 7:34:46 AM 12/14/2021 7:34:46 AM : Count:: ### TEMPLATE1:53 12/14/2021 7:34:49 AM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 7:34:49 AM 12/14/2021 7:34:49 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 12/14/2021 7:34:49 AM 12/14/2021 7:34:49 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 7:34:49 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2043239_TEMPLATE1.txt ### 12/14/2021 7:34:49 AM 12/14/2021 7:34:49 AM : Count:: ### TEMPLATE1:129 12/14/2021 7:35:07 AM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 7:35:07 AM 12/14/2021 7:35:07 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 12/14/2021 7:35:07 AM 12/14/2021 7:35:07 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 7:35:07 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 12/14/2021 7:35:07 AM 12/14/2021 7:35:07 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 7:35:07 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2743253_TEMPLATE1.TXT ### 12/14/2021 7:35:07 AM 12/14/2021 7:35:07 AM : Count:: ### TEMPLATE1:21 12/14/2021 7:35:10 AM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 7:35:10 AM 12/14/2021 7:35:10 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 12/14/2021 7:35:10 AM 12/14/2021 7:35:10 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 7:35:10 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 12/14/2021 7:35:10 AM 12/14/2021 7:35:10 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 7:35:10 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3224985_TEMPLATE1.TXT ### 12/14/2021 7:35:10 AM 12/14/2021 7:35:10 AM : Count:: ### TEMPLATE1:113 12/14/2021 7:35:17 AM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 7:35:17 AM 12/14/2021 7:35:17 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3559252_TEMPLATE1.TXT ### 12/14/2021 7:35:17 AM 12/14/2021 7:35:17 AM : Count:: ### TEMPLATE1:1 12/14/2021 7:35:18 AM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 7:35:18 AM 12/14/2021 7:35:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 12/14/2021 7:35:18 AM 12/14/2021 7:35:18 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 7:35:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 12/14/2021 7:35:18 AM 12/14/2021 7:35:18 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 7:35:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 12/14/2021 7:35:18 AM 12/14/2021 7:35:18 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 7:35:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 12/14/2021 7:35:18 AM 12/14/2021 7:35:18 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 7:35:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3937444_TEMPLATE1.txt ### 12/14/2021 7:35:18 AM 12/14/2021 7:35:18 AM : Count:: ### TEMPLATE1:457 12/14/2021 7:35:45 AM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 7:35:45 AM 12/14/2021 7:35:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3974630_TEMPLATE1.txt ### 12/14/2021 7:35:45 AM 12/14/2021 7:35:45 AM : Count:: ### TEMPLATE1:174 12/14/2021 7:35:56 AM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 7:35:56 AM 12/14/2021 7:35:56 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 12/14/2021 7:35:56 AM 12/14/2021 7:35:56 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 7:35:56 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4070468_TEMPLATE1.txt ### 12/14/2021 7:35:56 AM 12/14/2021 7:35:56 AM : Count:: ### TEMPLATE1:123 12/14/2021 7:36:14 AM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 7:36:14 AM 12/14/2021 7:36:14 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 12/14/2021 7:36:14 AM 12/14/2021 7:36:15 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 7:36:15 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 12/14/2021 7:36:15 AM 12/14/2021 7:36:15 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 7:36:15 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_722734_TEMPLATE1.TXT ### 12/14/2021 7:36:15 AM 12/14/2021 7:36:15 AM : Count:: ### TEMPLATE1:7 12/14/2021 7:36:15 AM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 7:36:15 AM 12/14/2021 7:36:15 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060306_TEMPLATE1.TXT ### 12/14/2021 7:36:15 AM 12/14/2021 7:36:15 AM : Count:: ### TEMPLATE1:134 12/14/2021 7:36:33 AM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 7:36:33 AM 12/14/2021 7:36:34 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060310_TEMPLATE1.TXT ### 12/14/2021 7:36:34 AM 12/14/2021 7:36:34 AM : Count:: ### TEMPLATE1:21 12/14/2021 7:36:36 AM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 7:36:36 AM 12/14/2021 7:36:36 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060448_TEMPLATE1.TXT ### 12/14/2021 7:36:36 AM 12/14/2021 7:36:36 AM : Count:: ### TEMPLATE1:28 12/14/2021 7:36:40 AM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 7:36:40 AM 12/14/2021 7:36:40 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060653_TEMPLATE1.txt ### 12/14/2021 7:36:40 AM 12/14/2021 7:36:40 AM : Count:: ### TEMPLATE1:31 12/14/2021 7:36:45 AM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 7:36:45 AM 12/14/2021 7:36:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 12/14/2021 7:36:45 AM 12/14/2021 7:36:45 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 7:36:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 12/14/2021 7:36:45 AM 12/14/2021 7:36:45 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 7:36:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 12/14/2021 7:36:45 AM 12/14/2021 7:36:45 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 7:36:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061625_TEMPLATE1.txt ### 12/14/2021 7:36:45 AM 12/14/2021 7:36:45 AM : Count:: ### TEMPLATE1:158 12/14/2021 7:36:54 AM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 7:36:54 AM 12/14/2021 7:36:54 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062891_TEMPLATE1.TXT ### 12/14/2021 7:36:54 AM 12/14/2021 7:36:54 AM : Count:: ### TEMPLATE1:109 12/14/2021 7:37:10 AM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 7:37:10 AM 12/14/2021 7:37:10 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 12/14/2021 7:37:10 AM 12/14/2021 7:37:10 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 7:37:10 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 12/14/2021 7:37:10 AM 12/14/2021 7:37:10 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 7:37:10 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067110_TEMPLATE1.TXT ### 12/14/2021 7:37:10 AM 12/14/2021 7:37:10 AM : Count:: ### TEMPLATE1:52 12/14/2021 7:37:11 AM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 7:37:11 AM 12/14/2021 7:37:11 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067123_TEMPLATE1.txt ### 12/14/2021 7:37:11 AM 12/14/2021 7:37:11 AM : Count:: ### TEMPLATE1:22 12/14/2021 7:37:14 AM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 7:37:14 AM 12/14/2021 7:37:14 AM : Template Import Complete ### 12/14/2021 7:37:14 AM 12/14/2021 7:37:17 AM : Completed Updating Has Transaction Flag ### 12/14/2021 7:37:17 AM 12/14/2021 7:37:17 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 12/14/2021 7:37:17 AM 12/14/2021 7:37:17 AM : Zylem Access Unblocked ### 12/14/2021 7:37:17 AM 12/14/2021 7:37:17 AM : Application Ended ### 12/14/2021 7:37:17 AM 12/14/2021 2:30:03 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 12/14/2021 2:30:04 PM : StartProcess ### 12/14/2021 2:30:04 PM 12/14/2021 2:30:04 PM : 11 ### 12/14/2021 2:30:04 PM 12/14/2021 2:30:04 PM : 22 ### 12/14/2021 2:30:04 PM 12/14/2021 2:30:04 PM : 33 ### 12/14/2021 2:30:04 PM 12/14/2021 2:30:04 PM : Application Started ### 12/14/2021 2:30:04 PM 12/14/2021 2:30:04 PM : Start Process : checkAllTablesExists() ### 12/14/2021 2:30:04 PM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 12/14/2021 2:30:04 PM 12/14/2021 2:30:04 PM : MainForm_Load ### AlertSystem ON 12/14/2021 2:30:04 PM : No. of Files to import (RECEIVEFINAL): ### 2799 12/14/2021 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 12/14/2021 2:30:05 PM : For Distributor 000000000001119 Insert Count::2 ### Delete Count::0 12/14/2021 2:30:05 PM : Import AD File --->> AD_1119_20211214_0cba5848f44fffaee9e7d0830a11d7ac.TXT ### 12/14/2021 2:30:05 PM 12/14/2021 2:30:05 PM : For Distributor 000000000001185 Insert Count::2 ### Delete Count::0 12/14/2021 2:30:05 PM : Import AD File --->> AD_1185_20211214_0af04f60a6fefd1edaaa961bf8518c3d.TXT ### 12/14/2021 2:30:05 PM 12/14/2021 2:30:05 PM : For Distributor 000000000000356 Insert Count::3 ### Delete Count::0 12/14/2021 2:30:05 PM : Import AD File --->> AD_356_20211214_68f289764d4d46f1ec92f18346e93051.TXT ### 12/14/2021 2:30:05 PM 12/14/2021 2:30:06 PM : For Distributor 000000000000357 Insert Count::1 ### Delete Count::0 12/14/2021 2:30:06 PM : Import AD File --->> AD_357_20211214_689c90550cb3cd0cce68e6a541d7578a.TXT ### 12/14/2021 2:30:06 PM 12/14/2021 2:30:06 PM : For Distributor 000000000000492 Insert Count::1 ### Delete Count::0 12/14/2021 2:30:06 PM : Import AD File --->> AD_492_20211214_08a12b629d0ecbf56b0e65480592ddb5.TXT ### 12/14/2021 2:30:06 PM 12/14/2021 2:30:06 PM : For Distributor 000000000000665 Insert Count::1 ### Delete Count::0 12/14/2021 2:30:06 PM : Import AD File --->> AD_665_20211214_02802b0b03d6d4376af8eb8cef5f19f4.TXT ### 12/14/2021 2:30:06 PM 12/14/2021 2:30:06 PM : For Distributor 000000000000756 Insert Count::1 ### Delete Count::0 12/14/2021 2:30:06 PM : Import AD File --->> AD_756_20211214_310b7bacf13f16903f2fb547112c079e.TXT ### 12/14/2021 2:30:06 PM 12/14/2021 2:30:06 PM : For Distributor 000000000000816 Insert Count::34 ### Delete Count::0 12/14/2021 2:30:06 PM : Import AD File --->> AD_816_20211214_7b1de8302f8a5e3a59c28d5b854e4e04.TXT ### 12/14/2021 2:30:06 PM 12/14/2021 2:30:07 PM : For Distributor 000000000000820 Insert Count::20 ### Delete Count::0 12/14/2021 2:30:07 PM : Import AD File --->> AD_820_20211214_2589e0b89ea43569e9705c0e9a3b2e31.TXT ### 12/14/2021 2:30:07 PM 12/14/2021 2:30:25 PM : For Distributor 000000000000003 Insert Count::6 ### Delete Count::0 12/14/2021 2:30:25 PM : Import DN File --->> DN_3_20211213_d85a31209ebf85ef6497bb293957258f.TXT ### 12/14/2021 2:30:25 PM 12/14/2021 2:30:28 PM : For Distributor 000000000000665 Insert Count::3 ### Delete Count::0 12/14/2021 2:30:28 PM : Import DN File --->> DN_665_20211211_c46b39db98425a3a9cb256c7f9adb142.TXT ### 12/14/2021 2:30:28 PM 12/14/2021 2:30:47 PM : For Distributor 000000000000809 Insert Count::6 ### Delete Count::0 12/14/2021 2:30:47 PM : Import DN File --->> DN_809_20211214_b7e88bd99ee69d2aea95f3904328edaf.TXT ### 12/14/2021 2:30:47 PM 12/14/2021 2:30:51 PM : For Distributor 000000000000816 Insert Count::10 ### Delete Count::10 12/14/2021 2:30:51 PM : Import DN File --->> DN_816_20211119_518b8c9ce9bf5a57818183383d039a0c.TXT ### 12/14/2021 2:30:51 PM 12/14/2021 2:30:51 PM : For Distributor 000000000000816 Insert Count::3 ### Delete Count::3 12/14/2021 2:30:51 PM : Import DN File --->> DN_816_20211123_eed4dd18e7e2785e4b829f24a033ebd8.TXT ### 12/14/2021 2:30:51 PM 12/14/2021 2:30:51 PM : For Distributor 000000000000816 Insert Count::4 ### Delete Count::4 12/14/2021 2:30:51 PM : Import DN File --->> DN_816_20211124_38bc2fa8eb62962a6f5516cc1b308f16.TXT ### 12/14/2021 2:30:51 PM 12/14/2021 2:30:51 PM : For Distributor 000000000000816 Insert Count::6 ### Delete Count::6 12/14/2021 2:30:51 PM : Import DN File --->> DN_816_20211126_949bdbf6eb5eca8953d509f93b49248b.TXT ### 12/14/2021 2:30:51 PM 12/14/2021 2:30:52 PM : Import DN File --->> DN_816_20211209_2ce2da477e79e8fd7319aa35c1652d8c.TXT ### 12/14/2021 2:30:52 PM 12/14/2021 2:30:52 PM : NO Previous File For Distributor 000000000000816 ### Insert Count::4 12/14/2021 2:31:05 PM : For Distributor 000000000001119 Insert Count::4 ### Delete Count::0 12/14/2021 2:31:05 PM : Import IN File --->> IN_1119_20211207_13b37a37060b42ad4dd2161dc0c47089.TXT ### 12/14/2021 2:31:05 PM 12/14/2021 2:31:05 PM : For Distributor 000000000001119 Insert Count::7 ### Delete Count::0 12/14/2021 2:31:05 PM : Import IN File --->> IN_1119_20211208_ddca41ed1b1f367840183926896389ad.TXT ### 12/14/2021 2:31:05 PM 12/14/2021 2:31:05 PM : For Distributor 000000000001119 Insert Count::3 ### Delete Count::0 12/14/2021 2:31:05 PM : Import IN File --->> IN_1119_20211211_d309c01357b22617e8f84d013544fde6.TXT ### 12/14/2021 2:31:05 PM 12/14/2021 2:31:05 PM : For Distributor 000000000001119 Insert Count::7 ### Delete Count::0 12/14/2021 2:31:05 PM : Import IN File --->> IN_1119_20211213_294a36aa410154c5cf115093531599bd.TXT ### 12/14/2021 2:31:05 PM 12/14/2021 2:31:05 PM : Import IN File --->> IN_1119_20211214_2907eac8c001a6dfb683d5a92334ad99.TXT ### 12/14/2021 2:31:05 PM 12/14/2021 2:31:05 PM : NO Previous File For Distributor 000000000001119 ### Insert Count::5 12/14/2021 2:31:12 PM : Import IN File --->> IN_1185_20211207_7bf5db1bc9368a5f4a1f981c465eed18.TXT ### 12/14/2021 2:31:12 PM 12/14/2021 2:31:12 PM : NO Previous File For Distributor 000000000001185 ### Insert Count::1 12/14/2021 2:31:12 PM : Import IN File --->> IN_1185_20211208_c03cf56fd885736dbea560fa774f4261.TXT ### 12/14/2021 2:31:12 PM 12/14/2021 2:31:12 PM : NO Previous File For Distributor 000000000001185 ### Insert Count::1 12/14/2021 2:31:12 PM : Import IN File --->> IN_1185_20211211_78e7776b82614d4b35cb011fa4f98201.TXT ### 12/14/2021 2:31:12 PM 12/14/2021 2:31:12 PM : NO Previous File For Distributor 000000000001185 ### Insert Count::2 12/14/2021 2:31:12 PM : Import IN File --->> IN_1185_20211213_1d01a2e23eecc6c4bb8a7fa67dc95791.TXT ### 12/14/2021 2:31:12 PM 12/14/2021 2:31:12 PM : NO Previous File For Distributor 000000000001185 ### Insert Count::3 12/14/2021 2:31:17 PM : For Distributor 000000000000356 Insert Count::21 ### Delete Count::0 12/14/2021 2:31:17 PM : Import IN File --->> IN_356_20211211_dfd9d4e819e420e253897331d8b8e836.TXT ### 12/14/2021 2:31:17 PM 12/14/2021 2:31:17 PM : For Distributor 000000000000356 Insert Count::18 ### Delete Count::0 12/14/2021 2:31:17 PM : Import IN File --->> IN_356_20211213_ddfd45a7077031827c87afb7028119c8.TXT ### 12/14/2021 2:31:17 PM 12/14/2021 2:31:17 PM : Import IN File --->> IN_356_20211214_2153a1e4a43cb580643e54f2f323855f.TXT ### 12/14/2021 2:31:17 PM 12/14/2021 2:31:17 PM : NO Previous File For Distributor 000000000000356 ### Insert Count::7 12/14/2021 2:31:19 PM : For Distributor 000000000000357 Insert Count::2 ### Delete Count::0 12/14/2021 2:31:19 PM : Import IN File --->> IN_357_20211213_7a8cf4620fa7b258e92c7394a8b13a05.TXT ### 12/14/2021 2:31:19 PM 12/14/2021 2:31:19 PM : Import IN File --->> IN_357_20211214_42dcb61d7a4a4e8e8bb4fbd4667f42ba.TXT ### 12/14/2021 2:31:19 PM 12/14/2021 2:31:19 PM : NO Previous File For Distributor 000000000000357 ### Insert Count::7 12/14/2021 2:31:33 PM : For Distributor 000000000000492 Insert Count::3 ### Delete Count::0 12/14/2021 2:31:33 PM : Import IN File --->> IN_492_20211213_9cbe104b0e0dfd75ba8861b1a684d773.TXT ### 12/14/2021 2:31:33 PM 12/14/2021 2:31:34 PM : For Distributor 000000000000665 Insert Count::3 ### Delete Count::0 12/14/2021 2:31:34 PM : Import IN File --->> IN_665_20211208_394b82a7377f4691d84c7a7e33987204.TXT ### 12/14/2021 2:31:34 PM 12/14/2021 2:31:35 PM : For Distributor 000000000000665 Insert Count::15 ### Delete Count::0 12/14/2021 2:31:35 PM : Import IN File --->> IN_665_20211213_04844b37ab0ca56c0e0462d813495966.TXT ### 12/14/2021 2:31:35 PM 12/14/2021 2:31:35 PM : Import IN File --->> IN_665_20211214_4f378152ac537b6ab1b6eec58a022ab1.TXT ### 12/14/2021 2:31:35 PM 12/14/2021 2:31:35 PM : NO Previous File For Distributor 000000000000665 ### Insert Count::2 12/14/2021 2:31:44 PM : For Distributor 000000000000756 Insert Count::81 ### Delete Count::0 12/14/2021 2:31:44 PM : Import IN File --->> IN_756_20211213_73c2b36ae3828eae0806d5bf68a388ff.TXT ### 12/14/2021 2:31:44 PM 12/14/2021 2:31:44 PM : Import IN File --->> IN_756_20211214_d221c29404aec822a77d47034907a7b7.TXT ### 12/14/2021 2:31:44 PM 12/14/2021 2:31:44 PM : NO Previous File For Distributor 000000000000756 ### Insert Count::10 12/14/2021 2:31:46 PM : Import IN File --->> IN_811_20211213_1fe040dfc5d70bd06e58e4d30b608cd4.TXT ### 12/14/2021 2:31:46 PM 12/14/2021 2:31:46 PM : NO Previous File For Distributor 000000000000811 ### Insert Count::13 12/14/2021 2:31:46 PM : Import IN File --->> IN_811_20211214_f676d918053f76f22838b3bf9760f7c5.TXT ### 12/14/2021 2:31:46 PM 12/14/2021 2:31:46 PM : NO Previous File For Distributor 000000000000811 ### Insert Count::1 12/14/2021 2:31:48 PM : Import IN File --->> IN_816_20211201_f613b5045285df2e95b313901664c828.TXT ### 12/14/2021 2:31:48 PM 12/14/2021 2:31:48 PM : NO Previous File For Distributor 000000000000816 ### Insert Count::10 12/14/2021 2:31:48 PM : Import IN File --->> IN_816_20211202_942c89b6a36c342f0a5b608cfd5d2536.TXT ### 12/14/2021 2:31:48 PM 12/14/2021 2:31:48 PM : NO Previous File For Distributor 000000000000816 ### Insert Count::3 12/14/2021 2:31:48 PM : Import IN File --->> IN_816_20211203_6aa56d401b73e67d5f2eefdc221e6a03.TXT ### 12/14/2021 2:31:48 PM 12/14/2021 2:31:48 PM : NO Previous File For Distributor 000000000000816 ### Insert Count::10 12/14/2021 2:31:48 PM : Import IN File --->> IN_816_20211204_c81c86aa05750d8522c04404e10e05ac.TXT ### 12/14/2021 2:31:48 PM 12/14/2021 2:31:49 PM : NO Previous File For Distributor 000000000000816 ### Insert Count::16 12/14/2021 2:31:49 PM : Import IN File --->> IN_816_20211206_496329a59487c023dd10b5191d111e68.TXT ### 12/14/2021 2:31:49 PM 12/14/2021 2:31:49 PM : NO Previous File For Distributor 000000000000816 ### Insert Count::19 12/14/2021 2:31:49 PM : Import IN File --->> IN_816_20211207_a340c1792f8988679a5ee289306e24da.TXT ### 12/14/2021 2:31:49 PM 12/14/2021 2:31:49 PM : NO Previous File For Distributor 000000000000816 ### Insert Count::1 12/14/2021 2:31:49 PM : Import IN File --->> IN_816_20211209_b651ee2e14ea4c65a4e3d7ab13d855f7.TXT ### 12/14/2021 2:31:49 PM 12/14/2021 2:31:49 PM : NO Previous File For Distributor 000000000000816 ### Insert Count::18 12/14/2021 2:31:49 PM : Import IN File --->> IN_816_20211210_df415758d576dcf83dbc3b632046fb6a.TXT ### 12/14/2021 2:31:49 PM 12/14/2021 2:31:49 PM : NO Previous File For Distributor 000000000000816 ### Insert Count::14 12/14/2021 2:31:49 PM : Import IN File --->> IN_816_20211211_06917df0bef70e40baae9a9b2a9bee91.TXT ### 12/14/2021 2:31:49 PM 12/14/2021 2:31:49 PM : NO Previous File For Distributor 000000000000816 ### Insert Count::12 12/14/2021 2:31:49 PM : Import IN File --->> IN_816_20211213_14a5ce312d13c797e22caab88fb4a7bf.TXT ### 12/14/2021 2:31:49 PM 12/14/2021 2:31:49 PM : NO Previous File For Distributor 000000000000816 ### Insert Count::10 12/14/2021 2:31:49 PM : Import IN File --->> IN_816_20211214_092b592f311aa9f2c6e451d8014b4e08.TXT ### 12/14/2021 2:31:49 PM 12/14/2021 2:31:49 PM : NO Previous File For Distributor 000000000000816 ### Insert Count::3 12/14/2021 2:31:50 PM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::0 12/14/2021 2:31:50 PM : Import IN File --->> IN_820_20211126_2946faa619dbb339ee1d3818eec86a0d.TXT ### 12/14/2021 2:31:50 PM 12/14/2021 2:31:50 PM : For Distributor 000000000000820 Insert Count::1 ### Delete Count::0 12/14/2021 2:31:50 PM : Import IN File --->> IN_820_20211127_446b23a29905019d8053448565f59db8.TXT ### 12/14/2021 2:31:50 PM 12/14/2021 2:31:50 PM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::0 12/14/2021 2:31:50 PM : Import IN File --->> IN_820_20211129_1982999b84d7ec097a8aafada1ea1131.TXT ### 12/14/2021 2:31:50 PM 12/14/2021 2:31:50 PM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::0 12/14/2021 2:31:50 PM : Import IN File --->> IN_820_20211130_d1dd1f21f17b6d0ae91423d5c94d67cf.TXT ### 12/14/2021 2:31:50 PM 12/14/2021 2:31:50 PM : For Distributor 000000000000820 Insert Count::6 ### Delete Count::0 12/14/2021 2:31:50 PM : Import IN File --->> IN_820_20211201_3718ce4aa403a6ace7235a01eb5494ee.TXT ### 12/14/2021 2:31:50 PM 12/14/2021 2:31:51 PM : For Distributor 000000000000820 Insert Count::6 ### Delete Count::0 12/14/2021 2:31:51 PM : Import IN File --->> IN_820_20211202_5ff67c416703382b3cf48829b0b43aee.TXT ### 12/14/2021 2:31:51 PM 12/14/2021 2:31:51 PM : For Distributor 000000000000820 Insert Count::8 ### Delete Count::0 12/14/2021 2:31:51 PM : Import IN File --->> IN_820_20211203_c1bc96de9a3ab64e201443bea76f8208.TXT ### 12/14/2021 2:31:51 PM 12/14/2021 2:31:51 PM : For Distributor 000000000000820 Insert Count::6 ### Delete Count::0 12/14/2021 2:31:51 PM : Import IN File --->> IN_820_20211204_78de551adb5b874f8c0235adfaf6b5b6.TXT ### 12/14/2021 2:31:51 PM 12/14/2021 2:31:51 PM : For Distributor 000000000000820 Insert Count::9 ### Delete Count::0 12/14/2021 2:31:51 PM : Import IN File --->> IN_820_20211206_47b31a09f9d0d2590a9394aacde70d47.TXT ### 12/14/2021 2:31:51 PM 12/14/2021 2:31:51 PM : For Distributor 000000000000820 Insert Count::7 ### Delete Count::0 12/14/2021 2:31:51 PM : Import IN File --->> IN_820_20211207_991b5b1b9a1254c5abdc3009bf304f00.TXT ### 12/14/2021 2:31:51 PM 12/14/2021 2:31:51 PM : For Distributor 000000000000820 Insert Count::3 ### Delete Count::0 12/14/2021 2:31:51 PM : Import IN File --->> IN_820_20211208_5c710d164cc828b8e99d8a4740de5241.TXT ### 12/14/2021 2:31:51 PM 12/14/2021 2:31:51 PM : For Distributor 000000000000820 Insert Count::7 ### Delete Count::0 12/14/2021 2:31:51 PM : Import IN File --->> IN_820_20211209_8c65376e54ce8d6ef57a1b31a3ceea81.TXT ### 12/14/2021 2:31:51 PM 12/14/2021 2:31:51 PM : For Distributor 000000000000820 Insert Count::9 ### Delete Count::0 12/14/2021 2:31:51 PM : Import IN File --->> IN_820_20211210_6eadba429fcbb866dfafe6369fd2d123.TXT ### 12/14/2021 2:31:51 PM 12/14/2021 2:31:51 PM : For Distributor 000000000000820 Insert Count::7 ### Delete Count::0 12/14/2021 2:31:51 PM : Import IN File --->> IN_820_20211211_bf5aae02748b0d114651808e63a30b8a.TXT ### 12/14/2021 2:31:51 PM 12/14/2021 2:31:51 PM : For Distributor 000000000000820 Insert Count::4 ### Delete Count::0 12/14/2021 2:31:51 PM : Import IN File --->> IN_820_20211213_e40c724f368c0d0a5bfdd73cf054efc8.TXT ### 12/14/2021 2:31:51 PM 12/14/2021 2:31:52 PM : Import IN File --->> IN_820_20211214_14a95009d2e2c8de4520c90984c2760d.TXT ### 12/14/2021 2:31:52 PM 12/14/2021 2:31:52 PM : NO Previous File For Distributor 000000000000820 ### Insert Count::6 12/14/2021 2:31:52 PM : For Distributor 000000000000820 Insert Count::9 ### Delete Count::0 12/14/2021 2:31:52 PM : Import PR File --->> PR_820_20211214_97579f0f1a94a8624cbdc52a712be31b.TXT ### 12/14/2021 2:31:52 PM 12/14/2021 2:31:52 PM : PostData() --->> ### 12/14/2021 2:31:52 PM 12/14/2021 2:32:08 PM : SP_CreateUnkCustomerUnkItem Successful --->> ### 12/14/2021 2:32:08 PM 12/14/2021 2:32:13 PM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '14/Dec/2021' ### 12/14/2021 2:32:13 PM 12/14/2021 2:32:13 PM : ItemLink Successful --->> exec SP_ItemLinkDiff '14/Dec/2021' ### 12/14/2021 2:32:13 PM 12/14/2021 2:32:13 PM : ### 12/14/2021 2:32:13 PM : UNLINKEDSALES Record Count Before --->> 417 ### 12/14/2021 2:32:13 PM 12/14/2021 2:32:13 PM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 12/14/2021 2:32:13 PM 12/14/2021 2:32:22 PM : Posting Sales Successful --->> exec prPostLinkedDiffSales '14/Dec/2021' ### 12/14/2021 2:32:22 PM 12/14/2021 2:32:22 PM : UNLINKEDSALES Record Count After --->> 0 ### 12/14/2021 2:32:22 PM 12/14/2021 2:32:22 PM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 12/14/2021 2:32:22 PM 12/14/2021 2:32:22 PM : ### 12/14/2021 2:32:22 PM : Posting Supplierlink Query for Purchases --->> ### 12/14/2021 2:32:22 PM 12/14/2021 2:32:29 PM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '14/Dec/2021' ### 12/14/2021 2:32:29 PM 12/14/2021 2:32:35 PM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '14/Dec/2021' ### 12/14/2021 2:32:35 PM 12/14/2021 2:32:35 PM : Posting Supplierlink Query for CompanyPurchases --->> ### 12/14/2021 2:32:35 PM 12/14/2021 2:32:35 PM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '14/Dec/2021' ### 12/14/2021 2:32:35 PM 12/14/2021 2:32:35 PM : Posting ClosingStock Successful --->> ### 12/14/2021 2:32:35 PM 12/14/2021 2:32:35 PM : FileWiseHashCode Updated for FlagImport=true records --->> ### 12/14/2021 2:32:35 PM 12/14/2021 2:32:35 PM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\ 12/14/2021 2:32:35 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1015312_TEMPLATE1.TXT ### 12/14/2021 2:32:35 PM 12/14/2021 2:32:35 PM : Count:: ### TEMPLATE1:172 12/14/2021 2:32:58 PM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 2:32:58 PM 12/14/2021 2:32:58 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1224500_TEMPLATE1.TXT ### 12/14/2021 2:32:58 PM 12/14/2021 2:32:58 PM : Count:: ### TEMPLATE1:9 12/14/2021 2:32:59 PM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 2:32:59 PM 12/14/2021 2:32:59 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 12/14/2021 2:32:59 PM 12/14/2021 2:32:59 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:32:59 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1998851_TEMPLATE1.TXT ### 12/14/2021 2:32:59 PM 12/14/2021 2:32:59 PM : Count:: ### TEMPLATE1:25 12/14/2021 2:33:00 PM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 2:33:00 PM 12/14/2021 2:33:00 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 12/14/2021 2:33:00 PM 12/14/2021 2:33:00 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:33:00 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 12/14/2021 2:33:00 PM 12/14/2021 2:33:00 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:33:00 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221277_TEMPLATE1.TXT ### 12/14/2021 2:33:00 PM 12/14/2021 2:33:00 PM : Count:: ### TEMPLATE1:9 12/14/2021 2:33:01 PM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 2:33:01 PM 12/14/2021 2:33:01 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 12/14/2021 2:33:01 PM 12/14/2021 2:33:01 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:33:01 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 12/14/2021 2:33:01 PM 12/14/2021 2:33:01 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:33:01 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2848065_TEMPLATE1.TXT ### 12/14/2021 2:33:01 PM 12/14/2021 2:33:01 PM : Count:: ### TEMPLATE1:50 12/14/2021 2:33:09 PM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 2:33:09 PM 12/14/2021 2:33:09 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3513087_TEMPLATE1.TXT ### 12/14/2021 2:33:09 PM 12/14/2021 2:33:09 PM : Count:: ### TEMPLATE1:56 12/14/2021 2:33:10 PM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 2:33:10 PM 12/14/2021 2:33:10 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 12/14/2021 2:33:10 PM 12/14/2021 2:33:10 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:33:10 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 12/14/2021 2:33:10 PM 12/14/2021 2:33:10 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:33:10 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3643369_TEMPLATE1.TXT ### 12/14/2021 2:33:10 PM 12/14/2021 2:33:10 PM : Count:: ### TEMPLATE1:178 12/14/2021 2:33:43 PM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 2:33:43 PM 12/14/2021 2:33:43 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 12/14/2021 2:33:43 PM 12/14/2021 2:33:43 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:33:43 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 12/14/2021 2:33:43 PM 12/14/2021 2:33:43 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:33:43 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3985879_TEMPLATE1.txt ### 12/14/2021 2:33:43 PM 12/14/2021 2:33:43 PM : Count:: ### TEMPLATE1:67 12/14/2021 2:33:45 PM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 2:33:45 PM 12/14/2021 2:33:45 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 12/14/2021 2:33:45 PM 12/14/2021 2:33:45 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:33:45 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4070468_TEMPLATE1.txt ### 12/14/2021 2:33:45 PM 12/14/2021 2:33:45 PM : Count:: ### TEMPLATE1:123 12/14/2021 2:34:03 PM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 2:34:03 PM 12/14/2021 2:34:03 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 12/14/2021 2:34:03 PM 12/14/2021 2:34:03 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:34:03 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4641970_TEMPLATE1.TXT ### 12/14/2021 2:34:03 PM 12/14/2021 2:34:03 PM : Count:: ### TEMPLATE1:62 12/14/2021 2:34:04 PM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 2:34:04 PM 12/14/2021 2:34:04 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 12/14/2021 2:34:04 PM 12/14/2021 2:34:04 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:34:04 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060858_TEMPLATE1.txt ### 12/14/2021 2:34:04 PM 12/14/2021 2:34:04 PM : Count:: ### TEMPLATE1:547 12/14/2021 2:34:37 PM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 2:34:37 PM 12/14/2021 2:34:37 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 12/14/2021 2:34:37 PM 12/14/2021 2:34:38 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:34:38 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061358_TEMPLATE1.TXT ### 12/14/2021 2:34:38 PM 12/14/2021 2:34:38 PM : Count:: ### TEMPLATE1:202 12/14/2021 2:34:50 PM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 2:34:50 PM 12/14/2021 2:34:50 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 12/14/2021 2:34:50 PM 12/14/2021 2:34:50 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:34:50 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 12/14/2021 2:34:50 PM 12/14/2021 2:34:50 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:34:50 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061625_TEMPLATE1.txt ### 12/14/2021 2:34:50 PM 12/14/2021 2:34:50 PM : Count:: ### TEMPLATE1:158 12/14/2021 2:34:59 PM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 2:34:59 PM 12/14/2021 2:34:59 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 12/14/2021 2:34:59 PM 12/14/2021 2:34:59 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:34:59 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063177_TEMPLATE1.TXT ### 12/14/2021 2:34:59 PM 12/14/2021 2:34:59 PM : Count:: ### TEMPLATE1:114 12/14/2021 2:35:14 PM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 2:35:14 PM 12/14/2021 2:35:14 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 12/14/2021 2:35:14 PM 12/14/2021 2:35:14 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 12/14/2021 2:35:14 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9064126_TEMPLATE1.txt ### 12/14/2021 2:35:14 PM 12/14/2021 2:35:14 PM : Count:: ### TEMPLATE1:1 12/14/2021 2:35:15 PM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 2:35:15 PM 12/14/2021 2:35:15 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067092_TEMPLATE1.TXT ### 12/14/2021 2:35:15 PM 12/14/2021 2:35:15 PM : Count:: ### TEMPLATE1:106 12/14/2021 2:35:30 PM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 2:35:30 PM 12/14/2021 2:35:30 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067109_TEMPLATE1.TXT ### 12/14/2021 2:35:30 PM 12/14/2021 2:35:30 PM : Count:: ### TEMPLATE1:45 12/14/2021 2:35:36 PM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 2:35:36 PM 12/14/2021 2:35:36 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067960_TEMPLATE1.txt ### 12/14/2021 2:35:36 PM 12/14/2021 2:35:36 PM : Count:: ### TEMPLATE1:189 12/14/2021 2:36:02 PM : SP_DistributorTemplatePosting Successful --->> ### 12/14/2021 2:36:02 PM 12/14/2021 2:36:02 PM : Template Import Complete ### 12/14/2021 2:36:02 PM 12/14/2021 2:36:05 PM : Completed Updating Has Transaction Flag ### 12/14/2021 2:36:05 PM 12/14/2021 2:36:05 PM : Transaction Table lastEdiDate Update on BrandAlias Update ### 12/14/2021 2:36:05 PM 12/14/2021 2:36:05 PM : Zylem Access Unblocked ### 12/14/2021 2:36:05 PM 12/14/2021 2:36:05 PM : Application Ended ### 12/14/2021 2:36:05 PM