topic Re: Copying data from one server to another in QlikView

Copying data from one server to another

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Copying data from one server to another

krishnacbe — Thu, 22 Dec 2016 20:04:15 GMT

Hi,

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

Re: Copying data from one server to another

Anonymous — Thu, 22 Dec 2016 21:30:52 GMT

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.

Re: Copying data from one server to another

vishsaggi — Thu, 22 Dec 2016 21:39:09 GMT

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

Re: Copying data from one server to another

Anonymous — Thu, 22 Dec 2016 22:22:29 GMT

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

Re: Copying data from one server to another

vishsaggi — Fri, 23 Dec 2016 00:47:40 GMT

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

Re: Copying data from one server to another

Anonymous — Fri, 23 Dec 2016 14:24:00 GMT

Yes Vishwarath, it's checked

Re: Copying data from one server to another

Anonymous — Fri, 23 Dec 2016 14:33:53 GMT

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.

Re: Copying data from one server to another

krishnacbe — Fri, 23 Dec 2016 16:06:51 GMT

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.

Re: Copying data from one server to another

Anonymous — Mon, 26 Dec 2016 15:48:11 GMT

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