Database migration to Oracle (unique constraint violated)

[alex_lu]

Hi guys,

I've used oracle sql developer to migrate from MySql 5.5 to Oracle 11g. Migration completed without errors.

However I've got this error when I start Alfresco. I'm on Alfresco 4.1.3 ent.

Please see error log. Sry I'm using remote client and cannot copy in text format. I took screenshots.

https://www.dropbox.com/s/i8gklagol0mw5xx/0.png
https://www.dropbox.com/s/a910inqz17vgi7r/1.png

Thanks

[afaust]

Hello,

have you made sure the Oracle sequences have been properly updated after migration? I've had a similar problem when I migrated a MySQL client to Oracle a few years back and I forgot that Oracle sequences need to be explicitly updated. If you don't, Alfresco will attempt to create new rows starting at 1 for ID columns, i.e. the node / ACL db-IDs.

Regards
Axel

[alex_lu]

Hi AFaust,

Thanks for the tip. There were two sequences out of sync. I manually updated them and it works now. Thanks!