AXv3 Production: Production status 'Ended' does not allow updating

[ACO]

This one is a real head-scratcher. One of our manufacturing locations has
found a way to cause the simple navigation off the row to trigger this error.
I have compared ProdTable, InventDim, ProdBOM, ProdRoute, BOM and Route
looking for data differences but have yet to land on anything conclusive.

Here's the situation.

The user fires up the ProdTable form and, using the arrow keys or mouse
cursor, navigates from one row to another. Eventually they will touch a row
and, when trying to navigate off the row, receive the error "Producton status
'Ended' does not allow updating" (@SYS22041). The only way out is to exit AX
and log on again.

The symptom does not present itself for any Production Order of any other
Warehouse than one.

The label is found in very few places. The call stack ndicates the error is
being thrown at Classes\ProdStatusType_Completed\validateWrite(). The root of
the thread is at
Forms\ProdTable\DataSources\ProdTable\Methods\validateWrite().

I found one situation where two Production Orders outputing the same item
used the same BOM and Route -- one had the symptom, the other did not. The
only substantial difference I found was that a ProdBOM component item was
changed earlier from the base BOM in the one with the symptom. But this is
not unusual in our environment. Other Warehouses do it all the time and do
not show the symptom.

Something somewhere is trying to change the ProdTable row when the user is
simply navigating. And it is only one Warehouse. I have not been able to
isolate what is changing the contents of the ProdTable row.

Any ideas?

[unknown]

First place to check is if there's any custom code trying to update fields in
the "active" method of the datasource. "active" is called each time a new row
is selected.

Is there a lot of custom code on the form? The "leave" method could also be
the culprit.
--
Mathieu Vaillancourt
http://vaillancourtm.blogspot.com

Post by ACO
This one is a real head-scratcher. One of our manufacturing locations has
found a way to cause the simple navigation off the row to trigger this error.
I have compared ProdTable, InventDim, ProdBOM, ProdRoute, BOM and Route
looking for data differences but have yet to land on anything conclusive.
Here's the situation.
The user fires up the ProdTable form and, using the arrow keys or mouse
cursor, navigates from one row to another. Eventually they will touch a row
and, when trying to navigate off the row, receive the error "Producton status
and log on again.
The symptom does not present itself for any Production Order of any other
Warehouse than one.
The label is found in very few places. The call stack ndicates the error is
being thrown at Classes\ProdStatusType_Completed\validateWrite(). The root of
the thread is at
Forms\ProdTable\DataSources\ProdTable\Methods\validateWrite().
I found one situation where two Production Orders outputing the same item
used the same BOM and Route -- one had the symptom, the other did not. The
only substantial difference I found was that a ProdBOM component item was
changed earlier from the base BOM in the one with the symptom. But this is
not unusual in our environment. Other Warehouses do it all the time and do
not show the symptom.
Something somewhere is trying to change the ProdTable row when the user is
simply navigating. And it is only one Warehouse. I have not been able to
isolate what is changing the contents of the ProdTable row.
Any ideas?

[ACO]

Mathieu:

Thanks for the ping.

As it turned out, the VAR wrote some very poor code in the DataSource
active() method that attempted various updates including to the ProdTable
table. It finally showed up only because a user changed some data in an
otherwise static base data table. Of course, since I was off on a tangent
chasing that problem, I never had a chance to come back here to check for
replies.