Topic
  • 9 replies
  • Latest Post - ‏2011-07-29T02:11:11Z by Leank
Leank
Leank
6 Posts

Pinned topic Cognos 10 Postgres ODBC issue - Urgent

‏2011-07-26T20:14:18Z |
Hi Guys.
I have Cognos 10 on RedHat 64 bits server installed on Server2.Cognos is UP and working fine.
My problem is to create a datasource on Cognos Connection poiting to Postgres DB installed on server2.

Check the error msg when i Try to create a datasource on Cognos portal

RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: testDataSourceConnection
UDA-SQL-0569 Unable to load the driver manager library (libodbcinst.so)
UDA-SQL-0571 The operating system returned an error message ( libodbcinst.so: cannot open shared object file. No such file or directory)



I have the Postgres ODBC installed and working fine with unixODBC, I can connect using isql from server1 (where Cognos is installed) to server 2 (where Postgres DB is installed)

The files /etc/odbcinst.ini and /etc/odbc.ini were properly configured

And I also created a link for the file mentioned above , like below

root@srvlinux2 ~# ln -s /usr/lib64/psqlodbc.so /usr/lib64/libodbcinst.so


Could please someone help me or give me some tip?
Updated on 2011-07-29T02:11:11Z at 2011-07-29T02:11:11Z by Leank
  • OpherB
    OpherB
    664 Posts

    Re: Cognos 10 Postgres ODBC issue - Urgent

    ‏2011-07-26T22:36:21Z  
    Not sure, but maybe you should post this question on the Cognos 10 forum?
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: Cognos 10 Postgres ODBC issue - Urgent

    ‏2011-07-27T01:07:06Z  
    • OpherB
    • ‏2011-07-26T22:36:21Z
    Not sure, but maybe you should post this question on the Cognos 10 forum?
    The configuration information will be much the same for Cognos 8 or Cognos 10. Cognos is complaining that it can't find the required driver libraries. This is usually handled by the environment variables configured for the user session running the Cognos application. It usually requires setting the PATH, LD_LIBRARY_PATH, along with configuring your odbc.ini file. The steps are listed in the Cognos 10 Installation and Configuration Guide under the topic "Set Up Connections to Suppported UNIX or Linux ODBC Data Sources". Note also that the odbc driver must be 32-bit.
  • Leank
    Leank
    6 Posts

    Re: Cognos 10 Postgres ODBC issue - Urgent

    ‏2011-07-27T23:06:45Z  
    The configuration information will be much the same for Cognos 8 or Cognos 10. Cognos is complaining that it can't find the required driver libraries. This is usually handled by the environment variables configured for the user session running the Cognos application. It usually requires setting the PATH, LD_LIBRARY_PATH, along with configuring your odbc.ini file. The steps are listed in the Cognos 10 Installation and Configuration Guide under the topic "Set Up Connections to Suppported UNIX or Linux ODBC Data Sources". Note also that the odbc driver must be 32-bit.
    Hi Phil, thx for your answer.

    What do you mean with "odbc driver must be 32-bit" ?
    I have Cognos installed on a RedHat 64 Bits, even this way should I install a 32 bit driver for Postgres?

    Another things is that, I could notice that after installing the unixODBC was when I got the libriries like libodbcinst.so.1, and others, but I couldn't get the libodbcinst.so that appears on the error msg.

    I don't know why this library is missing, but for i can see this library doesn't come with Cognos, it's something delivered by unixODBC

    Below you can see the variables you have mentioned:

    *LD_LIBRARY_PATH*=/usr/lib:/usr/lib64:/opt/ibm/cognos/c10_64/bin64:/opt/ibm/cognos/c10_64/cgi-bin
    *PATH*=/usr/lib64/qt-3.3/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: Cognos 10 Postgres ODBC issue - Urgent

    ‏2011-07-28T00:12:43Z  
    • Leank
    • ‏2011-07-27T23:06:45Z
    Hi Phil, thx for your answer.

    What do you mean with "odbc driver must be 32-bit" ?
    I have Cognos installed on a RedHat 64 Bits, even this way should I install a 32 bit driver for Postgres?

    Another things is that, I could notice that after installing the unixODBC was when I got the libriries like libodbcinst.so.1, and others, but I couldn't get the libodbcinst.so that appears on the error msg.

    I don't know why this library is missing, but for i can see this library doesn't come with Cognos, it's something delivered by unixODBC

    Below you can see the variables you have mentioned:

    *LD_LIBRARY_PATH*=/usr/lib:/usr/lib64:/opt/ibm/cognos/c10_64/bin64:/opt/ibm/cognos/c10_64/cgi-bin
    *PATH*=/usr/lib64/qt-3.3/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin
    The Cognos Java components can be run as 64-bit but the query engine is still 32-bit. This means that you need the 32-bit database drivers to work with the 32-bit query engine.

    Frankly, I'm not sure why the unixODBC package wouldn't include the libodbcinst.so library.
  • Leank
    Leank
    6 Posts

    Re: Cognos 10 Postgres ODBC issue - Urgent

    ‏2011-07-28T17:28:47Z  
    The Cognos Java components can be run as 64-bit but the query engine is still 32-bit. This means that you need the 32-bit database drivers to work with the 32-bit query engine.

    Frankly, I'm not sure why the unixODBC package wouldn't include the libodbcinst.so library.
    Thx Phil.
    I will try to do few more tests, but honestly I don't have much hope for now, I've already did lot of things and didn't work.

    It's very strange Cognos be complaing about this missing library, because I've create a simbolyc link for it and even this way it didn't work.
    At this moment, I belive that it doesn't have nothing to do with Postgres Drive, because this library Cognos is complaining it's not part of postgres drive installation.

    Let me do more test, anything new I'll post here.
    Thx so far for your help.

    Regards
  • Leank
    Leank
    6 Posts

    Re: Cognos 10 Postgres ODBC issue - Urgent

    ‏2011-07-29T00:33:08Z  
    • Leank
    • ‏2011-07-28T17:28:47Z
    Thx Phil.
    I will try to do few more tests, but honestly I don't have much hope for now, I've already did lot of things and didn't work.

    It's very strange Cognos be complaing about this missing library, because I've create a simbolyc link for it and even this way it didn't work.
    At this moment, I belive that it doesn't have nothing to do with Postgres Drive, because this library Cognos is complaining it's not part of postgres drive installation.

    Let me do more test, anything new I'll post here.
    Thx so far for your help.

    Regards
    Hi Phil, I could fix the problem. Now I have a problem on Framework manager that is installed in another server, this one is Windows.
    I had to do the missing things below
    1. Install Postgres ODBC Driver 32 bits (as you suggested)
    2. Exported the variable ODBCINI poiting to the file *c10_local*/bin/.odbc.ini (before I was pointing to +c10_local+/bin64/.odbc.ini)
    3. Fixed the settings within .odbc.ini as below (the Driver before was pointing to lib64 folder, instead of just lib)

    postgres_db
    Driver = /usr/lib/libodbcpsql.so
    Servername = srvlinux1
    Database = post_db_teste
    Username = postgres
    Password = admin123
    Port = 5432
    Trace = Yes
    TraceFile = /tmp/trace_psqlodbc.log

    ==================================
    I could create and test the Datasouce within Cognos Portal, but when I tried to import the tables in Framework Manager, I couldn't.
    When I try to import something I can't even open the datasource into FM
    When I click on it it says the following error: (Check the attached image)

    QE-DEF-0323 DSN(ODBC)/ServiceName is invalid.
    UDA-SQL-0031 Not possible to access the database
    UDA-SQLL-0532 The datasource postgres_db2 is not accessible
    MicrosoftODBC Driver Manager The Datasource name was not found

    It's very strange to have this error while on Cognos Portal the Datasource test went ok. And it's strange that in the error msg says "Microsoft ODBC Driver Manager"

    Any idea?
  • Leank
    Leank
    6 Posts

    Re: Cognos 10 Postgres ODBC issue - Urgent

    ‏2011-07-29T00:33:27Z  
    • Leank
    • ‏2011-07-28T17:28:47Z
    Thx Phil.
    I will try to do few more tests, but honestly I don't have much hope for now, I've already did lot of things and didn't work.

    It's very strange Cognos be complaing about this missing library, because I've create a simbolyc link for it and even this way it didn't work.
    At this moment, I belive that it doesn't have nothing to do with Postgres Drive, because this library Cognos is complaining it's not part of postgres drive installation.

    Let me do more test, anything new I'll post here.
    Thx so far for your help.

    Regards
    Hi Phil, I could fix the problem. Now I have a problem on Framework manager that is installed in another server, this one is Windows.
    I had to do the missing things below
    1. Install Postgres ODBC Driver 32 bits (as you suggested)
    2. Exported the variable ODBCINI poiting to the file *c10_local*/bin/.odbc.ini (before I was pointing to +c10_local+/bin64/.odbc.ini)
    3. Fixed the settings within .odbc.ini as below (the Driver before was pointing to lib64 folder, instead of just lib)

    postgres_db2
    Driver = /usr/lib/libodbcpsql.so
    Servername = srvlinux1
    Database = post_db_teste
    Username = postgres
    Password = admin123
    Port = 5432
    Trace = Yes
    TraceFile = /tmp/trace_psqlodbc.log

    ==================================
    I could create and test the Datasouce within Cognos Portal, but when I tried to import the tables in Framework Manager, I couldn't.
    When I try to import something I can't even open the datasource into FM
    When I click on it it says the following error: (Check the attached image)

    QE-DEF-0323 DSN(ODBC)/ServiceName is invalid.
    UDA-SQL-0031 Not possible to access the database
    UDA-SQLL-0532 The datasource postgres_db2 is not accessible
    MicrosoftODBC Driver Manager The Datasource name was not found

    It's very strange to have this error while on Cognos Portal the Datasource test went ok. And it's strange that in the error msg says "Microsoft ODBC Driver Manager"

    Any idea?
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: Cognos 10 Postgres ODBC issue - Urgent

    ‏2011-07-29T00:40:36Z  
    • Leank
    • ‏2011-07-29T00:33:27Z
    Hi Phil, I could fix the problem. Now I have a problem on Framework manager that is installed in another server, this one is Windows.
    I had to do the missing things below
    1. Install Postgres ODBC Driver 32 bits (as you suggested)
    2. Exported the variable ODBCINI poiting to the file *c10_local*/bin/.odbc.ini (before I was pointing to +c10_local+/bin64/.odbc.ini)
    3. Fixed the settings within .odbc.ini as below (the Driver before was pointing to lib64 folder, instead of just lib)

    postgres_db2
    Driver = /usr/lib/libodbcpsql.so
    Servername = srvlinux1
    Database = post_db_teste
    Username = postgres
    Password = admin123
    Port = 5432
    Trace = Yes
    TraceFile = /tmp/trace_psqlodbc.log

    ==================================
    I could create and test the Datasouce within Cognos Portal, but when I tried to import the tables in Framework Manager, I couldn't.
    When I try to import something I can't even open the datasource into FM
    When I click on it it says the following error: (Check the attached image)

    QE-DEF-0323 DSN(ODBC)/ServiceName is invalid.
    UDA-SQL-0031 Not possible to access the database
    UDA-SQLL-0532 The datasource postgres_db2 is not accessible
    MicrosoftODBC Driver Manager The Datasource name was not found

    It's very strange to have this error while on Cognos Portal the Datasource test went ok. And it's strange that in the error msg says "Microsoft ODBC Driver Manager"

    Any idea?
    It's not so strange that you are getting a Microsoft ODBC message. Framework Manager makes its own connection to the database from the system where it is running. The Cognos server only supplies the connection information to the Framework Manager instance and does not process any of the actual queries that Framework Manager submits. To get Framework Manager working you will need to install and configure the 32-bit Postgres ODBC driver on the Windows system and name the connection the same as you have defined it on the Linux server.
  • Leank
    Leank
    6 Posts

    Re: Cognos 10 Postgres ODBC issue - Urgent

    ‏2011-07-29T02:11:11Z  
    It's not so strange that you are getting a Microsoft ODBC message. Framework Manager makes its own connection to the database from the system where it is running. The Cognos server only supplies the connection information to the Framework Manager instance and does not process any of the actual queries that Framework Manager submits. To get Framework Manager working you will need to install and configure the 32-bit Postgres ODBC driver on the Windows system and name the connection the same as you have defined it on the Linux server.
    Phil, really thx for you help, PROBLEM SOLVED NOW!!!
    As you said, i had to install the PostgresODBC on my Framework Manager PC, after that and after set the Datasource there with the same name as I did on Cognos Server, it worked fine.

    Thx again for your quick and efficiently answer.