CA Service Management

Updating the version from 14.1 to 17.1, running the direct setup, gives database update error. Follows file with error. Can someone help?

Lrralves 

Which specific products are sharing the MDB?

Paul, 

In this installation I am not sharing the CMDB with any other application.

Lrralves 

As indicated by Chi_Chen , please check the MDB table ca_agent to see if it has object_uuid as primary FK. If not, you can manually make it primary FK and upgrade again.

Paul,

I checked the ca_agent table and actually the object_uuid is not a primary key. I'll try to make the corrections.

Thanks

Paul,

Chi's suggestion worked.

Thaks,

IfLeonio, please check the mdb table ca_agent to see if it has object_uuid as primary FK. If not, you can manually make it primary FK and upgrade again. Thanks _Chi

Chi,

I made object_uuid primary key of ca_agent table, the update worked.

Thanks.

Leonio, cool. That was what the error message said/lol. Regards _Chi

Lrralves 

Did the information provided by Chi_Chen help solve the 14.1->17.1 upgrade issue?