Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

An ACC update database structure error !!!

Avatar

Avatar
Validate 10
Level 1
yueminspb
Level 1

Likes

0 likes

Total Posts

38 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
View profile

Avatar
Validate 10
Level 1
yueminspb
Level 1

Likes

0 likes

Total Posts

38 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
View profile
yueminspb
Level 1

05-02-2021

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:

yueminspb_0-1612518707818.png

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

yueminspb_1-1612518796694.png

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Give Back 10
Employee
craigthonis
Employee

Likes

167 likes

Total Posts

258 posts

Correct Reply

152 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile

Avatar
Give Back 10
Employee
craigthonis
Employee

Likes

167 likes

Total Posts

258 posts

Correct Reply

152 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile
craigthonis
Employee

08-02-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

Answers (0)