This question has been flagged
1 Reply
6645 Views

Hello.

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...
Avatar
Discard

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.

Author

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

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.

Best Answer

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.

Avatar
Discard
Author

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

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

Author

Thank you. Still learning where is what.