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.

book

Article ID: 51459

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL CA Identity Manager CA Identity Governance CA Identity Portal Clarity PPM SaaS - Application 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:

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

Keywords: CLARITYKB.

Environment

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