How to resolve the error generated while adding a new user defined field to the "Task In Progress" table in IBM Case Analyzer

Troubleshooting

Problem

If a Case Analyzer store is upgraded to 5.5.x, the user might not be able to add new user-defined fields to the Task In Progress table. This issue does not occur with new 5.5.x Case Analyzer installations.

Symptom

The following type of error occurs when attempting to add a new user-defined field to the Task In Progress table:

[Error] [CaseAnalyzer_Store] UDFAdmin::nearTermViewUpdate:F_DMTaskWIP - Column names in each view or function must be unique. Column name 'VMAE_CustomerName_key' in view or function 'V_F_DMTaskWIP' is specified more than once. ; Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Column names in each view or function must be unique. Column name 'VMAE_CustomerName_key' in view or function 'V_F_DMTaskWIP' is specified more than once.

Document Location

Worldwide

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTHRT","label":"IBM Case Foundation"},"Component":"Case Analyzer","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.5.x","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Was this topic helpful?

Document Information

More support for:
IBM Case Foundation

Software version:
5.5.x

Document number:
1104207

Modified date:
15 November 2019

UID

ibm11104207

IBM Support

Tips