creating a link between a product and a category withthe service 
addProductToCategory causes a deadlock
-------------------------------------------------------------------------------------------------------

                 Key: OFBIZ-718
                 URL: https://issues.apache.org/jira/browse/OFBIZ-718
             Project: OFBiz (The Open for Business Project)
          Issue Type: Bug
          Components: product
    Affects Versions: SVN trunk
         Environment: local using derby database
            Reporter: Hans Bakker
         Assigned To: Al Byers


Hi Al, i have the problem below. I saw inthe log you are working on this?
It is caused in the checkCategoryRelatedPermissionService
in CategoryServices.xml at line 631/632

can you have a look?

the log:

Service [addProductToCategory] threw an unexpected exception/error
Exception: org.ofbiz.service.ServiceAuthException
Message: Error running the simple-method: Error in simple-method operation 
[<iterate list-name="productCategoryIdList" entry-name="productCategoryId"/>]: 
java.lang.RuntimeException: Error in simple-method operation [<entity-and/>]: 
java.lang.IllegalArgumentException: Error getting list from EntityListIterator: 
org.ofbiz.entity.GenericEntityException: Error getting the next result (A lock 
could not be obtained within the time requested)<br/>null
---- stack trace ---------------------------------------------------------------
org.ofbiz.service.ServiceAuthException: Error running the simple-method: Error 
in simple-method operation [<iterate list-name="productCategoryIdList" 
entry-name="productCategoryId"/>]: java.lang.RuntimeException: Error in 
simple-method operation [<entity-and/>]: java.lang.IllegalArgumentException: 
Error getting list from EntityListIterator: 
org.ofbiz.entity.GenericEntityException: Error getting the next result (A lock 
could not be obtained within the time requested)<br/>null
org.ofbiz.service.ServiceDispatcher.checkAuth(ServiceDispatcher.java:774)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:307)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:211)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:113)
org.ofbiz.local.convertxls.loadFiles(convertxls.java:211)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:88)
org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:74)
org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:409)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:240)


caused in program convertXls java code starting from line 200:
                                        Debug.logInfo("=== connection 
productId: " + productId + " to category: " + rowCategory, module);
                                        results = 
dispatcher.runSync("addProductToCategory", UtilMisc.toMap(
                                                        "userLogin",userLogin,
                                                        "productId", productId,
                                                        "productCategoryId", 
rowCategory));


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to