Hi,
I am trying to sync the inventory items from the third party inventory system. As the number of items increase I get the following error messages: Can someone please throw some light on this transaction time out issue. I have updated the debug messages to error message. I also tried with the increasing the transaction-timeout to 3 mins i.e. 180 sec but of no use. Regards, Prashant 2010-01-23 16:45:29,169 (default-invoker-Thread-544) [ TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0) 2010-01-23 16:45:29,169 (default-invoker-Thread-544) [ TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed 2010-01-23 16:45:29,716 (default-invoker-Thread-544) [ TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0) 2010-01-23 16:45:29,716 (default-invoker-Thread-544) [ TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed 2010-01-23 16:45:30,372 (default-invoker-Thread-544) [ TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0) 2010-01-23 16:45:30,372 (default-invoker-Thread-544) [ TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed 2010-01-23 16:45:30,387 (default-invoker-Thread-544) [ TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0) 2010-01-23 16:45:30,528 (default-invoker-Thread-544) [ ServiceDispatcher.java:543:ERROR] ---- exception report ---------------------------------------------------------- Could not commit transaction for service [syncInventoryItem] call Exception: org.ofbiz.entity.transaction.GenericTransactionException Message: Roll back error (with no rollbackOnly cause found), could not commit transaction, was rolled back instead: javax.transaction.RollbackException: Transaction timeout (Transaction timeout) ---- cause --------------------------------------------------------------------- Exception: javax.transaction.RollbackException Message: Transaction timeout ---- stack trace --------------------------------------------------------------- javax.transaction.RollbackException: Transaction timeout org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:269) org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:245) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:209) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:195) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:539) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:219) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159) org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69) org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:241) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2010-01-23 16:45:30,528 (default-invoker-Thread-544) [ GenericServiceJob.java:116:ERROR] ---- exception report ---------------------------------------------------------- Async-Service failed. Exception: org.ofbiz.service.GenericServiceException Message: Could not commit transaction for service [syncInventoryItem] call: Roll back error (with no rollbackOnly cause found), could not commit transaction, was rolled back instead: javax.transaction.RollbackException: Transaction timeout (Transaction timeout) ---- stack trace --------------------------------------------------------------- org.ofbiz.service.GenericServiceException: Could not commit transaction for service [syncInventoryItem] call: Roll back error (with no rollbackOnly cause found), could not commit transaction, was rolled back instead: javax.transaction.RollbackException: Transaction timeout (Transaction timeout) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:547) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:219) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159) org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69) org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:241) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2010-01-23 16:45:31,012 (default-invoker-Thread-10) [ TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0) 2010-01-23 16:45:31,012 (default-invoker-Thread-10) [ TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed 2010-01-23 16:45:31,575 (default-invoker-Thread-10) [ TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0) 2010-01-23 16:45:31,606 (default-invoker-Thread-10) [ TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed 2010-01-23 16:45:31,669 (ActiveMQ Session Task) [ TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0) 2010-01-23 16:45:31,669 (ActiveMQ Session Task) [ TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed 2010-01-23 16:45:31,684 (default-invoker-Thread-10) [ TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0) 2010-01-23 16:45:31,700 (default-invoker-Thread-10) [ TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed+ ________________________________ http://www.mindtree.com/email/disclaimer.html |
Hi,
Please note that this service is invoked asynchronuously. Regards, Prashant ________________________________ From: Prashant Punekar Sent: Saturday, January 23, 2010 4:51 PM To: [hidden email] Subject: transaction timeout ! Hi, I am trying to sync the inventory items from the third party inventory system. As the number of items increase I get the following error messages: Can someone please throw some light on this transaction time out issue. I have updated the debug messages to error message. I also tried with the increasing the transaction-timeout to 3 mins i.e. 180 sec but of no use. Regards, Prashant 2010-01-23 16:45:29,169 (default-invoker-Thread-544) [ TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0) 2010-01-23 16:45:29,169 (default-invoker-Thread-544) [ TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed 2010-01-23 16:45:29,716 (default-invoker-Thread-544) [ TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0) 2010-01-23 16:45:29,716 (default-invoker-Thread-544) [ TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed 2010-01-23 16:45:30,372 (default-invoker-Thread-544) [ TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0) 2010-01-23 16:45:30,372 (default-invoker-Thread-544) [ TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed 2010-01-23 16:45:30,387 (default-invoker-Thread-544) [ TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0) 2010-01-23 16:45:30,528 (default-invoker-Thread-544) [ ServiceDispatcher.java:543:ERROR] ---- exception report ---------------------------------------------------------- Could not commit transaction for service [syncInventoryItem] call Exception: org.ofbiz.entity.transaction.GenericTransactionException Message: Roll back error (with no rollbackOnly cause found), could not commit transaction, was rolled back instead: javax.transaction.RollbackException: Transaction timeout (Transaction timeout) ---- cause --------------------------------------------------------------------- Exception: javax.transaction.RollbackException Message: Transaction timeout ---- stack trace --------------------------------------------------------------- javax.transaction.RollbackException: Transaction timeout org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:269) org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:245) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:209) org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:195) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:539) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:219) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159) org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69) org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:241) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2010-01-23 16:45:30,528 (default-invoker-Thread-544) [ GenericServiceJob.java:116:ERROR] ---- exception report ---------------------------------------------------------- Async-Service failed. Exception: org.ofbiz.service.GenericServiceException Message: Could not commit transaction for service [syncInventoryItem] call: Roll back error (with no rollbackOnly cause found), could not commit transaction, was rolled back instead: javax.transaction.RollbackException: Transaction timeout (Transaction timeout) ---- stack trace --------------------------------------------------------------- org.ofbiz.service.GenericServiceException: Could not commit transaction for service [syncInventoryItem] call: Roll back error (with no rollbackOnly cause found), could not commit transaction, was rolled back instead: javax.transaction.RollbackException: Transaction timeout (Transaction timeout) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:547) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:219) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159) org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69) org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:241) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2010-01-23 16:45:31,012 (default-invoker-Thread-10) [ TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0) 2010-01-23 16:45:31,012 (default-invoker-Thread-10) [ TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed 2010-01-23 16:45:31,575 (default-invoker-Thread-10) [ TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0) 2010-01-23 16:45:31,606 (default-invoker-Thread-10) [ TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed 2010-01-23 16:45:31,669 (ActiveMQ Session Task) [ TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0) 2010-01-23 16:45:31,669 (ActiveMQ Session Task) [ TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed 2010-01-23 16:45:31,684 (default-invoker-Thread-10) [ TransactionUtil.java:206:ERROR] [TransactionUtil.commit] current status : Transaction Active (0) 2010-01-23 16:45:31,700 (default-invoker-Thread-10) [ TransactionUtil.java:217:ERROR] [TransactionUtil.commit] transaction committed+ ________________________________ http://www.mindtree.com/email/disclaimer.html |
Free forum by Nabble | Edit this page |