This documentation supports the 19.02 version of Remedy IT Service Management Suite.

To view the latest version, select the version from the Product version menu.

Troubleshooting Freehand SQL issues

Function not defined in AR System server

Issue symptoms

If you execute a function that is not defined in Remedy AR System, then you get the following error message:

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

Issue workaround

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

Minimum number of parameters not provided during execution

Issue symptoms

At the time of executing a function, if you do not provide the minimum number of parameters that are required for the function, you get the following error message:

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

Issue workaround

While executing a function, pass the minimum number of parameters that are required by that function. For example, if a function defined in Remedy AR System requires minimum two parameters, ensure that while executing that function, you are passing minimum two parameters.

Mismatch in number of parameters defined in AR System JDBC :Generic Db Functions form and function execution

Issue symptoms

If the number of parameters specified during defining a function in AR System Server differs from the number of parameters passed at the time of actual execution of that function, you get the following error message:

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

Issue workaround

While executing a function, pass the exact number of parameters that are required by that function. For example, if a function defined in Remedy AR System requires three parameters, ensure that while executing that function, you are passing three parameters.

Mismatch in type of parameters defined in AR System JDBC :Generic Db Functions form and function execution

Issue symptoms

If the data types of the parameters of a function defined in AR System Server do not match the data types of the parameters passed to a function at the time of execution, you get the following error message: 

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]

Issue workaround

While executing a function, pass the parameters having the same data types as the function definition in AR System. For example, if a function defined in Remedy AR System 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