ccikara Absent Member.
Absent Member.
247 views

Query Not Returning Anything...


Hi all,

I seem to keep struggling on these DAL queries when I make my own query
and entity in the DAL... I must not understand something...

What I want to achieve is for the workflow initiator to be able to
search for a group that is contained within the vault, these groups are
nested groups as they contain other groups as members...
This workflow will allow the initiator to manage these groups
(PositionTitleGroups) by adding or removing other groups
(PositionTitle).

Here is my current configuration with links to screenshots... NOTE: I
only want to search at the moment... I also want to return the CN of the
result...

NESTEDGROUP ENTITY:
'ImageShack® - Online Photo and Video Hosting'
(http://imageshack.us/photo/my-images/703/nestedgroup.png/)


I THEN ADDED ATTRIBUTES TO THE ENTITY

'ImageShack® - Online Photo and Video Hosting'
(http://imageshack.us/photo/my-images/405/nestedgroupgroupmember.png/)

'ImageShack® - Online Photo and Video Hosting'
(http://imageshack.us/photo/my-images/214/nestedgroupgroupmembers.png/)

'ImageShack® - Online Photo and Video Hosting'
(http://imageshack.us/photo/my-images/835/nestedgroupdescription.png/)

'ImageShack® - Online Photo and Video Hosting'
(http://imageshack.us/photo/my-images/534/nestedgroupcn.png/)

'ImageShack® - Online Photo and Video Hosting'
(http://imageshack.us/photo/my-images/208/nestedgroupnestedconfig.png/)

HERE IS THE QUERY:
'ImageShack® - Online Photo and Video Hosting'
(http://imageshack.us/photo/my-images/32/queryf.png/)

THIS IS THE CODE I AM USING (LOOK AT THE ONLOAD NOT THE DOQUERY EVENT
FOR NOW...):
'ImageShack® - Online Photo and Video Hosting'
(http://imageshack.us/photo/my-images/196/onload.png/)
The field groupName is a PickList with data type "string"

Now, when the form loads, the picklist remains empty...

When I increase the logging level of the UserApp I can see the query
being made, and the query is what I expected... i.e.
(&(objectClass=groupOfNames)(cn=*))

But nothing is returned...

I assume I have something configured incorrectly... I have flushed the
cache numerous times and with each DAL configuration change...


Code:
--------------------
2012-03-26 10:13:34,338 INFO [STDOUT] (http-0.0.0.0-8180-3) DEBUG [RBPM] [com.novell.srvprv.impl.vdata.model.VirtualDataAccess:getLdapAttributes] VDA.checking if object instance contains the requi
red objectClass per DAL definition: sys-provisioning-request
2012-03-26 10:13:34,338 INFO [STDOUT] (http-0.0.0.0-8180-3) 323980710 [http-0.0.0.0-8180-3] DEBUG com.novell.srvprv.impl.vdata.model.VirtualDataAccess - VDA.checking if object instance contains t
he required objectClass per DAL definition: sys-provisioning-request
2012-03-26 10:13:34,338 INFO [STDOUT] (http-0.0.0.0-8180-3) DEBUG [RBPM] [com.novell.srvprv.impl.vdata.model.VirtualDataAccess:getLdapAttributes] VDA.does contain required (search=true or auxillia
ry=false) objectClass:srvprvRequest
2012-03-26 10:13:34,338 INFO [STDOUT] (http-0.0.0.0-8180-3) 323980711 [http-0.0.0.0-8180-3] DEBUG com.novell.srvprv.impl.vdata.model.VirtualDataAccess - VDA.does contain required (search=true or
auxilliary=false) objectClass:srvprvRequest
2012-03-26 10:13:34,338 INFO [STDOUT] (http-0.0.0.0-8180-3) DEBUG [RBPM] [com.novell.srvprv.impl.vdata.model.VirtualDataAccess:getLdapAttributes] VDA.object instance is correct type
2012-03-26 10:13:34,339 INFO [STDOUT] (http-0.0.0.0-8180-3) 323980711 [http-0.0.0.0-8180-3] DEBUG com.novell.srvprv.impl.vdata.model.VirtualDataAccess - VDA.object instance is correct type
2012-03-26 10:13:34,339 INFO [STDOUT] (http-0.0.0.0-8180-3) DEBUG [RBPM] [com.novell.srvprv.impl.vdata.model.VirtualDataModel:getEntityDefinition] VDM.getEntityDefinition(String, Locale):sys-provi
sioning-request
2012-03-26 10:13:34,339 INFO [STDOUT] (http-0.0.0.0-8180-3) 323980712 [http-0.0.0.0-8180-3] DEBUG com.novell.srvprv.impl.vdata.model.VirtualDataModel - VDM.getEntityDefinition(String, Locale):sys
-provisioning-request
2012-03-26 10:13:34,683 INFO [STDOUT] (http-0.0.0.0-8180-3) DEBUG [RBPM] [com.novell.srvprv.impl.vdata.model.VirtualDataAccess:getEntityResultList] VDA.getEntityResultList
2012-03-26 10:13:34,683 INFO [STDOUT] (http-0.0.0.0-8180-3) 323981055 [http-0.0.0.0-8180-3] DEBUG com.novell.srvprv.impl.vdata.model.VirtualDataAccess - VDA.getEntityResultList
2012-03-26 10:13:34,683 INFO [STDOUT] (http-0.0.0.0-8180-3) DEBUG [RBPM] [com.novell.srvprv.impl.vdata.model.VirtualDataModel:getEntityDefinition] VDM.getEntityDefinition(String, Locale):nestedGro
up
2012-03-26 10:13:34,683 INFO [STDOUT] (http-0.0.0.0-8180-3) 323981056 [http-0.0.0.0-8180-3] DEBUG com.novell.srvprv.impl.vdata.model.VirtualDataModel - VDM.getEntityDefinition(String, Locale):nes
tedGroup
2012-03-26 10:13:34,684 INFO [STDOUT] (http-0.0.0.0-8180-3) DEBUG [RBPM] [com.novell.srvprv.impl.vdata.model.VirtualDataAccess:resolveLdapFilter] Dynamically query with paramter substition: (cn=*)
2012-03-26 10:13:34,684 INFO [STDOUT] (http-0.0.0.0-8180-3) 323981056 [http-0.0.0.0-8180-3] DEBUG com.novell.srvprv.impl.vdata.model.VirtualDataAccess - Dynamically query with paramter substition
: (cn=*)
2012-03-26 10:13:34,684 INFO [STDOUT] (http-0.0.0.0-8180-3) DEBUG [RBPM] [com.novell.srvprv.impl.vdata.model.VirtualDataAccess:buildEntityFilter] VDA.getEntityResultList query filter: (&(objectCla
ss=groupOfNames)(cn=*))
2012-03-26 10:13:34,684 INFO [STDOUT] (http-0.0.0.0-8180-3) 323981057 [http-0.0.0.0-8180-3] DEBUG com.novell.srvprv.impl.vdata.model.VirtualDataAccess - VDA.getEntityResultList query filter: (&(o
bjectClass=groupOfNames)(cn=*))
--------------------


--
ccikara
------------------------------------------------------------------------
ccikara's Profile: http://forums.novell.com/member.php?userid=86966
View this thread: http://forums.novell.com/showthread.php?t=453883

Labels (1)
0 Likes
4 Replies
mkreim Absent Member.
Absent Member.

Re: Query Not Returning Anything...

Did you grant eDirectory rights to the users?
What does LDAP trace show?

Greetings
Matthias


Am 26.03.2012 10:26, schrieb ccikara:
>
> Hi all,
>
> I seem to keep struggling on these DAL queries when I make my own query
> and entity in the DAL... I must not understand something...
>
> What I want to achieve is for the workflow initiator to be able to
> search for a group that is contained within the vault, these groups are
> nested groups as they contain other groups as members...
> This workflow will allow the initiator to manage these groups
> (PositionTitleGroups) by adding or removing other groups
> (PositionTitle).
>
> Here is my current configuration with links to screenshots... NOTE: I
> only want to search at the moment... I also want to return the CN of the
> result...
>
> NESTEDGROUP ENTITY:
> 'ImageShack® - Online Photo and Video Hosting'
> (http://imageshack.us/photo/my-images/703/nestedgroup.png/)
>
>
> I THEN ADDED ATTRIBUTES TO THE ENTITY
>
> 'ImageShack® - Online Photo and Video Hosting'
> (http://imageshack.us/photo/my-images/405/nestedgroupgroupmember.png/)
>
> 'ImageShack® - Online Photo and Video Hosting'
> (http://imageshack.us/photo/my-images/214/nestedgroupgroupmembers.png/)
>
> 'ImageShack® - Online Photo and Video Hosting'
> (http://imageshack.us/photo/my-images/835/nestedgroupdescription.png/)
>
> 'ImageShack® - Online Photo and Video Hosting'
> (http://imageshack.us/photo/my-images/534/nestedgroupcn.png/)
>
> 'ImageShack® - Online Photo and Video Hosting'
> (http://imageshack.us/photo/my-images/208/nestedgroupnestedconfig.png/)
>
> HERE IS THE QUERY:
> 'ImageShack® - Online Photo and Video Hosting'
> (http://imageshack.us/photo/my-images/32/queryf.png/)
>
> THIS IS THE CODE I AM USING (LOOK AT THE ONLOAD NOT THE DOQUERY EVENT
> FOR NOW...):
> 'ImageShack® - Online Photo and Video Hosting'
> (http://imageshack.us/photo/my-images/196/onload.png/)
> The field groupName is a PickList with data type "string"
>
> Now, when the form loads, the picklist remains empty...
>
> When I increase the logging level of the UserApp I can see the query
> being made, and the query is what I expected... i.e.
> (&(objectClass=groupOfNames)(cn=*))
>
> But nothing is returned...
>
> I assume I have something configured incorrectly... I have flushed the
> cache numerous times and with each DAL configuration change...
>
>
> Code:
> --------------------
> 2012-03-26 10:13:34,338 INFO [STDOUT] (http-0.0.0.0-8180-3) DEBUG [RBPM] [com.novell.srvprv.impl.vdata.model.VirtualDataAccess:getLdapAttributes] VDA.checking if object instance contains the requi
> red objectClass per DAL definition: sys-provisioning-request
> 2012-03-26 10:13:34,338 INFO [STDOUT] (http-0.0.0.0-8180-3) 323980710 [http-0.0.0.0-8180-3] DEBUG com.novell.srvprv.impl.vdata.model.VirtualDataAccess - VDA.checking if object instance contains t
> he required objectClass per DAL definition: sys-provisioning-request
> 2012-03-26 10:13:34,338 INFO [STDOUT] (http-0.0.0.0-8180-3) DEBUG [RBPM] [com.novell.srvprv.impl.vdata.model.VirtualDataAccess:getLdapAttributes] VDA.does contain required (search=true or auxillia
> ry=false) objectClass:srvprvRequest
> 2012-03-26 10:13:34,338 INFO [STDOUT] (http-0.0.0.0-8180-3) 323980711 [http-0.0.0.0-8180-3] DEBUG com.novell.srvprv.impl.vdata.model.VirtualDataAccess - VDA.does contain required (search=true or
> auxilliary=false) objectClass:srvprvRequest
> 2012-03-26 10:13:34,338 INFO [STDOUT] (http-0.0.0.0-8180-3) DEBUG [RBPM] [com.novell.srvprv.impl.vdata.model.VirtualDataAccess:getLdapAttributes] VDA.object instance is correct type
> 2012-03-26 10:13:34,339 INFO [STDOUT] (http-0.0.0.0-8180-3) 323980711 [http-0.0.0.0-8180-3] DEBUG com.novell.srvprv.impl.vdata.model.VirtualDataAccess - VDA.object instance is correct type
> 2012-03-26 10:13:34,339 INFO [STDOUT] (http-0.0.0.0-8180-3) DEBUG [RBPM] [com.novell.srvprv.impl.vdata.model.VirtualDataModel:getEntityDefinition] VDM.getEntityDefinition(String, Locale):sys-provi
> sioning-request
> 2012-03-26 10:13:34,339 INFO [STDOUT] (http-0.0.0.0-8180-3) 323980712 [http-0.0.0.0-8180-3] DEBUG com.novell.srvprv.impl.vdata.model.VirtualDataModel - VDM.getEntityDefinition(String, Locale):sys
> -provisioning-request
> 2012-03-26 10:13:34,683 INFO [STDOUT] (http-0.0.0.0-8180-3) DEBUG [RBPM] [com.novell.srvprv.impl.vdata.model.VirtualDataAccess:getEntityResultList] VDA.getEntityResultList
> 2012-03-26 10:13:34,683 INFO [STDOUT] (http-0.0.0.0-8180-3) 323981055 [http-0.0.0.0-8180-3] DEBUG com.novell.srvprv.impl.vdata.model.VirtualDataAccess - VDA.getEntityResultList
> 2012-03-26 10:13:34,683 INFO [STDOUT] (http-0.0.0.0-8180-3) DEBUG [RBPM] [com.novell.srvprv.impl.vdata.model.VirtualDataModel:getEntityDefinition] VDM.getEntityDefinition(String, Locale):nestedGro
> up
> 2012-03-26 10:13:34,683 INFO [STDOUT] (http-0.0.0.0-8180-3) 323981056 [http-0.0.0.0-8180-3] DEBUG com.novell.srvprv.impl.vdata.model.VirtualDataModel - VDM.getEntityDefinition(String, Locale):nes
> tedGroup
> 2012-03-26 10:13:34,684 INFO [STDOUT] (http-0.0.0.0-8180-3) DEBUG [RBPM] [com.novell.srvprv.impl.vdata.model.VirtualDataAccess:resolveLdapFilter] Dynamically query with paramter substition: (cn=*)
> 2012-03-26 10:13:34,684 INFO [STDOUT] (http-0.0.0.0-8180-3) 323981056 [http-0.0.0.0-8180-3] DEBUG com.novell.srvprv.impl.vdata.model.VirtualDataAccess - Dynamically query with paramter substition
> : (cn=*)
> 2012-03-26 10:13:34,684 INFO [STDOUT] (http-0.0.0.0-8180-3) DEBUG [RBPM] [com.novell.srvprv.impl.vdata.model.VirtualDataAccess:buildEntityFilter] VDA.getEntityResultList query filter: (&(objectCla
> ss=groupOfNames)(cn=*))
> 2012-03-26 10:13:34,684 INFO [STDOUT] (http-0.0.0.0-8180-3) 323981057 [http-0.0.0.0-8180-3] DEBUG com.novell.srvprv.impl.vdata.model.VirtualDataAccess - VDA.getEntityResultList query filter: (&(o
> bjectClass=groupOfNames)(cn=*))
> --------------------
>
>


0 Likes
ccikara Absent Member.
Absent Member.

Re: Query Not Returning Anything...


Thanks for the reply.

What do you mean by LDAP trace?

Also, the user that I am testing the workflow with is the userApp
admin, and when I run the LDAP query that appears in the server.log with
the userapp admin I get a result, so the user definitely has the correct
rights to the directory...
The problem seems that there is no returning attribute for the query...
I did have this previously with another query (for users) then I changed
firstname and surname to "required" in the custom entity definition and
that solved the problem... But as you can see, I have description and cn
as required for this entity definition and still no luck...

Can you suggest any other packages I can set to logging level TRACE so
I can get more information?


--
ccikara
------------------------------------------------------------------------
ccikara's Profile: http://forums.novell.com/member.php?userid=86966
View this thread: http://forums.novell.com/showthread.php?t=453883

0 Likes
mkreim Absent Member.
Absent Member.

Re: Query Not Returning Anything...

Use dstrace for LDAP trace of your eDir server. This shows the query and
the results returned.
Also if you receive a result which is empty but should contain values it
is very likley that your users do not have necessary rights assigned.
I would use a LDAP browser to verify rights assignments by sending the
query with the admin and another user.

Also your onload expression will never set any values. You have to use
the field.setValues() function.


Am 26.03.2012 11:46, schrieb ccikara:
>
> Thanks for the reply.
>
> What do you mean by LDAP trace?
>
> Also, the user that I am testing the workflow with is the userApp
> admin, and when I run the LDAP query that appears in the server.log with
> the userapp admin I get a result, so the user definitely has the correct
> rights to the directory...
> The problem seems that there is no returning attribute for the query...
> I did have this previously with another query (for users) then I changed
> firstname and surname to "required" in the custom entity definition and
> that solved the problem... But as you can see, I have description and cn
> as required for this entity definition and still no luck...
>
> Can you suggest any other packages I can set to logging level TRACE so
> I can get more information?
>
>


0 Likes
ccikara Absent Member.
Absent Member.

Re: Query Not Returning Anything...


hmmm... Seems that the userapp admin did not have the correct rights to
view the attribute I was trying to return...

Sorry for the false alarm!


--
ccikara
------------------------------------------------------------------------
ccikara's Profile: http://forums.novell.com/member.php?userid=86966
View this thread: http://forums.novell.com/showthread.php?t=453883

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.