Fetching Multiple Series from EIA Online DB

[jaylamb20]

Hello,

I'm having an issue accessing data from the EIA database through EViews. I'm hoping you can replicate it on your end and recommend solutions.

Consider the following short program:

Code: Select all

'Create workfile wfcreate(wf=TEMP, page=DATA_A) a 1990 2020 pagecreate(DATA_Q) q 1990 2020 pagecreate(DATA_M) m 1990 2020 'Fetch fuel price data from EIA for %freq A Q M pageselect DATA_{%freq} fetch(d=EIA) STEO.WTIPUUS.{%freq} STEO.NGHHMCF.{%freq} STEO.NGHHUUS.{%freq} STEO.BREPUUS.{%freq} next

The performance of this program changes every time I run it in EViews. Each time I run it, it breaks at a different point (i.e. on a different series), and gives an error message in the form of "Database Error: data values provided for object...are not in a supported format". I encourage you to try running my short program again 4-5 times and observe the point at which the fetch() command throws an error.

Any thoughts on what could be causing this? I'm perplexed by the fact that the code breaks at a different series in the fetch command each time I run it.

I am running EV9 Enterprise (September 14 2015 build) on Windows 7, and I have the EIA database in my registry with a valid API key.

Thanks,

-James

[EViews Jason]

I cannot replicate this bug even after running 10+ times. I am running with the latest patch, but I doubt any fixes since your build would cause this particular behavior.

Can you post screenshot of the error?

I doubt this is the problem but your example should read

Code: Select all

pagecreate(page=DATA_Q) q 1990 2020 pagecreate(page=DATA_M) m 1990 2020

[jaylamb20]

Ah, yes, that was a typo on my part. Inconsequential either way.

Here is the error message:



Image link: https://drive.google.com/file/d/0B-aPW_ ... ZSSUk/view

-James

[EViews Jason]

Can you try changing your loop to read

Code: Select all

fetch(d=EIA) STEO.WTIPUUS.{%freq} fetch(d=EIA) STEO.NGHHMCF.{%freq} fetch(d=EIA) STEO.NGHHUUS.{%freq} fetch(d=EIA) STEO.BREPUUS.{%freq}

Does this produce more consistent results (meaning does the error now happen on the same series)?

[jaylamb20]

When I run the code just as you presented, it fails every time on STEO.NGHHUUS.A.

Oddly enough, if I run the code below with explicit open() and close() commands, the programs makes it a bit farther, erroring out on STEO.BREPUUS.A and even occasionally making it to the Quarterly page before breaking.

Code: Select all

for %freq A Q M pageselect DATA_{%freq} dbopen EIA fetch(d=EIA) STEO.WTIPUUS.{%freq} fetch(d=EIA) STEO.NGHHMCF.{%freq} fetch(d=EIA) STEO.NGHHUUS.{%freq} fetch(d=EIA) STEO.BREPUUS.{%freq} close EIA next

[EViews Jason]

I have your email address and will be sending you an email shortly.

[jaylamb20]

Sounds good, thank you.

[jaylamb20]

For those of you coming to this forum from a search...Jason and I resolved the issue offline. I've been informed that the fix should be in the next EV9 patch.

-James