[GNC] quotes - internal server error

[John Ralls]

I'm guess then that the problem is somewhere in your perl http stack. Unless you're comfortable with perl development the simplest thing to try next is to uninstall perl and re-run the "Install Online Quotes Tool" in the GnuCash folder of the Start Menu.

Regards,
John Ralls


> On Apr 28, 2018, at 12:28 PM, Anne Bartley <ambartley at sympatico.ca> wrote:
> 
> Yes, it did include the listing of modules. I assumed the information of interest was the version code so I didn't include the rest. 
> 
> Anne
> 
> -----Original Message-----
> From: John Ralls [mailto:jralls at ceridwen.us] 
> Sent: Saturday, Apr 28, 2018 3:12 PM
> To: Anne Bartley
> Cc: gnucash-user at gnucash.org
> Subject: Re: [GNC] quotes - internal server error
> 
> Hmm, something I missed from your first post: You said that "The reply to [perl gnc-fq-check] is 1.47".
> It should return 
> ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" "asx" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual" "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse" "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe" "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts")
> 
> Did it, and you just elided the rest, or did it not return the listing of the modules?
> 
> Regards,
> John Ralls
> 
> 
> 
>> On Apr 28, 2018, at 8:28 AM, Anne Bartley <ambartley at sympatico.ca> wrote:
>> 
>> I tried the URL  and got good data going back to early December. I had already done something similar which suggested to me that the problem isn’t at Alphavantage.
>> 
>> I tried gnc-fq-update and got this reponse:
>> Database was generated on Sat, 18 Apr 2018 14:48:16 GMT
>> Date::Manip is up to date (6.61).
>> Finance::Quote is up to date (1.47).
>> 
>> I appreciate your help. I hope you’ll have another suggestion.
>> 
>> Anne
>> 
>> From: John Ralls [mailto:jralls at ceridwen.us] 
>> Sent: Saturday, Apr 28, 2018 11:12 AM
>> To: Anne Bartley
>> Cc: gnucash Users-List
>> Subject: Re: [GNC] quotes - internal server error
>> 
>> Please remember to copy the list on all replies.
>> 
>> I tried munging my key and found that alphavantage didn’t seem to care, so that’s probably not a source of the problem.
>> 
>> You could try the URL
>> https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&outputsize=compact&datatype=json&apikey=XXXXXXXXXXXXXXX&symbol=JNJ
>> 
>> In your browser, replacing XXXXXXXXXXXXXXX with your API key. You should get a several-mont JSON dump of JNJ price history.
>> 
>> If that works then I’d suspect that something is wrong with the networking setup in your perl installation. Running gnc-fq-update might help.
>> 
>> Regards,
>> John Ralls
>> 
>>> On Apr 28, 2018, at 7:49 AM, Anne Bartley <ambartley at sympatico.ca> wrote:
>>> 
>>> Thanks for the reply.
>>> 
>>> I just tried again and it didn't work.
>>> 
>>> I've been trying this for two weeks. There hasn't been much complaint so there must be something wrong with my system but I can't figure out what.
>>> 
>>> One possible source of error is the API key but if I try to get a new one from Alphavantage it tells me that I already have one and gives me the one that I'm using so it can't be wrong.
>>> 
>>> Is there something else I can do?
>>> 
>>> Thank you.
>>> 
>>> Anne
>>> 
>>> 
>>> -----Original Message-----
>>> From: John Ralls [mailto:jralls at ceridwen.us] 
>>> Sent: Saturday, Apr 28, 2018 10:32 AM
>>> To: Anne Bartley
>>> Cc: gnucash-user at gnucash.org
>>> Subject: Re: [GNC] quotes - internal server error
>>> 
>>> 
>>> 
>>> 
>>> On Apr 26, 2018, at 6:49 PM, Anne Bartley <ambartley at sympatico.ca> wrote:
>>> 
>>> The last online quote I have is on April 11. A few days later, they stopped
>>> working, The message is always "Unable to retrieve quotes for these items:
>>> ."
>>> 
>>> 
>>> 
>>> I tried updating to F::Q 1.47 and gnucash 2.6.21.  I found the new online
>>> quote entry in preferences and set it to my alphavantage API key but it
>>> still didn't work. After much digging around, here's what I came with to
>>> try:
>>> 
>>> 
>>> 
>>> In a cmd window on Windows 10:
>>> 
>>> 
>>> 
>>> cd ..\..\Program Files (x86)\gnucash\bin
>>> 
>>> set ALPHAVANTAGE_API_KEY=[my api key]
>>> 
>>> perl gnc-fq-dump -v alphavantage JNJ
>>> 
>>> 
>>> 
>>> There's nothing useful in what comes back. The errormsg is "Internal Server
>>> Error"
>>> 
>>> 
>>> 
>>> I've done the following:
>>> 
>>> perl gnc-fq-check
>>> 
>>> perl -v
>>> 
>>> 
>>> 
>>> The reply to the first is 1.47. The reply to the second is "This is perl 5,
>>> version 26, subversion 1. 
>>> 
>>> 
>>> 
>>> Can someone give me some advice on how to get quotes working again?
>>> 
>>> 
>>> “Internal server error” usually means that the server you’re trying to connect to--i.e. alphavantage--had a problem with the request. It worked for me just now, so try again.
>>> 
>>> Regards,
>>> John Ralls
>>> 
>>> 
>>> ---
>>> This email has been checked for viruses by AVG.
>>> http://www.avg.com
>>> 
>> 
>> 
>> 
>> Virus-free. www.avg.com
>