topic Re: Database migration to Oracle (unique constraint violated) in Alfresco Archive

Database migration to Oracle (unique constraint violated)

alex_lu — Mon, 18 Mar 2013 17:23:20 GMT

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:/

Re: Database migration to Oracle (unique constraint violated)

afaust — Mon, 18 Mar 2013 22:29:02 GMT

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

Re: Database migration to Oracle (unique constraint violated)

alex_lu — Wed, 20 Mar 2013 10:54:27 GMT

Hi AFaust,

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