This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!

Respond to this messageReturn to Index
Original Message
  • SQL Interface Error

    • Posted Jun 21, 2012 4:59 PM

      Has anyone seen this error before? The strange thing is that it doesn't happen with all cubes, but once I get it with a cube, I have to recreate it. Once I recreate the cube, I don't get the error anymore -- at least for a while. What should I look into -- I assume driver version? For a little context, I'm running 11.1.1.3 Essbase on AIX and hitting Oracle 10 database. Never any problems hitting Oracle 11 database.
      Thanks,
      Tim

      OK/INFO - 1021043 - Connection has been established.
      OK/INFO - 1021044 - Starting to execute query.
      OK/INFO - 1021013 - ODBC Layer Error: [S1000] ==> [[DataDirect][ODBC Oracle Wire Protocol driver]The DataDirect ODBC driver you are attempting to access has
      been provided to you by Hyperion Solutions for exclusive use with Hyperion products. You are not licensed to use this driver with any application other than
      Hyperion products. If you would like to purchase a driver for some other use, please call 800-876-3101 or visit DataDirect at www.datadirect.com ].
      OK/INFO - 1021014 - ODBC Layer Error: Native Error code [6091] .
      ERROR - 1021001 - Failed to Establish Connection With SQL Database Server. See log for more information.
      ERROR - 1241101 - Unexpected Essbase error 1021001.
    Login Status
  • You are not logged in
    • Login
      Password
       

      Optional
      Provides additional benefits such as notifications, signatures, and user authentication.


      Create Account
    Your Name
    Message Title
    Message Text
    Options