You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ofbiz.apache.org by Gary Lawrance <ac...@gmail.com> on 2021/07/13 16:28:12 UTC

Problem calling the assignPartyToWorkEffort service

Hi All,

First post to the user forum, but we have been using OFBiz now for two years.  Recently I have been trying to create a production run/run MRP and I get a very unhelpful error.

I am running 16.11.05.

The Following Errors Occurred:

Error calling event: org.apache.ofbiz.webapp.event.EventHandlerException: Service invocation error (null)

Has anyone else come across this issue?

Looking back through the logs it seems to be that the assignPartyToWorkEffort service is missing a statusid as per this error message.

2021-07-13 09:27:00,301 |http-nio-8443-exec-9 |ProductionRunServices |E| org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]))

Re: Problem calling the assignPartyToWorkEffort service

Posted by Gary Lawrance <ac...@gmail.com>.

Hi Jacques,

My appologies, I believe I have been subscribed to the list now.

Yes we are currently using OFBiz OOTB, with some users manually importing data through the webtools. (Products, Purchase Orders)

I was looking to have OFBiz create a manufacturing run when I approve an internal requirement. It just gives the error: "Error calling event: org.apache.ofbiz.webapp.event.EventHandlerException: Service invocation error (null)". I was clicking on the submit button at the ordermgr/control/ApproveRequirements screen. I was expecting the manufacturing runs to be created, but instead it just came back with the error above.

Unfortunately, I can't seem to reproduce this error when I create my own standalone version of OFBiz on my local. Which has lead me to believe there is something missing in the database...

At this time, I am working on migrating from v16 to v17 to keep up-to-date. (I have yet to come across this issue in 17 as well)

I have gone through the log to get some excerpts. See my copies below.

