PQ80429: TRYING TO STOP A BUSINESS PROCESS TEMPLATES CONFIGURED WITH AN ORACLE DB FAILS WITH A BPE EXCEPTION

 A fix is available

5.0.2.6: WebSphere Application Server Enterprise 5.0.2 Cumulative Fix 6



APAR status
Closed as program error.

Error description
Trying to stop a business process templates configured with an
oracle DB results in BPE Exception.  Because of an SQL exception
"Not in a transaction"  Error accessing Process MBeans.  Please
consult Logs, Documentation or Support for more details.
NewtonWFCreateDocument operation failed
javax.management.MBeanException:
BPEA0010E: Unexpected exception during execution. at
com.tivoli.jmx.modelmbean.DynamicModelMBeanSupport.resourceExcep
tionHand(DynamicModelMBeanSupport.java:668)
.
cut
.
.
com.ibm.bpe.api.UnexpectedFailureException: BPEA0010E:
Unexpected
exception during execution. java.sql.SQLException: Not in a
transaction at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
Local fix Problem summary
****************************************************************
* USERS AFFECTED: Users of the Process Choreographer           *
*                 component of WebSphere Enterprise with a     *
*                 pre Oracle 9i release 2 DB                   *
****************************************************************
* PROBLEM DESCRIPTION: stop business process template fails    *
*                      with java.sql.SQLException containing   *
*                      "Not  in a transaction".                *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
stop business process template fails
with java.sql.SQLException containing
"Not  in a transaction".
Problem conclusion
Changes made to allow for differences in oracle (pre 9i r2)
regarding two phase commit
Temporary fix Comments
APAR information
APAR number PQ80429
Reported component name WAS ENTERPRISE
Reported component ID 5630A3700
Reported release 00S
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Special Attention NoSpecatt
Submitted date 2003-11-04
Closed date 2004-02-26
Last modified date 2004-02-26

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros

Publications Referenced

Fix information

Applicable component levels
R003 PSY    UP
R00A PSY    UP
R00H PSY    UP
R00I PSY    UP
R00S PSY    UP
R00W PSY    UP


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > Enterprise Edition (EE)
Operating system(s):
Software version: 00S
Software edition:
Reference #: PQ80429
IBM Group: Software Group
Modified date: Feb 26, 2004