search cancel

After 16.1.0 Upgrade - Unable to Export Data to CSV - Modern Tasks

book

Article ID: 255581

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

When exporting out the tasks, the following errors appear in the BG logs:


ERROR 2022-12-05 16:26:46,030 [Dispatch Export to CSV Job : [email protected] (tenant=clarity)] union.persistence (clarity:user:session:Export to CSV Job) Exception on odf-pmd.oba_task.select-list-rest-api-conditional.map statement null
org.postgresql.util.PSQLException: ERROR: invalid reference to FROM-clause entry for table "inv____inv_investments"
  Hint: There is an entry for table "inv____inv_investments", but it cannot be referenced from this part of the query.
  Position: 7811
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356)
    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:181)
    at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:170)
    at jdk.internal.reflect.GeneratedMethodAccessor17.invoke(Unknown Source)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:118)
    at com.sun.proxy.$Proxy7.execute(Unknown Source)
    at com.niku.union.persistence.jdbc.SQLTracePreparedStatement.execute(SQLTracePreparedStatement.java:112)
    at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:3649)
    at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:926)
    at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:824)
    at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:626)
    at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:343)
    at com.niku.union.persistence.PersistenceConversation.process(PersistenceConversation.java:505)
    at com.ca.platform.osf.object.odata.EntitiesResponseImpl.getODFEntitiesList(EntitiesResponseImpl.java:117)
    at com.ca.platform.osf.object.odata.EntitiesResponseImpl.getODFEntities(EntitiesResponseImpl.java:99)
    at com.ca.platform.osf.object.rest.adapter.ODataODFObjectAdapter.getObjectInstances(ODataODFObjectAdapter.java:359)
    at com.ca.platform.osf.object.rest.adapter.ODataODFObjectAdapter.getObjectInstances(ODataODFObjectAdapter.java:265)
    at com.ca.platform.osf.object.rest.provider.ODFResourceProvider.getResources(ODFResourceProvider.java:1236)
    at com.ca.platform.osf.object.rest.provider.ODFResourceProvider.getEntities(ODFResourceProvider.java:208)
    at com.ca.ppm.rest.resource.BaseResourceHandler.retrieveResources(BaseResourceHandler.java:237)
    at com.ca.ppm.rest.resource.CustomerResourceHandler.retrieveResources(CustomerResourceHandler.java:98)
    at com.ca.ppm.rest.resource.CustomerResourceHandler.retrieveResources(CustomerResourceHandler.java:75)
    at com.ca.ppm.rest.client.RestApiJavaClient.doGet(RestApiJavaClient.java:154)
    at com.niku.njs.listeners.CSVExportJobListener.scheduledEventFired(CSVExportJobListener.java:206)
    at com.niku.njs.Dispatcher$BGTask.run(Dispatcher.java:759)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
    at java.base/java.lang.Thread.run(Thread.java:829)
ERROR 2022-12-05 16:26:46,030 [Dispatch Export to CSV Job : [email protected] (tenant=clarity)] odata.EntitiesResponseImpl (clarity:user:session:Export to CSV Job) Exception reading objects: oba_task
com.niku.union.persistence.PersistenceApplicationException

 

Environment

Release : 16.1.0

Resolution

This is a defect that is under investigation.

Note: If there are more than 500 records, the export will only contain headers, not the records/rows.