Schema Error

[Former Member]

I did QA refresh from the production copy, but unfortunaely the STM tool did not convert all the schema for all the objects. We were able to convert all the objects but one of the primary key is still left.

When i try the command

alter schema cmq transfer cmp.PK__sap_tr_eventclas__557F246A

i get an error 'Cannot transfer an object that is owned by a parent object."

Can someone please advice me ?

[Former Member]

Basically it is no good idea to convert the objects manually. But you could try this:

Get the parent object for the PK:

use <SID>
go
select * from sys.objects where object_id = 
(select parent_object_id from sys.objects where name = 'PK__sap_tr_eventclas__557F246A')

Most likely it is sap_tr_eventclas. Then transfer the parent object:

alter schema cmq transfer cmp.sap_tr_eventclas

The PK should be transfered with the parent object.