Logon To MDM Using SYSUSER Receive Error In Right Pane "The Server Has Encountered A Problem" (Doc ID 2335923.1)

Last updated on FEBRUARY 20, 2024

Applies to:

Symptoms

MDM version2.2.0.0.0 version after logging into to UI the user receives error in right pane "The server has encountered a problem". This occurs with using JDBC datasource. This does not occur when using UCP connection.

Error from Log:
SYSUSER - 283462-170-1 2017-09-15 13:53:11,193 [[ACTIVE] ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR (support.sql.PreparedStatementImpl) Error executing list for rawSQL:
 SELECT COUNT( REV_ID) AS CNTCHK FROM F1_OBJ_REV REV, F1_BUS_OBJ_STATUS BOS WHERE REV.USER_ID = ? AND REV.BUS_OBJ_CD = BOS.BUS_OBJ_CD AND REV.BO_STATUS_CD = BOS.BO_STATUS_CD AND BOS.BO_STATUS_COND_FLG='F1IN' /* SQL for Zone 'F1-USRCHKCNT' */ /* com.splwg.base.web.dataExplorer.common.DataExplorerSQLExecuter */
with 'FixedCHAR' parameter named 'USERID' to : 'SYSUSER ' to indices: 1

SYSUSER - 283462-173-1 2017-09-15 13:53:14,762 [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR (support.sql.PreparedStatementImpl) Error binding USERID
java.lang.IllegalArgumentException: not a proxy instance
  at java.lang.reflect.Proxy.getInvocationHandler(Proxy.java:816)
  at com.splwg.base.support.sql.OracleFunctionReplacer.bindFixedCHARString(OracleFunctionReplacer.java:365)
  at com.splwg.base.support.sql.type.FixedCharStringSQLType.bind(FixedCharStringSQLType.java:23)
  at com.splwg.base.support.sql.type.FixedCharStringSQLType.bind(FixedCharStringSQLType.java:9)
  at com.splwg.base.support.sql.type.SQLType.bindAllIndices(SQLType.java:56)
  at com.splwg.base.support.sql.PreparedStatementImpl.bindJDBCStatement(PreparedStatementImpl.java:202)
  at com.splwg.base.support.sql.PreparedStatementImpl.getJDBCStatement(PreparedStatementImpl.java:181)
  at com.splwg.base.support.sql.PreparedStatementImpl.iterate(Prepared



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Setup WLS Datasource
2. Configure JDBC_NAME
3. Login to the application

Cause

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