Skip to content
Advertisement

SSRS giving error as HResult E_FAIL has been returned from a call to a COM Component

When I run the SSRS report with data having 150 000 characters it gives error

HResult E_FAIL has been returned from a call to a COM Component

I am using the single textbox to display this data. For any other data it works fine. I have searched on some other forums and they say that you can only print 32 000 characters using SSRS textbox in 2008, but then why its working for some other data with 150 000 characters and not working with this particular data.

The data is having numbers as below

1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890121234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890121234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890121234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890121234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890121234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890121234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890121234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890121234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890121234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890121234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890121234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 

For normal data its working fine. The data type of the SQL server column is nvarchar(max) and it has such numbers only for 150 000 as the data.

Sometimes it returns the result as value does not fall within the expected range, but this a text column so why it is then considering this as number. The other data example is having a 100000 characters as strings and then rest of 50000 characters as numbers that are separated with spaces as given above for example 1234567890 1234567890 like this upto 50000 characters length.

I am not sure how to deal with this error.

Advertisement

Answer

We have not found solution to the Technical error, but after discussing this with Onsite folks, we have come to conclusion that the data is in single line, if line breaks are inserted in the data, then SSRS is working fine. SO we have proposed a Data Fix for this issue rather than going on and on with technical error of SSRS. We have not done any changes in SSRS. If line breaks are inserted in data then it works fine.

7 People found this is helpful
Advertisement