General Script Error

[#1]

Beyond Frustrated!

I am getting a General Script Error. The Reload has successfully fetched all lines of data from all tables and there are no sythetic keys.

Can anyone shed light on why this might be happening?

Thanks

Lee

[#2]

Hi Regis,

I have been through each SQL statement and identified the tables causing the error and we are going over them with a fine comb but can not see anything wrong with the tables.

I have not created a QVD previously ... I will give it a go. What does it do exactly and how will help with error?

Thanks

Lee

[#3]

commenting out is the problem here, take a backup of the hidden script, and remove it altogether. dont comment it out.

simply remove the hidden script, then reload the document, and then ti should work. let me know.

[#4]

Hi Naveen,

Still no luck I am afraid ... I have removed all other tabs, there are no hidden scripts just the Main tab pulling in these data sets and still the Script Error.

Quite tempted to remove QlikView and reload it onto the machine ... getting a bit desperate now!

Thanks for your tips though.

Lee

[#5]

this is very very strange...

i know this sounds stupid, but just create another document, and copy the main script onto that new one, load only one table in that new script, and dont create any hidden script there. then see what happens.

[#6]

Peter ...

You were spot on fella. We have been through and renamed various table fields etc etc. and bullseye ... script error gone.

Thanks to everyone for all their help ... learned loads in the process!

Cheers

Lee

[Anonymous]

Lee,
It's a dangerous approach to write script this way:
SELECT * FROM ...
You simply don't see what you're doing. The first step should be data model design on paper, and after that you load the data tables/fields that you need for the data model, and name your fields in a way that enforce links you need and avoid links you don't need.

[#8]

In my case the error dissapeared after I upgraded the ODBC driver from MYSQL 3.51.21.00 to MYSQL 5.01.06.00

Cheers,

Bogdan

[#9]

Hi Lee,

I am getting the same issue now. General script error!

I am trying exactly the same thing loading a MSOLAP into QlikView. The test connection is success and able to select data... but I am not able to retrieve the records. I get "script error".

My script as follows:

OLEDB CONNECT TO [Provider=MSOLAP.4;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Altius MIS Cube;Data Source=mis;Location=aclappserve1];

SQL SELECT *
FROM [Altius MIS Cube].[$Date];

When I do reload I get the Script Error.

Kindly guide me to sort this out. I am using QlikView 10 (32 bit version) and drivers with same versions.

What exactly did you do?

[Anonymous]

Hi Everyone,

I had the same error: When connecting to ODBC it gave me "General Script Error".... After an hour of research, I discovered that it is the ODBC (Impala connector) causing it. However, ODBC transferred data as usual. So everything worked as before but failing during reload task.

Installing latest driver fixed the problem, yet I still don't understand what was the issue...

Cheers