Clarity: Unable to create new Ideas.

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

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