ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

CA Identity Manager CA Identity Governance CA Identity Portal 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:
Powered by Wolken Software