Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
It has been brought to my attention that when a report is refreshed in QlikView Enterprise the userid and password is encrypted but when it is run from the command line using qv.exe /r the userid and password are not encrypted. QlikView Version 8.20.5415.2. Anyway to supress it?
manual refresh using QlikView Enterprise
2/2/2010 8:13:24 PM: Execution started.
2/2/2010 8:13:24 PM: QlikView Version:8.20.5415.2
2/2/2010 8:13:24 PM: 0007 SET ThousandSep=','
2/2/2010 8:13:24 PM: 0008 SET DecimalSep='.'
2/2/2010 8:13:24 PM: 0009 SET MoneyThousandSep=','
2/2/2010 8:13:24 PM: 0010 SET MoneyDecimalSep='.'
2/2/2010 8:13:24 PM: 0011 SET MoneyFormat='$#,##0.00;($#,##0.00)'
2/2/2010 8:13:24 PM: 0012 SET TimeFormat='h:mm:ss TT'
2/2/2010 8:13:24 PM: 0013 SET DateFormat='M/D/YYYY'
2/2/2010 8:13:24 PM: 0014 SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'
2/2/2010 8:13:24 PM: 0015 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'
2/2/2010 8:13:24 PM: 0016 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'
2/2/2010 8:13:24 PM: 0035 ODBC CONNECT TO [QLIKVIEW-smit;DBQ=SMIT ] (XUserId is LXXBQWFNMDbeGZFMZF, XPassword is ZNXEQWFNMDbeGZFMIA)
with QV.exe /R
2/2/2010 8:19:16 PM: Execution started.
2/2/2010 8:19:16 PM: QlikView Version:8.20.5415.2
2/2/2010 8:19:16 PM: 0007 SET ThousandSep=','
2/2/2010 8:19:16 PM: 0008 SET DecimalSep='.'
2/2/2010 8:19:16 PM: 0009 SET MoneyThousandSep=','
2/2/2010 8:19:16 PM: 0010 SET MoneyDecimalSep='.'
2/2/2010 8:19:16 PM: 0011 SET MoneyFormat='$#,##0.00;($#,##0.00)'
2/2/2010 8:19:16 PM: 0012 SET TimeFormat='h:mm:ss TT'
2/2/2010 8:19:16 PM: 0013 SET DateFormat='M/D/YYYY'
2/2/2010 8:19:16 PM: 0014 SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'
2/2/2010 8:19:16 PM: 0015 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'
2/2/2010 8:19:16 PM: 0016 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'
2/2/2010 8:19:16 PM: 0019 ODBC CONNECT TO [Web SQL] (UserId is 'mary', Password is 'lamb')
Do you have checkbox "Scramble Connect User Credentials" on under User Preferences?
You must login as the batch user you are running qv.exe / r under and make sure that checkbox is on for the user.
Hope this helps.