We're using an Oracle database and are regularly seeing the ORA-01795 error shown in JasperReports Server logs.
The error is produced by a delete statement from the JIAccessEvent table, using the IN operator with an extremely long list of variables.
Oracle has a limitation of 1000 bind variables per statement.
I believe this is a bug, but the TIBCO support rep that landed my case believes otherwise. Since this is a documented fact, I believe it is up to TIBCO to generate valid SQL for every database they support, not up to Oracle to support unlimited number of bind variables.
I believe everyone that runs on Oracle would benefit from this "enhancement".
Components | JasperReports Server |