Updating Job Operation UD Fields

We have a situation where we need to update a couple of UD columns in JobOper, this will be triggered when an operation is marked complete.

After creating an updatable baq and UBAQ method directive associated with it, I am getting errors trying to apply the update. I’ve used both custom code and a function but the update fails. I even tried writing a transaction to a UD table and having a method directive on that to update the job oper table. This was to try to isolate the the change of the operation completed flag from the UD fields, thinking there was some kind of timing or lock issue.

I’ve now stepped back and only have an updatable BAQ with no directives associated with it. Strangely, I can now update the UD fields in our Pilot environment, but not in Production with the exact same BAQ.

This is the error I get:

Severity: Exception, Table: JobOper, Field: , RowID: 10668c98-fac8-4488-a6b1-f2fea2361015, Text: Update of JobOper not allowed.

I’ve looked at our directives that are running on JobEntry comparing our test environment to our production environment…everything is consistent.

I have seen a few other posts related to issues updating JobOper that haven’t worked out for me.

Looking for Ideas as to where this restriction may be coming from

What are your settings under company configuration here? If prevent changes is checked you will need to Un-Engineer the job before it will allow changes

image

My “Prevent Changes” checkbox is not checked in either environment

thanks for the suggestion tho

Prevent changes would not stop just an update, but wholesale changes.

I do updates to JobOper with a preprocessing condition and then a post processing update on Labor.Update. I also have a ubaq to fix things in JobOper.
Both of these are wrapped in a transaction scope.

Is there anything else in the Event Viewer on the production app server before the exception is thrown?