Welcome to WEAP's Website WEAP
WEAP is an initiative of the Stockholm Environment Institute.

About WEAP

What's New?
Sample Screens
History and Credits

Using WEAP
User Guide
Videos (YouTube)

User Forum
Members List
Edit Profile

Additional Support
University Courses

About Us
SEI-US Water Resources Program
Please Contact Us

Environmental News
'Subterranean estuaries' crucial to sustainable fishing and aquacultur...
Pioneering research suggests 'subterranean estuaries' may be critical in managing sustainable fishing and aquaculture --...

Chemicals from human activities in transplanted oysters far from popul...
Wastewater treatment facilities clean the water that goes down our sinks and flushes our toilets, but they do not remove...

Antarctic Circumpolar Current flows more rapidly in warm phases
Our planet's strongest ocean current, which circulates around Antarctica, plays a major role in determining the transpor...
Source: Science Daily
Interested in Energy?
Read about LEAP: SEI's software for energy planning.

Link WEAP and LEAP for combined Water-Energy planning.
Watch a video demo!

User Forum

All Topics | Topic "Temporary table resource limit error"
Log in to post new messages or reply to existing messages.
Author Message
Mr. Kasra Keshavarz

Subject: Temporary table resource limit error   
Posted: 2/20/2018 Viewed: 3757 times

I have modelled a large catchment in WEAP, however, while trying to get the "streamflow (below node or reach listed)" results an error shows up saying: "Temporary table resource limit.". How am I supposed to resolve this error?

Mr. Jack Sieber

Subject: Re: Temporary table resource limit error   
Posted: 4/16/2018 Viewed: 3729 times
Depending on the size of your model results, WEAP may have difficulty with the database query to extract the results for display. (Large models with many elements, a large number of timesteps or years, or a large number of scenarios will all contribute to the size of the results.)

If your computer has less than 8 GB of RAM (memory), please try running WEAP on a different computer with more RAM. If you do already have this much computer memory, please try reducing the size of the results to display, e.g., select only a few or just one year for display, or select only one river's nodes and reaches.

Mr. Kasra Keshavarz

Subject: Re: Temporary table resource limit error   
Posted: 5/4/2018 Viewed: 3679 times
I am using WEAP API to export the results and this is a limitation. Is there any way to force WEAP to show a portion of time-steps using API and then export it to a CSV or Excel file? Then I will be able to aggregate the result tables altogether by a manual script.

Mr. Jack Sieber

Subject: Re: Temporary table resource limit error   
Posted: 5/8/2018 Viewed: 3668 times
Yes, you can use WEAP.ResultSetting to change the years or months displayed and export to CSV, e.g.,

WEAP.ResultSetting("Year") = "2010-2012"
WEAP.ResultSetting("Month") = "1,4,7,10"
WEAP.ExportResults "Results.CSV"

Topic "Temporary table resource limit error"