Refresh Data Warehouse OData Model job fails after an ODF-0918 attribute creation error

Products

• Clarity PPM SaaS

Issue/Introduction

The Refresh Data Warehouse OData Model job has failed after receiving a serious error on an attribute creation.

I created an attribute with the same Name and ID in the Cost Plan object and Cost Plan Details object.

The error was thrown when I tried to enable the second attribute for DWH

Resolution

Delete the attribute that caused the issue

Run the Load DWH

Run the Refresh Data Warehouse OData Model job once again.

Additional Information

bg-ca.log file error:

ERROR 2021-10-05 09:40:27,499 [Dispatch Refresh Data Warehouse OData Model : [email protected](tenant=clarity)] niku.njs (clarity:myuser:23039021__09DA92F5-192A-4497-A052-FEBF40A66E09:Refresh Data Warehouse OData Model) Data Warehouse OData Model refresh failed.
com.niku.union.reporting.odata.ODataServiceException: There was a problem creating the model.[DD Cloud OP][PostgreSQL JDBC Driver]Object has been closed.
 at com.ca.ppm.daas.client.DAASClient.getDataSourceRefreshModelStatus(DAASClient.java:766)
 at com.ca.ppm.daas.client.DAASClient.refreshDataSourceModel(DAASClient.java:711)
 at com.ca.ppm.daas.client.DAASClient.updateDataSource(DAASClient.java:670)
 at com.niku.reporting.odata.ODataSvcUpdateDataSourceCommand.updateDataSource(ODataSvcUpdateDataSourceCommand.java:181)
 at com.niku.reporting.odata.ODataSvcUpdateDataSourceCommand.updateDataSource(ODataSvcUpdateDataSourceCommand.java:126)
 at com.niku.reporting.odata.ODataSvcUpdateDataSourceCommand.updateDataSource(ODataSvcUpdateDataSourceCommand.java:92)
 at com.niku.reporting.odata.ODataSvcUpdateDataSourceCommand.execute(ODataSvcUpdateDataSourceCommand.java:60)
 at com.ca.ppm.daas.job.RefreshDWHODataEntities.scheduledEventFired(RefreshDWHODataEntities.java:45)
 at com.niku.njs.Dispatcher$BGTask.run(Dispatcher.java:746)
 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)