Users - Facility -> Inventory -> Find -> Exception

[Fred Forester-2]

Hi all,

If I do a find for inventory items things run ok for a while then tons
of continuous stack trace. the find works ok if I choose a category and
a type.


Thanx
Fred


141460 (http-0.0.0.0-8443-Processor4) [
ServiceDispatcher.java:452:DEBUG] [[Sync service finished-
total:0.161,since last(Begin):0.161]] - '
facility / getInventoryAvailableByFacility'
141528 (JotmBatch) [    TransactionImpl.java:765:INFO ] set rollback
only (tx=bb14:38:0:0155d1d292deb32e25...e1bc2a:)
141617 (http-0.0.0.0-8443-Processor4) [
GenericDAO.java:786:DEBUG] Ran query in 151 milli-seconds: SELECT
INVENTORY_ITEM_ID, INVENTOR
Y_ITEM_TYPE_ID, PRODUCT_ID, PARTY_ID, OWNER_PARTY_ID, STATUS_ID,
DATETIME_RECEIVED, EXPIRE_DATE, FACILITY_ID, CONTAINER_ID, LOT_ID, UOM_ID, B
IN_NUMBER, LOCATION_SEQ_ID, COMMENTS, QUANTITY_ON_HAND_TOTAL,
AVAILABLE_TO_PROMISE_TOTAL, QUANTITY_ON_HAND, AVAILABLE_TO_PROMISE,
SERIAL_NUMB
ER, UNIT_COST, CURRENCY_UOM_ID, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
public.INVENTORY_ITEM WHERE (
PRODUCT_ID = ? AND FACILITY_ID = ?)
141626 (http-0.0.0.0-8443-Processor4) [    TransactionUtil.java:77 :WARN ]
---- exception report
----------------------------------------------------------
[TransactionUtil.begin] active transaction marked for rollback in place,
so no transaction begun; this stack trace shows when the exception b
egan:
Exception: java.lang.Exception
Message: Tx Stack Placeholder
---- stack trace
---------------------------------------------------------------
java.lang.Exception: Tx Stack Placeholder
org.ofbiz.entity.transaction.TransactionUtil.setTransactionBeginStack(TransactionUtil.java:524)
org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:111)
org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:57)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:130)

---------------------------------------------

org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Thread.java:534)
--------------------------------------------------------------------------------

159778[    TransactionUtil.java:280:INFO ]
[TransactionUtil.setRollbackOnly] transaction rollback only not set,
rollback only is already set.
159780[  ServiceDispatcher.java:412:ERROR] Service Error
[getInventoryAvailableByFacility]: ERROR: Could not complete the Get
Inventory Avail
able for a Product
[file:/home/fforest/dev/customofbiz/applications/product/script/org/ofbiz/product/inventory/InventoryServices.xml#getProdu
ctInventoryAvailable] process [problem finding the InventoryItem entity:
SQL Exception occurred on commit (Cannot commit a transactional conn
ection: See JDBC 2.0 Optional Package Specification section 7.1 (p25))]
159781[    TransactionUtil.java:280:INFO ]
[TransactionUtil.setRollbackOnly] transaction rollback only not set,
rollback only is already set.
159783[  ServiceDispatcher.java:452:DEBUG] [[Sync service finished-
total:0.2,since last(Begin):0.2]] - 'facility / getInventoryAvailableByFa
cility'
159786[    TransactionUtil.java:77 :WARN ]
---- exception report
----------------------------------------------------------
[TransactionUtil.begin] active transaction marked for rollback in place,
so no transaction begun; this stack trace shows when the exception b
egan:
Exception: java.lang.Exception
 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[David E. Jones]

I don't know how many times we'll have to answer this sort of question. Nothing personal, but I guess the questions will probably never stop as transaction management is confusing and experience with it is limited in the world...

When you see an error that there is a transaction marked for rollback in place it means that SOMETHING ELSE caused the transaction to fail, not where the last error is shown. Read through details around it in the log.

