Organization and Person CSV reports fail with "cannot execute statement" error

Technote (troubleshooting)


Problem(Abstract)

When running the Organization CSV or Person CSV reports from the Reports tab the following error is encountered:
org.eclipse.birt.report.engine.api.EngineException: Cannot execute the statement. SQL statement does not return a ResultSet object. SQL error #1: ORA-06550: line 1, column 7: PLS-00103: Encountered the symbol "<" when expecting one of the following: ( begin case declare exit for goto if loop mod null pragma raise return select update while with << continue close current delete fetch lock insert open rollback savepoint set sql execute commit for all merge pipe purge

Cause

The AtlasReportStrings.properties file is not configured correctly.

Resolving the problem

The following property in the AtlasReportStrings.properties file needs to be set to the main PSSAPL schema name. For example:

report.common.schemaname=PSSAPL

Rate this page:

(0 users)Average rating

Document information


More support for:

Atlas eDiscovery Process Management
Reports

Software version:

4.5.1, 4.5.2, 5.0.1, 6.0, 6.0.1, 6.0.1.1, 6.0.1.2, 6.0.1.3, 6.0.1.4

Operating system(s):

Linux, Solaris, Windows

Reference #:

1621299

Modified date:

2013-01-02

Translate my page

Machine Translation

Content navigation