• State Not Answered
  • Replies 5 replies
  • Subscribers 94 subscribers
  • Views 1688 views
  • Users 0 members are here
Options
Related

Path upgrade from 8.1.3 to 8.2

M.IAM
over 2 years ago

Hello,

We are trying to upgrade from OIM 8.1.3 to 8.2.

We are using the online documentation : https://support.oneidentity.com/technical-documents/identity-manager/8.2/release-notes/6#TOPIC-1731304

When checking data consistency , we have many errors like : 

- Duplicate use of ACCProduct  

- GUID in primary key with invalid format            

- Compulsory field test           The compulsory fields for object 'CCC-T-CCC_DialogSchedule - Frequency' in table 'DialogColumn' are either empty or have too few characters.

- Compulsory field test The compulsory fields for object 'X_flux2' in table 'DialogTable' are either empty or have too few characters. 

Where the 'Repair' button is disabled.

snapshot here : www://ibb.co/MBmPz9P

And we don't know how to repair these errors. 

We are stuck around this step because the documentation states : 

' All the database tests must be successful. Correct any errors. Some consistency checks offer repair options for correcting errors. '

Another behaviour, is when i run the checks many times, i dont the the same errors. Is that normal?

Any ideas on how to fix such errors?

Many thanks

Parents Reply Children
  • 0 over 1 year ago in reply to v roggero

    <The compulsory fields for object> this part is easy.

    For e.g. in my case 

    The compulsory fields for object 'CCC-T-Trace - EventSubClass' in table 'DialogColumn' are either empty or have too few characters.

     So I went to DialogColumn Table, searched for EventSubClass column of Trace Table, and updated the mandatory fields which were not updated or empty and that fixed this consistency.

    For this GUID in primary key with invalid format errors - 

    1. execute this SELECT NEWID() in SSMS or SQL of Object Browser and you will get the new GUID and then copy that and update in the affected objects.

    2. For the Custom SQL Query script, you may need to contact OneIM Support they will provide based on the type of error.