We _even_ have some fancy things in place to show you where the transaction was marked for rollback. That's a good place to look for the real problem.

-David


Fred Forester wrote:

> Hi all,
>
> If I do a find for inventory items things run ok for a while then tons
> of continuous stack trace. the find works ok if I choose a category and
> a type.
>
>
> Thanx
> Fred
>
>
> 141460 (http-0.0.0.0-8443-Processor4) [
> ServiceDispatcher.java:452:DEBUG] [[Sync service finished-
> total:0.161,since last(Begin):0.161]] - '
> facility / getInventoryAvailableByFacility'
> 141528 (JotmBatch) [    TransactionImpl.java:765:INFO ] set rollback
> only (tx=bb14:38:0:0155d1d292deb32e25...e1bc2a:)
> 141617 (http-0.0.0.0-8443-Processor4) [
> GenericDAO.java:786:DEBUG] Ran query in 151 milli-seconds: SELECT
> INVENTORY_ITEM_ID, INVENTOR
> Y_ITEM_TYPE_ID, PRODUCT_ID, PARTY_ID, OWNER_PARTY_ID, STATUS_ID,
> DATETIME_RECEIVED, EXPIRE_DATE, FACILITY_ID, CONTAINER_ID, LOT_ID, UOM_ID, B
> IN_NUMBER, LOCATION_SEQ_ID, COMMENTS, QUANTITY_ON_HAND_TOTAL,
> AVAILABLE_TO_PROMISE_TOTAL, QUANTITY_ON_HAND, AVAILABLE_TO_PROMISE,
> SERIAL_NUMB
> ER, UNIT_COST, CURRENCY_UOM_ID, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
> public.INVENTORY_ITEM WHERE (
> PRODUCT_ID = ? AND FACILITY_ID = ?)
> 141626 (http-0.0.0.0-8443-Processor4) [    TransactionUtil.java:77 :WARN ]
> ---- exception report
> ----------------------------------------------------------
> [TransactionUtil.begin] active transaction marked for rollback in place,
> so no transaction begun; this stack trace shows when the exception b
> egan:
> Exception: java.lang.Exception
> Message: Tx Stack Placeholder
> ---- stack trace
> ---------------------------------------------------------------
> java.lang.Exception: Tx Stack Placeholder
> org.ofbiz.entity.transaction.TransactionUtil.setTransactionBeginStack(TransactionUtil.java:524)
> org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:111)
> org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:57)
> org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:130)
>
> ---------------------------------------------
>
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
> java.lang.Thread.run(Thread.java:534)
> --------------------------------------------------------------------------------
>
> 159778[    TransactionUtil.java:280:INFO ]
> [TransactionUtil.setRollbackOnly] transaction rollback only not set,
> rollback only is already set.
> 159780[  ServiceDispatcher.java:412:ERROR] Service Error
> [getInventoryAvailableByFacility]: ERROR: Could not complete the Get
> Inventory Avail
> able for a Product
> [file:/home/fforest/dev/customofbiz/applications/product/script/org/ofbiz/product/inventory/InventoryServices.xml#getProdu
> ctInventoryAvailable] process [problem finding the InventoryItem entity:
> SQL Exception occurred on commit (Cannot commit a transactional conn
> ection: See JDBC 2.0 Optional Package Specification section 7.1 (p25))]
> 159781[    TransactionUtil.java:280:INFO ]
> [TransactionUtil.setRollbackOnly] transaction rollback only not set,
> rollback only is already set.
> 159783[  ServiceDispatcher.java:452:DEBUG] [[Sync service finished-
> total:0.2,since last(Begin):0.2]] - 'facility / getInventoryAvailableByFa
> cility'
> 159786[    TransactionUtil.java:77 :WARN ]
> ---- exception report
> ----------------------------------------------------------
> [TransactionUtil.begin] active transaction marked for rollback in place,
> so no transaction begun; this stack trace shows when the exception b
> egan:
> Exception: java.lang.Exception
>  
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users