APAR status
Closed as fixed if next.
Error description
"Rules created in 811 that are against a Virtual table that has a Where clause which contains quoted strings, wherein the quote is escaped by a \ character, fail with a SQL error when they are executed in 812. Workaround is to edit the Where clause and remove the \ character."
Local fix
Problem summary
**************************************************************** USERS AFFECTED: Information Analyzer 8.1.2 users that upgraded from an 8.1.1 system. **************************************************************** PROBLEM DESCRIPTION: Rules created in Information Analyzer 8.1.1 that are against a Virtual table that has a Where clause which contains quoted strings, wherein the quote is escaped by a \ character, fail with a SQL error when they are executed in Information Analyzer 8.1.2. **************************************************************** RECOMMENDATION: Upgrade to Information Analyzer 8.1.2 Fix Pack 4, or 8.5 Fix Pack 1, or 8.7. ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
JR37546
Reported component name
WIS INFORM ANAL
Reported component ID
5724Q36IA
Reported release
812
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-08-19
Closed date
2010-09-08
Last modified date
2012-01-20
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
R812 PSN
UP
[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSZJLG","label":"InfoSphere Information Analyzer"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1.2"}]
Document Information
Modified date:
12 October 2021