Thursday, October 20, 2011

BI Publisher issue ends with java.lang.outOfMemory error

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:    BI Publisher issue ends with java.lang.outOfMemory error
 tmp file keeps extending upto around 30 MB even though program end with warning before than. i.e. tmp file keep extending after java.lang.outofmemory error.


Solution:


1.       Configure the Output Post Processor's JVM. These steps set the JVM to 2GB, depending upon
your server's size you might find 3 GB (-mx3072m), 4GB (-mx4096m) or even 5GB (-mx5120m) is a better value. This setting prevents the error "java.lang.OutOfMemoryError: Java heap space" in the Output Post Processor's log associated to the Subledger Accounting Program.

Login to SQL*Plus as APPS.
SQL>update FND_CP_SERVICES set DEVELOPER_PARAMETERS =
'J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx2048m'
where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME = 'FNDCPOPP'); 

Bounce the concurrent managers

2.       Increase the number of Output Post Processor as follows:

Logon to Applications with "System Administrator" responsibility 
Navigate to Concurrent -> Manager -> Define
Query for "Output Post Processor" 

Click on "Work Shifts" and Increase the number of processes. 
(If you have 2 processes then make them 4).
3.       1. Go to the XML Publisher Administrator responsibility.

2. Go to the Administration TAB

3. Set the three fields in the Admin page:

Under General -
Temporary directory : set the temporary directory to a large existing writable directory on the concurrent manager tier : Directory should have atleast 20 Gb free space. Set that directory name as temporary directory.

Under FO Processing -
Use XML Publisher's XSLT processor - True
Enable scalable feature of XSLT processor - NULL
Enable XSLT runtime optimization - True

4. Navigate to System Administrator => Profile => System => Query for the below profile and set the value at site level which is enough to complete the requests. (Input is in seconds)

Concurrent:OPP Process Timeout

5. Bounce the concurrent managers
4.       check the OPP Timeout must be set greater than 30min long (to include larger
XML data)
"Concurrent:OPP Process Timeout"
"Concurrent:OPP Response Timeout".
Change the both the values to big values like 10800.
Normally they would be in hundreds.
Please change them at site level. Then only they will reflect
References:
 BUG 8905212 - XML REPORT ENDS WITH JAVA.LANG.OUTOFMEMORY ERROR

XML/BI Publisher Reports Generating "java.lang.OutOfMemoryError" and OPP Logfile Shows "Check that the heap size per Output Post-processor service process is Sufficient" After Submitting Many Jobs [ID 371303.1]

Output Post Processor Fails Due To java.lang.OutOfMemoryError: ZIP002:OutOfMemoryError, MEM_ERROR in deflate_init2


Get Oracle Certifications for all Exams
Free Online Exams.com

XML/BI Publisher Reports Generating "java.lang.OutOfMemoryError" and OPP Logfile Shows "Check that the heap size per Output Post-processor service process is Sufficient" After Submitting Many Jobs

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:    XML/BI Publisher Reports Generating "java.lang.OutOfMemoryError" and OPP Logfile Shows "Check that the heap size per Output Post-processor service process is Sufficient" After Submitting Many Jobs

Symptoms:
When attempting to run a number of XML jobs in a row against the XML Post Processor the following error occurs.

Xml Publisher receives Exception: java.lang.OutOfMemoryError
java.lang.OutOfMemoryError

STEPS
Submit the XML jobs more than 10 times in a row.
Sometimes the error occurs quickly, sometimes it may take more than 15+ jobs to reproduce.

OPP LOGFILE Error:
Post-processing of request 311864 failed at 25-MAY-2006 12:42:14 with the error message:
The concurrent manager has timed out waiting for the Output Post-processor to finish this request.
Check that the heap size per Output Post-processor service process is sufficient.
Log files:


Solution:


The Output Post Processor did not have sufficient heap size per process defined.

The OPP needs to have sufficient heap size per process to handle the largest possible load.
1. Determine what the heap size per OPP process is currently:
select DEVELOPER_PARAMETERS from FND_CP_SERVICES
where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');

2. The default should be:
J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx512m

3. Increase the Heap Space per Process to 1024:
update FND_CP_SERVICES
set DEVELOPER_PARAMETERS =
'J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx1024m'
where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');

References:
XML/BI Publisher Reports Generating "java.lang.OutOfMemoryError" and OPP Logfile Shows "Check that the heap size per Output Post-processor service process is Sufficient" After Submitting Many Jobs [ID 371303.1]



Get Oracle Certifications for all Exams
Free Online Exams.com

Output Post Processor Fails Due To java.lang.OutOfMemoryError: ZIP002:OutOfMemoryError, MEM_ERROR in deflate_init2

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:    Output Post Processor Fails Due To java.lang.OutOfMemoryError: ZIP002:OutOfMemoryError, MEM_ERROR in deflate_init2

Symptoms:
The problem may occur in :
  • Large reports are being generated.
  • A large number of small reports are created within a short time frame.

Log files:
[7/31/08 3:15:38 PM] [1021643:RT46820325] Executing post-processing actions for request 46820325.
[7/31/08 3:15:38 PM] [1021643:RT46820325] Starting XML Publisher post-processing action.
[7/31/08 3:15:38 PM] [1021643:RT46820325] 
Template code: IRAR_RAXINV_XMLP_NEW_LT
Template app:  IRAR
Language:      en
Territory:     US
Output type:   PDF
[7/31/08 3:17:56 PM] [UNEXPECTED] [1021643:RT46820325] java.lang.OutOfMemoryError: ZIP002:OutOfMemoryError, MEM_ERROR in deflate_init2
at java.util.zip.Deflater.init(Native Method)
at java.util.zip.Deflater.<init>(Deflater.java(Inlined Compiled Code))
at oracle.apps.xdo.common.pdf.filter.DeflateFilter.deflate(DeflateFilter.java(Compiled Code))
at oracle.apps.xdo.generator.pdf.PDFStream.output(PDFStream.java(Compiled Code))
at oracle.apps.xdo.generator.pdf.PDFGenerator$ObjectManager.write(PDFGenerator.java(Compiled Code))
at oracle.apps.xdo.generator.pdf.PDFGenerator$ObjectManager.writeWritable(PDFGenerator.java(Inlined Compiled Code))
at oracle.apps.xdo.generator.pdf.PDFGenerator.closePage(PDFGenerator.java(Compiled Code))
at oracle.apps.xdo.generator.pdf.PDFGenerator.newPage(PDFGenerator.java(Compiled Code))
at oracle.apps.xdo.generator.ProxyGenerator.genNewPageWithSize(ProxyGenerator.java(Compiled Code))
at oracle.apps.xdo.generator.ProxyGenerator.processCommand(ProxyGenerator.java(Compiled Code))
at oracle.apps.xdo.generator.ProxyGenerator.processCommandsFromDataStream(ProxyGenerator.java(Compiled Code))
at oracle.apps.xdo.generator.ProxyGenerator.close(ProxyGenerator.java:1230)
at oracle.apps.xdo.template.fo.FOProcessingEngine.process(FOProcessingEngine.java:336)
at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:1043)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5888)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3438)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3527)
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:247)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:157)

[7/31/08 3:17:09 PM] [OPPServiceThread1] Post-processing request 46824024.

Solution:


The following patches are available:
  • Oracle E-Business Suite 11i: patch 7306874 ZIP002:OutOfMemoryError, MEM_ERROR in deflate_init2
    --> Also included in patch 6241631 11i.ATG_PF.H.delta.7
  • Oracle E-Business Suite Release 12.0.x (XDO.A): patch 7306874 ZIP002:OutOfMemoryError, MEM_ERROR in deflate_init2
  • Oracle E-Business Suite Release 12.1.x (XDO.B): At the time of writing this document (Mar 2010) development has not yet released a patch for this release though it is being worked upon. If needed then kindly raise a new Service Request via Metalink and request Global Customer Support for a backport of bug 7306874.

References:

Output Post Processor Fails Due To java.lang.OutOfMemoryError: ZIP002:OutOfMemoryError, MEM_ERROR in deflate_init2 [ID 734488.1]


Get Oracle Certifications for all Exams
Free Online Exams.com

HTTP transport error: javax.xml.soap.SOAPException: java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message send failed: Read timed out in BPEL

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:    HTTP transport error: javax.xml.soap.SOAPException: java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message send failed: Read timed out in BPEL
BPEL process which works on DB adaptaer in BPEL 
Status synchronize BPEL instance is failing for few declarations intermittently
Symptoms:

Log files:
 Error in logs
messages><input><sendClearanceMessageInputVariable><part xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" name="parameters"><sendClearanceMessageElement xmlns="http://impl.service.clearance.declaration.customs.pcfc.com/types/">
<declarationNumber>1050000327410</declarationNumber>
</sendClearanceMessageElement>
</part></sendClearanceMessageInputVariable></input><fault><remoteFault xmlns="http://schemas.oracle.com/bpel/extension"><part name="summary"><summary>exception on JaxRpc invoke: HTTP transport error: javax.xml.soap.SOAPException: java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message send failed: Read timed out</summary>
</part></remoteFault></fault></messages>

Node 2_SOA~OC4J_SOA~default_group~1.log
-----------------
<2010-01-13 15:31:32,390> <INFO> <declaration.collaxa.cube.ws> <AdapterFramework::Outbound> file:/u01/app/sit/bpel/domains/declaration/tmp/.bpel_EnqueueClearanceProcess_0.22.5.0_298f508cf1c437f24a56b651b1b2636b.tmp/SID_invoke.wsdl [ Enqueue_ptt::Enqueue(Clearance) ] - Using JCA Connection Pool - max size = <unbounded>
<2010-01-13 15:31:32,390> <WARN> <declaration.collaxa.cube.ws> <AdapterFramework::Outbound> file:/u01/app/sit/bpel/domains/declaration/tmp/.bpel_EnqueueClearanceProcess_0.22.5.0_298f508cf1c437f24a56b651b1b2636b.tmp/SID_invoke.wsdl [ Enqueue_ptt::Enqueue(Clearance) ] - JNDI lookup of 'eis/AQ/AQSIT' failed due to: eis/AQ/AQSIT not found
<2010-01-13 15:31:32,390> <INFO> <declaration.collaxa.cube.ws> <AdapterFramework::Outbound> Since unable to locate the JCA Resource Adapter deployed at 'eis/AQ/AQSIT', will then attempt to instantiate ManagedConnectionFactory oracle.tip.adapter.aq.AQManagedConnectionFactory directly.
<2010-01-13 15:31:32,391> <ERROR> <declaration.collaxa.cube.ws> <AdapterFramework::Outbound> file:/u01/app/sit/bpel/domains/declaration/tmp/.bpel_EnqueueClearanceProcess_0.22.5.0_298f508cf1c437f24a56b651b1b2636b.tmp/SID_invoke.wsdl [ Enqueue_ptt::Enqueue(Clearance) ] - Could not invoke operation 'Enqueue' against the 'AQ Adapter' due to: 
ORABPEL-11905
Error while obtaining handle to JDBC connection.
Error while obtaining handle to JDBC connection.
Please examine the log file to determine the problem.

<2010-01-13 15:31:32,391> <INFO> <declaration.collaxa.cube.ws> <AdapterFramework::Outbound> Change logging level for Logger 'declaration.collaxa.cube.ws' to DEBUG to see full error stack
<2010-01-13 15:31:32,391> <ERROR> <declaration.collaxa.cube.ws> <AdapterFramework::Outbound> file:/u01/app/sit/bpel/domains/declaration/tmp/.bpel_EnqueueClearanceProcess_0.22.5.0_298f508cf1c437f24a56b651b1b2636b.tmp/SID_invoke.wsdl [ Enqueue_ptt::Enqueue(Clearance) ] - Rolling back JCA LocalTransaction
<2010-01-13 15:31:32,392> <ERROR> <declaration.collaxa.cube.ws> <WSIFInvocationHandler::invoke> Fault happened: file:/u01/app/sit/bpel/domains/declaration/tmp/.bpel_EnqueueClearanceProcess_0.22.5.0_298f508cf1c437f24a56b651b1b2636b.tmp/SID_invoke.wsdl [ Enqueue_ptt::Enqueue(Clearance) ] - WSIF JCA Execute of operation 'Enqueue' failed due to: Error while obtaining handle to JDBC connection.
Error while obtaining handle to JDBC connection.
; nested exception is: 
ORABPEL-11905
Error while obtaining handle to JDBC connection.
Error while obtaining handle to JDBC connection.
Please examine the log file to determine the problem.

<2010-01-13 15:31:32,877> <ERROR> <declaration.collaxa.cube> <BaseCubeSessionBean::logError> Error while invoking bean "delivery": Waiting for response has timed out. The conversation id is null. Please check the process instance for detail.
com.oracle.bpel.client.delivery.ReceiveTimeOutException: Waiting for response has timed out. The conversation id is null. Please check the process instance for detail.
at com.collaxa.cube.ejb.impl.DeliveryBean.request(DeliveryBean.java:109)
at sun.reflect.GeneratedMethodAccessor70.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.evermind.server.ejb.interceptor.joinpoint.EJBJoinPointImpl.invoke(EJBJoinPointImpl.java:35)
at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.DMSInterceptor.invoke(DMSInterceptor.java:52) 
.....


Node1_SOA~OC4J_SOA~default_group~1.log
---------------------
<2010-01-13 15:34:21,660> <ERROR> <declaration.collaxa.cube.ws> <WSIFInvocationHandler::invoke> Fault happened: file:/u02/app/sit/bpel/domains/declaration/tmp/.bpel_EnqueueClearanceProcess_0.22.5.0_298f508cf1c437f24a56b651b1b2636b.tmp/SID_invoke.wsdl [ Enqueue_ptt::Enqueue(Clearance) ] - WSIF JCA Execute of operation 'Enqueue' failed due to: Adapter Framework unable to create outbound JCA connection.
file:/u02/app/sit/bpel/domains/declaration/tmp/.bpel_EnqueueClearanceProcess_0.22.5.0_298f508cf1c437f24a56b651b1b2636b.tmp/SID_invoke.wsdl [ Enqueue_ptt::Enqueue(Clearance) ] - : The Adapter Framework was unable to establish an outbound JCA connection due to the following issue: ORABPEL-11929
SQL error while creating managed (database) connection.
SQL error while creating managed (database) connection: Unable to get a physical connection from the database...there are no connections available.
Please examine the log file to determine the problem.
[Caused by: Unable to get a physical connection from the database...there are no connections available.]
; nested exception is: 
ORABPEL-12511
Adapter Framework unable to create outbound JCA connection.
file:/u02/app/sit/bpel/domains/declaration/tmp/.bpel_EnqueueClearanceProcess_0.22.5.0_298f508cf1c437f24a56b651b1b2636b.tmp/SID_invoke.wsdl [ Enqueue_ptt::Enqueue(Clearance) ] - : The Adapter Framework was unable to establish an outbound JCA connection due to the following issue: ORABPEL-11929
SQL error while creating managed (database) connection.
SQL error while creating managed (database) connection: Unable to get a physical connection from the database...there are no connections available.
Please examine the log file to determine the problem.
[Caused by: Unable to get a physical connection from the database...there are no connections available.]
Please examine the log file for any reasons. Enable DEBUG logging in the BPEL Console.

10/01/13 15:34:23 java.sql.SQLException: Unable to get a physical connection from the database...there are no connections available.
10/01/13 15:34:23 at oracle.oc4j.sql.spi.ManagedConnectionImpl$GenericConnectionUseStrategy.initForUse(ManagedConnectionImpl.java:1188)
10/01/13 15:34:23 at oracle.oc4j.sql.spi.ManagedConnectionImpl$OracleConnectionUseStrategy.initForUse(ManagedConnectionImpl.java:1233)
10/01/13 15:34:23 at oracle.oc4j.sql.spi.ManagedConnectionImpl.initForUse(ManagedConnectionImpl.java:156)
10/01/13 15:34:23 at oracle.oc4j.sql.spi.ManagedConnectionImpl.<init>(ManagedConnectionImpl.java:106)
10/01/13 15:34:23 at oracle.oc4j.sql.spi.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:171) 
............

Solution:


you have a BPEL process that includes an outbound AQ Adapter, make sure that you have done the following on the production env;
1- created connector-factory in the $ORACLE_HOME/j2ee/OC4J_PSOA/application-deployments/default/DBAdapter/oc4j-ra.xml
Note, the connection factory name must match the JNDI Name in the *.wsdl file that was generated from the creation of the AQ Adapter.

