Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

qv.exe /r putting unencrypted userid and password in log file

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')

1 Reply
disqr_rm
Partner - Specialist III
Partner - Specialist III

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.