TM1 Forum

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

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"?