Campaign Classic - Missing Zero ID Record
Description
Environment
- Campaign Classic
- Campaign
Issues/Symptoms
Prior to a build upgrade, when running an upgrade Pre-Check in a Campaign instance, we are seeing a warning:
------- 0 id record is missing from the following schemas
+++++++++++ Contact Consultant : Fix and regenerate specified schemas.
_____ | schema
| nms:recipient
| cus:xxxxx
| cus:xxxxx
| cus:xxxxx
| cus:xxxxx
Questions:
- Public understanding is that the zero ID record auto-generated and required when schemas are linked. How would someone intentionally or inadvertently delete this record?
- Once the zero ID record has been deleted, what is the recommended approach to restoring it? A direct SQL command?
Resolution
- Public understanding is that the zero ID record auto-generated and required when schemas are linked. How would someone intentionally or inadvertently delete this record? Someone fired a SQL directly to delete all records from the table (instead of using the Update data activity)
- Once the zero ID record has been deleted, what is the recommended approach to restoring it? A direct SQL command? Find out all integer columns in the schema and create an INSERT query with 0 populated for all those columns. This should recreate the 0 record. You will have to create a SQL script in the script section of Explorer in Campaign or use a SQL code activity in a workflow to be able to do this.