ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Jaspersoft Report Error: 'There was an error on the server. Try again or contact site administrators. (Error UID: 8366f766-7926-41b4-b47e-34776582e79b)'

book

Article ID: 214024

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction


When running reports from the library,  an error message:
   'There was an error on the server. Try again or contact site administrators. (Error UID: 8366f766-7926-41b4-b47e-34776582e79b)'

 

Cause


Check the jasperserver.log file for errors. In this case, an UnknownHostException indicating that the OneClick server name was
   unable to be resolved.

 


/opt/CA/SharedComponents/CABI/apache-tomcat/webapps/jasperserver-pro/WEB-INF/logs/jasperserver.log

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2021-04-28 09:32:23,577 ERROR ErrorPageHandlerAction,http-nio-8080-exec-6:115 - Error UID 823b7577-15d5-4486-8795-888ef1bf007f
com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection
Arguments: 
 at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:61)
 at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BaseJdbcDataSource.setReportParameterValues(BaseJdbcDataSource.java:46)
 at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.setReportParameterValues(JdbcDataSourceService.java:66)
 at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1823)
 at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1159)
 at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1088)
 at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:983)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
 at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=oneclickserver)(port=3306)(type=master) : oneclickserver
 at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:156)
 at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:118)
 at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.throwException(ExceptionMapper.java:92)
 at org.mariadb.jdbc.Driver.connect(Driver.java:111)
 at java.sql.DriverManager.getConnection(DriverManager.java:664)
 at java.sql.DriverManager.getConnection(DriverManager.java:247)
 at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75)
 at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDriverManagerConnectionFactory.createConnection(JdbcDriverManagerConnectionFactory.java:33)
 at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
 at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1148)
 at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
 at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.TibcoDriverManagerImpl.unlockConnection(TibcoDriverManagerImpl.java:56)
 at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:53)
 ... 9 more
Caused by: java.sql.SQLException: Could not connect to address=(host=oneclickserver)(port=3306)(type=master) : oneclickserver
 at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1034)
 at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:483)
 at org.mariadb.jdbc.Driver.connect(Driver.java:106)
 ... 18 more
Caused by: java.net.UnknownHostException: oneclickserver
 at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:184)
 at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
 at java.net.Socket.connect(Socket.java:589)
 at java.net.Socket.connect(Socket.java:538)
 at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:400)
 at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1028)
 ... 20 more

Environment

Release : 20.2

CABI 7.1.1.1

Component : Spectrum Core / SpectroSERVER

Resolution


Check name resolution on the CABI/Jaspersoft server and make sure that the oneclick server name can be resolved.