Schema Differences were found error during project version upgrade in ALM?
| ♥ 0 |
Hello, We have the following: When upgrading projects, the projects we’re unable to upgrade from v12.5 to v15.01 as we are getting this error: Schema differences were found. We ran the repair and it still didn’t fix the issue.
We are unsure how to proceed with this as the repair didn’t fix it. Thanks in advance, HomerJ
Marked as spam
|
||||||||||||||||||||
Posted by |
Private answer
Hello HomerJ, Not all errors and issue can be fixed by the repair tool. Generally when you run the maintenance verfiy tool, it will report if it found errors and if those errors will be corrected by the repair tool or will require manual intervention to repair. This must be the case with your issue that the tool cant repair the issue and it must be manually repaired. First I would recommend that appropriate backups are taken and in place before attempting any change of the schema as a precaution. For your issue the reported error from the file is as follows: the table: VER_CTRL has column VC_OBJECT_TYPE set to decimal currently when integer value is expected. In order to correct this you will need to have your DBA change the default setting from its current state of decimal to the expected value of integer (int). This will fix this schema error but you will need to see what the other 4 projects are reporting and adjust the schemas manually as you have with this one.
Hope this helps, Dan Marked as spam
 Posted by Dan (Questions: 0, Answers: 770) Answered on October 26, 2020 11:33 am
|