Nested reports over 50 rows do not display

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