When retrieving data from a nested report that has more than 50 rows, an error message displays that "Failed to create SQL Statement due to java.sql.SQLException: [Sybase][ODBC Driver][Adaptive Server Anywhere] General error: Resource governor for prepared statements exceeded".
Cause: This error only occurs to the SAP ASA/SQL Anywhere database. The ResultSet value that Appeon Server returned exceeds the maximum cursor value that is default in the SAP SQL Anywhere database.
Solution:
Run the following commands to set the cursor count and statement count to no limit:
Set option public.max_cursor_count = 0 Set option public.max_statement_count = 0
