Unable to enable an existing blueprint

Products

• Clarity PPM SaaS
• Clarity FedRAMP
• Clarity PPM On Premise

Issue/Introduction

Trying to edit an existing blueprint and getting an error API-1019 : Could not process the request due to internal error. Reviewing the app ca logs below errors are seen

Caused by: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

Environment

All Supported Clarity Version 

Cause

The error is occurring because there are two draft statuses for a single blueprint, whereas there should be only one.

Resolution

• Run the below query to check the duplicate blueprint

  select cab.name,ob.id,ob.type,ob.publish_target_id  from odf_blueprints ob, odf_abstract_blueprints cab
  where exists(select publish_target_id,count(1) from odf_blueprints p where p.blueprint_mode ='DRAFT'
  and p.publish_target_id =ob.publish_target_id 
  group by publish_target_id having count(1) > 1 )
  and ob.id = cab.id;

• Now open an working blueprint in the MUX https://Clarity/pm/#/admin/blueprints/XXX/view
• Now take the ID from the above query and replace the XXX in the URL, this will ensure the blueprint is seen and there will be Discard Edits button
• Click on Discard Edit and it will clear way the duplicate and blueprint should be editable