topic Re: Execution of script failed.Reload old Data error message for a particular user? in QlikView

Execution of script failed.Reload old Data error message for a particular user?

Tue, 21 Feb 2017 02:26:12 GMT

Hi Community Members,

I am trying to reload the data in the loader file and getting the following error message:

If other user having same permissions as me, runs the reload then it execute without any error!! Strange...(which means the script have no errors)

Can anybody suggests any possible reason for this issue?

Re: Execution of script failed.Reload old Data error message for a particular user?

Anil_Babu_Samineni — Tue, 21 Feb 2017 02:27:59 GMT

It could be issue tha paths, Can you check whether the path is existing on your server. I mena Data Source

Re: Execution of script failed.Reload old Data error message for a particular user?

Tue, 21 Feb 2017 02:31:42 GMT

Thanks Anil for reply. Could you please elaborate, which path you are talking about?

Thanks

Re: Execution of script failed.Reload old Data error message for a particular user?

Anil_Babu_Samineni — Tue, 21 Feb 2017 02:33:52 GMT

Load * From C:\Users\XYZ\Downloads\ABC.xls

I am saying check this path is valid or not which i've highlighted

Path is okay, You may share the script?

Re: Execution of script failed.Reload old Data error message for a particular user?

Tue, 21 Feb 2017 02:44:10 GMT

Thanks Anil,

Yes the path is correct, we have the loader qvw on server, when i try to reload data into the qvw, it fails and if other user logs in and try to reload then it work perfectly fine.

Re: Execution of script failed.Reload old Data error message for a particular user?

Anil_Babu_Samineni — Tue, 21 Feb 2017 02:45:51 GMT

Would you provide Log file of QVW? Document and Server Logs may be

Re: Execution of script failed.Reload old Data error message for a particular user?

Tue, 21 Feb 2017 02:59:30 GMT

Hi Anil,

I have attached the log file for both the users. Please note user1 has cancelled the task in between, as he did the reload for testing purpose only. user1 has successfully executed the task yesterday. it also works fine for Admin.

Any suggestions about it?

Thanks

Re: Execution of script failed.Reload old Data error message for a particular user?

Tue, 21 Feb 2017 03:48:59 GMT

Hi Anil,

It seems like the database connection is not working for me, may be i don't have privileges to connect to the data source as other user have.

I am using following in my script:

ODBC CONNECT TO [prdbidomain;DBQ=//biprddomain/biprddomain] (XUserId is abc, XPassword is xyz);

can you suggest any way i can check and compare my permissions with other user?

Note: I can't share whole script here because of some privacy concerns.

Thanks

Re: Execution of script failed.Reload old Data error message for a particular user?

Anil_Babu_Samineni — Tue, 21 Feb 2017 04:09:14 GMT

I've seen log files for User1 and User2

Here, The main issue is If User1 created the application then User2 need the same application. That case it won't reload due to Restriction of Privileges for User2. And, The main issue is User2 doesn't have access(May be application used for NTNAME). That case it won't help

Re: Execution of script failed.Reload old Data error message for a particular user?

Tue, 21 Feb 2017 05:30:32 GMT

Thanks Anil,

I just checked that I have the permissions to access the database, but still getting the error.

Re: Execution of script failed.Reload old Data error message for a particular user?

Tue, 21 Feb 2017 05:31:19 GMT

Is there any other suggestions from the community?

Re: Execution of script failed.Reload old Data error message for a particular user?

Anil_Babu_Samineni — Tue, 21 Feb 2017 07:14:03 GMT

Can you send the steps to follow the same. I meant how you are connecting to DB and then share Doc atleast. Because, When you say you have the access you are just fetching the data only. I am not sure, What you made over there will be correction.

Re: Execution of script failed.Reload old Data error message for a particular user?

Tue, 21 Feb 2017 07:54:31 GMT

In my Main Script

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;-$#,##0.00';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='D/MM/YYYY';

SET TimestampFormat='D/MM/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

LET vDownloadDateTime = Now();

//* Temporary:

SET vDataPath = 'MyPath';

Directory $(vDataPath);

LET vODBCDate = Date(Today()-1,'YYYY-MM-DD');

//* Perform a full reload on Saturday nights, otherwise do incremental to save time.

LET vWeekday = WEEKDAY(TODAY());

IF vWeekday = 'Sat' THEN

TRACE * Total Reload *;

SET vControlLoad = 'T';

ELSE

TRACE * Incremental Reload *;

SET vControlLoad = 'I';

ENDIF;

ODBC CONNECT TO [prdbidomian;DBQ=//biprddomain/biprddomain] (XUserId is xyz, XPassword is abc);

*************************this is where it gives error:********************************************

[Lodgement]:

LOAD *;

select * from mytable;

STORE [Lodgement] INTO $(vDataPath)\Lodge.qvd (qvd);

DROP TABLE [Lodgement];

Re: Execution of script failed.Reload old Data error message for a particular user?

Anonymous — Tue, 21 Feb 2017 08:00:21 GMT

Are you sure your userID has permission to load from the db?

Are the user name and passwords hardcoded?

ODBC CONNECT TO [prdbidomian;DBQ=//biprddomain/biprddomain] (XUserId is xyz, XPassword is abc);

Re: Execution of script failed.Reload old Data error message for a particular user?

Tue, 21 Feb 2017 08:06:04 GMT

Yes Deran it is hard coded and i have tested the connection, it works for me.

Re: Execution of script failed.Reload old Data error message for a particular user?

Anil_Babu_Samineni — Tue, 21 Feb 2017 08:11:56 GMT

Can you check this for me, I've tested this part and it's working with out any error and qvd also generated

If you want i will share QVW for you

[Lodgement]:

select * from mytable;

STORE Lodgement INTO $(vDataPath)\Lodge.qvd (qvd);

DROP TABLE Lodgement;

Note: 1) I've removed the Load Statement over here

2) I've removes Square brackets for Store and Drop Statement { [ And ] }

Re: Execution of script failed.Reload old Data error message for a particular user?

Tue, 21 Feb 2017 08:23:31 GMT

Thanks Anil,

Its working now.

Re: Execution of script failed.Reload old Data error message for a particular user?

miskin_m — Tue, 21 Feb 2017 08:26:35 GMT

Looking at you log files, I think it has nothing to do with database connection because it has loaded your first table.

The error is with loading second table. Try to comment and run by section to check where the error is.