Schema Problems that cannot be fixed by repair tool

  • Questions
  • Schema Problems that cannot be fixed by repair tool
Question ID: 106623
1
0

When attempting to upgrade one project from ALM 11.0 to ALM 12.20, we get a failure. The failure is due to a schema error.

Schema Problems that cannot be fixed by repair tool
Describes schema problems that must be fixed in order for the Upgrade tool to run. These problems cannot be fixed by the Repair tool.

And listed is a table described as extra called TTBL_5K.
I went back to our ALM 11.0 and ran a repair and the same table shows up as a repair that cannot be fixed by the repair tool.
How do I repair this so the project can upgrade?

Marked as spam
Posted by (Questions: 104, Answers: 0)
Asked on January 27, 2016 4:38 pm
16 views
Answers (1)
0
Private answer

Hello,

That table is a temp table and a DBA can manually remove it. As you have your ALM 11.0 still working, suggest having a DBA remove the table from the database side manually then attempt to run the repair again. If good, then use this project's files to move to your ALM 12.20 and upgrade there.

Just be sure to have a backup or make a copy of the project first in ALM 11.0 before doing the manual database edit. This is for safety sake, but being it involves a temp table, it should not be an issue.

Marked as spam
Posted by (Questions: 1, Answers: 116)
Answered on January 27, 2016 4:40 pm
Thank you, will get the DBA to delete then and try again.
( at January 27, 2016 4:42 pm)