v6 warning/error in log after database installed successfully

[GEM]

for info during the database creation in server log I have this warning and errors, but database is installed :

[2010-07-29 14:15:13,256] WARNING:init:object ir.module.web (Web Module) has no access rules!
[2010-07-29 14:15:13,256] WARNING:init:object ir.module.web.dependency (Web Module dependency) has no access rules!
[2010-07-29 14:15:13,322] INFO:init:[01]: Assertions report:
[2010-07-29 14:15:13,323] INFO:init:[02]: Level success failed
[2010-07-29 14:15:13,323] INFO:init:[03]: error 1 0
[2010-07-29 14:15:13,323] INFO:init:[04]: total 1 0

[2010-07-29 14:17:51,355] INFO:init:module crm: loading test/test_crm_lead.yml
[2010-07-29 14:17:51,565] ERROR:tests.crm:('warning', 'Error')
Traceback (most recent call last):
  File "tools\yaml_import.pyo", line 691, in process
  File "tools\yaml_import.pyo", line 704, in _process_node
  File "tools\yaml_import.pyo", line 297, in process_record
  File "d:\OpenERP AllInOne\Server\addons\base\ir\ir_model.py", line 575, in _update
  File "d:\OpenERP AllInOne\Server\addons\crm\crm_lead.py", line 168, in create
except_osv: ('warning', 'Error')

[2010-07-29 14:18:59,526] INFO:init:module sale: loading test/manual_order_policy.yml
[2010-07-29 14:19:01,460] ERROR:tests.sale:'module' object has no attribute 'strptime'
Traceback (most recent call last):
  File "tools\yaml_import.pyo", line 691, in process
  File "tools\yaml_import.pyo", line 725, in _process_node
  File "tools\yaml_import.pyo", line 419, in process_workflow
  File "workflow\wkf_service.pyo", line 80, in trg_validate
  File "workflow\instance.pyo", line 48, in validate
  File "workflow\workitem.pyo", line 61, in process
  File "workflow\workitem.pyo", line 174, in _split_test
  File "workflow\workitem.pyo", line 182, in _join_test
  File "workflow\workitem.pyo", line 41, in create
  File "workflow\workitem.pyo", line 61, in process
  File "workflow\workitem.pyo", line 174, in _split_test
  File "workflow\workitem.pyo", line 182, in _join_test
  File "workflow\workitem.pyo", line 41, in create
  File "workflow\workitem.pyo", line 61, in process
  File "workflow\workitem.pyo", line 174, in _split_test
  File "workflow\workitem.pyo", line 182, in _join_test
  File "workflow\workitem.pyo", line 41, in create
  File "workflow\workitem.pyo", line 53, in process
  File "workflow\workitem.pyo", line 107, in _execute
  File "workflow\wkf_expr.pyo", line 68, in execute
  File "workflow\wkf_expr.pyo", line 58, in _eval_expr
  File "tools\safe_eval.pyo", line 265, in safe_eval
  File "", line 1, in <module>
  File "osv\orm.pyo", line 176, in <lambda>
  File "d:\OpenERP AllInOne\Server\addons\sale\sale.py", line 708, in action_ship_create
  File "workflow\wkf_service.pyo", line 80, in trg_validate
  File "workflow\instance.pyo", line 48, in validate
  File "workflow\workitem.pyo", line 61, in process
  File "workflow\workitem.pyo", line 174, in _split_test
  File "workflow\workitem.pyo", line 182, in _join_test
  File "workflow\workitem.pyo", line 41, in create
  File "workflow\workitem.pyo", line 61, in process
  File "workflow\workitem.pyo", line 174, in _split_test
  File "workflow\workitem.pyo", line 182, in _join_test
  File "workflow\workitem.pyo", line 41, in create
  File "workflow\workitem.pyo", line 61, in process
  File "workflow\workitem.pyo", line 174, in _split_test
  File "workflow\workitem.pyo", line 182, in _join_test
  File "workflow\workitem.pyo", line 41, in create
  File "workflow\workitem.pyo", line 61, in process
  File "workflow\workitem.pyo", line 174, in _split_test
  File "workflow\workitem.pyo", line 182, in _join_test
  File "workflow\workitem.pyo", line 41, in create
  File "workflow\workitem.pyo", line 53, in process
  File "workflow\workitem.pyo", line 126, in _execute
  File "workflow\wkf_expr.pyo", line 68, in execute
  File "workflow\wkf_expr.pyo", line 58, in _eval_expr
  File "tools\safe_eval.pyo", line 265, in safe_eval
  File "", line 1, in <module>
  File "osv\orm.pyo", line 176, in <lambda>
  File "d:\OpenERP AllInOne\Server\addons\purchase\purchase.py", line 731, in action_po_assign
  File "d:\OpenERP AllInOne\Server\addons\purchase\purchase.py", line 764, in make_po