2021-07-14 13:00:29,469 |ttp-nio-8443-exec-10 |RequestHandler |I| Rendering View [ApproveRequirements]. Hidden sessionId by default.
2021-07-14 13:00:29,476 |ttp-nio-8443-exec-10 |ScreenFactory |I| Got 13 screens in 0.005s from: file:/C:/OFBiz/apache-ofbiz-16.11.05/applications/order/widget/ordermgr/RequirementScreens.xml
2021-07-14 13:00:29,562 |ttp-nio-8443-exec-10 |ScreenFactory |I| Got 4 screens in 0.005s from: file:/C:/OFBiz/apache-ofbiz-16.11.05/applications/order/widget/ordermgr/CommonScreens.xml
2021-07-14 13:00:29,567 |ttp-nio-8443-exec-10 |ScreenFactory |I| Got 1 screens in 0.005s from: file:/C:/OFBiz/apache-ofbiz-16.11.05/applications/commonext/widget/CommonScreens.xml
2021-07-14 13:00:29,870 |ttp-nio-8443-exec-10 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default
2021-07-14 13:00:32,576 |http-nio-8443-exec-2 |ConfigXMLReader |I| controller loaded: 0.0s, 45 requests, 22 views in file:/C:/OFBiz/apache-ofbiz-16.11.05/framework/common/webcommon/WEB-INF/common-controller.xml
2021-07-14 13:00:32,592 |http-nio-8443-exec-2 |ConfigXMLReader |I| controller loaded: 0.0s, 0 requests, 0 views in file:/C:/OFBiz/apache-ofbiz-16.11.05/framework/common/webcommon/WEB-INF/handlers-controller.xml
2021-07-14 13:00:32,628 |http-nio-8443-exec-2 |ServiceEcaRule |I| Running Service ECA Service: createProductionRunFromRequirement, triggered by rule on Service: updateRequirement
2021-07-14 13:00:33,062 |http-nio-8443-exec-2 |ServiceEcaRule |I| For Service ECA [workEffortGenericPermission] on [return] got false for condition: [hasPermission][equals][false][true][Boolean]
2021-07-14 13:00:33,154 |http-nio-8443-exec-2 |EntityEcaRule |I| Running Entity ECA Service: indexWorkEffortKeywords, triggered by rule on Entity: WorkEffort
2021-07-14 13:00:33,277 |http-nio-8443-exec-2 |ServiceEcaCondition |I| From Field (quickAssignPartyId) is not found in context for createWorkEffort, defaulting to null.
2021-07-14 13:00:33,277 |http-nio-8443-exec-2 |ServiceEcaRule |I| For Service ECA [createWorkEffort] on [commit] got false for condition: [quickAssignPartyId][is-not-empty][true][String]
2021-07-14 13:00:33,277 |http-nio-8443-exec-2 |ServiceEcaCondition |I| From Field (communicationEventId) is not found in context for createWorkEffort, defaulting to null.
2021-07-14 13:00:33,277 |http-nio-8443-exec-2 |ServiceEcaRule |I| For Service ECA [createWorkEffort] on [commit] got false for condition: [communicationEventId][is-not-empty][true][String]
2021-07-14 13:00:33,277 |http-nio-8443-exec-2 |ServiceEcaRule |I| For Service ECA [createWorkEffort] on [commit] got false for condition: [currentStatusId][equals][SPRINT_ACTIVE][true][String]
2021-07-14 13:00:33,277 |http-nio-8443-exec-2 |ProductionRunServices |I| ProductionRun created: 10618
2021-07-14 13:00:33,278 |http-nio-8443-exec-2 |ServiceEcaRule |I| For Service ECA [workEffortGenericPermission] on [return] got false for condition: [hasPermission][equals][false][true][Boolean]
2021-07-14 13:00:33,370 |http-nio-8443-exec-2 |ServiceEcaRule |I| For Service ECA [workEffortGenericPermission] on [return] got false for condition: [hasPermission][equals][false][true][Boolean]
2021-07-14 13:00:33,372 |http-nio-8443-exec-2 |EntityEcaRule |I| Running Entity ECA Service: indexWorkEffortKeywords, triggered by rule on Entity: WorkEffort
2021-07-14 13:00:33,380 |http-nio-8443-exec-2 |ServiceEcaCondition |I| From Field (quickAssignPartyId) is not found in context for createWorkEffort, defaulting to null.
2021-07-14 13:00:33,380 |http-nio-8443-exec-2 |ServiceEcaRule |I| For Service ECA [createWorkEffort] on [commit] got false for condition: [quickAssignPartyId][is-not-empty][true][String]
2021-07-14 13:00:33,380 |http-nio-8443-exec-2 |ServiceEcaCondition |I| From Field (communicationEventId) is not found in context for createWorkEffort, defaulting to null.
2021-07-14 13:00:33,380 |http-nio-8443-exec-2 |ServiceEcaRule |I| For Service ECA [createWorkEffort] on [commit] got false for condition: [communicationEventId][is-not-empty][true][String]
2021-07-14 13:00:33,380 |http-nio-8443-exec-2 |ServiceEcaRule |I| For Service ECA [createWorkEffort] on [commit] got false for condition: [currentStatusId][equals][SPRINT_ACTIVE][true][String]
2021-07-14 13:00:33,380 |http-nio-8443-exec-2 |ProductionRunServices |I| ProductionRunTaskId created: 10619
2021-07-14 13:00:33,381 |http-nio-8443-exec-2 |ServiceEcaRule |I| For Service ECA [workEffortGenericPermission] on [return] got false for condition: [hasPermission][equals][false][true][Boolean]
2021-07-14 13:00:33,466 |http-nio-8443-exec-2 |ServiceEcaRule |I| For Service ECA [workEffortGenericPermission] on [return] got false for condition: [hasPermission][equals][false][true][Boolean]
2021-07-14 13:00:33,478 |http-nio-8443-exec-2 |EntityEcaRule |I| Running Entity ECA Service: createSystemInfoNote, triggered by rule on Entity: WorkEffortPartyAssignment
2021-07-14 13:00:33,479 |http-nio-8443-exec-2 |ProductionRunServices |I| ProductionRunPartyassigment for party: 10160 created
2021-07-14 13:00:33,479 |http-nio-8443-exec-2 |ServiceEcaRule |I| For Service ECA [workEffortGenericPermission] on [return] got false for condition: [hasPermission][equals][false][true][Boolean]
2021-07-14 13:00:33,480 |http-nio-8443-exec-2 |ServiceDispatcher |E| Incoming context (in runSync : assignPartyToWorkEffort) does not match expected requirements
2021-07-14 13:00:33,481 |http-nio-8443-exec-2 |ProductionRunServices |E| Problem calling the assignPartyToWorkEffort service
2021-07-14 13:00:33,481 |http-nio-8443-exec-2 |GenericDelegator |E| Failure in findByCondition operation for entity [WorkEffortCostCalc]: org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]). Rolling back transaction
2021-07-14 13:00:33,482 |http-nio-8443-exec-2 |ProductionRunServices |E| org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]))
2021-07-14 13:00:33,483 |http-nio-8443-exec-2 |GenericDelegator |E| Failure in findByCondition operation for entity [WorkEffortGoodStandard]: org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]). Rolling back transaction.
2021-07-14 13:00:33,484 |http-nio-8443-exec-2 |PrimaryKeyFinder |E| Error finding entity value by primary key with entity-one: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWork
 Effort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]))
