Hi all. I've encountered an error using the 'Preview Data' option in the script editor of Qlik Cloud. If anyone has any guidance (or an explanation as to what is happening), then I'd be hugely grateful. I have used 'Preview Data' successfully on a lot of apps, and it normally works without issue, connecting to Google BigQuery views and pulling back a small subset of data. However I have one app where 'Preview Data' fails. A 'normal' reload via the 'Load Data' option works fine, it connects to a BQ view, and returns the full set of around 13 million records. However, when I run 'Preview Data', setting it to pull back only 100 records, it consistently fails, with the error 'Internal error. (Connector error: Connector Process returned error Unavailable, details: 'Socket closed')'. All I can think is that 'Preview Data' works differently to a normal load, and perhaps this particular BQ view is more complex (or involves more fields) than those used in my other apps. Any ideas?
Hi @Ben_P : if you can reproduce this consistently, please reach out to us on a chat with all the details, so that we can investigate it. Among the other things, it would be great if you could capture the har file while reproducing the issue. Also make sure to mention this discussion.
Daniele - Principal Technical Support Engineer & SaaS Support Coordinator at Qlik If a post helps to resolve your issue, please accept it as a Solution.
does your bigQuery Views contain combination of 2 or more tables?
did you try with increase number of Limit load from 100 to 1000 or 10000??
Great dreamer's dreams never fulfilled, they are always transcended. Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Hi @Ben_P : if you can reproduce this consistently, please reach out to us on a chat with all the details, so that we can investigate it. Among the other things, it would be great if you could capture the har file while reproducing the issue. Also make sure to mention this discussion.
Daniele - Principal Technical Support Engineer & SaaS Support Coordinator at Qlik If a post helps to resolve your issue, please accept it as a Solution.
Thanks, yes, I can reproduce consistently; it happens every time. I'll raise a ticket, include the HAR file, and reference this discussion. I'll post again here if I get an explanation as to the cause.
