7/18/2021 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
7/18/2021 2:30:04 AM : StartProcess  ### 7/18/2021 2:30:04 AM

7/18/2021 2:30:04 AM : 11  ### 7/18/2021 2:30:04 AM

7/18/2021 2:30:04 AM : 22  ### 7/18/2021 2:30:04 AM

7/18/2021 2:30:04 AM : 33  ### 7/18/2021 2:30:04 AM

7/18/2021 2:30:04 AM : Application Started  ### 7/18/2021 2:30:04 AM

7/18/2021 2:30:04 AM : Start Process : checkAllTablesExists()  ### 
7/18/2021 2:30:04 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 7/18/2021 2:30:04 AM
7/18/2021 2:30:04 AM : MainForm_Load  ### AlertSystem ON
7/18/2021 2:30:04 AM : No. of Files to import (RECEIVEFINAL):  ### 365
7/18/2021 2:30:04 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
7/18/2021 2:30:05 AM : For Distributor 000000000001191 Insert Count::1 ### Delete Count::0
7/18/2021 2:30:05 AM : Import AD File --->> AD_1191_20210718_d2d910d3449a67b6a73b8d4e7afc3985.TXT ### 7/18/2021 2:30:05 AM
7/18/2021 2:30:05 AM : For Distributor 000000000000515 Insert Count::1 ### Delete Count::0
7/18/2021 2:30:05 AM : Import AD File --->> AD_515_20210718_7a39823be88181bb65fe6e9b1151528a.TXT ### 7/18/2021 2:30:05 AM
7/18/2021 2:30:05 AM : For Distributor 000000000000715 Insert Count::1 ### Delete Count::0
7/18/2021 2:30:05 AM : Import AD File --->> AD_715_20210717_3f156aa1ed133fd362b5e8f406f6718f.TXT ### 7/18/2021 2:30:05 AM
7/18/2021 2:30:21 AM : For Distributor 000000000001191 Insert Count::1 ### Delete Count::0
7/18/2021 2:30:21 AM : Import IN File --->> IN_1191_20210612_f8cd00ca93ddd0025215f73e9f366e86.TXT ### 7/18/2021 2:30:21 AM
7/18/2021 2:30:22 AM : For Distributor 000000000001191 Insert Count::0 ### Delete Count::1
7/18/2021 2:30:22 AM : Import IN File --->> IN_1191_20210617_93357c1b678b426476004c6f9709c6ba.TXT ### 7/18/2021 2:30:22 AM
7/18/2021 2:30:24 AM : For Distributor 000000000001191 Insert Count::1 ### Delete Count::0
7/18/2021 2:30:24 AM : Import IN File --->> IN_1191_20210712_ef9aca54a40df57e87b28322d0e808ea.TXT ### 7/18/2021 2:30:24 AM
7/18/2021 2:30:24 AM : For Distributor 000000000001191 Insert Count::7 ### Delete Count::0
7/18/2021 2:30:24 AM : Import IN File --->> IN_1191_20210717_ee86458c892c7f4bf713eb1de6b46582.TXT ### 7/18/2021 2:30:24 AM
7/18/2021 2:30:27 AM : For Distributor 000000000000515 Insert Count::1 ### Delete Count::1
7/18/2021 2:30:27 AM : Import IN File --->> IN_515_20210710_2e33abca09dd3ce064e89c56f7fa167b.TXT ### 7/18/2021 2:30:27 AM
7/18/2021 2:30:27 AM : For Distributor 000000000000515 Insert Count::14 ### Delete Count::0
7/18/2021 2:30:27 AM : Import IN File --->> IN_515_20210717_b97d36ce53d29971b98222317c7bc584.TXT ### 7/18/2021 2:30:27 AM
7/18/2021 2:30:30 AM : For Distributor 000000000000715 Insert Count::8 ### Delete Count::0
7/18/2021 2:30:30 AM : Import IN File --->> IN_715_20210717_ef603bf21171688e47c83ac3848b7914.TXT ### 7/18/2021 2:30:30 AM
7/18/2021 2:30:31 AM : PostData() --->>  ### 7/18/2021 2:30:31 AM
7/18/2021 2:30:31 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 7/18/2021 2:30:31 AM
7/18/2021 2:30:33 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '18/Jul/2021' ### 7/18/2021 2:30:33 AM
7/18/2021 2:30:33 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '18/Jul/2021' ### 7/18/2021 2:30:33 AM
7/18/2021 2:30:33 AM :  ### 
7/18/2021 2:30:33 AM : UNLINKEDSALES Record Count Before --->> 32 ### 7/18/2021 2:30:33 AM
7/18/2021 2:30:33 AM : UNLINKEDSALES_DEL Record Count Before --->> 2 ### 7/18/2021 2:30:33 AM
7/18/2021 2:30:41 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '18/Jul/2021' ### 7/18/2021 2:30:41 AM
7/18/2021 2:30:41 AM : UNLINKEDSALES Record Count After --->> 0 ### 7/18/2021 2:30:41 AM
7/18/2021 2:30:41 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 7/18/2021 2:30:41 AM
7/18/2021 2:30:41 AM :  ### 
7/18/2021 2:30:41 AM : Posting Supplierlink Query for Purchases --->>  ### 7/18/2021 2:30:41 AM
7/18/2021 2:30:47 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '18/Jul/2021' ### 7/18/2021 2:30:47 AM
7/18/2021 2:30:53 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '18/Jul/2021' ### 7/18/2021 2:30:53 AM
7/18/2021 2:30:53 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 7/18/2021 2:30:53 AM
7/18/2021 2:30:53 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '18/Jul/2021' ### 7/18/2021 2:30:53 AM
7/18/2021 2:30:53 AM : Posting ClosingStock Successful --->>  ### 7/18/2021 2:30:53 AM
7/18/2021 2:30:53 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 7/18/2021 2:30:53 AM
7/18/2021 2:30:53 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
7/18/2021 2:30:53 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 7/18/2021 2:30:53 AM
7/18/2021 2:30:53 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:30:53 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 7/18/2021 2:30:53 AM
7/18/2021 2:30:53 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:30:53 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 7/18/2021 2:30:53 AM
7/18/2021 2:30:53 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:30:53 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 7/18/2021 2:30:53 AM
7/18/2021 2:30:53 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:30:53 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 7/18/2021 2:30:53 AM
7/18/2021 2:30:53 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:30:53 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 7/18/2021 2:30:53 AM
7/18/2021 2:30:53 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:30:53 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 7/18/2021 2:30:53 AM
7/18/2021 2:30:53 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:30:53 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 7/18/2021 2:30:53 AM
7/18/2021 2:30:53 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:30:53 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 7/18/2021 2:30:53 AM
7/18/2021 2:30:53 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:30:53 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_756908_TEMPLATE1.txt ### 7/18/2021 2:30:53 AM
7/18/2021 2:30:54 AM : Count:: ### TEMPLATE1:110
7/18/2021 2:30:58 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 2:30:58 AM
7/18/2021 2:30:58 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 7/18/2021 2:30:58 AM
7/18/2021 2:30:58 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:30:58 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061006_TEMPLATE1.TXT ### 7/18/2021 2:30:58 AM
7/18/2021 2:30:58 AM : Count:: ### TEMPLATE1:39
7/18/2021 2:31:03 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 2:31:03 AM
7/18/2021 2:31:03 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 7/18/2021 2:31:03 AM
7/18/2021 2:31:03 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:31:03 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 7/18/2021 2:31:03 AM
7/18/2021 2:31:03 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:31:03 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063167_TEMPLATE1.TXT ### 7/18/2021 2:31:03 AM
7/18/2021 2:31:03 AM : Count:: ### TEMPLATE1:43
7/18/2021 2:31:08 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 2:31:08 AM
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Ajay Traders Sirigiripadu","Ajay Traders Sirigiripadu","Ajay Traders Sirigiripadu","Sirigiripadu|37AJGPV4454J1ZN|","Sirigiripadu","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Anjaniputhra Traders Macherla","Anjaniputhra Traders Macherla","Anjaniputhra Traders Macherla","Macherla|37BBTPP4318M1ZV|","Macherla","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Ayyappa Fertilisers Uppalapadu","Ayyappa Fertilisers Uppalapadu","Ayyappa Fertilisers Uppalapadu","Uppalapadu|37BIHPM3004J1ZC|","Uppalapadu","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Balaji Agro Chemicals Adigoppala","Balaji Agro Chemicals Adigoppala","Balaji Agro Chemicals Adigoppala","Adigoppala|37BVQPR7511F1Z5|","Adigoppala","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Balaji Fertilisers Kandlakunta","Balaji Fertilisers Kandlakunta","Balaji Fertilisers Kandlakunta","Kandlakunta|37AZAPM0794Q1ZP|","Kandlakunta","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Bhagya Vara Lakshmi Frtilisers Nagulavaram","Bhagya Vara Lakshmi Frtilisers Nagulavaram","Bhagya Vara Lakshmi Frtilisers Nagulavaram","Nagulavaram|37CMWPM0260L1ZG|","Nagulavaram","0","0","9","0","9","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Chintapalli Mastan Pinnelli","Chintapalli Mastan Pinnelli","Chintapalli Mastan Pinnelli","Pinnelli||","Pinnelli","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Chinthapalli Sai Sannidhi Agencies Koppunuru","Chinthapalli Sai Sannidhi Agencies Koppunuru","Chinthapalli Sai Sannidhi Agencies Koppunuru","Koppunuru|37AUWPC4295R1ZH|","Koppunuru","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Gayathri Agro Chemicals Adigoppala","Gayathri Agro Chemicals Adigoppala","Gayathri Agro Chemicals Adigoppala","Adigoppala|37AYKPB2662D1ZO|","Adigoppala","0","0","9","0","9","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Gopala Krishna Fertilisers Oppicherla","Gopala Krishna Fertilisers Oppicherla","Gopala Krishna Fertilisers Oppicherla","Oppicherla|37AXQPC9431J1Z1|","Oppicherla","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Lakshmi Balaji Agencies Kothapalli","Lakshmi Balaji Agencies Kothapalli","Lakshmi Balaji Agencies Kothapalli","Kothapalli|37AAUPO3382P1ZM|","Kothapalli","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Lakshmi Ganapathi Agencies Kothapalli","Lakshmi Ganapathi Agencies Kothapalli","Lakshmi Ganapathi Agencies Kothapalli","Kothapalli|37ANUPD4918M1ZC|","Kothapalli","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Lakshmi Ganapathi Traders Rayavaram","Lakshmi Ganapathi Traders Rayavaram","Lakshmi Ganapathi Traders Rayavaram","Rayavaram|37AUOPG8163E2ZC|","Rayavaram","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Lakshmi Siva Malleswari Traders Oppicherla","Lakshmi Siva Malleswari Traders Oppicherla","Lakshmi Siva Malleswari Traders Oppicherla","Oppicherla|37AAIFL7689J1ZG|","Oppicherla","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Lakshmi Srinivasa Traders Bodilaveedu","Lakshmi Srinivasa Traders Bodilaveedu","Lakshmi Srinivasa Traders Bodilaveedu","Bodilaveedu|37AEMPA6703L1ZD|","Bodilaveedu","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Madhavi Agro Agencies Nagulavaram","Madhavi Agro Agencies Nagulavaram","Madhavi Agro Agencies Nagulavaram","Nagulavaram|37ARWPA7883N1ZP|","Nagulavaram","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Mallikarjuna Agro Chemicals Durgi","Mallikarjuna Agro Chemicals Durgi","Mallikarjuna Agro Chemicals Durgi","Durgi|37AALFM4660R1ZF|","Durgi","0","0","9","0","9","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Manisha Fertilisers Koppunuru","Manisha Fertilisers Koppunuru","Manisha Fertilisers Koppunuru","Koppunuru|37DDJPM2796G1Z1|","Koppunuru","0","0","9","0","9","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Nataraja Traders Jammalamadaka","Nataraja Traders Jammalamadaka","Nataraja Traders Jammalamadaka","Jammalamadaka|37AVDPD3540J1ZR|","Jammalamadaka","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Nelluri Laksmaiah Adigoppala","Nelluri Laksmaiah Adigoppala","Nelluri Laksmaiah Adigoppala","Adigoppala||","Adigoppala","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Pavan Sai Agencies Uppalapadu","Pavan Sai Agencies Uppalapadu","Pavan Sai Agencies Uppalapadu","Uppalapadu|37BCPPG3544P1ZY|","Uppalapadu","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Potla Hanumanthu Gurajala","Potla Hanumanthu Gurajala","Potla Hanumanthu Gurajala","Gurajala||","Gurajala","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Raveendra Fertilisers Jammalamadaka","Raveendra Fertilisers Jammalamadaka","Raveendra Fertilisers Jammalamadaka","Jammalamadaka|37AOPPG6379H1ZC|","Jammalamadaka","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Rythumithra Agro Agencies Durgi","Rythumithra Agro Agencies Durgi","Rythumithra Agro Agencies Durgi","Durgi|37APFPK4345C1Z4|","Durgi","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sai Fertilisers Dharmavaram","Sai Fertilisers Dharmavaram","Sai Fertilisers Dharmavaram","Dharmavaram|37AVCPV6541L1ZZ|","Dharmavaram","0","0","9","0","9","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sai Gayathri Agencies Uppalapadu","Sai Gayathri Agencies Uppalapadu","Sai Gayathri Agencies Uppalapadu","Uppalapadu|37ASKPD3127H1ZW|","Uppalapadu","0","0","7","0","7","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sambasiva Fertilisers Adigoppala","Sambasiva Fertilisers Adigoppala","Sambasiva Fertilisers Adigoppala","Adigoppala|37AYKPC4217H1ZK|","Adigoppala","0","0","9","0","9","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Seetha Ramanjaneya Traders Oppicherla","Seetha Ramanjaneya Traders Oppicherla","Seetha Ramanjaneya Traders Oppicherla","Oppicherla|37AMFPC9093A1Z7|","Oppicherla","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Shiridi Sai Agencies Bodilaveedu","Shiridi Sai Agencies Bodilaveedu","Shiridi Sai Agencies Bodilaveedu","Bodilaveedu|37AIZPV5505C1ZR|","Bodilaveedu","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Shiva Sai Venkateswara Fertilizers Atmakuru","Shiva Sai Venkateswara Fertilizers Atmakuru","Shiva Sai Venkateswara Fertilizers Atmakuru","Atmakuru|37NZFPS2010R1ZM|","Atmakuru","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Anjaneya Traders Uppalapadu","Sri Anjaneya Traders Uppalapadu","Sri Anjaneya Traders Uppalapadu","Uppalapadu|37CFIPB4788P1ZN|","Uppalapadu","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Balaji Tirupathamma Traders Rayavaram","Sri Balaji Tirupathamma Traders Rayavaram","Sri Balaji Tirupathamma Traders Rayavaram","Rayavaram|37AZXPG8162D1ZX|","Rayavaram","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Balaji Traders Adigoppala","Sri Balaji Traders Adigoppala","Sri Balaji Traders Adigoppala","Adigoppala|37AMFPG3261Q1ZO|","Adigoppala","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Dhana Lakshmi Trading Company Piduguralla","Sri Dhana Lakshmi Trading Company Piduguralla","Sri Dhana Lakshmi Trading Company Piduguralla","Piduguralla|37AAIFS3169G1ZX|","Piduguralla","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Dhana Malleswara Fertilisers Oppicherla","Sri Dhana Malleswara Fertilisers Oppicherla","Sri Dhana Malleswara Fertilisers Oppicherla","Oppicherla|37AOMPC7826A1Z3|","Oppicherla","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Hanuman Agencies Mittameedapalle","Sri Hanuman Agencies Mittameedapalle","Sri Hanuman Agencies Mittameedapalle","Mittameedapalle|37DITPK3420C1ZB|","Mittameedapalle","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Hanuman Traders Atmakuru","Sri Hanuman Traders Atmakuru","Sri Hanuman Traders Atmakuru","Atmakuru|37AXDPB7837J1Z9|","Atmakuru","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Krishna Sai Traders Uppalapadu","Sri Krishna Sai Traders Uppalapadu","Sri Krishna Sai Traders Uppalapadu","Uppalapadu|37BJMPK3784K1ZI|","Uppalapadu","0","0","9","0","9","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Lakshmi Narasimha Traders Durgi","Sri Lakshmi Narasimha Traders Durgi","Sri Lakshmi Narasimha Traders Durgi","Durgi|37AKWPM2209F1ZY|","Durgi","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Lakshmi Narasimha Traders Macherla","Sri Lakshmi Narasimha Traders Macherla","Sri Lakshmi Narasimha Traders Macherla","Macherla|37CAAPG3077R1Z8|","Macherla","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Lakshmi Srinivasa Chemicals Mutukuru","Sri Lakshmi Srinivasa Chemicals Mutukuru","Sri Lakshmi Srinivasa Chemicals Mutukuru","Mutukuru|37AFUPL5804J1ZW|","Mutukuru","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Lakshmi Srinivasa Fertilisers Mutukuru","Sri Lakshmi Srinivasa Fertilisers Mutukuru","Sri Lakshmi Srinivasa Fertilisers Mutukuru","Mutukuru|37AZBPG1551A1Z2|","Mutukuru","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Lakshmi Traders Mittameedapalle","Sri Lakshmi Traders Mittameedapalle","Sri Lakshmi Traders Mittameedapalle","Mittameedapalle|37BGSPM7103F1Z7|","Mittameedapalle","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Lakshmi Venkateswara Agencies S.b.palem","Sri Lakshmi Venkateswara Agencies S.b.palem","Sri Lakshmi Venkateswara Agencies S.b.palem","S.b.palem|37ARGPB3192B1Z7|","S.b.palem","0","0","9","0","9","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Mallikarjuna Traders Adigoppala","Sri Mallikarjuna Traders Adigoppala","Sri Mallikarjuna Traders Adigoppala","Adigoppala|37BEDPB3951H1ZP|","Adigoppala","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Mallikarjuna Traders Kothapalli","Sri Mallikarjuna Traders Kothapalli","Sri Mallikarjuna Traders Kothapalli","Kothapalli|37AKFPT4487K1ZD|","Kothapalli","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Mallikarjuna Traders Oppicherla","Sri Mallikarjuna Traders Oppicherla","Sri Mallikarjuna Traders Oppicherla","Oppicherla|37BIWPK7464F1ZK|","Oppicherla","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Manikanta Fertilisers O.b.palle","Sri Manikanta Fertilisers O.b.palle","Sri Manikanta Fertilisers O.b.palle","O.b.palle|37AHWPC1698M1ZH|","O.b.palle","0","0","9","0","9","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Raja Sekhara Traders Kothapalli","Sri Raja Sekhara Traders Kothapalli","Sri Raja Sekhara Traders Kothapalli","Kothapalli|37ABTPO6162F1Z6|","Kothapalli","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Sai Manikanta Fertilisers Oppicherla","Sri Sai Manikanta Fertilisers Oppicherla","Sri Sai Manikanta Fertilisers Oppicherla","Oppicherla|37AWSPC4198B1ZC|","Oppicherla","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Sai Prasanna Trders Mutukuru","Sri Sai Prasanna Trders Mutukuru","Sri Sai Prasanna Trders Mutukuru","Mutukuru|37AVTPT1949F1ZV|","Mutukuru","0","0","9","0","9","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Sai Raghavendra Traders Macherla","Sri Sai Raghavendra Traders Macherla","Sri Sai Raghavendra Traders Macherla","Macherla|37ALQPM6953R1ZU|","Macherla","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Sai Ram Agencies Mutukuru","Sri Sai Ram Agencies Mutukuru","Sri Sai Ram Agencies Mutukuru","Mutukuru|37AMXPL2729G1ZJ|","Mutukuru","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Sai Siva Traders S.b.palem","Sri Sai Siva Traders S.b.palem","Sri Sai Siva Traders S.b.palem","S.b.palem|37AQLPB8608E1ZV|","S.b.palem","0","0","9","0","9","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Sathyanarayana Traders Sirigiripadu","Sri Sathyanarayana Traders Sirigiripadu","Sri Sathyanarayana Traders Sirigiripadu","Sirigiripadu|37AKBPG3682K1ZZ|","Sirigiripadu","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Seetharama Traders Sirigiripadu","Sri Seetharama Traders Sirigiripadu","Sri Seetharama Traders Sirigiripadu","Sirigiripadu|37GRWPK4348Q1ZH|","Sirigiripadu","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Siva Sai Fertilisers Adigoppala","Sri Siva Sai Fertilisers Adigoppala","Sri Siva Sai Fertilisers Adigoppala","Adigoppala|37AIMPV4679G1ZF|","Adigoppala","0","0","9","0","9","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Siva Sankara Traders Atmakuru","Sri Siva Sankara Traders Atmakuru","Sri Siva Sankara Traders Atmakuru","Atmakuru|37AEDPV1367E1ZE|","Atmakuru","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Srinivasa Seeds & Pesticides Macherla","Sri Srinivasa Seeds & Pesticides Macherla","Sri Srinivasa Seeds & Pesticides Macherla","Macherla|37BERPK3356M1ZS|","Macherla","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Umasankar Traders Durgi","Sri Umasankar Traders Durgi","Sri Umasankar Traders Durgi","Durgi|37ARLPG6006A1Z8|","Durgi","0","0","8","0","8","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Veerajaneya Traders Macherla","Sri Veerajaneya Traders Macherla","Sri Veerajaneya Traders Macherla","Macherla|37AIEPV3032B1ZK|","Macherla","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Venkata Nagalakshmi Traders Gundlapadu","Sri Venkata Nagalakshmi Traders Gundlapadu","Sri Venkata Nagalakshmi Traders Gundlapadu","Gundlapadu|37CLLPS5465D2ZM|","Gundlapadu","0","0","9","0","9","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Venkata Sai Samba Siva Traders Oppicherla","Sri Venkata Sai Samba Siva Traders Oppicherla","Sri Venkata Sai Samba Siva Traders Oppicherla","Oppicherla|37BHYPK5350H1ZS|","Oppicherla","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Venkata Sailakshmi Traders Macherla","Sri Venkata Sailakshmi Traders Macherla","Sri Venkata Sailakshmi Traders Macherla","Macherla|37AATPY3376L1ZJ|","Macherla","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Venkateswara Agencie Patlaveedu","Sri Venkateswara Agencie Patlaveedu","Sri Venkateswara Agencie Patlaveedu","Patlaveedu|37BBLPC4928A1ZX|","Patlaveedu","0","0","9","0","9","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Vijaya Mahalakshmi Agencies Kothapalli","Sri Vijaya Mahalakshmi Agencies Kothapalli","Sri Vijaya Mahalakshmi Agencies Kothapalli","Kothapalli|37BIAPD1926M1ZB|","Kothapalli","0","0","9","0","9","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Srinivasa Agro Traders Uppalapadu","Srinivasa Agro Traders Uppalapadu","Srinivasa Agro Traders Uppalapadu","Uppalapadu|37BYKPS4975H1ZM|","Uppalapadu","0","0","9","0","9","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Umamaheswara Agency Mutukuru","Umamaheswara Agency Mutukuru","Umamaheswara Agency Mutukuru","Mutukuru|37AIAPL3086B2ZJ|","Mutukuru","0","0","9","0","9","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Veeranjaneya Agencies Sirigiripadu","Veeranjaneya Agencies Sirigiripadu","Veeranjaneya Agencies Sirigiripadu","Sirigiripadu|37AZYPJ0749C2Z1|","Sirigiripadu","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Veeranjaneya Fertilisers Oppicherla","Veeranjaneya Fertilisers Oppicherla","Veeranjaneya Fertilisers Oppicherla","Oppicherla|37GFVPS5990R1ZN|","Oppicherla","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Venkata Rama Traders Adigoppala","Venkata Rama Traders Adigoppala","Venkata Rama Traders Adigoppala","Adigoppala|37AHQPG1702J1ZC|","Adigoppala","0","0","9","0","9","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Vigneswara Fertilisers Adigoppala","Vigneswara Fertilisers Adigoppala","Vigneswara Fertilisers Adigoppala","Adigoppala|37BEIPK6778Q1ZD|","Adigoppala","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Vinayaka Fertilisers Oppicherla","Vinayaka Fertilisers Oppicherla","Vinayaka Fertilisers Oppicherla","Oppicherla|37ANLPB0416H1ZD|","Oppicherla","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Vyshnavi Fertlizers Veldurthy","Vyshnavi Fertlizers Veldurthy","Vyshnavi Fertlizers Veldurthy","Veldurthy|37AMWPC4370M1ZF|","Veldurthy","0","0","9","0","9","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Bayer Crop Science Ltd Guntur","Bayer Crop Science Ltd Guntur","Bayer Crop Science Ltd Guntur","Guntur|37AAACB9651K1ZC|","Guntur","0","0","","0","","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Error in file  ### TEMPLATE1 at Line 000000000000515","Sri Sairama Corporation Dachepalli","Sri Sairama Corporation Dachepalli","Sri Sairama Corporation Dachepalli","Dachepalli|37AAIFS2846Q1ZE|","Dachepalli","0","0","0","0","0","0","0
7/18/2021 2:31:08 AM : Exception  ### Input array is longer than the number of columns in this table.
7/18/2021 2:31:08 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 7/18/2021 2:31:08 AM
7/18/2021 2:31:08 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:31:08 AM : Template Import Complete  ### 7/18/2021 2:31:08 AM
7/18/2021 2:31:10 AM : Completed Updating Has Transaction Flag  ### 7/18/2021 2:31:10 AM
7/18/2021 2:31:10 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 7/18/2021 2:31:10 AM
7/18/2021 2:31:10 AM : Zylem Access Unblocked  ### 7/18/2021 2:31:10 AM
7/18/2021 2:31:10 AM : Application Ended  ### 7/18/2021 2:31:10 AM

7/18/2021 7:30:01 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
7/18/2021 7:30:02 AM : StartProcess  ### 7/18/2021 7:30:02 AM

7/18/2021 7:30:02 AM : 11  ### 7/18/2021 7:30:02 AM

7/18/2021 7:30:02 AM : 22  ### 7/18/2021 7:30:02 AM

7/18/2021 7:30:02 AM : 33  ### 7/18/2021 7:30:02 AM

7/18/2021 7:30:02 AM : Application Started  ### 7/18/2021 7:30:02 AM

7/18/2021 7:30:02 AM : Start Process : checkAllTablesExists()  ### 
7/18/2021 7:30:02 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 7/18/2021 7:30:02 AM
7/18/2021 7:30:02 AM : MainForm_Load  ### AlertSystem ON
7/18/2021 7:30:02 AM : No. of Files to import (RECEIVEFINAL):  ### 2336
7/18/2021 7:30:02 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
7/18/2021 7:30:03 AM : For Distributor 000000000001165 Insert Count::3 ### Delete Count::2
7/18/2021 7:30:03 AM : Import AD File --->> AD_1165_20210718_effb0c3b89d715c964050a79bba5787e.TXT ### 7/18/2021 7:30:03 AM
7/18/2021 7:30:03 AM : For Distributor 000000000000411 Insert Count::1 ### Delete Count::0
7/18/2021 7:30:03 AM : Import AD File --->> AD_411_20210718_5eabfe0d54aa827aa3a5b60ad5304000.TXT ### 7/18/2021 7:30:03 AM
7/18/2021 7:30:03 AM : For Distributor 000000000000041 Insert Count::1 ### Delete Count::1
7/18/2021 7:30:03 AM : Import AD File --->> AD_41_20210718_c36ac50319c91436bcf072b0c5acca11.TXT ### 7/18/2021 7:30:03 AM
7/18/2021 7:30:04 AM : Exception  ### Index was outside the bounds of the array.
7/18/2021 7:30:04 AM : Error ### Index was outside the bounds of the array. Line 
7/18/2021 7:30:04 AM : For Distributor 000000000000913 Insert Count::0 ### Delete Count::86
7/18/2021 7:30:04 AM : Import AD File --->> AD_913_20210718_0bb8be822acb0b36a8baf4d1e0737d1d.TXT ### 7/18/2021 7:30:04 AM
7/18/2021 7:30:18 AM : For Distributor 000000000001171 Insert Count::2 ### Delete Count::0
7/18/2021 7:30:18 AM : Import DN File --->> DN_1171_20210717_836adf9900d24083d59dadd217c79daa.TXT ### 7/18/2021 7:30:18 AM
7/18/2021 7:30:33 AM : Import DN File --->> DN_431_20210610_e317fafbf799bf4823d9747ba3318685.TXT ### 7/18/2021 7:30:33 AM
7/18/2021 7:30:33 AM : NO Previous File For Distributor 000000000000431 ### Insert Count::3
7/18/2021 7:30:33 AM : Import DN File --->> DN_431_20210615_e328e5cbbd634e51670a2ab581789e45.TXT ### 7/18/2021 7:30:33 AM
7/18/2021 7:30:33 AM : NO Previous File For Distributor 000000000000431 ### Insert Count::7
7/18/2021 7:30:33 AM : Import DN File --->> DN_431_20210616_a93029c0b34b5c3ca70d21b4734ca436.TXT ### 7/18/2021 7:30:33 AM
7/18/2021 7:30:33 AM : NO Previous File For Distributor 000000000000431 ### Insert Count::1
7/18/2021 7:30:35 AM : Import DN File --->> DN_431_20210710_e5e26f9dfa5042649aad653215bd2e90.TXT ### 7/18/2021 7:30:35 AM
7/18/2021 7:30:35 AM : NO Previous File For Distributor 000000000000431 ### Insert Count::1
7/18/2021 7:31:17 AM : For Distributor 000000000000909 Insert Count::3 ### Delete Count::0
7/18/2021 7:31:17 AM : Import DN File --->> DN_909_20210526_400a4a39efa8e447014b7617fac4fbc2.TXT ### 7/18/2021 7:31:17 AM
7/18/2021 7:31:19 AM : For Distributor 000000000000909 Insert Count::1 ### Delete Count::0
7/18/2021 7:31:19 AM : Import DN File --->> DN_909_20210623_10f6ae3aa6adcdef84e2e9db8455daac.TXT ### 7/18/2021 7:31:19 AM
7/18/2021 7:31:19 AM : For Distributor 000000000000909 Insert Count::1 ### Delete Count::0
7/18/2021 7:31:19 AM : Import DN File --->> DN_909_20210624_f4fc4b611b08857131efd7cefa9a64ff.TXT ### 7/18/2021 7:31:19 AM
7/18/2021 7:31:19 AM : For Distributor 000000000000909 Insert Count::2 ### Delete Count::0
7/18/2021 7:31:19 AM : Import DN File --->> DN_909_20210625_0226a4d4b90d67aa65767fac920605ff.TXT ### 7/18/2021 7:31:19 AM
7/18/2021 7:31:20 AM : For Distributor 000000000000909 Insert Count::3 ### Delete Count::0
7/18/2021 7:31:20 AM : Import DN File --->> DN_909_20210626_1fb3a8e1d1ac13d7be307f1aa1b1ae22.TXT ### 7/18/2021 7:31:20 AM
7/18/2021 7:31:21 AM : Import DN File --->> DN_909_20210711_98da7cc50d36932723c74e172c9715d8.TXT ### 7/18/2021 7:31:21 AM
7/18/2021 7:31:21 AM : NO Previous File For Distributor 000000000000909 ### Insert Count::1
7/18/2021 7:31:28 AM : For Distributor 000000000001026 Insert Count::3 ### Delete Count::0
7/18/2021 7:31:28 AM : Import IN File --->> IN_1026_20210717_8edcde826a21eff9f29ba50fc7ea294e.TXT ### 7/18/2021 7:31:28 AM
7/18/2021 7:31:31 AM : For Distributor 000000000001165 Insert Count::1 ### Delete Count::1
7/18/2021 7:31:31 AM : Import IN File --->> IN_1165_20210706_63da2fb85dd1eb92ac276aee86621908.TXT ### 7/18/2021 7:31:31 AM
7/18/2021 7:31:31 AM : For Distributor 000000000001165 Insert Count::31 ### Delete Count::0
7/18/2021 7:31:31 AM : Import IN File --->> IN_1165_20210715_daa196d59705e6e0e857ba2708e161a9.TXT ### 7/18/2021 7:31:31 AM
7/18/2021 7:31:31 AM : Import IN File --->> IN_1165_20210716_af887b47dac75b6f0561cd0d272ecee9.TXT ### 7/18/2021 7:31:31 AM
7/18/2021 7:31:31 AM : NO Previous File For Distributor 000000000001165 ### Insert Count::17
7/18/2021 7:31:31 AM : Import IN File --->> IN_1165_20210717_89fd1b34622989dc7648f31d15961b48.TXT ### 7/18/2021 7:31:31 AM
7/18/2021 7:31:31 AM : NO Previous File For Distributor 000000000001165 ### Insert Count::12
7/18/2021 7:31:35 AM : For Distributor 000000000001171 Insert Count::6 ### Delete Count::0
7/18/2021 7:31:35 AM : Import IN File --->> IN_1171_20210716_2c26f7b94837a23222eded5c6705f9a3.TXT ### 7/18/2021 7:31:35 AM
7/18/2021 7:31:35 AM : For Distributor 000000000001171 Insert Count::17 ### Delete Count::0
7/18/2021 7:31:35 AM : Import IN File --->> IN_1171_20210717_8edd9438fc6ea03ffd3ea4b08999a0a6.TXT ### 7/18/2021 7:31:35 AM
7/18/2021 7:31:39 AM : For Distributor 000000000000400 Insert Count::2 ### Delete Count::0
7/18/2021 7:31:39 AM : Import IN File --->> IN_400_20210717_075b2accc5bd60b87b0444d347fa5600.TXT ### 7/18/2021 7:31:39 AM
7/18/2021 7:31:42 AM : For Distributor 000000000000405 Insert Count::2 ### Delete Count::0
7/18/2021 7:31:42 AM : Import IN File --->> IN_405_20210715_4ccd2b7597d334c89022dc063b134199.TXT ### 7/18/2021 7:31:42 AM
7/18/2021 7:31:42 AM : For Distributor 000000000000405 Insert Count::1 ### Delete Count::0
7/18/2021 7:31:42 AM : Import IN File --->> IN_405_20210716_5f907bfc9dcc21145f7e9fc8dc4b869a.TXT ### 7/18/2021 7:31:42 AM
7/18/2021 7:31:45 AM : Import IN File --->> IN_411_20210717_0312395b3eee837b1c983e48740a4a43.TXT ### 7/18/2021 7:31:45 AM
7/18/2021 7:31:45 AM : NO Previous File For Distributor 000000000000411 ### Insert Count::2
7/18/2021 7:31:45 AM : For Distributor 000000000000431 Insert Count::1 ### Delete Count::0
7/18/2021 7:31:45 AM : Import IN File --->> IN_431_20210601_2b6be36e1dd31cce722c7c7484159bf8.TXT ### 7/18/2021 7:31:45 AM
7/18/2021 7:31:45 AM : For Distributor 000000000000431 Insert Count::2 ### Delete Count::0
7/18/2021 7:31:45 AM : Import IN File --->> IN_431_20210604_612402869bdd69b862f4eca480d96530.TXT ### 7/18/2021 7:31:45 AM
7/18/2021 7:31:46 AM : For Distributor 000000000000431 Insert Count::28 ### Delete Count::0
7/18/2021 7:31:46 AM : Import IN File --->> IN_431_20210611_891b2938049dfd972d9067629494addf.TXT ### 7/18/2021 7:31:46 AM
7/18/2021 7:31:46 AM : Import IN File --->> IN_431_20210612_5525b5f00f320166ff0b2ecfa9cecf93.TXT ### 7/18/2021 7:31:46 AM
7/18/2021 7:31:46 AM : NO Previous File For Distributor 000000000000431 ### Insert Count::6
7/18/2021 7:31:46 AM : Import IN File --->> IN_431_20210615_3a7f1ec6a1da4997a98ad8ed9fbedeb4.TXT ### 7/18/2021 7:31:46 AM
7/18/2021 7:31:46 AM : NO Previous File For Distributor 000000000000431 ### Insert Count::9
7/18/2021 7:31:46 AM : Import IN File --->> IN_431_20210616_5324297f0e998b0f58d044d0803a04d6.TXT ### 7/18/2021 7:31:46 AM
7/18/2021 7:31:46 AM : NO Previous File For Distributor 000000000000431 ### Insert Count::4
7/18/2021 7:31:46 AM : Import IN File --->> IN_431_20210617_ba6ea3c728a7f538089cb19236c563fc.TXT ### 7/18/2021 7:31:46 AM
7/18/2021 7:31:46 AM : NO Previous File For Distributor 000000000000431 ### Insert Count::12
7/18/2021 7:31:46 AM : Import IN File --->> IN_431_20210618_a3f8356fbb5ec4246142e8102446055a.TXT ### 7/18/2021 7:31:46 AM
7/18/2021 7:31:46 AM : NO Previous File For Distributor 000000000000431 ### Insert Count::1
7/18/2021 7:31:46 AM : Import IN File --->> IN_431_20210619_111ce78b4ba35dc7f81d65dc48c1a3b0.TXT ### 7/18/2021 7:31:46 AM
7/18/2021 7:31:46 AM : NO Previous File For Distributor 000000000000431 ### Insert Count::3
7/18/2021 7:31:47 AM : Import IN File --->> IN_431_20210621_8510785d4519af95a938b10beaf52435.TXT ### 7/18/2021 7:31:47 AM
7/18/2021 7:31:47 AM : NO Previous File For Distributor 000000000000431 ### Insert Count::1
7/18/2021 7:31:47 AM : Import IN File --->> IN_431_20210622_a45c6998f0eb1e34503a48f17564fec6.TXT ### 7/18/2021 7:31:47 AM
7/18/2021 7:31:47 AM : NO Previous File For Distributor 000000000000431 ### Insert Count::1
7/18/2021 7:31:47 AM : Import IN File --->> IN_431_20210624_4e1552f703180ef1e62c9949f22cfb7a.TXT ### 7/18/2021 7:31:47 AM
7/18/2021 7:31:47 AM : NO Previous File For Distributor 000000000000431 ### Insert Count::1
7/18/2021 7:31:47 AM : Import IN File --->> IN_431_20210625_31d4726d9506d66d24153f3542f7fa19.TXT ### 7/18/2021 7:31:47 AM
7/18/2021 7:31:47 AM : NO Previous File For Distributor 000000000000431 ### Insert Count::1
7/18/2021 7:31:47 AM : Import IN File --->> IN_431_20210627_5d65b878f689d8b360d7ec3fa22614f9.TXT ### 7/18/2021 7:31:47 AM
7/18/2021 7:31:47 AM : NO Previous File For Distributor 000000000000431 ### Insert Count::4
7/18/2021 7:31:47 AM : Import IN File --->> IN_431_20210628_08610112c375ad7fbf14092003e45960.TXT ### 7/18/2021 7:31:47 AM
7/18/2021 7:31:47 AM : NO Previous File For Distributor 000000000000431 ### Insert Count::1
7/18/2021 7:31:47 AM : Import IN File --->> IN_431_20210629_a37b427c4b85f6020adf98a2d3fdc999.TXT ### 7/18/2021 7:31:47 AM
7/18/2021 7:31:47 AM : NO Previous File For Distributor 000000000000431 ### Insert Count::4
7/18/2021 7:31:47 AM : Import IN File --->> IN_431_20210630_41dbc7d0d30f3eb893f0e98c5981b07e.TXT ### 7/18/2021 7:31:47 AM
7/18/2021 7:31:47 AM : NO Previous File For Distributor 000000000000431 ### Insert Count::1
7/18/2021 7:31:47 AM : Import IN File --->> IN_431_20210701_ac13fe31f82149ae6a8fa68b9b282693.TXT ### 7/18/2021 7:31:47 AM
7/18/2021 7:31:47 AM : NO Previous File For Distributor 000000000000431 ### Insert Count::1
7/18/2021 7:31:47 AM : Import IN File --->> IN_431_20210702_bcedf65f70eae188509a6a3a667fc08a.TXT ### 7/18/2021 7:31:47 AM
7/18/2021 7:31:47 AM : NO Previous File For Distributor 000000000000431 ### Insert Count::1
7/18/2021 7:31:48 AM : Import IN File --->> IN_431_20210705_6447c99a9dd6a189870ed9674d0658b2.TXT ### 7/18/2021 7:31:48 AM
7/18/2021 7:31:48 AM : NO Previous File For Distributor 000000000000431 ### Insert Count::2
7/18/2021 7:31:48 AM : Import IN File --->> IN_431_20210706_3c6ceaf799ecd0a1e3cb717b131752c8.TXT ### 7/18/2021 7:31:48 AM
7/18/2021 7:31:48 AM : NO Previous File For Distributor 000000000000431 ### Insert Count::6
7/18/2021 7:31:48 AM : Import IN File --->> IN_431_20210707_4225f8837359b852101280c0375cfb40.TXT ### 7/18/2021 7:31:48 AM
7/18/2021 7:31:48 AM : NO Previous File For Distributor 000000000000431 ### Insert Count::1
7/18/2021 7:31:48 AM : Import IN File --->> IN_431_20210708_2c002c63628563acfa3e93a0ccf45184.TXT ### 7/18/2021 7:31:48 AM
7/18/2021 7:31:48 AM : NO Previous File For Distributor 000000000000431 ### Insert Count::1
7/18/2021 7:31:48 AM : Import IN File --->> IN_431_20210711_6b0e933a0f589d178c924aeb64091378.TXT ### 7/18/2021 7:31:48 AM
7/18/2021 7:31:48 AM : NO Previous File For Distributor 000000000000431 ### Insert Count::4
7/18/2021 7:32:02 AM : For Distributor 000000000000004 Insert Count::4 ### Delete Count::0
7/18/2021 7:32:02 AM : Import IN File --->> IN_4_20210715_3eaf33b5929dc2494f583cb982c048be.TXT ### 7/18/2021 7:32:02 AM
7/18/2021 7:32:02 AM : For Distributor 000000000000004 Insert Count::6 ### Delete Count::0
7/18/2021 7:32:02 AM : Import IN File --->> IN_4_20210716_447634a460ad77e67ec55a7671c25c85.TXT ### 7/18/2021 7:32:02 AM
7/18/2021 7:32:02 AM : Import IN File --->> IN_4_20210717_8d88917454ee33ad5f905123d4779f85.TXT ### 7/18/2021 7:32:02 AM
7/18/2021 7:32:02 AM : NO Previous File For Distributor 000000000000004 ### Insert Count::4
7/18/2021 7:32:06 AM : For Distributor 000000000000739 Insert Count::19 ### Delete Count::0
7/18/2021 7:32:06 AM : Import IN File --->> IN_739_20210717_b1c3b5ef21c14c4914bc65f3284c28f8.TXT ### 7/18/2021 7:32:06 AM
7/18/2021 7:32:31 AM : For Distributor 000000000000913 Insert Count::3 ### Delete Count::0
7/18/2021 7:32:31 AM : Import IN File --->> IN_913_20210601_7c81eebf816b515e93c87680bea95d87.TXT ### 7/18/2021 7:32:31 AM
7/18/2021 7:32:31 AM : For Distributor 000000000000913 Insert Count::7 ### Delete Count::1
7/18/2021 7:32:31 AM : Import IN File --->> IN_913_20210602_48b8489f5bc9445bf52ccf5e5e02e2ab.TXT ### 7/18/2021 7:32:31 AM
7/18/2021 7:32:32 AM : For Distributor 000000000000913 Insert Count::3 ### Delete Count::0
7/18/2021 7:32:32 AM : Import IN File --->> IN_913_20210603_7ae58c3fa33b4bcae0259ceb610fcb70.TXT ### 7/18/2021 7:32:32 AM
7/18/2021 7:32:32 AM : For Distributor 000000000000913 Insert Count::4 ### Delete Count::0
7/18/2021 7:32:32 AM : Import IN File --->> IN_913_20210604_104c7f5fabce5ced4c960213cf0e9802.TXT ### 7/18/2021 7:32:32 AM
7/18/2021 7:32:32 AM : For Distributor 000000000000913 Insert Count::5 ### Delete Count::0
7/18/2021 7:32:32 AM : Import IN File --->> IN_913_20210605_b45dfe68a773e114d908df831b6888f4.TXT ### 7/18/2021 7:32:32 AM
7/18/2021 7:32:32 AM : For Distributor 000000000000913 Insert Count::2 ### Delete Count::0
7/18/2021 7:32:32 AM : Import IN File --->> IN_913_20210606_525413a3d27efab7a20cf5971121dae7.TXT ### 7/18/2021 7:32:32 AM
7/18/2021 7:32:32 AM : For Distributor 000000000000913 Insert Count::5 ### Delete Count::1
7/18/2021 7:32:32 AM : Import IN File --->> IN_913_20210607_c9293b1d5b6d393751c24112ae6585d8.TXT ### 7/18/2021 7:32:32 AM
7/18/2021 7:32:32 AM : For Distributor 000000000000913 Insert Count::8 ### Delete Count::1
7/18/2021 7:32:32 AM : Import IN File --->> IN_913_20210608_4faa577df0979bbdefb640f7e77a0e55.TXT ### 7/18/2021 7:32:32 AM
7/18/2021 7:32:32 AM : For Distributor 000000000000913 Insert Count::6 ### Delete Count::2
7/18/2021 7:32:32 AM : Import IN File --->> IN_913_20210609_65dcc1142e93f376d4dc747ab4893aea.TXT ### 7/18/2021 7:32:32 AM
7/18/2021 7:32:33 AM : For Distributor 000000000000913 Insert Count::8 ### Delete Count::1
7/18/2021 7:32:33 AM : Import IN File --->> IN_913_20210610_884c829949539d325443eedcbd87dc17.TXT ### 7/18/2021 7:32:33 AM
7/18/2021 7:32:33 AM : For Distributor 000000000000913 Insert Count::0 ### Delete Count::4
7/18/2021 7:32:33 AM : Import IN File --->> IN_913_20210611_d41d8cd98f00b204e9800998ecf8427e.TXT ### 7/18/2021 7:32:33 AM
7/18/2021 7:32:33 AM : For Distributor 000000000000913 Insert Count::0 ### Delete Count::9
7/18/2021 7:32:33 AM : Import IN File --->> IN_913_20210612_d41d8cd98f00b204e9800998ecf8427e.TXT ### 7/18/2021 7:32:33 AM
7/18/2021 7:32:33 AM : For Distributor 000000000000913 Insert Count::0 ### Delete Count::3
7/18/2021 7:32:33 AM : Import IN File --->> IN_913_20210614_d41d8cd98f00b204e9800998ecf8427e.TXT ### 7/18/2021 7:32:33 AM
7/18/2021 7:32:33 AM : For Distributor 000000000000913 Insert Count::0 ### Delete Count::1
7/18/2021 7:32:33 AM : Import IN File --->> IN_913_20210615_d41d8cd98f00b204e9800998ecf8427e.TXT ### 7/18/2021 7:32:33 AM
7/18/2021 7:32:33 AM : For Distributor 000000000000913 Insert Count::0 ### Delete Count::4
7/18/2021 7:32:33 AM : Import IN File --->> IN_913_20210616_d41d8cd98f00b204e9800998ecf8427e.TXT ### 7/18/2021 7:32:33 AM
7/18/2021 7:32:34 AM : For Distributor 000000000000913 Insert Count::0 ### Delete Count::4
7/18/2021 7:32:34 AM : Import IN File --->> IN_913_20210617_d41d8cd98f00b204e9800998ecf8427e.TXT ### 7/18/2021 7:32:34 AM
7/18/2021 7:32:34 AM : For Distributor 000000000000913 Insert Count::0 ### Delete Count::12
7/18/2021 7:32:34 AM : Import IN File --->> IN_913_20210618_d41d8cd98f00b204e9800998ecf8427e.TXT ### 7/18/2021 7:32:34 AM
7/18/2021 7:32:34 AM : For Distributor 000000000000913 Insert Count::0 ### Delete Count::11
7/18/2021 7:32:34 AM : Import IN File --->> IN_913_20210619_d41d8cd98f00b204e9800998ecf8427e.TXT ### 7/18/2021 7:32:34 AM
7/18/2021 7:32:34 AM : For Distributor 000000000000913 Insert Count::0 ### Delete Count::4
7/18/2021 7:32:34 AM : Import IN File --->> IN_913_20210621_d41d8cd98f00b204e9800998ecf8427e.TXT ### 7/18/2021 7:32:34 AM
7/18/2021 7:32:34 AM : For Distributor 000000000000913 Insert Count::0 ### Delete Count::4
7/18/2021 7:32:34 AM : Import IN File --->> IN_913_20210622_d41d8cd98f00b204e9800998ecf8427e.TXT ### 7/18/2021 7:32:34 AM
7/18/2021 7:32:34 AM : For Distributor 000000000000913 Insert Count::0 ### Delete Count::5
7/18/2021 7:32:34 AM : Import IN File --->> IN_913_20210623_d41d8cd98f00b204e9800998ecf8427e.TXT ### 7/18/2021 7:32:34 AM
7/18/2021 7:32:35 AM : For Distributor 000000000000913 Insert Count::0 ### Delete Count::7
7/18/2021 7:32:35 AM : Import IN File --->> IN_913_20210624_d41d8cd98f00b204e9800998ecf8427e.TXT ### 7/18/2021 7:32:35 AM
7/18/2021 7:32:35 AM : For Distributor 000000000000913 Insert Count::0 ### Delete Count::2
7/18/2021 7:32:35 AM : Import IN File --->> IN_913_20210625_d41d8cd98f00b204e9800998ecf8427e.TXT ### 7/18/2021 7:32:35 AM
7/18/2021 7:32:35 AM : For Distributor 000000000000913 Insert Count::0 ### Delete Count::25
7/18/2021 7:32:35 AM : Import IN File --->> IN_913_20210626_d41d8cd98f00b204e9800998ecf8427e.TXT ### 7/18/2021 7:32:35 AM
7/18/2021 7:32:35 AM : For Distributor 000000000000913 Insert Count::0 ### Delete Count::21
7/18/2021 7:32:35 AM : Import IN File --->> IN_913_20210628_d41d8cd98f00b204e9800998ecf8427e.TXT ### 7/18/2021 7:32:35 AM
7/18/2021 7:32:35 AM : For Distributor 000000000000913 Insert Count::0 ### Delete Count::10
7/18/2021 7:32:35 AM : Import IN File --->> IN_913_20210629_d41d8cd98f00b204e9800998ecf8427e.TXT ### 7/18/2021 7:32:35 AM
7/18/2021 7:32:35 AM : For Distributor 000000000000913 Insert Count::0 ### Delete Count::26
7/18/2021 7:32:35 AM : Import IN File --->> IN_913_20210630_d41d8cd98f00b204e9800998ecf8427e.TXT ### 7/18/2021 7:32:35 AM
7/18/2021 7:32:36 AM : For Distributor 000000000000913 Insert Count::0 ### Delete Count::1
7/18/2021 7:32:36 AM : Import IN File --->> IN_913_20210701_d41d8cd98f00b204e9800998ecf8427e.TXT ### 7/18/2021 7:32:36 AM
7/18/2021 7:32:36 AM : For Distributor 000000000000913 Insert Count::0 ### Delete Count::1
7/18/2021 7:32:36 AM : Import IN File --->> IN_913_20210703_d41d8cd98f00b204e9800998ecf8427e.TXT ### 7/18/2021 7:32:36 AM
7/18/2021 7:32:40 AM : Exception  ### Index was outside the bounds of the array.
7/18/2021 7:32:40 AM : Error ### Index was outside the bounds of the array. Line 
7/18/2021 7:32:40 AM : For Distributor 000000000000913 Insert Count::0 ### Delete Count::86
7/18/2021 7:32:40 AM : Import PR File --->> PR_913_20210718_2dd5cf85ff2b874da712c6beebeb88f6.TXT ### 7/18/2021 7:32:40 AM
7/18/2021 7:32:41 AM : PostData() --->>  ### 7/18/2021 7:32:41 AM
7/18/2021 7:32:52 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 7/18/2021 7:32:52 AM
7/18/2021 7:32:54 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '18/Jul/2021' ### 7/18/2021 7:32:54 AM
7/18/2021 7:32:54 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '18/Jul/2021' ### 7/18/2021 7:32:54 AM
7/18/2021 7:32:54 AM :  ### 
7/18/2021 7:32:54 AM : UNLINKEDSALES Record Count Before --->> 274 ### 7/18/2021 7:32:54 AM
7/18/2021 7:32:54 AM : UNLINKEDSALES_DEL Record Count Before --->> 161 ### 7/18/2021 7:32:54 AM
7/18/2021 7:33:23 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '18/Jul/2021' ### 7/18/2021 7:33:23 AM
7/18/2021 7:33:23 AM : UNLINKEDSALES Record Count After --->> 0 ### 7/18/2021 7:33:23 AM
7/18/2021 7:33:23 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 7/18/2021 7:33:23 AM
7/18/2021 7:33:23 AM :  ### 
7/18/2021 7:33:23 AM : Posting Supplierlink Query for Purchases --->>  ### 7/18/2021 7:33:23 AM
7/18/2021 7:33:29 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '18/Jul/2021' ### 7/18/2021 7:33:29 AM
7/18/2021 7:33:35 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '18/Jul/2021' ### 7/18/2021 7:33:35 AM
7/18/2021 7:33:35 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 7/18/2021 7:33:35 AM
7/18/2021 7:33:35 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '18/Jul/2021' ### 7/18/2021 7:33:35 AM
7/18/2021 7:33:35 AM : Posting ClosingStock Successful --->>  ### 7/18/2021 7:33:35 AM
7/18/2021 7:33:35 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 7/18/2021 7:33:35 AM
7/18/2021 7:33:35 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
7/18/2021 7:33:35 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 7/18/2021 7:33:35 AM
7/18/2021 7:33:35 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 7:33:35 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 7/18/2021 7:33:35 AM
7/18/2021 7:33:35 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 7:33:35 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 7/18/2021 7:33:35 AM
7/18/2021 7:33:35 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 7:33:35 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2838040_TEMPLATE1.TXT ### 7/18/2021 7:33:35 AM
7/18/2021 7:33:35 AM : Count:: ### TEMPLATE1:155
7/18/2021 7:33:42 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 7:33:42 AM
7/18/2021 7:33:42 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3482327_TEMPLATE1.TXT ### 7/18/2021 7:33:42 AM
7/18/2021 7:33:42 AM : Count:: ### TEMPLATE1:18
7/18/2021 7:33:45 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 7:33:45 AM
7/18/2021 7:33:45 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3572999_TEMPLATE1.TXT ### 7/18/2021 7:33:45 AM
7/18/2021 7:33:45 AM : Count:: ### TEMPLATE1:84
7/18/2021 7:33:55 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 7:33:55 AM
7/18/2021 7:33:55 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3596136_TEMPLATE1.txt ### 7/18/2021 7:33:55 AM
7/18/2021 7:33:55 AM : Count:: ### TEMPLATE1:6
7/18/2021 7:33:56 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 7:33:56 AM
7/18/2021 7:33:56 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3601731_TEMPLATE1.txt ### 7/18/2021 7:33:56 AM
7/18/2021 7:33:56 AM : Count:: ### TEMPLATE1:608
7/18/2021 7:34:24 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 7:34:24 AM
7/18/2021 7:34:24 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 7/18/2021 7:34:24 AM
7/18/2021 7:34:24 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 7:34:24 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 7/18/2021 7:34:24 AM
7/18/2021 7:34:24 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 7:34:24 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3796284_TEMPLATE1.txt ### 7/18/2021 7:34:24 AM
7/18/2021 7:34:24 AM : Count:: ### TEMPLATE1:805
7/18/2021 7:35:00 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 7:35:00 AM
7/18/2021 7:35:00 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3814664_TEMPLATE1.txt ### 7/18/2021 7:35:00 AM
7/18/2021 7:35:00 AM : Count:: ### TEMPLATE1:87
7/18/2021 7:35:02 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 7:35:02 AM
7/18/2021 7:35:02 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 7/18/2021 7:35:02 AM
7/18/2021 7:35:02 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 7:35:02 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 7/18/2021 7:35:02 AM
7/18/2021 7:35:02 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 7:35:02 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3897231_TEMPLATE1.txt ### 7/18/2021 7:35:02 AM
7/18/2021 7:35:02 AM : Count:: ### TEMPLATE1:31
7/18/2021 7:35:05 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 7:35:05 AM
7/18/2021 7:35:05 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3917242_TEMPLATE1.TXT ### 7/18/2021 7:35:05 AM
7/18/2021 7:35:05 AM : Count:: ### TEMPLATE1:91
7/18/2021 7:35:17 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 7:35:17 AM
7/18/2021 7:35:17 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 7/18/2021 7:35:17 AM
7/18/2021 7:35:17 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 7:35:17 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4188862_TEMPLATE1.TXT ### 7/18/2021 7:35:17 AM
7/18/2021 7:35:17 AM : Count:: ### TEMPLATE1:19
7/18/2021 7:35:17 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 7:35:17 AM
7/18/2021 7:35:17 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4194755_TEMPLATE1.txt ### 7/18/2021 7:35:17 AM
7/18/2021 7:35:17 AM : Count:: ### TEMPLATE1:573
7/18/2021 7:35:43 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 7:35:43 AM
7/18/2021 7:35:43 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4196234_TEMPLATE1.TXT ### 7/18/2021 7:35:43 AM
7/18/2021 7:35:43 AM : Count:: ### TEMPLATE1:3
7/18/2021 7:35:44 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 7:35:44 AM
7/18/2021 7:35:44 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4199222_TEMPLATE1.txt ### 7/18/2021 7:35:44 AM
7/18/2021 7:35:44 AM : Count:: ### TEMPLATE1:392
7/18/2021 7:36:01 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 7:36:01 AM
7/18/2021 7:36:01 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 7/18/2021 7:36:01 AM
7/18/2021 7:36:01 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 7:36:01 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 7/18/2021 7:36:01 AM
7/18/2021 7:36:01 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 7:36:01 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061058_TEMPLATE1.txt ### 7/18/2021 7:36:01 AM
7/18/2021 7:36:01 AM : Count:: ### TEMPLATE1:51
7/18/2021 7:36:06 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 7:36:06 AM
7/18/2021 7:36:06 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061385_TEMPLATE1.TXT ### 7/18/2021 7:36:06 AM
7/18/2021 7:36:06 AM : Count:: ### TEMPLATE1:305
7/18/2021 7:36:25 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 7:36:25 AM
7/18/2021 7:36:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 7/18/2021 7:36:25 AM
7/18/2021 7:36:25 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 7:36:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 7/18/2021 7:36:25 AM
7/18/2021 7:36:25 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 7:36:25 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061625_TEMPLATE1.txt ### 7/18/2021 7:36:25 AM
7/18/2021 7:36:25 AM : Count:: ### TEMPLATE1:158
7/18/2021 7:36:44 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 7:36:44 AM
7/18/2021 7:36:44 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 7/18/2021 7:36:44 AM
7/18/2021 7:36:44 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 7:36:44 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9065119_TEMPLATE1.TXT ### 7/18/2021 7:36:44 AM
7/18/2021 7:36:44 AM : Count:: ### TEMPLATE1:65
7/18/2021 7:36:55 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 7:36:55 AM
7/18/2021 7:36:55 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9068225_TEMPLATE1.txt ### 7/18/2021 7:36:55 AM
7/18/2021 7:36:55 AM : Count:: ### TEMPLATE1:232
7/18/2021 7:37:06 AM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 7:37:06 AM
7/18/2021 7:37:06 AM : Template Import Complete  ### 7/18/2021 7:37:06 AM
7/18/2021 7:37:08 AM : Completed Updating Has Transaction Flag  ### 7/18/2021 7:37:08 AM
7/18/2021 7:37:08 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 7/18/2021 7:37:08 AM
7/18/2021 7:37:08 AM : Zylem Access Unblocked  ### 7/18/2021 7:37:08 AM
7/18/2021 7:37:08 AM : Application Ended  ### 7/18/2021 7:37:08 AM

7/18/2021 2:30:01 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
7/18/2021 2:30:02 PM : StartProcess  ### 7/18/2021 2:30:02 PM

7/18/2021 2:30:02 PM : 11  ### 7/18/2021 2:30:02 PM

7/18/2021 2:30:02 PM : 22  ### 7/18/2021 2:30:02 PM

7/18/2021 2:30:02 PM : 33  ### 7/18/2021 2:30:02 PM

7/18/2021 2:30:02 PM : Application Started  ### 7/18/2021 2:30:02 PM

7/18/2021 2:30:02 PM : Start Process : checkAllTablesExists()  ### 
7/18/2021 2:30:02 PM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 7/18/2021 2:30:02 PM
7/18/2021 2:30:02 PM : MainForm_Load  ### AlertSystem ON
7/18/2021 2:30:02 PM : No. of Files to import (RECEIVEFINAL):  ### 1384
7/18/2021 2:30:02 PM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
7/18/2021 2:30:02 PM : For Distributor 000000000001047 Insert Count::4 ### Delete Count::0
7/18/2021 2:30:02 PM : Import AD File --->> AD_1047_20210718_d84722a5a565461b3cd5925419376205.TXT ### 7/18/2021 2:30:02 PM
7/18/2021 2:30:03 PM : For Distributor 000000000000265 Insert Count::2 ### Delete Count::2
7/18/2021 2:30:03 PM : Import AD File --->> AD_265_20210718_1d4ef201b0a0e2e100eceff45e92df94.TXT ### 7/18/2021 2:30:03 PM
7/18/2021 2:30:14 PM : For Distributor 000000000000265 Insert Count::1 ### Delete Count::0
7/18/2021 2:30:14 PM : Import DN File --->> DN_265_20210615_21e34b5691b63924547bfbd36ab892eb.TXT ### 7/18/2021 2:30:14 PM
7/18/2021 2:30:15 PM : For Distributor 000000000000265 Insert Count::1 ### Delete Count::0
7/18/2021 2:30:15 PM : Import DN File --->> DN_265_20210619_9bd9cee4cc6591651a52fc3fcf45c63b.TXT ### 7/18/2021 2:30:15 PM
7/18/2021 2:30:15 PM : For Distributor 000000000000265 Insert Count::1 ### Delete Count::0
7/18/2021 2:30:15 PM : Import DN File --->> DN_265_20210624_48fa249beec56d7e4e2e96a6d65876bf.TXT ### 7/18/2021 2:30:15 PM
7/18/2021 2:30:16 PM : For Distributor 000000000000265 Insert Count::1 ### Delete Count::0
7/18/2021 2:30:16 PM : Import DN File --->> DN_265_20210629_c9013f7f16762820dca785cfeb4678db.TXT ### 7/18/2021 2:30:16 PM
7/18/2021 2:30:18 PM : For Distributor 000000000000525 Insert Count::3 ### Delete Count::3
7/18/2021 2:30:18 PM : Import DN File --->> DN_525_20210618_7debeb66cd7fd19e9895038ada652f06.TXT ### 7/18/2021 2:30:18 PM
7/18/2021 2:30:19 PM : For Distributor 000000000000525 Insert Count::5 ### Delete Count::5
7/18/2021 2:30:19 PM : Import DN File --->> DN_525_20210623_bdfdf4d117435973c978625b46925840.TXT ### 7/18/2021 2:30:19 PM
7/18/2021 2:30:19 PM : For Distributor 000000000000525 Insert Count::5 ### Delete Count::0
7/18/2021 2:30:19 PM : Import DN File --->> DN_525_20210624_ffe5ca552a18631c5c0b37e73cb39eac.TXT ### 7/18/2021 2:30:19 PM
7/18/2021 2:30:19 PM : For Distributor 000000000000525 Insert Count::1 ### Delete Count::1
7/18/2021 2:30:19 PM : Import DN File --->> DN_525_20210702_bc95cf4518960b10f8048e90f30a1867.TXT ### 7/18/2021 2:30:19 PM
7/18/2021 2:30:51 PM : For Distributor 000000000001047 Insert Count::1 ### Delete Count::1
7/18/2021 2:30:51 PM : Import IN File --->> IN_1047_20210715_6f7169dc7f12cc334e0d449e38f897f7.TXT ### 7/18/2021 2:30:51 PM
7/18/2021 2:30:51 PM : For Distributor 000000000001047 Insert Count::2 ### Delete Count::0
7/18/2021 2:30:51 PM : Import IN File --->> IN_1047_20210716_d38dd55f1976698c48b38c286ee1e8dc.TXT ### 7/18/2021 2:30:51 PM
7/18/2021 2:30:51 PM : For Distributor 000000000001047 Insert Count::54 ### Delete Count::0
7/18/2021 2:30:51 PM : Import IN File --->> IN_1047_20210717_3c2b5bf5776d4337d207c4c7ec7681a8.TXT ### 7/18/2021 2:30:51 PM
7/18/2021 2:30:51 PM : Import IN File --->> IN_1047_20210718_f637ffe658294fc96d4c6dfbce0e15f4.TXT ### 7/18/2021 2:30:51 PM
7/18/2021 2:30:51 PM : NO Previous File For Distributor 000000000001047 ### Insert Count::17
7/18/2021 2:30:58 PM : For Distributor 000000000001168 Insert Count::1 ### Delete Count::0
7/18/2021 2:30:58 PM : Import IN File --->> IN_1168_20210717_05f700d56814a0e0c7f5ea094b1e6ad7.TXT ### 7/18/2021 2:30:58 PM
7/18/2021 2:30:59 PM : For Distributor 000000000000265 Insert Count::1 ### Delete Count::0
7/18/2021 2:30:59 PM : Import IN File --->> IN_265_20210607_8e2de260696fa4064b7c5b53c3837bca.TXT ### 7/18/2021 2:30:59 PM
7/18/2021 2:31:00 PM : For Distributor 000000000000265 Insert Count::1 ### Delete Count::0
7/18/2021 2:31:00 PM : Import IN File --->> IN_265_20210618_952574c5759b54c7b129d0048757c547.TXT ### 7/18/2021 2:31:00 PM
7/18/2021 2:31:00 PM : For Distributor 000000000000265 Insert Count::1 ### Delete Count::0
7/18/2021 2:31:00 PM : Import IN File --->> IN_265_20210621_22643a11f26d3ce452cc872a593546f1.TXT ### 7/18/2021 2:31:00 PM
7/18/2021 2:31:00 PM : For Distributor 000000000000265 Insert Count::1 ### Delete Count::0
7/18/2021 2:31:00 PM : Import IN File --->> IN_265_20210624_a58edae4cdffb9c13f190f4bf08cc908.TXT ### 7/18/2021 2:31:00 PM
7/18/2021 2:31:01 PM : For Distributor 000000000000265 Insert Count::1 ### Delete Count::0
7/18/2021 2:31:01 PM : Import IN File --->> IN_265_20210625_31c6d728d71095621acd40a7adb8b5e6.TXT ### 7/18/2021 2:31:01 PM
7/18/2021 2:31:01 PM : For Distributor 000000000000265 Insert Count::3 ### Delete Count::0
7/18/2021 2:31:01 PM : Import IN File --->> IN_265_20210626_071f92434ad89a87c261101a5f422c47.TXT ### 7/18/2021 2:31:01 PM
7/18/2021 2:31:01 PM : For Distributor 000000000000265 Insert Count::2 ### Delete Count::0
7/18/2021 2:31:01 PM : Import IN File --->> IN_265_20210628_2a97ed5d68680ed1651a077612bc7924.TXT ### 7/18/2021 2:31:01 PM
7/18/2021 2:31:01 PM : For Distributor 000000000000265 Insert Count::6 ### Delete Count::2
7/18/2021 2:31:01 PM : Import IN File --->> IN_265_20210629_177e4cb9d11e818645a022edaad93c31.TXT ### 7/18/2021 2:31:01 PM
7/18/2021 2:31:01 PM : For Distributor 000000000000265 Insert Count::10 ### Delete Count::3
7/18/2021 2:31:01 PM : Import IN File --->> IN_265_20210630_250ff78ca46f1181d50f972746302e25.TXT ### 7/18/2021 2:31:01 PM
7/18/2021 2:31:02 PM : For Distributor 000000000000265 Insert Count::1 ### Delete Count::0
7/18/2021 2:31:02 PM : Import IN File --->> IN_265_20210701_b492207e63393520ca207ae63d56ba91.TXT ### 7/18/2021 2:31:02 PM
7/18/2021 2:31:02 PM : For Distributor 000000000000265 Insert Count::3 ### Delete Count::0
7/18/2021 2:31:02 PM : Import IN File --->> IN_265_20210703_06c47a87e66b59c27b9e2b0a3c02b2c5.TXT ### 7/18/2021 2:31:02 PM
7/18/2021 2:31:02 PM : For Distributor 000000000000265 Insert Count::3 ### Delete Count::0
7/18/2021 2:31:02 PM : Import IN File --->> IN_265_20210705_0da017e25d9743b0d0e94beacf8e8465.TXT ### 7/18/2021 2:31:02 PM
7/18/2021 2:31:02 PM : For Distributor 000000000000265 Insert Count::2 ### Delete Count::1
7/18/2021 2:31:02 PM : Import IN File --->> IN_265_20210706_f90b223e13934e94392c52e2dbea1047.TXT ### 7/18/2021 2:31:02 PM
7/18/2021 2:31:02 PM : For Distributor 000000000000265 Insert Count::1 ### Delete Count::0
7/18/2021 2:31:02 PM : Import IN File --->> IN_265_20210707_632848f40c0ad0e17b1225aed28ba626.TXT ### 7/18/2021 2:31:02 PM
7/18/2021 2:31:02 PM : For Distributor 000000000000265 Insert Count::3 ### Delete Count::0
7/18/2021 2:31:02 PM : Import IN File --->> IN_265_20210708_337f34ac9873f5b4f184996fc9b747c2.TXT ### 7/18/2021 2:31:02 PM
7/18/2021 2:31:03 PM : For Distributor 000000000000265 Insert Count::3 ### Delete Count::0
7/18/2021 2:31:03 PM : Import IN File --->> IN_265_20210709_8faf7ff3bed6dec7b5646031af4cc68a.TXT ### 7/18/2021 2:31:03 PM
7/18/2021 2:31:03 PM : For Distributor 000000000000265 Insert Count::1 ### Delete Count::0
7/18/2021 2:31:03 PM : Import IN File --->> IN_265_20210710_4eb9ad570140ffc92b12cbe4fa66713d.TXT ### 7/18/2021 2:31:03 PM
7/18/2021 2:31:03 PM : For Distributor 000000000000265 Insert Count::1 ### Delete Count::0
7/18/2021 2:31:03 PM : Import IN File --->> IN_265_20210711_b0fa8a66e28f41df013ebf0f6d32db9c.TXT ### 7/18/2021 2:31:03 PM
7/18/2021 2:31:03 PM : For Distributor 000000000000265 Insert Count::2 ### Delete Count::0
7/18/2021 2:31:03 PM : Import IN File --->> IN_265_20210712_ab561c57504a79deaf748b0616062f78.TXT ### 7/18/2021 2:31:03 PM
7/18/2021 2:31:03 PM : For Distributor 000000000000265 Insert Count::5 ### Delete Count::0
7/18/2021 2:31:03 PM : Import IN File --->> IN_265_20210713_3693e761602b5a76fca7d68f50fad493.TXT ### 7/18/2021 2:31:03 PM
7/18/2021 2:31:03 PM : For Distributor 000000000000265 Insert Count::3 ### Delete Count::1
7/18/2021 2:31:03 PM : Import IN File --->> IN_265_20210714_11ed271bdbe02a4a5f7cde430ea225b3.TXT ### 7/18/2021 2:31:03 PM
7/18/2021 2:31:04 PM : For Distributor 000000000000265 Insert Count::3 ### Delete Count::0
7/18/2021 2:31:04 PM : Import IN File --->> IN_265_20210715_605c23ac9ac30fb80443d29067285c94.TXT ### 7/18/2021 2:31:04 PM
7/18/2021 2:31:04 PM : Import IN File --->> IN_265_20210717_9a219959e3c9337bb74f1b5d4970274d.TXT ### 7/18/2021 2:31:04 PM
7/18/2021 2:31:04 PM : NO Previous File For Distributor 000000000000265 ### Insert Count::1
7/18/2021 2:31:36 PM : For Distributor 000000000001047 Insert Count::2 ### Delete Count::0
7/18/2021 2:31:36 PM : Import PR File --->> PR_1047_20210718_0d0071657378f8be94514987bb110a86.TXT ### 7/18/2021 2:31:36 PM
7/18/2021 2:31:37 PM : For Distributor 000000000000110 Insert Count::0 ### Delete Count::7
7/18/2021 2:31:37 PM : Import PR File --->> PR_110_20210718_cd6222089f9cc83b4786c3e93c24fda8.TXT ### 7/18/2021 2:31:37 PM
7/18/2021 2:31:37 PM : For Distributor 000000000000265 Insert Count::55 ### Delete Count::0
7/18/2021 2:31:37 PM : Import PR File --->> PR_265_20210718_bf9a44daa2c56bc0e924b615b560c3b8.TXT ### 7/18/2021 2:31:37 PM
7/18/2021 2:31:37 PM : PostData() --->>  ### 7/18/2021 2:31:37 PM
7/18/2021 2:31:41 PM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 7/18/2021 2:31:41 PM
7/18/2021 2:31:42 PM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '18/Jul/2021' ### 7/18/2021 2:31:42 PM
7/18/2021 2:31:43 PM : ItemLink Successful --->> exec SP_ItemLinkDiff '18/Jul/2021' ### 7/18/2021 2:31:43 PM
7/18/2021 2:31:43 PM :  ### 
7/18/2021 2:31:43 PM : UNLINKEDSALES Record Count Before --->> 133 ### 7/18/2021 2:31:43 PM
7/18/2021 2:31:43 PM : UNLINKEDSALES_DEL Record Count Before --->> 8 ### 7/18/2021 2:31:43 PM
7/18/2021 2:31:54 PM : Posting Sales Successful --->> exec prPostLinkedDiffSales '18/Jul/2021' ### 7/18/2021 2:31:54 PM
7/18/2021 2:31:54 PM : UNLINKEDSALES Record Count After --->> 0 ### 7/18/2021 2:31:54 PM
7/18/2021 2:31:54 PM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 7/18/2021 2:31:54 PM
7/18/2021 2:31:54 PM :  ### 
7/18/2021 2:31:54 PM : Posting Supplierlink Query for Purchases --->>  ### 7/18/2021 2:31:54 PM
7/18/2021 2:32:01 PM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '18/Jul/2021' ### 7/18/2021 2:32:01 PM
7/18/2021 2:32:07 PM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '18/Jul/2021' ### 7/18/2021 2:32:07 PM
7/18/2021 2:32:07 PM : Posting Supplierlink Query for CompanyPurchases --->>  ### 7/18/2021 2:32:07 PM
7/18/2021 2:32:07 PM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '18/Jul/2021' ### 7/18/2021 2:32:07 PM
7/18/2021 2:32:07 PM : Posting ClosingStock Successful --->>  ### 7/18/2021 2:32:07 PM
7/18/2021 2:32:07 PM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 7/18/2021 2:32:07 PM
7/18/2021 2:32:07 PM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
7/18/2021 2:32:07 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 7/18/2021 2:32:07 PM
7/18/2021 2:32:07 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:32:07 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1988040_TEMPLATE1.txt ### 7/18/2021 2:32:07 PM
7/18/2021 2:32:07 PM : Count:: ### TEMPLATE1:295
7/18/2021 2:32:21 PM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 2:32:21 PM
7/18/2021 2:32:21 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 7/18/2021 2:32:21 PM
7/18/2021 2:32:21 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:32:21 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 7/18/2021 2:32:21 PM
7/18/2021 2:32:21 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:32:21 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3272418_TEMPLATE1.TXT ### 7/18/2021 2:32:21 PM
7/18/2021 2:32:21 PM : Count:: ### TEMPLATE1:130
7/18/2021 2:32:27 PM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 2:32:27 PM
7/18/2021 2:32:27 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3572999_TEMPLATE1.TXT ### 7/18/2021 2:32:27 PM
7/18/2021 2:32:27 PM : Count:: ### TEMPLATE1:84
7/18/2021 2:32:38 PM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 2:32:38 PM
7/18/2021 2:32:38 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 7/18/2021 2:32:38 PM
7/18/2021 2:32:38 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:32:38 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 7/18/2021 2:32:38 PM
7/18/2021 2:32:38 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:32:38 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3814664_TEMPLATE1.txt ### 7/18/2021 2:32:38 PM
7/18/2021 2:32:38 PM : Count:: ### TEMPLATE1:87
7/18/2021 2:32:50 PM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 2:32:50 PM
7/18/2021 2:32:50 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 7/18/2021 2:32:50 PM
7/18/2021 2:32:50 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:32:50 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 7/18/2021 2:32:50 PM
7/18/2021 2:32:50 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:32:50 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3974630_TEMPLATE1.txt ### 7/18/2021 2:32:50 PM
7/18/2021 2:32:50 PM : Count:: ### TEMPLATE1:85
7/18/2021 2:32:54 PM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 2:32:54 PM
7/18/2021 2:32:54 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 7/18/2021 2:32:54 PM
7/18/2021 2:32:54 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:32:54 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4179428_TEMPLATE1.txt ### 7/18/2021 2:32:54 PM
7/18/2021 2:32:54 PM : Count:: ### TEMPLATE1:3
7/18/2021 2:32:55 PM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 2:32:55 PM
7/18/2021 2:32:55 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4198784_TEMPLATE1.txt ### 7/18/2021 2:32:55 PM
7/18/2021 2:32:55 PM : Count:: ### TEMPLATE1:13
7/18/2021 2:32:56 PM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 2:32:56 PM
7/18/2021 2:32:56 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 7/18/2021 2:32:56 PM
7/18/2021 2:32:56 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:32:56 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 7/18/2021 2:32:56 PM
7/18/2021 2:32:56 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:32:56 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061033_TEMPLATE1.TXT ### 7/18/2021 2:32:56 PM
7/18/2021 2:32:56 PM : Count:: ### TEMPLATE1:12
7/18/2021 2:32:57 PM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 2:32:57 PM
7/18/2021 2:32:57 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 7/18/2021 2:32:57 PM
7/18/2021 2:32:57 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:32:57 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 7/18/2021 2:32:57 PM
7/18/2021 2:32:57 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:32:57 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061625_TEMPLATE1.txt ### 7/18/2021 2:32:57 PM
7/18/2021 2:32:57 PM : Count:: ### TEMPLATE1:158
7/18/2021 2:33:05 PM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 2:33:05 PM
7/18/2021 2:33:05 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 7/18/2021 2:33:05 PM
7/18/2021 2:33:05 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
7/18/2021 2:33:05 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9068225_TEMPLATE1.txt ### 7/18/2021 2:33:05 PM
7/18/2021 2:33:05 PM : Count:: ### TEMPLATE1:232
7/18/2021 2:33:30 PM : SP_DistributorTemplatePosting Successful --->>  ### 7/18/2021 2:33:30 PM
7/18/2021 2:33:30 PM : Template Import Complete  ### 7/18/2021 2:33:30 PM
7/18/2021 2:33:32 PM : Completed Updating Has Transaction Flag  ### 7/18/2021 2:33:32 PM
7/18/2021 2:33:32 PM : Transaction Table lastEdiDate Update on BrandAlias Update ### 7/18/2021 2:33:32 PM
7/18/2021 2:33:32 PM : Zylem Access Unblocked  ### 7/18/2021 2:33:32 PM
7/18/2021 2:33:32 PM : Application Ended  ### 7/18/2021 2:33:32 PM