Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

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

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

1 Solution

Accepted Solutions
Employee
Employee

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

Is the DSN a user DSN or a System DSN?

Bill

7 Replies
Not applicable

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

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

Not applicable

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

Sampath,

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

Thanks,

-Khaled

Employee
Employee

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

Is the DSN a user DSN or a System DSN?

Bill

Not applicable

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

Sampath,

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

Thanks,

-Khaled.

Not applicable

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

Bill,

Changing it to System DSN fixed the problem.

Thank you.

-Khaled.

erich_shiino
Honored Contributor

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

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

Not applicable

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

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.

Community Browser