AttributeError: 'module' object has no attribute 'strptime'

[2010-07-29 14:19:20,092] INFO:init:module mrp: loading test/mrp_phantom_bom.yml
[2010-07-29 14:19:25,987] ERROR:tests.mrp:'module' object has no attribute 'strptime'
Traceback (most recent call last):
  File "tools\yaml_import.pyo", line 691, in process
  File "tools\yaml_import.pyo", line 728, in _process_node
  File "tools\yaml_import.pyo", line 458, in process_function
  File "d:\OpenERP AllInOne\Server\addons\procurement\procurement.py", line 468, in run_scheduler
  File "d:\OpenERP AllInOne\Server\addons\procurement\schedulers.py", line 55, in _procure_confirm
  File "workflow\wkf_service.pyo", line 80, in trg_validate
  File "workflow\instance.pyo", line 48, in validate
  File "workflow\workitem.pyo", line 61, in process
  File "workflow\workitem.pyo", line 174, in _split_test
  File "workflow\workitem.pyo", line 182, in _join_test
  File "workflow\workitem.pyo", line 41, in create
  File "workflow\workitem.pyo", line 61, in process
  File "workflow\workitem.pyo", line 174, in _split_test
  File "workflow\workitem.pyo", line 182, in _join_test
  File "workflow\workitem.pyo", line 41, in create
  File "workflow\workitem.pyo", line 61, in process
  File "workflow\workitem.pyo", line 174, in _split_test
  File "workflow\workitem.pyo", line 182, in _join_test
  File "workflow\workitem.pyo", line 41, in create
  File "workflow\workitem.pyo", line 61, in process
  File "workflow\workitem.pyo", line 174, in _split_test
  File "workflow\workitem.pyo", line 182, in _join_test
  File "workflow\workitem.pyo", line 41, in create
  File "workflow\workitem.pyo", line 61, in process
  File "workflow\workitem.pyo", line 174, in _split_test
  File "workflow\workitem.pyo", line 182, in _join_test
  File "workflow\workitem.pyo", line 41, in create
  File "workflow\workitem.pyo", line 53, in process
  File "workflow\workitem.pyo", line 126, in _execute
  File "workflow\wkf_expr.pyo", line 68, in execute
  File "workflow\wkf_expr.pyo", line 58, in _eval_expr
  File "tools\safe_eval.pyo", line 265, in safe_eval
  File "", line 1, in <module>
  File "osv\orm.pyo", line 176, in <lambda>
  File "d:\OpenERP AllInOne\Server\addons\mrp\procurement.py", line 56, in action_produce_assign_product
  File "d:\OpenERP AllInOne\Server\addons\mrp\procurement.py", line 73, in make_mo
AttributeError: 'module' object has no attribute 'strptime'

[2010-07-29 14:19:31,407] INFO:i18n:module sale_crm: loading translation file for language fr
[2010-07-29 14:19:31,802] WARNING:init:object ir.module.web (Web Module) has no access rules!
[2010-07-29 14:19:31,803] WARNING:init:object ir.module.web.dependency (Web Module dependency) has no access rules!
[2010-07-29 14:19:31,803] WARNING:init:object account.cashbox.line (CashBox Line) has no access rules!
[2010-07-29 14:19:31,808] WARNING:init:In-memory object res.config.installer (res.config.installer) should not have explicit access rules!
[2010-07-29 14:19:32,013] INFO:init:[01]: Assertions report:
[2010-07-29 14:19:32,013] INFO:init:[02]: Level success failed
[2010-07-29 14:19:32,013] INFO:init:[03]: error 5 0
[2010-07-29 14:19:32,013] INFO:init:[04]: total 5 0

