Forum Discussion
Refresh Failure
Hi Anonymous
Could you have a look at your ODBC conneciton if there is an option to specify how long the timeout value is?
Also if you can make sure that your PostgreSQL is not slow in returning the query.
And finally to make sure that there are enough resources on your gateway to process the data quickly enough.
Hi GilbertQ
The refresh started to work again, and I still can't understand what was the reason for not working. I've edited one of my data source files and republished it (went to Settings -> Current File Privacy, and ticked Ignore the Privacy Levels option; I've also set 'Support row reduction clauses' to 'LIMIT and OFFSET' in the data source settings). Then I've published the file and it refreshed successfully.
However, I did nothing to my other data sources, which are basically the same and created only because there are several separate reports, while an ODBC data source can only be used by one report.
So I don't know why all started working...
I couldn't figure out if there is an option to set the timeout value.
My queries aren't slow.
Talking about the gateway resources - could you tell me how to check this?