topic Re: Export all tasks by command in Qlik Replicate

Export all tasks by command

FrancoHR — Thu, 06 Jul 2023 20:38:51 GMT

I am trying to extract all the replicate tasks but when I execute the command: repctl exportrepository, it generates a json of 1kb. What's wrong?

Regards,

Re: Export all tasks by command

Dineshan — Thu, 06 Jul 2023 20:42:46 GMT

Hello @FrancoHR

Where is your data directory? If it is not installed in the default location, you will need to specify it in the export command.

repctl -d /opt/attunity/replicate/data exportrepository

Thank you,

Dinesh

Re: Export all tasks by command

FrancoHR — Thu, 06 Jul 2023 20:54:05 GMT

Hello @Dineshan

Replicate installed on Windows.

My data folder is in: 'E:\Program Files\Attunity\Replicate\data'
Replicate: 'C:\Program Files\Attunity\Replicate'
the command would be? repctl -d 'E:\Program Files\Attunity\Replicate\data' exportrepository

Re: Export all tasks by command

SwathiPulagam — Thu, 06 Jul 2023 20:55:21 GMT

Hi @FrancoHR ,

That is correct.

Thanks,

Swathi

Re: Export all tasks by command

SwathiPulagam — Thu, 06 Jul 2023 20:56:31 GMT

Hi @FrancoHR ,

Here is the command if you want to include the server settings also:

repctl -d [data directory] exportrepository include_server_settings=true

Thanks,

Swathi

Re: Export all tasks by command

FrancoHR — Thu, 06 Jul 2023 20:59:09 GMT

Hello @SwathiPulagam

I ran the command and got the following error:

REPCTL initialization - failed to initialize environment (status 1000195)
[e:\jenkins_slave\workspace\Replicate-2021.5.0-Win-x64\replicate\repsrv\base\environment.c:269] (1000195) Class 'ENCRYPTION_CLASS' failed to initialize.
[e:\jenkins_slave\workspace\Replicate-2021.5.0-Win-x64\replicate\repsrv\base\encryption.c:1423] (1000195) Failed to save server password

any idea?

Re: Export all tasks by command

FrancoHR — Thu, 06 Jul 2023 21:02:53 GMT

Hello @SwathiPulagam

I ran the command and got the following error:

Re: Export all tasks by command

FrancoHR — Thu, 06 Jul 2023 21:03:37 GMT

I ran the command and got the following error:

Re: Export all tasks by command

FrancoHR — Thu, 06 Jul 2023 21:05:48 GMT

I ran the command and got the following error:

Re: Export all tasks by command

SwathiPulagam — Thu, 06 Jul 2023 21:11:07 GMT

Hi @FrancoHR ,

Ensure to run the command prompt as administrator to execute the repctl.exe.

Thanks,

Swathi

Re: Export all tasks by command

FrancoHR — Thu, 06 Jul 2023 21:15:14 GMT

I ran it as administrator:

I tried: repctl -d E:\Program Files\Attunity\Replicate\data exportrepository
Output: [Files\Attunity\Replicate\data command] Failed command Files\Attunity\Replicate\data cannot be found (exit status 20014)

Is it because of the blank space in program files?

Re: Export all tasks by command

Dana_Baldwin — Thu, 06 Jul 2023 21:18:45 GMT

Hi @FrancoHR

Yes, you need to wrap the path following -d in quotes.

Thanks,

Dana

Re: Export all tasks by command

Dineshan — Thu, 06 Jul 2023 21:19:26 GMT

Hello @FrancoHR

Please try this command.

repctl -d "E:\Program Files\Attunity\Replicate\data" exportrepository

Thank you,

Dinesh

Re: Export all tasks by command

FrancoHR — Thu, 06 Jul 2023 21:25:35 GMT

Thanks for the help!

Regards.

Re: Export all tasks by command

Kent_Feng — Fri, 07 Jul 2023 00:18:17 GMT

Hi Franco,

When you run the command repctl exportrepository, Replicate will save a json to the Replication installation folder, with the default name Replication_Definition.json. (and the default path is c:\Program Files\Attunity\Replicate\data\imports\). This json file contains all tasks definitions and also some other settings like notifications. This is the standard operation for exporting or backing up Replicate tasks.

You need to run command "repctl importRepository json_file=Replication_Definition" to import all tasks into another Replicate server or the same Replicate server. Before doing so, you can also edit the json file to remove some settings you don't need such as the notification section.