11200 Failed Adding New User After Applying OFSAAI 7.3.5.3

(Doc ID 2394230.1)

Last updated on MAY 02, 2018

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.5.3.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)

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 = 'MYUSER'] 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
[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 = 'MYUSER'] 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
[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)
at com.iflex.fic.newservice.NewServiceMaster.provideService(NewServiceMaster.java:211)
at com.iflex.fic.newservice.DynamicServiceManager.provideService(DynamicServiceManager.java:297)
at com.iflex.fic.ficserver.JavaRequestHandler.handleRequest(JavaRequestHandler.java:546)
at com.iflex.fic.ficserver.JavaSocketConnection.run(JavaSocketConnection.java:201)

[UMMLOG] Apr 30,18 15:50:37 : [DACDATABASEGATEWAY][BIND VARIABLES DDL Query for debug] : [null] 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
[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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms