topic Re: Reload Runs in Desktop But Fails in Server...!! in QlikView

Reload Runs in Desktop But Fails in Server...!!

Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Reload Runs in Desktop But Fails in Server...!!

Wed, 20 Feb 2013 11:31:19 GMT

Please check whether your service account is having all the access.

Re: Reload Runs in Desktop But Fails in Server...!!

Wed, 20 Feb 2013 11:38:13 GMT

Sampath,

Can you please tell me what do you mean by service account ?

Thanks,

-Khaled

Re: Reload Runs in Desktop But Fails in Server...!!

Bill_Britt — Wed, 20 Feb 2013 13:08:09 GMT

Is the DSN a user DSN or a System DSN?

Bill

Re: Reload Runs in Desktop But Fails in Server...!!

Wed, 20 Feb 2013 13:11:30 GMT

Sampath,

The issue was with the DSN. Changed the User DSN to System DSN and it worked!

Thanks,

-Khaled.

Re: Reload Runs in Desktop But Fails in Server...!!

Wed, 20 Feb 2013 13:12:22 GMT

Bill,

Changing it to System DSN fixed the problem.

Thank you.

-Khaled.

Re: Reload Runs in Desktop But Fails in Server...!!

erichshiino — Wed, 20 Feb 2013 13:49:57 GMT

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

Re: Reload Runs in Desktop But Fails in Server...!!

Wed, 20 Feb 2013 13:51:51 GMT

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.