This documentation supports the 19.11 version of Remedy Smart Reporting, which is available only to BMC Helix subscribers (SaaS).
To view an earlier version, select the version from the Product version menu of the documentation at IT Service Management Suite .

Troubleshooting database functions defined in Remedy AR System Server for use in Freehand SQL

This topic describes how to troubleshoot some of the issues related to Freehand SQL.

Issue symptomIssue scopeResolution

The following error message is displayed:

ERROR (8570): JDBC Custom function not defined.; Function testfunction is not defined in AR System JDBC:Generic Db Functions Form for database SQL Server.

You executed a function that is not defined in Remedy AR System server.

Ensure that the function that you want to execute is defined in Remedy AR System server.

The following error message is displayed:

ERROR (8571): Minimum parameters mismatch in function definition and execution; minimum parameters not present for the function testfunction

You did not provide the minimum number of parameters required for the function.

While executing a function, pass the minimum number of parameters that are required by that function.

The following error message is displayed:

ERROR (8572): Parameters mismatch in function definition and execution; 
Argument 2 is defined in AR System JDBC:Generic Db Functions form but not passed in the function

The number of parameters specified while defining a function in the Remedy AR System server differs from the number of parameters passed at the time of actual execution of that function.

While executing a function, pass the exact number of parameters that are required by that function.

The following error message is displayed:

ERROR (8573): Parameters type mismatch in function definition and execution; 
Argument 2  passed to function testfunction have dataType [CHAR] , which is not compatible with function argument type defined in AR System JDBC:Generic Db Functions Form [Integer]

The data type of the parameters of a function defined in the Remedy AR System server do not match the data types of the parameters passed at the time of actual execution of that function.While executing a function, pass the parameters having the same data type as the function definition in Remedy AR System server. For example, if a function defined in Remedy AR System server requires a STRING type of parameter, ensure that while executing that function, you are passing a parameter of type STRING.
Was this page helpful? Yes No Submitting... Thank you

Comments