message BO has been changed by another user

rbross

Hello,

Starting getting this message when running a process.
Not sure why I am getting it. I am the only one in the system under test.
I am passing this BO to each process and sub-process that uses it. The BO only has 1 records in it.
I am wondering if I have the same record in context twice?

This BO is Temp BO used to hold certain values while the process is running.
It gets CLEANED at the beginning of the process each time it is run.

Roger

BenHayat

rbross wrote
Hello,

Starting getting this message when running a process.
Not sure why I am getting it. I am the only one in the system under test.
I am passing this BO to each process and sub-process that uses it. The BO only has 1 records in it.
I am wondering if I have the same record in context twice?

This BO is Temp BO used to hold certain values while the process is running.
It gets CLEANED at the beginning of the process each time it is run.

Roger

I get this too and very annoying, because after the error, user gets kicked out.

rbross

I think it is related to the FIND statement in the process call and IN BATCHES OF # used.
I changed IN BATCHES OF from 1 to 20 in a few of my processes and then started to get the message.
I changed it back to 1 in for 2 processes and it when away and now comes up in the next process in the list.

Did I mention most of these processes are doing FINDS on External MS-SQL Tables.

Roger

BenHayat

rbross wrote
I think it is related to the FIND statement in the process call and IN BATCHES OF # used.
I changed IN BATCHES OF from 1 to 20 in a few of my processes and then started to get the message.
I changed it back to 1 in for 2 processes and it when away and now comes up in the next process in the list.

Did I mention most of these processes are doing FINDS on External MS-SQL Tables.

Roger

I'm not doing any BATCHES or external DB and I get it. I'm trying to see if I can isolate it to create a test BSV for support.

customaware

Roger,

If you are bringing a record into context and then running sub processes, check to make sure that none of the sub process are making any indirect changes to the
initial by way of the BO rules being triggered and then following up with further changes to the record in the top level process.

Changes to that record should be made in one place or the other.

This may all be nonsense but seems to be the can from what I have seen in the past.

rbross

Some how its related to the IN BATCHES OF if its greater than 1 then I get the error!

tford

It's really hard to make any meaningful comment about your scenario without the details. I hesitate to say that because often that can involve LOTS of detail to get your mind around understanding a scenario. Such is the life of programming.

.. where are you triggering this process from, a query, a menu item, a BO rule?
.. have you looked at the logs?

rbross

Yes, Tom this is a tricky process for sure. Dealing with External tables makes it even harder to develop I think!
I am starting the process from a menu items right now.

I just ran it again and this time it completed without any issues.
I took out the 2nd to last process call that reads the special pricing agreement BO.
The last process which creates the actual records, created 75 records this time without failing or running out of memory (Java Heap Space error)
The special pricing process is the last process that is called from the process that does a FIND on the temp table with my working dataset.
Basically it is layed out this way:
FIND ALL T_AVX_Sales_Ledger IN BATCHES OF 1 (There are 75 records in the temp table)
Read_apinv_line (called process) This process calls a process to Read apinv_hdr
Find Lowest SPA Price ( called process)
Within This process it calls up 6 other processes to look for the lowest Special pricing agreement for the partno.
Once it finds a match it sets a FoundFlag to Yes and does not call the rest of the processes
It then returns to the top level process and calls the final process to read the temp table for the last time and creates a record for each one in the actual AVX_SalesLedger BO.

When calling the Find_Lowest_SPA_Price process I get the "Updated by another user error on the other temp BO"

"Find_Lowset_SPA_Price" process looks like this: Passing in T_AVX_Sales_Ledger & T_SalesLedgerDateRange
Rule 1 Find_Lowest_SPA_Price1
Rule 2 If T_SalesLedgerDateRange.T_SPANumFound='No' Then
G_Find_Lowest_SPA_Price2
Rule 3 If T_SalesLedgerDateRange.T_SPANumFound='No' Then
G_Find_Lowest_SPA_Price3
Rule 4 If T_SalesLedgerDateRange.T_SPANumFound='No' Then
G_Find_Lowest_SPA_Price4
Rule 5 If T_SalesLedgerDateRange.T_SPANumFound='No' Then
G_Find_Lowest_SPA_Price5
Rule 6 If T_SalesLedgerDateRange.T_SPANumFound='No' Then
G_Find_Lowest_SPA_Price6

Each one of the above processes looks likes this with the exception of the SPA.Cust_PartNo_Item field. we are trying to find the matching part number that is in the Special Pricing Agreement Table and it could be 1 of 3 PartNo variations.
Passing in T_AVX_Sales_Ledger & T_SalesLedgerDateRange

SPA_Price1. AVX_SPA.CustPartNo_Item=T_AVX_Sales_Ledger.SalesItemID
SPA_Price2. AVX_SPA.AVX_CustPartNo_Desc=T_AVX_Sales_Ledger.SalesItemID
SPA_Price3. AVX_SPA.AVX_Catelog_CustPartNo=T_AVX_Sales_Ledger.SalesItemID

SPA_Price4. AVX_SPA.CustPartNo_Item=T_AVX_Sales_Ledger.SalesItem_Desc
SPA_Price5. AVX_SPA.AVX_CustPartNo_Desc=T_AVX_Sales_Ledger.SalesItem_Desc
SPA_Price6. AVX_SPA.AVX_Catelog_CustPartNo=T_AVX_Sales_Ledger.SalesItem_Desc

Rule 1 FIND AVX_SPA WHERE AVX_SPA.CustPartNo_Item=T_AVX_Sales_Ledger.SalesItemID IN BATCHES OF 1

Rule 2 If SEARCH_COUNT<>0 AND T_AVX_Sales_Ledger.SalesDateInvoiced BETWEEN AVX_SPA.SPA_StartDate AND AVX_SPA.SPA_ExpireDate Then
T_SalesLedgerDateRange.T_SPANumFound='Yes'

Rule 3 If T_SalesLedgerDateRange.T_SPANumFound='Yes' AND (T_AVX_Sales_Ledger.POSPAAuthAmt2=0 OR T_AVX_Sales_Ledger.POSPAAuthAmt2<>0) AND AVX_SPA.SPACost<T_AVX_Sales_Ledger.POSPAAuthAmt2 Then
T_SalesLedgerDateRange.T_SpaColumnUsed=1
T_SalesLedgerDateRange.T_SPAItem=AVX_SPA.CustPartNo_Item
T_SalesLedgerDateRange.T_SuggestedSPA=AVX_SPA.SPA_No
T_SalesLedgerDateRange.T_SPABookAmt=AVX_SPA.BookCost
T_SalesLedgerDateRange.T_SPAAuthAmt=AVX_SPA.SPACost
T_AVX_Sales_Ledger.SPAColumnUsed=1
T_AVX_Sales_Ledger.SPAItem=AVX_SPA.CustPartNo_Item
T_AVX_Sales_Ledger.SuggestedSPA=AVX_SPA.SPA_No
T_AVX_Sales_Ledger.POSPABookAmt2=AVX_SPA.BookCost
T_AVX_Sales_Ledger.POSPAAuthAmt2=AVX_SPA.SPACost

Does this help or just more confusion?

Desperate to get this resolved~ Roger