Home » Developer & Programmer » Data Integration » Caused By: java.sql.SQLException: ORA-12801: error signaled in parallel query server P001 ORA-08103: (ODI 12C)
Caused By: java.sql.SQLException: ORA-12801: error signaled in parallel query server P001 ORA-08103: [message #683003] Mon, 23 November 2020 16:08
manoj12
Messages: 207
Registered: March 2008
Location: India
Senior Member
Hello Team,

I am having an ODI session which executes at 3:00:47 AM it creates a unique identifier table C$_1AQM97VQ6UNBBC0056KO3FA4TJ7 and uses the unique identifier table to load the records into the temp table.

I have called the Package only once in the load plan but the session fails by giving error as shown below error.
isCaused By: java.sql.SQLException: ORA-12801: error signaled in parallel query server P001
ORA-08103: object no longer exists
At first I realize that the other map is trying to drop the temp table but this is not the case.

The object for the error came still the unique identifier table still exists C$_1AQM97VQ6UNBBC0056KO3FA4TJ7 in the database.

Appreciate your help on the above questions.

Regards,
Previous Topic: change the Parameter $$END_DATE value in sil_day_dimension
Goto Forum:
  


Current Time: Wed Apr 14 04:05:01 CDT 2021