While running the job in QMC it throwing file path... - Qlik Community

iahmadmca1 · ‎2017-03-28

Hi Team,

Just I want to one clarification regarding job in QMC job.when I am executing the QVW file manually it is executing successfully but while running in QMC it throwing path issue. could you please help me to do this. please find the below example for reference.

QMC Log details:

FROM

3/28/2017 12:11:19 PM: 0157 [\\qlikapp-ccc-02\QVDOCS\Data\outageFile-11-01.txt]

3/28/2017 12:11:19 PM: 0158 (txt, codepage is 1252, no labels, delimiter is ',', msq)

3/28/2017 12:11:19 PM: Error: Cannot open file '\\qlikapp-ccc-02\QVDOCS\Data\outageFile-11-01.txt' The system cannot find the path specified.

3/28/2017 12:11:19 PM: General Script Error

3/28/2017 12:11:19 PM: Execution Failed

3/28/2017 12:11:19 PM: Execution finished.

When I am executing same QVW file manually it is running successfully without any log error.

Thanks,

Irshad Ahmad

vishsaggi · ‎2017-03-28

Is this your actual source path in you qvw script? Can you share your script?

iahmadmca1 · ‎2017-03-28

sure Vishwarath,

Please find the below script which you need.

LET vSourceFiles = '\\qlikapp-ccc-02\QVDOCS\Data\';

-------------------------------------------------------------------------------------

If '$(vMode)' = 'Daily Build' then

CALL FindDiff

For vRow = 1 to NoOfRows('3')

LET vFileToLoop = Peek('filenamediff',vRow-1,'3') ;

'$(vFileToLoop)':

LOAD

//*

@1,

@2,

@3,

@4,

@5

FROM

[$(vSourceFiles)$(vFileToLoop).txt]

(txt, codepage is 1252, no labels, delimiter is ',', msq);

;

LET vFileStore = SubField('$(vFileToLoop)','.',1) &'.qvd' ;

//STORE '$(vFileToLoop)' into [$(vQVD_Extract)\$(vFileStore)] (qvd);

DROP Table '$(vFileToLoop)';

NOTE: Actually, we have two Server QA and production. I am working on QA server QVW file.The QA QVW file using one CSV file from the production server using network path.

Thanks,

Irshad Ahmad

iahmadmca1 · ‎2017-03-28

sure Vishwarath,

Please find the below script which you need.

LET vSourceFiles = '\\qlikapp-ccc-02\QVDOCS\Data\';

-------------------------------------------------------------------------------------

If '$(vMode)' = 'Daily Build' then

CALL FindDiff

For vRow = 1 to NoOfRows('3')

LET vFileToLoop = Peek('filenamediff',vRow-1,'3') ;

'$(vFileToLoop)':

LOAD

//*

@1,

@2,

@3,

@4,

@5

FROM

[$(vSourceFiles)$(vFileToLoop).txt]

(txt, codepage is 1252, no labels, delimiter is ',', msq);

;

LET vFileStore = SubField('$(vFileToLoop)','.',1) &'.qvd' ;

//STORE '$(vFileToLoop)' into [$(vQVD_Extract)\$(vFileStore)] (qvd);

DROP Table '$(vFileToLoop)';

NOTE: Actually, we have two Server QA and production. I am working on QA server QVW file.The QA QVW file using one CSV file from the production server using network path.

Thanks,

Irshad Ahmad

vishsaggi · ‎2017-03-28

Where are you using your variable vSourceFile in our script?

stabben23 · ‎2017-03-29

Hi,

the most common issue when have problem to load from QMC is authorization problem.

Make sure that the service account on QMC have read premission on the .txt files or Access to folders.

You can also try to change the servername \\qlikapp-ccc-02\QVDOCS\Data\ to an ip-adress instead, like this,

\\10.172.1.1\QVDOCS\Data\

tamilarasu · ‎2017-03-29

Hi Irshad,

Seems your QMC server is not having access to the file path \\qlikapp-ccc-02\QVDOCS\Data\. Check it once and get access if you don't have it in your QMC.

Good luck.

iahmadmca1 · ‎2017-04-02

Hi Johansson,

You are suggesting like instead of old path use IP Address for achieving this problem.

Thanks,

Irshad Ahmad

iahmadmca1 · ‎2017-04-03

Johansson,

I used the IP address instead of old path but it is throwing the same issue.

Thanks,

Irshad Ahmad

stabben23 · ‎2017-04-03

Then you have to check if the QMC user account have Access to the filepath.

While running the job in QMC it throwing file path issue.