Running database query for cleanup

Before you upgrade Marketing Operations, run the database query to remove duplicate project request ids, if any.

Run the query in your database and remove all the results return by this query to ensure the successful upgrade of Marketing Operations.

Complete the following steps to run the database query for cleanup:

Open your database console that has Marketing Operations system tables.

Enter the following query:

 SELECT proj_request_id, count(proj_request_id) num
 FROM uap_projects
 WHERE proj_request_id in (SELECT project_id FROM uap_projects WHERE 
state_code = 'ACCEPTED')
 group by proj_request_id
 having count(proj_request_id) > 1"

The query returns project request ids that are duplicate. If the rows are not deleted, the upgrade to Marketing Operations 9.1 fails.