Clarity: Unable to create new Ideas.

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Description:

New Ideas cannot be created.
The error seem in the UI is 'System Error - Contact System Administrator'.
Idea creation was working fine until a Query based portlet was XOGged in. After that no new ideas could be created.

Error from the app-niku.log:

ERROR 2009-08-05 10:09:22,766 [http-80-Processor2] niku.xql2 (admin:6072433__
 44e3a6f4:pma.ideaCreateSave) Internal Processing exception
 com.niku.union.persistence.PersistenceException:
 SQL error code: 1400
 Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into ("CLARITY"."CMN_INSTANCE_PAGES"."PAGE_FRAME_ID")
 Executed:

Solution:

Add a default setting for Tabs on the Idea Layout Portlet page. It may have been removed during your portlet or idea object XOG.

Steps to fix the problem:

1. Click on Admin tool/Portlet pages/Idea Layout/tabs/
   
   NOTE: One of the tabas should have a button beside it indicating it is the default tab.
   
   
2. If no default tab is selected, select one and click the Save button.

Keywords: CLARITYKB, studio, xml open gateway, auto-numbering

Environment

Release: NCSVCS05900-8.1-Clarity-Service Connect-for MS-SQL
Component: