Description:
Project cannot be launched to OWB or MSP when the Team object has a custom attribute lookup referencing Department browse.
With Microsoft Project (MSP) the project does not launch or give error.
With Open Workbench (OWB) you get the following error:
Error on Oracle:
Unable to open project XXXXX. An error occurred on the server: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00936: missing expression.
Error on SQL server:
Unable to open project XXXXX. An error occurred on the server: [CA Clarity][SQLServer JDBC Driver][SQLServer]
Must declare the scalar variable "@[email protected]"
Steps to Reproduce:
Expected Result: Expected Result: the project to opening without error
Actual Results: Oracle: Unable to open project XXXXX. An error occurred on the server: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00936: missing expression SQL Server: Must declare the scalar variable "@[email protected]"
Release: ESPCLA99000-13.2-Clarity-Extended Support Plus
Component:
Solution:
Workaround:
Deactivate the custom department lookup on the team object
STATUS/RESOLUTION:
Resolved in Clarity 13.3
Keywords: CLARITYKB, CLRT-70237, clarity13resolved, clarity133resolved