IV29879: USING SUBSTR COLUMN FUNCTION AND ORACLE WAREHOUSE FAILS
Fixes are available
Closed as program error.
APAR Type: Field Approver Initials: mb Severity: 3 Reported Release: 622 Compid: 5724C04PS Tivoli Enterprise Portal Server ABSTRACT: Using substr column function and Oracle warehouse fails PROBLEM DESCRIPTION: When using the SUBSTR function on a column and the warehouse is configured for Oracle, then the requests are done via JDBC. In the JDBC code the translation is not done when the SUBSTR function wraps the column name. . RECREATE INSTRUCTIONS: Configure the TEPS for an Oracle Warehouse and then create a query that uses the SUBSTR function. .
When specifying a query to the Warehouse database, the long column names need to be specified in the query and not the short name. When the Oracle Warehouse is specified, the portal server eWAS JDBC code does not handle the translation properly and uses the short name which causes the query to fail with: KFWITM354E The Timespan request terminated with the following message: KFWITM217E: Request error java.sql.SQLException ORA-00904: "UNIXDISK"."MOUNTPT". Invalid identifier. The column name 'MOUNTPT' and table name 'UNIXDISK' in the above message will be different based on the agent table and column in the query.
The code was modified to parse out the SUBSTR( ) value and translate the column name. The fix for this APAR is contained in the following maintenance packages: | fix pack | 6.2.3-TIV-ITM-FP0003
Reported component name
Reported component ID
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fixed component name
Fixed component ID
Applicable component levels