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?
Release : 16.0.1
Component : Clarity MUX Blueprints and Administration
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
SQL error code: 1427
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01427: single-row subquery returns more than one row
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 = ?
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.