Hello
I created a process for loading data from an oracle database, it works correctly if I limit the number of lines to load, otherwise it generates this error "Error: Data procedure line (0): SQLState: S1000 SQLMsg: [Oracle][ODBC][Ora]ORA-08103: object no longer exists"
knowing that the query runs quickly in Oracle and that it sees more than 2310000
Thank you in advance for your help
SQLState: S1000 SQLMsg: [Oracle][ODBC][Ora]ORA-08103: object no longer exists
-
declanr
- MVP
- Posts: 1815
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: SQLState: S1000 SQLMsg: [Oracle][ODBC][Ora]ORA-08103: object no longer exists
What is the query? Is it against a table or something else?
It's certainly not unheard of for the error messages to be misleading but "object no longer exists" is not one I have come across before.
I wonder if its something like a stored procedure to return a view but another user has executed the stored procedure since then destroying your view.
Does it always error for the larger number of records? And does it always work for the smaller number?
How are you "limiting the number of lines"?
It's certainly not unheard of for the error messages to be misleading but "object no longer exists" is not one I have come across before.
I wonder if its something like a stored procedure to return a view but another user has executed the stored procedure since then destroying your view.
Does it always error for the larger number of records? And does it always work for the smaller number?
How are you "limiting the number of lines"?
Declan Rodger