Resolving JasperSoft Report Generation Issues with IDM Integration

Products

• CA Identity Suite

Issue/Introduction

This article provides a solution to a common issue encountered when generating reports after integrating JasperSoft with Identity Manager (IDM). The issue is characterized by error messages indicating a different datasource configuration in the cache, despite having correctly configured datasources.

Symptoms:

• - Some reports work, while others fail to generate
• - Error messages indicate a different datasource configuration in the cache
• - No clear indication of where to change the datasource configuration or where the parameter comes from

Example Error Message:

"ERROR SecureExceptionHandlerImpl,http-nio-8080-exec-1:125 - Error de conexión de la fuente de datos.. [TibcoSoftware][SQLServer JDBC Driver]Error establishing socket to <host:port> :. Reason: Connection timed out: connect com.jaspersoft.jasperserver.api.metadata.common.service.JSDataSourceConnectionFailedException: jsexception.error.creating.connection"

Environment

Jaspersoft version 8.2
Identity Manager version 14.5 (Virtual Appliance deploy type)

Cause

IP address configured in DataSource

Resolution

• - Review the DataSource configurations to ensure they are correct.
• - Check the error messages for any indications of a connection issue.
• - Verify the IP address configured in the DataSource.
• - Update the IP address to the correct value resolved the issue, allowing reports to generate successfully.
•