[2010-07-29 14:19:47,013] INFO:init:module document: loading test/document_test2.yml
[2010-07-29 14:19:47,098] ERROR:tests.document:object of type 'NoneType' has no len()
Traceback (most recent call last):
  File "tools\yaml_import.pyo", line 691, in process
  File "tools\yaml_import.pyo", line 710, in _process_node
  File "tools\yaml_import.pyo", line 600, in process_delete
TypeError: object of type 'NoneType' has no len()

[2010-07-29 14:19:48,980] INFO:init:module document_ftp: loading test/document_ftp_test2.yml
[2010-07-29 14:19:49,076] ERROR:tests.document_ftp:connect() got an unexpected keyword argument 'timeout'
Traceback (most recent call last):
  File "tools\yaml_import.pyo", line 691, in process
  File "tools\yaml_import.pyo", line 706, in _process_node
  File "tools\yaml_import.pyo", line 387, in process_python
YamlImportAbortion: connect() got an unexpected keyword argument 'timeout'

[2010-07-29 14:21:08,924] INFO:init:module hr_recruitment: loading test/test_hr_recruitment.yml
[2010-07-29 14:21:09,032] ERROR:tests.hr_recruitment:No references to hr_recruitment.type_job2
Traceback (most recent call last):
  File "tools\yaml_import.pyo", line 691, in process
  File "tools\yaml_import.pyo", line 704, in _process_node
  File "tools\yaml_import.pyo", line 294, in process_record
  File "tools\yaml_import.pyo", line 305, in _create_record
  File "tools\yaml_import.pyo", line 349, in _eval_field
  File "tools\yaml_import.pyo", line 175, in get_id
  File "tools\misc.pyo", line 802, in cached_result
  File "d:\OpenERP AllInOne\Server\addons\base\ir\ir_model.py", line 494, in _get_id
ValueError: No references to hr_recruitment.type_job2

[2010-07-29 14:21:15,717] INFO:init:module hr_payroll: loading test/payslip.yml
[2010-07-29 14:21:16,670] ERROR:tests.hr_payroll:('warning', 'Integrity Error !')
Traceback (most recent call last):
  File "tools\yaml_import.pyo", line 691, in process
  File "tools\yaml_import.pyo", line 725, in _process_node
  File "tools\yaml_import.pyo", line 419, in process_workflow
  File "workflow\wkf_service.pyo", line 80, in trg_validate
  File "workflow\instance.pyo", line 48, in validate
  File "workflow\workitem.pyo", line 61, in process
  File "workflow\workitem.pyo", line 174, in _split_test
  File "workflow\workitem.pyo", line 182, in _join_test
  File "workflow\workitem.pyo", line 41, in create
  File "workflow\workitem.pyo", line 53, in process
  File "workflow\workitem.pyo", line 107, in _execute
  File "workflow\wkf_expr.pyo", line 68, in execute
  File "workflow\wkf_expr.pyo", line 58, in _eval_expr
  File "tools\safe_eval.pyo", line 265, in safe_eval
  File "", line 1, in <module>
  File "osv\orm.pyo", line 176, in <lambda>
  File "d:\OpenERP AllInOne\Server\addons\hr_payroll_account\hr_payroll_account.py", line 267, in verify_sheet
except_osv: ('warning', 'Integrity Error !')

[2010-07-29 14:21:21,344] INFO:init:module hr_timesheet_invoice: loading test/test_hr_timesheet_invoice.yml
[2010-07-29 14:21:22,062] ERROR:tests.hr_timesheet_invoice:'ids'
Traceback (most recent call last):
  File "tools\yaml_import.pyo", line 691, in process
  File "tools\yaml_import.pyo", line 706, in _process_node
  File "tools\yaml_import.pyo", line 387, in process_python
