ORABPEL-00540 performance degradation observed via BPEL Console java.sql.SQLException: Declaration ID already exists at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)

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-00540 performance degradation observed via BPEL Console

java.sql.SQLException: Declaration ID already exists at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)

exception on JaxRpc invoke: HTTP transport error: javax.xml.soap.SOAPException: java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message send failed: Broken pipe (errno:32)

he following error repeat over and over again in the log:

ORABPEL-00540

Fault policy not available in fault policy manager.
Cannot access fault policy "DefaultPolicy".

at com.collaxa.cube.engine.ext.wmp.faultpolicy.RecoverFault.resolveToActionRef(RecoverFault.java:327)
at com.collaxa.cube.engine.ext.wmp.faultpolicy.RecoverFault.resolveAndRecover(RecoverFault.java:343)
at com.collaxa.cube.engine.ext.wmp.BPELInvokeWMP.__handleException(BPELInvokeWMP.java:636)
at com.collaxa.cube.engine.ext.wmp.BPELInvokeWMP.__callback(BPELInvokeWMP.java:668)
at com.collaxa.cube.engine.ext.wmp.BPELInvokeWMP.__executeStatements(BPELInvokeWMP.java:447)
at com.collaxa.cube.engine.ext.wmp.BPELActivityWMP.perform(BPELActivityWMP.java:199)
at com.collaxa.cube.engine.CubeEngine.performActivity(CubeEngine.java:3704)
at com.collaxa.cube.engine.CubeEngine.handleWorkItem(CubeEngine.java:1656)
at 

Symptoms:

Database Size Used space Free space
-------------------- -------------------- --------------------
138 GB 109 GB 29 GB


---- Table Cube Instance size - 544 MB

----No to records in ORABPEL.CUBE_INSTNACE.

Solution:

SOA tables not cleaned periodically in production,clean ORABPEL tables, purge old instances

Get Oracle Certifications for all Exams
Free Online Exams.com