topic Re: Custom read failed in QlikView

Custom read failed

udaya_kumar — Tue, 17 Oct 2017 10:08:58 GMT

Hi,

I am executing a simple query in QlikView script by connecting it to the Salesforce.

Select * from Tablename

where Field='Status';

This is the query i have used, but it is getting failed with the following error

QVX_UNEXPECTED_END_OF_DATA: Batch was not processed, status: Failed : InternalServerError : Retried more than 15 times;

17-10-2017 9:47:00: InvalidBatch : Failed to process query: QUERY_TIMEOUT: Your query request was running for too long. Trying again later.;

17-10-2017 9:47:00: InvalidBatch : Failed to process query: QUERY_TIMEOUT: Your query request was running for too long. ...

17-10-2017 9:47:00: Error: Custom read failed

What might be the issue here?

Can someone please help me to sort out this issue?

Thanks in advance.

Re: Custom read failed

Anil_Babu_Samineni — Tue, 17 Oct 2017 10:11:34 GMT

First load this.

Select * from Tablename;

Re: Custom read failed

udaya_kumar — Tue, 17 Oct 2017 10:12:49 GMT

I don't need all the data, so i am just filtering it as it has millions of rows.

Thanks for the reply Anil.

Re: Custom read failed

Anil_Babu_Samineni — Tue, 17 Oct 2017 10:14:57 GMT

Understand, Try this one first where you are getting reload or not? If it is, Then it should work with Where condition as well.

Re: Custom read failed

udaya_kumar — Tue, 17 Oct 2017 10:17:24 GMT

It was working properly before, but not sure what changed.

I did not do any change in QlikView, but it is getting failed now.

Re: Custom read failed

Anil_Babu_Samineni — Tue, 17 Oct 2017 10:19:17 GMT

Have you tested my way? If it s loading now? I believe there is some authentication credentials changed in SAP instance which created for Qlik. Check with the team and re connect the same server using connector..

Re: Custom read failed

udaya_kumar — Tue, 17 Oct 2017 10:22:17 GMT

It failed again even without where condition.

Qlik is getting connected to Salesforce.

But other tables are working fine which are connect to same salesforce, just this table is getting failed to reload.

Re: Custom read failed

Anil_Babu_Samineni — Tue, 17 Oct 2017 10:26:09 GMT

Check with your Salesforce team related this whether they have Tables in source?

Re: Custom read failed

Peter_Cammaert — Tue, 17 Oct 2017 10:50:52 GMT

If you use the SOAP API, then you can change the Timeout value that is set in the connection string. Try to increase it. It shouldn't affect any of the working table extracts.