ERROR WHILE CREATING THE CHARACTERISTIC TYPE (Doc ID 2152774.1)

Last updated on JULY 14, 2017

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.4.0.2.0 and later
Information in this document applies to any platform.

Goal

 whenever login to application, right hand side shows The server has encountered a problem. Please contact your system administrator.

while creating Charecteristics type input parameters with Charecteristics Type CMWTCCMM
Description: water tonk connection Size in MM,Type of char value :Predefined value allow search by Char val : Allowed

Getting the error like "messege server has encountered a problem and request could not proceed".

ERROR
-----------------------
SYSUSER - 635852-4235-1 2016-06-18 01:51:37,519 [[ACTIVE] ExecuteThread: '9' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR (web.dataservlet.PageChange) Unexpected error.
com.splwg.shared.common.LoggedException:
The following stacked messages were reported as the LoggedException was rethrown:
com.splwg.base.support.service.ServiceReplayExecuter.executeInAppropriateSession(ServiceReplayExecuter.java:114): Exception occurred calling serviceName: CILTCHTP
com.splwg.base.support.service.ServiceReplayExecuter$2.execute(ServiceReplayExecuter.java:166): Caught exception from SessionExecutable.execute()
com.splwg.base.support.pagemaintenance.AbstractPageMaintenance.changeItem(AbstractPageMaintenance.java:136): Rollback: Change failed
com.splwg.base.support.sql.PreparedStatementImpl.firstRow(PreparedStatementImpl.java:74): Error executing delete RI query with SQL = 'select IN_SVC_NAME , CHAR_TYPE_CD , SEQ_NUM from F1_IWS_SVC_CHAR where CHAR_TYPE_CD = :CHAR_TYPE_CD and CHAR_VAL = :CHAR_VAL '

1. The root LoggedException was: Error executing iterate for rawSQL:
select IN_SVC_NAME , CHAR_TYPE_CD , SEQ_NUM from F1_IWS_SVC_CHAR where CHAR_TYPE_CD = ? and CHAR_VAL = ? /* com.splwg.base.support.changehandlers.deleteValidation.SQLReferencingValidation */
with 'string' parameter named 'CHAR_VAL' to : '15 ' to indices: 2
with 'string' parameter named 'CHAR_TYPE_CD' to : 'CMWTCCMM' to indices: 1

java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

2. The root LoggedException was: Hibernate exception while applying filter
'select count(*)' to list
com.splwg.base.domain.common.uiMap.UiMapHtmldefns_Gen for owner
UiMap_Per[F1-ExplZoneHeadMenuFusion]

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Charecteristics type input parameters
2. Charecteristics Type CMWTCCMM
3. Description: water tonk connection Size in MM
4. Type of char value :Predefined value
allow search by Char val : Allowed
5. Getting the error like "messege server has encountered a problem and request could not proceed".

Solution

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