Fix zero id record error

Transcript

Hello, everyone. In this video, we will discuss the resolve for missing zero ID record error in Adobe Campaign. When running an upgrade on an instance, you might encounter a warning as shown stating that zero ID record is missing from the schemas. The reason for this could be someone firing a SQL query directly to delete all records from the table. Instead of using the update data activity. To restore the zero ID record, you need to find out all integer columns in the schema and create an insert query with zero populated in all those columns. You will have to create a SQL script in the script section of Explorer or use a SQL code activity to do this. To create a SQL script using Explorer, to create a SQL script using Explorer, open Adobe Campaign, classic console, and navigate to SQL scripts from the left panel and click on create new icon at the top right corner. Enter a name and label for the script and write an insert query with zero populated in all the integer columns. Please note that this query depends on the structure of the schema and will vary for each schema. Now click on save. Right click on the script and click on execute the script from the actions menu. Another method to resolve the issue is to use the SQL code activity. To do this open workflows from the left panel and click on create new workflow from the top right corner. Enter the label and description of the workflow and click on save. Now open this newly created workflow and click on actions. From the actions menu, drag and drop SQL code to the workspace. Now go to flow control and similarly drag and drop end as shown. Click on SQL code and write the insert query in the space provided. Once done, click on okay. At last, click on start icon to execute the query. You can use any of the two methods discussed to resolve the issue. Thank you for watching this video. -