EUROSTAT database

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

farrel
Posts: 108
Joined: Thu Sep 18, 2008 11:13 pm

EUROSTAT database

Postby farrel » Wed Nov 11, 2020 2:20 am

Dear Eviews,

Look at this. Is this OK?
1. I downloaded one series from EUROSTAT SDMX database (series: "prc_hicp_midx__coicop=cp00.freq=m.geo=ea.unit=i15")
2. I saved the series in Workfile with a possibility to update it (linked the series)
3. I open WF and try to update the seris, but Eviews says the following: Database error ....


What I do wrong? The series around 300 observations only ...

Andrejs
Attachments
eurostat.PNG
eurostat.PNG (27.42 KiB) Viewed 34529 times

farrel
Posts: 108
Joined: Thu Sep 18, 2008 11:13 pm

Re: EUROSTAT database

Postby farrel » Wed Nov 11, 2020 2:28 am

I have to say, that if I update the series immediately after downloading it, with EUROSTAT SDMX database dialog window being open, the update works...

Andrejs
Attachments
eurostat2.PNG
eurostat2.PNG (33.48 KiB) Viewed 34528 times

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

Re: EUROSTAT database

Postby EViews Katerina » Thu Nov 12, 2020 10:53 am

EViews 11 patch (Nov 11 2020 build) contains the fix for this issue.

farrel
Posts: 108
Joined: Thu Sep 18, 2008 11:13 pm

Re: EUROSTAT database

Postby farrel » Fri Dec 04, 2020 1:56 am

Dear Eviews,

Have a look at another bug...

1. I fetched from EUROSTAT 3 series of GDP - Belgium (BE), Denmark (DK) and Estonia (EE). and store the workfile with links to update.
pic1.PNG
pic1.PNG (39.72 KiB) Viewed 34159 times


2. I open WF once again and try to update. Eviews updates all, but the last series in th WF - Estonia. I got message - I cannot update EE.
I click "update" on Estonia and I able to update one single series.

pic2.PNG
pic2.PNG (29.86 KiB) Viewed 34159 times


3. What I do? I delete Estonia and try to update all series once again. And I got message - I cannot udpate DK (the last series)

pic3.PNG
pic3.PNG (28.41 KiB) Viewed 34159 times


4. Conclusion - every time I want to update WF, Eviews cannot update the last series! Could you please to fix it?


Best
Andrejs

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

Re: EUROSTAT database

Postby EViews Katerina » Tue Dec 08, 2020 4:04 pm

A fix on this issue was posted on latest patch (Dec 8 2020 build)

farrel
Posts: 108
Joined: Thu Sep 18, 2008 11:13 pm

Re: EUROSTAT database

Postby farrel » Wed Dec 09, 2020 2:28 am

Thanks! Great!

farrel
Posts: 108
Joined: Thu Sep 18, 2008 11:13 pm

Re: EUROSTAT database

Postby farrel » Wed Dec 09, 2020 2:48 am

One more question.
Are there any restrictions how many series I can download per session?
Look, I tried to select all 468 variables of euro area HICP indices, but application says "no results found". It's not really true. If one selects fewer series, then I'm able to download them...
It seems that there is some sensitivity to filters or something ...

pic1.PNG
pic1.PNG (33.75 KiB) Viewed 33720 times

pic2.PNG
pic2.PNG (20.75 KiB) Viewed 33720 times

pic3.PNG
pic3.PNG (19.07 KiB) Viewed 33720 times

farrel
Posts: 108
Joined: Thu Sep 18, 2008 11:13 pm

Re: EUROSTAT database

Postby farrel » Wed Dec 09, 2020 3:21 am

One more question on a speed of data update from EUROSTAT.
The update of 100 HICP series takes about 3.5 min. Is that speed OK?
As to me, it's seems somewhat long. I try to undestand on which side might be problems - my, Eviews or EUROSTAT?!

Andrejs

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

Re: EUROSTAT database

Postby EViews Katerina » Wed Dec 09, 2020 12:51 pm

Selecting filters for all SDMX databases is very important for reducing the speed or the query and the size of the results. When filters are not selected it means we will try to fetch everything (any number of series at any time) from a dataset.
I checked your query for Eurostat for the Dataset HICP without filters and saw that the response was:
>Response too large due to client request
>Query size exceeds maximum limit (1000000 entries)
Adding filters for COICOP and GEO for the specific HICP dataset will result in less entries and EViews will display the results.

You can see the error of the query without any filter by opening browser and pasting this url :
http://ec.europa.eu/eurostat/SDMX/diss- ... hicp_midx/ )

ErikG
Posts: 78
Joined: Wed Jan 23, 2013 1:18 am

Re: EUROSTAT database

Postby ErikG » Fri Jan 29, 2021 5:47 am

Hi, fetching data from Eurostat is not working great at the moment. I guess the fault may perhaps be with Eurostat rather than Eviews.

The interactive filter list is slow and I find it difficult to make selections. Once I was able to select a series this appeared:

EurostatError.JPG
EurostatError.JPG (71.96 KiB) Viewed 30229 times


Regards,
Erik
/Eviews 12, dec 8 2020 build

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

Re: EUROSTAT database

Postby EViews Katerina » Fri Feb 05, 2021 11:29 am

Latest patch of EViews 12 (Feb 4, 2021 Build) has a fix for the issue.

ErikG
Posts: 78
Joined: Wed Jan 23, 2013 1:18 am

Re: EUROSTAT database

Postby ErikG » Thu Feb 16, 2023 6:04 am

Greetings from Sweden,

The Eurostat database is not working well with Eviews today. Opening the database and attempting to browse causes the following error with both Eviews 13 and Eviews 12:

Error.jpg
Error.jpg (12.44 KiB) Viewed 11681 times

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

Re: EUROSTAT database

Postby EViews Gareth » Thu Feb 16, 2023 6:34 am

Eurostat have discontinued the API that EViews uses. Unfortunately it will be some time before we are able to connect to Eurostat, I believe.
Follow us on Twitter @IHSEViews

ErikG
Posts: 78
Joined: Wed Jan 23, 2013 1:18 am

Re: EUROSTAT database

Postby ErikG » Thu Feb 16, 2023 7:20 am

ok thanks Gareth

ErikG
Posts: 78
Joined: Wed Jan 23, 2013 1:18 am

Re: EUROSTAT database

Postby ErikG » Wed Jun 28, 2023 5:34 am

Hi again, have you made any progress on the Eurostat API issue? Do you know if it will be possible to connect to Eurostat via Eviews sometime again this year?


Return to “Bug Reports”

Who is online

Users browsing this forum: No registered users and 14 guests