Clarity OWB and MSP: projects will not launch with custom team department lookup; Oracle: ORA-00936: missing expression or SQL Server: Must declare the scalar variable "@[email protected]"

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

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:

1. Navigate to Administration > Objects > Team
2. Click on Attributes
3. Click on New
4. Select Data Type = Lookup - String
5. Navigate to the Department browse text lookup and select it
6. Enter lookuptest for name and ID
7. Save the attribute
8. Navigate to the application
9. Find a project set to open in OWB
10. Launch the project to OWB

 

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]"

 

Environment

Release: ESPCLA99000-13.2-Clarity-Extended Support Plus
Component:

Resolution

Solution:

Workaround:
Deactivate the custom department lookup on the team object

STATUS/RESOLUTION:
Resolved in Clarity 13.3

Keywords: CLARITYKB, CLRT-70237, clarity13resolved, clarity133resolved