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

Stay ahead of what's shaping modern marketing. Subscribe to the CMO Mandate for sharp perspectives on AI, strategy and what's next.

linkedin-400.pngFollow Customer Intelligence 360 on LinkedIn for insights, success stories, and practical tips to help you modernize your marketing stack.

Leader Spring 2026.png

Want to review SAS CI360? G2 is offering a gift card or charitable donation to One Tree Planted for each accepted review. Use this link to opt out of receiving anything of value for your review.

 

SAS Customer Intelligence 360

Get started with CI 360

Review CI 360 Release Notes

Open a Technical Support case

Suggest software enhancements

 

Training Resources

SAS Learning: Customer Intelligence​

Access free tutorials

Refer to documentation

Latest hot fixes

Compatibility notice re: SAS 9.4M8 (TS1M8) or later

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.

Stay ahead of what's shaping modern marketing. Subscribe to the CMO Mandate for sharp perspectives on AI, strategy and what's next.

linkedin-400.pngFollow Customer Intelligence 360 on LinkedIn for insights, success stories, and practical tips to help you modernize your marketing stack.

Leader Spring 2026.png

Want to review SAS CI360? G2 is offering a gift card or charitable donation to One Tree Planted for each accepted review. Use this link to opt out of receiving anything of value for your review.

 

SAS Customer Intelligence 360

Get started with CI 360

Review CI 360 Release Notes

Open a Technical Support case

Suggest software enhancements

 

Training Resources

SAS Learning: Customer Intelligence​

Access free tutorials

Refer to documentation

Latest hot fixes

Compatibility notice re: SAS 9.4M8 (TS1M8) or later

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