How to consistently access eplusout.sql

asked 2023-12-12 12:04:02 -0500

jlorrey
31 ●1 ●2

updated 2023-12-19 10:40:22 -0500

Aaron Boranian

13830 ●76 ●24 http://bigladdersoftware.com/

I'm using an analysis finalization script to try to save my OS server job's eplusout.sql files to cloud storage. For each datapoint, the script gets the datapoint.zip, extracts the files of interest (eplusout.sql & a few others) and saves them to my cloud storage location.

The problem I'm running into is that the eplusout.sql files don't get consistently saved to the datapoint zip files. Based on https://unmethours.com/question/26789..., it seems there is a size limit above which they will not get included in the datapoint.zip.

Is there a way to disable this size limit, or access the eplusout.sql file outside of the datapoint.zip?

Thanks!

answered 2023-12-13 02:27:08 -0500

antonszilasi
1523 ●1 ●5 ●12

updated 2023-12-19 02:39:04 -0500

Hello,

I'm just wondering why are you trying to save these sql files from the datapoint.zip, I assume that you are doing this from the OpenStudio server console?

You can access the sql files directly in the data point run directory by using a datapoint finalization script. You can set this up with PAT and then SSH into the docker container running the datapoints to test the finalization script.

You could write some code which puts these .sql into a AWS s3 bucket. This worked well for me but I was doing it for smaller files.

The eplusout.sql can be very large, so it maybe cleaner to write a measure that queries the .sql files for the info that you need and then puts this into S3 somewhere.

EDIT: I've attached an example pushtos3.rb script https://drive.google.com/file/d/16POb... in google drive here where I put something in a S3 bucket through the script

edit flag offensive delete link

Comments

Hi & thanks for your response!

I did originally try using a datapoint finalization script to save the datapoint results, but didn't have much luck. Would you be willing to share a code snippet of how you directly accessed the result files in your datapoint finalization script?

Agreed that writing a measure to query the sql for the specific info we need would often be a better approach, and I will look into that as well.

Thanks!

jlorrey ( 2023-12-15 10:52:56 -0500 )edit

I just attached an example script