Set Data Model Properties to Prevent Memory Errors

You can use the data model properties to help prevent memory errors in your system.

You can set the Query Time Out, Enable SQL Pruning, and Skip Unused Dataset Query properties at the data model level.

Only an administrator can set the Enable Data Model scalable mode and DB fetch size runtime properties for all data models.

Query Time Out

The Query Time Out property specifies the time limit in seconds within which the database must execute SQL statements for scheduled reports.

The default value of SQL query timeout for scheduled reports is 600 seconds. You specify the time limit on the data model. By increasing the number of seconds, you risk getting stuck threads in the Oracle WebLogic Server. Don't raise the value unless all other optimizations and alternatives have been utilized.

Queries that can't execute in less than 600 seconds aren't well optimized. Ask your DBA or performance expert to analyze and fine-tune the query. Increase the number of seconds only after attempting optimizations of the query.

Enable SQL Pruning

The SQL pruning property specifies whether to fetch only the columns that are used in the report layout/template.

Set the Enable SQL Pruning property to On in the Data Model Properties page to enhance performance by allowing the system to fetch only the columns used in the report layout or template. The system won't fetch columns that are defined in the query but not used in the report. This property doesn't alter the WHERE clause but instead wraps the entire SQL query with the columns specified in the layout.

If you enabled SQL pruning, you can use the Skip Unused Dataset Query property to skip the execution of unused datasets in a layout.

DB Fetch Size

The DB Fetch Size runtime property specifies the number of rows of data that are fetched from the database at one time.

An administrator can set the DB fetch size runtime property for all data models. A large number reduces the number of calls to the database but consumes more memory for storing more rows of data. Set the Enable Auto DB fetch size mode property to true to allow the system to calculate the optimal fetch size at runtime.

Scalable Mode

The scalable mode property in data model specifies whether to use the temp file system to generate data.

Administrator can set the Enable Data Model scalable mode runtime property for all data models.

If you select Enable Data Model scalable mode, Publisher uses the temp file system to generate data, and the data processor uses the least amount of memory.