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.

Article Id: 51459
Status: Published
Updated On: 21-03-2018 06:14
Legacy Id: TEC531903
Products:
CA Identity Manager , CA Identity Governance , CA Identity Portal , STARTER PACK-CLARITY PPM
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: