**BRIEF DESCRIPTION**
This KB article shows you how to resolve the reported error in the ARDCS status log screen.
ERROR:
SDE Logged: ProcessUsageRec: Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fn_RemoveNonPrintableCharsAndDblQuote", or the name is ambiguous.:(-2147217900)
SOLUTION: Run the entire following script against the RP database.
**START OF SCRIPT**
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE FUNCTION [dbo].[fn_RemoveNonPrintableCharsAndDblQuote] (
@szValue VARCHAR(6000)
)
RETURNS VARCHAR(6000)
AS
/********************************************************************************
********************************************************************************
***
*** Date Author Modification
*** 2015-07-08 JN Created.
********************************************************************************
********************************************************************************/
BEGIN
RETURN (
SELECT
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(REPLACE(@szValue,
CHAR(00), ''), CHAR(01), ''), CHAR(02), ''), CHAR(03), ''), CHAR(04), ''),
CHAR(05), ''), CHAR(06), ''), CHAR(07), ''), CHAR(08), ''), CHAR(09), ''),
CHAR(10), ''), CHAR(11), ''), CHAR(12), ''), CHAR(13), ''), CHAR(14), ''),
CHAR(15), ''), CHAR(16), ''), CHAR(17), ''), CHAR(18), ''), CHAR(19), ''),
CHAR(20), ''), CHAR(21), ''), CHAR(22), ''), CHAR(23), ''), CHAR(24), ''),
CHAR(25), ''), CHAR(26), ''), CHAR(27), ''), CHAR(28), ''), CHAR(29), ''),
CHAR(30), ''), CHAR(31), ''), '"', '')
)
END
GO
GRANT EXECUTE
ON OBJECT::[dbo].[fn_RemoveNonPrintableCharsAndDblQuote] TO [idsrole]
AS [dbo];
GO
**END OF SCRIPT**