2021-07-14 13:00:33,485 |http-nio-8443-exec-2 |EntityAutoEngine |E| Error doing entity-auto operation for entity [WorkEffortGoodStandard] in service [createWorkEffortGoodStandard]: org.apache.ofbiz.base.util.GeneralException: Error finding entity value by primary key with entity-one: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkE
 ffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId])) (org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.Servic
 eValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId])))
2021-07-14 13:00:33,486 |http-nio-8443-exec-2 |ServiceDispatcher |E| Error in Service [createWorkEffortGoodStandard]: Error doing entity-auto operation for entity WorkEffortGoodStandard in service createWorkEffortGoodStandard: org.apache.ofbiz.base.util.GeneralException: Error finding entity value by primary key with entity-one: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackO
 nly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId])) (org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected 
 exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId])))
2021-07-14 13:00:33,487 |http-nio-8443-exec-2 |GenericDelegator |E| Failure in findOne operation for entity [WorkEffort]: org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]). Rolling back transaction.
2021-07-14 13:00:33,487 |http-nio-8443-exec-2 |ProductionRunServices |E| org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]))
2021-07-14 13:00:33,487 |http-nio-8443-exec-2 |BOMNode |E| Problem calling the createProductionRun service
2021-07-14 13:00:33,488 |http-nio-8443-exec-2 |GenericDelegator |E| Failure in findByCondition operation for entity [SupplierProduct]: org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]). Rolling back transaction.
2021-07-14 13:00:33,488 |http-nio-8443-exec-2 |BOMNode |E| Problem in BOMNode.isManufactured()
2021-07-14 13:00:33,488 |http-nio-8443-exec-2 |GenericDelegator |E| Failure in findByCondition operation for entity [SupplierProduct]: org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]). Rolling back transaction.
2021-07-14 13:00:33,489 |http-nio-8443-exec-2 |BOMNode |E| Problem in BOMNode.isManufactured()
2021-07-14 13:00:33,489 |http-nio-8443-exec-2 |GenericDelegator |E| Failure in findByCondition operation for entity [Product]: org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]). Rolling back transaction.
2021-07-14 13:00:33,490 |http-nio-8443-exec-2 |ServiceDispatcher |E| Error in Service [createProductionRun]: org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [as
 signPartyToWorkEffort.statusId]))
2021-07-14 13:00:33,490 |http-nio-8443-exec-2 |GenericDelegator |E| Failure in findByCondition operation for entity [SupplierProduct]: org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]). Rolling back transaction.
2021-07-14 13:00:33,491 |http-nio-8443-exec-2 |BOMNode |E| Problem in BOMNode.isManufactured()
2021-07-14 13:00:33,491 |http-nio-8443-exec-2 |GenericDelegator |E| Failure in findByCondition operation for entity [SupplierProduct]: org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]). Rolling back transaction.
2021-07-14 13:00:33,492 |http-nio-8443-exec-2 |BOMNode |E| Problem in BOMNode.isManufactured()
2021-07-14 13:00:33,492 |http-nio-8443-exec-2 |GenericDelegator |E| Failure in findByCondition operation for entity [SupplierProduct]: org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]). Rolling back transaction.
2021-07-14 13:00:33,493 |http-nio-8443-exec-2 |BOMNode |E| Problem in BOMNode.isManufactured()
2021-07-14 13:00:33,493 |http-nio-8443-exec-2 |GenericDelegator |E| Failure in findByCondition operation for entity [SupplierProduct]: org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]). Rolling back transaction.
2021-07-14 13:00:33,493 |http-nio-8443-exec-2 |BOMNode |E| Problem in BOMNode.isManufactured()
2021-07-14 13:00:33,494 |http-nio-8443-exec-2 |GenericDelegator |E| Failure in findByCondition operation for entity [SupplierProduct]: org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]). Rolling back transaction.
2021-07-14 13:00:33,494 |http-nio-8443-exec-2 |BOMNode |E| Problem in BOMNode.isManufactured()
2021-07-14 13:00:33,495 |http-nio-8443-exec-2 |GenericDelegator |E| Failure in findByCondition operation for entity [Product]: org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]). Rolling back transaction.
2021-07-14 13:00:33,501 |http-nio-8443-exec-2 |ServiceDispatcher |E| Error in Service [createProductionRun]: org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [as
 signPartyToWorkEffort.statusId]))