2- Make sure that the Queue where you enqueue messages has been already created in the DB




Get Oracle Certifications for all Exams
Free Online Exams.com

BPEL container abnormally terminated and after that it is not starting

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
 Problem:    BPEL container abnormally terminated and after that it is not starting

Log files:
warnings in the logs 

10/01/14 11:01:12 Exception in thread "PingWaiter" java.lang.OutOfMemoryError: unable to create new native thread
10/01/14 11:01:12 at java.lang.Thread.start0(Native Method)
10/01/14 11:01:12 at java.lang.Thread.start(Thread.java:574)
10/01/14 11:01:12 at org.collaxa.thirdparty.jgroups.protocols.PingSender.start(PingSender.java:34)
10/01/14 11:01:12 at org.collaxa.thirdparty.jgroups.protocols.PingWaiter.findInitialMembers(PingWaiter.java:113)
10/01/14 11:01:12 at org.collaxa.thirdparty.jgroups.protocols.PingWaiter.run(PingWaiter.java:99)
10/01/14 11:01:12 at java.lang.Thread.run(Thread.java:595)
rejoin the cluster

Jan 14, 2010 1:08:27 PM org.collaxa.thirdparty.jgroups.protocols.pbcast.ClientGmsImpl join
WARNING: join(172.29.16.30:49652) sent to 172.29.16.30:55491 timed out, retrying
Jan 14, 2010 1:08:34 PM org.collaxa.thirdparty.jgroups.protocols.pbcast.ClientGmsImpl join
WARNING: join(172.29.16.30:49652) sent to 172.29.16.30:55491 timed out, retrying
Jan 14, 2010 1:08:41 PM org.collaxa.thirdparty.jgroups.protocols.pbcast.ClientGmsImpl join
WARNING: join(172.29.16.30:49652) sent to 172.29.16.30:55491 timed out, retrying

Solution:


1.       As this happened after processing many large files, and combined with the OOM error you saw , there is a bug that you might be hitting that matches this behavior
Bug 8813964 BPEL PROCESS LOOPS WHILE PROCESSING LARGE FILE

The fix for this bug is included in MLR #19 for 10.1.3.3 - patch number 8590151
2.       maxpermSize determine size of heap allocated to OC4J Processes.

If you have enough memory please increse 
-XX:MaxPermSize=512M
for the BPEL container 
3.       Also to reduce risk of nodes dropping from the cluster you can increase the fault detection FD timeout setting. FD timeout specifies the maximum time in milliseconds for a cluster node to respond to a message. A node will be dropped from a cluster after the max number of tries is reached without a response. Both the UDP and TCP sections useFD timeout and max_tries.

Detail information, please reference 

6.11 jGroup Nodes May Drop Out of the BPELCluster


These 2 combined should prevent further OOM error on the system 
<FD timeout="2000"
max_tries="3"
shun="true"/>
References:
Note 455152.1 How To Configure BPEL 10.1.3 Cluster
note 967076.1 jGroup Nodes May Drop Out of the BPELCluster



Get Oracle Certifications for all Exams
Free Online Exams.com

Unable to find an Output Post Processor service to post-process request, FND_CP_GSM_OPP_AQ Queue is Invalidated After Patching

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:    Unable to find an Output Post Processor service to post-process request, FND_CP_GSM_OPP_AQ Queue is Invalidated After Patching

Symptoms:
XML concurrent requests getting failed with the error: 

+---------------------------------------------------------------------------+
Executing request completion options...

+------------- 1) PUBLISH -------------+
Unable to find an Output Post Processor service to post-process request 13400761.

Check that the Output Post Processor service is running.

After restarting the completed database and application now OPP log contains below error:

[2/28/10 8:03:54 PM] [UNEXPECTED] [OPPAQMON:97381] Too many SQL errors, shutting down AQ monitor
[2/28/10 8:03:54 PM] [EXCEPTION] [OPPAQMON:97381] java.sql.SQLException: Closed Connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleConnection.privatePrepareCall(OracleConnection.java:1163)
at oracle.jdbc.driver.OracleConnection.prepareCall(OracleConnection.java:1075)
at oracle.apps.fnd.cp.opp.OPPAQMonitor.unsubscribeFromAQ(OPPAQMonitor.java:574)
at oracle.apps.fnd.cp.opp.OPPAQMonitor.run(OPPAQMonitor.java:131)
at java.lang.Thread.run(Thread.java:534)
Log files:


Solution:


1.       Close concurrent manager and makes sure that there is no FNDLIB processes is running then follow 
Note: 134007.1 CMCLEAN.SQL - Non Destructive Script to Clean Concurrent Manager Tables.
Retest the issue
2.       Bug.8337735 (92) XML REPORTS ARE COMPLETED WITH STATUS WANING.: 


Reduce the number of OPP processes, ensure that you have only 1 in the OPP processes and change the threads to be 5 instead of 6. 
Bounce the CM and retest again.
3.       Recreate the queue using  $FND_TOP/patch/115/sql/afopp002.sql file as 'APPLSYS' user.  On running the script you will be prompted for username and password.

4.       Republish those requests to get the real output generated by applying the template.

References:
FND_CP_GSM_OPP_AQ Queue is Invalidated After Patching [ID 311851.1]



Get Oracle Certifications for all Exams
Free Online Exams.com

