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 SQL Anywhere database. The ResultSet value that PowerServer 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