MetaSolv Solution application hangs on PSR order; receives "FWK005 parse may not be called while parsing" error and crashes with "Error Number 39"

(Doc ID 1053467.1)

Last updated on APRIL 01, 2015

Applies to:

Oracle Communications MetaSolv Solution - Version 6.0.15 and later
Information in this document applies to any platform.
***** checked for relevance on 02-April-15 ************

Symptoms

On certain accounts, the application hangs after clicking on the product under the Service Location of a PSR order.  The application eventually displays an "xml parser error" and crashes with an "Error Number 39". Below are the errors received in GUI as well as those captured in the application server logs.

Screenshot of "xml parser error" in the application:


Error text
A data-related error occurred. Please use the detail button for more information.

PBPackageError: SAXException - xml parser error
FWK005 parse may not be called while parsing.

Screenshot of "Error Number 39" in the application:


Error text:
Error Number 39.
Error text = Error accessing external object property atn_count.
Window/Menu/Object = w_service_order.
Error Object/Control = w_service_order.
Script = of_set_services_tabpages.
Line in Script = 152.



Error captured in the appserverlog.xml file:

<log4j:event logger="cmm.invFromPB" timestamp="1262967701890" level="ERROR" thread="ExecuteThread: '89' for queue: 'weblogic.kernel.Default'" dateTime="Fri Jan 08 10:21:41 CST 2010" userName="appadmin" moduleName="cmm.invFromPB" appServerName="DEF_APPSERVER" messageID="10122" productName="nur" className="DEF_CLASS" debugCode="0" machineName="XXXXXXX">
<log4j:message><![CDATA[The server encountered the following Error: ]]></log4j:message>
                <log4j:cause><![CDATA[The server encountered the following Error:]]></log4j:cause>
                <log4j:action><![CDATA[The server encountered the following Error:]]></log4j:action>
<log4j:throwable><![CDATA[org.xml.sax.SAXException: FWK005 parse may not be called while parsing.
                at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
                at MetaSolv.utilities.powerbuilder.PBPackage.fromXML(PBPackage.java:518)
                at com.mslv.webapp.pblistener.PBListener.getPBPackageFromRequest(PBListener.java:692)
                at com.mslv.webapp.pblistener.PBListener.doPost(PBListener.java:400)
                at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
                at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
                at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1072)
                at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:465)
                at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:348)
                at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6981)
                at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
                at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3892)
                at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2766)
                at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:224)
                at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)
]]></log4j:throwable>
</log4j:event>

Error captured in the {SERVER}.mss log:

error in parseorg.xml.sax.SAXException: FWK005 parse may not be called while parsing.
The Database Administrator may report the following query as a top consumer of database resources:

SELECT  asap.std_item.description_2000,   
asap.item_spec.description_2000  ,
SIR.tn_assoc_item_cd,
A.order_count,
NVL(A.first_order , 0) first_order,
NVL(C.new_activity_order , 0) new_activity_order, 
?    current_order,
0  locked_ind,
asap.serv_item.serv_item_id,
asap.serv_item.disc_reason_cd,
D.internal_account ,
E.atn_count ,
F.value_code 
FROM  asap.serv_item,   
asap.item_spec,   
asap.std_item_rel  SIR,   
asap.std_item ,
( select  count(distinct SR.document_number) order_count,
min(SR.document_number)  first_order 
from  asap.serv_req_si  SRSI,
asap.serv_req SR
where  SRSI.document_number = SR.document_number
and SRSI.serv_item_id  = ?  
and SR.type_of_sr = 'SO'
and   rownum <= 2
and SR.service_request_status < 801) A ,
( select  min(SR.document_number)  new_activity_order  
from  asap.serv_req_si  SRSI, 
asap.serv_req SR 
where  SRSI.serv_item_id = ?    
and  SRSI.document_number  = SR.document_number 
and SR.type_of_sr = 'SO' 
and  SRSI.activity_cd = 'N' ) C, 
( SELECT  DISTINCT   asap.cust_acct_si.serv_item_id, 
asap.cust_acct_si.cust_acct_id internal_account  
FROM  asap.cust_acct_si , 
asap.cust_acct_rel 
WHERE  asap.cust_acct_rel.cust_acct_id_dwn = asap.cust_acct_si.cust_acct_id  and 
asap.cust_acct_rel.cust_acct_id_up = ?  and 
asap.cust_acct_si.ordered_for_ind = 'Y'  and 
asap.cust_acct_si.serv_item_id = ?   and 
asap.cust_acct_si.ordered_by_ind = 'N' ) D , 
( SELECT  COUNT (*) atn_count 
FROM  asap.assigned_tel_num  ATN 
WHERE  ATN.serv_item_id = ?  ) E ,
( SELECT  ? serv_item_id, 
value_code 
FROM  asap.serv_req_si_value 
WHERE  document_number = ? AND 
serv_item_id = ? AND 
label_cd = 'BBSVCCAT') F   
WHERE  asap.item_spec.item_spec_id  = asap.serv_item.spec_grp_id  and  
SIR.std_item_rel_id = asap.item_spec.std_item_rel_id  and  
SIR.item_type_cd_si_dwn = asap.std_item.item_type_cd  and   
SIR.item_cd_si_dwn  = asap.std_item.item_cd  and   
SIR.item_seq_si_dwn  = asap.std_item.item_seq  and   
asap.serv_item.serv_item_id  = ?  and 
asap.serv_item.serv_item_id = D.serv_item_id (+) and 
asap.serv_item.serv_item_id = F.serv_item_id (+)

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