When i execute report error happen like that. May i know how to resolve it.

[Toe San]

2024-02-07T02:01:56,634 ERROR SecureExceptionHandlerImpl,pool-9-thread-47:125 - There was an error on the server. Try again or contact site administrators. (Error UID: 0aeb4af5-1dfc-4cd9-ad32-2e73acd23f2b) com.jaspersoft.jasperserver.api.ErrorDescriptorException: There was an error on the server. Try again or contact site administrators. (Error UID: 35802855-3321-4337-89e0-997f18edcfde)
        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:748)

2024-02-07T02:04:53,725 DEBUG JRJdbcQueryExecuter,pool-7-thread-20:154 - DB is MySQL version 8.0.33 (8/0)
2024-02-07T02:04:53,725 DEBUG JRJdbcQueryExecuter,pool-7-thread-20:158 - driver is MariaDB Connector/J version 2.5.3 (2/5)
2024-02-07T02:04:53,725 DEBUG JRJdbcQueryExecuter,pool-7-thread-20:162 - jdbc 4/2
2024-02-07T02:04:53,725 DEBUG JRJdbcQueryExecuter,pool-7-thread-20:164 - connection URL is jdbc:mysql://xxxx.rds.amazonaws.com:6055/XXXTransactionEngine_ttt?tinyInt1isBit=false
2024-02-07T02:04:53,725 DEBUG JRJdbcQueryExecuter,pool-7-thread-20:206 - system timezone is sun.util.calendar.ZoneInfo[id="Etc/UTC",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null]
2024-02-07T02:04:53,725 DEBUG JRJdbcQueryExecuter,pool-7-thread-20:207 - report timezone is sun.util.calendar.ZoneInfo[id="Etc/UTC",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null]
2024-02-07T02:04:53,725 DEBUG JRJdbcQueryExecuter,pool-7-thread-20:208 - JDBC timezone parameter is null
2024-02-07T02:04:53,725 DEBUG JRJdbcQueryExecuter,pool-7-thread-20:209 - JDBC timezone property is null
2024-02-07T02:04:53,725 DEBUG JRJdbcQueryExecuter,pool-7-thread-20:215 - JDBC parameters timezone parameter is null
2024-02-07T02:04:53,725 DEBUG JRJdbcQueryExecuter,pool-7-thread-20:227 - JDBC parameters timezone property is null
2024-02-07T02:04:53,725 DEBUG JRJdbcQueryExecuter,pool-7-thread-20:234 - parameters timezone null
2024-02-07T02:04:53,725 DEBUG JRJdbcQueryExecuter,pool-7-thread-20:240 - JDBC fields timezone parameter is null
2024-02-07T02:04:53,725 DEBUG JRJdbcQueryExecuter,pool-7-thread-20:252 - JDBC fields timezone property is null
2024-02-07T02:04:53,725 DEBUG JRJdbcQueryExecuter,pool-7-thread-20:259 - fields timezone null
2024-02-07T02:04:53,726 DEBUG JRJdbcQueryExecuter,pool-7-thread-20:382 - SQL query string: SELECT CAST(
          userAcc.UserAccountUniqueId AS CHAR
        ) AccountUniqueId,
        (
          CASE WHEN userAcc.Accountstatus = '1' THEN 'Active' WHEN userAcc.Accountstatus = '11' THEN 'Locked' WHEN userAcc.Accountstatus = '5' THEN 'BlackListed' WHEN userAcc.Accountstatus = '7' THEN 'Blocked' WHEN userAcc.Accountstatus = '2' THEN 'Registered' WHEN userAcc.Accountstatus = '9' THEN 'InActive' WHEN userAcc.Accountstatus = '4' THEN 'Terminated' ELSE '-' END
    ) AS AccountStatus,
    userAcc.KycLevel,
    IFNULL(LEFT(
          JSON_UNQUOTE(
            JSON_EXTRACT(
              userAcc.KycDetail, '$.PERSONAL_INFO.DOB'
            )
      ),10),'-') AS DOB,
    DATE_ADD(DATE_ADD(userAcc.CreateDate, INTERVAL + 6 HOUR),INTERVAL + 30 MINUTE) as RegDate,
    UserAccountUniqueIdInt ,
    uc.Name  as UserCategory
    ,TRIM( TRAILING ']' FROM TRIM(LEADING '[' FROM REPLACE(JSON_EXTRACT(KycDetail, '$.*.MSISDN'), '"', ''))) AS MSISDN
        ,TRIM( TRAILING ']' FROM TRIM(LEADING '[' FROM REPLACE(JSON_EXTRACT(KycDetail, '$.*.FULL_NAME'), '"', '') )) AS FULL_NAME
        ,TRIM( TRAILING ']' FROM TRIM(LEADING '[' FROM REPLACE(JSON_EXTRACT(KycDetail, '$.*.ID_TYPE'), '"', '') )) as ID_TYPE
        ,TRIM( TRAILING ']' FROM TRIM(LEADING '[' FROM REPLACE(JSON_EXTRACT(KycDetail, '$.IDENTITY_VERIFY.NRCID.NRC_ID'), '"', '') )) as NRC_ID
   ,TRIM( TRAILING ']' FROM TRIM(LEADING '[' FROM REPLACE(JSON_EXTRACT(KycDetail, '$.*.*.PASSPORT_ID'), '"', '') )) as PASSPORT_ID
        ,TRIM( TRAILING ']' FROM TRIM(LEADING '[' FROM REPLACE(JSON_EXTRACT(KycDetail, '$.*.*.DRIVING_LICENSE_NUMBER'), '"', ''))) as DRIVING_LICENSE_NUMBER
    ,TRIM( TRAILING ']' FROM TRIM(LEADING '[' FROM REPLACE(JSON_EXTRACT(KycDetail, '$.*.*.ADDRESS'), '"', '') )) AS ADDRESS
