Venio Console: Ingestion error. Cannot find either column "DBO" or the user-defined function or aggregate "DBO.FN_VARBINTOHEXSTR" or the name is ambiguous

Problem

Ingestion is stuck with the error message that reads, "Cannot find either column "DBO" or the user-defined function or aggregate "DBO.FN_VARBINTOHEXSTR" or the name is ambiguous"

Resolution

This issue usually occurs when synonym FN_VARBINTOHEXSTR, it was points to VenioPCD instead of Master database.Therefore, on your project database run the following script

USE [<Replace with your project database name>]
GO

DROP SYNONYM [dbo].[FN_VARBINTOHEXSTR]
GO

CREATE SYNONYM [dbo].[FN_VARBINTOHEXSTR] FOR [Master].[dbo].[FN_VARBINTOHEXSTR]
GO