September 13, 2010 at 5:45 am
Hi,
I get the following error message randomly when i execute my SSRS Report RDL (SSRS 2005)
"an error has occurred during report processing.cannot read the next data row for the data set connection. ORA-08103: object no longer exists"
The dataset in the RDL connects to ORACLE database.
The Stored Proc(SP) in Oracle uses Global temporary tables , which is created in the same SP. Global temporary table is created before it is accessed.
This error occurs randomly only. I am not table to identify the reason for this error. Please help me in identfying the cause of this issue.
Thanks,
Arunvijay
September 13, 2010 at 6:59 am
That's an Oracle Error. I'd say kick it over to the oracle team (if you have one) and see what they have to say about it. If it's just you or you want to help out the other guys, have a look at the following... http://blogs.imeta.co.uk/sstrong/archive/2009/07/29/732.aspx
-Luke.
September 13, 2010 at 11:07 pm
The problem my be that the report is using the shared data connection which is no longer available.This error is shown only when there is an error in data connection.Connection in RDL may be working fine but at report level it is not so check the data source at report level...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply