search cancel

Unable to create Idea from Template

book

Article ID: 243086

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

We are attempting to test the functionality of creating ideas from a template in our dev lower environment. Whenever we attempt to create an idea off a template, we get the error “API-1019 : Could not process the request due to internal error.”

We checked and made sure we had edit access to all the Clarity fields (even ones that no one should edit) just to be safe and still are getting the error. Reading the Broadcom documentation on creating idea templates did not show any steps we appear to have missed. Could you assist? Is there a setting/right we missed?

Cause

ERROR 2022-05-11 08:30:51,453 [http-nio-8082-exec-114] ppm.rest (clarity:admin:6504455__8662E903-8D88-404B-8A3C-4082FB1F58F5:PPM_REST_API) AbstractInvestmentTemplateCopier ::  Exception while creating instance [name: Test SaaS code: ID2621 ] from template id [ 5047003 ]. Error code: internal Error Msg: 
ERROR 2022-05-11 08:30:59,246 [http-nio-8082-exec-121] api.CopyProjectAPI (clarity:admin:6504455__8662E903-8D88-404B-8A3C-4082FB1F58F5:PPM_REST_API) copyBlueprintInfo exception 
com.niku.union.persistence.PersistenceException: 
SQL error code: 1427
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01427: single-row subquery returns more than one row


Executed:
 update inv_investments
             set odf_template_id = ?,
                 odf_blueprint_id = (select NVL( odf_blueprint_id,
                  (select id from odf_blueprints where is_system = 1 and type = NLS_UPPER( odf_object_code ))) from inv_investments where id = ?)
           where id = ? 

Environment

Release : 16.0.1

Component : Clarity MUX Blueprints and Administration

Resolution

The problem was that there are 2 system blueprints for Idea and there should only be one.

We ran below query and observed 2 records.

select * from odf_blueprints where is_system = 1 and type = 'IDEA'

To fix this we need to remove one of the custom blueprint that was designated as system one.