Skip to main content

Hello everyone,

I’m working on a workflow which goal is to automatizes human operations.
We using it for shop order operations subcontracting on other company of our group.

The issue is :
I recover a collection of filtered shop order operations, then I loop on those and I want to update the ParallelOperation field, which is an enum.
I got an error : 

"java.sql.SQLException: OR
A-06531: Reference to uninitialized collection ORA-06512: at "IFS
APP.SHOP_ORDER_HANDLING_SVC", line 28606 ORA-06512: at "IFSAPP.SH
OP_ORDER_HANDLING_SVC", line 28617 ORA-06512: at "IFSAPP.SHOP_ORD
ER_HANDLING_SVC", line 12700 ORA-06512: at line 1 "

If I try to update the Db value (field name : ParallelOperationDb), no error, but values are not updated.

I already do this kind of action previously, not in a loop, to update OperStatusCode (I update this one, not the Db value field).

I don’t understand what’s wrong. I tried different APIs (ShopOrderHandling , ShopOrderOperationsHandling) and different EntitySets and it’s not working.

I absolutely need to loop on operations as I need to update all filtered operations

Here is the BPM file (can’t upload so I paste the code in pastebin.com) : https://pastebin.com/Mx7irbCW

Here is the image of the bpmn diagram :
https://jumpshare.com/s/1j1LtmfdqyvKUu1FcmQd

Thank you for your help

Up, still need help
Here is my super drawing :
 


It’s bug when I change ParallelOperation value of the Shop Order Operation
What’s funny is I update the OperStatusCode of a Shop Order Operation with client value on the screen below, OperStatusCode is a standard enum ok you follow
 


Then in my test I try to update ParallelOperation of a Shop Order Operation with client value, on the screen below, ParallelOperation is also a standard enum
 

But here I got the same error of the collection not initialized
It’s same structural object, a standard enum, but different behaviour !!????
Just trying some stuff to understand what’s going on, we don’t even care about the loop as it’s not working on a single element
 

 It​​​​​​ tried all values, french, english, db values with dbfield (crazy one, no error, nothing saved with dbvalues love it guys)
Thank you for your help with this incredible drawing tool


Reply