APAR status
Closed as program error.
Error description
The ODBC interface of both TM1 10.1.0 and TM1 10.1.0.1 aka TM1 10.1.0 FP1 Server for IBM AIX is broken.??????In an IBM AIX LPAR the customer installed ??- 64-bit TM1 9.5.2 Server for IBM AIX??- 64-bit unixODBC ODBC Driver Manager??- 64-bit Oracle Instant Client ODBC Driver Version 11????The customer configured the ODBC Connection. ??It worked.??????They uninstalled 64-bit TM1 9.5.2 Server for IBM AIX.??They installed 64-bit TM1 10.1.0 Server for IBM AIX.????It works with the ODBC test tool bin64\odbc_test.exe shipped with 64-bit TM1 10.1.0 Server for IBM AIX. But when using the TI Editor to preview a valid SQL query, it fails with the error message:?? TM1?? Unable to Open Connection to Database??????And in the TM1 server message logfile tm1server.log they found the corresponding error lines:????3866 [11] ERROR 2012-07-02 15:11:10.711 TM1.SQLAPI 01000[unixODBC][Driver Manager]Can't open lib '/opt/IBM/cognos/oracle/libsqora.so' : file not found?? ??3866 [11] ERROR 2012-07-02 15:11:10.711 TM1.SQLAPI E16) Cannot connect to ODBC data source "RT70_DEV" 01000[unixODBC][Driver Manager]Can't open lib '/opt/IBM/cognos/oracle/libsqora.so' : file not found????3866 [11] ERROR 2012-07-02 15:11:10.711 TM1.SQLAPI 08003[unixODBC][Driver Manager]Connnection does not exist??????The customer upgraded from 64-bit TM1 10.1.0 Server for IBM AIX to 64-bit TM1 10.1.0.1 aka TM1 10.1.0 FP1 Server for IBM AIX, but to no avail: ??The error persists.??
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Users * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Please upgrade to IBM Cognos TM1 10.1.1 or IBM Cognos TM1 * * 9.5.2 FP3 * ****************************************************************
Problem conclusion
Code Fix
Temporary fix
Comments
APAR Information
APAR number
PM68165
Reported component name
TM1 TURBO INTEG
Reported component ID
5724W49TI
Reported release
952
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-07-04
Closed date
2012-09-12
Last modified date
2012-12-14
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
TM1 TURBO INTEG
Fixed component ID
5724W49TI
Applicable component levels
RA11 PSN
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5.2","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
21 September 2021