Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Time Out Error

Status
Not open for further replies.

myrcmstr

IS-IT--Management
Feb 24, 2007
9
US
I am getting 'time out error' while running the report. How can I solve this? What are the different ways?
 
Check the project settings under governing
 
Make sure you have temp table space creation access in the database and if so, you have ENOUGH space to store it. Users in my client site have 200GB spaces and they spool out.

Try to restrict the amount of data you want to display.

Check your SQL for cross joins and make sure 'fail on cartesian join' is turned on in your VLDB.

Make sure you aren't comparing two huge fact tables.

Anyone got any other ideas?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top