Troubleshooting
Problem
ORA-01435: user does not exist during login with JBOSS
Symptom
Application is configured to use datasource with JBOSS. SSCA 8.0 is deployed and when the user tries to login. Applciation throws the following exception,
Error Message?xml version="1.0" encoding="UTF-8"?>
<Errors>
<Error
ErrorCode="java.sql.SQLException" ErrorDescription="java.sql.SQLException"
ErrorRelatedMoreInfo="">
<Attribute Name="ErrorCode"
Value="java.sql.SQLException"/>
<Attribute Name="ErrorDescription"
Value="java.sql.SQLException"/>
<Error ErrorCode="java.sql.SQLException"
ErrorDescription="" ErrorRelatedMoreInfo="ORA-01435: user does not
exist
">
<Stack>java.sql.SQLException: ORA-01435: user does not
exist
Resolving The Problem
With -Dvendor and other related data-source system properties passed in the
server startup scripts, system is NOT expected to look into other connection
properties specified in the sanbox/jdbc/overrides property files.Also, customer
is expected to NOT to define any undue connection related properties in case,
if he is using Datasource for appserver.
To solve/overcome this
exception, customer should DEFINE a blank value for DB_SCHEMA_OWNER in sandbox
or in overrides.Ideally, it should work with no issues with correct schema name
specified.
Historical Number
NFX7929
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21555991