Problem Aborting Processes using admin app
"Kofford, C Todd" <[email protected]> Mon, 21 Jun 2010 08:28:15 -0500
| Newsgroups | gmane.comp.java.enhydra.shark |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format...
------------=_1277127023-5928-2435
Content-class: urn:content-classes:message
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01CB1145.9AC1B6E1"
This is a multi-part message in MIME format.
------_=_NextPart_001_01CB1145.9AC1B6E1
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
I am trying to abort several processes using the admin app, but it keeps
failing and logging the following error in the log:=20
ANY help would be appreciated.=20
--TK=20
2010-06-18 09:26:34,444: SyncDBTransaction.beforeCompletion setting
rollback only=20
java.sql.SQLException: ORA-01400: cannot insert NULL into
("SHARKD"."SHKPROCESSHISTORYINFO"."PROCESSID")=20
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
2)=20
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)=20
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.jav
a:216)=20
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem
ent.java:966)=20
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
java:1170)=20
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare
dStatement.java:3339)=20
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
tatement.java:3423)=20
at
org.enhydra.jdbc.core.CorePreparedStatement.executeUpdate(CorePreparedSt
atement.java:102)=20
at
com.lutris.appserver.server.sql.pscache.CachedPreparedStatement.executeU
pdate(CachedPreparedStatement.java:173)=20
at
com.lutris.appserver.server.sql.ExtendedDBConnection.executeUpdate(Exten
dedDBConnection.java:475)=20
at
com.lutris.appserver.server.sql.CoreDO.executeInsert(CoreDO.java:358)=20
at
com.lutris.dods.builder.generator.dataobject.GenericDO.executeInsert(Gen
ericDO.java:412)=20
at
org.enhydra.shark.eventaudit.data.ProcessHistoryInfoDO.executeInsert(Pro
cessHistoryInfoDO.java:2712)=20
at
org.enhydra.dods.dbtransaction.DBAction.executeIt(SortingDBTransaction.j
ava:697)=20
at
org.enhydra.dods.dbtransaction.SortingDBTransaction.executeEm(SortingDBT
ransaction.java:298)=20
at
org.enhydra.dods.dbtransaction.SortingDBTransaction.writeTheRest(Sorting
DBTransaction.java:277)=20
at
org.enhydra.dods.dbtransaction.SortingDBTransaction.write(SortingDBTrans
action.java:233)=20
at
org.enhydra.dods.dbtransaction.SortingDBTransaction.commit(SortingDBTran
saction.java:364)=20
at
org.enhydra.dods.jta.SyncDBTransactionFactory$SyncDBTransaction.beforeCo
mpletion(SyncDBTransactionFactory.java:182)=20
at
org.objectweb.jotm.SubCoordinator.doBeforeCompletion(SubCoordinator.java
:1487)=20
at
org.objectweb.jotm.SubCoordinator.commit_one_phase(SubCoordinator.java:4
16)=20
at
org.objectweb.jotm.TransactionImpl.commit(TransactionImpl.java:239)=20
at org.objectweb.jotm.Current.commit(Current.java:488)=20
at
org.enhydra.shark.swingclient.workflowadmin.monitoring.actions.AbortProc
esses.actionPerformed(AbortProcesses.java:148)=20
at
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at
javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2
318)=20
at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.ja
va:387)=20
at
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)=20
at
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonList
ener.java:236)=20
at
java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
at java.awt.Component.processMouseEvent(Component.java:6263)=20
at
javax.swing.JComponent.processMouseEvent(JComponent.java:3267)=20
at java.awt.Component.processEvent(Component.java:6028)=20
at java.awt.Container.processEvent(Container.java:2041)=20
at java.awt.Component.dispatchEventImpl(Component.java:4630)=20
at java.awt.Container.dispatchEventImpl(Container.java:2099)=20
at java.awt.Component.dispatchEvent(Component.java:4460)=20
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574)=20
at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)=20
at
java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)=20
at java.awt.Container.dispatchEventImpl(Container.java:2085)=20
at java.awt.Window.dispatchEventImpl(Window.java:2478)=20
at java.awt.Component.dispatchEvent(Component.java:4460)=20
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)=20
at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.
java:269)=20
at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.jav
a:184)=20
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.
java:174)=20
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)=20
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)=20
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122
Todd Kofford=20
[email protected]=20
University of Kansas - IT=20
=20
------_=_NextPart_001_01CB1145.9AC1B6E1
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Dus-ascii" http-equiv=3DContent-Type>
<META name=3DGENERATOR content=3D"MSHTML 8.00.7600.16535"></HEAD>
<BODY>
<DIV><FONT size=3D2 face=3DArial><SPAN=20
style=3D"WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE=
: separate; FONT: medium 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2=
; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-bor=
der-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-=
text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-t=
ext-stroke-width: 0px"=20
class=3DApple-style-span><SPAN=20
style=3D"FONT-FAMILY: verdana, geneva, helvetica, arial, sans-serif; FONT-S=
IZE: 13px"=20
class=3DApple-style-span>
<DIV=20
style=3D"BORDER-BOTTOM-COLOR: rgb(204,204,204); BORDER-TOP-COLOR: rgb(204,2=
04,204); BORDER-RIGHT-COLOR: rgb(204,204,204); BORDER-LEFT-COLOR: rgb(204,2=
04,204)"=20
id=3Dnabble.msgtext class=3Dmessage-text>I am trying to abort several proce=
sses=20
using the admin app, but it keeps failing and logging the following error i=
n the=20
log:<SPAN class=3DApple-converted-space> </SPAN><BR><BR>ANY help would=
be=20
appreciated.<SPAN class=3DApple-converted-space> </SPAN><BR><BR>--TK<S=
PAN=20
class=3DApple-converted-space> </SPAN><BR><BR>2010-06-18 09:26:34,444:=
=20
SyncDBTransaction.beforeCompletion setting rollback only<SPAN=20
class=3DApple-converted-space> </SPAN><BR>java.sql.SQLException: ORA-0=
1400:=20
cannot insert NULL into ("SHARKD"."SHKPROCESSHISTORYINFO"."PROCESSID")<SPAN=
=20
class=3DApple-converted-space> </SPAN><BR><BR> &nb=
sp; at=20
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)<=
SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:2=
16)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement=
.java:966)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.jav=
a:1170)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedSt=
atement.java:3339)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStat=
ement.java:3423)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
org.enhydra.jdbc.core.CorePreparedStatement.executeUpdate(CorePreparedState=
ment.java:102)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
com.lutris.appserver.server.sql.pscache.CachedPreparedStatement.executeUpda=
te(CachedPreparedStatement.java:173)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
com.lutris.appserver.server.sql.ExtendedDBConnection.executeUpdate(Extended=
DBConnection.java:475)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
com.lutris.appserver.server.sql.CoreDO.executeInsert(CoreDO.java:358)<SPAN=
=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
com.lutris.dods.builder.generator.dataobject.GenericDO.executeInsert(Generi=
cDO.java:412)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
org.enhydra.shark.eventaudit.data.ProcessHistoryInfoDO.executeInsert(Proces=
sHistoryInfoDO.java:2712)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
org.enhydra.dods.dbtransaction.DBAction.executeIt(SortingDBTransaction.java=
:697)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
org.enhydra.dods.dbtransaction.SortingDBTransaction.executeEm(SortingDBTran=
saction.java:298)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
org.enhydra.dods.dbtransaction.SortingDBTransaction.writeTheRest(SortingDBT=
ransaction.java:277)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
org.enhydra.dods.dbtransaction.SortingDBTransaction.write(SortingDBTransact=
ion.java:233)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
org.enhydra.dods.dbtransaction.SortingDBTransaction.commit(SortingDBTransac=
tion.java:364)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
org.enhydra.dods.jta.SyncDBTransactionFactory$SyncDBTransaction.beforeCompl=
etion(SyncDBTransactionFactory.java:182)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
org.objectweb.jotm.SubCoordinator.doBeforeCompletion(SubCoordinator.java:14=
87)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
org.objectweb.jotm.SubCoordinator.commit_one_phase(SubCoordinator.java:416)=
<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
org.objectweb.jotm.TransactionImpl.commit(TransactionImpl.java:239)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
org.objectweb.jotm.Current.commit(Current.java:488)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
org.enhydra.shark.swingclient.workflowadmin.monitoring.actions.AbortProcess=
es.actionPerformed(AbortProcesses.java:148)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)<SP=
AN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318=
)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:=
387)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)<SPAN=
=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListene=
r.java:236)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)<SP=
AN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
java.awt.Component.processMouseEvent(Component.java:6263)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
javax.swing.JComponent.processMouseEvent(JComponent.java:3267)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
java.awt.Component.processEvent(Component.java:6028)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
java.awt.Container.processEvent(Container.java:2041)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
java.awt.Component.dispatchEventImpl(Component.java:4630)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
java.awt.Container.dispatchEventImpl(Container.java:2099)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
java.awt.Component.dispatchEvent(Component.java:4460)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574)<SPAN=
=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)<SPAN=
=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
java.awt.Container.dispatchEventImpl(Container.java:2085)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
java.awt.Window.dispatchEventImpl(Window.java:2478)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
java.awt.Component.dispatchEvent(Component.java:4460)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
java.awt.EventQueue.dispatchEvent(EventQueue.java:599)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.jav=
a:269)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:1=
84)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.jav=
a:174)<SPAN=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)<SPAN=
=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)<SPAN=
=20
class=3DApple-converted-space> </SPAN><BR> =
at=20
java.awt.EventDispatchThread.run(EventDispatchThread.java:122</SPAN></SPAN>=
</FONT></DIV></DIV><!-- Converted from text/rtf format -->
<P align=3Dleft><FONT size=3D2><FONT face=3D"Comic Sans MS"><I><SPAN lang=
=3Den-us>Todd=20
Kofford</SPAN></I> <BR><I><SPAN lang=3Den-us>[email protected]</SPAN></I>=20
<BR><I><SPAN lang=3Den-us>University of Kansas - IT</SPAN></I></FONT></FONT=
> </P>
<DIV> </DIV></BODY></HTML>
------_=_NextPart_001_01CB1145.9AC1B6E1--
------------=_1277127023-5928-2435
Content-Type: text/plain; charset="UTF-8"; name="message-footer.txt"
Content-Disposition: inline; filename="message-footer.txt"
Content-Transfer-Encoding: quoted-printable
--
You receive this message as a subscriber of the [email protected] mailing lis=
t.
To unsubscribe: mailto:[email protected]
For general help: mailto:[email protected]?subject=3Dhelp
OW2 mailing lists service home page: http://www.ow2.org/wws
------------=_1277127023-5928-2435--