seba4 Respected Contributor.
Respected Contributor.
438 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
Labels (1)
0 Likes
2 Replies
Knowledge Partner
Knowledge Partner

Re: JDBC driver and Entitlement Query Groups

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.
0 Likes
seba4 Respected Contributor.
Respected Contributor.

Re: JDBC driver and Entitlement Query Groups

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.
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.