OpenERP 7.0 - Product Screen -Request Procurement

Bug #1126178 reported by Sudheendra Walvekar
10
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Odoo Addons (MOVED TO GITHUB)
Invalid
Undecided
Unassigned

Bug Description

Hi All,
I created blank database in the openERP 7.0 web client. I installed CRM, Purchase, Warehouse,Manufacturing, Human resources, Accounting modules.
I have created the organization under Settings-> Companies.
I created 3 products A,B and C. Also, I have created a Bill of Material for A with BOM components as B and C.
I navigated to product A and clicked on Request procurement button which took me to next screen with a button ask for new products. This leads to INT: admin screen which has 'Run Procurement' Button. When this button is clicked, I get the following error.

OpenERP Server Error
Client Traceback (most recent call last):
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\openerp\addons\web\http.py", line 195, in dispatch
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\openerp\addons\web\controllers\main.py", line 1089, in exec_workflow
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\openerp\addons\web\session.py", line 148, in exec_workflow
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\openerp\addons\web\session.py", line 31, in proxy_method
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\openerp\addons\web\session.py", line 104, in send

Server Traceback (most recent call last):
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\openerp\addons\web\session.py", line 90, in send
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\netsvc.py", line 289, in dispatch_rpc
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\service\web_services.py", line 614, in dispatch
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\osv\osv.py", line 123, in wrapper
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\osv\osv.py", line 202, in exec_workflow
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\openerp\addons\audittrail\audittrail.py", line 520, in exec_workflow_cr
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\osv\osv.py", line 195, in exec_workflow_cr
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\osv\orm.py", line 3928, in _workflow_signal
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\workflow\wkf_service.py", line 119, in trg_validate
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\workflow\instance.py", line 43, in validate
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\workflow\workitem.py", line 60, in process
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\workflow\workitem.py", line 175, in _split_test
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\workflow\workitem.py", line 183, in _join_test
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\workflow\workitem.py", line 40, in create
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\workflow\workitem.py", line 60, in process
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\workflow\workitem.py", line 175, in _split_test
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\workflow\workitem.py", line 183, in _join_test
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\workflow\workitem.py", line 40, in create
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\workflow\workitem.py", line 60, in process
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\workflow\workitem.py", line 175, in _split_test
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\workflow\workitem.py", line 183, in _join_test
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\workflow\workitem.py", line 40, in create
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\workflow\workitem.py", line 52, in process
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\workflow\workitem.py", line 133, in _execute
TypeError: 'NoneType' object is unsubscriptable

This, however, does not happen when db with demonstration data is used.
I would appreciate any help
Regards

Daniel Reis (dreis-pt)
affects: openobject-library → openobject-addons
Revision history for this message
Sudheendra Walvekar (walvekars) wrote :
Download full text (5.2 KiB)

As suggested by Daniel Reis(SECURITAS SA) here are the steps to reproduce the bug.

Install openERP and an already installed postgress instance. (Uncheck postgress during openERP 7.0 installation).

After installation is successful change the pg patch in the openerp-server.conf file to point openERP to the correct posgress directory.

Environment : Windows 7

Install the modules : CRM, Project Accounting, Purchase, Warehouse, Manufacturing and Human Resources.

Go to Settings-> Companies and Create a company.

Go to Warehouse -> Products and create following products

Product A - Choose any category and make the product as Check Mark 'Can be sold'. Procurement Method: Make to order,Supply Method :Manufacture. Enter the Cost price.

Product B and Product C - Choose any category and Check mark 'Can be Purchased'. Procurement Method: Make to Stock and Supply Method : Buy.

Go to Product A and create Bill of Material by clicking on to button Bill of Materials. Choose B and C as BoM components for A.

To reproduce the Error, Click on Product B or C and Click on button 'Request for Procurement' and click on the button 'Ask for New Products' in the next screen. This will take you to Products / B / INT: admin screen. Click on 'Run Procurement'

This displays the said error as shown below again.

OpenERP Server Error
Client Traceback (most recent call last):
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\openerp\addons\web\http.py", line 195, in dispatch
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\openerp\addons\web\controllers\main.py", line 1089, in exec_workflow
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\openerp\addons\web\session.py", line 148, in exec_workflow
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\openerp\addons\web\session.py", line 31, in proxy_method
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\openerp\addons\web\session.py", line 104, in send

