Copying data from one server to another

[Anonymous]

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!!

[krishnacbe]

Hi,

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

[Anonymous]

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]

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]

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

[vishsaggi]

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 

[Anonymous]

Yes Vishwarath, it's checked

[Anonymous]

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 · Accepted solution]

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]

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