When using ORA:PARSEESCAPEDXML() in our code we were successfully parsing &amp; characters before applying the MLR#9 but after applying MLR#9 we are unable to process this messages.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:    When using ORA:PARSEESCAPEDXML() in our code we were successfully parsing &amp;amp; characters before applying the MLR#9 but after applying MLR#9 we are unable to process this messages. 

Log files:
ora:parseEscapedXML(string). The function takes a string as a parameter and
returns structured XML data
As per Note: 861637.1 The only options is to change the input variable and 
use "&" as a replacement of '&' in stringContent variable.
As per Note 567712.1, modify your xml code from ora:parseEscapedXML to
ora:parseXML

The above scenario did not work on 11.1.1.2 soa instance also, we got the
following error :

java.lang.Exception:
oracle.sysman.emSDK.webservices.wsdlapi.SoapTestException: XPath expression
failed to execute.
An error occurs while processing the XPath expression; the expression is
@ oraext:parseEscapedXML(bpws:getVariableData('inputVariable','payload','/client
:process/client:input')).
The XPath expression failed to execute; the reason was: internal xpath error.
Check the detailed root cause described in the exception message text and
verify that the XPath query is correct. at
oracle.sysman.emas.model.wsmgt.WSTestModel.invokeOperation(WSTestModel.java:57
5) at oracle.sysman.emas.view.wsmgt.WSView.invokeOperation(WSView.java:381)
at oracle.sysman.emas.view.wsmgt.WSView.invokeOperation(WSView.java:298) at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.j
ava:25) at java.lang.reflect.Method.invoke(Method.java:597) at
com.sun.el.parser.AstValue.invoke(AstValue.java:157) at
com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:283) at
org.apache.myfaces.trinidadinternal.taglib.util.MethodExpressionMethodBinding.
invoke(MethodExpressionMethodBinding.java:53) at
@ org.apache.myfaces.trinidad.component.UIXComponentBase.broadcastToMethodBindin
g(UIXComponentBase.java:1245) at
@ org.apache.myfaces.trinidad.component.UIXCommand.broadcast(UIXCommand.java:183
) at
@ oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$1.run(Contex
tSwitchingComponent.java:90) at
@ oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhas
e(ContextSwitchingComponent.java:309) at
@ oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.broadcast(Co
ntextSwitchingComponent.java:94) at
@ oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:1
02) at
@ oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$1.run(Contex
tSwitchingComponent.java:90) at
@ oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhas
e(ContextSwitchingComponent.java:309) at
@ oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.broadcast(Co
ntextSwitchingComponent.java:94) at
@ oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:9
@ 6) at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:475)
@ at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:756)
at
oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._invokeApplication(Lifec
ycleImpl.java:698) at
oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleI
mpl.java:285) at
oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.ja
va:177) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265) at
weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecu
rityHelper.java:227) at
weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.
java:125) at
weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26) at
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at
oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(Registra
tionFilter.java:97) at
org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.
doFilter(TrinidadFilterImpl.java:420) at
oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)
at
org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.
doFilter(TrinidadFilterImpl.java:420) at
org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(Tr
inidadFilterImpl.java:247) at
org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(Trinida
dFilterImpl.java:157) at
org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java
:92) at
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.help.web.rich.OHWFilter.doFilter(Unknown Source) at
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.sysman.emSDK.license.LicenseFilter.doFilter(LicenseFilter.java:101)
at
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at
oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:191)
at
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at
oracle.sysman.emas.fwk.MASConnectionFilter.doFilter(MASConnectionFilter.java:4
1) at
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:159)
at
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at
oracle.sysman.eml.app.AuditServletFilter.doFilter(AuditServletFilter.java:179)
at
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
@ at oracle.sysman.eml.app.EMRepLoginFilter.doFilter(EMRepLoginFilter.java:203)
at
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.sysman.core.app.perf.PerfFilter.doFilter(PerfFilter.java:141) at
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at
oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:542)
at
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.dms.wls.DMSServletFilter.doFilter(DMSServletFilter.java:326) at
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at
weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.jav
a:27) at
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(Web
AppServletContext.java:3592) 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(WebAppServletCon
text.java:2202) at
weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.ja
va:2108) at
weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1432)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201) at
weblogic.work.ExecuteThread.run(ExecuteThread.java:173) Caused by:
oracle.sysman.emSDK.webservices.wsdlapi.SoapTestException: XPath expression
failed to execute. An error occurs while processing the XPath expression; the
expression is
@ oraext:parseEscapedXML(bpws:getVariableData('inputVariable','payload','/client
:process/client:input')). The XPath expression failed to execute; the reason
was: internal xpath error. Check the detailed root cause described in the
exception message text and verify that the XPath query is correct. at
oracle.sysman.emSDK.webservices.wsdlapi.dispatch.DispatchUtil.invoke(DispatchU
til.java:260) at
oracle.sysman.emSDK.webservices.wsdlparser.OperationInfoImpl.invokeWithDispatc
h(OperationInfoImpl.java:985) at
oracle.sysman.emas.model.wsmgt.PortName.invokeOperation(PortName.java:716) at
oracle.sysman.emas.model.wsmgt.WSTestModel.invokeOperation(WSTestModel.java:56
9) ... 68 more Caused by: javax.xml.ws.soap.SOAPFaultException: XPath
expression failed to execute. An error occurs while processing the XPath
expression; the expression is
@ oraext:parseEscapedXML(bpws:getVariableData('inputVariable','payload','/client
:process/client:input')). The XPath expression failed to execute; the reason
was: internal xpath error. Check the detailed root cause described in the
exception message text and verify that the XPath query is correct. at
oracle.j2ee.ws.client.jaxws.DispatchImpl.throwJAXWSSoapFaultException(Dispatch
Impl.java:882) at
oracle.j2ee.ws.client.jaxws.DispatchImpl.invoke(DispatchImpl.java:715) at
@ oracle.j2ee.ws.client.jaxws.OracleDispatchImpl.synchronousInvocationWithRetry(
OracleDispatchImpl.java:226) at
@ oracle.j2ee.ws.client.jaxws.OracleDispatchImpl.invoke(OracleDispatchImpl.java:
97) at
oracle.sysman.emSDK.webservices.wsdlapi.dispatch.DispatchUtil.invoke(DispatchU
til.java:256) ... 71 more

Solution:


Bug:9245013 

try the following workarounds:

1) Replace the "&" with "&amp;" .You can use a Java exec in the BPEL code
to implement this workaround.

String temp = (((Element)getVariableData("inputVariable",
"payload","/client:ParseEscapedXMLTestProcessRequest/client:input")).getFirstC
hild()).getNodeValue();
System.out.println("String temp before manipulation: " + temp); 
addAuditTrailEntry("String temp before manipulation: " + temp);
temp = temp.replaceAll("&", "&amp"); 
//we have tried this also;
// temp = temp.replaceAll("&amp", "&");
System.out.println("String temp after manipulation: " + temp); 
addAuditTrailEntry("String temp after manipulation: " + temp);
(((Element)getVariableData("inputVariable",
"payload","/client:ParseEscapedXMLTestProcessRequest/client:input")).getFirstC
hild()).setNodeValue(temp);

2) The above workaround did not work also, we have tried the following:
modify xml code from ora:parseEscapedXML to ora:parseXML(),

References:




Get Oracle Certifications for all Exams
Free Online Exams.com

ORABPEL-12511, javax.resource.spi.ResourceAllocationException: Unable to allocate new connection

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:    ORABPEL-12511, javax.resource.spi.ResourceAllocationException: Unable to allocate new connection

Symptoms:
 PRODUTION BPEL CONNECTION POOL TO DE-HYDRATION STORE IN OAS has waiting threads 

Observations:- one of the connection pool has waiting threads , while the other is free 

when this happens INSTANCES ARE NOT FOUND IN BPEL CONSOLE - Missing instances
Log files:
<MSG_TEXT>Failed to set the internal configuration of the OC4J JMS Server with: XMLJMSServerConfig[file:/u01/app/oracle/products/OAS/1013/SOA/j2ee/oc4j_soa/config/jms.xml]</MSG_TEXT>
<SUPPL_DETAIL><![CDATA[java.lang.InstantiationException: ServerFile[PersistentMap,/u01/app/oracle/products/OAS/1013/SOA/j2ee/oc4j_soa/persistence/oc4j_soa_default_group_1/jms.state]: persistence file could not be locked. Resolve the sharing violation by ending the process currently holding the file lock or by using a different persistence directory for one or both processes.
at com.evermind.server.jms.JMSUtils.make(JMSUtils.java:1075)
at com.evermind.server.jms.JMSUtils.toInstantiationException(JMSUtils.java:1240)
at com.evermind.server.jms.JMSServer.recoverState(JMSServer.java:1831)
at com.evermind.server.jms.JMSServer.internalSetConfig(JMSServer.java:209)
at com.evermind.server.jms.JMSServer.setConfig(JMSServer.java:182)
at com.evermind.server.ApplicationServer.initializeJMS(ApplicationServer.java:2455)
at com.evermind.server.Application

Solution:


1- Apply MLR# 9 Patch 8589928

2- Review information mentioned on below documents to verify the correctness of their setup
###########################################################################



1) "http://download.oracle.com/docs/cd/E10291_01/core.1013/e10294/toc.htm" (Oracle® Application Server Enterprise Deployment Guide)

2) "http://www.oracle.com/technology/tech/soa/pdf/oracle-soa-suite-xa-rac-guide.pdf" (Oracle SOA Suite 10g XA and RAC Database Configuration Guide)
===> Document contains BPEL Engine / Adapters -AQ , DB, ...- XA specific configurations

3) "http://download-uk.oracle.com/docs/cd/B31017_01/integrate.1013/b28994/toc.htm" (Oracle® Application Server Adapters for Files, FTP, Databases, and Enterprise Messaging User's Guide 10g Release 3 (10.1.3.1.0))

4) "http://www.oracle.com/technology/tech/soa/pdf/oracle-soa-suite-ha-faq.pdf" (Oracle SOA Suite High-Availability FAQ and Troubleshooting Guide)

5) As per information mentioned on bpel.xml file