2021-07-14 13:00:33,501 |http-nio-8443-exec-2 |ServiceDispatcher |E| Error in Service [createProductionRunsForProductBom]: No production run is required for product with id 14923-SHB7130 in date 2021-06-11 17:29:59.997; please verify the validity dates of the bill of materials and routing.
2021-07-14 13:00:33,502 |http-nio-8443-exec-2 |ServiceDispatcher |E| Error in Service [createProductionRunFromRequirement]: No production run is required for product with id 14923-SHB7130 in date 2021-06-11 17:29:59.997; please verify the validity dates of the bill of materials and routing.
2021-07-14 13:00:33,561 |http-nio-8443-exec-2 |TransactionUtil |E| Rollback Only was set when trying to commit transaction here; throwing rollbackOnly cause exception
2021-07-14 13:00:33,562 |http-nio-8443-exec-2 |ServiceMultiEventHandler |E| Could not commit multi-service global transaction
2021-07-14 13:00:33,563 |http-nio-8443-exec-2 |RequestHandler |E| Request approveRequirements caused an error with the following message: Error calling event: org.apache.ofbiz.webapp.event.EventHandlerException: Commit multi-service global transaction failed

Re: Problem calling the assignPartyToWorkEffort service

Posted by Jacques Le Roux <ja...@les7arts.com>.

Hi Gary,

Your message has been moderated, else it would not have reached this Mailing List.

Please subscribe to the user ML for such questions and then use your email client.
See why here http://ofbiz.apache.org/mailing-lists.html.

You will get a better support, people can answer you on the ML.
The wider the audience the better the answers you might get.

Also it's more work for moderators who have to accept your messages as long as you have not subscribed.
I'll personally no longer accept them (other moderators still could).

Thanks

This said, do you use the service assignPartyToWorkEffort in a standard context (OOTB) or did you create a specific context?

If you use it as OOTB, you need to give us more details. Most of the time URLs are enough and welcome
Else please follow this scenario (at least relevant parts)

Why
     * What you were looking for
     * How did you try to achieve it
     * What did you expect as results
     * And what you really got

How
     # What you did (including detailed steps to reproduce)
     # What you expected to happen
     # What actually happened (including exact quotes of error messages, etc)
     # If possible provide an URL

Also please consider to rather use the last available and supported version (17.12.07): https://ofbiz.apache.org/download.html

HTH

Jacques

Le 13/07/2021 à 18:28, Gary Lawrance a écrit :
> Hi All,
>
> First post to the user forum, but we have been using OFBiz now for two years.  Recently I have been trying to create a production run/run MRP and I get a very unhelpful error.
>
> I am running 16.11.05.
>
> The Following Errors Occurred:
>
> Error calling event: org.apache.ofbiz.webapp.event.EventHandlerException: Service invocation error (null)
>
> Has anyone else come across this issue?
>
> Looking back through the logs it seems to be that the assignPartyToWorkEffort service is missing a statusid as per this error message.
>
> 2021-07-13 09:27:00,301 |http-nio-8443-exec-9 |ProductionRunServices |E| org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [assignPartyToWorkEffort] threw an unexpected exception/errororg.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [assignPartyToWorkEffort.statusId] (The following required parameter is missing: [assignPartyToWorkEffort.statusId]))