1 Reply Latest reply on May 22, 2015 4:16 PM by Tom Rowe

    BI Administration Tool - Metadata Import for IBM Informix Database  'The connection has failed.'

    Tom Rowe

      Hi,

       

      I wonder if anyone has any experience in getting OBIEE to connect to an IBM Informix Database ? I have been working on the following all day with no success.

       

      I am using the IBM Informix 4.10.FC5DE (64-bit) ODBC Driver and the System DSN I have configured is passing the Connect tab 'Apply & Connection Test'   i.e. 'Test connection was successful'.

       

      However when I set up a Connection Pool to the System DSN in the BI Administration Tool the Metadata Import returns a 'The connection has failed.' message straight away.

       

      There are no useful diagnostics in the BI Admin Tool NQSAdminTool.log that tell me what the problem could be, I have also tried with the earlier IBM Informix 3.50.FC9 ODBC Driver with the same result, and have now completely run out of ideas to try to get this working so any help / ideas on what possibly could be wrong would be appreciated.

       

      Regards,

       

      Tom Rowe

        • 1. Re: BI Administration Tool - Metadata Import for IBM Informix Database  'The connection has failed.'
          Tom Rowe

          Further to my previous post I have managed to obtain the following Windows ODBC trace…

           

          admintool       1b8c-13c8     ENTER SQLDriverConnectW
                      HDBC                0x0000000000DDC6E0
                      HWND                0x0000000000000000
                      WCHAR *             0x000007FEF00B8F08 [      -3] "******\ 0"
                      SWORD                       -3
                      WCHAR *             0x000007FEF00B8F08
                      SWORD                       -3
                      SWORD *             0x0000000000000000
                      UWORD                        0 <SQL_DRIVER_NOPROMPT>

          admintool       1b8c-13c8     EXIT  SQLDriverConnectW  with return code -1 (SQL_ERROR)
                      HDBC                0x0000000000DDC6E0
                      HWND                0x0000000000000000
                      WCHAR *             0x000007FEF00B8F08 [      -3] "******\ 0"
                      SWORD                       -3
                      WCHAR *             0x000007FEF00B8F08
                      SWORD                       -3
                      SWORD *             0x0000000000000000
                      UWORD                        0 <SQL_DRIVER_NOPROMPT>

                      DIAG [S1000] [Informix][Informix ODBC Driver][I (-256)

          admintool       1b8c-13c8     ENTER SQLErrorW
                      HENV                0x0000000000000000
                      HDBC                0x0000000000DDC6E0
                      HSTMT               0x0000000000000000
                      WCHAR *             0x000000000012D5C0
                      SDWORD *            0x000000000012D544
                      WCHAR *             0x000000000012D5D0
                      SWORD                     1022
                      SWORD *             0x000000000012D540

          admintool       1b8c-13c8     EXIT  SQLErrorW  with return code 0 (SQL_SUCCESS)
                      HENV                0x0000000000000000
                      HDBC                0x0000000000DDC6E0
                      HSTMT               0x0000000000000000
                      WCHAR *             0x000000000012D5C0 [       5] "S1000"
                      SDWORD *            0x000000000012D544 (-256)
                      WCHAR *             0x000000000012D5D0 [      68] "[Informix][Informix ODBC Driver][I\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0"
                      SWORD                     1022
                      SWORD *             0x000000000012D540 (68)

          admintool       1b8c-13c8     ENTER SQLErrorW
                      HENV                0x0000000000000000
                      HDBC                0x0000000000DDC6E0
                      HSTMT               0x0000000000000000
                      WCHAR *             0x000000000012D5C0
                      SDWORD *            0x000000000012D544
                      WCHAR *             0x000000000012D5D0
                      SWORD                     1022
                      SWORD *             0x000000000012D540

          admintool       1b8c-13c8     EXIT  SQLErrorW  with return code 100 (SQL_NO_DATA_FOUND)
                      HENV                0x0000000000000000
                      HDBC                0x0000000000DDC6E0
                      HSTMT               0x0000000000000000
                      WCHAR *             0x000000000012D5C0
                      SDWORD *            0x000000000012D544
                      WCHAR *             0x000000000012D5D0
                      SWORD                     1022
                      SWORD *             0x000000000012D540

           

          From the following entry DIAG [S1000] [Informix][Informix ODBC Driver][I (-256). I have concluded that the problem may be that the Informix database I am connecting to has no Transaction Logging. 

           

          i.e. From Map SQLSTATE values to Informix error messages
          http://www-01.ibm.com/support/knowledgecenter/SSGU8G_11.70.0/com.ibm.odbc.doc/ids_odbc_236.htm

          S1000 = General Error

           

          And -256 from  Informix Dynamic Server v10.0 Error Messages

          http://publib.boulder.ibm.com/epubs/html/i1182660.html
          http://www-01.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.em.doc/errors.html

           

          -256  Transaction not available.

          You cannot begin a transaction in this database because it does not have a transaction log. In order to support transactions, you must start a transaction log. Refer to your Administrator's Guide for information on how to start a transaction log.

           

          Now the problem is we have always been able to connect to the database using Hyperion and according to our DBA's the database has never had Transaction logging set up. So it appears to me that  for some reason the BI Admin Tool believes that Transaction Logging is required is there anyway to change this behaviour ?