My Oracle Support Banner

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:

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



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
Cause
Solution
References


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