Problem fetching from FRED

For notifying us of what you believe are bugs or errors in EViews.
Please ensure your copy of EViews is up-to-date before posting.

Moderators: EViews Gareth, EViews Moderator

ghammond
Posts: 7
Joined: Fri Jun 08, 2018 10:32 am

Problem fetching from FRED

Postby ghammond » Wed Jul 13, 2022 8:37 am

Hi,

I'm having trouble fetching data from FRED (using a program). I get the error message:

Database Error: FRED library error: 'Error HRESULT E_FAIL has been returned from a call to a COM component.' in "FETCH PAYEMS USMINE USCONS MANEMP USTPU USINFO USFIRE USPBS USEHS USLAH USSERV USGOVT" on line 719.

This seems to be happening for all series I'm trying to fetch from FRED.

Could you please have a look asap?

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13294
Joined: Tue Sep 16, 2008 5:38 pm

Re: Problem fetching from FRED

Postby EViews Gareth » Wed Jul 13, 2022 8:45 am

What's the version and build date of your copy of EViews?
Follow us on Twitter @IHSEViews

ghammond
Posts: 7
Joined: Fri Jun 08, 2018 10:32 am

Re: Problem fetching from FRED

Postby ghammond » Thu Jul 14, 2022 1:27 pm

Hi Gareth, it's Eviews12, July 12, 2022 build

EViews Katerina
Posts: 51
Joined: Thu Jun 25, 2015 9:54 am

Re: Problem fetching from FRED

Postby EViews Katerina » Thu Jul 14, 2022 4:09 pm

Can you send us the lines of your program fetching from FRED database?
Latest EViews patch (July 12)) has no updates for Fred database.
Are you using more than one version of EViews?

ghammond
Posts: 7
Joined: Fri Jun 08, 2018 10:32 am

Re: Problem fetching from FRED

Postby ghammond » Fri Jul 15, 2022 7:16 am

Seems to be working now, thanks.

I'm running one version of Eviews, Eviews12.

Here's an example of the fetch code in Eviews:
dbopen fred
fetch CPIAUCSL CPIAUCNS CPILFESL CPILFENS CPIUFDSL CPIUFDNS CPIENGSL CPIENGNS CUSR0000SAC CUUR0000SAC CUSR0000SAH1 CUUR0000SAH1 CUSR0000SAS CUUR0000SAS CPIFABNS CPIFABSL CPITRNNS CPITRNSL CPIMEDNS CPIMEDSL CUUR0000SAE1 CUSR0000SAE1 CUUR0000SETB01 CUSR0000SETB01 CUUR0000SAH1 CUSR0000SAH1 CUSR0000SAC CUSR0000SAS

ghammond
Posts: 7
Joined: Fri Jun 08, 2018 10:32 am

Re: Problem fetching from FRED

Postby ghammond » Tue Oct 04, 2022 6:59 am

Hi,
I'm still having trouble with this error throughout my program. Here's an example of the Eviews error report in the log file:

Database Error: FRED library error: 'Error HRESULT E_FAIL has been returned from a call to a COM component.' in "FETCH PAYNSA LNU03000000 LNU01000000" on line 176.

Here's the code from my program:
dbopen(t=fred, c=an)
fetch PAYNSA LNU03000000 LNU01000000

Can you help?

EViews Jason
EViews Developer
Posts: 870
Joined: Tue Sep 16, 2008 3:50 pm

Re: Problem fetching from FRED

Postby EViews Jason » Tue Oct 04, 2022 8:58 am

It sounds as though the problem comes and go. Is that correct or is the problem consistent?

ghammond
Posts: 7
Joined: Fri Jun 08, 2018 10:32 am

Re: Problem fetching from FRED

Postby ghammond » Wed Oct 05, 2022 2:02 pm

Yes, the problems do come and go. Sometimes the fetch works fine and sometimes I get the error.

EViews Jason
EViews Developer
Posts: 870
Joined: Tue Sep 16, 2008 3:50 pm

Re: Problem fetching from FRED

Postby EViews Jason » Wed Oct 12, 2022 4:41 pm

If that is the case I am pretty confident, it is an issue on FREDs end and unfortunately, there isnt much we can do about it.

adceia
Posts: 1
Joined: Wed Nov 16, 2022 2:25 pm

Re: Problem fetching from FRED

Postby adceia » Wed Nov 16, 2022 2:48 pm

I am facing the same issue as well. Getting the exact same error. Any idea if this is on the Eviews or FRED side?

paolo.zanghieri
Posts: 49
Joined: Wed Mar 05, 2014 10:52 am

Re: Problem fetching from FRED

Postby paolo.zanghieri » Fri Nov 25, 2022 10:32 am

Hi
each time I try to get data from FRED I get an error message (see pic attached). Any clue?
thanks
Attachments
Screenshot 2022-11-25 183109.png
Screenshot 2022-11-25 183109.png (21.2 KiB) Viewed 5452 times


Return to “Bug Reports”

Who is online

Users browsing this forum: No registered users and 9 guests