IBM Support

Error running RINVC007.rptdesign report.

Troubleshooting


Problem

Following error is received when running TUAM Invoice report: SQL statement does not return a ResultSet object. SQL error #1: DB2 SQL Error: SQLCODE=-420, SQLSTATE=22018, SQLERRMC=INTEGER, DRIVER=3.53.70

Symptom

Running TUAM Invoice report (RINVC007.rptdesign), following exceptions are received:

org.eclipse.birt.report.engine.api.EngineException: Cannot execute the statement.
SQL statement does not return a ResultSet object.
SQL error #1: DB2 SQL Error: SQLCODE=-420, SQLSTATE=22018,
SQLERRMC=INTEGER, DRIVER=3.53.70
.
.
.
Caused by: org.eclipse.birt.data.engine.core.DataException: Cannot execute the statement.
SQL statement does not return a ResultSet object.
SQL error #1: DB2 SQL Error: SQLCODE=-420, SQLSTATE=22018,
SQLERRMC=INTEGER, DRIVER=3.53.70
.
.
.
org.eclipse.birt.report.engine.api.EngineException: Invalid bound column name: TotalMoneyValue.

Resolving The Problem

The Maximo Base Service (MBS) framework uses the reports.xml file to load individual report information into the database.
This information is used at runtime - and determines items like whether or not report parameters are required.

If you look at the reports.xml file, for each of the reports that you have defined, the parameter values are not required. This is
shown in the example below - where the parameter's value for required is highlighted, and then specified as No, or 0.

If the parameters are required, this value must be set to Yes, or 1.



If the parameter field is set to yes in this file, its value can be seen in the UI in the Report Administration application. Below is an
example of a report with its required parameter value highlighted.



These values are then shown to the end user when he goes to execute a report. This is done on the individual report's request page.
Using this same example, you can see how the location parameter is defined as a required value with the orange asterisk (*).

If the user does not enter a value for this required parameter, and clicks submit on the request page - a message will display.
So - the MBS framework will not let the report's request be sent to the report engine - - unless the required parameter value is filled.

[{"Product":{"code":"SSFG5E","label":"Tivoli Service Automation Manager"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"General Information","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.2;7.2.0.1;7.2.1;7.2.2;7.2.2.1;7.2.2.2;7.2.3","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
17 June 2018

UID

swg21428639