,(SELECT DISTINCT StateName
    FROM BG5x.StateCode
    WHERE
      StateCode = TRIM(TRAILING ']' FROM TRIM(LEADING '[' FROM REPLACE(JSON_EXTRACT(KycDetail, '$.*.*.STATE'), '"', '') ))
  ) AS State
  ,(SELECT DISTINCT DistrictName
    FROM BG5x.StateCode
    WHERE
      DistrictCode = TRIM(TRAILING ']' FROM TRIM(LEADING '[' FROM REPLACE(JSON_EXTRACT(KycDetail, '$.*.*.CITY'), '"', '') ))
      AND TownCode = TRIM(TRAILING ']' FROM TRIM(LEADING '[' FROM REPLACE(JSON_EXTRACT(KycDetail, '$.*.*.TOWNSHIP'), '"', '') ))
  ) AS District
,(SELECT DISTINCT TownName
    FROM BG5x.StateCode
    WHERE
      TownCode = TRIM(TRAILING ']' FROM TRIM(LEADING '[' FROM REPLACE(JSON_EXTRACT(KycDetail, '$.*.*.TOWNSHIP'), '"', '') ))
  ) AS Township
  FROM
    MobifinEliteTransactionEngine_CCN.TBLUserAccount userAcc
        LEFT JOIN MobifinEliteAdmin_CCN.TBLMOperatingEntity oe ON oe.ExternalId = userAcc.UserEntityId
        LEFT JOIN MobifinEliteAdmin_CCN.TBLMUserCategory uc ON uc.UserCategoryId = oe.UserCategoryId
        WHERE userAcc.Accountstatus <> 4
        AND uc.Name = 'Consumer Category'
        AND
