In our company we use "user defined sql-functions" (UDF) to extract certain data. We use these UDF sucessfully in our reports programmed with "Report Studio 8.2".
Now I need to use a UDF in "Event Studio 8.2" to create a Data Item. In this case COGNOS does not run the UDF on the database where it is defined. Instead COGNOS tries to run the UDF as a COGNOS-internal-function which of course leads to the followin Error message:
CNC-ASV-0025 Agent Condition invalid: CNC-MON-0011 The Monitor Service encountered an error. RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-126'. UDA-SQL-0219 The function "TBGT4DATE" is being used for local processing but is not available as a built-in function, or at least one of its parameters is not supported.
Does anyone know how to solve this problem?
Thank you in advance
Now I need to use a UDF in "Event Studio 8.2" to create a Data Item. In this case COGNOS does not run the UDF on the database where it is defined. Instead COGNOS tries to run the UDF as a COGNOS-internal-function which of course leads to the followin Error message:
CNC-ASV-0025 Agent Condition invalid: CNC-MON-0011 The Monitor Service encountered an error. RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-126'. UDA-SQL-0219 The function "TBGT4DATE" is being used for local processing but is not available as a built-in function, or at least one of its parameters is not supported.
Does anyone know how to solve this problem?
Thank you in advance