Jasper Report - 'rptParamConn' does not exist

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: