search cancel

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

book

Article ID: 21146

calendar_today

Updated On:

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