4 Replies Latest reply: Sep 21, 2015 5:52 AM by Frédéric Villemin RSS

    OID Generation Failed

    Vamshi Tataipelli



      I am getting this general error for some tasks very often.

      Error: SQL##f - SqlState: S1000, ErrorCode: 21561, ErrorMsg: [Oracle][ODBC][Ora]ORA-21561: OID generation failed


      But when i re-run the task after some time it is working fine. Can anybody help me in hot to fix this issue?

        • Re: OID Generation Failed
          Bill Markham



          I'd suggest you seek the advice of your Oracle DBA.



          Best Regards,     Bill

          • Re: OID Generation Failed
            Fernando Keuroglian

            As Bill said its look like an internal error in some id in the database , and it is strange that happend some times yes, and others not.


            try to execute the same sql when the error ocurrs in qlikview and see what happend, pherhaps in sql ambient would be the same error at the same time



            • Re: OID Generation Failed

              This error message is only what we get from the SQL database, and not a QlikView generated error.

              As suggested, check communities and Oracle for suggestions to fix problem.


              Found this after a quick search:

              Check the client's /.../hosts file and verify that the local node is correctly identified with a mapping for both the short and fully qualified name of the host.

              • Re: OID Generation Failed
                Frédéric Villemin


                it's the same for me and it only happens with Qlikview.

                So it's probably a database issue but also maybe a database issue coming from QVConnect.


                We have discovered that when our server has not enough memory (less than 4GB out of 64GB), it may crash with database errors like Connection Failed probably because of QV Connect. The database is fine and everything's running correctly every where except with Qlikview.


                Difficult to make a case because it's a random error. Sometimes it works sometimes it doesn't ...