Clarity PPM: Advanced Reporting Custom Report Error When Running

book

Article ID: 198442

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

After GCP migration to PostgreSQL database, running a custom report from Advanced Reporting is giving error:


The server has encountered an error. Please excuse the inconvenience.

Error Message

Exception getting data strategyexception getting dataset from cache

 

 

Cause

The report has not been converted/tested to run in the PostgreSQL database.

 

Environment

Release : 15.8

Component : CA PPM SAAS APPLICATION

Resolution

The report will need to be converted due to error in the jasperserver.log:


Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: null.
 at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:347)
 at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:166)
 at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.run(JSControlledJdbcQueryExecuter.java:154)
 at java.lang.Thread.run(Thread.java:748)
Caused by: org.postgresql.util.PSQLException: ERROR: function length(numeric) does not exist
  Hint: No function matches the given name and argument types. You might need to add explicit type casts.
  Position: 445