Datamart Extraction Job Fails with Error: Project or Resource OBS assignments are not setup

book

Article ID: 206944

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

The job fails with

ERROR 2021-01-20 22:02:49,466 [Dispatch Datamart Extraction : [email protected](tenant=clarity)] niku.njs (clarity:admin:xxxx:Datamart Extraction) Error executing job: 5026007
com.niku.union.persistence.PersistenceException: 
SQL error code: 50000
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]NBI_CFG_NO_PROJECT_OBS_ASSIGNMENT - Project or Resource OBS assignments are not setup
SQL error code: 50000
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer] 

Cause

Created OBS do not have Associated Objects (Project, Resource)

Environment

All Clarity versions

Resolution

1. From the Administration > Organization and Access > OBS, 
Select an OBS to associate the objects. Save.

2. Go to Administration > Data Administration > Datamart Settings to have the mapping set for both the 
Project Organizational Breakdown Structure mapping and the Resource Organizational Breakdown Structure.


 

Attachments