Server Traceback (most recent call last):
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\openerp\addons\web\session.py", line 90, in send
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\netsvc.py", line 289, in dispatch_rpc
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\service\web_services.py", line 614, in dispatch
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\osv\osv.py", line 123, in wrapper
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\osv\osv.py", line 202, in exec_workflow
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\openerp\addons\audittrail\audittrail.py", line 520, in exec_workflow_cr
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\osv\osv.py", line 195, in exec_workflow_cr
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\osv\orm.py", line 3928, in _workflow_signal
  File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\workflow\wkf_service.py", line 119, ...

Read more...

description: updated
Revision history for this message
Twinkle Christian(OpenERP) (tch-openerp) wrote :

Hello Sudheendra Walvekar,

I have tested your issue with trunk as well as with 7.0, but did not meet with the your traceback. So I have attached a video for your reference, Please refer it and correct me if i did follow any wrong steps while performing this. So, would you please check it again with latest code and also provide more precise steps for reproducing it.

I hope you understand. :)

Thanks & Waiting for your answer.

Changed in openobject-addons:
status: New → Incomplete
Revision history for this message
Sudheendra Walvekar (walvekars) wrote : RE: [Bug 1126178] Re: OpenERP 7.0 - Product Screen -Request Procurement
Download full text (6.1 KiB)

Hi,

Sorry for the delayed response.

I thank you very much for all the effort that you have made to replicate the issue.

As such the problem is solved. I found that the Windows OS had issues and many other applications were not running properly. I reinstalled windows and the problem has got resolved.

Thank you again.

Regards

Sudheendra

-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of Twinkle Christian(OpenERP)
Sent: Monday, March 18, 2013 4:55 PM
To: <email address hidden>
Subject: [Bug 1126178] Re: OpenERP 7.0 - Product Screen -Request Procurement

Hello Sudheendra Walvekar,

I have tested your issue with trunk as well as with 7.0, but did not meet with the your traceback. So I have attached a video for your reference, Please refer it and correct me if i did follow any wrong steps while performing this. So, would you please check it again with latest code and also provide more precise steps for reproducing it.

I hope you understand. :)

Thanks & Waiting for your answer.

** Attachment added: "test product.ogv"
   https://bugs.launchpad.net/openobject-addons/+bug/1126178/+attachment/3581230/+files/test%20product.ogv

** Changed in: openobject-addons
       Status: New => Incomplete

--
You received this bug notification because you are subscribed to the bug report.
https://bugs.launchpad.net/bugs/1126178

Title:
  OpenERP 7.0 - Product Screen -Request Procurement

Status in OpenERP Addons (modules):
  Incomplete

Bug description:
  Hi All,
  I created blank database in the openERP 7.0 web client. I installed CRM, Purchase, Warehouse,Manufacturing, Human resources, Accounting modules.
  I have created the organization under Settings-> Companies.
  I created 3 products A,B and C. Also, I have created a Bill of Material for A with BOM components as B and C.
  I navigated to product A and clicked on Request procurement button which took me to next screen with a button ask for new products. This leads to INT: admin screen which has 'Run Procurement' Button. When this button is clicked, I get the following error.

  OpenERP Server Error
  Client Traceback (most recent call last):
    File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\openerp\addons\web\http.py", line 195, in dispatch
    File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\openerp\addons\web\controllers\main.py", line 1089, in exec_workflow
    File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\openerp\addons\web\session.py", line 148, in exec_workflow
    File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\openerp\addons\web\session.py", line 31, in proxy_method
    File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\openerp\addons\web\session.py", line 104, in send

  Server Traceback (most recent call last):
    File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\openerp\addons\web\session.py", line 90, in send
    File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\.\openerp\netsvc.py", line 289, in dispatch_rpc
    File "C:\Program Files (x86)\OpenERP 7.0-20130118-002240\Server\server\...

Read more...

Revision history for this message
Amit Parik (amit-parik) wrote :

As per last comment closing this issue.

Thanks for the response.

Changed in openobject-addons:
status: Incomplete → 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.