Why is Epicor insisting in creating a function that already exists (SQL)

[hkeric.wci (Haso Keric)]

Is this related to what you had before:

SQL Blocking Process ( CREATE function [Erp].[listEntry] )

We installed some SQL monitoring tools a few weeks ago and we’ve been learning all sorts of things about the Epicor DB. Once thing we keep getting repeatedly is a Blocking Process usually triggered by a BAQ [image] What’s strange is that this function already exists but somehow Epicor BAQ process runs this create function and it causes some locking issues. Any idea why this is and how to stop it ? @Rich

Also I get similar ones but diff:

SQL Blocking Process ( CREATE function [Erp].[listEntry] )

I get alot of these, following proper SQL Permissions by not giving the Service Account full DB Access to dbo. <Exception act="Ice:BO:SysConfig/SysConfigSvcContract/PassSessionValues" machine="GRECORAPP" pid="9104" tid="174"><![CDATA[System.Data.SqlClient.SqlException (0x80131904): Caller does not have permissions to execute the stored procedure. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlCl…