topic General Script Error in QlikView

General Script Error

Fri, 06 Nov 2009 20:06:52 GMT

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

General Script Error

Anonymous — Fri, 06 Nov 2009 20:30:55 GMT

The most often "general script error" - incorrect use of "group by". Can you post the part of script that generates the error?

General Script Error

Fri, 06 Nov 2009 20:49:30 GMT

Hi Michael,

Thanks for the reply ... please see the whole script below ... in debug the animation goes right to the end and says Script Finished ... so I am not sure what is erroring. Just to confirm ... no Synthetic Keys are created either.


 SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;-$#,##0.00';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY ';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=BirchMdfReportingDev;Data Source=wok-bi-data-02;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=WOK-BI-WKST-119;Use Encryption for Data=False;Tag with column collation when possible=False];
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptAccount;
//SQL SELECT *
//FROM BirchMdfReportingDev.dbo.RptAccountFunding;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptActivity;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptActivityAudience;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptActivityCode;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptActivityCodeROI;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptActivityCustomer;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptActivitySoftware;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptActivitySolution;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptActivityVertical;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptAudience;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptClaim;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptCountriesArea;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptCurrency;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptCustomer;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptFund;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptObjective;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptROI;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptROIDescription;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptSLA;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptSoftware;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptSolution;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptState;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptStatusCode;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptUsage;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptUser;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptUserAccountSecurity;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptVertical;
SQL SELECT *
FROM BirchMdfReportingDev.dbo.RptXRate;

General Script Error

prieper — Fri, 06 Nov 2009 22:18:12 GMT

Did you try to switch the log-option to OFF?
After a crash or after having killed the application, it can be that the logfile is still blocked and trying to create a new one then fails with such error-message.

HTH
Peter

General Script Error

Fri, 06 Nov 2009 22:30:50 GMT

Hi Peter.

Just given that a try and still not loading ... I have been through and built it up table by table by commenting and uncommenting and it appears to be failing on 9 tables with no commonality as to why they might fail. Have you come across something like that before?

Thanks

Lee

General Script Error

prieper — Fri, 06 Nov 2009 22:52:34 GMT

Have only couple of guesses:

load only under debug 10 records each - check again for synthetic keys.
load tables one by one (probably also in debug) and see where the error incurs
in the faulty table please check for "strange" fieldnames or contents
does it always happen on the same table? if you change the order of loading?
do you have the rights to read in the database?

Peter

General Script Error

Sat, 07 Nov 2009 01:37:46 GMT

Hi Peter,

Still no luck but thank you for you suggestions ... I have full rights, changed the load order, reduced the data load ... the fields are all pretty standard e.g. ObjectiveDescription the various field types match e.g nvarchars etc. Really stumped now.

Cheers

Lee

General Script Error

Sat, 07 Nov 2009 01:58:39 GMT

do you have any section access/section application statements in a hidden script? any form of security within the document?

General Script Error

Sat, 07 Nov 2009 08:15:35 GMT

Hi,

Have you used a Store to create a QVD at the end ?

Have you tried to remove some SQL SELECT statments and do it step-by-step ?

General Script Error

Mon, 09 Nov 2009 15:12:18 GMT

Hi,

Thanks for reply Naveen.

I do but I had commented them out until this is fixed. A real head scrambler this one!

Cheers

Lee

General Script Error

Mon, 09 Nov 2009 15:16:35 GMT

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

General Script Error

Mon, 09 Nov 2009 17:21:27 GMT

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.

General Script Error

Mon, 09 Nov 2009 17:34:29 GMT

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

General Script Error

Mon, 09 Nov 2009 19:48:42 GMT

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.

General Script Error

Mon, 09 Nov 2009 21:13:56 GMT

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

General Script Error

Anonymous — Sat, 14 Nov 2009 03:39:55 GMT

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.

General Script Error

Fri, 24 Sep 2010 09:18:11 GMT

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

General Script Error

Thu, 24 Feb 2011 16:29:56 GMT

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?

Re: General Script Error

Anonymous — Tue, 12 Sep 2017 09:38:31 GMT

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