Hi All,
We are facing lot of errors migrating Service Desk from r12.5 to r12.9. We have run successfully Query( SQLCheckr12UniqueIndexes) and removes all duplicates but still We are facing errors like some columns are already built in the MDB database and Migration console tries to create same column and index for the same. We also tried to drop each column one by one after looking into the logs of migration but still its giving errors of same type
( Update sql failed:ALTER TABLE ca_company ADD tenant binary(16)
06-06,14:23:38 DEBUG - Column names in each table must be unique. Column name
'tenant' in table 'ca_company' is specified more than once. )
Do you have any idea how to remove these errors without dropping the columns which CA Service desk r12.9 DVD wants to create?
Is there any patch for the same?
Also are anyone facing same problem or running Migration DVD smoothly.