Re: Problem Aborting Processes using admin app

This is a multi-part message in MIME format...

------------=_1277409309-5928-2719
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


RESOLVED - 

I had a problem with my shark DB, when I rebuilt the DB, the problem went
away.

--TK


Todd Kofford wrote:
> 
> I am trying to abort several processes using the admin app, but it keeps
> failing and logging the following error in the log: 
> 
> ANY help would be appreciated. 
> 
> --TK 
> 
> 2010-06-18 09:26:34,444: SyncDBTransaction.beforeCompletion setting
> rollback only 
> java.sql.SQLException: ORA-01400: cannot insert NULL into
> ("SHARKD"."SHKPROCESSHISTORYINFO"."PROCESSID") 
> 
>         at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
> 2) 
>         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) 
>         at
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.jav
> a:216) 
>         at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem
> ent.java:966) 
>         at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
> java:1170) 
>         at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare
> dStatement.java:3339) 
>         at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
> tatement.java:3423) 
>         at
> org.enhydra.jdbc.core.CorePreparedStatement.executeUpdate(CorePreparedSt
> atement.java:102) 
>         at
> com.lutris.appserver.server.sql.pscache.CachedPreparedStatement.executeU
> pdate(CachedPreparedStatement.java:173) 
>         at
> com.lutris.appserver.server.sql.ExtendedDBConnection.executeUpdate(Exten
> dedDBConnection.java:475) 
>         at
> com.lutris.appserver.server.sql.CoreDO.executeInsert(CoreDO.java:358) 
>         at
> com.lutris.dods.builder.generator.dataobject.GenericDO.executeInsert(Gen
> ericDO.java:412) 
>         at
> org.enhydra.shark.eventaudit.data.ProcessHistoryInfoDO.executeInsert(Pro
> cessHistoryInfoDO.java:2712) 
>         at
> org.enhydra.dods.dbtransaction.DBAction.executeIt(SortingDBTransaction.j
> ava:697) 
>         at
> org.enhydra.dods.dbtransaction.SortingDBTransaction.executeEm(SortingDBT
> ransaction.java:298) 
>         at
> org.enhydra.dods.dbtransaction.SortingDBTransaction.writeTheRest(Sorting
> DBTransaction.java:277) 
>         at
> org.enhydra.dods.dbtransaction.SortingDBTransaction.write(SortingDBTrans
> action.java:233) 
>         at
> org.enhydra.dods.dbtransaction.SortingDBTransaction.commit(SortingDBTran
> saction.java:364) 
>         at
> org.enhydra.dods.jta.SyncDBTransactionFactory$SyncDBTransaction.beforeCo
> mpletion(SyncDBTransactionFactory.java:182) 
>         at
> org.objectweb.jotm.SubCoordinator.doBeforeCompletion(SubCoordinator.java
> :1487) 
>         at
> org.objectweb.jotm.SubCoordinator.commit_one_phase(SubCoordinator.java:4
> 16) 
>         at
> org.objectweb.jotm.TransactionImpl.commit(TransactionImpl.java:239) 
>         at org.objectweb.jotm.Current.commit(Current.java:488) 
>         at
> org.enhydra.shark.swingclient.workflowadmin.monitoring.actions.AbortProc
> esses.actionPerformed(AbortProcesses.java:148) 
>         at
> javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
> 
>         at
> javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2
> 318) 
>         at
> javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.ja
> va:387) 
>         at
> javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) 
>         at
> javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonList
> ener.java:236) 
>         at
> java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
> 
>         at java.awt.Component.processMouseEvent(Component.java:6263) 
>         at
> javax.swing.JComponent.processMouseEvent(JComponent.java:3267) 
>         at java.awt.Component.processEvent(Component.java:6028) 
>         at java.awt.Container.processEvent(Container.java:2041) 
>         at java.awt.Component.dispatchEventImpl(Component.java:4630) 
>         at java.awt.Container.dispatchEventImpl(Container.java:2099) 
>         at java.awt.Component.dispatchEvent(Component.java:4460) 
>         at
> java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574) 
>         at
> java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238) 
>         at
> java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168) 
>         at java.awt.Container.dispatchEventImpl(Container.java:2085) 
>         at java.awt.Window.dispatchEventImpl(Window.java:2478) 
>         at java.awt.Component.dispatchEvent(Component.java:4460) 
>         at java.awt.EventQueue.dispatchEvent(EventQueue.java:599) 
>         at
> java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.
> java:269) 
>         at
> java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.jav
> a:184) 
>         at
> java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.
> java:174) 
>         at
> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169) 
>         at
> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161) 
>         at java.awt.EventDispatchThread.run(EventDispatchThread.java:122
> 
> Todd Kofford 
> [email protected] 
> University of Kansas - IT 
> 
>  
> 
> 
> --
> You receive this message as a subscriber of the [email protected] mailing
> list.
> To unsubscribe: mailto:[email protected]
> For general help: mailto:[email protected]?subject=help
> OW2 mailing lists service home page: http://www.ow2.org/wws
> 
> 

-- 
View this message in context: http://old.nabble.com/Problem-Aborting-Processes-using-admin-app-tp28948658p28986079.html
Sent from the Enhydra Shark mailing list archive at Nabble.com.


------------=_1277409309-5928-2719
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

------------=_1277409309-5928-2719--