Description:
When opening a project through Open Workbench, it is throwing "ORA-01795: maximum number of expressions in a list is 1000" error and unable to open the project.
This project contains around 1600 tasks and unable to provide RMP copy of the project. We are using OWB 1.1.6.
This issue also occurs for Master Projects with more than 1,000 subproject dependencies.
Steps to Reproduce:
Expected Results: The project should open in Open Workbench.
Actual Results: Receive error 'Unable to open project. An error occurred on the server: ORA-01795: maximum number of expressions in a list is 1000. Retry the operation and if the failure continues, contact your support personnel."
Solution:
WORKAROUND:
Remove the extra dependencies and the project will open in OWB or split the master project into two projects in order to allow to add more dependencies.
STATUS/RESOLUTION:
This issue has been documented as CLRT-22303 and is assigned to development for review. If you are experiencing this problem and the workaround above does not significantly help, please contact CA Clarity Technical Support.
Keywords: CLARITYKB, CLRT-22303, clarity8open, clarity12open.