#970 Unable to grant add_expenses permission

[Thorsten Niehues]

Unable to grant add_expenses permission via web-gui to group employee.

Unfortunately there was no error message on the web-site.

error.log:

[11/May/2015:14:40:07][2099.2817514352][-default:9-] Debug: db_exec: timing 0 seconds nsdb0 select dbqd.intranet-core.tcl.intranet-navbar-procs.im_navbar_tree_human_resources.absences
[11/May/2015:14:40:07][2099.2817514352][-default:9-] Debug: db_qd_replace_sql: dbqd.acs-tcl.tcl.acs-permissions-procs.permission::permission_p_not_cached.select_permission_p
[11/May/2015:14:40:07][2099.2817514352][-default:9-] Notice: Querying '
select 1 from dual
where exists
( select 1
from acs_object_party_privilege_map ppm
where ppm.object_id = '408' and ppm.party_id = '35805' and ppm.privilege = 'add_expenses' );'
[11/May/2015:14:40:07][2099.2817514352][-default:9-] Notice: dbinit: sql(localhost::projop): '
select 1 from dual
where exists
( select 1
from acs_object_party_privilege_map ppm
where ppm.object_id = '408' and ppm.party_id = '35805' and ppm.privilege = 'add_expenses' )
'
[11/May/2015:14:40:07][2099.2817514352][-default:9-] Debug: db_exec: timing 0 seconds nsdb0 0or1row dbqd.acs-tcl.tcl.acs-permissions-procs.permission::permission_p_not_cached.select_permission_p
[11/May/2015:14:40:07][2099.2817514352][-default:9-] Debug: db_qd_replace_sql: dbqd.intranet-core.tcl.intranet-navbar-procs.im_navbar_write_tree_helper.main_menu
[11/May/2015:14:40:07][2099.2817514352][-default:9-] Debug: NO FULLQUERY FOR dbqd.intranet-core.tcl.intranet-navbar-procs.im_navbar_write_tree_helper.main_menu --> using default SQL
[11/May/2015:14:40:07][2099.2817514352][-default:9-] Notice: Querying 'select menu_id from im_menus where label='reporting-hr';'
[11/May/2015:14:40:07][2099.2817514352][-default:9-] Notice: dbinit: sql(localhost::projop): 'select menu_id from im_menus where label='reporting-hr''
[11/May/2015:14:40:07][2099.2817514352][-default:9-] Debug: db_exec: timing 0 seconds nsdb0 0or1row dbqd.intranet-core.tcl.intranet-navbar-procs.im_navbar_write_tree_helper.main_menu
[11/May/2015:14:40:07][2099.2817514352][-default:9-] Debug: db_qd_replace_sql: dbqd.intranet-core.tcl.intranet-navbar-procs.im_navbar_write_tree_helper.menus
[11/May/2015:14:40:07][2099.2817514352][-default:9-] Debug: NO FULLQUERY FOR dbqd.intranet-core.tcl.intranet-navbar-procs.im_navbar_write_tree_helper.menus --> using default SQL
[11/May/2015:14:40:07][2099.2817514352][-default:9-] Notice: Querying '

......

[11/May/2015:14:40:07][2099.2817514352][-default:9-] Debug: db_exec: timing 0 seconds nsdb0 select dbqd.intranet-core.tcl.intranet-navbar-procs.im_navbar_tree_human_resources.absences
[11/May/2015:14:40:07][2099.2817514352][-default:9-] Debug: db_qd_replace_sql: dbqd.acs-tcl.tcl.acs-permissions-procs.permission::permission_p_not_cached.select_permission_p
[11/May/2015:14:40:07][2099.2817514352][-default:9-] Notice: Querying '
select 1 from dual
where exists
( select 1
from acs_object_party_privilege_map ppm
where ppm.object_id = '408' and ppm.party_id = '35805' and ppm.privilege = 'add_expenses' );'
[11/May/2015:14:40:07][2099.2817514352][-default:9-] Notice: dbinit: sql(localhost::projop): '
select 1 from dual
where exists
( select 1
from acs_object_party_privilege_map ppm
where ppm.object_id = '408' and ppm.party_id = '35805' and ppm.privilege = 'add_expenses' )
'
[11/May/2015:14:40:07][2099.2817514352][-default:9-] Debug: db_exec: timing 0 seconds nsdb0 0or1row dbqd.acs-tcl.tcl.acs-permissions-procs.permission::permission_p_not_cached.select_permission_p
[11/May/2015:14:40:07][2099.2817514352][-default:9-] Debug: db_qd_replace_sql: dbqd.intranet-core.tcl.intranet-navbar-procs.im_navbar_write_tree_helper.main_menu
[11/May/2015:14:40:07][2099.2817514352][-default:9-] Debug: NO FULLQUERY FOR dbqd.intranet-core.tcl.intranet-navbar-procs.im_navbar_write_tree_helper.main_menu --> using default SQL
[11/May/2015:14:40:07][2099.2817514352][-default:9-] Notice: Querying 'select menu_id from im_menus where label='reporting-hr';'
[11/May/2015:14:40:07][2099.2817514352][-default:9-] Notice: dbinit: sql(localhost::projop): 'select menu_id from im_menus where label='reporting-hr''
[11/May/2015:14:40:07][2099.2817514352][-default:9-] Debug: db_exec: timing 0 seconds nsdb0 0or1row dbqd.intranet-core.tcl.intranet-navbar-procs.im_navbar_write_tree_helper.main_menu
[11/May/2015:14:40:07][2099.2817514352][-default:9-] Debug: db_qd_replace_sql: dbqd.intranet-core.tcl.intranet-navbar-procs.im_navbar_write_tree_helper.menus
[11/May/2015:14:40:07][2099.2817514352][-default:9-] Debug: NO FULLQUERY FOR dbqd.intranet-core.tcl.intranet-navbar-procs.im_navbar_write_tree_helper.menus --> using default SQL
[11/May/2015:14:40:07][2099.2817514352][-default:9-] Notice: Querying '

[Frank Bergmann]

Sorry, I don't understand this. What is the offending URL, what should have happen and what happened?

[Frank Bergmann]

I couldn't reproduce this issue.
Maybe there is some funny misconfiguration in your system.