4/22/2022 2: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 4/22/2022 2:30:04 AM : StartProcess ### 4/22/2022 2:30:04 AM 4/22/2022 2:30:04 AM : 11 ### 4/22/2022 2:30:04 AM 4/22/2022 2:30:04 AM : 22 ### 4/22/2022 2:30:04 AM 4/22/2022 2:30:04 AM : 33 ### 4/22/2022 2:30:04 AM 4/22/2022 2:30:04 AM : Application Started ### 4/22/2022 2:30:04 AM 4/22/2022 2:30:04 AM : Start Process : checkAllTablesExists() ### 4/22/2022 2:30:04 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 4/22/2022 2:30:04 AM 4/22/2022 2:30:04 AM : MainForm_Load ### AlertSystem ON 4/22/2022 2:30:05 AM : No. of Files to import (RECEIVEFINAL): ### 1 4/22/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/22/2022 2:30:05 AM : PostData() --->> ### 4/22/2022 2:30:05 AM 4/22/2022 2:30:05 AM : SP_CreateUnkCustomerUnkItem Successful --->> ### 4/22/2022 2:30:05 AM 4/22/2022 2:30:06 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '22/Apr/2022' ### 4/22/2022 2:30:06 AM 4/22/2022 2:30:06 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '22/Apr/2022' ### 4/22/2022 2:30:06 AM 4/22/2022 2:30:06 AM : ### 4/22/2022 2:30:06 AM : UNLINKEDSALES Record Count Before --->> 0 ### 4/22/2022 2:30:06 AM 4/22/2022 2:30:06 AM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 4/22/2022 2:30:06 AM 4/22/2022 2:30:14 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '22/Apr/2022' ### 4/22/2022 2:30:14 AM 4/22/2022 2:30:14 AM : UNLINKEDSALES Record Count After --->> 0 ### 4/22/2022 2:30:14 AM 4/22/2022 2:30:14 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 4/22/2022 2:30:14 AM 4/22/2022 2:30:14 AM : ### 4/22/2022 2:30:14 AM : Posting Supplierlink Query for Purchases --->> ### 4/22/2022 2:30:14 AM 4/22/2022 2:30:20 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '22/Apr/2022' ### 4/22/2022 2:30:20 AM 4/22/2022 2:30:27 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '22/Apr/2022' ### 4/22/2022 2:30:27 AM 4/22/2022 2:30:27 AM : Posting Supplierlink Query for CompanyPurchases --->> ### 4/22/2022 2:30:27 AM 4/22/2022 2:30:27 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '22/Apr/2022' ### 4/22/2022 2:30:27 AM 4/22/2022 2:30:27 AM : Posting ClosingStock Successful --->> ### 4/22/2022 2:30:27 AM 4/22/2022 2:30:27 AM : FileWiseHashCode Updated for FlagImport=true records --->> ### 4/22/2022 2:30:27 AM 4/22/2022 2:30:27 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\ 4/22/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 4/22/2022 2:30:27 AM 4/22/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 4/22/2022 2:30:27 AM 4/22/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 4/22/2022 2:30:27 AM 4/22/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 4/22/2022 2:30:27 AM 4/22/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 4/22/2022 2:30:27 AM 4/22/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 4/22/2022 2:30:27 AM 4/22/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 4/22/2022 2:30:27 AM 4/22/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 4/22/2022 2:30:27 AM 4/22/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 4/22/2022 2:30:27 AM 4/22/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 4/22/2022 2:30:28 AM 4/22/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 4/22/2022 2:30:28 AM 4/22/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 4/22/2022 2:30:28 AM 4/22/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 4/22/2022 2:30:28 AM 4/22/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 4/22/2022 2:30:28 AM 4/22/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 4/22/2022 2:30:28 AM 4/22/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 4/22/2022 2:30:28 AM 4/22/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 4/22/2022 2:30:28 AM 4/22/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:30:28 AM : Template Import Complete ### 4/22/2022 2:30:28 AM 4/22/2022 2:30:31 AM : Completed Updating Has Transaction Flag ### 4/22/2022 2:30:31 AM 4/22/2022 2:30:31 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 4/22/2022 2:30:31 AM 4/22/2022 2:30:31 AM : Zylem Access Unblocked ### 4/22/2022 2:30:31 AM 4/22/2022 2:30:31 AM : Application Ended ### 4/22/2022 2:30:31 AM 4/22/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/22/2022 7:30:03 AM : StartProcess ### 4/22/2022 7:30:03 AM 4/22/2022 7:30:03 AM : 11 ### 4/22/2022 7:30:03 AM 4/22/2022 7:30:04 AM : 22 ### 4/22/2022 7:30:04 AM 4/22/2022 7:30:04 AM : 33 ### 4/22/2022 7:30:04 AM 4/22/2022 7:30:04 AM : Application Started ### 4/22/2022 7:30:04 AM 4/22/2022 7:30:04 AM : Start Process : checkAllTablesExists() ### 4/22/2022 7:30:04 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 4/22/2022 7:30:04 AM 4/22/2022 7:30:04 AM : MainForm_Load ### AlertSystem ON 4/22/2022 7:30:04 AM : No. of Files to import (RECEIVEFINAL): ### 961 4/22/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/22/2022 7:30:05 AM : For Distributor 000000000000011 Insert Count::2 ### Delete Count::0 4/22/2022 7:30:05 AM : Import AD File --->> AD_11_20220422_6f083ca04586d28937ae5ec438277014.TXT ### 4/22/2022 7:30:05 AM 4/22/2022 7:30:06 AM : For Distributor 000000000001316 Insert Count::1 ### Delete Count::0 4/22/2022 7:30:06 AM : Import AD File --->> AD_1316_20220422_f451f374da20b821b35c9ea203df4d2e.TXT ### 4/22/2022 7:30:06 AM 4/22/2022 7:30:06 AM : For Distributor 000000000000809 Insert Count::4 ### Delete Count::0 4/22/2022 7:30:06 AM : Import AD File --->> AD_809_20220422_8032afb78138ecf808a8f2cb0bac9eb6.TXT ### 4/22/2022 7:30:06 AM 4/22/2022 7:30:07 AM : For Distributor 000000000000810 Insert Count::117 ### Delete Count::0 4/22/2022 7:30:07 AM : Import AD File --->> AD_810_20220422_9393c9d3348706ce5621f655b0166a36.TXT ### 4/22/2022 7:30:07 AM 4/22/2022 7:30:07 AM : For Distributor 000000000000820 Insert Count::3 ### Delete Count::0 4/22/2022 7:30:07 AM : Import AD File --->> AD_820_20220422_139a6ff9cea9106b3d570801c3bcd231.TXT ### 4/22/2022 7:30:07 AM 4/22/2022 7:30:28 AM : For Distributor 000000000000492 Insert Count::6 ### Delete Count::6 4/22/2022 7:30:28 AM : Import DN File --->> DN_492_20220408_f0b10e8feb17b4b032dd06a3aa18b266.TXT ### 4/22/2022 7:30:28 AM 4/22/2022 7:30:38 AM : For Distributor 000000000000809 Insert Count::2 ### Delete Count::0 4/22/2022 7:30:38 AM : Import DN File --->> DN_809_20220421_97352655dd263de5d1e200339ee1af8a.TXT ### 4/22/2022 7:30:38 AM 4/22/2022 7:30:45 AM : For Distributor 000000000000810 Insert Count::1 ### Delete Count::1 4/22/2022 7:30:45 AM : Import DN File --->> DN_810_20220402_92f10edf0c4e83cc9fa9bdc6c0d909db.TXT ### 4/22/2022 7:30:45 AM 4/22/2022 7:30:45 AM : For Distributor 000000000000810 Insert Count::6 ### Delete Count::6 4/22/2022 7:30:45 AM : Import DN File --->> DN_810_20220404_6413689cbf3121514cbed45fdf5503ac.TXT ### 4/22/2022 7:30:45 AM 4/22/2022 7:30:46 AM : For Distributor 000000000000810 Insert Count::1 ### Delete Count::1 4/22/2022 7:30:46 AM : Import DN File --->> DN_810_20220406_9a2f19b47e3c1160b4998e3210202bb6.TXT ### 4/22/2022 7:30:46 AM 4/22/2022 7:30:46 AM : For Distributor 000000000000810 Insert Count::1 ### Delete Count::1 4/22/2022 7:30:46 AM : Import DN File --->> DN_810_20220407_7c69cf4a8c6bffce5b540f0ca82e3e50.TXT ### 4/22/2022 7:30:46 AM 4/22/2022 7:30:46 AM : For Distributor 000000000000810 Insert Count::1 ### Delete Count::1 4/22/2022 7:30:46 AM : Import DN File --->> DN_810_20220409_e5e29ee5d0d27f213314cac988bc711e.TXT ### 4/22/2022 7:30:46 AM 4/22/2022 7:30:47 AM : For Distributor 000000000000810 Insert Count::4 ### Delete Count::4 4/22/2022 7:30:47 AM : Import DN File --->> DN_810_20220412_32b2ab43da8d6c63cf4175d924b84908.TXT ### 4/22/2022 7:30:47 AM 4/22/2022 7:30:58 AM : For Distributor 000000000001026 Insert Count::1 ### Delete Count::0 4/22/2022 7:30:58 AM : Import IN File --->> IN_1026_20220419_1cecca2d48f07404b7a095be19b3d101.TXT ### 4/22/2022 7:30:58 AM 4/22/2022 7:30:58 AM : For Distributor 000000000001026 Insert Count::16 ### Delete Count::0 4/22/2022 7:30:58 AM : Import IN File --->> IN_1026_20220420_42e03c99e8cb3b4fc2b17a74ebf0d963.TXT ### 4/22/2022 7:30:58 AM 4/22/2022 7:30:58 AM : For Distributor 000000000001026 Insert Count::16 ### Delete Count::0 4/22/2022 7:30:58 AM : Import IN File --->> IN_1026_20220421_7c563d3c079ca5163cee4090e52f6887.TXT ### 4/22/2022 7:30:58 AM 4/22/2022 7:31:00 AM : For Distributor 000000000000011 Insert Count::5 ### Delete Count::0 4/22/2022 7:31:00 AM : Import IN File --->> IN_11_20220421_26f60fbb04c5bc924a1ca2c80afa5254.TXT ### 4/22/2022 7:31:00 AM 4/22/2022 7:31:02 AM : For Distributor 000000000001316 Insert Count::3 ### Delete Count::0 4/22/2022 7:31:02 AM : Import IN File --->> IN_1316_20220421_e7f5f4cc3d101fd4580d181b0b5f21d3.TXT ### 4/22/2022 7:31:02 AM 4/22/2022 7:31:07 AM : For Distributor 000000000000362 Insert Count::1 ### Delete Count::0 4/22/2022 7:31:07 AM : Import IN File --->> IN_362_20220419_407034fdf8285b85b562e5db70430419.TXT ### 4/22/2022 7:31:07 AM 4/22/2022 7:31:08 AM : For Distributor 000000000000362 Insert Count::5 ### Delete Count::0 4/22/2022 7:31:08 AM : Import IN File --->> IN_362_20220420_ef28178fc4e885a955eba3b59fd29e34.TXT ### 4/22/2022 7:31:08 AM 4/22/2022 7:31:12 AM : Exception ### Index was outside the bounds of the array. 4/22/2022 7:31:12 AM : Error ### Index was outside the bounds of the array. Line 4/22/2022 7:31:12 AM : For Distributor 000000000000492 Insert Count::5 ### Delete Count::0 4/22/2022 7:31:12 AM : Import IN File --->> IN_492_20220421_d3c7b9a7f725b0ec8d5ff472b5dde78d.TXT ### 4/22/2022 7:31:12 AM 4/22/2022 7:31:14 AM : For Distributor 000000000000809 Insert Count::8 ### Delete Count::1 4/22/2022 7:31:14 AM : Import IN File --->> IN_809_20220421_84586c62e041ea9ae59bc1733db1bda0.TXT ### 4/22/2022 7:31:14 AM 4/22/2022 7:31:14 AM : Import IN File --->> IN_809_20220422_c156299307037aa8efa6867173f45253.TXT ### 4/22/2022 7:31:14 AM 4/22/2022 7:31:14 AM : NO Previous File For Distributor 000000000000809 ### Insert Count::5 4/22/2022 7:31:14 AM : For Distributor 000000000000810 Insert Count::2 ### Delete Count::2 4/22/2022 7:31:14 AM : Import IN File --->> IN_810_20220301_e28c2ea393c2a0acb5d1540947c51a71.TXT ### 4/22/2022 7:31:14 AM 4/22/2022 7:31:16 AM : For Distributor 000000000000810 Insert Count::1 ### Delete Count::1 4/22/2022 7:31:16 AM : Import IN File --->> IN_810_20220401_4db32fec2c4ce9065a8fbbc56f619a67.TXT ### 4/22/2022 7:31:16 AM 4/22/2022 7:31:16 AM : For Distributor 000000000000810 Insert Count::22 ### Delete Count::0 4/22/2022 7:31:16 AM : Import IN File --->> IN_810_20220416_06b41ab28da87930a3cbe8410ae2329e.TXT ### 4/22/2022 7:31:16 AM 4/22/2022 7:31:17 AM : For Distributor 000000000000810 Insert Count::20 ### Delete Count::0 4/22/2022 7:31:17 AM : Import IN File --->> IN_810_20220418_199ea91ff152f78b55741bdc8ae35754.TXT ### 4/22/2022 7:31:17 AM 4/22/2022 7:31:17 AM : Import IN File --->> IN_810_20220419_ee1301a57701772fe80fc5219ff2f23c.TXT ### 4/22/2022 7:31:17 AM 4/22/2022 7:31:17 AM : NO Previous File For Distributor 000000000000810 ### Insert Count::15 4/22/2022 7:31:17 AM : Import IN File --->> IN_810_20220420_fc6a4fb907233bfe5391cf0cd34d2b25.TXT ### 4/22/2022 7:31:17 AM 4/22/2022 7:31:17 AM : NO Previous File For Distributor 000000000000810 ### Insert Count::14 4/22/2022 7:31:19 AM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::2 4/22/2022 7:31:19 AM : Import IN File --->> IN_820_20220420_e40eab813fcadb531a4f5e370e927d96.TXT ### 4/22/2022 7:31:19 AM 4/22/2022 7:31:19 AM : For Distributor 000000000000820 Insert Count::11 ### Delete Count::0 4/22/2022 7:31:19 AM : Import IN File --->> IN_820_20220421_4c5a4a1caa70fbb17847819c1f056513.TXT ### 4/22/2022 7:31:19 AM 4/22/2022 7:31:19 AM : Import IN File --->> IN_820_20220422_60cc321b7f5695efa096afec5bf20db6.TXT ### 4/22/2022 7:31:19 AM 4/22/2022 7:31:19 AM : NO Previous File For Distributor 000000000000820 ### Insert Count::6 4/22/2022 7:31:22 AM : Import OT File --->> OT_820_20220421_20ce3188e78278c3818b067bd8e9eaa1.TXT ### 4/22/2022 7:31:22 AM 4/22/2022 7:31:22 AM : NO Previous File For Distributor 000000000000820 ### Insert Count::2 4/22/2022 7:31:22 AM : PostData() --->> ### 4/22/2022 7:31:22 AM 4/22/2022 7:31:26 AM : SP_CreateUnkCustomerUnkItem Successful --->> ### 4/22/2022 7:31:26 AM 4/22/2022 7:31:29 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '22/Apr/2022' ### 4/22/2022 7:31:29 AM 4/22/2022 7:31:29 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '22/Apr/2022' ### 4/22/2022 7:31:29 AM 4/22/2022 7:31:29 AM : ### 4/22/2022 7:31:29 AM : UNLINKEDSALES Record Count Before --->> 158 ### 4/22/2022 7:31:29 AM 4/22/2022 7:31:29 AM : UNLINKEDSALES_DEL Record Count Before --->> 6 ### 4/22/2022 7:31:29 AM 4/22/2022 7:31:41 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '22/Apr/2022' ### 4/22/2022 7:31:41 AM 4/22/2022 7:31:41 AM : UNLINKEDSALES Record Count After --->> 0 ### 4/22/2022 7:31:41 AM 4/22/2022 7:31:41 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 4/22/2022 7:31:41 AM 4/22/2022 7:31:41 AM : ### 4/22/2022 7:31:41 AM : Posting Supplierlink Query for Purchases --->> ### 4/22/2022 7:31:41 AM 4/22/2022 7:31:49 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '22/Apr/2022' ### 4/22/2022 7:31:49 AM 4/22/2022 7:31:55 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '22/Apr/2022' ### 4/22/2022 7:31:55 AM 4/22/2022 7:31:55 AM : Posting Supplierlink Query for CompanyPurchases --->> ### 4/22/2022 7:31:55 AM 4/22/2022 7:31:55 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '22/Apr/2022' ### 4/22/2022 7:31:55 AM 4/22/2022 7:31:55 AM : Posting ClosingStock Successful --->> ### 4/22/2022 7:31:55 AM 4/22/2022 7:31:56 AM : FileWiseHashCode Updated for FlagImport=true records --->> ### 4/22/2022 7:31:56 AM 4/22/2022 7:31:56 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\ 4/22/2022 7:31:56 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 4/22/2022 7:31:56 AM 4/22/2022 7:31:56 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 7:31:56 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 4/22/2022 7:31:56 AM 4/22/2022 7:31:56 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 7:31:56 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 4/22/2022 7:31:56 AM 4/22/2022 7:31:56 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 7:31:56 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 4/22/2022 7:31:56 AM 4/22/2022 7:31:56 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 7:31:56 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 4/22/2022 7:31:56 AM 4/22/2022 7:31:56 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 7:31:56 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2848065_TEMPLATE1.TXT ### 4/22/2022 7:31:56 AM 4/22/2022 7:31:56 AM : Count:: ### TEMPLATE1:70 4/22/2022 7:32:00 AM : SP_DistributorTemplatePosting Successful --->> ### 4/22/2022 7:32:00 AM 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 AM : Error in file ### TEMPLATE1 at Line KRISHNA MANSION 4/22/2022 7:32:00 AM : Exception ### Exception of type 'System.Exception' was thrown. 4/22/2022 7:32:00 AM : Error in file ### TEMPLATE1 at Line GHEE BAZAAR 4/22/2022 7:32:00 AM : Exception ### Exception of type 'System.Exception' was thrown. 4/22/2022 7:32:00 AM : Error in file ### TEMPLATE1 at Line |24AKXPA1540L1Z3|98980 08767|","AHMEDABAD","GUJARAT","390002","98980 08767","SUSHILBHAI AGRAWAL","98980 08767","0","0" 4/22/2022 7:32:00 AM : Exception ### Exception of type 'System.Exception' was thrown. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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","","98250 31711","JIGNESH TRIVEDI","98250 31711","0","0 4/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 AM : Error in file ### TEMPLATE1 at Line 000000000000011","A270","A270","NILKANTH TRADERS","KRISHNA COMPLEXOPP. DHARA PETROL PUMP|24AATFN3046Q1ZL|99099 83028|","THOL","GUJARAT","","99099 83028","ARVIND BHAI","99099 83028","0","0 4/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 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/22/2022 7:32:00 AM : Exception ### Input array is longer than the number of columns in this table. 4/22/2022 7:32:00 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3228822_TEMPLATE1.txt ### 4/22/2022 7:32:00 AM 4/22/2022 7:32:00 AM : Count:: ### TEMPLATE1:1 4/22/2022 7:32:01 AM : SP_DistributorTemplatePosting Successful --->> ### 4/22/2022 7:32:01 AM 4/22/2022 7:32:01 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 4/22/2022 7:32:01 AM 4/22/2022 7:32:01 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 7:32:01 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3612379_TEMPLATE1.TXT ### 4/22/2022 7:32:01 AM 4/22/2022 7:32:01 AM : Count:: ### TEMPLATE1:18 4/22/2022 7:32:03 AM : SP_DistributorTemplatePosting Successful --->> ### 4/22/2022 7:32:03 AM 4/22/2022 7:32:03 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 4/22/2022 7:32:03 AM 4/22/2022 7:32:03 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 7:32:03 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 4/22/2022 7:32:03 AM 4/22/2022 7:32:03 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 7:32:03 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 4/22/2022 7:32:03 AM 4/22/2022 7:32:03 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 7:32:03 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 4/22/2022 7:32:03 AM 4/22/2022 7:32:03 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 7:32:03 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 4/22/2022 7:32:03 AM 4/22/2022 7:32:03 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 7:32:03 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 4/22/2022 7:32:03 AM 4/22/2022 7:32:03 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 7:32:03 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060893_TEMPLATE1.txt ### 4/22/2022 7:32:03 AM 4/22/2022 7:32:04 AM : Count:: ### TEMPLATE1:502 4/22/2022 7:32:35 AM : SP_DistributorTemplatePosting Successful --->> ### 4/22/2022 7:32:35 AM 4/22/2022 7:32:35 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 4/22/2022 7:32:35 AM 4/22/2022 7:32:36 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 7:32:36 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 4/22/2022 7:32:36 AM 4/22/2022 7:32:36 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 7:32:36 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 4/22/2022 7:32:36 AM 4/22/2022 7:32:36 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 7:32:36 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062891_TEMPLATE1.TXT ### 4/22/2022 7:32:36 AM 4/22/2022 7:32:36 AM : Count:: ### TEMPLATE1:135 4/22/2022 7:32:44 AM : SP_DistributorTemplatePosting Successful --->> ### 4/22/2022 7:32:44 AM 4/22/2022 7:32:44 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 4/22/2022 7:32:44 AM 4/22/2022 7:32:44 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 7:32:44 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 4/22/2022 7:32:44 AM 4/22/2022 7:32:44 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 7:32:44 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9064126_TEMPLATE1.txt ### 4/22/2022 7:32:44 AM 4/22/2022 7:32:44 AM : Count:: ### TEMPLATE1:2 4/22/2022 7:32:45 AM : SP_DistributorTemplatePosting Successful --->> ### 4/22/2022 7:32:45 AM 4/22/2022 7:32:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067109_TEMPLATE1.TXT ### 4/22/2022 7:32:45 AM 4/22/2022 7:32:45 AM : Count:: ### TEMPLATE1:50 4/22/2022 7:32:52 AM : SP_DistributorTemplatePosting Successful --->> ### 4/22/2022 7:32:52 AM 4/22/2022 7:32:52 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067123_TEMPLATE1.txt ### 4/22/2022 7:32:52 AM 4/22/2022 7:32:52 AM : Count:: ### TEMPLATE1:35 4/22/2022 7:32:57 AM : SP_DistributorTemplatePosting Successful --->> ### 4/22/2022 7:32:57 AM 4/22/2022 7:32:57 AM : Template Import Complete ### 4/22/2022 7:32:57 AM 4/22/2022 7:32:59 AM : Completed Updating Has Transaction Flag ### 4/22/2022 7:32:59 AM 4/22/2022 7:32:59 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 4/22/2022 7:32:59 AM 4/22/2022 7:32:59 AM : Zylem Access Unblocked ### 4/22/2022 7:32:59 AM 4/22/2022 7:32:59 AM : Application Ended ### 4/22/2022 7:32:59 AM 4/22/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/22/2022 2:30:03 PM : StartProcess ### 4/22/2022 2:30:03 PM 4/22/2022 2:30:03 PM : 11 ### 4/22/2022 2:30:03 PM 4/22/2022 2:30:03 PM : 22 ### 4/22/2022 2:30:03 PM 4/22/2022 2:30:03 PM : 33 ### 4/22/2022 2:30:03 PM 4/22/2022 2:30:03 PM : Application Started ### 4/22/2022 2:30:03 PM 4/22/2022 2:30:03 PM : Start Process : checkAllTablesExists() ### 4/22/2022 2:30:03 PM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 4/22/2022 2:30:03 PM 4/22/2022 2:30:04 PM : MainForm_Load ### AlertSystem ON 4/22/2022 2:30:04 PM : No. of Files to import (RECEIVEFINAL): ### 995 4/22/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/22/2022 2:30:04 PM : For Distributor 000000000001025 Insert Count::5 ### Delete Count::0 4/22/2022 2:30:04 PM : Import AD File --->> AD_1025_20220422_e3757cc4ae9323bc0df7cd504e72a6a8.TXT ### 4/22/2022 2:30:04 PM 4/22/2022 2:30:05 PM : For Distributor 000000000001026 Insert Count::2 ### Delete Count::0 4/22/2022 2:30:05 PM : Import AD File --->> AD_1026_20220422_9a973263b7b7cb1bfe165bd46afb2e44.TXT ### 4/22/2022 2:30:05 PM 4/22/2022 2:30:05 PM : For Distributor 000000000001288 Insert Count::0 ### Delete Count::123 4/22/2022 2:30:05 PM : Import AD File --->> AD_1288_20220422_51f6028f70213499b084714ddc81cf33.TXT ### 4/22/2022 2:30:05 PM 4/22/2022 2:30:05 PM : For Distributor 000000000001316 Insert Count::3 ### Delete Count::0 4/22/2022 2:30:05 PM : Import AD File --->> AD_1316_20220422_e97e1cb64e06304c66e918c437cdd77c.TXT ### 4/22/2022 2:30:05 PM 4/22/2022 2:30:06 PM : For Distributor 000000000001317 Insert Count::6 ### Delete Count::64 4/22/2022 2:30:06 PM : Import AD File --->> AD_1317_20220422_2b240fcd4ad0d18bd82b9993c27366ea.TXT ### 4/22/2022 2:30:06 PM 4/22/2022 2:30:06 PM : For Distributor 000000000000352 Insert Count::4 ### Delete Count::0 4/22/2022 2:30:06 PM : Import AD File --->> AD_352_20220422_094997b99c28fecf8230e174b7cc4d64.TXT ### 4/22/2022 2:30:06 PM 4/22/2022 2:30:06 PM : For Distributor 000000000000371 Insert Count::3 ### Delete Count::0 4/22/2022 2:30:06 PM : Import AD File --->> AD_371_20220422_3624392958244ef489acf1d273afbfd3.TXT ### 4/22/2022 2:30:06 PM 4/22/2022 2:30:06 PM : For Distributor 000000000000815 Insert Count::0 ### Delete Count::133 4/22/2022 2:30:06 PM : Import AD File --->> AD_815_20220422_6e7726b67289626cb4d69329d29c894b.TXT ### 4/22/2022 2:30:06 PM 4/22/2022 2:30:10 PM : Import DN File --->> DN_1288_20220422_132c0abfc38a22e47f61ebd591fc95b0.TXT ### 4/22/2022 2:30:10 PM 4/22/2022 2:30:10 PM : NO Previous File For Distributor 000000000001288 ### Insert Count::1 4/22/2022 2:30:12 PM : Import DN File --->> DN_352_20220421_7aa36c9f99a572293cb7fa9b2b642308.TXT ### 4/22/2022 2:30:12 PM 4/22/2022 2:30:13 PM : NO Previous File For Distributor 000000000000352 ### Insert Count::5 4/22/2022 2:30:13 PM : Import DN File --->> DN_352_20220422_729a422cc7a787f67ab4ba23ac902f45.TXT ### 4/22/2022 2:30:13 PM 4/22/2022 2:30:13 PM : NO Previous File For Distributor 000000000000352 ### Insert Count::2 4/22/2022 2:30:24 PM : Import IN File --->> IN_1025_20220418_0f56cba8f20c9fb59bf7a7104d49ba83.TXT ### 4/22/2022 2:30:24 PM 4/22/2022 2:30:24 PM : NO Previous File For Distributor 000000000001025 ### Insert Count::5 4/22/2022 2:30:24 PM : Import IN File --->> IN_1025_20220419_8e35c20282bc2726a7846834ac3eced3.TXT ### 4/22/2022 2:30:24 PM 4/22/2022 2:30:24 PM : NO Previous File For Distributor 000000000001025 ### Insert Count::2 4/22/2022 2:30:24 PM : Import IN File --->> IN_1025_20220420_20e67463d8906e2efadf2265a6972dbd.TXT ### 4/22/2022 2:30:24 PM 4/22/2022 2:30:24 PM : NO Previous File For Distributor 000000000001025 ### Insert Count::1 4/22/2022 2:30:24 PM : Import IN File --->> IN_1025_20220421_0959f13da6cca2c6ba691b922e945f66.TXT ### 4/22/2022 2:30:24 PM 4/22/2022 2:30:24 PM : NO Previous File For Distributor 000000000001025 ### Insert Count::4 4/22/2022 2:30:25 PM : For Distributor 000000000001026 Insert Count::1 ### Delete Count::0 4/22/2022 2:30:25 PM : Import IN File --->> IN_1026_20220414_07ea3484d62f38351b3ff1a3e4d3bb71.TXT ### 4/22/2022 2:30:25 PM 4/22/2022 2:30:25 PM : For Distributor 000000000001026 Insert Count::6 ### Delete Count::0 4/22/2022 2:30:25 PM : Import IN File --->> IN_1026_20220421_345c79ee7442fd0daf6b72dbf3fa6b30.TXT ### 4/22/2022 2:30:25 PM 4/22/2022 2:30:25 PM : For Distributor 000000000001026 Insert Count::5 ### Delete Count::0 4/22/2022 2:30:25 PM : Import IN File --->> IN_1026_20220422_be7e7280b49b6ea1cd2728933330215a.TXT ### 4/22/2022 2:30:25 PM 4/22/2022 2:30:27 PM : For Distributor 000000000001288 Insert Count::1 ### Delete Count::0 4/22/2022 2:30:27 PM : Import IN File --->> IN_1288_20220421_942531de0f1e06d97865fa3521a17ad8.TXT ### 4/22/2022 2:30:27 PM 4/22/2022 2:30:27 PM : Import IN File --->> IN_1288_20220422_b455004928404cf719f16d4cffb9d36b.TXT ### 4/22/2022 2:30:27 PM 4/22/2022 2:30:27 PM : NO Previous File For Distributor 000000000001288 ### Insert Count::2 4/22/2022 2:30:30 PM : For Distributor 000000000001316 Insert Count::3 ### Delete Count::0 4/22/2022 2:30:30 PM : Import IN File --->> IN_1316_20220422_6a756a2ad67e167f8dfc9326f4f21157.TXT ### 4/22/2022 2:30:30 PM 4/22/2022 2:30:33 PM : Import IN File --->> IN_352_20220420_35cd874b1014b59914bbb5c41c83c29c.TXT ### 4/22/2022 2:30:33 PM 4/22/2022 2:30:33 PM : NO Previous File For Distributor 000000000000352 ### Insert Count::4 4/22/2022 2:30:33 PM : Import IN File --->> IN_352_20220421_fe465b8ddcf40a403974b25f0266ae1e.TXT ### 4/22/2022 2:30:33 PM 4/22/2022 2:30:33 PM : NO Previous File For Distributor 000000000000352 ### Insert Count::6 4/22/2022 2:30:33 PM : Import IN File --->> IN_352_20220422_201b8488631d1080f82fe5170c3e5000.TXT ### 4/22/2022 2:30:33 PM 4/22/2022 2:30:33 PM : NO Previous File For Distributor 000000000000352 ### Insert Count::9 4/22/2022 2:30:36 PM : Import IN File --->> IN_371_20220422_db66100d12e41d6f80a3b266497299c2.TXT ### 4/22/2022 2:30:36 PM 4/22/2022 2:30:36 PM : NO Previous File For Distributor 000000000000371 ### Insert Count::33 4/22/2022 2:30:38 PM : For Distributor 000000000000372 Insert Count::1 ### Delete Count::0 4/22/2022 2:30:38 PM : Import IN File --->> IN_372_20220420_8a41d8b26c687581e70bcb079813b44a.TXT ### 4/22/2022 2:30:38 PM 4/22/2022 2:30:38 PM : Import IN File --->> IN_372_20220421_736cc61bd5efd7c613cfa4d59c06e322.TXT ### 4/22/2022 2:30:38 PM 4/22/2022 2:30:38 PM : NO Previous File For Distributor 000000000000372 ### Insert Count::2 4/22/2022 2:30:42 PM : For Distributor 000000000000815 Insert Count::2 ### Delete Count::0 4/22/2022 2:30:42 PM : Import IN File --->> IN_815_20220420_c931fb8719cb215bce564e087cf89aac.TXT ### 4/22/2022 2:30:42 PM 4/22/2022 2:30:42 PM : For Distributor 000000000000815 Insert Count::3 ### Delete Count::0 4/22/2022 2:30:42 PM : Import IN File --->> IN_815_20220421_808cab5da823679de49affbf21c8e6cf.TXT ### 4/22/2022 2:30:42 PM 4/22/2022 2:30:42 PM : Import IN File --->> IN_815_20220422_20a89382d7ad6b5133cecde76a2493a0.TXT ### 4/22/2022 2:30:42 PM 4/22/2022 2:30:42 PM : NO Previous File For Distributor 000000000000815 ### Insert Count::13 4/22/2022 2:30:45 PM : Import OT File --->> OT_1025_20220420_333e039b7a6f9d9a6693562fa2039a81.TXT ### 4/22/2022 2:30:45 PM 4/22/2022 2:30:45 PM : NO Previous File For Distributor 000000000001025 ### Insert Count::2 4/22/2022 2:30:45 PM : For Distributor 000000000000424 Insert Count::1 ### Delete Count::1 4/22/2022 2:30:45 PM : Import OT File --->> OT_424_20220308_cbe9421cf9399bf278cf5f707a6f5b99.TXT ### 4/22/2022 2:30:45 PM 4/22/2022 2:30:47 PM : For Distributor 000000000001025 Insert Count::1 ### Delete Count::0 4/22/2022 2:30:47 PM : Import PR File --->> PR_1025_20220422_dc33fded1f1c13f89b059ff52c479320.TXT ### 4/22/2022 2:30:47 PM 4/22/2022 2:30:48 PM : For Distributor 000000000001288 Insert Count::0 ### Delete Count::1 4/22/2022 2:30:48 PM : Import PR File --->> PR_1288_20220422_b59dfa1085526071f9656b7d6d6571a5.TXT ### 4/22/2022 2:30:48 PM 4/22/2022 2:30:48 PM : PostData() --->> ### 4/22/2022 2:30:48 PM 4/22/2022 2:30:51 PM : SP_CreateUnkCustomerUnkItem Successful --->> ### 4/22/2022 2:30:51 PM 4/22/2022 2:30:55 PM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '22/Apr/2022' ### 4/22/2022 2:30:55 PM 4/22/2022 2:30:55 PM : ItemLink Successful --->> exec SP_ItemLinkDiff '22/Apr/2022' ### 4/22/2022 2:30:55 PM 4/22/2022 2:30:55 PM : ### 4/22/2022 2:30:55 PM : UNLINKEDSALES Record Count Before --->> 103 ### 4/22/2022 2:30:55 PM 4/22/2022 2:30:55 PM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 4/22/2022 2:30:55 PM 4/22/2022 2:31:03 PM : Posting Sales Successful --->> exec prPostLinkedDiffSales '22/Apr/2022' ### 4/22/2022 2:31:03 PM 4/22/2022 2:31:03 PM : UNLINKEDSALES Record Count After --->> 0 ### 4/22/2022 2:31:03 PM 4/22/2022 2:31:03 PM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 4/22/2022 2:31:03 PM 4/22/2022 2:31:03 PM : ### 4/22/2022 2:31:03 PM : Posting Supplierlink Query for Purchases --->> ### 4/22/2022 2:31:03 PM 4/22/2022 2:31:09 PM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '22/Apr/2022' ### 4/22/2022 2:31:09 PM 4/22/2022 2:31:17 PM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '22/Apr/2022' ### 4/22/2022 2:31:17 PM 4/22/2022 2:31:17 PM : Posting Supplierlink Query for CompanyPurchases --->> ### 4/22/2022 2:31:17 PM 4/22/2022 2:31:17 PM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '22/Apr/2022' ### 4/22/2022 2:31:17 PM 4/22/2022 2:31:17 PM : Posting ClosingStock Successful --->> ### 4/22/2022 2:31:17 PM 4/22/2022 2:31:17 PM : FileWiseHashCode Updated for FlagImport=true records --->> ### 4/22/2022 2:31:17 PM 4/22/2022 2:31:17 PM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\ 4/22/2022 2:31:17 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1025789_TEMPLATE1.TXT ### 4/22/2022 2:31:17 PM 4/22/2022 2:31:17 PM : Count:: ### TEMPLATE1:161 4/22/2022 2:31:28 PM : SP_DistributorTemplatePosting Successful --->> ### 4/22/2022 2:31:28 PM 4/22/2022 2:31:28 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 4/22/2022 2:31:28 PM 4/22/2022 2:31:28 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:31:28 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 4/22/2022 2:31:28 PM 4/22/2022 2:31:28 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:31:28 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 4/22/2022 2:31:28 PM 4/22/2022 2:31:28 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:31:28 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 4/22/2022 2:31:28 PM 4/22/2022 2:31:28 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:31:28 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 4/22/2022 2:31:28 PM 4/22/2022 2:31:28 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:31:28 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 4/22/2022 2:31:28 PM 4/22/2022 2:31:28 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:31:28 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3612379_TEMPLATE1.TXT ### 4/22/2022 2:31:28 PM 4/22/2022 2:31:28 PM : Count:: ### TEMPLATE1:18 4/22/2022 2:31:29 PM : SP_DistributorTemplatePosting Successful --->> ### 4/22/2022 2:31:29 PM 4/22/2022 2:31:29 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 4/22/2022 2:31:29 PM 4/22/2022 2:31:29 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:31:29 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 4/22/2022 2:31:29 PM 4/22/2022 2:31:29 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:31:29 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 4/22/2022 2:31:29 PM 4/22/2022 2:31:29 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:31:30 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3985879_TEMPLATE1.txt ### 4/22/2022 2:31:30 PM 4/22/2022 2:31:30 PM : Count:: ### TEMPLATE1:15 4/22/2022 2:31:32 PM : SP_DistributorTemplatePosting Successful --->> ### 4/22/2022 2:31:32 PM 4/22/2022 2:31:32 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 4/22/2022 2:31:32 PM 4/22/2022 2:31:32 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:31:32 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 4/22/2022 2:31:32 PM 4/22/2022 2:31:32 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:31:32 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4597115_TEMPLATE1.TXT ### 4/22/2022 2:31:32 PM 4/22/2022 2:31:32 PM : Count:: ### TEMPLATE1:47 4/22/2022 2:31:38 PM : SP_DistributorTemplatePosting Successful --->> ### 4/22/2022 2:31:38 PM 4/22/2022 2:31:38 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 4/22/2022 2:31:38 PM 4/22/2022 2:31:38 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:31:38 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_722734_TEMPLATE1.TXT ### 4/22/2022 2:31:38 PM 4/22/2022 2:31:38 PM : Count:: ### TEMPLATE1:10 4/22/2022 2:31:40 PM : SP_DistributorTemplatePosting Successful --->> ### 4/22/2022 2:31:40 PM 4/22/2022 2:31:40 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060305_TEMPLATE1.TXT ### 4/22/2022 2:31:40 PM 4/22/2022 2:31:40 PM : Count:: ### TEMPLATE1:100 4/22/2022 2:31:54 PM : SP_DistributorTemplatePosting Successful --->> ### 4/22/2022 2:31:54 PM 4/22/2022 2:31:54 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060893_TEMPLATE1.txt ### 4/22/2022 2:31:54 PM 4/22/2022 2:31:54 PM : Count:: ### TEMPLATE1:502 4/22/2022 2:32:26 PM : SP_DistributorTemplatePosting Successful --->> ### 4/22/2022 2:32:26 PM 4/22/2022 2:32:26 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 4/22/2022 2:32:26 PM 4/22/2022 2:32:26 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:32:26 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 4/22/2022 2:32:26 PM 4/22/2022 2:32:26 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:32:26 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 4/22/2022 2:32:26 PM 4/22/2022 2:32:26 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:32:26 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 4/22/2022 2:32:26 PM 4/22/2022 2:32:26 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:32:26 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 4/22/2022 2:32:26 PM 4/22/2022 2:32:26 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 4/22/2022 2:32:26 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9064126_TEMPLATE1.txt ### 4/22/2022 2:32:26 PM 4/22/2022 2:32:26 PM : Count:: ### TEMPLATE1:2 4/22/2022 2:32:26 PM : SP_DistributorTemplatePosting Successful --->> ### 4/22/2022 2:32:26 PM 4/22/2022 2:32:26 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9066916_TEMPLATE1.TXT ### 4/22/2022 2:32:26 PM 4/22/2022 2:32:26 PM : Count:: ### TEMPLATE1:72 4/22/2022 2:32:36 PM : SP_DistributorTemplatePosting Successful --->> ### 4/22/2022 2:32:36 PM 4/22/2022 2:32:36 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067041_TEMPLATE1.TXT ### 4/22/2022 2:32:36 PM 4/22/2022 2:32:36 PM : Count:: ### TEMPLATE1:94 4/22/2022 2:32:49 PM : SP_DistributorTemplatePosting Successful --->> ### 4/22/2022 2:32:49 PM 4/22/2022 2:32:49 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067092_TEMPLATE1.TXT ### 4/22/2022 2:32:49 PM 4/22/2022 2:32:49 PM : Count:: ### TEMPLATE1:24 4/22/2022 2:32:53 PM : SP_DistributorTemplatePosting Successful --->> ### 4/22/2022 2:32:53 PM 4/22/2022 2:32:53 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067122_TEMPLATE1.TXT ### 4/22/2022 2:32:53 PM 4/22/2022 2:32:53 PM : Count:: ### TEMPLATE1:35 4/22/2022 2:32:58 PM : SP_DistributorTemplatePosting Successful --->> ### 4/22/2022 2:32:58 PM 4/22/2022 2:32:58 PM : Template Import Complete ### 4/22/2022 2:32:58 PM 4/22/2022 2:33:01 PM : Completed Updating Has Transaction Flag ### 4/22/2022 2:33:01 PM 4/22/2022 2:33:01 PM : Transaction Table lastEdiDate Update on BrandAlias Update ### 4/22/2022 2:33:01 PM 4/22/2022 2:33:01 PM : Zylem Access Unblocked ### 4/22/2022 2:33:01 PM 4/22/2022 2:33:01 PM : Application Ended ### 4/22/2022 2:33:01 PM