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

11/12/2020 4:00:04 AM : 11  ### 11/12/2020 4:00:04 AM

11/12/2020 4:00:04 AM : 22  ### 11/12/2020 4:00:04 AM

11/12/2020 4:00:04 AM : 33  ### 11/12/2020 4:00:04 AM

11/12/2020 4:00:04 AM : Application Started  ### 11/12/2020 4:00:04 AM

11/12/2020 4:00:04 AM : Start Process : checkAllTablesExists()  ### 
11/12/2020 4:00:04 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 11/12/2020 4:00:04 AM
11/12/2020 4:00:04 AM : MainForm_Load  ### AlertSystem ON
11/12/2020 4:00:04 AM : No. of Files to import (RECEIVEFINAL):  ### 2750
11/12/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/12/2020 4:00:05 AM : For Distributor 000000000000176 Insert Count::3 ### Delete Count::0
11/12/2020 4:00:05 AM : Import AD File --->> AD_176_20201111_a050f1d70e0511be2bd45c4135b97ef6.TXT ### 11/12/2020 4:00:05 AM
11/12/2020 4:00:05 AM : For Distributor 000000000000180 Insert Count::4 ### Delete Count::0
11/12/2020 4:00:05 AM : Import AD File --->> AD_180_20201111_afe55c8203ec305c9d2dfe764dbb4af8.TXT ### 11/12/2020 4:00:05 AM
11/12/2020 4:00:05 AM : For Distributor 000000000000215 Insert Count::1 ### Delete Count::1
11/12/2020 4:00:05 AM : Import AD File --->> AD_215_20201111_e26d1fd0c0086fd3659638502b9b8a07.TXT ### 11/12/2020 4:00:05 AM
11/12/2020 4:00:05 AM : Import AD File --->> AD_220_20201111_60f20916c8050e84b68f91c077695a07.TXT ### 11/12/2020 4:00:05 AM
11/12/2020 4:00:05 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::2
11/12/2020 4:00:05 AM : For Distributor 000000000000035 Insert Count::6 ### Delete Count::0
11/12/2020 4:00:05 AM : Import AD File --->> AD_35_20201111_0ace354ff14b0803dcfa7c1453894752.TXT ### 11/12/2020 4:00:05 AM
11/12/2020 4:00:05 AM : For Distributor 000000000000361 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:05 AM : Import AD File --->> AD_361_20201111_9a285d8f4ee3a155ec353a22b90f52cf.TXT ### 11/12/2020 4:00:05 AM
11/12/2020 4:00:05 AM : For Distributor 000000000000362 Insert Count::3 ### Delete Count::1
11/12/2020 4:00:05 AM : Import AD File --->> AD_362_20201111_ac1c5742ac0422adad9b735385cb83fc.TXT ### 11/12/2020 4:00:05 AM
11/12/2020 4:00:06 AM : For Distributor 000000000000366 Insert Count::2 ### Delete Count::1
11/12/2020 4:00:06 AM : Import AD File --->> AD_366_20201111_843855345149fc664678214284a066ce.TXT ### 11/12/2020 4:00:06 AM
11/12/2020 4:00:06 AM : For Distributor 000000000000368 Insert Count::5 ### Delete Count::0
11/12/2020 4:00:06 AM : Import AD File --->> AD_368_20201111_dfd6e2fb0825b2ec196c9092e69f1a74.TXT ### 11/12/2020 4:00:06 AM
11/12/2020 4:00:06 AM : For Distributor 000000000000379 Insert Count::1 ### Delete Count::2
11/12/2020 4:00:06 AM : Import AD File --->> AD_379_20201111_f939682f83752b4566c45a15379696ff.TXT ### 11/12/2020 4:00:06 AM
11/12/2020 4:00:06 AM : For Distributor 000000000000395 Insert Count::0 ### Delete Count::1
11/12/2020 4:00:06 AM : Import AD File --->> AD_395_20201112_f26356b48a8814d7f5c6c11f800e2a60.TXT ### 11/12/2020 4:00:06 AM
11/12/2020 4:00:06 AM : For Distributor 000000000000461 Insert Count::1 ### Delete Count::1
11/12/2020 4:00:06 AM : Import AD File --->> AD_461_20201112_4197f7dc01fdd7cb1127718161e543ba.TXT ### 11/12/2020 4:00:06 AM
11/12/2020 4:00:06 AM : For Distributor 000000000000489 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:06 AM : Import AD File --->> AD_489_20201111_e395baed1946321313a3b0984aad37b0.TXT ### 11/12/2020 4:00:06 AM
11/12/2020 4:00:06 AM : For Distributor 000000000000494 Insert Count::3 ### Delete Count::0
11/12/2020 4:00:07 AM : Import AD File --->> AD_494_20201111_b82df3b30a19580d0e148ae511657374.TXT ### 11/12/2020 4:00:07 AM
11/12/2020 4:00:07 AM : For Distributor 000000000000007 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:07 AM : Import AD File --->> AD_7_20201111_aae593528f32e8240ab317388fc70b55.TXT ### 11/12/2020 4:00:07 AM
11/12/2020 4:00:07 AM : For Distributor 000000000000010 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:07 AM : Import DN File --->> DN_10_20201031_0452546d1fef63de53cb2074bd11e294.TXT ### 11/12/2020 4:00:07 AM
11/12/2020 4:00:09 AM : For Distributor 000000000000176 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:09 AM : Import DN File --->> DN_176_20201002_a7c2570cf1229aaa47a3b4d041c3a443.TXT ### 11/12/2020 4:00:09 AM
11/12/2020 4:00:09 AM : For Distributor 000000000000176 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:09 AM : Import DN File --->> DN_176_20201028_168d6a3f4c2c0df5f52e610a6ab47d2f.TXT ### 11/12/2020 4:00:09 AM
11/12/2020 4:00:10 AM : For Distributor 000000000000180 Insert Count::3 ### Delete Count::0
11/12/2020 4:00:10 AM : Import DN File --->> DN_180_20201027_133c2606b4330c6aac1382a105457967.TXT ### 11/12/2020 4:00:10 AM
11/12/2020 4:00:10 AM : For Distributor 000000000000180 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:10 AM : Import DN File --->> DN_180_20201103_1c5eaef312d194d6706e2cc92fbc5400.TXT ### 11/12/2020 4:00:10 AM
11/12/2020 4:00:11 AM : Import DN File --->> DN_220_20200207_9f44d4bbc54de094067ff072f2b5fe7e.TXT ### 11/12/2020 4:00:11 AM
11/12/2020 4:00:11 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::1
11/12/2020 4:00:15 AM : For Distributor 000000000000035 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:15 AM : Import DN File --->> DN_35_20201109_25ec3056c43ea4c357b2d5cec0b73146.TXT ### 11/12/2020 4:00:15 AM
11/12/2020 4:00:15 AM : For Distributor 000000000000035 Insert Count::4 ### Delete Count::0
11/12/2020 4:00:15 AM : Import DN File --->> DN_35_20201110_75fc27acb6e0660dfd413e842d309045.TXT ### 11/12/2020 4:00:15 AM
11/12/2020 4:00:18 AM : For Distributor 000000000000368 Insert Count::2 ### Delete Count::0
11/12/2020 4:00:18 AM : Import DN File --->> DN_368_20201103_ae4a4e8a88a90e38376a09cd37a0e39b.TXT ### 11/12/2020 4:00:18 AM
11/12/2020 4:00:18 AM : For Distributor 000000000000368 Insert Count::8 ### Delete Count::0
11/12/2020 4:00:18 AM : Import DN File --->> DN_368_20201105_9a1f6b5bc5706defe68ba02857af5939.TXT ### 11/12/2020 4:00:18 AM
11/12/2020 4:00:18 AM : Import DN File --->> DN_368_20201107_2e335c18826e1c2f010a0e6cfe100262.TXT ### 11/12/2020 4:00:18 AM
11/12/2020 4:00:18 AM : NO Previous File For Distributor 000000000000368 ### Insert Count::11
11/12/2020 4:00:19 AM : For Distributor 000000000000038 Insert Count::11 ### Delete Count::11
11/12/2020 4:00:19 AM : Import DN File --->> DN_38_20201002_3be176eadc15fa48ea6c1c82b7264a36.TXT ### 11/12/2020 4:00:19 AM
11/12/2020 4:00:19 AM : For Distributor 000000000000038 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:19 AM : Import DN File --->> DN_38_20201007_3e0be40f0f145a0125280d95d69e53be.TXT ### 11/12/2020 4:00:19 AM
11/12/2020 4:00:21 AM : For Distributor 000000000000391 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:21 AM : Import DN File --->> DN_391_20201106_5a224edd320dbe0b0d03fe77c8a47252.TXT ### 11/12/2020 4:00:21 AM
11/12/2020 4:00:24 AM : For Distributor 000000000000494 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:24 AM : Import DN File --->> DN_494_20201110_6aa9556cd50fa65fdcd014f30bce0e13.TXT ### 11/12/2020 4:00:24 AM
11/12/2020 4:00:25 AM : For Distributor 000000000000007 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:25 AM : Import DN File --->> DN_7_20201104_7bd0454c6273eeea7ed3f4efa2606bd1.TXT ### 11/12/2020 4:00:25 AM
11/12/2020 4:00:25 AM : For Distributor 000000000000007 Insert Count::3 ### Delete Count::0
11/12/2020 4:00:25 AM : Import DN File --->> DN_7_20201109_1d5f21776713fefd60fd9d6fb528ef71.TXT ### 11/12/2020 4:00:25 AM
11/12/2020 4:00:25 AM : For Distributor 000000000000009 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:25 AM : Import DN File --->> DN_9_20201015_e43c4c4b156cbbfdaa501d588f6643b2.TXT ### 11/12/2020 4:00:25 AM
11/12/2020 4:00:26 AM : For Distributor 000000000000010 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:26 AM : Import IN File --->> IN_10_20201015_f92f09aefc9da5ce5bcc955f07c8c786.TXT ### 11/12/2020 4:00:26 AM
11/12/2020 4:00:27 AM : For Distributor 000000000000115 Insert Count::2 ### Delete Count::0
11/12/2020 4:00:27 AM : Import IN File --->> IN_115_20201102_b80903338bb764b952b032fae350c078.TXT ### 11/12/2020 4:00:27 AM
11/12/2020 4:00:27 AM : For Distributor 000000000000115 Insert Count::6 ### Delete Count::0
11/12/2020 4:00:27 AM : Import IN File --->> IN_115_20201103_fb3c1b74be460dbc7da01393e4b33dfe.TXT ### 11/12/2020 4:00:27 AM
11/12/2020 4:00:28 AM : For Distributor 000000000000012 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:28 AM : Import IN File --->> IN_12_20201109_8493e39b18dfed2baf88684b40ab1a42.TXT ### 11/12/2020 4:00:28 AM
11/12/2020 4:00:28 AM : For Distributor 000000000000176 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:28 AM : Import IN File --->> IN_176_20201001_17829f89317d6fb65e7c3325cd9b2db9.TXT ### 11/12/2020 4:00:28 AM
11/12/2020 4:00:28 AM : For Distributor 000000000000176 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:28 AM : Import IN File --->> IN_176_20201003_7099fff8cbc048167602ee82450912d0.TXT ### 11/12/2020 4:00:28 AM
11/12/2020 4:00:28 AM : For Distributor 000000000000176 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:28 AM : Import IN File --->> IN_176_20201004_40e83d07a45624a03e2bcd1e0e9feb20.TXT ### 11/12/2020 4:00:28 AM
11/12/2020 4:00:28 AM : For Distributor 000000000000176 Insert Count::3 ### Delete Count::0
11/12/2020 4:00:28 AM : Import IN File --->> IN_176_20201005_916c7a7529bfc4f4a9dfba3a87a4f690.TXT ### 11/12/2020 4:00:28 AM
11/12/2020 4:00:28 AM : For Distributor 000000000000176 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:28 AM : Import IN File --->> IN_176_20201007_bb118c9871788331d5227454fdb5885a.TXT ### 11/12/2020 4:00:28 AM
11/12/2020 4:00:29 AM : For Distributor 000000000000176 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:29 AM : Import IN File --->> IN_176_20201008_3f17b4a424b3ebf4bf8a30e36064b22d.TXT ### 11/12/2020 4:00:29 AM
11/12/2020 4:00:29 AM : For Distributor 000000000000176 Insert Count::2 ### Delete Count::0
11/12/2020 4:00:29 AM : Import IN File --->> IN_176_20201009_2e55548425af6cc264ecdaf3d48d4dbf.TXT ### 11/12/2020 4:00:29 AM
11/12/2020 4:00:29 AM : For Distributor 000000000000176 Insert Count::2 ### Delete Count::0
11/12/2020 4:00:29 AM : Import IN File --->> IN_176_20201014_a425f7872c7234dea24cbaf9721ec2f7.TXT ### 11/12/2020 4:00:29 AM
11/12/2020 4:00:29 AM : For Distributor 000000000000176 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:29 AM : Import IN File --->> IN_176_20201015_fe414a47947ee7e916ddf730ce099989.TXT ### 11/12/2020 4:00:29 AM
11/12/2020 4:00:29 AM : For Distributor 000000000000176 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:29 AM : Import IN File --->> IN_176_20201016_e52eef180ecf4f61d8d564a1c48f07c8.TXT ### 11/12/2020 4:00:29 AM
11/12/2020 4:00:29 AM : For Distributor 000000000000176 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:29 AM : Import IN File --->> IN_176_20201023_a7be4132be35114ac592c7d4705f78d7.TXT ### 11/12/2020 4:00:29 AM
11/12/2020 4:00:29 AM : For Distributor 000000000000176 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:29 AM : Import IN File --->> IN_176_20201025_a33796eade809caadafd61af0eb595d1.TXT ### 11/12/2020 4:00:29 AM
11/12/2020 4:00:29 AM : For Distributor 000000000000176 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:29 AM : Import IN File --->> IN_176_20201027_92c7d3586ed4efeddc7bd0be06d167b4.TXT ### 11/12/2020 4:00:29 AM
11/12/2020 4:00:30 AM : For Distributor 000000000000176 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:30 AM : Import IN File --->> IN_176_20201028_2ec9f3dfccf4cfcd6d90e663736819db.TXT ### 11/12/2020 4:00:30 AM
11/12/2020 4:00:30 AM : For Distributor 000000000000176 Insert Count::2 ### Delete Count::0
11/12/2020 4:00:30 AM : Import IN File --->> IN_176_20201030_365d4fed048150ef1aa84b1a43778bf2.TXT ### 11/12/2020 4:00:30 AM
11/12/2020 4:00:30 AM : For Distributor 000000000000176 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:30 AM : Import IN File --->> IN_176_20201101_b27ca74ea38e614a1718a58a31b31476.TXT ### 11/12/2020 4:00:30 AM
11/12/2020 4:00:30 AM : For Distributor 000000000000176 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:30 AM : Import IN File --->> IN_176_20201102_74ebab119982cfba543f377125dc75be.TXT ### 11/12/2020 4:00:30 AM
11/12/2020 4:00:30 AM : For Distributor 000000000000176 Insert Count::2 ### Delete Count::0
11/12/2020 4:00:30 AM : Import IN File --->> IN_176_20201104_c2b8b7b81d46dbcd192ff242c2bffd89.TXT ### 11/12/2020 4:00:30 AM
11/12/2020 4:00:30 AM : For Distributor 000000000000176 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:30 AM : Import IN File --->> IN_176_20201105_8b6a0acfa2124e43dcd3170e715f74d6.TXT ### 11/12/2020 4:00:30 AM
11/12/2020 4:00:30 AM : For Distributor 000000000000176 Insert Count::4 ### Delete Count::0
11/12/2020 4:00:30 AM : Import IN File --->> IN_176_20201106_9758c7a1ced9cc50b3ad0801792dfe62.TXT ### 11/12/2020 4:00:30 AM
11/12/2020 4:00:30 AM : For Distributor 000000000000176 Insert Count::8 ### Delete Count::0
11/12/2020 4:00:30 AM : Import IN File --->> IN_176_20201107_00236035e5e893a0c6e59482d66995ed.TXT ### 11/12/2020 4:00:30 AM
11/12/2020 4:00:31 AM : For Distributor 000000000000176 Insert Count::9 ### Delete Count::0
11/12/2020 4:00:31 AM : Import IN File --->> IN_176_20201108_6799fb8f1d3c5c1ad4929336a71931c2.TXT ### 11/12/2020 4:00:31 AM
11/12/2020 4:00:31 AM : For Distributor 000000000000180 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:31 AM : Import IN File --->> IN_180_20201001_f8d6ce7c0b505fa1a0a75c0da5b7818c.TXT ### 11/12/2020 4:00:31 AM
11/12/2020 4:00:31 AM : For Distributor 000000000000180 Insert Count::4 ### Delete Count::0
11/12/2020 4:00:31 AM : Import IN File --->> IN_180_20201002_83087ebd55fc83c3f4a94fb5eac9567e.TXT ### 11/12/2020 4:00:31 AM
11/12/2020 4:00:31 AM : For Distributor 000000000000180 Insert Count::3 ### Delete Count::0
11/12/2020 4:00:31 AM : Import IN File --->> IN_180_20201019_db9dadbe1071737222410befb9c2cab1.TXT ### 11/12/2020 4:00:31 AM
11/12/2020 4:00:31 AM : For Distributor 000000000000180 Insert Count::2 ### Delete Count::0
11/12/2020 4:00:31 AM : Import IN File --->> IN_180_20201020_195f6764d377a156c08d0e04dadcc8da.TXT ### 11/12/2020 4:00:31 AM
11/12/2020 4:00:31 AM : For Distributor 000000000000180 Insert Count::2 ### Delete Count::0
11/12/2020 4:00:31 AM : Import IN File --->> IN_180_20201021_59fcbd6a19e491c2414675e486c851d9.TXT ### 11/12/2020 4:00:31 AM
11/12/2020 4:00:31 AM : For Distributor 000000000000180 Insert Count::2 ### Delete Count::0
11/12/2020 4:00:31 AM : Import IN File --->> IN_180_20201022_72244d2cc33943b19a15da55f4a21223.TXT ### 11/12/2020 4:00:31 AM
11/12/2020 4:00:32 AM : For Distributor 000000000000180 Insert Count::5 ### Delete Count::0
11/12/2020 4:00:32 AM : Import IN File --->> IN_180_20201023_2e56a2eecd994bbed5c52adb2310c10b.TXT ### 11/12/2020 4:00:32 AM
11/12/2020 4:00:32 AM : For Distributor 000000000000180 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:32 AM : Import IN File --->> IN_180_20201024_f4df22337781c1527d732b2e998ec97e.TXT ### 11/12/2020 4:00:32 AM
11/12/2020 4:00:32 AM : For Distributor 000000000000180 Insert Count::2 ### Delete Count::0
11/12/2020 4:00:32 AM : Import IN File --->> IN_180_20201026_6752bf528067a7ffdd46a2c9d03fbcb4.TXT ### 11/12/2020 4:00:32 AM
11/12/2020 4:00:32 AM : For Distributor 000000000000180 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:32 AM : Import IN File --->> IN_180_20201027_6f2348d2148163f46121ea9cef54ba5f.TXT ### 11/12/2020 4:00:32 AM
11/12/2020 4:00:32 AM : For Distributor 000000000000180 Insert Count::2 ### Delete Count::0
11/12/2020 4:00:32 AM : Import IN File --->> IN_180_20201028_1b4f676fcc0fec72cbb988e46055df53.TXT ### 11/12/2020 4:00:32 AM
11/12/2020 4:00:32 AM : For Distributor 000000000000180 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:32 AM : Import IN File --->> IN_180_20201030_8dcdcf964068d85e3fc28adacbe58e37.TXT ### 11/12/2020 4:00:32 AM
11/12/2020 4:00:32 AM : For Distributor 000000000000180 Insert Count::4 ### Delete Count::0
11/12/2020 4:00:32 AM : Import IN File --->> IN_180_20201108_717356787002ed371fb2d303f4c5377c.TXT ### 11/12/2020 4:00:32 AM
11/12/2020 4:00:33 AM : For Distributor 000000000000215 Insert Count::1 ### Delete Count::1
11/12/2020 4:00:33 AM : Import IN File --->> IN_215_20201001_6d7a655b008583ebc2079d37a3b9cee3.TXT ### 11/12/2020 4:00:33 AM
11/12/2020 4:00:33 AM : For Distributor 000000000000215 Insert Count::1 ### Delete Count::1
11/12/2020 4:00:33 AM : Import IN File --->> IN_215_20201003_dffd13fdbfce14a03c367a188cacc8ce.TXT ### 11/12/2020 4:00:33 AM
11/12/2020 4:00:33 AM : For Distributor 000000000000215 Insert Count::2 ### Delete Count::2
11/12/2020 4:00:33 AM : Import IN File --->> IN_215_20201009_22447769a4182ed53000eec92b46d48d.TXT ### 11/12/2020 4:00:33 AM
11/12/2020 4:00:34 AM : For Distributor 000000000000215 Insert Count::1 ### Delete Count::1
11/12/2020 4:00:34 AM : Import IN File --->> IN_215_20201015_d3bdca57c4b790ff5f2f3ca414ec5a2d.TXT ### 11/12/2020 4:00:34 AM
11/12/2020 4:00:34 AM : For Distributor 000000000000215 Insert Count::1 ### Delete Count::1
11/12/2020 4:00:34 AM : Import IN File --->> IN_215_20201017_073c6a65f6cc992978a7c9b8ae763cbe.TXT ### 11/12/2020 4:00:34 AM
11/12/2020 4:00:34 AM : For Distributor 000000000000215 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:34 AM : Import IN File --->> IN_215_20201018_177acc4053b4f57d814b8113ea323cd0.TXT ### 11/12/2020 4:00:34 AM
11/12/2020 4:00:34 AM : For Distributor 000000000000215 Insert Count::1 ### Delete Count::1
11/12/2020 4:00:34 AM : Import IN File --->> IN_215_20201022_c9e21826fb8dcd5e0c90e40fe77e9f8c.TXT ### 11/12/2020 4:00:34 AM
11/12/2020 4:00:34 AM : For Distributor 000000000000215 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:34 AM : Import IN File --->> IN_215_20201023_99a895136870934f1d2bae471925a167.TXT ### 11/12/2020 4:00:34 AM
11/12/2020 4:00:34 AM : For Distributor 000000000000215 Insert Count::3 ### Delete Count::1
11/12/2020 4:00:34 AM : Import IN File --->> IN_215_20201107_265c117c492a218fe263f91299e821b1.TXT ### 11/12/2020 4:00:34 AM
11/12/2020 4:00:34 AM : For Distributor 000000000000215 Insert Count::2 ### Delete Count::0
11/12/2020 4:00:34 AM : Import IN File --->> IN_215_20201109_37a3e6755c616e9aeac34b2fee1aa0bd.TXT ### 11/12/2020 4:00:34 AM
11/12/2020 4:00:35 AM : Import IN File --->> IN_220_20200101_25255e983d47c03508d2cdacd032a13f.TXT ### 11/12/2020 4:00:35 AM
11/12/2020 4:00:35 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::29
11/12/2020 4:00:35 AM : Import IN File --->> IN_220_20200102_7e58dca06909862c8cacee774f03382a.TXT ### 11/12/2020 4:00:35 AM
11/12/2020 4:00:35 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::11
11/12/2020 4:00:35 AM : Import IN File --->> IN_220_20200103_1503588703f3860bdc852a34cb390057.TXT ### 11/12/2020 4:00:35 AM
11/12/2020 4:00:35 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::54
11/12/2020 4:00:35 AM : Import IN File --->> IN_220_20200104_53b94ae987749c2dcb1b68f3ddd70f18.TXT ### 11/12/2020 4:00:35 AM
11/12/2020 4:00:35 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::66
11/12/2020 4:00:35 AM : Import IN File --->> IN_220_20200105_ade7a868e92ce118ffdede9b4fd70bcb.TXT ### 11/12/2020 4:00:35 AM
11/12/2020 4:00:35 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::16
11/12/2020 4:00:35 AM : Import IN File --->> IN_220_20200106_71f5935b8dd9a5058ba2eb4915573ce3.TXT ### 11/12/2020 4:00:35 AM
11/12/2020 4:00:35 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::17
11/12/2020 4:00:35 AM : Import IN File --->> IN_220_20200116_0939012fed2d3848a6ee7c267ffceb53.TXT ### 11/12/2020 4:00:35 AM
11/12/2020 4:00:35 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::34
11/12/2020 4:00:35 AM : Import IN File --->> IN_220_20200117_24f653aa682b35c220568078cc4d12f9.TXT ### 11/12/2020 4:00:35 AM
11/12/2020 4:00:35 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::35
11/12/2020 4:00:35 AM : Import IN File --->> IN_220_20200118_84445a030881e72c53e30de5bac16c69.TXT ### 11/12/2020 4:00:35 AM
11/12/2020 4:00:35 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::18
11/12/2020 4:00:35 AM : Import IN File --->> IN_220_20200119_f249b6b0519fa7a35e331cc8e8691640.TXT ### 11/12/2020 4:00:35 AM
11/12/2020 4:00:35 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::21
11/12/2020 4:00:35 AM : Import IN File --->> IN_220_20200120_63feedb212dcc6f117730202ed5ff148.TXT ### 11/12/2020 4:00:35 AM
11/12/2020 4:00:35 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::39
11/12/2020 4:00:35 AM : Import IN File --->> IN_220_20200121_83e00620c392593d0ffaccdbcc7408bf.TXT ### 11/12/2020 4:00:35 AM
11/12/2020 4:00:35 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::18
11/12/2020 4:00:35 AM : Import IN File --->> IN_220_20200122_13ec43d604dc1c17ad6d7c813991d76f.TXT ### 11/12/2020 4:00:35 AM
11/12/2020 4:00:35 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::10
11/12/2020 4:00:36 AM : Import IN File --->> IN_220_20200201_11bc259590d2172f0588bdc6f870c5d9.TXT ### 11/12/2020 4:00:36 AM
11/12/2020 4:00:36 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::5
11/12/2020 4:00:36 AM : Import IN File --->> IN_220_20200204_3bd9b7cc1265a1a15bd9ca53876841fc.TXT ### 11/12/2020 4:00:36 AM
11/12/2020 4:00:36 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::11
11/12/2020 4:00:36 AM : Import IN File --->> IN_220_20200205_12cf7064e7cf4dd5b546da0f22bd2fbf.TXT ### 11/12/2020 4:00:36 AM
11/12/2020 4:00:36 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::16
11/12/2020 4:00:36 AM : Import IN File --->> IN_220_20200206_613c3ad3f14faa46c0ef1e6f42520f8c.TXT ### 11/12/2020 4:00:36 AM
11/12/2020 4:00:36 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::13
11/12/2020 4:00:36 AM : Import IN File --->> IN_220_20200207_a21e1f4be4dd1986012cf731bd6c8ac9.TXT ### 11/12/2020 4:00:36 AM
11/12/2020 4:00:36 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::22
11/12/2020 4:00:36 AM : Import IN File --->> IN_220_20200208_01dc7ef6af5147857ceb051a3bd060ed.TXT ### 11/12/2020 4:00:36 AM
11/12/2020 4:00:36 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::13
11/12/2020 4:00:36 AM : Import IN File --->> IN_220_20200209_380169d254e58a3fff8514c657f53199.TXT ### 11/12/2020 4:00:36 AM
11/12/2020 4:00:36 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::20
11/12/2020 4:00:36 AM : Import IN File --->> IN_220_20200210_eea88b6c0c36747c47ec3b666bf62b4d.TXT ### 11/12/2020 4:00:36 AM
11/12/2020 4:00:36 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::21
11/12/2020 4:00:36 AM : Import IN File --->> IN_220_20200211_62d5d751244dc97e87e2db5cd8a6b4a9.TXT ### 11/12/2020 4:00:36 AM
11/12/2020 4:00:36 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::20
11/12/2020 4:00:36 AM : Import IN File --->> IN_220_20200212_568f40fe4bdacd811094875237ae4901.TXT ### 11/12/2020 4:00:36 AM
11/12/2020 4:00:36 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::22
11/12/2020 4:00:36 AM : Import IN File --->> IN_220_20200213_e3d71414af525fe00a221178f965e3a2.TXT ### 11/12/2020 4:00:36 AM
11/12/2020 4:00:36 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::21
11/12/2020 4:00:36 AM : Import IN File --->> IN_220_20200214_e59ade8478b3ef3d32743193726ea97e.TXT ### 11/12/2020 4:00:36 AM
11/12/2020 4:00:36 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::6
11/12/2020 4:00:36 AM : Import IN File --->> IN_220_20200226_8d96e2346672e19c2aae161f7e338153.TXT ### 11/12/2020 4:00:36 AM
11/12/2020 4:00:36 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::6
11/12/2020 4:00:36 AM : Import IN File --->> IN_220_20200227_a8af07f9c2129d111c2274c2d38f5b73.TXT ### 11/12/2020 4:00:36 AM
11/12/2020 4:00:36 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::5
11/12/2020 4:00:37 AM : Import IN File --->> IN_220_20200301_2ea5908072068b52e946a8b6611a3052.TXT ### 11/12/2020 4:00:37 AM
11/12/2020 4:00:37 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::12
11/12/2020 4:00:37 AM : Import IN File --->> IN_220_20200302_4c506c8a1f4b17971a3493986a772eef.TXT ### 11/12/2020 4:00:37 AM
11/12/2020 4:00:37 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::3
11/12/2020 4:00:37 AM : Import IN File --->> IN_220_20200303_8a0bc3d2135db38415f66f37b9e5c36e.TXT ### 11/12/2020 4:00:37 AM
11/12/2020 4:00:37 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::1
11/12/2020 4:00:37 AM : Import IN File --->> IN_220_20200304_0a6b998e3641e5877d712e6644c821d9.TXT ### 11/12/2020 4:00:37 AM
11/12/2020 4:00:37 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::8
11/12/2020 4:00:37 AM : Import IN File --->> IN_220_20200305_6d41990267b63eaaaf8730e4127b0808.TXT ### 11/12/2020 4:00:37 AM
11/12/2020 4:00:37 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::4
11/12/2020 4:00:37 AM : Import IN File --->> IN_220_20200306_b8177eb353074d3838ca331e942d5b5c.TXT ### 11/12/2020 4:00:37 AM
11/12/2020 4:00:37 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::14
11/12/2020 4:00:37 AM : Import IN File --->> IN_220_20200307_e526f4b9686f695544ed80854ff70115.TXT ### 11/12/2020 4:00:37 AM
11/12/2020 4:00:37 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::3
11/12/2020 4:00:37 AM : Import IN File --->> IN_220_20200308_a816111f2592b4ce481f53baeb76e7cf.TXT ### 11/12/2020 4:00:37 AM
11/12/2020 4:00:37 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::9
11/12/2020 4:00:37 AM : Import IN File --->> IN_220_20200309_3a3507b4fad57af266d0cf804d51c59a.TXT ### 11/12/2020 4:00:37 AM
11/12/2020 4:00:37 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::7
11/12/2020 4:00:37 AM : Import IN File --->> IN_220_20200317_7f8496997a7d31700eaf843510ded7f3.TXT ### 11/12/2020 4:00:37 AM
11/12/2020 4:00:37 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::4
11/12/2020 4:00:40 AM : For Distributor 000000000000352 Insert Count::6 ### Delete Count::1
11/12/2020 4:00:40 AM : Import IN File --->> IN_352_20201109_0970af1114d993c49e714118e011d47d.TXT ### 11/12/2020 4:00:40 AM
11/12/2020 4:00:40 AM : For Distributor 000000000000352 Insert Count::7 ### Delete Count::0
11/12/2020 4:00:40 AM : Import IN File --->> IN_352_20201110_65126368411627d2e23b69df70f7f451.TXT ### 11/12/2020 4:00:40 AM
11/12/2020 4:00:41 AM : For Distributor 000000000000035 Insert Count::25 ### Delete Count::0
11/12/2020 4:00:41 AM : Import IN File --->> IN_35_20201110_4218f4d818603e0ac719e3b3eb357dcd.TXT ### 11/12/2020 4:00:41 AM
11/12/2020 4:00:42 AM : For Distributor 000000000000361 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:42 AM : Import IN File --->> IN_361_20201110_3e9a874735b7a4b0887965831250181b.TXT ### 11/12/2020 4:00:42 AM
11/12/2020 4:00:42 AM : For Distributor 000000000000362 Insert Count::1 ### Delete Count::1
11/12/2020 4:00:42 AM : Import IN File --->> IN_362_20201001_9f6ff9c611697b92102f8162232553c6.TXT ### 11/12/2020 4:00:42 AM
11/12/2020 4:00:42 AM : For Distributor 000000000000362 Insert Count::2 ### Delete Count::0
11/12/2020 4:00:42 AM : Import IN File --->> IN_362_20201106_b1f58b3579a3f3bb0127a45187761f53.TXT ### 11/12/2020 4:00:42 AM
11/12/2020 4:00:43 AM : For Distributor 000000000000362 Insert Count::10 ### Delete Count::0
11/12/2020 4:00:43 AM : Import IN File --->> IN_362_20201107_5758d1985912f918eaab548c38409410.TXT ### 11/12/2020 4:00:43 AM
11/12/2020 4:00:43 AM : For Distributor 000000000000362 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:43 AM : Import IN File --->> IN_362_20201109_fd8724861d84b1e5e47bdf3fee066eba.TXT ### 11/12/2020 4:00:43 AM
11/12/2020 4:00:43 AM : For Distributor 000000000000362 Insert Count::4 ### Delete Count::0
11/12/2020 4:00:43 AM : Import IN File --->> IN_362_20201110_3e6e22789c497deb9d0cb5ca04924d69.TXT ### 11/12/2020 4:00:43 AM
11/12/2020 4:00:43 AM : Import IN File --->> IN_362_20201111_4570995cb1a3f54f7e90d01548e58ee9.TXT ### 11/12/2020 4:00:43 AM
11/12/2020 4:00:43 AM : NO Previous File For Distributor 000000000000362 ### Insert Count::1
11/12/2020 4:00:44 AM : Import IN File --->> IN_366_20201111_6dcfaf900f34cfeb0f22145746f5b9ba.TXT ### 11/12/2020 4:00:44 AM
11/12/2020 4:00:44 AM : NO Previous File For Distributor 000000000000366 ### Insert Count::4
11/12/2020 4:00:45 AM : Import IN File --->> IN_368_20201107_0ad72fd2d7f6f5b9518719035ff1ea48.TXT ### 11/12/2020 4:00:45 AM
11/12/2020 4:00:45 AM : NO Previous File For Distributor 000000000000368 ### Insert Count::30
11/12/2020 4:00:45 AM : Import IN File --->> IN_368_20201109_8888d00db54506d0011a11248e39848f.TXT ### 11/12/2020 4:00:45 AM
11/12/2020 4:00:45 AM : NO Previous File For Distributor 000000000000368 ### Insert Count::66
11/12/2020 4:00:45 AM : Import IN File --->> IN_368_20201110_ef2511cb8700f5ed9b65736e9048ff24.TXT ### 11/12/2020 4:00:45 AM
11/12/2020 4:00:45 AM : NO Previous File For Distributor 000000000000368 ### Insert Count::52
11/12/2020 4:00:45 AM : Import IN File --->> IN_368_20201111_53a20e1a14dda4b28eeec03493946158.TXT ### 11/12/2020 4:00:45 AM
11/12/2020 4:00:45 AM : NO Previous File For Distributor 000000000000368 ### Insert Count::19
11/12/2020 4:00:45 AM : For Distributor 000000000000379 Insert Count::4 ### Delete Count::4
11/12/2020 4:00:45 AM : Import IN File --->> IN_379_20201017_aa137d15b9fe140fba5e13abf40b8957.TXT ### 11/12/2020 4:00:45 AM
11/12/2020 4:00:45 AM : For Distributor 000000000000379 Insert Count::2 ### Delete Count::2
11/12/2020 4:00:45 AM : Import IN File --->> IN_379_20201029_ddf758df02dfd7002c94b6cc4942eac1.TXT ### 11/12/2020 4:00:45 AM
11/12/2020 4:00:45 AM : For Distributor 000000000000379 Insert Count::3 ### Delete Count::1
11/12/2020 4:00:45 AM : Import IN File --->> IN_379_20201031_78e77d1fc12a6ed136406d7dd41aa871.TXT ### 11/12/2020 4:00:45 AM
11/12/2020 4:00:46 AM : For Distributor 000000000000379 Insert Count::5 ### Delete Count::0
11/12/2020 4:00:46 AM : Import IN File --->> IN_379_20201110_2965c32ac7a49c41e006edb678f86620.TXT ### 11/12/2020 4:00:46 AM
11/12/2020 4:00:46 AM : For Distributor 000000000000038 Insert Count::2 ### Delete Count::2
11/12/2020 4:00:46 AM : Import IN File --->> IN_38_20201001_db4fbbb9dc16a48ad19c380989fe72c5.TXT ### 11/12/2020 4:00:46 AM
11/12/2020 4:00:46 AM : For Distributor 000000000000038 Insert Count::2 ### Delete Count::2
11/12/2020 4:00:46 AM : Import IN File --->> IN_38_20201003_b4c58ba77d8941f6fb06b1e91b56794b.TXT ### 11/12/2020 4:00:46 AM
11/12/2020 4:00:46 AM : For Distributor 000000000000038 Insert Count::1 ### Delete Count::1
11/12/2020 4:00:46 AM : Import IN File --->> IN_38_20201006_e9e4d77b16996d0c788d096631a984d2.TXT ### 11/12/2020 4:00:46 AM
11/12/2020 4:00:46 AM : For Distributor 000000000000038 Insert Count::17 ### Delete Count::0
11/12/2020 4:00:46 AM : Import IN File --->> IN_38_20201008_a10bb5f3c0266e3eb3a0e6efd0c0cef6.TXT ### 11/12/2020 4:00:46 AM
11/12/2020 4:00:46 AM : For Distributor 000000000000038 Insert Count::5 ### Delete Count::0
11/12/2020 4:00:46 AM : Import IN File --->> IN_38_20201009_69ef3416dae8dc80ef14052c9439c89b.TXT ### 11/12/2020 4:00:46 AM
11/12/2020 4:00:46 AM : For Distributor 000000000000038 Insert Count::4 ### Delete Count::0
11/12/2020 4:00:46 AM : Import IN File --->> IN_38_20201010_945e818e561f25c14ccac6a7f9540bfa.TXT ### 11/12/2020 4:00:46 AM
11/12/2020 4:00:47 AM : For Distributor 000000000000038 Insert Count::5 ### Delete Count::0
11/12/2020 4:00:47 AM : Import IN File --->> IN_38_20201012_f6bd84a1382245993b6abf9b383e2692.TXT ### 11/12/2020 4:00:47 AM
11/12/2020 4:00:48 AM : Import IN File --->> IN_391_20201109_1c79dc045454999bcebdc14a7a0b662e.TXT ### 11/12/2020 4:00:48 AM
11/12/2020 4:00:48 AM : NO Previous File For Distributor 000000000000391 ### Insert Count::7
11/12/2020 4:00:48 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/12/2020 4:00:50 AM : For Distributor 000000000000461 Insert Count::2 ### Delete Count::0
11/12/2020 4:00:50 AM : Import IN File --->> IN_461_20201109_aac26f43c48e2df9a22e362d526e4fcf.TXT ### 11/12/2020 4:00:50 AM
11/12/2020 4:00:50 AM : Import IN File --->> IN_461_20201111_299cb79bb919848ce0b8976cb180c6c1.TXT ### 11/12/2020 4:00:50 AM
11/12/2020 4:00:50 AM : NO Previous File For Distributor 000000000000461 ### Insert Count::1
11/12/2020 4:00:51 AM : For Distributor 000000000000467 Insert Count::4 ### Delete Count::0
11/12/2020 4:00:51 AM : Import IN File --->> IN_467_20201107_4b19987efa69983462e46991b2987758.TXT ### 11/12/2020 4:00:51 AM
11/12/2020 4:00:51 AM : Import IN File --->> IN_467_20201109_639cf52c329d543b762ff6220663d7a0.TXT ### 11/12/2020 4:00:51 AM
11/12/2020 4:00:51 AM : NO Previous File For Distributor 000000000000467 ### Insert Count::1
11/12/2020 4:00:52 AM : For Distributor 000000000000489 Insert Count::3 ### Delete Count::0
11/12/2020 4:00:52 AM : Import IN File --->> IN_489_20201106_c4dce61fbdacab7d9b16c1c8b3ec0ca2.TXT ### 11/12/2020 4:00:52 AM
11/12/2020 4:00:52 AM : For Distributor 000000000000489 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:52 AM : Import IN File --->> IN_489_20201107_40cd9e8193814655a72b109c477e8947.TXT ### 11/12/2020 4:00:52 AM
11/12/2020 4:00:53 AM : For Distributor 000000000000494 Insert Count::11 ### Delete Count::0
11/12/2020 4:00:53 AM : Import IN File --->> IN_494_20201109_7508c77cbb8faf181c84c73b14e201a7.TXT ### 11/12/2020 4:00:53 AM
11/12/2020 4:00:53 AM : For Distributor 000000000000494 Insert Count::15 ### Delete Count::0
11/12/2020 4:00:53 AM : Import IN File --->> IN_494_20201110_6d87b278fb300f2fde2820f35b00172a.TXT ### 11/12/2020 4:00:53 AM
11/12/2020 4:00:53 AM : For Distributor 000000000000007 Insert Count::6 ### Delete Count::0
11/12/2020 4:00:53 AM : Import IN File --->> IN_7_20201110_291e02b996d710f69ebcb5997e269614.TXT ### 11/12/2020 4:00:53 AM
11/12/2020 4:00:53 AM : Import IN File --->> IN_7_20201111_c296cc28d4f6d70c0efde2a7f2072f67.TXT ### 11/12/2020 4:00:53 AM
11/12/2020 4:00:53 AM : NO Previous File For Distributor 000000000000007 ### Insert Count::26
11/12/2020 4:00:54 AM : For Distributor 000000000000366 Insert Count::1 ### Delete Count::1
11/12/2020 4:00:54 AM : Import OT File --->> OT_366_20201004_466f4fd4467e7856265907e8f0e8df8a.TXT ### 11/12/2020 4:00:54 AM
11/12/2020 4:00:54 AM : For Distributor 000000000000366 Insert Count::2 ### Delete Count::2
11/12/2020 4:00:54 AM : Import OT File --->> OT_366_20201020_b9de169e2fcd32954742f17ed6c97f76.TXT ### 11/12/2020 4:00:54 AM
11/12/2020 4:00:55 AM : For Distributor 000000000000366 Insert Count::2 ### Delete Count::2
11/12/2020 4:00:55 AM : Import OT File --->> OT_366_20201022_58208b92a8c459572fd4517f396164e0.TXT ### 11/12/2020 4:00:55 AM
11/12/2020 4:00:55 AM : For Distributor 000000000000366 Insert Count::2 ### Delete Count::2
11/12/2020 4:00:55 AM : Import OT File --->> OT_366_20201102_b54505618228c31c21d93aa9ad283045.TXT ### 11/12/2020 4:00:55 AM
11/12/2020 4:00:57 AM : For Distributor 000000000000467 Insert Count::12 ### Delete Count::0
11/12/2020 4:00:57 AM : Import OT File --->> OT_467_20201106_2e6258d19c70c4caf1d33e929862ca4e.TXT ### 11/12/2020 4:00:57 AM
11/12/2020 4:00:57 AM : For Distributor 000000000000176 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:57 AM : Import PR File --->> PR_176_20201111_437c7b81c6dfb6e397648941d90fc0c3.TXT ### 11/12/2020 4:00:57 AM
11/12/2020 4:00:57 AM : Import PR File --->> PR_220_20201111_c922169c3dcaa9c6313aeb3c695be439.TXT ### 11/12/2020 4:00:57 AM
11/12/2020 4:00:57 AM : NO Previous File For Distributor 000000000000220 ### Insert Count::14
11/12/2020 4:00:57 AM : For Distributor 000000000000038 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:57 AM : Import PR File --->> PR_38_20201111_bb7816df62b081682223d2555844fff1.TXT ### 11/12/2020 4:00:57 AM
11/12/2020 4:00:57 AM : For Distributor 000000000000007 Insert Count::1 ### Delete Count::0
11/12/2020 4:00:57 AM : Import PR File --->> PR_7_20201111_ba167218d9bd1d3a06b51ac4de210ecd.TXT ### 11/12/2020 4:00:57 AM
11/12/2020 4:00:57 AM : PostData() --->>  ### 11/12/2020 4:00:57 AM
11/12/2020 4:01:02 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 11/12/2020 4:01:02 AM
11/12/2020 4:01:04 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '12/Nov/2020' ### 11/12/2020 4:01:04 AM
11/12/2020 4:01:04 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '12/Nov/2020' ### 11/12/2020 4:01:04 AM
11/12/2020 4:01:04 AM :  ### 
11/12/2020 4:01:04 AM : UNLINKEDSALES Record Count Before --->> 1090 ### 11/12/2020 4:01:04 AM
11/12/2020 4:01:04 AM : UNLINKEDSALES_DEL Record Count Before --->> 22 ### 11/12/2020 4:01:04 AM
11/12/2020 4:01:12 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '12/Nov/2020' ### 11/12/2020 4:01:12 AM
11/12/2020 4:01:12 AM : UNLINKEDSALES Record Count After --->> 0 ### 11/12/2020 4:01:12 AM
11/12/2020 4:01:12 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 11/12/2020 4:01:12 AM
11/12/2020 4:01:12 AM :  ### 
11/12/2020 4:01:12 AM : Posting Supplierlink Query for Purchases --->>  ### 11/12/2020 4:01:12 AM
11/12/2020 4:01:17 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '12/Nov/2020' ### 11/12/2020 4:01:17 AM
11/12/2020 4:01:22 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '12/Nov/2020' ### 11/12/2020 4:01:22 AM
11/12/2020 4:01:22 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 11/12/2020 4:01:22 AM
11/12/2020 4:01:22 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '12/Nov/2020' ### 11/12/2020 4:01:22 AM
11/12/2020 4:01:22 AM : Posting ClosingStock Successful --->>  ### 11/12/2020 4:01:22 AM
11/12/2020 4:01:22 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 11/12/2020 4:01:22 AM
11/12/2020 4:01:23 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
11/12/2020 4:01:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1988040_TEMPLATE1.txt ### 11/12/2020 4:01:23 AM
11/12/2020 4:01:23 AM : Count:: ### TEMPLATE1:231
11/12/2020 4:01:25 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:25 AM
11/12/2020 4:01:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2838040_TEMPLATE1.TXT ### 11/12/2020 4:01:25 AM
11/12/2020 4:01:25 AM : Count:: ### TEMPLATE1:151
11/12/2020 4:01:26 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:26 AM
11/12/2020 4:01:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3224985_TEMPLATE1.txt ### 11/12/2020 4:01:26 AM
11/12/2020 4:01:26 AM : Count:: ### TEMPLATE1:55
11/12/2020 4:01:26 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:26 AM
11/12/2020 4:01:26 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3555953_TEMPLATE1.txt ### 11/12/2020 4:01:26 AM
11/12/2020 4:01:26 AM : Count:: ### TEMPLATE1:55
11/12/2020 4:01:27 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:27 AM
11/12/2020 4:01:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3573015_TEMPLATE1.txt ### 11/12/2020 4:01:27 AM
11/12/2020 4:01:27 AM : Count:: ### TEMPLATE1:3
11/12/2020 4:01:27 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:27 AM
11/12/2020 4:01:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3831146_TEMPLATE1.txt ### 11/12/2020 4:01:27 AM
11/12/2020 4:01:27 AM : Count:: ### TEMPLATE1:15
11/12/2020 4:01:27 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:27 AM
11/12/2020 4:01:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3912298_TEMPLATE1.TXT ### 11/12/2020 4:01:27 AM
11/12/2020 4:01:27 AM : Count:: ### TEMPLATE1:87
11/12/2020 4:01:28 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:28 AM
11/12/2020 4:01:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3912945_TEMPLATE1.txt ### 11/12/2020 4:01:28 AM
11/12/2020 4:01:28 AM : Count:: ### TEMPLATE1:71
11/12/2020 4:01:28 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:28 AM
11/12/2020 4:01:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3927136_TEMPLATE1.txt ### 11/12/2020 4:01:28 AM
11/12/2020 4:01:28 AM : Count:: ### TEMPLATE1:281
11/12/2020 4:01:29 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:29 AM
11/12/2020 4:01:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3963576_TEMPLATE1.txt ### 11/12/2020 4:01:29 AM
11/12/2020 4:01:29 AM : Count:: ### TEMPLATE1:21
11/12/2020 4:01:29 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:29 AM
11/12/2020 4:01:29 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3966389_TEMPLATE1.txt ### 11/12/2020 4:01:29 AM
11/12/2020 4:01:29 AM : Count:: ### TEMPLATE1:40
11/12/2020 4:01:30 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:30 AM
11/12/2020 4:01:30 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4025251_TEMPLATE1.txt ### 11/12/2020 4:01:30 AM
11/12/2020 4:01:30 AM : Count:: ### TEMPLATE1:37
11/12/2020 4:01:30 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:30 AM
11/12/2020 4:01:30 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4058225_TEMPLATE1.txt ### 11/12/2020 4:01:30 AM
11/12/2020 4:01:30 AM : Count:: ### TEMPLATE1:492
11/12/2020 4:01:32 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:32 AM
11/12/2020 4:01:32 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4277134_TEMPLATE1.txt ### 11/12/2020 4:01:32 AM
11/12/2020 4:01:32 AM : Count:: ### TEMPLATE1:148
11/12/2020 4:01:33 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:33 AM
11/12/2020 4:01:33 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4457065_TEMPLATE1.txt ### 11/12/2020 4:01:33 AM
11/12/2020 4:01:33 AM : Count:: ### TEMPLATE1:48
11/12/2020 4:01:34 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:34 AM
11/12/2020 4:01:34 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4526825_TEMPLATE1.txt ### 11/12/2020 4:01:34 AM
11/12/2020 4:01:34 AM : Count:: ### TEMPLATE1:16
11/12/2020 4:01:34 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:34 AM
11/12/2020 4:01:34 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4529171_TEMPLATE1.txt ### 11/12/2020 4:01:34 AM
11/12/2020 4:01:34 AM : Count:: ### TEMPLATE1:34
11/12/2020 4:01:35 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:35 AM
11/12/2020 4:01:35 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060305_TEMPLATE1.txt ### 11/12/2020 4:01:35 AM
11/12/2020 4:01:35 AM : Count:: ### TEMPLATE1:86
11/12/2020 4:01:36 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:36 AM
11/12/2020 4:01:36 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060327_TEMPLATE1.TXT ### 11/12/2020 4:01:36 AM
11/12/2020 4:01:36 AM : Count:: ### TEMPLATE1:48
11/12/2020 4:01:36 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:36 AM
11/12/2020 4:01:36 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060559_TEMPLATE1.txt ### 11/12/2020 4:01:36 AM
11/12/2020 4:01:36 AM : Count:: ### TEMPLATE1:133
11/12/2020 4:01:38 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:38 AM
11/12/2020 4:01:38 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060613_TEMPLATE1.txt ### 11/12/2020 4:01:38 AM
11/12/2020 4:01:38 AM : Count:: ### TEMPLATE1:3128
11/12/2020 4:01:38 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:38 AM
11/12/2020 4:01:38 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060893_TEMPLATE1.txt ### 11/12/2020 4:01:38 AM
11/12/2020 4:01:38 AM : Count:: ### TEMPLATE1:415
11/12/2020 4:01:40 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:40 AM
11/12/2020 4:01:40 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061250_TEMPLATE1.txt ### 11/12/2020 4:01:40 AM
11/12/2020 4:01:40 AM : Count:: ### TEMPLATE1:194
11/12/2020 4:01:41 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:41 AM
11/12/2020 4:01:41 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061385_TEMPLATE1.TXT ### 11/12/2020 4:01:41 AM
11/12/2020 4:01:41 AM : Count:: ### TEMPLATE1:41
11/12/2020 4:01:41 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:41 AM
11/12/2020 4:01:41 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061625_TEMPLATE1.txt ### 11/12/2020 4:01:41 AM
11/12/2020 4:01:41 AM : Count:: ### TEMPLATE1:146
11/12/2020 4:01:43 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:43 AM
11/12/2020 4:01:43 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062642_TEMPLATE1.txt ### 11/12/2020 4:01:43 AM
11/12/2020 4:01:43 AM : Count:: ### TEMPLATE1:41
11/12/2020 4:01:44 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:44 AM
11/12/2020 4:01:44 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062804_TEMPLATE1.txt ### 11/12/2020 4:01:44 AM
11/12/2020 4:01:44 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
11/12/2020 4:01:44 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063967_TEMPLATE1.txt ### 11/12/2020 4:01:44 AM
11/12/2020 4:01:44 AM : Count:: ### TEMPLATE1:100
11/12/2020 4:01:45 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:45 AM
11/12/2020 4:01:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9064815_TEMPLATE1.txt ### 11/12/2020 4:01:45 AM
11/12/2020 4:01:45 AM : Count:: ### TEMPLATE1:42
11/12/2020 4:01:46 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:46 AM
11/12/2020 4:01:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9065310_TEMPLATE1.txt ### 11/12/2020 4:01:46 AM
11/12/2020 4:01:46 AM : Count:: ### TEMPLATE1:61
11/12/2020 4:01:46 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:46 AM
11/12/2020 4:01:46 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067092_TEMPLATE1.TXT ### 11/12/2020 4:01:46 AM
11/12/2020 4:01:46 AM : Count:: ### TEMPLATE1:65
11/12/2020 4:01:47 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:47 AM
11/12/2020 4:01:47 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067123_TEMPLATE1.txt ### 11/12/2020 4:01:47 AM
11/12/2020 4:01:47 AM : Count:: ### TEMPLATE1:29
11/12/2020 4:01:47 AM : SP_DistributorTemplatePosting Successful --->>  ### 11/12/2020 4:01:47 AM
11/12/2020 4:01:47 AM : Template Import Complete  ### 11/12/2020 4:01:47 AM
11/12/2020 4:01:48 AM : Completed Updating Has Transaction Flag  ### 11/12/2020 4:01:48 AM
11/12/2020 4:01:48 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 11/12/2020 4:01:48 AM
11/12/2020 4:01:48 AM : Zylem Access Unblocked  ### 11/12/2020 4:01:48 AM
11/12/2020 4:01:48 AM : Application Ended  ### 11/12/2020 4:01:48 AM