APAR status
Closed as program error.
Error description
When define IA rule with HIVE connection, if column has an alias, order by need to use the alias instead of the original column name. Or will get error like: "Invalid table alias or column reference 'xxx': (possible column name are: xxxx).
Local fix
Problem summary
IA rule fails binded column of virtual table which has 'order by ' clause on a hive database
Problem conclusion
11502rup11, 11702sp1 has the fix
Temporary fix
Comments
APAR Information
APAR number
JR59665
Reported component name
WIS INFORM ANAL
Reported component ID
5724Q36IA
Reported release
B50
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-06-18
Closed date
2018-10-30
Last modified date
2018-10-30
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
WIS INFORM ANAL
Fixed component ID
5724Q36IA
Applicable component levels
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSZJLG","label":"InfoSphere Information Analyzer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B50","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
30 October 2018