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 "@DBUSER@"

Document ID : KB000021146
Last Modified Date : 14/02/2018
Show Technical Document Details

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 "@DBUSER@"

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 "@DBUSER@"

Solution:

Workaround:
Deactivate the custom department lookup on the team object

STATUS/RESOLUTION:
Resolved in Clarity 13.3

Keywords: CLARITYKB, CLRT-70237, clarity13resolved, clarity133resolved