Jasper Report - 'rptParamConn' does not exist

Article Id: 195402
Status: Published
Updated On: 17-07-2020 15:48
Products:
CA Identity Manager , CA Identity Governance , CA Identity Portal , CA Identity Suite
Issue/Introduction:

When trying to run a report you get the below error:

ERROR [com.netegrity.webapp.page.reporting.pages.JasperReportTabPage] (default task-62) jdbc connetion object : 'rptParamConn' does not exist - can not run report java.lang.StringIndexOutOfBoundsException: String index out of range: -1

Cause:

This can happen when you manually edit or alter the data source within Jasper Report Server

Environment:

Release : 14.3

Component : CA IDENTITY SUITE (VIRTUAL APPLIANCE)

Resolution:

In Jasper Server

  1. Delete the organization
  2. Create a new organization named IAM
  3. Create your user against the IAM organization
  4. Import the Oracle SQL reports
  5. Adjust permissions at the IAM level setting your created user from step 3 with read only access
  6. Navigate down to IAM > IM > datasources and right click datasources
  7. Set the permissions on the datasources folder as read + write for the user created in step 3. DO NOT EDIT THE DATASOURCE
  8. Navigate to IDM and create your snapshot.  
  9. Once the snapshot is created, request the report.  When you request the report, the datasource will be updated on Jasper Server. 

Additional Information:

IDM modifies the data source when you request the report.  See below:

Datasource after creating the organization:

Datasource after requesting the report:

Report Running: