1 Reply Latest reply on Sep 24, 2010 7:42 PM by user1102152

    Getting the below error when trying to fetch the data from SQL sources (DB2

    user6464652
      Getting the below error when trying to fetch the data from SQL sources (DB2 UDB database) thru Essbase Load rule.
      'Failed to connect to SQL Databases'
      When trying to connect to database using the example in the merant driver location, the following error is coming:'

      As suggested in the esb_sql_interface.pdf, the odbc.ini file in $MERANT_HOME fiolder been updated to include the relational data sources and this file is being copied to $ESSBASEPATH/bin '/home/hyperion/Oracle/Middleware/EPMSystem11R1/products/Essbase/EssbaseServer/bin) folder as .odbc.ini and symbolically linked to /home/hyperion/.odbc.ini file
      After the above is done, I tried to test the connectivity by executing the example software that come with the package. Below is the error.
      Can somebody please provide steps to resolve this? Appreciate your help. Thanks,
      -----------------------
      eaqhyp02a:{arbor}:/home/hyperion/Oracle/Middleware/EPMSystem11R1/common/ODBC-64/Merant/6.0/example>
      $./example
      ./example DataDirect Technologies, Inc. ODBC Example Application.

      Enter the data source name : dolq001

      Enter the user name : db2ol1

      Enter the password : **********
      SQLSTATE = S1000
      NATIVE ERROR = -1001
      MSG = [DataDirect][ODBC DB2 Wire Protocol driver][DB2]Unknown error: SQLCODE -1001

      SQLConnect: Retrying Connect.
      SQLSTATE = S1000
      NATIVE ERROR = -1001
      MSG = [DataDirect][ODBC DB2 Wire Protocol driver][DB2]Unknown error: SQLCODE -1001

      SQLConnect: Retrying Connect.
      SQLSTATE = S1000
      NATIVE ERROR = -1001
      MSG = [DataDirect][ODBC DB2 Wire Protocol driver][DB2]Unknown error: SQLCODE -1001

      SQLConnect: Retrying Connect.
      eaqhyp02a:{arbor}:/home/hyperion/Oracle/Middleware/EPMSystem11R1/common/ODBC-64/Merant/6.0/example>
      $cd $ESSBASEPATH/bin
      eaqhyp02a:{arbor}:/home/hyperion/Oracle/Middleware/EPMSystem11R1/products/Essbase/EssbaseServer/bin>
        • 1. Re: Getting the below error when trying to fetch the data from SQL sources (DB2
          user1102152
          You cannot believe the weiredest thing. I believe the instruction is wrong. It happened to us from Essbase when we tried to load the rules file an hour ago.
          We were able to see on the log file that it gave the path of diffrent from $ESSBASEPATH which is at the products directory.

          However it is looking for the path in
          home/hyperion/Oracle/Middleware/user_projects/epmsystem1/EssbaseServer/essbaseserver1/bin/.odbc.ini
          We copied the .odbc.ini file to this directory and were good to go !!

          Hope that helps.


          Application Log File when we got error showed
          [Fri Sep 24 11:16:56 2010]Local/RevFlash/RevFlash/admin@Native Directory/Info(1013091)
          Received Command [OtlQueryMbrs] from user [admin@Native Directory]

          [Fri Sep 24 11:17:05 2010]Local/RevFlash/RevFlash/admin@Native Directory/Info(1013091)
          Received Command [SQLListDsn] from user [admin@Native Directory]

          [Fri Sep 24 11:17:05 2010]Local/RevFlash/RevFlash/admin@Native Directory/Info(1021020)
          Cannot read SQL driver name for [PDWH1] from [home/hyperion/Oracle/Middleware/user_projects/epmsystem1/EssbaseServer/essbaseserver1/bin/.odbc.ini]

          [Fri Sep 24 11:17:05 2010]Local/RevFlash/RevFlash/admin@Native Directory/Info(1021020)
          Cannot read SQL driver name for [ps] from [home/hyperion/Oracle/Middleware/user_projects/epmsystem1/EssbaseServer/essbaseserver1/bin/.odbc.ini]


          Jullin