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,

Report message to a moderator

Previous Topic: change the Parameter $$END_DATE value in sil_day_dimension
Next Topic: Upgrade 11G Repository to 12c Repository
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 26 05:05:10 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.