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


About WEAP

Home
Why WEAP?
Features
What's New?
Sample Screens
Demonstration
Publications
History and Credits

Using WEAP
Download
Licensing
User Guide
Tutorial
Videos (YouTube)

User Forum
Discussions
Members List
Edit Profile

Additional Support
Training
University Courses
Collaboration

About Us
SEI-US Water Resources Program
Please Contact Us

LEAP
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: 10256 times
Hello,

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?


Thanks,
Kasra
Mr. Jack Sieber

Subject: Re: Temporary table resource limit error   
Posted: 4/16/2018 Viewed: 10228 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.

Jack
Mr. Kasra Keshavarz

Subject: Re: Temporary table resource limit error   
Posted: 5/4/2018 Viewed: 10178 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.


Kasra
Mr. Jack Sieber

Subject: Re: Temporary table resource limit error   
Posted: 5/8/2018 Viewed: 10167 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"

Jack
Topic "Temporary table resource limit error"