Stock prodlot

[Bruno Hostalery]

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

[Jay Vora (Serpent Consulting Services) (jayvora)]

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.

[Bruno Hostalery (istf)]

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)

[Bruno Hostalery (istf)]

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