Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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. Trying again later.;
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. Trying again later.;
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. Trying again later.;
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.
First load this.
Select * from Tablename;
I don't need all the data, so i am just filtering it as it has millions of rows.
Thanks for the reply Anil.
Understand, Try this one first where you are getting reload or not? If it is, Then it should work with Where condition as well.
It was working properly before, but not sure what changed.
I did not do any change in QlikView, but it is getting failed now.
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..
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.
Check with your Salesforce team related this whether they have Tables in source?
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.