<faultPolicyBindings>
<process faultPolicy="FaultPolicySynchronous"/>
</faultPolicyBindings>


Please Review information mentioned on "http://www.oracle.com/technology/products/ias/bpel/pdf/10133technotes.pdf" to confirm that you've defined below properties for the fault policy defined
===================the following configuration means 10 retries, at 60 second intervals===========================
<property name="retryMaxCount">10</property>
<property name="retryInterval">60</property>
==================================================================================================================


6) Please follow information mentioned on "http://download-uk.oracle.com/docs/cd/B31017_01/integrate.1013/b28994/app_trblshoot.htm" ==> A.4.2.2 I/O Exception: Network Adapter Could Not Establish the Connection in order to confirm that connectionString is correct, and the database and listener are up

7) (<jca:address location="eis/AQ/AQSIT" UIConnectionName="AQSIT") used on "DPW_invoke.wsdl_after_code_change" but not defined on "oc4j_ra__after_code_change", So please again we need to perform following action
+ Please create the conn factory "eis/AQ/AQSIT" in the AQ adapter , redeploy the BPEL process and retest
References:
Note 461615.1 "OPMN Not Able to Start OC4J Component When 4 or More JVMs "
AQ Adapter: ORABPEL-12511, javax.resource.spi.ResourceAllocationException: Unable to allocate new connection + (Doc ID 730285.1)

 "http://download.oracle.com/docs/cd/E10291_01/core.1013/e10294/toc.htm" (Oracle® Application Server Enterprise Deployment Guide)

 "http://www.oracle.com/technology/tech/soa/pdf/oracle-soa-suite-xa-rac-guide.pdf" (Oracle SOA Suite 10g XA and RAC Database Configuration Guide)
