Can't login to xFlow Column not found in table usp_contact

Products

• CA Service Management - Service Desk Manager

Issue/Introduction

Users can't login to xFlow/Service Point.

Whenever an user tries to login, these error messages show in xFlow-install-folder\APPS\logs\incidentMS.log file

ERROR - 2024-12-02 11:54:02 [c.ca.casm.framework.util.CasmFuture] - Exception occurred, see call stack for more details: userid ()
java.util.concurrent.CompletionException: com.ca.casm.exception.CasmBaseException: Error :  Column z_myfield not found in table usp_contact (subquery 1.0 SELECTION) at . z_myfield

where z_myfield could be any custom field

Environment

CA Service Desk Manager/xFlow 17.3 and higher

Resolution

Check the ddich.sch file in the Service Desk-install\site folder for this table

TABLE usp_contact LARGE LOW_VOLATILE {

...

}

You should see something like

TABLE usp_contact LARGE LOW_VOLATILE {

...
z_myfield STRING 50;
...
}

If not, then your custom field z_myfield customization is not complete and you would need to use Web Screen Painter

Using the Web Screen Painter (WSP)

to re-publish this custom field.

If the z_myfield does show in the table, please contact Broadcom Support.

 

 

 

Additional Information

Note: this can't login issue happens only when there is missing field in usp_contact table