11/9/2020 4:00: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
11/9/2020 4:00:03 AM : StartProcess  ### 11/9/2020 4:00:03 AM

11/9/2020 4:00:03 AM : 11  ### 11/9/2020 4:00:03 AM

11/9/2020 4:00:03 AM : 22  ### 11/9/2020 4:00:03 AM

11/9/2020 4:00:03 AM : 33  ### 11/9/2020 4:00:03 AM

11/9/2020 4:00:03 AM : Application Started  ### 11/9/2020 4:00:03 AM

11/9/2020 4:00:03 AM : Start Process : checkAllTablesExists()  ### 
11/9/2020 4:00:03 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 11/9/2020 4:00:03 AM
11/9/2020 4:00:03 AM : MainForm_Load  ### AlertSystem ON
11/9/2020 4:00:04 AM : No. of Files to import (RECEIVEFINAL):  ### 822
11/9/2020 4:00:04 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
11/9/2020 4:00:04 AM : For Distributor 000000000000215 Insert Count::17 ### Delete Count::0
11/9/2020 4:00:04 AM : Import AD File --->> AD_215_20201108_a3fcb6e9343714fbdb62f9a78284a73b.TXT ### 11/9/2020 4:00:04 AM
11/9/2020 4:00:04 AM : For Distributor 000000000000035 Insert Count::5 ### Delete Count::0
11/9/2020 4:00:04 AM : Import AD File --->> AD_35_20201108_87363074f2467a0ee0d46548a88aa8cc.TXT ### 11/9/2020 4:00:04 AM
11/9/2020 4:00:04 AM : For Distributor 000000000000427 Insert Count::20 ### Delete Count::5
11/9/2020 4:00:04 AM : Import AD File --->> AD_427_20201108_c7af54960648b7fb5577ee56f4aaa390.TXT ### 11/9/2020 4:00:04 AM
11/9/2020 4:00:07 AM : For Distributor 000000000000035 Insert Count::2 ### Delete Count::2
11/9/2020 4:00:07 AM : Import DN File --->> DN_35_20201030_4077384367aa08a87d2fc69d1eb6864b.TXT ### 11/9/2020 4:00:07 AM
11/9/2020 4:00:08 AM : For Distributor 000000000000379 Insert Count::1 ### Delete Count::0
11/9/2020 4:00:08 AM : Import DN File --->> DN_379_20201027_4cea1a9593597d022e60a7686c9d8285.TXT ### 11/9/2020 4:00:08 AM
11/9/2020 4:00:08 AM : For Distributor 000000000000379 Insert Count::2 ### Delete Count::0
11/9/2020 4:00:08 AM : Import DN File --->> DN_379_20201028_6bf030021f9ce8a28e48a5d9cc685cbb.TXT ### 11/9/2020 4:00:08 AM
11/9/2020 4:00:09 AM : For Distributor 000000000000427 Insert Count::1 ### Delete Count::0
11/9/2020 4:00:09 AM : Import DN File --->> DN_427_20201014_7b575159a7050d52f60e4aaed4b09bd9.TXT ### 11/9/2020 4:00:09 AM
11/9/2020 4:00:11 AM : For Distributor 000000000000115 Insert Count::2 ### Delete Count::0
11/9/2020 4:00:11 AM : Import IN File --->> IN_115_20201102_b80903338bb764b952b032fae350c078.TXT ### 11/9/2020 4:00:11 AM
11/9/2020 4:00:11 AM : For Distributor 000000000000115 Insert Count::6 ### Delete Count::0
11/9/2020 4:00:11 AM : Import IN File --->> IN_115_20201103_fb3c1b74be460dbc7da01393e4b33dfe.TXT ### 11/9/2020 4:00:11 AM
11/9/2020 4:00:11 AM : For Distributor 000000000000115 Insert Count::2 ### Delete Count::0
11/9/2020 4:00:11 AM : Import IN File --->> IN_115_20201105_5f081b61d9e94294ce0d2c26726879f2.TXT ### 11/9/2020 4:00:11 AM
11/9/2020 4:00:11 AM : For Distributor 000000000000115 Insert Count::8 ### Delete Count::0
11/9/2020 4:00:11 AM : Import IN File --->> IN_115_20201106_8bf96d47ee94297289c763bc221e404b.TXT ### 11/9/2020 4:00:11 AM
11/9/2020 4:00:11 AM : For Distributor 000000000000180 Insert Count::11 ### Delete Count::0
11/9/2020 4:00:12 AM : Import IN File --->> IN_180_20201001_4997728f452fdc7c9f169374e996f2a6.TXT ### 11/9/2020 4:00:12 AM
11/9/2020 4:00:12 AM : For Distributor 000000000000180 Insert Count::3 ### Delete Count::0
11/9/2020 4:00:12 AM : Import IN File --->> IN_180_20201002_d81705f5bd39d683ed5140c5eadf3e68.TXT ### 11/9/2020 4:00:12 AM
11/9/2020 4:00:12 AM : For Distributor 000000000000180 Insert Count::3 ### Delete Count::0
11/9/2020 4:00:12 AM : Import IN File --->> IN_180_20201003_67505c5de5e217e3eaabc05d190e6270.TXT ### 11/9/2020 4:00:12 AM
11/9/2020 4:00:12 AM : For Distributor 000000000000180 Insert Count::4 ### Delete Count::0
11/9/2020 4:00:12 AM : Import IN File --->> IN_180_20201004_ab6ba9a160adeed5cc84e28f7e2f1953.TXT ### 11/9/2020 4:00:12 AM
11/9/2020 4:00:12 AM : For Distributor 000000000000180 Insert Count::2 ### Delete Count::0
11/9/2020 4:00:12 AM : Import IN File --->> IN_180_20201005_f7732c192130fa9a685e0471d4348e43.TXT ### 11/9/2020 4:00:12 AM
11/9/2020 4:00:12 AM : For Distributor 000000000000180 Insert Count::1 ### Delete Count::0
11/9/2020 4:00:12 AM : Import IN File --->> IN_180_20201006_d300ac69f1d2585156998af559cac586.TXT ### 11/9/2020 4:00:12 AM
11/9/2020 4:00:12 AM : For Distributor 000000000000180 Insert Count::2 ### Delete Count::0
11/9/2020 4:00:12 AM : Import IN File --->> IN_180_20201007_a8531e9f5a73bb8853967a8c28f1d8bd.TXT ### 11/9/2020 4:00:12 AM
11/9/2020 4:00:12 AM : For Distributor 000000000000180 Insert Count::4 ### Delete Count::0
11/9/2020 4:00:12 AM : Import IN File --->> IN_180_20201008_eb9df175e81aa1a204d0c9dab4b9b451.TXT ### 11/9/2020 4:00:12 AM
11/9/2020 4:00:12 AM : For Distributor 000000000000180 Insert Count::3 ### Delete Count::0
11/9/2020 4:00:12 AM : Import IN File --->> IN_180_20201009_1fa7c6aa4b49304be8b69442ac61aaed.TXT ### 11/9/2020 4:00:12 AM
11/9/2020 4:00:12 AM : For Distributor 000000000000180 Insert Count::1 ### Delete Count::0
11/9/2020 4:00:12 AM : Import IN File --->> IN_180_20201010_18d676c4cb27a6843c7526a785ea6155.TXT ### 11/9/2020 4:00:12 AM
11/9/2020 4:00:12 AM : For Distributor 000000000000180 Insert Count::1 ### Delete Count::0
11/9/2020 4:00:13 AM : Import IN File --->> IN_180_20201011_05569d82cce03e152dc2a30afa987c24.TXT ### 11/9/2020 4:00:13 AM
11/9/2020 4:00:13 AM : For Distributor 000000000000180 Insert Count::1 ### Delete Count::0
11/9/2020 4:00:13 AM : Import IN File --->> IN_180_20201012_ec25dc2dd51135127a73d0d13e4bbb91.TXT ### 11/9/2020 4:00:13 AM
11/9/2020 4:00:13 AM : For Distributor 000000000000180 Insert Count::4 ### Delete Count::0
11/9/2020 4:00:13 AM : Import IN File --->> IN_180_20201013_0f7f569749471209006d64d42a19730f.TXT ### 11/9/2020 4:00:13 AM
11/9/2020 4:00:13 AM : For Distributor 000000000000180 Insert Count::3 ### Delete Count::0
11/9/2020 4:00:13 AM : Import IN File --->> IN_180_20201014_0c2ff2c14858dc24081cefb1b6c1232e.TXT ### 11/9/2020 4:00:13 AM
11/9/2020 4:00:13 AM : For Distributor 000000000000180 Insert Count::4 ### Delete Count::0
11/9/2020 4:00:13 AM : Import IN File --->> IN_180_20201015_b4bc03a857822c8563c68d81afb3f5ca.TXT ### 11/9/2020 4:00:13 AM
11/9/2020 4:00:13 AM : For Distributor 000000000000180 Insert Count::4 ### Delete Count::0
11/9/2020 4:00:13 AM : Import IN File --->> IN_180_20201016_83daec441ada48a3ef3a5e12587baadc.TXT ### 11/9/2020 4:00:13 AM
11/9/2020 4:00:13 AM : For Distributor 000000000000180 Insert Count::7 ### Delete Count::0
11/9/2020 4:00:13 AM : Import IN File --->> IN_180_20201017_fd1f77f43bb3dda4a2a9261d9208e8b7.TXT ### 11/9/2020 4:00:13 AM
11/9/2020 4:00:13 AM : For Distributor 000000000000180 Insert Count::3 ### Delete Count::0
11/9/2020 4:00:13 AM : Import IN File --->> IN_180_20201018_d290ede4b88c77303d3e45a95ab7e40d.TXT ### 11/9/2020 4:00:13 AM
11/9/2020 4:00:13 AM : For Distributor 000000000000180 Insert Count::1 ### Delete Count::0
11/9/2020 4:00:13 AM : Import IN File --->> IN_180_20201019_a9d167f8778ab8a9443543929c98dbb0.TXT ### 11/9/2020 4:00:13 AM
11/9/2020 4:00:15 AM : For Distributor 000000000000215 Insert Count::1 ### Delete Count::0
11/9/2020 4:00:15 AM : Import IN File --->> IN_215_20201106_5bbac5e39f7c673a53fe38a5e2e2af52.TXT ### 11/9/2020 4:00:15 AM
11/9/2020 4:00:15 AM : For Distributor 000000000000215 Insert Count::2 ### Delete Count::0
11/9/2020 4:00:15 AM : Import IN File --->> IN_215_20201107_f3fa3565aaaa1131aa0823bc9bcbfd2a.TXT ### 11/9/2020 4:00:15 AM
11/9/2020 4:00:15 AM : For Distributor 000000000000035 Insert Count::1 ### Delete Count::0
11/9/2020 4:00:15 AM : Import IN File --->> IN_35_20201001_c0cd5fde45a61da7ef31e26a140d0c5e.TXT ### 11/9/2020 4:00:15 AM
11/9/2020 4:00:15 AM : For Distributor 000000000000035 Insert Count::0 ### Delete Count::1
11/9/2020 4:00:15 AM : Import IN File --->> IN_35_20201021_13e14b0bfea3b41f67b7905a69728882.TXT ### 11/9/2020 4:00:15 AM
11/9/2020 4:00:16 AM : For Distributor 000000000000035 Insert Count::32 ### Delete Count::0
11/9/2020 4:00:16 AM : Import IN File --->> IN_35_20201107_4b6274c7f0cfd105e1e49f54930e6055.TXT ### 11/9/2020 4:00:16 AM
11/9/2020 4:00:16 AM : For Distributor 000000000000379 Insert Count::2 ### Delete Count::0
11/9/2020 4:00:16 AM : Import IN File --->> IN_379_20201107_da592ec5bc3282bb08ed179bdfc8d9e8.TXT ### 11/9/2020 4:00:16 AM
11/9/2020 4:00:16 AM : The process failed: {0}  ### System.IndexOutOfRangeException: Index was outside the bounds of the array.
   at ZylemImport.ZylemImportClass.ImportINFile(String connectionstring, String Selection, String user) in e:\PROJECTS_SVN\ZylemMIS_Release_1.1.0\slnESpirit\ZylemImport\ZylemImportClass.cs:line 1418
