Troubleshooting database functions defined in AR System Server for use in Freehand SQL
This topic describes how to troubleshoot some of the issues related to Freehand SQL.
Issue symptom | Issue scope | Resolution |
|---|---|---|
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 AR System server. | Ensure that the function that you want to execute is defined in 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; | The number of parameters specified while defining a function in the 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; | The data type of the parameters of a function defined in the 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 AR System server. For example, if a function defined in AR System server requires a STRING type of parameter, ensure that while executing that function, you are passing a parameter of type STRING. |