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 laterInformation 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 |