The Datamart Extraction job fails with an NBI_CFG_NO_PROJECT_OBS_ASSIGNMENT table reference on the log files

Document ID : KB000091696
Last Modified Date : 16/04/2018
Show Technical Document Details
Question:
The Datamart Extraction job fails with references to the NBI_CFG_NO_PROJECT_OBS_ASSIGNMENT table. How can I resolve this?

 
Answer:
1. Go to Administration > Datamart Settings page
2. Select at least 1 'Project Organizational Breakdown Structure Mapping' 
(Project OBS) by clicking the 'New' button and selecting one OBS Unit. 
3. Also add Resource OBS if a new button is present
4. Run the Datamart jobs afterwards 
Additional Information:
Please see below a snip of the bg-ca.log file:

ERROR 2018-04-13 15:35:23,660 [Dispatch SŠ 2018-04-13 2 Datamart Extraction : bg@CAPPMTAPP01 (tenant=clarity)] niku.njs (clarity:admin:5260960__9C2FA3D9-DF19-41B0-8D02-AD6B0B889656:SŠ 2018-04-13 2 Datamart Extraction) Error executing job: 5019008 
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] 
Executed: 
{call nbi_extract_sp()} 
Derived from statement: 
<?xml version="1.0" encoding="UTF-8"?> 
<statement location="datamartPMD.xml" id="nmc.extract_stmt" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="none" xmlns="http://schemas.niku.com/2002/pmd"> 
<sql dbVendor="all">