Failed to Execute the RequestUserToService Task

Products

• CA Identity Manager
• CA Identity Suite

Issue/Introduction

https://techdocs.broadcom.com/us/en/symantec-security-software/identity-security/identity-manager/14-5/Release-Notes/known-issues/general-issues.html

 

Caused by: Error : 1843, Position : 279, Sql = INSERT INTO "FWSERVICE_REQUEST_HISTORY"("ENV_OID", "DURATION", "USERID", "CHANGEDATE", "CHANGE", "ACTIONSTEP", "ACTIONLEVEL", "SERVICETAG", "STATUS", "ACTIONMESSAGE", "ACTIONSTATE", "APPROVERID", "DATE", "UNIQUE_NAME") VALUES (:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:12 ,:13 ,FWSERVICE_REQUEST_HISTORY_SEQ.NEXTVAL), OriginalSql = INSERT INTO "FWSERVICE_REQUEST_HISTORY"("ENV_OID", "DURATION", "USERID", "CHANGEDATE", "CHANGE", "ACTIONSTEP", "ACTIONLEVEL", "SERVICETAG", "STATUS", "ACTIONMESSAGE", "ACTIONSTATE", "APPROVERID", "DATE", "UNIQUE_NAME") VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,FWSERVICE_REQUEST_HISTORY_SEQ.NEXTVAL), Error Msg = ORA-01843: not a valid month

Environment

Identity Manager 14.x

Resolution

https://techdocs.broadcom.com/us/en/symantec-security-software/identity-security/identity-manager/14-5/Release-Notes/known-issues/general-issues.html

 

For Virtual Appliance

[dsa@my_vapp ~]$ /opt/CA/wildfly-idm/bin/jboss-cli.sh -c

Authenticating against security realm: ManagementRealm

Username: imadmin

Password:

[standalone@localhost:9990 /] /subsystem=datasources/data-source=iam_im-imobjectstoredb-ds:write-attribute(name=new-connection-sql, value="alter session set NLS_DATE_FORMAT='YYYY-MM-DD' NLS_TIMESTAMP_FORMAT='YYYY-MM-DD HH24:MI:SS.FF3'")

{"outcome" => "success"}