YamlImportAbortion: 'ids'

[2010-07-29 14:21:25,184] INFO:init:module hr_timesheet_sheet: loading test/test_hr_timesheet_sheet.yml
[2010-07-29 14:21:25,884] ERROR:tests.hr_timesheet_sheet:name 'netsvc' is not defined
Traceback (most recent call last):
  File "tools\yaml_import.pyo", line 691, in process
  File "tools\yaml_import.pyo", line 706, in _process_node
  File "tools\yaml_import.pyo", line 387, in process_python
YamlImportAbortion: name 'netsvc' is not defined

[2010-07-29 14:22:04,753] INFO:init:module project_gtd: loading test/gtd_test.yml
[2010-07-29 14:22:05,151] ERROR:tests.project_gtd:('ValidateError', 'Error occurred while validating the field(s) date_start,date_end: Error! task start-date must be lower then task end-date.')
Traceback (most recent call last):
  File "tools\yaml_import.pyo", line 691, in process
  File "tools\yaml_import.pyo", line 706, in _process_node
  File "tools\yaml_import.pyo", line 387, in process_python
YamlImportAbortion: ('ValidateError', 'Error occurred while validating the field(s) date_start,date_end: Error! task start-date must be lower then task end-date.')

[2010-07-29 14:23:35,161] INFO:init:module stock_location: loading test/stock_location.yml
[2010-07-29 14:23:36,903] ERROR:db.cursor:bad query: insert into "product_supplierinfo" (id,"delay","product_id","sequence","qty","company_id","name",create_uid,create_date) values (26,1,50,1,5.0,1,29,1,now())
Traceback (most recent call last):
  File "sql_db.pyo", line 119, in execute
IntegrityError: null value in column "min_qty" violates not-null constraint

[2010-07-29 14:23:36,903] ERROR:tests.stock_location:null value in column "min_qty" violates not-null constraint
Traceback (most recent call last):
  File "tools\yaml_import.pyo", line 691, in process
  File "tools\yaml_import.pyo", line 704, in _process_node
  File "tools\yaml_import.pyo", line 297, in process_record
  File "d:\OpenERP AllInOne\Server\addons\base\ir\ir_model.py", line 575, in _update
  File "osv\orm.pyo", line 3464, in create
  File "osv\orm.pyo", line 3572, in create
  File "osv\fields.pyo", line 457, in set
  File "osv\orm.pyo", line 3536, in create
  File "sql_db.pyo", line 74, in wrapper
  File "sql_db.pyo", line 119, in execute
IntegrityError: null value in column "min_qty" violates not-null constraint

[2010-07-29 14:23:37,831] INFO:init:module mrp_operations: loading test/mrp_operations.yml
[2010-07-29 14:23:38,029] ERROR:tests.mrp_operations:'module' object has no attribute 'strptime'
Traceback (most recent call last):
  File "tools\yaml_import.pyo", line 691, in process
  File "tools\yaml_import.pyo", line 706, in _process_node
  File "tools\yaml_import.pyo", line 387, in process_python
YamlImportAbortion: 'module' object has no attribute 'strptime'

That's all.
Bye

[GEM (nimp3)]

and in gtk client log :

Traceback (most recent call last):
  File "widget\view\form_gtk\parser.pyo", line 122, in button_clicked
  File "widget\model\record.pyo", line 391, in get_button_action
  File "widget\screen\screen.pyo", line 662, in reload
  File "widget\screen\screen.pyo", line 728, in display
  File "widget\view\form.pyo", line 480, in display
  File "widget\view\form.pyo", line 52, in display
  File "widget\view\form_gtk\binary.pyo", line 197, in display
  File "widget\model\field.pyo", line 202, in get_client
  File "widget\model\field.pyo", line 173, in __check_load
IndexError: list index out of range

[Samantha (samantha-z-mathews)]

Thanks a lot GEM.
It sounds like MJ's long lyrics(the traceback).

@openerp,
it's a problem of yaml_import, where can i get something about yml?

