topic Re: Data is not getting pull from RedShift in QlikView

Data is not getting pull from RedShift

Karim_Khan — Wed, 25 Nov 2015 10:07:26 GMT

Hi Team,

I have made the ODBC connection with RedShift but data is not getting pull.its showing only in connected state.

Regards,

Karim Khan

Re: Data is not getting pull from RedShift

marcus_sommer — Wed, 25 Nov 2015 11:25:52 GMT

I would it interpret that the database didn't response in those from you expected time-frame and there are different reasons possible. For example the query is quite big or queries gets queued or the database responsed no error-message and qv simply waits and waits ...

I suggest that you for testings reduced the query to a few record or choose another table to find out if it in general worked or not.

- Marcus

Re: Data is not getting pull from RedShift

Karim_Khan — Wed, 25 Nov 2015 12:17:04 GMT

Hi Marcus,

I have limited the rows to 10 only.But then also the same issue.

Regards,

Karim Khan

Re: Data is not getting pull from RedShift

marcus_sommer — Wed, 25 Nov 2015 12:56:05 GMT

It seems that there is any error but you didn't receive a response for this. You could try to get more informations if you enabled load-logging and/or ErrorMode: Error Handling in Qlikview but I think you will need to ask the database-admin for help.

- Marcus