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

[#1]

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?

[#2]

Is there any other suggestions from the community?

[Anil_Babu_Samineni]

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.

[#4]

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];

[Anonymous]

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);

[#6]

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

[Anil_Babu_Samineni · Accepted solution]

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 ] }

[#8]

Thanks Anil,

Its working now.

[miskin_m]

Hi

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.