c2c-oerpscenario team mailing list archive
-
c2c-oerpscenario team
-
Mailing list archive
-
Message #32022
[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