Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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?

1 Reply
sbaldwin
Contributor III

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.

Community Browser