topic Re: batch file got stuck while running qlikview documents in QlikView

batch file got stuck while running qlikview documents

jeevays7 — Thu, 28 Dec 2017 07:00:25 GMT

Hi all,

I have Five qlikview documents and I am running those application using batch file.

Some times, after the 4th application run successfully, the next application is not initiated to run.

the batch file got stuck(showing the 4th application in comment prompt) in the 4th application only. it does not initiate 5th application.

the log file of the 4th application also has no Errors.

What s the problem? how can i identify the problem?

Re: batch file got stuck while running qlikview documents

pradosh_thakur — Thu, 28 Dec 2017 07:13:25 GMT

It used to work fine and now the issue started or it never goes to 5th file?

can you post the code?

Re: batch file got stuck while running qlikview documents

jeevays7 — Thu, 28 Dec 2017 07:37:26 GMT

Hi,

The issue i got some times only, not always. It goes 5th comment if i run again.

Re: batch file got stuck while running qlikview documents

pradosh_thakur — Thu, 28 Dec 2017 07:52:42 GMT

can you post the code ?

Re: batch file got stuck while running qlikview documents

jeevays7 — Thu, 28 Dec 2017 08:10:16 GMT

Hi,

Sorry, i cant able to paste the code. it is a big application. Can you suggest what is the problem might be?

Re: batch file got stuck while running qlikview documents

marcus_sommer — Thu, 28 Dec 2017 09:56:25 GMT

I think the variety of what could be going temporary wrong is quite big but I assume that it's caused by some kind of conflicting between this process and another processes.

For example that any other process tried to access any used file/folder which are read, used or stored at this moment - this could be other users or tasks or any security routine or any OS process like windows shadow copies and so on.

Batch-routins are usually not very robust against any kind of disturbances and fail therefore easily. You could try to find any hint within the various windows log-files, especially the event-log but if you don't find there a clue you would need to go further with a process-monitoring which isn't really trivial.

Even if you find the cause it doesn't meant that you could just fix and/or bypass it - it could be also possible that you need a different approach to execute your tasks maybe by implementing some more or less expensive error-routines and/or even a second tasks-line which checks the first and restarted them if they failed.

- Marcus

Re: batch file got stuck while running qlikview documents

PrashantSangle — Thu, 28 Dec 2017 10:28:00 GMT

did you try to execute your 4 application manually???

You are not getting any error in error log because that application is not yet closed. It is still open in backend.

Modify your batch script as below.

"C:\Program Files\QlikView\Qv.exe" /nosecurity /r Your qvw application path

IF %ERRORLEVEL% NEQ 0 (

exit /b 1

)

and In application set errormode=0;

So that if there is any error in you application batch will close that application and run next application.

Regards,

Prashant Sangle

Re: batch file got stuck while running qlikview documents

PrashantSangle — Thu, 28 Dec 2017 10:30:15 GMT

Whenever you think batch file stuck then open task manager and check that which file open in back end??

Re: batch file got stuck while running qlikview documents

jeevays7 — Thu, 28 Dec 2017 10:47:41 GMT

Yes, You are correct. There is no error is log file, then why it is still open in back end?

I don't have any error, then why i have to do the above script in batch file .?

Re: batch file got stuck while running qlikview documents

jeevays7 — Thu, 28 Dec 2017 10:48:33 GMT

Thank you marcus.

Re: batch file got stuck while running qlikview documents

Anil_Babu_Samineni — Thu, 28 Dec 2017 10:49:35 GMT

The same way, Even it should work

"C:/Program files/Qlikview/qv.exe" /R "D:/A.Qvw" : eof : insert

Re: batch file got stuck while running qlikview documents

jeevays7 — Thu, 28 Dec 2017 10:53:49 GMT

Can you explain the above code? what is eof : insert ??

Re: batch file got stuck while running qlikview documents

PrashantSangle — Thu, 28 Dec 2017 10:56:27 GMT

did you get any error while you execute that file manually???

Re: batch file got stuck while running qlikview documents

Anil_Babu_Samineni — Thu, 28 Dec 2017 10:57:33 GMT

Sure, The function EOF is same for all. So, In your case how you done the script that is main important. So, When i look you thread opened seems this should work.

EOF is initiated here batch file - Where does GOTO :EOF return to? - Stack Overflow

"C:/Program files/Qlikview/qv.exe" /R "D:/A.Qvw" : eof : insert

"C:/Program files/Qlikview/qv.exe" /R "D:/B.Qvw" : eof : insert

"C:/Program files/Qlikview/qv.exe" /R "D:/C.Qvw" : eof : insert

"C:/Program files/Qlikview/qv.exe" /R "D:/D.Qvw" : eof : insert

"C:/Program files/Qlikview/qv.exe" /R "D:/E.Qvw" : eof : insert

"C:/Program files/Qlikview/qv.exe" /R "D:/A.Qvw"

IF %ERRORLEVEL% NEQ 0 (

exit /b 1

)

"C:/Program files/Qlikview/qv.exe" /R "D:/B.Qvw"

IF %ERRORLEVEL% NEQ 0 (

exit /b 1

)

"C:/Program files/Qlikview/qv.exe" /R "D:/C.Qvw"

IF %ERRORLEVEL% NEQ 0 (

exit /b 1

)

"C:/Program files/Qlikview/qv.exe" /R "D:/D.Qvw"

IF %ERRORLEVEL% NEQ 0 (

exit /b 1

)

"C:/Program files/Qlikview/qv.exe" /R "D:/E.Qvw"

Re: batch file got stuck while running qlikview documents

jeevays7 — Thu, 28 Dec 2017 11:04:11 GMT

Thank you anil babu.

Re: batch file got stuck while running qlikview documents

Anil_Babu_Samineni — Thu, 28 Dec 2017 11:14:52 GMT

If you solve your issue, I would ask you to close this thread by flag "Correct Answer" and proper helpful if helps

Re: batch file got stuck while running qlikview documents

jeevays7 — Thu, 28 Dec 2017 11:41:28 GMT

Hi Prashant,

i did not get any error while execute the application manually.

Re: batch file got stuck while running qlikview documents

PrashantSangle — Thu, 28 Dec 2017 11:52:37 GMT

are you able to save that application after sucessfull reload?

do you have any hidden sheet or object in your application?

Remove them from application. and try.

Regards,

Re: batch file got stuck while running qlikview documents

jeevays7 — Thu, 28 Dec 2017 12:21:14 GMT

Hi Prasant,

I have used many hidden objects. those object will display based on any selection.

Why i have to remove? i cant remove because that is the requirement.

I can able to save the application manually. but it is not saved when using batch file i think.