is there any option like : repctl exportrepository all, so all tasks exported in separate json files

[selvakumars]

is there any option like : repctl exportrepository all, so all tasks exported in separate json files

I understood, 

repctl -d <"...Attunity\Replicate\data"> exportrepository <------ This will export all tasks in single json file

repctl -d <"...\data"> exportrepository exportrepository task=<"taskname"> <--- will export a single task in a single json

Is there any option like:

repctl -d <"...\data"> exportrepository all  <<<<<< something like this, which will export all tasks but in separate individual json files?

Kindly advise

with regards,

Selvakumar S

[Michael_Litz]

Hi @selvakumars ,

No there is no option in replicate do do that sort of export.

Thanks,
Michael

[selvakumars]

Thanks Michale

[selvakumars]

Now I tried an alternative way:

repctl exportrepository  <<<<< this generated all tasks in my test Qlik MS-server, but in a single Json file

Then I tried to create a .bat file listing all the tasks to be exported like:

repctl -d <"...Attunity\Replicate\data"> exportrepository task=<"task_1">

repctl -d <"...Attunity\Replicate\data"> exportrepository task=<"task_2">

.......

....
repctl -d <"...Attunity\Replicate\data"> exportrepository task=<"task_n">

But then I noticed, the "repctl exportrepository" command had created a single json export with only 30 tasks, but I totally have 79 tasks when I check from QEM (Qlik Enterprise Manager) for my Server "Test Orcl Source"

Then I tried to execute the export for one of the missed task like:

repctl -d <"...Attunity\Replicate\data"> exportrepository task=<"task_missed_task">

[exportrepository command] Failed
Cannot load replication definition. (exit status 1020500)
Object type: TASK, Object name: <"task_missed_task"> not found. (exit status 1020500)

But I do see this on QEM, why is repctl is unable to find this task in the same server?  Any advise please

[DesmondWOO]

Hi @selvakumars ,

If you export all tasks, i.e. repctl exportrepository, can you find the missing task information?

Regards,
Desmond

[selvakumars]

No Desmond, 
if I execute "repctl exportrepository", I see the single json file "...\imports\Replication_Definition.json" generated with 30 tasks only.

Then when I check for the same server "Test Orcl Source" in QEM (Qlik Enterprise Manager), I see 79 tasks.

Then I tried, may be something went wrong with "repctl exportrepository" and tried exporting one of the missed task with the below command:

repctl -d <"...Attunity\Replicate\data"> exportrepository task=<"task_missed_task">

[exportrepository command] Failed
Cannot load replication definition. (exit status 1020500)
Object type: TASK, Object name: <"task_missed_task"> not found. (exit status 1020500)

But, you can see it fails with exist status 1020500, it appears repctl is unable to find my task, but in reality, this same task is found on QEM.

Why is repctl is unable to find this task in the same server?  Is my doubt now

Is there any command like "repctl listtask", just to cross verify if repctl is able to list all the tasks in this server "Test Orcl Source"?

[john_wang]

Hello @selvakumars ,

The command "repctl exportrepository" works for me in my labs and it exported 326 tasks from my Replicate Server. 

Certainly you may list your available tasks by command:

repctl gettasklist %

A sample output like:

C:\Program Files\Attunity\Replicate\bin>repctl gettasklist %
command gettasklist response:
{
  "task_desc_list": [{
    "name": "AIS-to-CSV",
    "source_name": "AIS-ODBC-DISAM",
    "target_names": ["CSV-tgt"]
  }, {
    "name": "AIS-to-HDP",
    "description": "VSAM OFF driver ODBC Source to\nHortonworks",
    "source_name": "AIS-VSAMOFF-AR-ODBC",
    "target_names": ["HDP-Hortonworks26-tgt"]
  }, {
    "name": "AIS_Disam-to-HDP",
    "source_name": "AIS-DISAM-AR-ODBC",
    "target_names": ["HDP-Hortonworks26-tgt__Special"]
  }, {
    "name": "AS400-to-Kafka",
    "source_name": "AS400-Native-src",
    "target_names": ["kafka-tgt"]
  }, {

... ...

Hope this helps.

John.

[selvakumars]

Thank you John Wang,
yes, "repctl gettasklist %" this command provides me the list of 30 tasks in this server.

But when I login to Qlik EM, I see 79 tasks, so 20 tasks are in stopped state and remaining 59 tasks are running.
I am not sure why repctl is not able to see the complete list.

[john_wang]

Hello @selvakumars ,

We need additional information to understand the issue. I'd like to suggest you opening a support ticket and attach the "repctl exportrepository" result, our support team will be more than happy to trace the issue deeper.

BTW, "repctl gettasklist %" means "repctl gettasklist all" where "%" is the wildcard. If you need a json file for each task separately, then you need to compose a script file to do it.

Regards,

John.

[Heinvandenheuvel]

Occam's razor says that you used a stale replicate data directory with REPCTL, failing to specify the actual directory with the -d option.

To create individual taks JSON's is a SMOP either from export-all and parsing the json, or maybe easier with a gettasklist driven loop.

Hein.