A fix is available
APAR status
Closed as program error.
Error description
A query defined with the STRSCAN function on a column returns data for real time and short term history, but fails with an error when used to retrieve long term history. RECREATE INSTRUCTIONS: Create a query using the STRSCAN function, verify it returns real time and short term history, then modify the view to retrieve long term history data.
Local fix
Problem summary
A query defined with the STRSCAN function on a column fails with an error when used to retrieve long term history. A query defined with the STRSCAN function on a column returns data for real time and short term history, but fails with an error when used to retrieve long term history. An error message similar to the following will be seen in the portal server log: [IBM][CLI Drivcw.er] CLI0100E Wrong number of parameters. SQLSTATE=07001, GENERIC SQLSTATE: 07001, ERR: -99999
Problem conclusion
Modified code to use correct string scan function for ODBC data sources. The fix for this APAR is included in the following maintenance vehicle: | fix pack | 6.3.0-TIV-ITM-FP0003
Temporary fix
Comments
APAR Information
APAR number
IV50764
Reported component name
TEPS
Reported component ID
5724C04PS
Reported release
623
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-10-14
Closed date
2014-01-30
Last modified date
2014-08-08
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
TEPS
Fixed component ID
5724C04PS
Applicable component levels
R630 PSY
UP
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SSCTLMQ","label":"ITM Tivoli Enterprise Portal Server V6"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"623","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
08 August 2014