Need help on an SQLException - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Need help on an SQLException

Author

Topic

vpsalgia
Starting Member

2 Posts

Posted - 2009-01-27 : 03:42:35

Hi

I am getting an exception while seeding the database (SQL Server 2005).

Can some one help me for the probable cause for the same?

Caused by: java.lang.IllegalStateException: Exception on rollback:java.rmi.RemoteException: rollback: Unexpected XAException:Cannot send res.rollback:javax.transaction.xa.XAException: java.sql.SQLException: ROLLBACK:Status:0 msg:*** SQLJDBC_XA DTC_ERROR Context: xa_rollback, state=1, StatusCode:-3 (0xFFFFFFFD) *** (error code = 0) --java.sql.SQLException: ROLLBACK:Status:0 msg:*** SQLJDBC_XA DTC_ERROR Context: xa_rollback, state=1, StatusCode:-3 (0xFFFFFFFD) ***
at org.objectweb.jotm.TransactionImpl.rollback(TransactionImpl.java:663)
at org.objectweb.jotm.Current.rollback(Current.java:536)
at com.pace2020.appbox.blocks.transaction.JotmTransactionManager.rollback(JotmTransactionManager.java:87)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.avalon.phoenix.components.application.BlockInvocationHandler.invoke(BlockInvocationHandler.java:134)
at $Proxy9.rollback(Unknown Source)
at com.pace2020.appbox.blocks.transaction.JtaUserTransaction.rollback(JtaUserTransaction.java:91)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.avalon.phoenix.components.application.BlockInvocationHandler.invoke(BlockInvocationHandler.java:134)
at $Proxy10.rollback(Unknown Source)
at com.pace2020.appbox.blocks.objectmodel.planter.PermissionSeedPlanter.plant(PermissionSeedPlanter.java:89)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.avalon.fortress.impl.factory.PassThroughInvocationHandler.invoke(PassThroughInvocationHandler.java:68)
at $Proxy68.plant(Unknown Source)
at com.pace2020.appbox.blocks.objectmodel.ObjectModelImpl.maybePlantSeeds(ObjectModelImpl.java:211)
at com.pace2020.appbox.blocks.objectmodel.ObjectModelImpl.initialize(ObjectModelImpl.java:167)
at org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:283)
at org.apache.avalon.phoenix.containerkit.lifecycle.LifecycleHelper.startup(LifecycleHelper.java:200)

vpsalgia
Starting Member

2 Posts

Posted - 2009-01-27 : 03:57:43

Some times I get the exception:

Caused by: com.pace2020.appbox.services.datafactory.DataFactoryException: ObjectFactory: Permission: Unable to modify object: SQL: INSERT INTO permission (actions, permission, groupname, name) VALUES('add', 'com.pace2020.appbox.services.objectmodel.security.DataObjectPermission', 'Sys Estimator Admin', 'PressEventWorkflowItem'), values: []
at com.pace2020.appbox.blocks.datafactory.DataFactoryImpl.executeModifyingStatement(DataFactoryImpl.java:849)
at com.pace2020.appbox.blocks.datafactory.DataFactoryImpl.addStorable(DataFactoryImpl.java:657)
at com.pace2020.appbox.blocks.datafactory.DataFactoryImpl.save(DataFactoryImpl.java:414)
at sun.reflect.GeneratedMethodAccessor73.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.avalon.phoenix.components.application.BlockInvocationHandler.invoke(BlockInvocationHandler.java:134)
at $Proxy20.save(Unknown Source)
at com.pace2020.appbox.blocks.objectmodel.manager.PersistableDataManager.doPersist(PersistableDataManager.java:544)
... 46 more
Caused by: java.sql.SQLException: Cannot send XA(com.microsoft.sqlserver.jdbc.SQLServerXAResource@196bf64) start:javax.transaction.xa.XAException: java.sql.SQLException: DTC_XA_START:Status:0 msg:*** SQLJDBC_XA DTC_ERROR Context: xa_start, state=8, StatusCode:-2147024882 (0x8007000E) *** (error code = 0) --java.sql.SQLException: DTC_XA_START:Status:0 msg:*** SQLJDBC_XA DTC_ERROR Context: xa_start, state=8, StatusCode:-2147024882 (0x8007000E) ***
at com.pace2020.appbox.blocks.datasource.InstrumentedPoolingXADataSource.enlistResource(InstrumentedPoolingXADataSource.java:297)
at com.pace2020.appbox.blocks.datasource.InstrumentedPoolingXADataSource.getConnection(InstrumentedPoolingXADataSource.java:261)
at com.pace2020.appbox.blocks.datafactory.DataFactoryImpl.getConnection(DataFactoryImpl.java:189)
at com.pace2020.appbox.blocks.datafactory.DataFactoryImpl.executeStatement(DataFactoryImpl.java:1539)
at com.pace2020.appbox.blocks.datafactory.DataFactoryImpl.executeModifyingStatement(DataFactoryImpl.java:825)

brianjensen
Starting Member

22 Posts

Posted - 2009-01-27 : 04:17:15

Isn't this more an application problem that a SQL Server problem?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources