Logon To MDM Using SYSUSER Receive Error In Right Pane "The Server Has Encountered A Problem"

(Doc ID 2335923.1)

Last updated on DECEMBER 15, 2017

Applies to:

Oracle Utilities Meter Data Management - Version 2.2.0.0.0 and later
Information in this document applies to any platform.

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



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