TRIM( TRAILING ']' FROM TRIM(LEADING '[' FROM REPLACE(JSON_EXTRACT(KycDetail, '$.IDENTITY_VERIFY.NRCID.NRC_ID'), '"', '') ))
in
(
#----343 NRC duplicate
select distinct NRC_ID
                from
                (
                        select NRC_ID ,count(distinct AccountUniqueId) dupcnt from
                        (

                                SELECT CAST(
                                  userAcc.UserAccountUniqueId AS CHAR
                                ) AccountUniqueId,
                          TRIM( TRAILING ']' FROM TRIM(LEADING '[' FROM REPLACE(JSON_EXTRACT(KycDetail, '$.IDENTITY_VERIFY.NRCID.NRC_ID'), '"', '') )) as NRC_ID,
                          uc.Name as UserCategory
                           FROM
                            MobifinEliteTransactionEngine_CCN.TBLUserAccount userAcc
                            LEFT JOIN MobifinEliteAdmin_CCN.TBLMOperatingEntity oe ON oe.ExternalId = userAcc.UserEntityId
        LEFT JOIN MobifinEliteAdmin_CCN.TBLMUserCategory uc ON uc.UserCategoryId = oe.UserCategoryId
                                WHERE userAcc.Accountstatus  <> 4
                        )aa
                        where (NRC_ID is not null and LENGTH(NRC_ID)>1)
                        and NRC_ID
                        NOT in ('1/AAAA(N)000000' , '1/AAAA(N)000000','12/AAAA(N)111111','12/ERW/LSLLA/AS1','6/AAA(N)000000',
                                        '00000,'Vacant CSR')
                        and UserCategory = 'Consumer Category'
                        group by 1
                        having count(distinct AccountUniqueId)  > 1
                )aa
 );

2024-02-07T02:04:53,726 DEBUG JRJdbcQueryExecuter,pool-7-thread-20:307 - Executing query
2024-02-07T02:05:04,773 DEBUG JRJdbcQueryExecuter,pool-7-thread-20:322 - Query execution done
2024-02-07T02:05:04,846 ERROR SecureExceptionHandlerImpl,pool-9-thread-49:125 - There was an error on the server. Try again or contact site administrators. (Error UID: b117dd2f-7775-4ece-a651-3226124d0ebb) java.lang.NoClassDefFoundError: Could not initialize class net.sf.jasperreports.engine.util.JRStyledTextParser
        at net.sf.jasperreports.engine.fill.JRBaseFiller.<init>(JRBaseFiller.java:114)
        at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:82)
        at net.sf.jasperreports.engine.fill.JRFiller.createBandReportFiller(JRFiller.java:251)
        at net.sf.jasperreports.engine.fill.JRFiller.createReportFiller(JRFiller.java:272)
        at net.sf.jasperreports.engine.fill.BaseFillHandle.<init>(BaseFillHandle.java:86)
        at net.sf.jasperreports.engine.fill.BaseFillHandle.<init>(BaseFillHandle.java:69)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousFillHandle.<init>(EngineServiceImpl.java:943)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:893)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillQueryReport(EngineServiceImpl.java:2058)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1896)
        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:748)

2024-02-07T02:05:04,846 ERROR SecureExceptionHandlerImpl,pool-9-thread-50:125 - There was an error on the server. Try again or contact site administrators. (Error UID: dccf8415-fb8d-4446-8701-c0211e5546ef) com.jaspersoft.jasperserver.api.ErrorDescriptorException: There was an error on the server. Try again or contact site administrators. (Error UID: b117dd2f-7775-4ece-a651-3226124d0ebb)
        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)

[schubar_js]

Hi @Toe San,

could be multiple reasons:

• outdated or incompatible  jasperreports library (upgrade may help)
• Headless mode issue -Djava.awt.headless=true in the startup script or the  vm options 
• missing system fonts (try installing ttf-dejavu)

[shreekrishna.shankhwar]

Simple is to first test these reports on studio then try on Jasper server. These kind of issue need step by step to check everything . So please take help from your Colleagues.