[Jay Vora (Serpent Consulting Services) (jayvora)]

Yaml test failures have been fixed.
Thanks GEM.

[GEM (nimp3)]

Hi Jay,
it's ok for me too,
thanks for work.
Bye

[GEM (nimp3)]

in fact no error strptime for modules mrp\procurement.py, purchase\purchase.py
and an other for account :
[2010-10-06 08:45:46,118][admin] INFO:init:module account: loading test/account_fiscalyear_close_state.yml
[2010-10-06 08:45:46,148][admin] ERROR:tests.account:'__import__'
Traceback (most recent call last):
  File "tools\yaml_import.pyo", line 722, in process
  File "tools\yaml_import.pyo", line 735, in _process_node
  File "tools\yaml_import.pyo", line 315, in process_record
  File "tools\yaml_import.pyo", line 328, in _create_record
  File "tools\yaml_import.pyo", line 389, in _eval_field
  File "tools\yaml_import.pyo", line 355, in process_eval
  File "tools\safe_eval.pyo", line 270, in safe_eval
  File "", line 1, in <module>
KeyError: '__import__'
[2010-10-06 08:45:46,779][admin] INFO:i18n:module account: loading translation file for language fr
[2010-10-06 08:46:05,686][admin] INFO:init:module project: loading security/project_security.xml
[2010-10-06 08:46:05,862][admin] INFO:init:module project: loading wizard/project_task_delegate_view.xml
[2010-10-06 08:46:05,887][admin] INFO:init:module project: loading wizard/project_task_close_view.xml
[2010-10-06 08:46:05,908][admin] INFO:init:module project: loading wizard/project_task_reevaluate_view.xml
[2010-10-06 08:46:05,930][admin] INFO:init:module project: loading security/ir.model.access.csv
[2010-10-06 08:46:06,102][admin] INFO:init:module project: loading project_data.xml
[2010-10-06 08:46:06,134][admin] INFO:init:module project: loading project_view.xml
[2010-10-06 08:46:06,496][admin] INFO:init:module project: loading process/task_process.xml
[2010-10-06 08:46:06,576][admin] INFO:init:module project: loading project_installer.xml
[2010-10-06 08:46:06,608][admin] INFO:init:module project: loading res_partner_view.xml
[2010-10-06 08:46:06,625][admin] INFO:init:module project: loading report/project_report_view.xml
[2010-10-06 08:46:06,805][admin] INFO:init:module project: loading board_project_view.xml
[2010-10-06 08:46:06,921][admin] INFO:init:module project: loading board_project_manager_view.xml
[2010-10-06 08:46:06,977][admin] INFO:init:module project: loading project_demo.xml
[2010-10-06 08:46:10,391][admin] INFO:init:module project: loading board_project_demo.xml
[2010-10-06 08:46:10,411][admin] INFO:init:module project: loading test/test_project.yml
[2010-10-06 08:46:13,348][admin] INFO:init:module project: loading test/test_project_delegation.yml
[2010-10-06 08:46:17,950][admin] INFO:i18n:module project: loading translation file for language fr
[2010-10-06 08:46:21,203][admin] INFO:init:module crm: loading crm_data.xml
[2010-10-06 08:46:21,223][admin] INFO:init:module crm: loading crm_meeting_data.xml
[2010-10-06 08:46:21,249][admin] INFO:init:module crm: loading crm_lead_data.xml
[2010-10-06 08:46:21,335][admin] INFO:init:module crm: loading crm_meeting_data.xml
[2010-10-06 08:46:21,361][admin] INFO:init:module crm: loading crm_opportunity_data.xml
[2010-10-06 08:46:21,407][admin] INFO:init:module crm: loading crm_phonecall_data.xml
[2010-10-06 08:46:21,418][admin] INFO:init:module crm: loading security/crm_security.xml
[2010-10-06 08:46:21,471][admin] INFO:init:module ...

[GEM (nimp3)]

due to the module mrp error, I can't install purchase requisition and purchase anlalytic plans (depend of it).

