Jump to content
We've recently updated our Privacy Statement, available here ×

erik.dittert

Members
  • Posts

    52
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Posts posted by erik.dittert

  1. Hi,

    i use jasperserver 8.1.0, ROLE_ADMINISTRATOR is allow to see stacktrace in error message, but it shows only "last part" of error:

    converted-file.png.16e1b6d8d91b514fe5bf1c386a30e68a.png

     

    how to show full error like on logs:

    2023-10-09T11:13:05,209 ERROR SecureExceptionHandlerImpl,pool-9-thread-12403:125 - Error executing SQL statement for: Auftragswerte. (Fehler-UID: f6c80f03-f198-492c-98fc-9f0d9aab034e). ERROR: syntax error at or near "on"
      Position: 2057 net.sf.jasperreports.engine.JRException: Error executing SQL statement for: Auftragswerte.
        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 net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1273)
        at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:734)
        at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:457)
        at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:585)
        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:972)
        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:923)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1894)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1185)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1122)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:997)
        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:750)
    Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "on"
      Position: 2057
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355)
        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490)
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408)
        at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:167)
        at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:119)
        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)
        ... 16 more

    2023-10-09T11:13:05,210 ERROR SecureExceptionHandlerImpl,pool-9-thread-12402:125 - Error executing SQL statement for: Auftragswerte. (Fehler-UID: f6c80f03-f198-492c-98fc-9f0d9aab034e) (Fehler-UID: a5d4688e-f3bd-4cbf-8e94-8e905327d184) com.jaspersoft.jasperserver.api.ErrorDescriptorException: Error executing SQL statement for: Auftragswerte. (Fehler-UID: f6c80f03-f198-492c-98fc-9f0d9aab034e)
        at com.jaspersoft.jasperserver.remote.services.ReportExecution.getFinalReportUnitResult(ReportExecution.java:173)
        at com.jaspersoft.jasperserver.remote.services.impl.RunReportServiceImpl$2.run(RunReportServiceImpl.java:498)
        at com.jaspersoft.jasperserver.api.logging.util.LoggableExecutorService$1.run(LoggableExecutorService.java:84)
        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:750)

    Thx!

    Erik

  2. Hi,

    I am unsuccessfully trying to authenticate Jasperserver to my ldap server.

    I used current jasperserver version 8.1.0, i copied file from samples to /opt/bitnami/jasperreports/WEB-INF/applicationContext-externalAuth-LDAP.xml

    Changed logs to in /opt/bitnami/jasperreports/WEB-INF/log4j2.properties to:

    # Security Logging
    logger.com_jaspersoft_jasperserver_api_security.name=com.jaspersoft.jasperserver.api.security
    logger.com_jaspersoft_jasperserver_api_security.level=INFO

     

    and logs say:

    2023-03-26T18:42:01,760  INFO JSLdapContextSource,main:76 -  URL 'ldap://192.168.62.30:7389/dc=gut,dc=xxxxx', root DN is 'dc=gut,dc=xxxx'
    2023-03-26T18:42:11,045  WARN SecurityConfiguration,ajp-nio-127.0.0.1-8009-exec-1:194 - SECURITY for [iNPUT-VALIDATION] is OFF
    2023-03-26T18:42:11,047  WARN SecurityConfiguration,ajp-nio-127.0.0.1-8009-exec-1:194 - SECURITY for [sql-INJECTION] is OFF
    2023-03-26T18:42:11,048  WARN SecurityConfiguration,ajp-nio-127.0.0.1-8009-exec-1:194 - SECURITY for [ENCRYPTION] is OFF
    2023-03-26T18:42:11,048  WARN JSDelegatingFilterProxy,ajp-nio-127.0.0.1-8009-exec-1:97 - casSingleSignOutFilter bean was not "dropped into" application context.  Using class com.jaspersoft.jasperserver.war.NullFilter instead.
    2023-03-26T18:42:11,049  WARN JSDelegatingFilterProxy,ajp-nio-127.0.0.1-8009-exec-1:93 - Filter proxy bean nullFilter discovered.
    2023-03-26T18:42:11,078  WARN JSDelegatingFilterProxy,ajp-nio-127.0.0.1-8009-exec-1:97 - proxyPreAuthenticatedProcessingFilter bean was not "dropped into" application context.  Using class com.jaspersoft.jasperserver.war.NullFilter instead.
    2023-03-26T18:42:11,079  WARN JSDelegatingFilterProxy,ajp-nio-127.0.0.1-8009-exec-1:97 - proxyAuthenticationProcessingFilter bean was not "dropped into" application context.  Using class com.jaspersoft.jasperserver.api.security.EncryptionAuthenticationProcessingFilter instead.
    2023-03-26T18:42:11,080  WARN JSDelegatingFilterProxy,ajp-nio-127.0.0.1-8009-exec-1:93 - Filter proxy bean proxyBasicProcessingFilter discovered.
    2023-03-26T18:42:11,081  WARN JSDelegatingFilterProxy,ajp-nio-127.0.0.1-8009-exec-1:93 - Filter proxy bean proxyRequestParameterAuthenticationFilter discovered.
    2023-03-26T18:42:11,083  WARN JSDelegatingFilterProxy,ajp-nio-127.0.0.1-8009-exec-1:97 - corsFilter bean was not "dropped into" application context.  Using class org.springframework.web.filter.CorsFilter instead.
    2023-03-26T18:42:11,086  WARN JSDelegatingFilterProxy,ajp-nio-127.0.0.1-8009-exec-1:97 - proxyExceptionTranslationFilter bean was not "dropped into" application context.  Using class org.springframework.security.web.access.ExceptionTranslationFilter instead.
    2023-03-26T18:42:49,677  WARN EncryptionAuthenticationProcessingFilter,ajp-nio-127.0.0.1-8009-exec-2:85 - Deprecated username parameter used to obtain it from request! switch to new parameter name.
    2023-03-26T18:50:56,595  WARN EncryptionAuthenticationProcessingFilter,ajp-nio-127.0.0.1-8009-exec-9:85 - Deprecated username parameter used to obtain it from request! switch to new parameter name.

    i dont know what "Deprecated username parameter used to obtain it from request! switch to new parameter name." could mean.

    i attached my applicationContext-externalAuth-LDAP.xml.

    could some tell me what i do wrong?

     

     

     

     

×
×
  • Create New...