1 Reply Latest reply: Mar 29, 2012 4:18 AM by 927212 RSS

    ORA-12801: error signaled in parallel query server P001

    913284
      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???
        • 1. Re: ORA-12801: error signaled in parallel query server P001
          927212
          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
          "