===> Document contains BPEL Engine / Adapters -AQ , DB, ...- XA specific configurations

 "http://download-uk.oracle.com/docs/cd/B31017_01/integrate.1013/b28994/toc.htm" (Oracle® Application Server Adapters for Files, FTP, Databases, and Enterprise Messaging User's Guide 10g Release 3 (10.1.3.1.0))

 "http://www.oracle.com/technology/tech/soa/pdf/oracle-soa-suite-ha-faq.pdf" (Oracle SOA Suite High-Availability FAQ and Troubleshooting Guide)



Get Oracle Certifications for all Exams
Free Online Exams.com

on Widnows 7 with IE8 while using Oracle SSO it is displaying the SSO login page instead of automatically authenticating the user since it is WNA enabled.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:    on Widnows 7 with IE8 while using Oracle SSO it is displaying the SSO login page instead of automatically authenticating the user since it is WNA enabled.
On windows 7 desktop users, SSO is not authenticating the users and displaying the SSO login page and also Jinit for Ebusiness Suite is not working.
Symptoms:
 Windows 7 is not yet certified/supported to work with EBS.
Could you provide the version of:

- Jinitiator/Java plug-in used in client PC
- browser
- Forms

Solution:


Windows 7 is not yet certified with AS - please check the following link:

8.3 Oracle Application Server Browser Certification
http://www.oracle.com/technology/software/products/ias/files/idm_certification_101401.html#SEC83

Windows 7 is not yet certified with AS. Logged an enhancement request under:

bug 9127966 - WINDOWS 7 WITH IE8 PLATFORM CERTIFIED FOR SSO AND WNA 





Get Oracle Certifications for all Exams
Free Online Exams.com

FND_CP_GSM_OPP_AQ Queue is Invalidated After Patching

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:    FND_CP_GSM_OPP_AQ Queue is Invalidated After Patching

Symptoms:
After applying patches, FND_CP_GSM_OPP_AQ queue becomes invalidated. The patches can be any, including Technology patches like (FND,OWF, OAF) or functional patches like (AP, AR,OM etc).
ORA-600 [kqludp2] is seen in the alert log.

The PL/SQL Call Stack may have elements of the following:
package body SYS.DBMS_RULE_ADM
anonymous block
package body SYS.DBMS_AQADM_SYS
package body SYS.DBMS_PRVTAQIS
package body SYS.DBMS_AQADM_SYS
package body SYS.DBMS_AQADM
package body APPS.FND_CP_OPP_IPC

The call stack may look similar to the following:
kgerinv kgeasnmierr kqludp kwraadr kwriadr spefcmpa spefmccallstd pextproc peftrusted psdexsp rpiswu2 psdextp pefccal pefcal pevm_FCAL pfrrun peicnt <- kkxexe


Solution:


Patch application (or) Validating and Compiling the Apps schema while Output Post processor (OPP) is up and running.

If the OPP service is running and there are messages in FND_CP_GSM_OPP_AQ queue, applying patches will invalidate this queue. The patch/patches internally validate and compile the schema making the data in the queue to be inconsistent.
If OPP service is not running then all requests that use XML Publisher transformation will fail and if FND_CP_GSM_OPP_AQ queue is not up and running, the OPP service fails to start.


1. Recreate the queue using  $FND_TOP/patch/115/sql/afopp002.sql file as 'APPLSYS' user.  On running the script you will be prompted for username and password.
2. Republish those requests to get the real output generated by applying the template.

References:

FND_CP_GSM_OPP_AQ Queue is Invalidated After Patching [ID 311851.1]


Get Oracle Certifications for all Exams
Free Online Exams.com

Unable to Find an Output Post Processor Service to Post-Process Request, "FRM-40212: Invalid value for field MGR_TYPE_ICM"

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:    Unable to Find an Output Post Processor Service to Post-Process Request, "FRM-40212: Invalid value for field MGR_TYPE_ICM"

Symptoms:
All the Bi Publisher reports are failing with the warning :

"Unable to find an Output Post Processor service to post-process request"

 When the Concurrent Manager Define form , FNDCPDCQ, is queried for the 'Output Post Processor' manager, FNDCPOPP, the following error occurs.

"FRM-40212: Invalid value for field MGR_TYPE_ICM"


Solution:



The value for the MANAGER_TYPE/SERVICE_ID  columns in certain tables is < 1000 . 
Solution
1. Backup the tables from sqlplus...

create table fnd_cp_services_tl_bak as select * from fnd_cp_services_tl

create table fnd_cp_services_bak as select * from fnd_cp_services

create table fnd_concurrent_queues_bak as select * from fnd_concurrent_queues

2.Run the following select statement to bring back a numeric value for the manager type for FNDCPOPP eg 21 .
select CONCURRENT_QUEUE_NAME,MANAGER_TYPE from fnd_concurrent_queues
where CONCURRENT_QUEUE_NAME = 'FNDCPOPP';

3. Shutdown the concurrent managers eg adcmctl.sh stop apps/apps


4. Update the tables using the sql below
( Use the numeric value obtained from step 2 to replace '21' in the sql statements below )


update fnd_cp_services
set service_id=1091
where service_id=21;

update fnd_cp_services_tl
set service_id=1091
where service_id=21;

update fnd_concurrent_queues
set manager_type=1091
where manager_type=21;

5. The three sql statements above should update 1 row each, if all 3 do this then commit otherwise rollback.

6. Restart the concurrent managers eg adcmctl.sh start apps/apps


References:
Unable to Find an Output Post Processor Service to Post-Process Request [ID 783046.1]



Get Oracle Certifications for all Exams
Free Online Exams.com

Error while obtaining handle to JDBC connection.; nested exception is: ORABPEL-11905

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:    Error while obtaining handle to JDBC connection.; nested exception is: ORABPEL-11905

Symptoms:
BPEL Enqueue clearance process message is failing for few declarations intermittently
we get this error in BPEL logs

<ERROR> <declaration.collaxa.cube.ws> <WSIFInvocationHandler::invoke> Fault happened: file:/u03/app/si
tnew1/bpel/domains/declaration/tmp/.bpel_EnqueueClearanceProcess_0.22.0.5.1_81e51e874704d9b8ed7dcdeac0b289a3.tmp/DPW_invoke.wsdl
[ Enqueue_ptt::Enqueue(Clearance) ] - WSIF JCA Execute of operation 'Enqueue' failed due to: Error while obtaining handle to JD
BC
connection.

Error while obtaining handle to JDBC connection.
; nested exception is: 
ORABPEL-11905
Error while obtaining handle to JDBC connection.
Error while obtaining handle to JDBC connection


Log files:

10/02/01 09:59:19 QName string is DPPException
10/02/01 10:15:39 pFaultMessage is org.collaxa.thirdparty.apache.wsif.base.WSIFDefaultMessage@e105c08 name:DPPException
10/02/01 10:15:39 QName string is DPPException
10/02/01 11:07:42 pFaultMessage is org.collaxa.thirdparty.apache.wsif.base.WSIFDefaultMessage@668bda5a name:DPPException
10/02/01 11:07:42 QName string is DPPException
10/02/01 12:24:42 pFaultMessage is org.collaxa.thirdparty.apache.wsif.base.WSIFDefaultMessage@32835e3e name:DPPException
10/02/01 12:24:42 QName string is DPPException
10/02/01 12:32:01 pFaultMessage is org.collaxa.thirdparty.apache.wsif.base.WSIFDefaultMessage@6645db6c name:DPPException
10/02/01 12:32:01 QName string is DPPException
<2010-02-01 12:57:34,995> <ERROR> <declaration.collaxa.cube.engine.data> <BaseDocumentHandler::load> 
java.sql.SQLException: Closed Connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
::::::::::::::
::::::::::::::
at java.lang.Thread.run(Thread.java:595)
10/02/01 12:57:35 java.sql.SQLException: Closed Connection
10/02/01 12:57:35 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
::::::::::::::::::
::::::::::::::::::
<2010-02-01 12:57:35,140> <ERROR> <declaration.collaxa.cube.engine.data> <BaseDeliveryPersistenceAdaptor::loadInvokeMetaData> 
ORABPEL-09222

Cannot deserialize DOM element.
Failed to deserialize the DOM element from binary format, the document id 793afcd967e47fcd:58734659:126885d9d4c:74ac. The exception reported is Cannot fetch document.
The process domain was unable to fetch the document "793afcd967e47fcd:58734659:126885d9d4c:74ac" from the datastore. The exception reported is: Closed Connection
Please check that the machine hosting the datasource is physically connected to the network. Otherwise, check that the datasource connection parameters (user/password) is currently valid.
sql statement: SELECT dockey, bin_csize, bin_usize, bin_format, bin FROM xml_document WHERE dockey = ? 


at com.collaxa.cube.xml.dom.SDOMHelper.loadCompressedNormalDocuments(SDOMHelper.java:384)
at com.collaxa.cube.xml.dom.SDOMHelper.loadDocuments(SDOMHelper.java:153)
:::::::::::::::::
:::::::::::::::::
<2010-02-01 12:57:35,150> <ERROR> <declaration.collaxa.cube.engine.data> <DBUtils::close> Caught NPE from JDBC layer: 
java.lang.NullPointerException
at oracle.oc4j.sql.proxy.StatementBCELProxy.oc4j_releaseToCache(StatementBCELProxy.java:67)
at oracle.oc4j.sql.proxy.StatementBCELProxy.oc4j_releaseTarget(StatementBCELProxy.java:79)
::::::::::::::::::
::::::::::::::::::
Exception: java.lang.NullPointerException
Handled As: com.collaxa.cube.engine.EngineException

ORABPEL-00000

Exception not handled by the Collaxa Cube system.
An unhandled exception has been thrown in the Collaxa Cube system. The exception reported is: "java.lang.NullPointerException
at com.collaxa.cube.engine.util.DBUtils.close(DBUtils.java:796)
at com.collaxa.cube.engine.adaptors.common.BaseDeliveryPersistenceAdaptor.__loadInvoke(BaseDeliveryPersistenceAdaptor.java:2250)
:::::::::::
::::::::::
10/02/02 14:37:50 QName string is DPPException


FileName
--------
BPEL~oc4j_soa~default_group~1.log

Solution:


Apply MLR #9



Get Oracle Certifications for all Exams
Free Online Exams.com