seba4

Captain
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2018-09-19
12:32
489 views
JDBC driver and Entitlement Query Groups
Hi i am trying to setup Entitlement query procedure and it kinda works, but the problem is that only first record is saved/visible inside IDMProv - Resource Catalog.
Does anyone have any idea why only first record is saved? What did i miss? What can i check?
This is the end of logs
[HTML]
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20180222_0550" instance="Marknet DEV" version="4.1.0.0">DirXML Driver for JDBC</product>
<contact>NetIQ Corporation</contact>
</source>
<output>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">CASH</value>
</attr>
<attr attr-name="DESCR">
<value type="string">CASH DEPARTMENT</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">SNILS</value>
</attr>
<attr attr-name="DESCR">
<value type="string">SNILS</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">SNOPSR</value>
</attr>
<attr attr-name="DESCR">
<value type="string">SNOPS - LESERETTIGHETER</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">SNACSR</value>
</attr>
<attr attr-name="DESCR">
<value type="string">SNACS - LESERETTIGHETER</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">SNICSR</value>
</attr>
<attr attr-name="DESCR">
<value type="string">SNICS - LESERETTIGHETER</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">SNACS1</value>
</attr>
<attr attr-name="DESCR">
<value type="string">SNACS - HOVEDGRUPPE</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">LEDGER</value>
</attr>
<attr attr-name="DESCR">
<value type="string">LEDGER RIGHTS</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">SUBS</value>
</attr>
<attr attr-name="DESCR">
<value type="string">SUBSIDIARIES</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">TRADE</value>
</attr>
<attr attr-name="DESCR">
<value type="string">Trade Controller</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">SIA</value>
</attr>
<attr attr-name="DESCR">
<value type="string">Sissel (example)</value>
</attr>
</instance>
<status event-id="0" level="success">
<operation-data class="marknet_group" operation="query" read-attributes="DESCR,GROUPID"/>
</status>
</output>
</nds>
[09/18/18 15:10:59.574]:Marknet DEV ST:Applying policy: %+C%14CGENLJDBCCOMM-smp%-C.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.589]:Marknet DEV ST:Resolving association references.
[/HTML]
It looks that mapping works fine and I get multiple Groups.
Only this is visible inside IDMProv:
[HTML]
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">CASH</value>
</attr>
<attr attr-name="DESCR">
<value type="string">CASH DEPARTMENT</value>
</attr>
</instance>
[/HTML]
Regards
Sebastjan
Does anyone have any idea why only first record is saved? What did i miss? What can i check?
This is the end of logs
[HTML]
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20180222_0550" instance="Marknet DEV" version="4.1.0.0">DirXML Driver for JDBC</product>
<contact>NetIQ Corporation</contact>
</source>
<output>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">CASH</value>
</attr>
<attr attr-name="DESCR">
<value type="string">CASH DEPARTMENT</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">SNILS</value>
</attr>
<attr attr-name="DESCR">
<value type="string">SNILS</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">SNOPSR</value>
</attr>
<attr attr-name="DESCR">
<value type="string">SNOPS - LESERETTIGHETER</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">SNACSR</value>
</attr>
<attr attr-name="DESCR">
<value type="string">SNACS - LESERETTIGHETER</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">SNICSR</value>
</attr>
<attr attr-name="DESCR">
<value type="string">SNICS - LESERETTIGHETER</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">SNACS1</value>
</attr>
<attr attr-name="DESCR">
<value type="string">SNACS - HOVEDGRUPPE</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">LEDGER</value>
</attr>
<attr attr-name="DESCR">
<value type="string">LEDGER RIGHTS</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">SUBS</value>
</attr>
<attr attr-name="DESCR">
<value type="string">SUBSIDIARIES</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">TRADE</value>
</attr>
<attr attr-name="DESCR">
<value type="string">Trade Controller</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">SIA</value>
</attr>
<attr attr-name="DESCR">
<value type="string">Sissel (example)</value>
</attr>
</instance>
<status event-id="0" level="success">
<operation-data class="marknet_group" operation="query" read-attributes="DESCR,GROUPID"/>
</status>
</output>
</nds>
[09/18/18 15:10:59.574]:Marknet DEV ST:Applying policy: %+C%14CGENLJDBCCOMM-smp%-C.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.589]:Marknet DEV ST:Resolving association references.
[/HTML]
It looks that mapping works fine and I get multiple Groups.
Only this is visible inside IDMProv:
[HTML]
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">CASH</value>
</attr>
<attr attr-name="DESCR">
<value type="string">CASH DEPARTMENT</value>
</attr>
</instance>
[/HTML]
Regards
Sebastjan
2 Replies


