{"action":"created","issue":{"url":"https://api.github.com/repos/googleads/aw-reporting/issues/254","repository_url":"https://api.github.com/repos/googleads/aw-reporting","labels_url":"https://api.github.com/repos/googleads/aw-reporting/issues/254/labels{/name}","comments_url":"https://api.github.com/repos/googleads/aw-reporting/issues/254/comments","events_url":"https://api.github.com/repos/googleads/aw-reporting/issues/254/events","html_url":"https://github.com/googleads/aw-reporting/issues/254","id":177153331,"number":254,"title":"Error when using QualityScore in KeywordPerformanceReport","user":{"login":"Timmeh74","id":8416683,"avatar_url":"https://avatars.githubusercontent.com/u/8416683?v=3","gravatar_id":"","url":"https://api.github.com/users/Timmeh74","html_url":"https://github.com/Timmeh74","followers_url":"https://api.github.com/users/Timmeh74/followers","following_url":"https://api.github.com/users/Timmeh74/following{/other_user}","gists_url":"https://api.github.com/users/Timmeh74/gists{/gist_id}","starred_url":"https://api.github.com/users/Timmeh74/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Timmeh74/subscriptions","organizations_url":"https://api.github.com/users/Timmeh74/orgs","repos_url":"https://api.github.com/users/Timmeh74/repos","events_url":"https://api.github.com/users/Timmeh74/events{/privacy}","received_events_url":"https://api.github.com/users/Timmeh74/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-09-15T11:34:59Z","updated_at":"2016-09-16T15:34:21Z","closed_at":null,"body":"Hi!\r\n\r\nWhile running the latest AwReporting version (API v201607) for the first time, we received the following error repeatedly on the KeywordPerformanceReport:\r\n\r\n```\r\nError Parsing column # 1 with contents:  --\r\nError Parsing PropertyDescriptor: java.beans.PropertyDescriptor[name=qualityScore; propertyType=class java.lang.Long; readMethod=public java.lang.Long com.google.api.ads.adwords.awreporting.model.entities.ReportKeywords.getQualityScore(); writeMethod=public void com.google.api.ads.adwords.awreporting.model.entities.ReportKeywords.setQualityScore(java.lang.Long)]\r\n[15 Sep 2016 12:19:24,393-RunnableProcessorOnFile:ERROR:pool-2-thread-13] Error processing file: /tmp/reportDownload-KEYWORDS_PERFORMANCE_REPORT-9372911668-7168491296421712872.report.gunzip\r\n2016-09-15 12:19:24,393 [ERROR|com.google.api.ads.adwords.awreporting.processors.onfile.RunnableProcessorOnFile|RunnableProcessorOnFile] Error processing file: /tmp/reportDownload-KEYWORDS_PERFORMANCE_REPORT-9372911668-7168491296421712872.report.gunzip\r\njava.lang.RuntimeException: java.lang.RuntimeException: java.lang.NumberFormatException: Zero length string\r\n        at com.google.api.ads.adwords.awreporting.model.util.CsvParserIterator.computeNext(CsvParserIterator.java:60)\r\n        at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:143)\r\n        at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:138)\r\n        at com.google.api.ads.adwords.awreporting.processors.onfile.RunnableProcessorOnFile.run(RunnableProcessorOnFile.java:124)\r\n        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)\r\n        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)\r\n        at java.lang.Thread.run(Thread.java:745)\r\nCaused by: java.lang.RuntimeException: java.lang.NumberFormatException: Zero length string\r\n        at com.google.api.ads.adwords.awreporting.model.util.ModifiedCsvToBean.processLine(ModifiedCsvToBean.java:125)\r\n        at com.google.api.ads.adwords.awreporting.model.util.CsvParserIterator.computeNext(CsvParserIterator.java:55)\r\n        ... 6 more\r\nCaused by: java.lang.NumberFormatException: Zero length string\r\n        at java.lang.Long.decode(Long.java:630)\r\n        at com.sun.beans.editors.LongEditor.setAsText(LongEditor.java:45)\r\n        at au.com.bytecode.opencsv.bean.CsvToBean.convertValue(CsvToBean.java:82)\r\n        at com.google.api.ads.adwords.awreporting.model.util.ModifiedCsvToBean.processLine(ModifiedCsvToBean.java:105)\r\n        ... 7 more\r\n```\r\n\r\nThe properties file part for the report looks like this:\r\n\r\n`KEYWORDS_PERFORMANCE_REPORT=ExternalCustomerId,Date,AccountDescriptiveName,Cost,Clicks,Impressions,Conversions,ConversionsManyPerClick,Ctr,AverageCpm,AverageCpc,AveragePosition,AccountCurrencyCode,Id,QualityScore,KeywordMatchType,Criteria,CriteriaDestinationUrl,AdGroupId,CampaignId,Status,IsNegative,Labels`\r\n\r\nAs the error is in reference to the **QualityScore**, I removed that field from the properties and was able to run the report again without any problems. This might be related to the newly added \"--\" value for the QS introduced in v201607.\r\n\r\nWe currently don't use QualityScore, so we can do without it for now, but it would be good if this could be resolved. Thanks!\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/googleads/aw-reporting/issues/comments/247632259","html_url":"https://github.com/googleads/aw-reporting/issues/254#issuecomment-247632259","issue_url":"https://api.github.com/repos/googleads/aw-reporting/issues/254","id":247632259,"user":{"login":"praflo","id":7632854,"avatar_url":"https://avatars.githubusercontent.com/u/7632854?v=3","gravatar_id":"","url":"https://api.github.com/users/praflo","html_url":"https://github.com/praflo","followers_url":"https://api.github.com/users/praflo/followers","following_url":"https://api.github.com/users/praflo/following{/other_user}","gists_url":"https://api.github.com/users/praflo/gists{/gist_id}","starred_url":"https://api.github.com/users/praflo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/praflo/subscriptions","organizations_url":"https://api.github.com/users/praflo/orgs","repos_url":"https://api.github.com/users/praflo/repos","events_url":"https://api.github.com/users/praflo/events{/privacy}","received_events_url":"https://api.github.com/users/praflo/received_events","type":"User","site_admin":false},"created_at":"2016-09-16T15:34:21Z","updated_at":"2016-09-16T15:34:21Z","body":"I have the same issue. This error seems to generate from this change: \r\nhttp://googleadsdeveloper.blogspot.it/2016/08/changes-to-quality-score-in-adwords.html\r\n\r\nAs a result, the downloaded file may contain lines like this:\r\n\r\n> Keyword ID,Quality score,Ad relevance,Landing page experience\r\n> 1234567890, --,Not applicable,Not applicable,Not applicable\r\n\r\nI think that those \"--\" are generating the error.\r\n\r\nHow to fix this?\r\n\r\nWe do use QS and we need it.\r\nA quick patch would be more than welcome.\r\n"}}
{"actor":{"display_login":"praflo"}}