Query is Not Working Properly (Doc ID 1389108.1)

Last updated on AUGUST 13, 2013

Applies to:

Oracle Communications Order and Service Management - Version: 7.0.3 and later   [Release: 7.0.0 and later ]
Information in this document applies to any platform.

Symptoms

In the OSM WebClient while using the query functionality the following happened:.

When querying for order information, the users are getting an SQL
Error in the OSM log and the query doesn't return anything.

java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

at
oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1035)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194
)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStateme
nt.java:791)
at
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedState
ment.java:866)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:
1188)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStat
ement.java:3386)
at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.ja
va:3487)
at
oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedState
mentWrapper.java:1374)
at
weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
at com.mslv.oms.dataaccesslayer.PreparedProxy.executeStatement(Unknown
Source)
at com.mslv.oms.dataaccesslayer.b.execute(Unknown Source)
at com.mslv.oms.dataaccesslayer.PreparedProxy.execute(Unknown Source)
at com.mslv.oms.model.lists.ListProxy.execute(Unknown Source)
at com.mslv.oms.handler.query.QueryHandlerEJB.process(Unknown Source)
at com.mslv.oms.handler.a.processRequest(Unknown Source)
at com.mslv.oms.jsp.processor.RequestProcessorSupport.a(Unknown Source)
at
com.mslv.oms.jsp.processor.RequestProcessorSupport.processRequest(Unknown
Source)
at
com.mslv.oms.jsp.processor.RequestProcessorSupport.processRequest(Unknown
Source)
at com.mslv.oms.jsp.processor.RequestProcessorSupport.a(Unknown Source)
at com.mslv.oms.jsp.processor.RequestProcessorSupport.a(Unknown Source)
at com.mslv.oms.jsp.processor.QueryResultsProcessor.d(Unknown Source)
at com.mslv.oms.jsp.processor.QueryResultsProcessor.processRequest(Unknown
Source)
at com.mslv.oms.jsp.controller.RequestController.a(Unknown Source)
at com.mslv.oms.jsp.controller.RequestController.a(Unknown Source)
at com.mslv.oms.jsp.controller.RequestController.processRequest(Unknown
Source)
at com.mslv.oms.jsp.controller.MainServlet.a(Unknown Source)
at com.mslv.oms.jsp.controller.MainServlet.doProcess(Unknown Source)
at com.mslv.oms.jsp.controller.MainServlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at
weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSec
urityHelper.java:227)
at
weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper
.java:125)
at
weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.dms.wls.DMSServletFilter.doFilter(DMSServletFilter.java:330)
at
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.doIt(W
ebAppServletContext.java:3684)
at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(We
bAppServletContext.java:3650)
at
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject
.java:321)
at
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at
weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletCo
ntext.java:2268)
at
weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.j
ava:2174)
at
weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1446
)
at
weblogic.work.ExecuteRequestAdapter.execute(ExecuteRequestAdapter.java:21)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:145)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:117)
<Dec 12, 2011 3:59:26 PM EET> <Error> <oms> <BEA-000000>
<core.logSQLException: SQL Exception 936 : ORA-00936: missing expression

java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

at
oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
Truncated. see log file for complete stacktrace

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