Odoo Help


This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


How fix "Field(s) `date_stop` failed against a constraint: Error!" loading account module with demo data?

Paty L L
on 9/9/14, 2:17 PM 2,362 views

On september 8 I cloned odoo 8 (git clone -b 8.0  https://github.com/odoo/odoo.git)  and ran setup.py install, then configured openerp-server.conf  and some details on dependencies. Now its working almost right.

Problem is when I try to install account module with demo data (I created database with demonstration data) it reports violation on restriction while loading account_demo.xml file.

Field(s) `date_stop` failed against a constraint: Error!
The period is invalid. Either some periods are overlapping or the period's dates are not matching the scope of the fiscal year." while parsing /home/openerp/odoo8169/odoo/addons/account/demo/account_demo.xml:30, near
<record id="period_1" model="account.period">
            <field eval="'01/'+time.strftime('%Y')" name="code"/>
            <field eval="'X 01/'+time.strftime('%Y')" name="name"/>
            <field name="fiscalyear_id" ref="data_fiscalyear"/>
            <field eval="time.strftime('%Y')+'-01-01'" name="date_start"/>
            <field eval="time.strftime('%Y')+'-01-31'" name="date_stop"/>
            <field name="company_id" ref="base.main_company"/>

I can see the first period (opening period 2014 ) overlaps date_stop with date_start on second period (01/2014) as both are 01-01, but this is a normal situation as long as I know.

Have any of you faced this problem? Thanks for your comments.


Now I gave following to problem into account/account.py. I realized the False response was in method _check_year_limit, when testing pids = self.search(cr, uid, [('date_stop','>=',obj_period.date_start),('date_start','',obj_period.id)]) for period in self.browse(cr, uid, pids): if period.fiscalyear_id.company_id.id==obj_period.fiscalyear_id.company_id.id: ... it found similar period. So, looking at the log, I decided comment out the loading of ## 'account_pre_install.yml', file in 'data': [ section of __openerp__.py All this in module account. In summary, I avoided loading of account_pre_install.yml file for account module, start a fresh database and load account module. It loaded everything ok. What I dont know is why fiscal periods are loading twice.

Paty L L
on 9/9/14, 5:39 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


Asked: 9/9/14, 2:17 PM
Seen: 2362 times
Last updated: 3/16/15, 8:10 AM