An other point, you should add in server\setup.py line 177 for the list of required modules for py2xe (build for windows) "simplejson", "sqlalchemy" (error no module ....), sqlalchemy is in options line 217, but it isn't enough.
Bye

[GEM (nimp3)]

I don't know if this can be util but strptime is now supported for windows by egenix mx datetime with version 3.1.2, see :
http://www.egenix.com/products/python/mxBase/mxDateTime/changelog.html
But I don't know if for the build this version can give some other problems ...

[GEM (nimp3)]

Else, if this can help :
http://seehuhn.de/pages/pdate
Conversion between ISO Time Representation and datetime

Unfortunately there is no easy way to parse full ISO 8601 dates using the Python standard library. If you know the exact format of the date string in advance, you can use the strptime constructor of the datetime class (new in Python version 2.5):

>>> from datetime import datetime
>>> datetime.strptime("2007-03-04 21:08:12", "%Y-%m-%d %H:%M:%S")
datetime.datetime(2007, 3, 4, 21, 8, 12)

There are several parsers available in external modules. The most robust one I found is contained in the Egenix mxDateTime module:

>>> from mx.DateTime.ISO import ParseDateTimeUTC
>>> from datetime import datetime
>>> x = ParseDateTimeUTC("2007-03-04 21:08:12")
>>> datetime.fromtimestamp(x)
datetime.datetime(2007, 3, 4, 21, 8, 12)

[GEM (nimp3)]

I install new egenix-mx-base-3.1.3.win32-py2.5.msi to replace version 3.1.1 which was required to build installer for windows.
I had line from mx.DateTime import mxDateTime in mrp\procurement.py and in purchase\purchase.py after line "from datetime import datetime"
with configurator, I checked all modules possible, and no error no attribute strptime for this two modules

[GEM (nimp3)]

with mrp installed, I can finish configurator, but in server log there is 6-7 errors:
see attachment, my complete openerp-server.log

[Samantha (samantha-z-mathews)]

Thanks GEM.
I wil also ask my team for check of windows.

[GEM (nimp3)]

Hi samantha
I tested egenix-mx-base-3.1.3.win32-py2.5.msi for windows and it works well without error strptime, but there other errors with an other way to find, but I works on a script (finished, just one or two test to do) which is a mix of bzr_set.py (download and update sources with bazaar, adapted for windows =>symlink) and new scrit python of Stephane wirtel to build setup for windows (with more options => all combination of build possible, see make.py in branch win-installer trunk for original sources => last modification in the list), works for v5 and v6, just click to a file.cmd in which you have just to adapt options you need => 30 options possible), if you have email post me a message on openerp forum to GEM user, to give your email if you want I send you for testing all scripts and modules necessary to put in site-packages, for v5 and v6).Bye

[Jay Vora (Serpent Consulting Services) (jayvora)]

Errors seem fixed since RC1.
Thanks a lot GEM.

[GEM (nimp3)]

Hi Jay,
configurator with client gtk works without stopped now,
but some errors in the log of server, see attachment, last revision of sources used.
Happy we
Bye

[Jay Vora (Serpent Consulting Services) (jayvora)]

GEM,

These are just Logs in terms of INFO and WARNING, I did not see any error that cause a BLOCK for you.

Thanks.

[xrg (xrg)]

On Thursday 29 July 2010, you wrote:
> Public bug reported:
>
> for info during the database creation in server log I have this warning
> and errors, but database is installed :
>
> ERROR:tests.crm:('warning', 'Error')
> Traceback (most recent call last):
> File "tools\yaml_import.pyo", line 691, in process
>...
> in _update File "d:\OpenERP AllInOne\Server\addons\crm\crm_lead.py", line
> 168, in create except_osv: ('warning', 'Error')
>

I think I recognize many of those exceptions, having seen them in the
automated tests' logs.
Since this report is quite old, I believe that we have already fixed almost all
of them.
You could always cross check in:
    http://test.openobject.com
to see if what you've seen at your logs looks similar to a failed test there.
We are now getting very efficient in finding and eliminating such bugs.

We still appreciate your help, sending us your feedback.