IBM Support

IJ36928: ERROR WHILE CREATING NEW CUSTOMER ESTIMATE FROM WORK ORDER TRACKING (SP) APPLICATION

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • An error message is displayed trying to create New Customer
Estimate from Work Order Tracking (SP) application: BMXAA4214E -
An unknown error has occurred. Please contact your system
administrator for assistance. Gather the logs from the <HOME>
directory and determine where and why the error occurred.
STEPS TO REPRODUCE:
1.	Navigate to Work Order Tracking (SP) application.
2.	Pick any work order which is in WAPPR status and open the
record.
3.	Click on Select Action -->Create Estimate --> click on New
Customer Estimate button.
Note:- the following error MSG is displayed
BMXAA4214E - An unknown error has occurred. Please contact your
system administrator for assistance. Gather the logs from the
<HOME> directory and determine where and why the error occurred.

4.	Click OK
5.	In the System logs there is one of the following error
messages:
[12/13/21 22:21:02:681 EST] 00000748 SystemOut O 13 Dec 2021
22:21:02:681 [ERROR] [MXServer01] [] ORA-00904: "REFWO": invalid
identifier
java.sql.SQLSyntaxErrorException: ORA-00904: "REFWO": invalid
identifier
Caused by: Error : 904, Position : 72, Sql = select distinct
refwo from pluspgbtrans where siteid = 'PGGB' and refwo in
(select distinct wonum from workorder where parent = '71652' and
siteid = 'PGGB' ), OriginalSql = select distinct refwo from
pluspgbtrans where siteid = 'PGGB' and refwo in (select distinct
wonum from workorder where parent = '71652' and siteid = 'PGGB'
), Error Msg = ORA-00904: "REFWO": invalid identifier
Or:
[12/17/21 1:01:50:662 PST] 00000133 SystemOut     O 17 Dec 2021
01:01:50:662 [ERROR] [MAXIMO] [] "REFWO" is not valid in the
context where it is used.. SQLCODE=-206, SQLSTATE=42703,
DRIVER=4.26.14
com.ibm.db2.jcc.am.SqlSyntaxErrorException: "REFWO" is not valid
in the context where it is used.. SQLCODE=-206, SQLSTATE=42703,
DRIVER=4.26.14
	at com.ibm.db2.jcc.am.b7.a(b7.java:810)
	at com.ibm.db2.jcc.am.b7.a(b7.java:66)
	at com.ibm.db2.jcc.am.b7.a(b7.java:140)
	at com.ibm.db2.jcc.am.k4.c(k4.java:2824)
	at com.ibm.db2.jcc.am.k4.d(k4.java:2808)
	at com.ibm.db2.jcc.am.k4.a(k4.java:2234)
	at com.ibm.db2.jcc.t4.ab.i(ab.java:206)
	at com.ibm.db2.jcc.t4.ab.b(ab.java:96)
	at com.ibm.db2.jcc.t4.p.a(p.java:32)
	at com.ibm.db2.jcc.t4.av.i(av.java:150)
	at com.ibm.db2.jcc.am.k4.al(k4.java:2203)
	at com.ibm.db2.jcc.am.k4.a(k4.java:3330)
	at com.ibm.db2.jcc.am.k4.a(k4.java:737)
	at com.ibm.db2.jcc.am.k4.executeQuery(k4.java:716)
	at psdi.mbo.DBShortcut.executeQuery(DBShortcut.java:393)
	at psdi.app.workorder.virtual.ShowActualMboSet.fetchMbosOrigin
al(ShowActualMboSet.java:201)
	at psdi.app.workorder.virtual.ShowActualMboSet.fetchMbos(ShowA
ctualMboSet.java:143)
	at psdi.mbo.FauxMboSet.getMbo(FauxMboSet.java:807)
	at psdi.mbo.FauxMboSet.isEmpty(FauxMboSet.java:666)
	at psdi.mbo.FauxMboSet.notExist(FauxMboSet.java:686)
	at psdi.plusp.app.workorder.PlusPWorkorderUtil.setTotalValues(
PlusPWorkorderUtil.java:1222)
	at psdi.plusp.app.workorder.PlusPWorkorderUtil.calculateTotals
(PlusPWorkorderUtil.java:953)
	at psdi.plusp.app.workorder.PlusPWorkorderUtil.calculateTotals
(PlusPWorkorderUtil.java:810)
	at psdi.plusp.app.ticket.PlusPWorkLog.setPrice(PlusPWorkLog.ja
va:170)
	at psdi.plusp.app.ticket.PlusPWorkLog.setWorkLogEstimateDetail
sForkWorkOrder(PlusPWorkLog.java:149)
	at
psdi.plusp.app.ticket.PlusPWorkLog.add(PlusPWorkLog.java:103)
	at psdi.mbo.MboSet.addAtIndex(MboSet.java:4775)
	at psdi.mbo.MboSet.addAtEnd(MboSet.java:4695)
	at psdi.mbo.MboSet.addAtEnd(MboSet.java:4584)
	at psdi.webclient.system.beans.DataBean.insertAtEnd(DataBean.j
ava:3620)
	at
psdi.webclient.system.beans.DataBean.addrow(DataBean.java:6143)
	at psdi.plusp.webclient.beans.common.PlusPWorkLogBean.newcusto
