Error Message There was an error on the server. Try again or contact site administrators.

[Thanankit Phitchayaphatmethin]

Hi 

I got the issue with JasperServer below issue

I try to do with this link  https://knowledge.broadcom.com/external/article?articleNumber=200754  not working 

my log 

2024-11-11T13:16:50,919 ERROR SecureExceptionHandlerImpl,pool-15-thread-9:125 - There was an error on the server. Try again or contact site administrators. (Error UID: 9625f459-6abf-4222-9785-e5f61d9283c2). [TibcoSoftware][SQLServer JDBC Driver][SQLServer]Invalid object name 'imsAuditTaskSession12'. net.sf.jasperreports.engine.JRException: Error executing SQL statement for: Reset Password Report.
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:367)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:173)
    at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.createDatasource(JSControlledJdbcQueryExecuter.java:112)
    at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1286)
    at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:736)
    at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:458)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:586)
    at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:135)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:973)
    at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:181)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:924)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1895)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1186)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1123)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:998)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLSyntaxErrorException: [TibcoSoftware][SQLServer JDBC Driver][SQLServer]Invalid object name 'imsAuditTaskSession12'.
    at tibcosoftware.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1085)
    at tibcosoftware.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977)
    at tibcosoftware.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124)
    at tibcosoftware.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193)
    at tibcosoftware.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153)
    at tibcosoftware.jdbc.sqlserver.tds.s.a(TDSRequest.java:4126)
    at tibcosoftware.jdbc.sqlserver.tds.r.a(TDSRPCRequest.java:1063)
    at tibcosoftware.jdbc.sqlserver.tds.s.c(TDSRequest.java:4275)
    at tibcosoftware.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1895)
    at tibcosoftware.jdbc.sqlserverbase.go.bY(BaseStatement.java:632)
    at tibcosoftware.jdbc.sqlserverbase.go.B(BaseStatement.java:2661)
    at tibcosoftware.jdbc.sqlserverbase.fe.B(BasePreparedStatement.java:530)
    at tibcosoftware.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470)
    at tibcosoftware.jdbc.sqlserverbase.go.kw(BaseStatement.java:2354)
    at tibcosoftware.jdbc.sqlserverbase.fe.executeQuery(BasePreparedStatement.java:485)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:317)
    ... 17 more

[Florisvaldo Pereira]

Hi

Please, see if this another article helps

Error while trying to access CA Jasper Report from IM (Error UID: ab284ad7-718e-44d1-a629-2824ec0cf044)

1)First Test the Connection from the IM User Console

 

=> Tasks>System>Reporting>Report Server Connection

 

2) Fill in the details and click on the Test Connection Button

 

3) If the Test Connection is successfully, check the Tomcat Services status on Jasper Report Server

 

Restarting the Tomcat Services will resolve the issue

If issue persists, please open a Support case