SQL Server – Unable to retrieve View Information with view_target_id on MUX Grids

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

After Upgrade on SQL Server MUX Grid views will throw an error for some users (may happen on Projects or Ideas workspace)

Unable to retrieve View Information with view_target_id17 (ID may vary) 

STEPS TO REPRODUCE

1. Connect to Clarity MUX with admin user
2. Go to Project Grid or Ideas Grid

Expected Results: The views to work for display

Actual results: Error thrown in UI and unable to access the view in MUX - Error Unable to retrieve View Information with view_target_id17

Error in logs:

• com.ca.ppm.rest.exception.APIAppException: Unable to retrieve View Information with view_target_id17
• Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Error converting data type nvarchar to numeric.

Environment

Clarity 16.3.3

Cause

DE180565

Resolution

Targeted for fix in:

• Clarity 16.4.1
• Clarity 16.3.3 Patch 3 (16.3.3.3)
• Clarity 16.4.0 Patch 1 (16.4.0.1)

Workaround:

1. Create a new index on Clarity schema: 
   CREATE NONCLUSTERED INDEX Z_ODF_MVL_LOOKUPS ON odf_multi_valued_lookups (object, attribute) INCLUDE (value, pk_id);
2. Retry accessing the views