Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to reload a document using Management Console and the reload fails. The document runs fine when reloaded using QlikView Desktop with OLEDB connectivity.
The Log file reads as follows:
2/20/2013 1:47:00 PM: Execution started.
2/20/2013 1:47:00 PM: QlikView Version:11.0.11440.0
2/20/2013 1:47:00 PM: CPU Target x64
2/20/2013 1:47:00 PM: Operating System Windows Server 2008 R2 Enterprise Service Pack 1 (64 bit edition)
2/20/2013 1:47:00 PM: Wow64 mode Not using Wow64
2/20/2013 1:47:00 PM: MDAC Version 6.1.7601.17514
2/20/2013 1:47:00 PM: MDAC Full Install Version 6.1.7601.17514
2/20/2013 1:47:00 PM: PreferredCompression 2
2/20/2013 1:47:00 PM: EnableParallelReload 1
2/20/2013 1:47:00 PM: ParallelizeQvdLoads 1
2/20/2013 1:47:00 PM: AutoSaveAfterReload 0
2/20/2013 1:47:00 PM: BackupBeforeReload 0
2/20/2013 1:47:00 PM: EnableFlushLog 0
2/20/2013 1:47:00 PM: SaveInfoWhenSavingFile 0
2/20/2013 1:47:00 PM: UserLogfileCharset 0
2/20/2013 1:47:00 PM: OdbcLoginTimeout -1
2/20/2013 1:47:00 PM: OdbcConnectionTimeout -1
2/20/2013 1:47:00 PM: ScriptWantsDbWrite false
2/20/2013 1:47:00 PM: ScriptWantsExe false
2/20/2013 1:47:00 PM: LogFile CodePage Used: 1252
2/20/2013 1:47:00 PM: 0002 SET ThousandSep=','
2/20/2013 1:47:00 PM: 0003 SET DecimalSep='.'
2/20/2013 1:47:00 PM: 0004 SET MoneyThousandSep=','
2/20/2013 1:47:00 PM: 0005 SET MoneyDecimalSep='.'
2/20/2013 1:47:00 PM: 0006 SET MoneyFormat='$#,##0.00;($#,##0.00)'
2/20/2013 1:47:00 PM: 0007 SET TimeFormat='h:mm:ss TT'
2/20/2013 1:47:00 PM: 0008 SET DateFormat='M/D/YYYY'
2/20/2013 1:47:00 PM: 0009 SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'
2/20/2013 1:47:00 PM: 0010 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'
2/20/2013 1:47:00 PM: 0011 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'
2/20/2013 1:47:00 PM: 0013 set source="C:\NIC Project\QVDFiles\"
2/20/2013 1:47:00 PM: 0016 set vHol = '38722,38723'
2/20/2013 1:47:00 PM: 0019 OLEDB CONNECT32*Provider*
2/20/2013 1:47:01 PM: Error: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Login failed for user 'sa'.
2/20/2013 1:47:01 PM: General Script Error
2/20/2013 1:47:01 PM: Execution Failed
2/20/2013 1:47:01 PM: Execution finished.
If I use ODBC connectivity, the error log has the following message:
Data source name not found and no default driver specified
Can somebody tell me what could be the problem?
Thanks,
-Khaled
Is the DSN a user DSN or a System DSN?
Bill
Please check whether your service account is having all the access.
Sampath,
Can you please tell me what do you mean by service account ?
Thanks,
-Khaled
Is the DSN a user DSN or a System DSN?
Bill
Sampath,
The issue was with the DSN. Changed the User DSN to System DSN and it worked!
Thanks,
-Khaled.
Bill,
Changing it to System DSN fixed the problem.
Thank you.
-Khaled.
The service account mentioned by sampath is the account the runs the qlikview server services. Maybe there is some restrictions for this user
Is you server 64bit? what about the qv desktop? Maybe you should try to force a 32 bit ODBC connection
Regards,
Erich
Hello Erich,
Thank you for your response.
The issue is fixed now. It's a problem of selecting the correct DSN, which should've been a System DSN and not a User DSN..
Regards,
-Khaled.