Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Copying data from one server to another

Hi Qlik Experts I have a problem.

I'm trying to copy some .qvd's from a server to another using the Execute command that calls a .bat file. If I run that

manually it works but if I use the QMC it doesn't.

-This is my command:  

EXECUTE cmd.exe /C E:\QVModels\BAT\QVReport;

-And my QVReport.bat is: 

XCOPY E:\QVModels\5_Data\*.qvd Y:\5_Data\ /y

Any idea?  Thanks!!

1 Solution

Accepted Solutions
krishnacbe
Partner - Specialist III
Partner - Specialist III

Hi,

Hope the UserID runs the Batch file doesn't have permission to execute the batch.

Go to Control Panel -> Administrative Tools -> Local Security Policy Editor

Search for the Policy "Logon as Batch" & "Logon as Service".

Add your Qlikview service account to those policies.

We are running the batch as a service from QMC. So our functional/service ID should be part of this policies.

View solution in original post

9 Replies
krishnacbe
Partner - Specialist III
Partner - Specialist III

Hi,

Does it shows some error or the files are not copied?

Anonymous
Not applicable
Author

Thanks for your response Krishnapriya !! And it doesn't show me any error, just the files aren't copied. The problem is when I use the QMC, manually it works very well.

vishsaggi
Champion III
Champion III

can you use the actual server names like

-This is my command:

EXECUTE cmd.exe /C \\yourservername1\QVModels\BAT\QVReport;

-And my QVReport.bat is:

XCOPY \\Yourservername1\QVModels\5_Data\*.qvd \\servername2\5_Data\ /y

Anonymous
Not applicable
Author

Hi Vishwarath! I already change the names as you suggested but still nothing happens . Thanks

vishsaggi
Champion III
Champion III

Did you try checking this check box in edit script? Or in User Preferences (ctrl+alt+u) -> Security Tab -> Script check

And in your .bat try using "\\Yourservername1\QVModels\5_Data\*.qvd"  "\\servername2\5_Data\" /y 

Capture.PNG

Anonymous
Not applicable
Author

Yes Vishwarath, it's checked

Anonymous
Not applicable
Author

Try logging into the server using the same AD user that the the QlikView Windows Services run under and manually run your bat file  If that fails then look at whether that AD user has the correct permissions to the folders in question.

krishnacbe
Partner - Specialist III
Partner - Specialist III

Hi,

Hope the UserID runs the Batch file doesn't have permission to execute the batch.

Go to Control Panel -> Administrative Tools -> Local Security Policy Editor

Search for the Policy "Logon as Batch" & "Logon as Service".

Add your Qlikview service account to those policies.

We are running the batch as a service from QMC. So our functional/service ID should be part of this policies.

Anonymous
Not applicable
Author

Thank you Krishnapriya!!! I added my account to the policies and it worked.Thanks again!!