RE: MRP Not Working

2022-02-02 Thread Steven Payne 
OK will do,

I haven't modified anything, just haven't loaded all the demo data into the 
database, I created our own dataset. It has been working perfect until now. So 
it leads me to believe there is something in the data that is causing this.  
What is weird though is it is failing when it is using the entity-auto create 
method.

The status Item is there and the user login are there, so it leads me to 
believe it’s the requirement that is missing... But it's running MRP so it's 
creating the requirement in the first place... ugh.


Regards,
Steven Payne
Inventory Control Coordinator

-Original Message-
From: Michael Brohl  
Sent: February 1, 2022 2:09 PM
To: user@ofbiz.apache.org
Subject: Re: MRP Not Working

Hi Steven,

the table RequirementStatus has 3 foreign keys: requirementId, statusId 
and changeByUserLoginId.

Are those ids present in their tables (Requirement, StatusItem, 
UserLogin)? Is all seed data loaded?

Is this a custom installation or standard OFBiz?

If you think this is a bug, you might want to file a Jira. Please give 
as much information as possible there on how to recreate this error.

Thanks and regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 01.02.22 um 21:37 schrieb Steven Payne:
> Hi Michael,
>
> Thanks for the quick response.  Here is the full stacktrace (I think)...
>
> 2022-02-01 12:33:36,369 |OFBiz-JobQueue-44|ServiceDispatcher 
> |E| Service [createRequirementStatus] threw an unexpected exception/error
> org.apache.ofbiz.service.GenericServiceException: Cannot run job. (Unable to 
> queue job [createRequirementStatus.1643747616369])
>  at 
> org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:143)
>  ~[ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:70)
>  ~[ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:748)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:813)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runAsync(GenericDispatcherFactory.java:181)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:131)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:160) 
> [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:191)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:514)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.manufacturing.mrp.ProposedOrder.create(ProposedOrder.java:262)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.manufacturing.mrp.MrpServices.executeMrp(MrpServices.java:816)
>  [ofbiz.jar:?]
>  at sun.reflect.GeneratedMethodAccessor1393.invoke(Unknown Source) 
> ~[?:?]
>  at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>  ~[?:1.8.0_312]
>  at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_312]
>  at 
> org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:415)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70)
>  [ofbiz.jar:?]
>  at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87) 
> [ofbiz.jar:?]
>  at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>  [?:1.8.0_312]
>  at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>  [?:1.8.0_312]
>  at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312]
> Caused by: org.apache.ofbiz.service.job.InvalidJobException: Unable to queue 
> job [createR

Re: MRP Not Working

2022-02-01 Thread Michael Brohl 
DAO.create(GenericHelperDAO.java:66)
 [ofbiz.jar:?]
 at 
org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:874) 
[ofbiz.jar:?]
 at org.apache.ofbiz.entity.GenericValue.create(GenericValue.java:76) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.engine.EntityAutoEngine.invokeCreate(EntityAutoEngine.java:357)
 [ofbiz.jar:?]
 at 
org.apache.ofbiz.service.engine.EntityAutoEngine.runSync(EntityAutoEngine.java:114)
 [ofbiz.jar:?]
 at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:415) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
 [ofbiz.jar:?]
 at 
org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70) 
[ofbiz.jar:?]
 at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87) 
[ofbiz.jar:?]
 at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) 
[?:1.8.0_312]
 at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) 
[?:1.8.0_312]
 at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312]


Regards,
Steven Payne
Inventory Control Coordinator

-Original Message-
From: Michael Brohl 
Sent: February 1, 2022 12:21 PM
To: user@ofbiz.apache.org
Subject: Re: MRP Not Working

Hi Steven,

it seems that you did not provide the whole stacktrace, at least I cannot find 
a message containing hints for a failed foreign key constraint.

You should find the name of the failed constraint in the error log, near the 
prepared statement log entry.

Please make your credentials shown in the log unreadable next time ;-)

Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 01.02.22 um 21:02 schrieb Steven Payne:

Hi All,

I am trying to run the MRP system here and I am coming across a weird error. 
Has anyone else had issues with running MRP and it not being able to create a 
REQUIREMENT_STATUS?

I managed to find the start of the error (posted below) and I am trying one by 
one to add each manufacturing run to see if I can isolate the issue.  No luck 
so far. It states that there is a foreign key constraint breaking...but what FK 
constraint?

2022-02-01 11:59:21,676 |OFBiz-JobQueue-47|ServiceDispatcher 
|E| Service [createRequirementStatus] threw an unexpected exception/error
org.apache.ofbiz.service.GenericServiceException: Cannot run job. (Unable to 
queue job [createRequirementStatus.1643745561676])
  at 
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:143)
 ~[ofbiz.jar:?]
  at 
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:70)
 ~[ofbiz.jar:?]
  at 
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:748) 
[ofbiz.jar:?]
  at 
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:813) 
[ofbiz.jar:?]
  at 
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runAsync(GenericDispatcherFactory.java:181)
 [ofbiz.jar:?]
  at 
