Odoo Help


Error during apps installation - date/time field value out of range: "2013-02-30"

Max Kosenko
on 2/7/13, 12:03 PM 3,336 views


Trying to evaluate on Windows 7. Using all-in-one installation. All default settings. Changed regional to default US. But a lot of apps can't be installed normally and returning following error:

OpenERP Server Error
Client Traceback (most recent call last):
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\openerp\addons\web\http.py", line 195, in dispatch
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\openerp\addons\web\controllers\main.py", line 1082, in call_button
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\openerp\addons\web\controllers\main.py", line 1070, in _call_kw
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\openerp\addons\web\session.py", line 43, in proxy
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\openerp\addons\web\session.py", line 31, in proxy_method
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\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-20130206-000101\Server\server\openerp\addons\web\session.py", line 90, in send
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\.\openerp\netsvc.py", line 289, in dispatch_rpc
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\.\openerp\service\web_services.py", line 614, in dispatch
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\.\openerp\osv\osv.py", line 169, in execute_kw
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\.\openerp\osv\osv.py", line 123, in wrapper
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\.\openerp\osv\osv.py", line 179, in execute
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\.\openerp\osv\osv.py", line 166, in execute_cr
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\openerp\addons\base\module\wizard\base_module_upgrade.py", line 90, in upgrade_module
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\.\openerp\pooler.py", line 39, in restart_pool
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\.\openerp\modules\registry.py", line 214, in new
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\.\openerp\modules\loading.py", line 347, in load_modules
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\.\openerp\modules\loading.py", line 258, in load_marked_modules
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\.\openerp\modules\loading.py", line 194, in load_module_graph
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\.\openerp\modules\loading.py", line 76, in <lambda>
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\.\openerp\modules\loading.py", line 126, in _load_data
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\.\openerp\tools\convert.py", line 954, in convert_xml_import
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\.\openerp\tools\convert.py", line 847, in parse
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\.\openerp\tools\convert.py", line 814, in _tag_record
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\openerp\addons\base\ir\ir_model.py", line 956, in _update
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\openerp\addons\crm\crm_lead.py", line 97, in create
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\openerp\addons\mail\mail_thread.py", line 241, in create
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\.\openerp\osv\orm.py", line 4436, in create
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\.\openerp\sql_db.py", line 162, in wrapper
  File "C:\Program Files (x86)\OpenERP 7.0-20130206-000101\Server\server\.\openerp\sql_db.py", line 227, in execute
DataError: date/time field value out of range: "2013-02-30"
LINE 1: ...uid,create_date,write_uid,write_date) values (240,'2013-02-3...

The 30th of February is an invalid date - so the error makes sense. The next step is working out what is causing OpenERP to insert that date into the system.

Ray Carnes
on 2/7/13, 12:11 PM

Ha ha! I just realized that there is no such date exists. Thank you.

Max Kosenko
on 2/7/13, 12:24 PM

When using demo data, there is some data generated on the day 30 of current month. But there are less than 30 days in February. You can use pgadmin to change the dates. I had the same problem, I think it was an appointment with a lead or something that was causing it.

on 2/18/13, 8:14 AM

Davide Corio

--Davide Corio--

| 5 4 7
Bricherasio, Italy
--Davide Corio--

Odoo Evangelist and Consultant

Davide Corio
On 2/7/13, 12:19 PM

That happens if you select the demo data installation during the db creation. It's clearly a bug.

Just deselect the demo data field on the new db creation form.

Could you advise where I can find a ticket to track it?

Max Kosenko
on 2/7/13, 12:23 PM

It´'s fixed in revision 8639 2013-02-01 06:02:20 - http://bazaar.launchpad.net/~openerp/openobject-addons/7.0/revision/8639 Use a newer nightly version

Hans Henrik Gabelgaard
on 2/7/13, 4:37 PM

Thank you. Still learning where is what.

Max Kosenko
on 2/7/13, 5:29 PM

About This Community

This platform 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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 2/7/13, 12:03 PM
Seen: 3336 times
Last updated: 3/16/15, 8:10 AM