{"action":"created","issue":{"url":"https://api.github.com/repos/ODM2/WOFpy/issues/46","labels_url":"https://api.github.com/repos/ODM2/WOFpy/issues/46/labels{/name}","comments_url":"https://api.github.com/repos/ODM2/WOFpy/issues/46/comments","events_url":"https://api.github.com/repos/ODM2/WOFpy/issues/46/events","html_url":"https://github.com/ODM2/WOFpy/issues/46","id":119547289,"number":46,"title":"GetValuesObject request returns nothing","user":{"login":"RussNelson","id":1156994,"avatar_url":"https://avatars.githubusercontent.com/u/1156994?v=3","gravatar_id":"","url":"https://api.github.com/users/RussNelson","html_url":"https://github.com/RussNelson","followers_url":"https://api.github.com/users/RussNelson/followers","following_url":"https://api.github.com/users/RussNelson/following{/other_user}","gists_url":"https://api.github.com/users/RussNelson/gists{/gist_id}","starred_url":"https://api.github.com/users/RussNelson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RussNelson/subscriptions","organizations_url":"https://api.github.com/users/RussNelson/orgs","repos_url":"https://api.github.com/users/RussNelson/repos","events_url":"https://api.github.com/users/RussNelson/events{/privacy}","received_events_url":"https://api.github.com/users/RussNelson/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":8,"created_at":"2015-11-30T18:05:18Z","updated_at":"2015-12-01T16:19:56Z","closed_at":"2015-12-01T16:19:55Z","body":"I'm trying to download data into HydroDesktop. I get no data on a 200 response from WOFpy, which HydroDesktop thinks is an error. You'd think it would be a warning, but BUT maybe what WOFpy is returning is actually an invalid response?\r\n\r\nI figured out how to get sqlalchemy to log its SQL transactions. You have to add the following line:\r\n  logging.getLogger('sqlalchemy.engine').setLevel(logging.DEBUG)\r\nright after the call to logging.basicConfig\r\n\r\nHaving done so, I see that WOFpy is searching for the site, which it finds (REON:Esperance), then it searches for the variable, which it finds (REON:temperature). And then it doesn't make any more SQL queries, but instead immediately returns no values. It's as if WOFpy is encountering some problem and giving up before doing a query on DataValues, but it's not throwing an error. You can see that the return value on the POST is 200.\r\n\r\nThe Spyne debugging output isn't all that useful. Maybe we need a higher level of tracing, like at the WSGI level?\r\n\r\n[current.txt](https://github.com/ODM2/WOFpy/files/47594/current.txt)\r\n"},"comment":{"url":"https://api.github.com/repos/ODM2/WOFpy/issues/comments/161019331","html_url":"https://github.com/ODM2/WOFpy/issues/46#issuecomment-161019331","issue_url":"https://api.github.com/repos/ODM2/WOFpy/issues/46","id":161019331,"user":{"login":"RussNelson","id":1156994,"avatar_url":"https://avatars.githubusercontent.com/u/1156994?v=3","gravatar_id":"","url":"https://api.github.com/users/RussNelson","html_url":"https://github.com/RussNelson","followers_url":"https://api.github.com/users/RussNelson/followers","following_url":"https://api.github.com/users/RussNelson/following{/other_user}","gists_url":"https://api.github.com/users/RussNelson/gists{/gist_id}","starred_url":"https://api.github.com/users/RussNelson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RussNelson/subscriptions","organizations_url":"https://api.github.com/users/RussNelson/orgs","repos_url":"https://api.github.com/users/RussNelson/repos","events_url":"https://api.github.com/users/RussNelson/events{/privacy}","received_events_url":"https://api.github.com/users/RussNelson/received_events","type":"User","site_admin":false},"created_at":"2015-12-01T16:19:55Z","updated_at":"2015-12-01T16:19:55Z","body":"Progress!!! It's now doing the database queries necessary to get data, and it's logging that it's getting the data, but it's crashing. I'll close this one and start a new issue with the new details. Well done!"}}