search cancel

IP - Failed to execute prepared statement

book

Article ID: 187340

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Governance CA Identity Portal CA Identity Suite

Issue/Introduction

When creating a user via the CA Identity Portal (IP) the following error is returned.


ERROR MESSAGE: Failed running query ; Failed to execute prepared statement: SELECT dbo.InitCap('User'); on data source: java:/iam/im/jdbc/jdbc/objectstore. Exception: Cannot find either column "dbo" or the user-defined function or aggregate "dbo.InitCap", or the name is ambiguous.; Cannot find either column "dbo" or the user-defined function or aggregate "dbo.InitCap", or the name is ambiguous.

 

Cause

This is the expected response to a SQL Data Elements problem.

Environment

Release : 14.x

Component : CA IDENTITY SUITE (VIRTUAL APPLIANCE)

Resolution

A SQL Data Element is missing or incorrectly configured in the CA Identity manager (IM) task associated with user creation.

After correcting the erroneous task the problem was resolved.

Additional Information

For more information on Data Elements please refer to the CA Identity Manager product documentation

(https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/layer7-identity-and-access-management/identity-manager/14-3/data-elements.html)