Compiling the database with certain database users causes "Database error 50000: re-throw in Procedure vid

Compiling the database with certain database users causes "Database error 50000: re-throw in Procedure vid_FillDialogCustomSQL". (150144)

Return

Feedback submitted.

Was this article helpful?

[Select Rating]

Title

Compiling the database with certain database users causes "Database error 50000: re-throw in Procedure vid_FillDialogCustomSQL".
Description

We configured an additional DB user according to the minimal SQL permissions guide, but when trying to compile the database with the additional DB user, we see the error message "Database error 50000: re-throw in Procedure vid_FillDialogCustomSQL".
Cause

When compiling the database, stored procedures are executed and rolled back. The error message is thrown when executing a stored procedure, e.g. a customer stored procedure, fails. This could have various reasons, such as lack of permissions. E.g. the procedure has a bulk load statement and the DB user used for the compilation does not have bulkadmin permissions.
Resolution

Use an SQL tool such as SQL Management Studio or Toad for SQL Server to try to execute the stored procedure within a transaction that you can roll back. If there are any errors, investigate them further.