Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

stuwannop
Contributor II

Auto Reload Error

Hi Guys

I'm relatively new to Qlikview and I've installed Enterprise Server and Publisher and successfully loaded reports so they can be viewed through i.e. I am now having a problem with the auto reload schedule. I can set up the schedule fine and it will try to run the script but every time it fails, citing Error Count = 3. I have created a log from the qvd and it says there is a general script error.

07/02/2012 18:00:02:      Execution started.

07/02/2012 18:00:02:      QlikView Version:9.00.7808.9

07/02/2012 18:00:02: 0002  SET ThousandSep=','

07/02/2012 18:00:02: 0003  SET DecimalSep='.'

07/02/2012 18:00:02: 0004  SET MoneyThousandSep=','

07/02/2012 18:00:02: 0005  SET MoneyDecimalSep='.'

07/02/2012 18:00:02: 0006  SET MoneyFormat='£#,##0.00;-£#,##0.00'

07/02/2012 18:00:02: 0007  SET TimeFormat='hh:mm:ss'

07/02/2012 18:00:02: 0008  SET DateFormat='DD/MM/YYYY'

07/02/2012 18:00:02: 0009  SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'

07/02/2012 18:00:02: 0010  SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

07/02/2012 18:00:02: 0011  SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

07/02/2012 18:00:02: 0013  OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=CRM2011Live;Data Source=crm-sql;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=4996-CUSTSVC;Use Encryption for Data=False;Tag with column collation when possible=False]

07/02/2012 18:00:02:       Error: Unknown statement

07/02/2012 18:00:02:       General Script Error

07/02/2012 18:00:02:       Execution Failed

07/02/2012 18:00:02:      Execution finished.

It runs fine using Qlikview desktop, just won't work when I schedule a reload. Any ideas? It's driving me mad! I am using QV10 Desktop to develop and the Server build is 9.00.7808.9

Thanks in advance

Stu

1 Solution

Accepted Solutions
stuwannop
Contributor II

Auto Reload Error

Jerry

I think I've figured out what it was.

The problem was a connection string in my script which I had set to force 32 bit:

//OLEDB CONNECT32 TO [Provider=SQLOL.......

As the server is a 64 bit operating system I changed the connections to read:

OLEDB CONNECT TO [Provider=SQLOL........"

and it works! Seems that's the answer.

Much appreciated for replying and taking a look though - it prompted me to comment everything out and look line by line.

Stu

3 Replies
jerrysvensson
Valued Contributor II

Auto Reload Error

Hi

What is the unknown statement? Can you give us the scriptlines following the ODBC connection?

You are running Integrated Security, has the service user access to the database?

stuwannop
Contributor II

Auto Reload Error

HI Jerry

Thanks for your reply.

I am using integrated security and access is fine - I tested using a blank QV report with just a connection and basic table in it and it ran. I've commented out all the script on the report I am having issues with (although there are several) and I am gradually adding the scripts back in chunk by chunk so I can hopefully identify the bit it doesn't like, I will post the script that is flagging up the error shortly.

Thanks

Stu

stuwannop
Contributor II

Auto Reload Error

Jerry

I think I've figured out what it was.

The problem was a connection string in my script which I had set to force 32 bit:

//OLEDB CONNECT32 TO [Provider=SQLOL.......

As the server is a 64 bit operating system I changed the connections to read:

OLEDB CONNECT TO [Provider=SQLOL........"

and it works! Seems that's the answer.

Much appreciated for replying and taking a look though - it prompted me to comment everything out and look line by line.

Stu

Community Browser