Clarity: Error when trying to XOG In a new project: Cannot insert the value NULL into column 'PAGE_FRAME_ID', table 'ClarityPPM.niku.CMN_INSTANCE_PAGES'; column does not allow nulls. INSERT fails.

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Description:

Error when trying to XOG In a new project: Cannot insert the value NULL into column 'PAGE_FRAME_ID', table 'ClarityPPM.niku.CMN_INSTANCE_PAGES'; column does not allow nulls. INSERT fails.

XOGOutput error

<Severity>FATAL</Severity>   
<Description>Project Object insert failed</Description>   
? <Exception>   
? <![CDATA[ java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]
  Cannot insert the value NULL into column 'PAGE_FRAME_ID', table   
  'ClarityPPM.niku.CMN_INSTANCE_PAGES'; column does not allow nulls. INSERT fails.   
  <column name="ID">5002446</column>   
  <column name="name">GTBC Teste Proj PC XOG</column>   
  <column name="UNIQUE_NAME">000262</column>   
  </KeyInformation>   
? <ErrorInformation>   
<Severity>WARNING</Severity>   
<Description>OBS id (bes_location) is invalid. So, the OBS Association was not made.</Description>

Solution:

1. Admin Tool > CA Clarity Studio: Portlet Pages.
   
   
2. Filter for "The Project Default Layout".
   
   
3. In Tabs verify the "default" column to have one page set as default. Make sure there is a default tab set.
   
   
4. Try the XOG again.

Keywords: CLARITYKB.

Environment

Release: ESPCLA99000-12.1-Clarity-Extended Support Plus
Component: