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,Maximo 7.1, db2 9.7, Web Sphere 6.5, MS Win 2003 sp1
Kindly help me how to fix following error as comming in systemErr.log file coninously;
Error:
[6/28/15 14:25:02:074 AST] 0000005f SystemErr R com.ibm.db2.jcc.am.SqlSyntaxErrorException: "CLASS" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.59.81[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.dd.a(dd.java:676)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.dd.a(dd.java:60)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.dd.a(dd.java:127)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.bn.c(bn.java:2546)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.bn.d(bn.java:2534)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.bn.a(bn.java:2026)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.t4.cb.g(cb.java:140)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.t4.cb.a(cb.java:40)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.t4.q.a(q.java:32)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.t4.rb.i(rb.java:135)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.bn.gb(bn.java:1997)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.bn.a(bn.java:2997)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.bn.a(bn.java:659)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.bn.executeQuery(bn.java:643)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboSet.getDBValue(MboSet.java:3721)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboSet.getDBValue(MboSet.java:3640)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboSet.getDBCalc(MboSet.java:3790)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboSet.count(MboSet.java:3232)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboSet.count(MboSet.java:3244)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboSet.count(MboSet.java:3197)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.common.parse.ParserService.getBoolean(ParserService.java:191)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.common.condition.ExpressionCondition.evaluateCondition(ExpressionCondition.java:45)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.common.condition.MaxCondition.evaluate(MaxCondition.java:130)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.Mbo.evaluateCondition(Mbo.java:7906)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.Mbo.evaluateCondition(Mbo.java:7921)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.Mbo.evaluateRestriction(Mbo.java:4979)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.Mbo.andEvaluateConditions(Mbo.java:4108)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.Mbo.getAttrRestrictionFlag(Mbo.java:5029)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboValue.getAttrRestrictionFlag(MboValue.java:2218)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboValue.isFlagSet(MboValue.java:2287)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboLONGALNValue._setValue(MboLONGALNValue.java:380)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboValue.setValue(MboValue.java:1079)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.Mbo.setValue(Mbo.java:2136)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.webclient.system.beans.DataBean.setValue(DataBean.java:3637)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.webclient.system.beans.DataBean.setvalue(DataBean.java:5223)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at sun.reflect.GeneratedMethodAccessor86.invoke(Unknown Source)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at java.lang.reflect.Method.invoke(Method.java:618)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.webclient.system.session.WebClientSession.defaultHandler(WebClientSession.java:1193)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.webclient.system.session.WebClientSession.handleEvent(WebClientSession.java:1087)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.webclient.system.session.WebClientSession.handleRequest(WebClientSession.java:700)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.webclient.system.controller.RequestManager.manageRequest(RequestManager.java:101)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.webclient.servlet.WebClientServlet.handleRequest(WebClientServlet.java:96)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.webclient.servlet.WebClientServlet.doPost(WebClientServlet.java:45)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1095)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1036)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:118)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:832)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:679)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:565)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:748)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1461)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:118)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:387)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1473)
Waiting for your prompt reply, Thanks in advance for help.
RegardsShah
Looks like you might have a bad sql statement used in an expression, i would query for the word '%CLASS%' in the conditions table, escalations...etc.. Until you find the bad where clause.
> On Jun 28, 2015, at 6:30 AM, shah faisal dba_develper@yahoo.com [MAXIMO] <MAXIMO@yahoogroups.com> wrote:
>
> Hi,Maximo 7.1, db2 9.7, Web Sphere 6.5, MS Win 2003 sp1
> Kindly help me how to fix following error as comming in systemErr.log file coninously;
> Error:
> [6/28/15 14:25:02:074 AST] 0000005f SystemErr R com.ibm.db2.jcc.am.SqlSyntaxErrorException: "CLASS" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.59.81[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.dd.a(dd.java:676)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.dd.a(dd.java:60)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.dd.a(dd.java:127)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.bn.c(bn.java:2546)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.bn.d(bn.java:2534)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.bn.a(bn.java:2026)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.t4.cb.g(cb.java:140)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.t4.cb.a(cb.java:40)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.t4.q.a(q.java:32)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.t4.rb.i(rb.java:135)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.bn.gb(bn.java:1997)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.bn.a(bn.java:2997)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.bn.a(bn.java:659)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.bn.executeQuery(bn.java:643)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboSet.getDBValue(MboSet.java:3721)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboSet.getDBValue(MboSet.java:3640)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboSet.getDBCalc(MboSet.java:3790)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboSet.count(MboSet.java:3232)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboSet.count(MboSet.java:3244)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboSet.count(MboSet.java:3197)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.common.parse.ParserService.getBoolean(ParserService.java:191)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.common.condition.ExpressionCondition.evaluateCondition(ExpressionCondition.java:45)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.common.condition.MaxCondition.evaluate(MaxCondition.java:130)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.Mbo.evaluateCondition(Mbo.java:7906)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.Mbo.evaluateCondition(Mbo.java:7921)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.Mbo.evaluateRestriction(Mbo.java:4979)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.Mbo.andEvaluateConditions(Mbo.java:4108)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.Mbo.getAttrRestrictionFlag(Mbo.java:5029)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboValue.getAttrRestrictionFlag(MboValue.java:2218)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboValue.isFlagSet(MboValue.java:2287)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboLONGALNValue._setValue(MboLONGALNValue.java:380)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboValue.setValue(MboValue.java:1079)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.Mbo.setValue(Mbo.java:2136)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.webclient.system.beans.DataBean.setValue(DataBean.java:3637)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.webclient.system.beans.DataBean.setvalue(DataBean.java:5223)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at sun.reflect.GeneratedMethodAccessor86.invoke(Unknown Source)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at java.lang.reflect.Method.invoke(Method.java:618)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.webclient.system.session.WebClientSession.defaultHandler(WebClientSession.java:1193)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.webclient.system.session.WebClientSession.handleEvent(WebClientSession.java:1087)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.webclient.system.session.WebClientSession.handleRequest(WebClientSession.java:700)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.webclient.system.controller.RequestManager.manageRequest(RequestManager.java:101)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.webclient.servlet.WebClientServlet.handleRequest(WebClientServlet.java:96)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.webclient.servlet.WebClientServlet.doPost(WebClientServlet.java:45)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1095)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1036)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:118)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:832)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:679)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:565)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:748)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1461)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:118)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:387)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1473)
> Waiting for your prompt reply, Thanks in advance for help.
> RegardsShah
>
>
>
>
I notice the error has a reference to psdi.mbo.Mbo.evaluateRestriction – personally, I’d start with Data Restrictions when I’m looking for the error.
Shannon Rotz
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
Sent: June 28, 2015 4:56 AM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Maximo - System Error
Looks like you might have a bad sql statement used in an expression, i would query for the word '%CLASS%' in the conditions table, escalations...etc.. Until you find the bad where clause.
> On Jun 28, 2015, at 6:30 AM, shah faisal dba_develper@yahoo.com [MAXIMO] <MAXIMO@yahoogroups.com> wrote:
>
> Hi,Maximo 7.1, db2 9.7, Web Sphere 6.5, MS Win 2003 sp1
> Kindly help me how to fix following error as comming in systemErr.log file coninously;
> Error:
> [6/28/15 14:25:02:074 AST] 0000005f SystemErr R com.ibm.db2.jcc.am.SqlSyntaxErrorException: "CLASS" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.59.81[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.dd.a(dd.java:676)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.dd.a(dd.java:60)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.dd.a(dd.java:127)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.bn.c(bn.java:2546)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.bn.d(bn.java:2534)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.bn.a(bn.java:2026)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.t4.cb.g(cb.java:140)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.t4.cb.a(cb.java:40)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.t4.q.a(q.java:32)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.t4.rb.i(rb.java:135)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.bn.gb(bn.java:1997)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.bn.a(bn.java:2997)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.bn.a(bn.java:659)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.db2.jcc.am.bn.executeQuery(bn.java:643)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboSet.getDBValue(MboSet.java:3721)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboSet.getDBValue(MboSet.java:3640)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboSet.getDBCalc(MboSet.java:3790)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboSet.count(MboSet.java:3232)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboSet.count(MboSet.java:3244)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboSet.count(MboSet.java:3197)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.common.parse.ParserService.getBoolean(ParserService.java:191)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.common.condition.ExpressionCondition.evaluateCondition(ExpressionCondition.java:45)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.common.condition.MaxCondition.evaluate(MaxCondition.java:130)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.Mbo.evaluateCondition(Mbo.java:7906)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.Mbo.evaluateCondition(Mbo.java:7921)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.Mbo.evaluateRestriction(Mbo.java:4979)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.Mbo.andEvaluateConditions(Mbo.java:4108)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.Mbo.getAttrRestrictionFlag(Mbo.java:5029)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboValue.getAttrRestrictionFlag(MboValue.java:2218)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboValue.isFlagSet(MboValue.java:2287)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboLONGALNValue._setValue(MboLONGALNValue.java:380)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.MboValue.setValue(MboValue.java:1079)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.mbo.Mbo.setValue(Mbo.java:2136)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.webclient.system.beans.DataBean.setValue(DataBean.java:3637)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.webclient.system.beans.DataBean.setvalue(DataBean.java:5223)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at sun.reflect.GeneratedMethodAccessor86.invoke(Unknown Source)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at java.lang.reflect.Method.invoke(Method.java:618)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.webclient.system.session.WebClientSession.defaultHandler(WebClientSession.java:1193)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.webclient.system.session.WebClientSession.handleEvent(WebClientSession.java:1087)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.webclient.system.session.WebClientSession.handleRequest(WebClientSession.java:700)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.webclient.system.controller.RequestManager.manageRequest(RequestManager.java:101)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.webclient.servlet.WebClientServlet.handleRequest(WebClientServlet.java:96)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at psdi.webclient.servlet.WebClientServlet.doPost(WebClientServlet.java:45)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1095)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1036)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:118)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:832)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:679)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:565)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:748)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1461)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:118)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:387)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)[6/28/15 14:25:02:074 AST] 0000005f SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1473)
> Waiting for your prompt reply, Thanks in advance for help.
> RegardsShah
>
>
>
>