My Oracle Support Banner

ORA-00904: "V_AUTH_USER_NAME": invalid identifier Error While Starting OFSAAI service (Doc ID 2575176.1)

Last updated on AUGUST 20, 2019

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.5 and later
Information in this document applies to any platform.

Symptoms

Issue while starting OFSAAI services , when startofsaai.sh is triggered it prompts for config schema password.
Even though correct password is provided and there is no lock at DB level below error is seen on console:

Creating Logger Svc Code:999 LoggerName:ESPLOGGER oggerlevel:0
LogConstants.log4jInited = true
#Comparing---DAPPINST99966665---DAPPINST99966665
Kindly enter CONFIG schema password
User has typed an incorrect password or account is locked, please check the log.
Please provide the system password again
User has typed an incorrect password twice or account is locked, please check the log.

Below error comes up in SMSService.log:

[UMMLOG] Aug 5,19 19:24:45 : [DACDATABASEGATEWAY]Trial reinitialization connection and query execution
[UMMLOG] Aug 5,19 19:24:45 : [DACCONNECTIONPROVIDER]Connection Type getting used ->
[UMMLOG] Aug 5,19 19:24:45 : [DACDATABASEGATEWAY]Failed Executing 2nd time normal Select Query : [select v_auth_string from aai_db_auth_alias where v_auth_user_name=?] [On URL: jdbc:oracle:thin:@sxx.xxx.com:<Port>/<SID>] [Driver: oracle.jdbc.driver.OracleDriver] [Metadata Required : false]
[UMMLOG] Aug 5,19 19:24:45 : [DACDATABASEGATEWAY]
java.sql.SQLSyntaxErrorException: ORA-00904: "V_AUTH_USER_NAME": invalid identifier

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:5179)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:12485)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4793)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501)
at com.iflex.fic.ficserver.services.DAC.DACDatabaseGateway.executePSQuery(DACDatabaseGateway.java:1887)
at com.iflex.fic.ficserver.services.sms.SMSDACGateway.executeQueryWithDefaultParams(SMSDACGateway.java:74)
at com.iflex.fic.ficserver.services.sms.SMSServiceProvider.validatePassword(SMSServiceProvider.java:2005)
at com.iflex.fic.ficserver.services.sms.SMSServiceProvider.createSecurityFile(SMSServiceProvider.java:1802)
at com.iflex.fic.ficserver.services.sms.SMSServiceProvider.startUp(SMSServiceProvider.java:431)
at com.iflex.fic.newservice.DynamicServicePool.initializeService(DynamicServicePool.java:118)
at com.iflex.fic.newservice.ServiceProxy.initializeService(ServiceProxy.java:85)
at com.iflex.fic.newservice.NewServiceMaster.initializeServices(NewServiceMaster.java:122)
at com.iflex.fic.newservice.NewServiceMaster.init(NewServiceMaster.java:83)
at com.iflex.fic.newservice.DynamicServiceManager.initializeServiceMaster(DynamicServiceManager.java:229)
at com.iflex.fic.ficserver.FICServer.initialize(FICServer.java:311)
at com.iflex.fic.ficserver.FICServer.(FICServer.java:281)
at com.iflex.fic.ficserver.FICServer.main(FICServer.java:194)

[UMMLOG] Aug 5,19 19:24:45 : [SMSDACGATEWAY]Error while Executing query :Error Executing Query. Error: ORA-00904: "V_AUTH_USER_NAME": invalid identifier

Changes

 N/A

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


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