Tracing a possible error in a SQL OLE DB connection
I have a Qlikview report that returns the required data using my personal credentials. When I use group credentials through a Reload job, the report takes just as long to run, but no data is returned. Since the report works when run locally, I suspect there's something wrong with the group credentials, but no errors are returned. Is there a data file or a log file created when the job is run that I could review for errors?
Re: Tracing a possible error in a SQL OLE DB connection
yes from in the document goto document properties->general there is a checkbox called generate logfile, this will output a text file in the same location and with the same name as your qvw (but with .log extension) that can help you see what is going on.