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:
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"
Jaspersoft version 8.2
Identity Manager version 14.5 (Virtual Appliance deploy type)
IP address configured in DataSource