merpriceestimate(PlusPWorkLogBean.java:138)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcc
essorImpl.java:90)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingM
ethodAccessorImpl.java:55)
	at java.lang.reflect.Method.invoke(Method.java:508)
	at psdi.webclient.system.session.WebClientSession.defaultHandl
er(WebClientSession.java:1510)
	at psdi.webclient.system.session.WebClientSession.handleEvent(
WebClientSession.java:1403)
	at psdi.webclient.system.session.WebClientSession.processReque
stEvent(WebClientSession.java:6219)
	at psdi.webclient.system.session.WebClientSession.handleClient
SideQueueRequest(WebClientSession.java:6175)
	at psdi.webclient.system.session.WebClientSession.handleReques
t(WebClientSession.java:892)
	at psdi.webclient.system.session.AsyncRequestManager.handleReq
uest(AsyncRequestManager.java:555)
	at psdi.webclient.system.session.AsyncRequestManager.manageReq
uest(AsyncRequestManager.java:253)
	at psdi.webclient.system.controller.RequestManager.manageReque
st(RequestManager.java:290)
	at psdi.webclient.servlet.WebClientServlet.handleRequest(WebCl
ientServlet.java:141)
	at psdi.webclient.servlet.WebClientServlet.doPost(WebClientSer
vlet.java:52)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)

	at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(Serv
letWrapper.java:1235)
	at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleReques
t(ServletWrapper.java:779)
	at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleReques
t(ServletWrapper.java:478)
	at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRe
quest(ServletWrapperImpl.java:179)
	at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarg
et(WebAppFilterChain.java:143)
	at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(W
ebAppFilterChain.java:96)
	at psdi.webclient.system.filter.HttpCrossSiteScriptingSecurity
.doFilter(HttpCrossSiteScriptingSecurity.java:66)
	at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilt
er(FilterInstanceWrapper.java:197)
	at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(W
ebAppFilterChain.java:90)
	at psdi.webclient.system.filter.MXCorrelationFilter.doFilter(M
XCorrelationFilter.java:137)
	at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilt
er(FilterInstanceWrapper.java:197)
	at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(W
ebAppFilterChain.java:90)
	at psdi.webclient.system.filter.PerformanceMonitor.doFilter(Pe
rformanceMonitor.java:126)
	at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilt
er(FilterInstanceWrapper.java:197)
	at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(W
ebAppFilterChain.java:90)
	at psdi.webclient.system.filter.HttpXFrameOptionsFilter.doFilt
er(HttpXFrameOptionsFilter.java:38)
	at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilt
er(FilterInstanceWrapper.java:197)
	at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(W
ebAppFilterChain.java:90)
	at psdi.webclient.system.filter.MTContextFilter.doFilter(MTCon
textFilter.java:53)
	at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilt
er(FilterInstanceWrapper.java:197)
	at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(W
ebAppFilterChain.java:90)
	at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter
(WebAppFilterManager.java:979)
	at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFi
lters(WebAppFilterManager.java:1119)
	at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleR
equest(CacheServletWrapper.java:82)
	at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebConta
iner.java:966)
	at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebC
ontainer.java:1817)
	at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChann
elLink.java:382)
	at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handle
Discrimination(HttpInboundLink.java:465)
	at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handle
NewRequest(HttpInboundLink.java:532)
	at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.proces
sRequest(HttpInboundLink.java:318)
	at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.co
mplete(HttpICLReadCallback.java:88)
	at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futur
eCompleted(AioReadCompletionListener.java:175)
	at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(Abstrac
tAsyncFuture.java:217)
	at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(A
syncChannelFuture.java:161)
	at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)

	at
com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
	at com.ibm.io.async.ResultHandler.runEventProcessingLoop(Resul
tHandler.java:775)
	at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)

	at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1909)
6.	Click for the second time New Customer Estimate button ? this
time the required screen is opening.
RESULT:
An error is displayed when creating a new customer estimate
EXPECTED RESULT:
No error should be displayed when creating a new customer
estimate
REPORTED IN VERSION:
Tivoli's process automation engine 7.6.1.2

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED:                                              *
* MAXIMO                                                       *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* ERROR WHILE CREATING NEW CUSTOMER ESTIMATE FROM WORK ORDER   *
* TRACKING (SP) APPLICATION                                    *
****************************************************************

    



Problem conclusion


    

  • _The fix for this APAR is contained in the following maintenance
package: release\fix pack for Release 7.6.1.3 Product_

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IJ36928
    • 

  • Reported component name
    MAXIMO ASST MGM
    • 

  • Reported component ID
    5724R46AM
    • 

  • Reported release
    761
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2022-01-04
    • 

  • Closed date
    2022-01-18
    • 

  • Last modified date
    2022-01-18
    • 





    

  • APAR is sysrouted FROM one or more of the following:
    

    • 

  • APAR is sysrouted TO one or more of the following:
    

    • 



Fix information


    

  • Fixed component name
    MAXIMO ASST MGM
    • 

  • Fixed component ID
    5724R46AM
    • 



Applicable component levels


    








      
              
                            

              

              [{"Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"761"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            19 January 2022
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback