1.
|
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"
3.
|
The query returns project request ids that are duplicate. If the rows are not deleted, the upgrade to Marketing Operations 9.1 fails.
|
Copyright IBM Corporation 2014. All Rights Reserved.
|