BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
pcapazzi
Pyrite | Level 9

 

We copied a production diagram into a different business context on the same server the we use for testing purposes. The CAMP code was never changed and the diagram has been deleted. We would like to bring it back to change the CAMP code so that reporting based on the CDM does not show duplicate records. 

 

Thanks,

1 ACCEPTED SOLUTION

Accepted Solutions
Dmitry_Alergant
Pyrite | Level 9

Hi,

 

There is no built-in "undelete" functionality. You are supposed to implement scheduled environment backups (of metadata, content server repository, WIP etc) of a production environment.

 

So theoretically you could temporarily halt operations, revert back in time to a backup, do what you need, then go back to the present state.

 

In reality, it is much easier to just delete or fix the garbage directly in the CDM database. Campaign Code change will only require 1 or 2 simple SQL updates to CI_CAMPAIGN and to CI_CELL_PACKAGE table (that one only if you have run the campaign and stored the contact history).

 

You can also modify your reporting to exclude any data from non-production business context by referring to "Business_Context_Nm" column of the CI_Campaign table.

 

Hope if helps!

 

 

 

 

-------
Dmitriy Alergant, Tier One Analytics

View solution in original post

1 REPLY 1
Dmitry_Alergant
Pyrite | Level 9

Hi,

 

There is no built-in "undelete" functionality. You are supposed to implement scheduled environment backups (of metadata, content server repository, WIP etc) of a production environment.

 

So theoretically you could temporarily halt operations, revert back in time to a backup, do what you need, then go back to the present state.

 

In reality, it is much easier to just delete or fix the garbage directly in the CDM database. Campaign Code change will only require 1 or 2 simple SQL updates to CI_CAMPAIGN and to CI_CELL_PACKAGE table (that one only if you have run the campaign and stored the contact history).

 

You can also modify your reporting to exclude any data from non-production business context by referring to "Business_Context_Nm" column of the CI_Campaign table.

 

Hope if helps!

 

 

 

 

-------
Dmitriy Alergant, Tier One Analytics
How to improve email deliverability

SAS' Peter Ansbacher shows you how to use the dashboard in SAS Customer Intelligence 360 for better results.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 881 views
  • 1 like
  • 2 in conversation