AppWorx, Dollar Universe and Sysload Community

AWI REST POST causing Blocking in database

  • 1.  AWI REST POST causing Blocking in database

    Posted 08-24-2020 02:13 PM
    We are importing one object via a REST call, but getting a tremendous amount of DB blocking - to the point the AWI becomes unavailable to users.

    The head blocker has this statement:

    (@P1 int)SELECT * FROM OH with (UPDLOCK) WHERE OH_Idnr = @P1


    Does anyone have experience with the import of a JSON causing the system to grind to a hault?