← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 838012] Re: Error duplicate key

 

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


References