Stock prodlot

Bug #550500 reported by Bruno Hostalery
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Odoo Addons (MOVED TO GITHUB)
Invalid
Undecided
Unassigned

Bug Description

Try to make production with prodlot.
Go to production, product made, split prodlot, create new prodlot and then :

Traceback (most recent call last):
  File "/opt/openerp/openerp-server-5.0.7/bin/netsvc.py", line 244, in dispatch
    result = LocalService(service_name)(method, *params)
  File "/opt/openerp/openerp-server-5.0.7/bin/netsvc.py", line 73, in __call__
    return getattr(self, method)(*params)
  File "/opt/openerp/server/bin/addons/base_module_record/base_module_record.py", line 38, in execute
    res = super(recording_objects_proxy, self).execute(*args, **argv)
  File "/opt/openerp/openerp-server-5.0.7/bin/service/web_services.py", line 576, in execute
    res = service.execute(db, uid, object, method, *args)
  File "/opt/openerp/openerp-server-5.0.7/bin/osv/osv.py", line 58, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/opt/openerp/openerp-server-5.0.7/bin/osv/osv.py", line 119, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/openerp/openerp-server-5.0.7/bin/osv/osv.py", line 111, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/openerp/openerp-server-5.0.7/bin/osv/orm.py", line 2203, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/opt/openerp/openerp-server-5.0.7/bin/osv/orm.py", line 2333, in _read_flat
    res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res)
  File "/opt/openerp/openerp-server-5.0.7/bin/osv/fields.py", line 650, in get
    res = self._fnct(obj, cr, user, ids, name, self._arg, context)
  File "/opt/openerp/server/bin/addons/stock/stock.py", line 841, in _get_stock
    ''')
  File "/opt/openerp/openerp-server-5.0.7/bin/sql_db.py", line 77, in wrapper
    return f(self, *args, **kwargs)
  File "/opt/openerp/openerp-server-5.0.7/bin/sql_db.py", line 122, in execute
    res = self._obj.execute(query, params)
ProgrammingError: ERREUR: la relation « stock_report_prodlots » n'existe pas
LIGNE 5 : stock_report_prodlots
                              ^

openerp 5.0.7
postgresql 8.4
debian 5.0

Revision history for this message
Jay Vora (Serpent Consulting Services) (jayvora) wrote :

Hello Bruno,

I would say that its an error coming due to some local changes.

Can you please go to the file stock/report_stock.py and check whether the view contains the name stock_report_prodlots?

Please apply the patch and recheck.

Thanks.

Another way:
Go to stock/report_stock.py. Look for the line 'create or replace view stock_report_prodlot as' on init() of class stock_report_prodlots.

I guess it has been modified. If so, look at the name of the view. and drop it.
Have an update of the module.
Thanks.

Changed in openobject-addons:
milestone: none → 5.0.8
status: New → Invalid
Revision history for this message
Bruno Hostalery (istf) wrote :

Sorry but it doesn't work
At first, without any prodlot, the program permit me to create one from the picking of my production.
But after one exist,there are no possibility to choose one.
The only way for the moment is to create prodlot manualy, and add it on picking by putting the exact number (no list to show, so no error message)

Changed in openobject-addons:
status: Invalid → New
Revision history for this message
Bruno Hostalery (istf) wrote :

Re sorry, it's my fault.
I just modify source and run server with -u all on my base, but it is not sufficient.
Have to use module configuration, plan a update and do it.

it works now

Changed in openobject-addons:
status: New → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.