Knowledge Partner
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2018-09-21
14:58
seba4;2487772 wrote:
Hi i am trying to setup Entitlement query procedure and it kinda works, but the problem is that only first record is saved/visible inside IDMProv - Resource Catalog.
Does anyone have any idea why only first record is saved? What did i miss? What can i check?
This is the end of logs
[HTML]
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20180222_0550" instance="Marknet DEV" version="4.1.0.0">DirXML Driver for JDBC</product>
<contact>NetIQ Corporation</contact>
</source>
<output>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">CASH</value>
</attr>
<attr attr-name="DESCR">
<value type="string">CASH DEPARTMENT</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">SNILS</value>
</attr>
<attr attr-name="DESCR">
<value type="string">SNILS</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">SNOPSR</value>
</attr>
<attr attr-name="DESCR">
<value type="string">SNOPS - LESERETTIGHETER</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">SNACSR</value>
</attr>
<attr attr-name="DESCR">
<value type="string">SNACS - LESERETTIGHETER</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">SNICSR</value>
</attr>
<attr attr-name="DESCR">
<value type="string">SNICS - LESERETTIGHETER</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">SNACS1</value>
</attr>
<attr attr-name="DESCR">
<value type="string">SNACS - HOVEDGRUPPE</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">LEDGER</value>
</attr>
<attr attr-name="DESCR">
<value type="string">LEDGER RIGHTS</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">SUBS</value>
</attr>
<attr attr-name="DESCR">
<value type="string">SUBSIDIARIES</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">TRADE</value>
</attr>
<attr attr-name="DESCR">
<value type="string">Trade Controller</value>
</attr>
</instance>
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">SIA</value>
</attr>
<attr attr-name="DESCR">
<value type="string">Sissel (example)</value>
</attr>
</instance>
<status event-id="0" level="success">
<operation-data class="marknet_group" operation="query" read-attributes="DESCR,GROUPID"/>
</status>
</output>
</nds>
[09/18/18 15:10:59.574]:Marknet DEV ST:Applying policy: %+C%14CGENLJDBCCOMM-smp%-C.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping class-name 'marknet_group' to 'Group'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.574]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'GROUPID' to 'Group ID'.
[09/18/18 15:10:59.589]:Marknet DEV ST: Mapping attr-name 'DESCR' to 'Description'.
[09/18/18 15:10:59.589]:Marknet DEV ST:Resolving association references.
[/HTML]
It looks that mapping works fine and I get multiple Groups.
Only this is visible inside IDMProv:
[HTML]
<instance class-name="marknet_group" event-id="0">
<attr attr-name="GROUPID">
<value type="string">CASH</value>
</attr>
<attr attr-name="DESCR">
<value type="string">CASH DEPARTMENT</value>
</attr>
</instance>
[/HTML]
Regards
Sebastjan
The query reply looks ok to me. Now you get to go look at the RBPM log (catalina.out) to see what the code map refresh did with the results it got back.
seba4

Captain
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2018-09-28
12:29
dgersic;2487903 wrote:
The query reply looks ok to me. Now you get to go look at the RBPM log (catalina.out) to see what the code map refresh did with the results it got back.
Thanks for your help. This helped me to fix it. The problem was i have modified some attribute names and it looks that i have forgotten to change some for Entitlements. Now i have returned back to original names (idg) and then everything worked like it should.