org.apache.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:131)
 [ofbiz.jar:?]
  at 
org.apache.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:160) 
[ofbiz.jar:?]
  at 
org.apache.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:191) 
[ofbiz.jar:?]
  at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:514) 
[ofbiz.jar:?]
  at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240) 
[ofbiz.jar:?]
  at 
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
 [ofbiz.jar:?]
  at 
org.apache.ofbiz.manufacturing.mrp.ProposedOrder.create(ProposedOrder.java:262) 
[ofbiz.jar:?]
  at 
org.apache.ofbiz.manufacturing.mrp.MrpServices.executeMrp(MrpServices.java:816) 
[ofbiz.jar:?]
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
~[?:1.8.0_312]
  at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
~[?:1.8.0_312]
  at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 ~[?:1.8.0_312]
  at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_312]
  at 
org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
 [ofbiz.jar:?]
  at 
org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
 [ofbiz.jar:?]
  at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:415) 
[ofbiz.jar:?]
  at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240) 
[ofbiz.jar:?]

RE: MRP Not Working

2022-02-01 Thread Steven Payne 
er.runSync(GenericDispatcherFactory.java:88)
 [ofbiz.jar:?]
at 
org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70) 
[ofbiz.jar:?]
at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87) 
[ofbiz.jar:?]
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) 
[?:1.8.0_312]
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) 
[?:1.8.0_312]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312]


Regards,
Steven Payne
Inventory Control Coordinator

-Original Message-
From: Michael Brohl  
Sent: February 1, 2022 12:21 PM
To: user@ofbiz.apache.org
Subject: Re: MRP Not Working

Hi Steven,

it seems that you did not provide the whole stacktrace, at least I cannot find 
a message containing hints for a failed foreign key constraint.

You should find the name of the failed constraint in the error log, near the 
prepared statement log entry.

Please make your credentials shown in the log unreadable next time ;-)

Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 01.02.22 um 21:02 schrieb Steven Payne:
> Hi All,
>
> I am trying to run the MRP system here and I am coming across a weird error. 
> Has anyone else had issues with running MRP and it not being able to create a 
> REQUIREMENT_STATUS?
>
> I managed to find the start of the error (posted below) and I am trying one 
> by one to add each manufacturing run to see if I can isolate the issue.  No 
> luck so far. It states that there is a foreign key constraint breaking...but 
> what FK constraint?
>
> 2022-02-01 11:59:21,676 |OFBiz-JobQueue-47|ServiceDispatcher 
> |E| Service [createRequirementStatus] threw an unexpected exception/error
> org.apache.ofbiz.service.GenericServiceException: Cannot run job. (Unable to 
> queue job [createRequirementStatus.1643745561676])
>  at 
> org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:143)
>  ~[ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:70)
>  ~[ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:748)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:813)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runAsync(GenericDispatcherFactory.java:181)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:131)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:160) 
> [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:191)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:514)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.manufacturing.mrp.ProposedOrder.create(ProposedOrder.java:262)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.manufacturing.mrp.MrpServices.executeMrp(MrpServices.java:816)
>  [ofbiz.jar:?]
>  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
> ~[?:1.8.0_312]
>  at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
> ~[?:1.8.0_312]
>  at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>  ~[?:1.8.0_312]
>  at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_312]
>  at 
> org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:415)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
>  [ofbiz.jar:?]
>  at 
> org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70)
>  [ofbiz.jar:?]
>  at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87) 
> [ofbiz.jar:?]
>  at 
> java.util.concurrent.Thr

Re: MRP Not Working

2022-02-01 Thread Michael Brohl 

Hi Steven,

it seems that you did not provide the whole stacktrace, at least I 
cannot find a message containing hints for a failed foreign key constraint.


You should find the name of the failed constraint in the error log, near 
the prepared statement log entry.


Please make your credentials shown in the log unreadable next time ;-)

Best regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 01.02.22 um 21:02 schrieb Steven Payne:

Hi All,

I am trying to run the MRP system here and I am coming across a weird error. 
Has anyone else had issues with running MRP and it not being able to create a 
REQUIREMENT_STATUS?

I managed to find the start of the error (posted below) and I am trying one by 
one to add each manufacturing run to see if I can isolate the issue.  No luck 
so far. It states that there is a foreign key constraint breaking...but what FK 
constraint?

2022-02-01 11:59:21,676 |OFBiz-JobQueue-47|ServiceDispatcher 
|E| Service [createRequirementStatus] threw an unexpected exception/error
org.apache.ofbiz.service.GenericServiceException: Cannot run job. (Unable to 
queue job [createRequirementStatus.1643745561676])
 at 
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:143)
 ~[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:70)
 ~[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:748) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:813) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runAsync(GenericDispatcherFactory.java:181)
 [ofbiz.jar:?]
 at 
