Urgent: CORBA TRANSACTION_ROLLEDBACK

[Tezcan Dilshener]

Hi all,
We are using WAS v.3.5.5 on WinNt4 sp6a.
We have a web application that that uses
html->servlet->sessionBean->cmpEJB
to accesses db2 v7.2 tables.

We receive CORBA TRANSACTION_ROLLEDBACK error during insert into one of the
tables.
(see belowfor the full error).
I am unable to find the cause of this, yet alone to figure out how to
resolve it.

I shall be grateful if anyone will kindly assist me with this problem.
The sessionBean is statefull and acts as the session fascade wrapper to the
cmp entity bean.
It is set as TRNX_SUPPORTS and isolation is TRNX_SERIALIZABLE
The entity bean is defined and mapped as cmp.
It is set as TRNX_SUPPORTS and isolation is TRNX_REPEATABLE_READ

Thanks
Tex...

[12.02.2002 17:00:21:375] ERROR in WEBvisitorSBBean.setRegistered():
javax.transaction.TransactionRolledbackException: CORBA
TRANSACTION_ROLLEDBACK 0 No; nested exception is:
org.omg.CORBA.TRANSACTION_ROLLEDBACK:
com.ibm.websphere.csi.CSITransactionRolledbackException:
at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java(Compiled Code))
at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java(Compiled
Code))
at
com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.jav
a(Compiled Code))
at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java(Compiled
Code))
at
com.satzsoft.web.data_base.EJSRemoteContacted._copyToEJBfromValueObject(EJSR
emoteContacted.java:1096)
at
com.satzsoft.web.data_base._Contacted_BaseStub._copyToEJBfromValueObject(_Co
ntacted_BaseStub.java:282)
at
com.satzsoft.web.data_base._Contacted_Stub._copyToEJBfromValueObject(_Contac
ted_Stub.java:2372)
at
com.satzsoft.web.back_end.WEBvisitorSBBean.setContacted(WEBvisitorSBBean.jav
a:474)
at
com.satzsoft.web.back_end.EJSRemoteWEBvisitorSB.setContacted(EJSRemoteWEBvis
itorSB.java:256)
at
com.satzsoft.web.back_end._WEBvisitorSB_BaseStub.setContacted(_WEBvisitorSB_
BaseStub.java:645)
at
com.satzsoft.web.back_end._WEBvisitorSB_Stub.setContacted(_WEBvisitorSB_Stub
.java:205)
at
com.satzsoft.web.back_end.WEBvisitorSBAccessBean.setContacted(WEBvisitorSBAc
cessBean.java:206)
at
com.satzsoft.web.front_end.DoRegistration.setContacted(DoRegistration.java:2
17)
at
com.satzsoft.web.front_end.DoRegistration.performTask(DoRegistration.java:14
1)
at
com.satzsoft.web.front_end.WEBAbstractServlet.doResponse(WEBAbstractServlet.
java(Compiled Code))
at
com.satzsoft.web.front_end.WEBAbstractServlet.doPost(WEBAbstractServlet.java
(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager
.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycl
eServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServle
t.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycle
Servlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java(Co
mpiled Code))
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletMan
ager.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManag
er.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(W
ebAppRequestDispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequest
Dispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestD
ispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java(Compil
ed Code))
at
com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.
java(Compiled Code))
at
com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedIn
vocation.java(Compiled Code))
at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequ
estProcessor.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener
.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.SQEventListenerImp$ServiceRunnable.run(SQ
EventListenerImp.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.SQEventListenerImp.notifySQEvent(SQEventL
istenerImp.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.serverqueue.SQEventSource.notifyEvent(SQE
ventSource.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.serverqueue.SQWrapperEventSource$SelectRu
nnable.notifyService(SQWrapperEventSource.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.serverqueue.SQWrapperEventSource$SelectRu
nnable.run(SQWrapperEventSource.java:221)
at
com.ibm.servlet.engine.oselistener.outofproc.OutOfProcThread$CtlRunnable.run
(OutOfProcThread.java:248)
at java.lang.Thread.run(Thread.java:481)
minor code: 0 completed: No

javax.transaction.TransactionRolledbackException: CORBA
TRANSACTION_ROLLEDBACK 0 No; nested exception is:
org.omg.CORBA.TRANSACTION_ROLLEDBACK:
com.ibm.websphere.csi.CSITransactionRolledbackException:
at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java(Compiled Code))
at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java(Compiled
Code))
at
com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.jav
a(Compiled Code))
at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java(Compiled
Code))
at
com.satzsoft.web.data_base.EJSRemoteContacted._copyToEJBfromValueObject(EJSR
emoteContacted.java:1096)
at
com.satzsoft.web.data_base._Contacted_BaseStub._copyToEJBfromValueObject(_Co
ntacted_BaseStub.java:282)
at
com.satzsoft.web.data_base._Contacted_Stub._copyToEJBfromValueObject(_Contac
ted_Stub.java:2372)
at
com.satzsoft.web.back_end.WEBvisitorSBBean.setContacted(WEBvisitorSBBean.jav
a:474)
at
com.satzsoft.web.back_end.EJSRemoteWEBvisitorSB.setContacted(EJSRemoteWEBvis
itorSB.java:256)
at
com.satzsoft.web.back_end._WEBvisitorSB_BaseStub.setContacted(_WEBvisitorSB_
BaseStub.java:645)
at
com.satzsoft.web.back_end._WEBvisitorSB_Stub.setContacted(_WEBvisitorSB_Stub
.java:205)
at
com.satzsoft.web.back_end.WEBvisitorSBAccessBean.setContacted(WEBvisitorSBAc
cessBean.java:206)
at
com.satzsoft.web.front_end.DoRegistration.setContacted(DoRegistration.java:2
17)
at
com.satzsoft.web.front_end.DoRegistration.performTask(DoRegistration.java:14
1)
at
com.satzsoft.web.front_end.WEBAbstractServlet.doResponse(WEBAbstractServlet.
java(Compiled Code))
at
com.satzsoft.web.front_end.WEBAbstractServlet.doPost(WEBAbstractServlet.java
(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager
.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycl
eServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServle
t.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycle
Servlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java(Co
mpiled Code))
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletMan
ager.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManag
er.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(W
ebAppRequestDispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequest
Dispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestD
ispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java(Compil
ed Code))
at
com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.
java(Compiled Code))
at
com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedIn
vocation.java(Compiled Code))
at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequ
estProcessor.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener
.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.SQEventListenerImp$ServiceRunnable.run(SQ
EventListenerImp.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.SQEventListenerImp.notifySQEvent(SQEventL
istenerImp.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.serverqueue.SQEventSource.notifyEvent(SQE
ventSource.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.serverqueue.SQWrapperEventSource$SelectRu
nnable.notifyService(SQWrapperEventSource.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.serverqueue.SQWrapperEventSource$SelectRu
nnable.run(SQWrapperEventSource.java:221)
at
com.ibm.servlet.engine.oselistener.outofproc.OutOfProcThread$CtlRunnable.run
(OutOfProcThread.java:248)
at java.lang.Thread.run(Thread.java:481)
minor code: 0 completed: No
org.omg.CORBA.TRANSACTION_ROLLEDBACK:
com.ibm.websphere.csi.CSITransactionRolledbackException:
at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java(Compiled Code))
at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java(Compiled
Code))
at
com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.jav
a(Compiled Code))
at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java(Compiled
Code))
at
com.satzsoft.web.data_base.EJSRemoteContacted._copyToEJBfromValueObject(EJSR
emoteContacted.java:1096)
at
com.satzsoft.web.data_base._Contacted_BaseStub._copyToEJBfromValueObject(_Co
ntacted_BaseStub.java:282)
at
com.satzsoft.web.data_base._Contacted_Stub._copyToEJBfromValueObject(_Contac
ted_Stub.java:2372)
at
com.satzsoft.web.back_end.WEBvisitorSBBean.setContacted(WEBvisitorSBBean.jav
a:474)
at
com.satzsoft.web.back_end.EJSRemoteWEBvisitorSB.setContacted(EJSRemoteWEBvis
itorSB.java:256)
at
com.satzsoft.web.back_end._WEBvisitorSB_BaseStub.setContacted(_WEBvisitorSB_
BaseStub.java:645)
at
com.satzsoft.web.back_end._WEBvisitorSB_Stub.setContacted(_WEBvisitorSB_Stub
.java:205)
at
com.satzsoft.web.back_end.WEBvisitorSBAccessBean.setContacted(WEBvisitorSBAc
cessBean.java:206)
at
com.satzsoft.web.front_end.DoRegistration.setContacted(DoRegistration.java:2
17)
at
com.satzsoft.web.front_end.DoRegistration.performTask(DoRegistration.java:14
1)
at
com.satzsoft.web.front_end.WEBAbstractServlet.doResponse(WEBAbstractServlet.
java(Compiled Code))
at
com.satzsoft.web.front_end.WEBAbstractServlet.doPost(WEBAbstractServlet.java
(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager
.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycl
eServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServle
t.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycle
Servlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java(Co
mpiled Code))
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletMan
ager.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManag
er.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(W
ebAppRequestDispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequest
Dispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestD
ispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java(Compil
ed Code))
at
com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.
java(Compiled Code))
at
com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedIn
vocation.java(Compiled Code))
at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequ
estProcessor.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener
.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.SQEventListenerImp$ServiceRunnable.run(SQ
EventListenerImp.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.SQEventListenerImp.notifySQEvent(SQEventL
istenerImp.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.serverqueue.SQEventSource.notifyEvent(SQE
ventSource.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.serverqueue.SQWrapperEventSource$SelectRu
nnable.notifyService(SQWrapperEventSource.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.serverqueue.SQWrapperEventSource$SelectRu
nnable.run(SQWrapperEventSource.java:221)
at
com.ibm.servlet.engine.oselistener.outofproc.OutOfProcThread$CtlRunnable.run
(OutOfProcThread.java:248)
at java.lang.Thread.run(Thread.java:481)
minor code: 0 completed: No
at java.lang.reflect.Constructor.newInstance(Native Method)
at javax.rmi.CORBA.Util.copyObject(Util.java(Compiled Code))
at
com.satzsoft.web.data_base._Contacted_BaseStub._copyToEJBfromValueObject(_Co
ntacted_BaseStub.java:284)
at
com.satzsoft.web.data_base._Contacted_Stub._copyToEJBfromValueObject(_Contac
ted_Stub.java:2372)
at
com.satzsoft.web.back_end.WEBvisitorSBBean.setContacted(WEBvisitorSBBean.jav
a:474)
at
com.satzsoft.web.back_end.EJSRemoteWEBvisitorSB.setContacted(EJSRemoteWEBvis
itorSB.java:256)
at
com.satzsoft.web.back_end._WEBvisitorSB_BaseStub.setContacted(_WEBvisitorSB_
BaseStub.java:645)
at
com.satzsoft.web.back_end._WEBvisitorSB_Stub.setContacted(_WEBvisitorSB_Stub
.java:205)
at
com.satzsoft.web.back_end.WEBvisitorSBAccessBean.setContacted(WEBvisitorSBAc
cessBean.java:206)
at
com.satzsoft.web.front_end.DoRegistration.setContacted(DoRegistration.java:2
17)
at
com.satzsoft.web.front_end.DoRegistration.performTask(DoRegistration.java:14
1)
at
com.satzsoft.web.front_end.WEBAbstractServlet.doResponse(WEBAbstractServlet.
java(Compiled Code))
at
com.satzsoft.web.front_end.WEBAbstractServlet.doPost(WEBAbstractServlet.java
(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager
.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycl
eServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServle
t.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycle
Servlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java(Co
mpiled Code))
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletMan
ager.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManag
er.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(W
ebAppRequestDispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequest
Dispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestD
ispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java(Compil
ed Code))
at
com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.
java(Compiled Code))
at
com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedIn
vocation.java(Compiled Code))
at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequ
estProcessor.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener
.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.SQEventListenerImp$ServiceRunnable.run(SQ
EventListenerImp.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.SQEventListenerImp.notifySQEvent(SQEventL
istenerImp.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.serverqueue.SQEventSource.notifyEvent(SQE
ventSource.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.serverqueue.SQWrapperEventSource$SelectRu
nnable.notifyService(SQWrapperEventSource.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.serverqueue.SQWrapperEventSource$SelectRu
nnable.run(SQWrapperEventSource.java:221)
at
com.ibm.servlet.engine.oselistener.outofproc.OutOfProcThread$CtlRunnable.run
(OutOfProcThread.java:248)
at java.lang.Thread.run(Thread.java:481)

--

T.Dilshener
MSc. CEng. MBCS
http://www.dilshener.de

[David Artus]

If you bturn on some suitable trace then you will probably see the underlying
SQL exception (or whatever).

Try com.ibm.ejs.*=all=enabled

[Tezcan Dilshener]

Thanks for your suggestion David
coudl you tell me where do Iturn the tracing on and where do I put the
com.ibm.ejs

Tex...

"David Artus" <art...@uk.ibm.com> wrote in message
news:3C6D0313...@uk.ibm.com...

[David Artus]

This is explained in the InfoCentre, but a more detailed explaantion is
in the 3.5 Handbook redbook. If you are working with WebSphere
you really need the redbooks. Suggest you browse www.redbooks.ibm.com.

The 3.5 Handbook will show up if you search for 6161. Section 23.5
explains the trace facility.