Mail-Notification: Full Load of a single table completed

[Laurin37]

Hey guys,
I have setup a "Full Load completed" notification rule and it works fine when we do a full reload of the entire task. 
However, when I just reload a individual table in the task - no Mail is generated.  

I found this community post Full Load Completed Email Notification Issue - Qlik Community - 2449316 and tried to follow it step by step, but we can’t implement point 3 in our JSON because those entries don’t exist in our JSON.

It is also important to us that this notification applies to all tasks on our server.

Does anyone have any further suggestions on how we could implement this?

Best regards!

[john_wang]

Hello @Laurin37 ,

Since the notification was created through the GUI, you can use it as a template for TABLE_LOAD_END_TRIGGER. You can either:

• Create a new entry with the trigger type set to TABLE_LOAD_END_TRIGGER, or
• Update the existing entry by changing trigger_type  from LOAD_END_TRIGGER to TABLE_LOAD_END_TRIGGER

After making the change, import it back into the repository.

Hope this helps.

John.

[Laurin37]

Hey @john_wang,

Thanks for your reply!

The notification was created via the GUI:

But if i search in the generated JSON for "trigger_type" i can not find anything...

        "notifications":    {

        },

is empty


Best regards,
Laurin

[john_wang]

Hello @Laurin37 ,

I’m not sure how the task was exported to JSON. Please try the following:

1. Open Command Prompt as Administrator
2. Navigate to the Replicate bin directory
3. Run:

repctl exportrepository task=<taskName> include_server_settings=true

Note that exporting a task from the GUI does not include the associated server settings.

Regards,

John.

[john_wang]

Hello Laurin, @Laurin37 

I’m not sure how the task was exported to JSON. Please try the following:

1. Open Command Prompt as Administrator
2. Navigate to the Replicate bin directory
3. Run:

repctl exportrepository task=<taskName> include_server_settings=true

Note that exporting a task from the GUI does not include the associated server settings.

Regards,

John.

[Laurin37]

Hey @john_wang ,

I did 100%  as discribed in the other community post Full Load Completed Email Notification Issue - Qlik Community - 2449316 and as you discribed it in this post.

Unfortunately, this has not been as successful as hoped. As mentioned earlier, the "notifications" is empty and therefore cannot be customized as discribed.

Copied from the JSON:

 "notifications":    {

        },

Best regards,
Laurn

[john_wang]

Hello Laurn, @Laurin37 

One possible reason is that your data directory is not using the default path. In this case, please include the -d parameter, for example:

repctl -d E:\MyRep\data exportrepository task=<taskName> include_server_settings=true

where "E:\MyRep\data" is your actual data directory..

If the issue persists, you can run:

repctl exportrepository

(or include the -d parameter as above), and then review the Replication_Definition.json file to check whether any notifications are defined.

thanks,

John.

[Laurin37]

Hello @john_wang,

We followed the instructions exactly as described. However, the notifications configured in the GUI do not appear in the JSON file.

Best regards,
Laurin

[john_wang]

Hello @Laurin37 ,

Please open a support ticket and upload the above information and attachments. Our support team will assist you further with the investigation.

thanks,

John.