An ACC update database structure error !!! | Community
Skip to main content
Level 3
February 5, 2021
Solved

An ACC update database structure error !!!

  • February 5, 2021
  • 2 replies
  • 1616 views

Hi team,

We encountered a update database structure error, please help.

When we finished the Prod environment installation, and we need to update the latest schema to database. Then we unexpectedly found that some ACC built-in schema not sync yet as below:

Once we start to run update, some error prompt, and this error seems lead us can not delete manual-added folder

This is prod environment, help is needed very much, thanks a lot

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Craig_Thonis

Hi Yuemin,


It looks like the update failed because there is a dependent object "DF_NmsPropos_ilnte_6BAEFA67".  I don't know where the object is as it looks custom but there is a dependent relationship between this object and the iinterationID which means you need to address this prior to altering the table.

Check your propositionRCP table to see if any data with this value exists and check your schema to see if there are any links/revlinks that would map back to a value like the above.

 

Regards,

Craig

2 replies

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe EmployeeAccepted solution
Adobe Employee
February 8, 2021

Hi Yuemin,


It looks like the update failed because there is a dependent object "DF_NmsPropos_ilnte_6BAEFA67".  I don't know where the object is as it looks custom but there is a dependent relationship between this object and the iinterationID which means you need to address this prior to altering the table.

Check your propositionRCP table to see if any data with this value exists and check your schema to see if there are any links/revlinks that would map back to a value like the above.

 

Regards,

Craig

Sukrity_Wadhwa
Community Manager
Community Manager
February 15, 2021
Hi @yueminspb, Were you able to resolve this query with the given solution or do you need more help here? Do let us know. Thanks!
Sukrity Wadhwa