We are getting the following error once in a while when we have upgraded our environment to Oracle 11g and ODP.NET 11.x
Failed to get Service Credit records for Service ID , Reason: ORA-12801: error signaled in parallel query server P001, instance omnibadb1:portalp1 (1) ORA-01460: unimplemented or unreasonable conversion requested ORA-06512: at "CIS.PA_SERVICE_CREDIT", line 374 ORA-06512: at line 1|Error attempting Select Method GetRetirementEligiblityGroupsByConference:14391
When we are running the same code with 10g and ODP.NET 10.x it is working fine.
Issue gets resolves if we do the IIS reset on the server from where we are making database calls.
It seems to be the issue in the ODP.NET provider --- Anyone has ever come across this issue ??? Is there any patch or permanent solution to resolve this issue???
I have the same problem in calling simple procedure (simple select inside) from sqlPlus from bash. The error apperas very rearly and next execution usually going without problem.
When i turn off parallel query error stop appears for day, right now.
"ORA-12801: error signaled in parallel query server P035
ORA-01460: unimplemented or unreasonable conversion requested
ORA-06512: at "XXX", line 99
ORA-06512: at line 6