Odoo Addons (MOVED TO GITHUB)

[Windows]Version 7 - Contracts Mgmt installation stops with error

Bug #1082924 reported by Gerald Ngui
80
This bug affects 13 people
Affects Status Importance Assigned to Milestone
Odoo Addons (MOVED TO GITHUB)
Confirmed
Medium
OpenERP R&D Addons Team 3

Bug Description

Contracts Management installation stops with an error.
This is on Windows 7 using openerp-allinone-setup-7.0beta.exe, version OpenERP 6.2dev-20121116-000101.

To replicate, create a new empty database, go to settings/module. Install Contracts Management. The module installation stops with the following error:

OpenERP Server Error
Client Traceback (most recent call last):
  File "E:\Program Files\OpenERP 6.2dev-20121116-000101\Server\server\openerp\addons\web\http.py", line 192, in dispatch
  File "E:\Program Files\OpenERP 6.2dev-20121116-000101\Server\server\openerp\addons\web\controllers\main.py", line 1225, in call_button
  File "E:\Program Files\OpenERP 6.2dev-20121116-000101\Server\server\openerp\addons\web\controllers\main.py", line 1159, in call_common
  File "E:\Program Files\OpenERP 6.2dev-20121116-000101\Server\server\openerp\addons\web\controllers\main.py", line 1183, in _call_kw
  File "E:\Program Files\OpenERP 6.2dev-20121116-000101\Server\server\openerp\addons\web\session.py", line 42, in proxy
  File "E:\Program Files\OpenERP 6.2dev-20121116-000101\Server\server\openerp\addons\web\session.py", line 30, in proxy_method
  File "E:\Program Files\OpenERP 6.2dev-20121116-000101\Server\server\openerp\addons\web\session.py", line 105, in send

Server Traceback (most recent call last):
  File "E:\Program Files\OpenERP 6.2dev-20121116-000101\Server\server\openerp\addons\web\session.py", line 91, in send
  File "E:\Program Files\OpenERP 6.2dev-20121116-000101\Server\server\.\openerp\netsvc.py", line 361, in dispatch_rpc
  File "E:\Program Files\OpenERP 6.2dev-20121116-000101\Server\server\.\openerp\service\web_services.py", line 596, in dispatch
  File "E:\Program Files\OpenERP 6.2dev-20121116-000101\Server\server\.\openerp\osv\osv.py", line 167, in execute_kw
  File "E:\Program Files\OpenERP 6.2dev-20121116-000101\Server\server\.\openerp\osv\osv.py", line 121, in wrapper
  File "E:\Program Files\OpenERP 6.2dev-20121116-000101\Server\server\.\openerp\osv\osv.py", line 176, in execute
  File "E:\Program Files\OpenERP 6.2dev-20121116-000101\Server\server\.\openerp\osv\osv.py", line 164, in execute_cr
  File "E:\Program Files\OpenERP 6.2dev-20121116-000101\Server\server\openerp\addons\base\module\module.py", line 368, in button_immediate_install
  File "E:\Program Files\OpenERP 6.2dev-20121116-000101\Server\server\openerp\addons\base\module\module.py", line 418, in _button_immediate_function
  File "E:\Program Files\OpenERP 6.2dev-20121116-000101\Server\server\.\openerp\pooler.py", line 39, in restart_pool
  File "E:\Program Files\OpenERP 6.2dev-20121116-000101\Server\server\.\openerp\modules\registry.py", line 178, in new
  File "E:\Program Files\OpenERP 6.2dev-20121116-000101\Server\server\.\openerp\modules\loading.py", line 337, in load_modules
  File "E:\Program Files\OpenERP 6.2dev-20121116-000101\Server\server\.\openerp\modules\loading.py", line 248, in load_marked_modules
  File "E:\Program Files\OpenERP 6.2dev-20121116-000101\Server\server\.\openerp\modules\loading.py", line 161, in load_module_graph
  File "E:\Program Files\OpenERP 6.2dev-20121116-000101\Server\server\.\openerp\modules\module.py", line 377, in init_module_models
  File "E:\Program Files\OpenERP 6.2dev-20121116-000101\Server\server\openerp\addons\account_analytic_analysis\account_analytic_analysis.py", line 530, in init
  File "E:\Program Files\OpenERP 6.2dev-20121116-000101\Server\server\.\openerp\sql_db.py", line 162, in wrapper
  File "E:\Program Files\OpenERP 6.2dev-20121116-000101\Server\server\.\openerp\sql_db.py", line 227, in execute
ProgrammingError: syntax error at or near "with mu"
LINE 2: with mu as
                    ^

Tags: costing
Jignesh Rathod(OpenERP) (jir-openerp)
Changed in openobject-addons:
assignee: nobody → OpenERP R&D Addons Team 3 (openerp-dev-addons3)
importance: Undecided → Medium
status: New → Confirmed
Amit Parik (amit-parik)
summary: - Version 7 - Contracts Mgmt installation stops with error
+ [Windows]Version 7 - Contracts Mgmt installation stops with error
Revision history for this message
Carlos Pueyo (cpueyo) wrote :

This happens because AllInOne install PostgreSQL 8.3 with no support recursive querys.

To solve, uninstall PostgreSQL 8.3 and install PostgreSQL 8.4.14.

Revision history for this message
Houssine (houssine-bakkali) wrote :

Hi Carlos,

I'm not sure of that because it happens as soon you install/activate the account analytic analysis. And as the contract management module has a dependency on it, it activate the account analytic analysis once the contract mngt module is installed.

The problem is with the init method of account_analytic_analysis.py file

ProgrammingError: syntax error at or near "with mu"
LINE 2: with mu as

def init(self, cr):
        tools.sql.drop_view_if_exists(cr, 'account_analytic_analysis_summary_user')
        cr.execute('''CREATE OR REPLACE VIEW account_analytic_analysis_summary_user AS (
            with mu as
                (select max(id) as max_user from res_users)
            , lu AS
                (SELECT
                 l.account_id AS account_id,
                 coalesce(l.user_id, 0) AS user_id,
                 SUM(l.unit_amount) AS unit_amount
             FROM account_analytic_line AS l,
                 account_analytic_journal AS j
             WHERE (j.type = 'general' ) and (j.id=l.journal_id)
             GROUP BY l.account_id, l.user_id
            )
            select (lu.account_id * mu.max_user) + lu.user_id as id,
                    lu.account_id as account_id,
                    lu.user_id as "user",
                    unit_amount
            from lu, mu)''')

Revision history for this message
Houssine (houssine-bakkali) wrote :

any update about this?

Revision history for this message
Houssine (houssine-bakkali) wrote :

making it running on 8.4 solved the issue.

Thanks Carlos!

Revision history for this message
开阖软件 Jeff Wang (jeff.osbzr.com) wrote :

why not change the allinone installer package with pgsql8.4 or 9.1?

Amit Parik (amit-parik)
tags: added: costing
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

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