Support Article
Exception on opening Specifications not linked to Implementation
SA-57345
Summary
DatabaseException occurs while opening 'Specifications not linked to Implementations' from the Application profile landing page.
Error Messages
There was a problem getting a list: code: 0 SQLState: 57014 Message: ERROR: canceling statement due to user request
DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: canceling statement due to user request
| SQL Code: 0 | SQL State: 57014
Steps to Reproduce
- Navigate to Designer Studio > Application > Profile > Analysis
- Click the 'Specifications not linked to Implementations' link
Root Cause
A defect or configuration issue in the operating environment. The SQL query run by the report timed out.
Resolution
Make the following change to the operating environment:Create an index on pr4_rule_vw and pr_link_usecase.
Published July 23, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.