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.

Document ID : KB000051459
Last Modified Date : 14/02/2018
Show Technical Document Details

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.