3 Replies Latest reply on May 11, 2018 2:24 AM by alouhichi2

    Schedule Bulk Update on System/User Foreign Key Constraint Error

    Apprentice

      Anyone know how to get around this problem?

       

      I am trying to set up a daily scheduled bulk update to set an attribute added to the System/User Record called Current Network. Running the bulk update interactively runs successfully but running as a scheduled task every update fails with

       

      The UPDATE statement conflicted with the FOREIGN KEY constraint "fkey$tps_user$userpw".

      The conflict occurred in database "LANDESKDEV", table "dbo.tps_password", column "tps_guid".

      The statement has been terminated.

       

      The query is declared as a system query available to everyone with this definition

      awtemp.png

      Running the bulk action interactively works fine

      awtemp2.png

       

      The definition of the schedule within Bulk Update Management is:

      awtemp3.png

       

      The user added attribute on System/User Record called Current Network has the following Properties

      CurrentNetworkProp.png
      which maps to the inbuilt attribute System/Company

      temp.png