This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Hi,
We are seeing this error very frequently in Maximo 7.1.1.7 Error logs,
Can you please share your thoughts, For what reason it is throwing this Exception.
Thanks in Advance.
Regards,
Yogi
[14/08/13 15:06:46:050 EST] 0000003f SystemErr R java.sql.SQLException: ORA-00904: "POTYPE": invalid identifier
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:801)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:841)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1274)
at psdi.mbo.MboSet.getDBValue(MboSet.java:3714)
at psdi.mbo.MboSet.getDBValue(MboSet.java:3633)
at psdi.mbo.MboSet.getDBCalc(MboSet.java:3783)
at psdi.mbo.MboSet.count(MboSet.java:3225)
at psdi.mbo.MboSet.count(MboSet.java:3237)
at psdi.mbo.MboSet.count(MboSet.java:3190)
at psdi.common.parse.ParserService.getBoolean(ParserService.java:191)
at psdi.common.condition.ExpressionCondition.evaluateCondition(ExpressionCondition.java:45)
at psdi.common.condition.MaxCondition.evaluate(MaxCondition.java:130)
at psdi.mbo.Mbo.evaluateCondition(Mbo.java:7901)
at psdi.mbo.Mbo.evaluateCondition(Mbo.java:7916)
at psdi.mbo.Mbo.evaluateRestriction(Mbo.java:4977)
at psdi.mbo.Mbo.orEvaluateConditions(Mbo.java:4060)
at psdi.mbo.Mbo.checkQualifiedRestriction(Mbo.java:4016)
at psdi.mbo.Mbo.validate(Mbo.java:3855)
at psdi.mbo.MboSet.validate(MboSet.java:4595)
at psdi.mbo.MboSet.validateTransaction(MboSet.java:6960)
at psdi.txn.MXTransactionImpl.validateTransaction(MXTransactionImpl.java:377)
at psdi.txn.MXTransactionImpl.saveTransaction(MXTransactionImpl.java:214)
at psdi.txn.MXTransactionImpl.save(MXTransactionImpl.java:163)
at psdi.mbo.MboSet.save(MboSet.java:6653)
at psdi.mbo.MboSet.save(MboSet.java:6594)
at psdi.webclient.system.beans.AppBean.save(AppBean.java:521)
at psdi.webclient.system.beans.AppBean.SAVE(AppBean.java:830)
at psdi.webclient.beans.po.POAppBean.SAVE(POAppBean.java:187)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at psdi.webclient.system.session.WebClientSession.defaultHandler(WebClientSession.java:1144)
at psdi.webclient.system.session.WebClientSession.handleEvent(WebClientSession.java:1038)
at psdi.webclient.system.session.WebClientSession.handleRequest(WebClientSession.java:684)
at psdi.webclient.system.controller.RequestManager.manageRequest(RequestManager.java:101)
at psdi.webclient.servlet.WebClientServlet.handleRequest(WebClientServlet.java:96)
at psdi.webclient.servlet.WebClientServlet.doPost(WebClientServlet.java:45)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1075)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1016)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)
at psdi.webclient.system.filter.HttpCrossSiteScriptingSecurity.doFilter(HttpCrossSiteScriptingSecurity.java:64)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:771)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:679)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:546)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:744)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1455)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:115)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:387)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1473)
Are you using any conditional expressions? We see similar noise
constantly in our logs after we implemented a bunch of data restrictions
using conditional expressions. The implementation of conditional
expressions has an annoying little "feature". We were told by IBM that
every conditional expression first evaluates against an object called
"dummy_table" before it actually evaluates against the object that it is
really supposed to. We were given some half-witted explanation that
this was for performance and this was working as designed. The bottom
line is that conditional expressions create so much noise in the logs
that anytime I have to research an actual error it takes me forever to
find it in all the false errors.
-----Original Message-----
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf
Of Yugesh Rudra
Sent: Wednesday, August 14, 2013 6:57 AM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] java.sql.SQLException: ORA-00904: "POTYPE":
invalid identifier
Hi,
We are seeing this error very frequently in Maximo 7.1.1.7 Error logs,
Can you please share your thoughts, For what reason it is throwing this
Exception.
Thanks in Advance.
Regards,
Yogi
[14/08/13 15:06:46:050 EST] 0000003f SystemErr R java.sql.SQLException:
ORA-00904: "POTYPE": invalid identifier
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
2)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at
oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:801
)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.
java:1039)
at
oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:8
41)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
java:1134)
at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:127
4)
at psdi.mbo.MboSet.getDBValue(MboSet.java:3714)
at psdi.mbo.MboSet.getDBValue(MboSet.java:3633)
at psdi.mbo.MboSet.getDBCalc(MboSet.java:3783)
at psdi.mbo.MboSet.count(MboSet.java:3225)
at psdi.mbo.MboSet.count(MboSet.java:3237)
at psdi.mbo.MboSet.count(MboSet.java:3190)
at psdi.common.parse.ParserService.getBoolean(ParserService.java:191)
at
psdi.common.condition.ExpressionCondition.evaluateCondition(ExpressionCo
ndition.java:45)
at psdi.common.condition.MaxCondition.evaluate(MaxCondition.java:130)
at psdi.mbo.Mbo.evaluateCondition(Mbo.java:7901)
at psdi.mbo.Mbo.evaluateCondition(Mbo.java:7916)
at psdi.mbo.Mbo.evaluateRestriction(Mbo.java:4977)
at psdi.mbo.Mbo.orEvaluateConditions(Mbo.java:4060)
at psdi.mbo.Mbo.checkQualifiedRestriction(Mbo.java:4016)
at psdi.mbo.Mbo.validate(Mbo.java:3855)
at psdi.mbo.MboSet.validate(MboSet.java:4595)
at psdi.mbo.MboSet.validateTransaction(MboSet.java:6960)
at
psdi.txn.MXTransactionImpl.validateTransaction(MXTransactionImpl.java:37
7)
at
psdi.txn.MXTransactionImpl.saveTransaction(MXTransactionImpl.java:214)
at psdi.txn.MXTransactionImpl.save(MXTransactionImpl.java:163)
at psdi.mbo.MboSet.save(MboSet.java:6653)
at psdi.mbo.MboSet.save(MboSet.java:6594)
at psdi.webclient.system.beans.AppBean.save(AppBean.java:521)
at psdi.webclient.system.beans.AppBean.SAVE(AppBean.java:830)
at psdi.webclient.beans.po.POAppBean.SAVE(POAppBean.java:187)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
psdi.webclient.system.session.WebClientSession.defaultHandler(WebClientS
ession.java:1144)
at
psdi.webclient.system.session.WebClientSession.handleEvent(WebClientSess
ion.java:1038)
at
psdi.webclient.system.session.WebClientSession.handleRequest(WebClientSe
ssion.java:684)
at
psdi.webclient.system.controller.RequestManager.manageRequest(RequestMan
ager.java:101)
at
psdi.webclient.servlet.WebClientServlet.handleRequest(WebClientServlet.j
ava:96)
at
psdi.webclient.servlet.WebClientServlet.doPost(WebClientServlet.java:45)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.ja
va:1075)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.ja
va:1016)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCh
ain.java:145)
at
psdi.webclient.system.filter.HttpCrossSiteScriptingSecurity.doFilter(Htt
pCrossSiteScriptingSecurity.java:64)
at
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInst
anceWrapper.java:190)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCh
ain.java:130)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterC
hain.java:87)
at
com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilter
Manager.java:771)
at
com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilter
Manager.java:679)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrap
per.java:546)
at
com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWr
apper.java:478)
at
com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheS
ervletWrapper.java:90)
at
com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:744
)
at
com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1
455)
at
com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:1
15)
at
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscriminatio
n(HttpInboundLink.java:458)
at
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformatio
n(HttpInboundLink.java:387)
at
com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpIC
LReadCallback.java:102)
at
com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(Ai
oReadCompletionListener.java:165)
at
com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.
java:217)
at
com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFu
ture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)
at
com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java
:743)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1473)
This technote explains about the dummy_table. It also explains about things to check.
It includes an example about how to fix it.
http://www-01.ibm.com/support/docview.wss?uid=swg21591587
best regards,
Mark
--- In MAXIMO@yahoogroups.com, "Hanna, Christopher A CTR" <christopher.a.hanna@...> wrote:
>
> Are you using any conditional expressions? We see similar noise
> constantly in our logs after we implemented a bunch of data restrictions
> using conditional expressions. The implementation of conditional
> expressions has an annoying little "feature". We were told by IBM that
> every conditional expression first evaluates against an object called
> "dummy_table" before it actually evaluates against the object that it is
> really supposed to. We were given some half-witted explanation that
> this was for performance and this was working as designed. The bottom
> line is that conditional expressions create so much noise in the logs
> that anytime I have to research an actual error it takes me forever to
> find it in all the false errors.