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: 210
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
Next Topic: Upgrade 11G Repository to 12c Repository
Goto Forum:
  


Current Time: Fri Mar 29 04:54:32 CDT 2024