Hello uv gurus, 

I post a question about trigger on uv/win 11.3

We use a trigger after update on a high frequency update file 'A'.  (10 update/min)

The trigger is really simple (get a lock on file B, delete record on file B) 

Yesterday, we get, 9 time on thousand  executions, the error :

Unable to execute trigger as trigger creator "dom\\user" ​

9 times, the session's user is différent, the PID is différent, the account/VOC and runtime context  is the same. 

Is someone have any idea what to check ? 

With kind regards.

------------------------------
manu fernandes
------------------------------

Manu,

UniVerse needs to be able to detect that user who created trigger exists and at the point in time. When the enquiry was made to the operating system the status of the user could not be determined  (most likely down to an Active Domain problem), hence the message you got. You can recreate this situation by deleting the user who created the trigger and you will get the same error.

At the time of the error this suggests that the OS call to validate the user and I am presumming this is being done via an Active Directory call, failed at that instance to determine the status of the user but a later call the Active Directory call worked. A workaround would be to drop the trigger and recreate while logged on as a user that is created locally on the machine. This would mean that UniVerse would check locally on the machine to see if the user exists and not have to rely on the Active Driectory call that seems to have the odd failure in your environment.

Regards,

------------------------------
Jonathan Smith
UniData ATS
Rocket Support
------------------------------

---

Hello uv gurus, 

I post a question about trigger on uv/win 11.3

We use a trigger after update on a high frequency update file 'A'.  (10 update/min)

The trigger is really simple (get a lock on file B, delete record on file B) 

Yesterday, we get, 9 time on thousand  executions, the error :

Unable to execute trigger as trigger creator "dom\\user" ​

9 times, the session's user is différent, the PID is différent, the account/VOC and runtime context  is the same. 

Is someone have any idea what to check ? 

With kind regards.

------------------------------
manu fernandes
------------------------------

Thank you Greg that worked.

Jon Card
Combined Transport, Inc.
541-618-6565

www.combinedtransport.com
Division of Combined Transport Logistics Group, Inc.

---