topic Re: Oracle Database Views in QlikView

Oracle Database Views

MK_QSL — Mon, 30 Jun 2014 13:31:45 GMT

I am trying to load 150+ oracle views to generate QVDs.

But due to not having access of some views, I am getting insufficient privileges….

Is there any ways that even though above error, the script will keep running and I would have list of all views which having insufficient privileges errors?

Re: Oracle Database Views

SunilChauhan — Mon, 30 Jun 2014 13:34:05 GMT

no you can't . you need to have access ateast read only to run those views.

hope this helps

Re: Oracle Database Views

quwok — Mon, 30 Jun 2014 13:55:47 GMT

Try adding the following to the top of your load script

Set ErrorMode=0;

This will tell QlikView to ignore errors and continue processing the script.

Re: Oracle Database Views

SunilChauhan — Mon, 30 Jun 2014 14:04:20 GMT

i am agree with him

errormode=0 means it will not give errror on any error occurance in script;

but it also mean that error code data will not be available .

i thing it fit to your requirement.

Re: Oracle Database Views

MK_QSL — Mon, 30 Jun 2014 14:09:29 GMT

I am currently running with Set ErrorMode = 0.

Let some other GURUs to reply...