openupgrade-drivers team mailing list archive

[Stefan <stefan@xxxxxxxx>]

Hi Dragan,

this happens when the users' partners are created. As the comment in 
that part of the base module's pre script says:

    If other modules set additional columns to
    required, the following will break. We may
    want to have a look at disabling triggers
    at that point.

It seems wiser to refactor to pass defaults in this query depending on 
the module install base. For now, if you know a bit of Python you can 
simply hack the 'no-message' default value for these columns into the query.

Cheers,
Stefan.




On 13-06-14 08:51, Dragan Stojkovic wrote:
> New question #250185 on OpenUpgrade Server:
> https://answers.launchpad.net/openupgrade-server/+question/250185
>
> By trying to run migration script I receive an Not-Null-Constraint for the values : purchase_warn, sales_warn,invoice_warn,picking_warn
>
> 2014-06-13 05:58:37,625 31575 ERROR P100_migrated openerp.sql_db: bad query: INSERT INTO res_partner (name, active) VALUES(E'Chris Stumbert',true) RETURNING id
> Traceback (most recent call last):
>    File "/var/tmp/openupgrade/7.0/server/openerp/sql_db.py", line 226, in execute
>      res = self._obj.execute(query, params)
> IntegrityError: FEHLER:  NULL-Wert in Spalte »purchase_warn« verletzt Not-Null-Constraint
>
> 2014-06-13 05:58:37,625 31575 ERROR P100_migrated OpenUpgrade: base: error in migration script /var/tmp/openupgrade/7.0/server/openerp/addons/base/migrations/7.0.1.3/pre-migration.py: FEHLER:  N
> ULL-Wert in Spalte »purchase_warn« verletzt Not-Null-Constraint
>
> 2014-06-13 05:58:37,625 31575 ERROR P100_migrated OpenUpgrade: FEHLER:  NULL-Wert in Spalte »purchase_warn« verletzt Not-Null-Constraint
> Traceback (most recent call last):
>    File "/var/tmp/openupgrade/7.0/server/openerp/openupgrade/openupgrade.py", line 471, in wrapped_function
>      func(cr, version)
>    File "base/migrations/7.0.1.3/pre-migration.py", line 231, in migrate
>    File "base/migrations/7.0.1.3/pre-migration.py", line 190, in create_users_partner
>    File "/var/tmp/openupgrade/7.0/server/openerp/sql_db.py", line 161, in wrapper
>      return f(self, *args, **kwargs)
>    File "/var/tmp/openupgrade/7.0/server/openerp/sql_db.py", line 226, in execute
>      res = self._obj.execute(query, params)
> IntegrityError: FEHLER:  NULL-Wert in Spalte »purchase_warn« verletzt Not-Null-Constraint


--
Therp - Maatwerk in open ontwikkeling

Stefan Rijnhart - Ontwerp en implementatie

mail: stefan@xxxxxxxx
tel: +31 (0) 614478606
web: http://therp.nl