Error when querying/fetching IHS Magellan 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

troy_walters
Posts: 20
Joined: Thu Jan 15, 2015 9:07 am

Error when querying/fetching IHS Magellan database

Postby troy_walters » Tue Apr 05, 2016 2:16 pm

I am attempting to query an IHS Magellan database. I get the following error message when doing so:

Code: Select all

Database Error: Magellan library error: '[System.
ArgumentNullException: Value cannot be null.
Parameter name: String]
   at System.Number.StringToNumber(String str,
 NumberStyles options, NumberBuffer&& number,
 NumberFormatInfo info, Boolean parseDecimal)
   at System.Numb.


This happens only sometimes, not everytime. It occurs when querying/fetching and the issue is not limited to any one particular databank. At other times I get an error message stating the the object does not exist. But when I access the Magellan api via another method (e.g. AREMOS), the object is there. Help?

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

Re: Error when querying/fetching IHS Magellan database

Postby EViews Jason » Tue Apr 05, 2016 3:23 pm

You said it was inconsistent from one databank to another, but how a particular series? For the same series, are you getting consistent behavior?

What is an example series that produces the reported error?

What is an example series that 'does not exist'?

Is this a recent phenomena or has this always been a problem?

troy_walters
Posts: 20
Joined: Thu Jan 15, 2015 9:07 am

Re: Error when querying/fetching IHS Magellan database

Postby troy_walters » Wed Apr 06, 2016 7:18 am

It also also inconsistent across series.

I am trying to reproduce the error. But today I am getting a different error at the same spot:

Code: Select all

Database Error: Magellan library error: 'Index was out of
 range. Must be non-negative and less than the size of the
 collection.
Parameter name: index' in "COPY REGCON::POIIA
 "STATERE0216"::FHFAPOIIA".


The above series POIIA in the Magellan REGCON "bank" is an example. I should point out that in that example I am using the copy command, but this problem happens during fetch and queries as well.

These errors (and similar) are relatively new. I have only encountered them over the past two weeks. Prior to that I had never seen them.

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

Re: Error when querying/fetching IHS Magellan database

Postby EViews Jason » Wed Apr 06, 2016 11:33 am

Can you post the full 'copy' command you are using?

It is strange that Magellan is returning

Code: Select all

Parameter name: index' in "COPY REGCON::POIIA
 "STATERE0216"::FHFAPOIIA".


The 'copy' portion of the command should never get sent to Magellan.

What happens when you run the below code?

Code: Select all

create u 100
fetch poiia.q
Last edited by EViews Jason on Wed Apr 06, 2016 1:41 pm, edited 1 time in total.

troy_walters
Posts: 20
Joined: Thu Jan 15, 2015 9:07 am

Re: Error when querying/fetching IHS Magellan database

Postby troy_walters » Wed Apr 06, 2016 12:37 pm

This is the copy command I am using:

Code: Select all

for %reg {%streg}
   copy regcon::poi{%reg} %new_st::fhfapoi{%reg}
next



When I run your code:

Code: Select all

create u 100
fetch poiia.q


it works ok right now, but again, I am only getting these errors sporadically, which makes it challenging to reproduce at any given moment.

Sometimes my above code runs fine. Most recently it failed again at the same place, this time with a third different error msg:

Code: Select all

Database Error: Magellan library error: 'Object reference not set to an instance of an object.' in "COPY REGCON::POICMAC "STATERE0216"::FHFAPOICMAC".

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

Re: Error when querying/fetching IHS Magellan database

Postby EViews Jason » Wed Apr 06, 2016 1:46 pm

In your example, what is statere0216? Is it an EViews database?

Also try changing your command to

Code: Select all

 copy regcon::poi{%reg} {%new_st}::fhfapoi{%reg}


Does that help?

troy_walters
Posts: 20
Joined: Thu Jan 15, 2015 9:07 am

Re: Error when querying/fetching IHS Magellan database

Postby troy_walters » Thu Apr 07, 2016 12:15 pm

It's an EViews workfile. No it's still throwing the error on that line after I make your suggested change. Except that today, rather than throwing one of the three error messages I described earlier, its just saying that the series REGCON::POIAL was not found. But I know it's there. I'm not sure at this point. Given the sporadic behavior of this error its really hard to troubleshoot.

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

Re: Error when querying/fetching IHS Magellan database

Postby EViews Jason » Wed Apr 27, 2016 7:42 am

The Magellan folks think they may have found the problem. A fix will hopefully be in place soon. We will post back with any updates.

troy_walters
Posts: 20
Joined: Thu Jan 15, 2015 9:07 am

Re: Error when querying/fetching IHS Magellan database

Postby troy_walters » Fri Apr 29, 2016 10:54 am

Great thank you!

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

Re: Error when querying/fetching IHS Magellan database

Postby EViews Jason » Fri May 13, 2016 10:54 am

We have been informed the problem have been fixed. Please report any issues.

troy_walters
Posts: 20
Joined: Thu Jan 15, 2015 9:07 am

Re: Error when querying/fetching IHS Magellan database

Postby troy_walters » Mon Jun 06, 2016 11:57 am

Thanks Jason. So far so good. I'll let you know if anything else comes up.

Y_L
Posts: 1
Joined: Wed Jan 31, 2024 11:08 am

Re: Error when querying/fetching IHS Magellan database

Postby Y_L » Wed Jan 31, 2024 11:21 am

I just got my new computer and have eviews 13 installed. I experience the same error message as
Database Error: Magellan library error: 'The underlying connection was closed: An unexpected error occurred on a receive.'. when trying to connect/fetch data from IHS Magellan databanks.

Everything seems working fine on my old computer with eviews 9

Any suggestion?

Thanks!

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

Re: Error when querying/fetching IHS Magellan database

Postby EViews Gareth » Wed Jan 31, 2024 11:39 am

Recommend contacting support for your data subscription.
Follow us on Twitter @IHSEViews


Return to “Bug Reports”

Who is online

Users browsing this forum: No registered users and 16 guests