IBM Support

Getting RSV-VAL-0004 when running a report based on custom SQL

Troubleshooting


Problem

Validating the SQL is successful but running a list report based on the SQL query fails with RSV-VAL-0004

Symptom

The SQL was copied from an email or another tool

Cause

There are invalid symbol(s) at the end of the SQL. The symbols might be invisible.

Resolving The Problem

Remove end of the SQL text and type it again

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0.x","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
10 December 2018

UID

ibm10787587