11200 Failed Adding New User After Applying OFSAAI 7.3.5.3 (Doc ID 2394230.1)

Last updated on MAY 24, 2023

Applies to:

Symptoms

On OFSAAI 7.3.5.3.0, attempting to add a new user in a newly cloned instance gives errors:

ERROR

[11200] Failed Adding New User.

SMSService.log gives error:

[UMMLOG] Apr 30,18 15:50:37 : [SMSSERVICEPROVIDER]Adding a user
[UMMLOG] Apr 30,18 15:50:37 : [DACDATABASEGATEWAY][BIND VARIABLES DDL Query for debug] : [SELECT v_usr_id FROM cssms_usr_profile WHERE v_usr_id = '<USER>'] On URL: jdbc:oracle:thin:@<HOSTNAME>:<PORT>:<CONTEXT>Driver: oracle.jdbc.driver.OracleDriver Metadata Required : false
[UMMLOG] Apr 30,18 15:50:37 : [DACCONNECTIONPROVIDER]Trial Execution Status: true
[UMMLOG] Apr 30,18 15:50:37 : [DACDATABASEGATEWAY][BIND VARIABLES DDL Query for debug] : [SELECT v_usr_id FROM cssms_usr_profile_unauth WHERE v_usr_id = '<USER>'] On URL: jdbc:oracle:thin:@<HOSTNAME>:<PORT>:<CONTEXT> Driver: oracle.jdbc.driver.OracleDriver Metadata Required : false
[UMMLOG] Apr 30,18 15:50:37 : [DACCONNECTIONPROVIDER]Trial Execution Status: true
[UMMLOG] Apr 30,18 15:50:37 : [SMSUSERHANDLER]Exception
java.lang.NullPointerException
at com.iflex.fic.ficserver.services.sms.cssms.service.handlers.SMSUserHandler.addUser(SMSUserHandler.java:93)
at com.iflex.fic.ficserver.services.sms.CSSMSServices.addUser(CSSMSServices.java:2041)
at com.iflex.fic.ficserver.services.sms.SMSServiceProvider.handleRequest(SMSServiceProvider.java:1211)
at com.iflex.fic.newservice.ServiceProxy.invokeService(ServiceProxy.java:184)


[UMMLOG] Apr 30,18 15:50:37 : [DACDATABASEGATEWAY][BIND VARIABLES DDL Query for debug] : [null] On URL: jdbc:oracle:thin:@<HOSTNAME>:<PORT>:<CONTEXT> Driver: oracle.jdbc.driver.OracleDriver Metadata Required : false
[UMMLOG] Apr 30,18 15:50:37 : [DACCONNECTIONPROVIDER]Trial Execution Status: true
[UMMLOG] Apr 30,18 15:50:37 : [SMSSERVICEPROVIDER]Retrieving all Profiles
[UMMLOG] Apr 30,18 15:50:37 : [SMSPROFILEHANDLER]rolecode>>>
[UMMLOG] Apr 30,18 15:50:37 : [SMSPROFILEHANDLER]select * from cssms_profile_mast WHERE V_PROFILE_CODE LIKE ? AND UPPER(V_PROFILE_NAME) LIKE ? ORDER BY upper(v_profile_name)
[UMMLOG] Apr 30,18 15:50:37 : [DACDATABASEGATEWAY][BIND VARIABLES DDL Query for debug] : [select * from cssms_profile_mast WHERE V_PROFILE_CODE LIKE '%%' AND UPPER(V_PROFILE_NAME) LIKE '%%' ORDER BY upper(v_profile_name)] On URL: jdbc:oracle:thin:@@OFSAA:1521:OFSAA Driver: oracle.jdbc.driver.OracleDriver Metadata Required : false
[UMMLOG] Apr 30,18 15:50:37 : [DACCONNECTIONPROVIDER]Trial Execution Status: true

RevAppserver.log

[REVELEUSLOG] Apr 30,18 15:50:37 : [JAVASOCKETCONNECTION]Finished writing :[SC:10][ST:760][SST:0][Oper:0][Version:0][EF:false][D:][S:null][U:SYSADMN][PT:760][P:nullSMSME.USR_ADD_FAIL]
[REVELEUSLOG] Apr 30,18 15:50:37 : [NONE]

Also unable to update existing user.

The issue can be reproduced at will with the following steps:
1. Cloned the Prod 7.3.3 environment into Dev.
2. Patch to 7.3.5.3.
3. Attempt to create new user

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.