Adobe Campaign Recipient Table

[#1]

Hi,

Is there any way to recover recipient table in adobe campaign?

[#2 · Accepted solution]

Hi Sumit,

The question is not completely clear.

Either of the two things might have happened here.

1. You've deleted the recipient schema
2. You've deleted the underlying table.

If the table has been deleted, you can recover it from the last day's backup if you are maintaining it. In case the instance is Adobe hosted, we do take daily backups which are available for 7 days before being purged.

In case you have deleted the schema, please export the schema from another environment say the Dev instance and import it into the current affected environment. This step has to be followed if you had done customizations to factory recipient schema.

If you are using OOB version, please feel free to hit the Regenerate schema button.

Hope this helps.

Regards,
Vipul

[#3]

Hello,

If you need to force regeneration of all schema, for example to solve certain dependency problems in the reverse links, you can launch the following command from the Adobe Campaign application server:

nlserver config -postupgrade -instance:`<instance_name>' -force

You must then restart the Adobe Campaign application server and disconnect/reconnect to the client console.

[#4]

Hi Vipul,

Actually when I try to hit the Regenerate schema option I get the below error -

Can you help me with this. Thanks in Advance

Regards,

Sadaf

[#5]

Hi sadafali,

Please refer to following https://helpx.adobe.com/search.html#q=packages&t=All&sort=relevancy&f:@CommonProduct=[Campaign%20Cla...to understand more about exporting and importing packages.

Regards,
vipul

[#6]

Hi Vipul,

Could you please tell the steps of how to export schema from one instance to another? Or if there is any link describing the same could you please share.

Thanks,

Sadaf

[Acmuser]

Hi Vipul,

My recipient schema was showing error that @id (primary key) is missing. So I deleted it and tried to import it from the postgres sql table.

But it didn't work. I am new to this tool and so working on local, so no prod/dev environments are there.

For now, I have reinstalled the Adobe campaign and exported the recipient schema to avoid this hassle later.

Also, I have another question here.. In schema I can see some MD5 key being generated, but when I export the schema, it is not in the exported file. So, I am not sure if I import the exported schema then it will work. Could you please guide me on this.

Regards,

Sumit 

[Acmuser]

I have a question, if a recipient profile is accidentally deleted from Profile and Targets using the delete button towards the right hand corner, 1. Does it mean the profile is deleted completely? and 2.is there a way to recover it?