org.apache.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:131)
 [ofbiz.jar:?]
 at 
org.apache.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:160) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:191) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:514) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
 [ofbiz.jar:?]
 at 
org.apache.ofbiz.manufacturing.mrp.ProposedOrder.create(ProposedOrder.java:262) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.manufacturing.mrp.MrpServices.executeMrp(MrpServices.java:816) 
[ofbiz.jar:?]
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
~[?:1.8.0_312]
 at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
~[?:1.8.0_312]
 at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 ~[?:1.8.0_312]
 at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_312]
 at 
org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
 [ofbiz.jar:?]
 at 
org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
 [ofbiz.jar:?]
 at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:415) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240) 
[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
 [ofbiz.jar:?]
 at 
org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70) 
[ofbiz.jar:?]
 at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87) 
[ofbiz.jar:?]
 at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) 
[?:1.8.0_312]
 at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) 
[?:1.8.0_312]
 at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312]
Caused by: org.apache.ofbiz.service.job.InvalidJobException: Unable to queue 
job [createRequirementStatus.1643745561676]
 at 
org.apache.ofbiz.service.job.GenericServiceJob.deQueue(GenericServiceJob.java:151)
 ~[ofbiz.jar:?]
 at org.apache.ofbiz.service.job.JobPoller.queueNow(JobPoller.java:173) 
~[ofbiz.jar:?]
 at org.apache.ofbiz.service.job.JobManager.runJob(JobManager.java:366) 
~[ofbiz.jar:?]
 at 
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:141)
 ~[ofbiz.jar:?]
 ... 26 more
2022-02-01 11:59:21,677 |OFBiz-JobQueue-47|TransactionUtil   
|W| Calling transaction setRollbackOnly; this stack trace shows where this is 
happening:
java.lang.Exception: Service [createRequirementStatus] threw an unexpected 
exception/error
 at 
org.apache.ofbiz.entity.transaction.TransactionUtil.setRol

MRP Not Working

2022-02-01 Thread Steven Payne 
Hi All,

I am trying to run the MRP system here and I am coming across a weird error. 
Has anyone else had issues with running MRP and it not being able to create a 
REQUIREMENT_STATUS?

I managed to find the start of the error (posted below) and I am trying one by 
one to add each manufacturing run to see if I can isolate the issue.  No luck 
so far. It states that there is a foreign key constraint breaking...but what FK 
constraint?

2022-02-01 11:59:21,676 |OFBiz-JobQueue-47|ServiceDispatcher 
|E| Service [createRequirementStatus] threw an unexpected exception/error
org.apache.ofbiz.service.GenericServiceException: Cannot run job. (Unable to 
queue job [createRequirementStatus.1643745561676])
at 
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:143)
 ~[ofbiz.jar:?]
at 
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:70)
 ~[ofbiz.jar:?]
at 
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:748) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:813) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runAsync(GenericDispatcherFactory.java:181)
 [ofbiz.jar:?]
at 
org.apache.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:131)
 [ofbiz.jar:?]
at 
org.apache.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:160) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:191) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:514) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
 [ofbiz.jar:?]
at 
org.apache.ofbiz.manufacturing.mrp.ProposedOrder.create(ProposedOrder.java:262) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.manufacturing.mrp.MrpServices.executeMrp(MrpServices.java:816) 
[ofbiz.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
~[?:1.8.0_312]
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
~[?:1.8.0_312]
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 ~[?:1.8.0_312]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_312]
at 
org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
 [ofbiz.jar:?]
at 
org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
 [ofbiz.jar:?]
at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:415) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
 [ofbiz.jar:?]
at 
org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70) 
[ofbiz.jar:?]
at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87) 
[ofbiz.jar:?]
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) 
[?:1.8.0_312]
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) 
[?:1.8.0_312]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312]
Caused by: org.apache.ofbiz.service.job.InvalidJobException: Unable to queue 
job [createRequirementStatus.1643745561676]
at 
org.apache.ofbiz.service.job.GenericServiceJob.deQueue(GenericServiceJob.java:151)
 ~[ofbiz.jar:?]
at org.apache.ofbiz.service.job.JobPoller.queueNow(JobPoller.java:173) 
~[ofbiz.jar:?]
at org.apache.ofbiz.service.job.JobManager.runJob(JobManager.java:366) 
~[ofbiz.jar:?]
at 
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:141)
 ~[ofbiz.jar:?]
... 26 more
2022-02-01 11:59:21,677 |OFBiz-JobQueue-47|TransactionUtil   
|W| Calling transaction setRollbackOnly; this stack trace shows where this is 
happening:
java.lang.Exception: Service [createRequirementStatus] threw an unexpected 
exception/error
at 
org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:358)
 [ofbiz.jar:?]
at 
org.apache.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:292)
 [ofbiz.jar:?]
at 
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:764) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:813) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runAsync(GenericDispa