SQL*Loader-951: Error calling once/load initialization

[udayk_2007]

Hello Friends

We are facing a sql loader error in DataStage jobs

SQL*Loader-951: Error calling once/load initialization
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist

These jobs are doing a truncate & load. Also a pattern observed is this is happening with the jobs which are inserting into a different schema (other than the source table schema)

We also checked the database version and the client version. They are 11.1.0.7.0 & 11.2.0 respectively.

Our DBA's are suspecting that this is happening due to client version higher than database version. But the same setup in development env is running fine.

Also this problem is observed for a particular moment. After restarting,the job runs fine. This problem is occuring in different jobs everytime

Please help

Thanks

[priyadarshikunal]

How are you calling that table in other schema, is it through synonym or by prefixing the schema name or any other way?

server and clients with Minor version difference are generally compatible but may create problems once in a while. But you need to first find out the root cause. Did the DBA tried enabling trace on this database?