Adobe Campaign Recipient Table | Community
Skip to main content
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
vraghav
vraghavAccepted solution
Employee
Jun 3, 2017 4:42 PM UTC

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

7 replies

Level 2
Sep 27, 2019 2:37 PM UTC

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.
Translate
Jul 12, 2018 7:06 AM UTC

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

Translate
vraghav
Employee
Jul 12, 2018 5:35 AM UTC

Hi sadafali,

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

Regards,
vipul

Translate
Jul 12, 2018 5:27 AM UTC

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

Translate
New Participant
Jun 5, 2017 5:04 AM UTC

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 

Translate
New Participant
Jan 7, 2020 5:04 PM UTC
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?
Translate
vraghav
vraghavAccepted solution
Employee
Jun 3, 2017 4:42 PM UTC

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

Translate