11/9/2020 4:00:17 AM : For Distributor 000000000000427 Insert Count::1 ### Delete Count::1
11/9/2020 4:00:17 AM : Import IN File --->> IN_427_20201001_c20fd04e2815aba6cd9dfe27e52dfaee.TXT ### 11/9/2020 4:00:17 AM
11/9/2020 4:00:17 AM : For Distributor 000000000000427 Insert Count::1 ### Delete Count::1
11/9/2020 4:00:17 AM : Import IN File --->> IN_427_20201002_6bf5c2b0568b35fabfd8741099b9702b.TXT ### 11/9/2020 4:00:17 AM
11/9/2020 4:00:17 AM : For Distributor 000000000000427 Insert Count::1 ### Delete Count::1
11/9/2020 4:00:17 AM : Import IN File --->> IN_427_20201003_2f4ee617635a1ac798e0d2d513f161a0.TXT ### 11/9/2020 4:00:17 AM
11/9/2020 4:00:17 AM : For Distributor 000000000000427 Insert Count::2 ### Delete Count::2
11/9/2020 4:00:17 AM : Import IN File --->> IN_427_20201004_7c2837b1fbb627a3951440e59a139b03.TXT ### 11/9/2020 4:00:17 AM
11/9/2020 4:00:18 AM : For Distributor 000000000000427 Insert Count::1 ### Delete Count::1
11/9/2020 4:00:18 AM : Import IN File --->> IN_427_20201005_1ac20cadadd6663c0ba952a0111126a1.TXT ### 11/9/2020 4:00:18 AM
11/9/2020 4:00:18 AM : For Distributor 000000000000427 Insert Count::1 ### Delete Count::1
11/9/2020 4:00:18 AM : Import IN File --->> IN_427_20201006_e2b71cb3b6e00e96b8368fa8611391ad.TXT ### 11/9/2020 4:00:18 AM
11/9/2020 4:00:18 AM : For Distributor 000000000000427 Insert Count::7 ### Delete Count::0
11/9/2020 4:00:18 AM : Import IN File --->> IN_427_20201007_182bba08adf80d71cc6b26633d18c5ab.TXT ### 11/9/2020 4:00:18 AM
11/9/2020 4:00:18 AM : For Distributor 000000000000427 Insert Count::2 ### Delete Count::0
11/9/2020 4:00:18 AM : Import IN File --->> IN_427_20201008_a5388a71f271acf2be52e4a052af3ccc.TXT ### 11/9/2020 4:00:18 AM
11/9/2020 4:00:18 AM : For Distributor 000000000000427 Insert Count::6 ### Delete Count::0
11/9/2020 4:00:18 AM : Import IN File --->> IN_427_20201009_d70f796a06a0266440bb65e9476f8525.TXT ### 11/9/2020 4:00:18 AM
11/9/2020 4:00:18 AM : For Distributor 000000000000427 Insert Count::10 ### Delete Count::0
11/9/2020 4:00:18 AM : Import IN File --->> IN_427_20201010_7368d58044ef6e33b33b35d577677fca.TXT ### 11/9/2020 4:00:18 AM
11/9/2020 4:00:18 AM : For Distributor 000000000000427 Insert Count::5 ### Delete Count::0
11/9/2020 4:00:18 AM : Import IN File --->> IN_427_20201011_16f033fbc8500a1fd272f97e95e23662.TXT ### 11/9/2020 4:00:18 AM
11/9/2020 4:00:18 AM : For Distributor 000000000000427 Insert Count::38 ### Delete Count::0
11/9/2020 4:00:18 AM : Import IN File --->> IN_427_20201012_e111c9ab31503ff565ed1fad4015cc19.TXT ### 11/9/2020 4:00:18 AM
11/9/2020 4:00:18 AM : For Distributor 000000000000427 Insert Count::51 ### Delete Count::0
11/9/2020 4:00:18 AM : Import IN File --->> IN_427_20201013_277c2ec6dd7987fc2a17c58577917aa7.TXT ### 11/9/2020 4:00:18 AM
11/9/2020 4:00:19 AM : For Distributor 000000000000427 Insert Count::69 ### Delete Count::0
11/9/2020 4:00:19 AM : Import IN File --->> IN_427_20201014_f8199be1e3c47cdc584a397c4f522637.TXT ### 11/9/2020 4:00:19 AM
11/9/2020 4:00:19 AM : For Distributor 000000000000427 Insert Count::28 ### Delete Count::0
11/9/2020 4:00:19 AM : Import IN File --->> IN_427_20201015_a3ee1e68f660439ee57854c65c0d19e3.TXT ### 11/9/2020 4:00:19 AM
11/9/2020 4:00:19 AM : For Distributor 000000000000427 Insert Count::22 ### Delete Count::0
11/9/2020 4:00:19 AM : Import IN File --->> IN_427_20201016_09f012d5c14871b9b1704462f3a05450.TXT ### 11/9/2020 4:00:19 AM
11/9/2020 4:00:19 AM : For Distributor 000000000000427 Insert Count::10 ### Delete Count::0
11/9/2020 4:00:19 AM : Import IN File --->> IN_427_20201017_c388966192bc9c74461f541a379e011b.TXT ### 11/9/2020 4:00:19 AM
11/9/2020 4:00:19 AM : For Distributor 000000000000427 Insert Count::6 ### Delete Count::0
11/9/2020 4:00:19 AM : Import IN File --->> IN_427_20201018_d863fd1712661503b1c0e3428e2d69cb.TXT ### 11/9/2020 4:00:19 AM
11/9/2020 4:00:19 AM : For Distributor 000000000000427 Insert Count::6 ### Delete Count::0
11/9/2020 4:00:19 AM : Import IN File --->> IN_427_20201019_cd1da030e8727e4c3cb9d64a6f05572c.TXT ### 11/9/2020 4:00:19 AM
11/9/2020 4:00:21 AM : For Distributor 000000000000427 Insert Count::7 ### Delete Count::0
11/9/2020 4:00:21 AM : Import PR File --->> PR_427_20201108_e9f68a0024ce4316f73d23d9148f4960.TXT ### 11/9/2020 4:00:21 AM
11/9/2020 4:00:21 AM : PostData() --->>  ### 11/9/2020 4:00:21 AM
11/9/2020 4:00:22 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 11/9/2020 4:00:22 AM
11/9/2020 4:00:23 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '09/Nov/2020' ### 11/9/2020 4:00:23 AM
11/9/2020 4:00:23 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '09/Nov/2020' ### 11/9/2020 4:00:23 AM
11/9/2020 4:00:23 AM :  ### 
11/9/2020 4:00:23 AM : UNLINKEDSALES Record Count Before --->> 385 ### 11/9/2020 4:00:23 AM
11/9/2020 4:00:23 AM : UNLINKEDSALES_DEL Record Count Before --->> 8 ### 11/9/2020 4:00:23 AM
11/9/2020 4:00:29 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '09/Nov/2020' ### 11/9/2020 4:00:29 AM
11/9/2020 4:00:29 AM : UNLINKEDSALES Record Count After --->> 0 ### 11/9/2020 4:00:29 AM
11/9/2020 4:00:29 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 11/9/2020 4:00:29 AM
11/9/2020 4:00:29 AM :  ### 
11/9/2020 4:00:29 AM : Posting Supplierlink Query for Purchases --->>  ### 11/9/2020 4:00:29 AM
11/9/2020 4:00:34 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '09/Nov/2020' ### 11/9/2020 4:00:34 AM
11/9/2020 4:00:38 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '09/Nov/2020' ### 11/9/2020 4:00:38 AM
11/9/2020 4:00:38 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 11/9/2020 4:00:38 AM
11/9/2020 4:00:38 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '09/Nov/2020' ### 11/9/2020 4:00:38 AM
11/9/2020 4:00:39 AM : Posting ClosingStock Successful --->>  ### 11/9/2020 4:00:39 AM
11/9/2020 4:00:39 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 11/9/2020 4:00:39 AM
11/9/2020 4:00:39 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
11/9/2020 4:00:39 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1036054_TEMPLATE1.txt ### 11/9/2020 4:00:39 AM
11/9/2020 4:00:39 AM : Count:: ### TEMPLATE1:39
11/9/2020 4:00:39 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/9/2020 4:00:39 AM
11/9/2020 4:00:39 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1988040_TEMPLATE1.txt ### 11/9/2020 4:00:39 AM
11/9/2020 4:00:39 AM : Count:: ### TEMPLATE1:232
11/9/2020 4:00:40 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/9/2020 4:00:40 AM
11/9/2020 4:00:40 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2838040_TEMPLATE1.TXT ### 11/9/2020 4:00:40 AM
11/9/2020 4:00:40 AM : Count:: ### TEMPLATE1:151
11/9/2020 4:00:42 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/9/2020 4:00:42 AM
11/9/2020 4:00:42 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3555953_TEMPLATE1.txt ### 11/9/2020 4:00:42 AM
11/9/2020 4:00:42 AM : Count:: ### TEMPLATE1:55
11/9/2020 4:00:42 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/9/2020 4:00:42 AM
11/9/2020 4:00:42 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3963576_TEMPLATE1.txt ### 11/9/2020 4:00:42 AM
11/9/2020 4:00:42 AM : Count:: ### TEMPLATE1:17
11/9/2020 4:00:42 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/9/2020 4:00:42 AM
11/9/2020 4:00:42 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3966389_TEMPLATE1.txt ### 11/9/2020 4:00:42 AM
11/9/2020 4:00:42 AM : Count:: ### TEMPLATE1:37
11/9/2020 4:00:43 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/9/2020 4:00:43 AM
11/9/2020 4:00:43 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4025251_TEMPLATE1.txt ### 11/9/2020 4:00:43 AM
11/9/2020 4:00:43 AM : Count:: ### TEMPLATE1:37
11/9/2020 4:00:43 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/9/2020 4:00:43 AM
11/9/2020 4:00:43 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4277134_TEMPLATE1.txt ### 11/9/2020 4:00:43 AM
11/9/2020 4:00:43 AM : Count:: ### TEMPLATE1:149
11/9/2020 4:00:45 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/9/2020 4:00:45 AM
11/9/2020 4:00:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4447756_TEMPLATE1.txt ### 11/9/2020 4:00:45 AM
11/9/2020 4:00:45 AM : Count:: ### TEMPLATE1:35
11/9/2020 4:00:45 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/9/2020 4:00:45 AM
11/9/2020 4:00:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060559_TEMPLATE1.txt ### 11/9/2020 4:00:45 AM
11/9/2020 4:00:45 AM : Count:: ### TEMPLATE1:133
11/9/2020 4:00:47 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/9/2020 4:00:47 AM
11/9/2020 4:00:47 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060613_TEMPLATE1.txt ### 11/9/2020 4:00:47 AM
11/9/2020 4:00:47 AM : Count:: ### TEMPLATE1:3127
11/9/2020 4:00:47 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/9/2020 4:00:47 AM
11/9/2020 4:00:47 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061625_TEMPLATE1.txt ### 11/9/2020 4:00:47 AM
11/9/2020 4:00:47 AM : Count:: ### TEMPLATE1:146
11/9/2020 4:00:48 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/9/2020 4:00:48 AM
11/9/2020 4:00:48 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062804_TEMPLATE1.txt ### 11/9/2020 4:00:48 AM
11/9/2020 4:00:48 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
11/9/2020 4:00:48 AM : Template Import Complete  ### 11/9/2020 4:00:48 AM
11/9/2020 4:00:48 AM : Completed Updating Has Transaction Flag  ### 11/9/2020 4:00:48 AM
11/9/2020 4:00:49 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 11/9/2020 4:00:49 AM
11/9/2020 4:00:49 AM : Zylem Access Unblocked  ### 11/9/2020 4:00:49 AM
11/9/2020 4:00:49 AM : Application Ended  ### 11/9/2020 4:00:49 AM