Hi, I have a similar problem with some constraints defined for account_journal. The steps followed were similar to amaza: - Create a new database on V6 - Skipped all configurations - Installed server_migration with config base, accounting, product, stock - Skipped all configurations again, so my database is empty - connect to old database - Load configuration - Create migration scheduler (all models) and start
... and get the following error : <<<<<<<<<<<<<<<< Error! >>>>>>>>>>>>>>>> Traceback (most recent call last): File "C:\Program Files\OpenERP 6.0\Server\addons\server_migration\migration.py", line 626, in _import_data File "C:\Program Files\OpenERP 6.0\Server\addons\server_migration\migration.py", line 589, in import_model File "C:\Program Files\OpenERP 6.0\Server\addons\server_migration\migration.py", line 294, in create File "sql_db.pyo", line 78, in wrapper File "sql_db.pyo", line 131, in execute IntegrityError: IntegrityError: duplicate key value violates unique constraint "account_journal_code_company_uniq" I double checked in the old database, and there were no journals with the same code. You marked amaza's post as incomplete. What more can I tell you? -- You received this bug notification because you are a member of C2C OERPScenario, which is subscribed to OpenERP Project Group. https://bugs.launchpad.net/bugs/838012 Title: Error duplicate key Status in OpenERP Addons by Agile BG & Domsense: Incomplete Bug description: when I do schedule migration, and see the scheduled migration I've the next error <<<<<<<<<<<<<<<< Error! >>>>>>>>>>>>>>>> Traceback (most recent call last): File "C:\Archivos de programa\OpenERP 6.0\Server\addons\server_migration\migration.py", line 626, in _import_data File "C:\Archivos de programa\OpenERP 6.0\Server\addons\server_migration\migration.py", line 589, in import_model File "C:\Archivos de programa\OpenERP 6.0\Server\addons\server_migration\migration.py", line 329, in create File "osv\fields.pyo", line 644, in set File "sql_db.pyo", line 78, in wrapper File "sql_db.pyo", line 131, in execute IntegrityError: duplicate key value violates unique constraint "res_partner_category_rel_partner_id_key" I redo the process (restart) and the error changes to this: <<<<<<<<<<<<<<<< Error! >>>>>>>>>>>>>>>> Traceback (most recent call last): File "C:\Archivos de programa\OpenERP 6.0\Server\addons\server_migration\migration.py", line 626, in _import_data File "C:\Archivos de programa\OpenERP 6.0\Server\addons\server_migration\migration.py", line 589, in import_model File "C:\Archivos de programa\OpenERP 6.0\Server\addons\server_migration\migration.py", line 329, in create File "osv\fields.pyo", line 644, in set File "sql_db.pyo", line 78, in wrapper File "sql_db.pyo", line 131, in execute IntegrityError: insert or update on table "res_partner_category_rel" violates foreign key constraint "res_partner_category_rel_category_id_fkey" DETAIL: Key (category_id)=(31) is not present in table "res_partner_category". In first execution there is no detail... To manage notifications about this bug go to: https://bugs.launchpad.net/domsense-agilebg-addons/+bug/838012/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~c2c-oerpscenario Post to : [email protected] Unsubscribe : https://launchpad.net/~c2c-oerpscenario More help : https://help.launchpad.net/ListHelp
