Hi,
We are trying to automate pretty much everything to auto install. One of the things we need to setup a category tree during install.
category_tree::add if no default user_id is passed uses [ad_conn user_id]. Naturally that this point there is no user_id yet. I have asked DaveB on what is the proper solution. His opinion is that a category tree should survive without a user_id. This is the plsql that gives the problem.
Transaction aborted: Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")
ERROR: null value in column "grantee_id" violates not-null constraint
CONTEXT: PL/pgSQL function "acs_permission__grant_permission" line 17 at SQL statement
PL/pgSQL function "category_tree__new" line 28 at perform
SQL:
select category_tree__new (
NULL,
NULL,
'Main Site',
'tree for subsite Main Site',
'f',
current_timestamp,
NULL,
'127.0.0.1',
NULL
)
It is granting permission to a null user. Is this really a design flaw? I can edit it not to grant permissions if there is no user_id. I just want to make sure that its the correct design behavior. Thanks.
