ALERT! The community will be read-only starting on April 19, 8am Pacific as the migration begins. Read more for important details.
ALERT! The community will be read-only starting on April 19, 8am Pacific as the migration begins.Read more for important details.
Captain
Captain
845 views

JDBC driver and multiple call-procedure calls.

I was looking for JDBC documentation and i couldn't find how to solve if we get one change and then we need to call procedure x.times.
If i do it once everything works, but if need to call it more than once in one XML then only one works.

Does anyone have any experience how to prepare XML? Do i need multiple statements or one statement with multiple call-procedure calls?

Example: We add roles to user. (ROLE1, ROLE2, ROLE3). This is passed to driver and for each ROLE i need to call ADD_GROUP(ROLE_NAME, USERID) procedure.
Labels (1)
0 Likes
7 Replies
Knowledge Partner Knowledge Partner
Knowledge Partner

seba4 wrote:

> Do i need multiple
> statements or one statement with multiple call-procedure calls?


I'd probably try with separate statements, so that separate status events come
back and see which one failed in case of an error. Other than that: give it a
try and see what works best.

--
http://www.is4it.de/en/solution/identity-access-management/

(If you find this post helpful, please click on the star below.)
______________________________________________
https://www.is4it.de/identity-access-management
0 Likes
Captain
Captain

Thank you for your answer. I have tried both and i preferred separate statements but i had some problem I am still trying to figure why is like that.

If i set same event-id on jdbc:statement then only one procedure is executed, but if i left this attribute out then it works.
0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

seba4;2488186 wrote:
Thank you for your answer. I have tried both and i preferred separate statements but i had some problem I am still trying to figure why is like that.

If i set same event-id on jdbc:statement then only one procedure is executed, but if i left this attribute out then it works.


Post a level 3 trace to show what you're doing. Sanitize it as needed.
0 Likes
Captain
Captain

I have tried multiple options and each has it's own problems:

1.Option where statements are separated and on both statements event-id is clone of main event id:
Problems:
- Only one statement is executed

[HTML]
<nds dtdversion="4.0" ndsversion="8.x">
<source>
<product edition="Advanced" version="4.7.0.0">DirXML</product>
<contact>NetIQ Corporation</contact>
</source>
<input>
<jdbc:statement event-id="basenet015_524-NDS#20180928120842#3#1:6cff2d4a-f485-4982-adc6-0dcba3a48bfd" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:call-procedure jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
<jdbc:param>
<jdbc:value>TSTGNL6</jdbc:value>
</jdbc:param>
<jdbc:param>
<jdbc:value>CASH</jdbc:value>
</jdbc:param>
<jdbc:param/>
<jdbc:param/>
<jdbc:param/>
</jdbc:call-procedure>
<operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user" groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true" operation="modify">
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
</operation-data>
</jdbc:statement>
<jdbc:statement event-id="basenet015_524-NDS#20180928120842#3#1:6cff2d4a-f485-4982-adc6-0dcba3a48bfd" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:call-procedure jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
<jdbc:param>
<jdbc:value>TSTGNL6</jdbc:value>
</jdbc:param>
<jdbc:param>
<jdbc:value>LEDGER</jdbc:value>
</jdbc:param>
<jdbc:param/>
<jdbc:param/>
<jdbc:param/>
</jdbc:call-procedure>
<operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user" groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true" operation="modify">
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
</operation-data>
</jdbc:statement>
</input>
</nds>
[09/28/18 14:08:43.207]:Basenet DEV ST:Stripping operation data from input document
[09/28/18 14:08:43.207]:Basenet DEV ST:{call IDAM.PACK_BASENET_IDAM.ADD_GROUP(?,?,?,?,?)}
[09/28/18 14:08:43.207]:Basenet DEV ST: IN @ index 1, param 'PI_USERNAME', field '$1', length: 7, value = 'TSTGNL6'
[09/28/18 14:08:43.207]:Basenet DEV ST: IN @ index 2, param 'PI_GROUPID', field '$2', length: 4, value = 'CASH'
[09/28/18 14:08:43.207]:Basenet DEV ST: OUT @ index 3, param 'PO_STATUS', field '$3'
[09/28/18 14:08:43.207]:Basenet DEV ST: OUT @ index 4, param 'PO_USERNAME', field '$4'
[09/28/18 14:08:43.207]:Basenet DEV ST: OUT @ index 5, param 'PO_MESSAGE', field '$5'
[09/28/18 14:08:43.207]:Basenet DEV ST: OUT @ index 3, param 'PO_STATUS', field '$3', value = 0
[09/28/18 14:08:43.207]:Basenet DEV ST: OUT @ index 4, param 'PO_USERNAME', field '$4', length: 7, value = 'TSTGNL6'
[09/28/18 14:08:43.207]:Basenet DEV ST: OUT @ index 5, param 'PO_MESSAGE', field '$5', value = null
[09/28/18 14:08:43.207]:Basenet DEV ST:ROLLBACK
[09/28/18 14:08:43.207]:Basenet DEV ST:Restoring operation data to output document
[09/28/18 14:08:43.207]:Basenet DEV ST:SubscriptionShim.execute() returned:
[09/28/18 14:08:43.207]:Basenet DEV ST:
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20180222_0550" instance="Basenet DEV" version="4.1.0.0">DirXML Driver for JDBC</product>
<contact>NetIQ Corporation</contact>
</source>
<output>
<status event-id="basenet015_524-NDS#20180928120842#3#1:6cff2d4a-f485-4982-adc6-0dcba3a48bfd" level="error" type="app-general">
<description>Unable to obtain value(s) from stored procedure 'IDAM.PACK_BASENET_IDAM.ADD_GROUP'. Unable to retrieve statement results.</description>
<jdbc:exception jdbc:class="java.lang.NullPointerException"/>
<jdbc:document xml:space="preserve"><nds dtdversion="4.0" ndsversion="8.x">
<source>
<product edition="Advanced" version="4.7.0.0">DirXML</product>
<contact>NetIQ Corporation</contact>
</source>
<input>
<jdbc:statement event-id="basenet015_524-NDS#20180928120842#3#1:6cff2d4a-f485-4982-adc6-0dcba3a48bfd" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:call-procedure jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
<jdbc:param>
<jdbc:value>TSTGNL6</jdbc:value>
</jdbc:param>
<jdbc:param>
<jdbc:value>CASH</jdbc:value>
</jdbc:param>
<jdbc:param/>
<jdbc:param/>
<jdbc:param/>
</jdbc:call-procedure>
</jdbc:statement>
<jdbc:statement event-id="basenet015_524-NDS#20180928120842#3#1:6cff2d4a-f485-4982-adc6-0dcba3a48bfd_opData0" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:call-procedure jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
<jdbc:param>
<jdbc:value>TSTGNL6</jdbc:value>
</jdbc:param>
<jdbc:param>
<jdbc:value>LEDGER</jdbc:value>
</jdbc:param>
<jdbc:param/>
<jdbc:param/>
<jdbc:param/>
</jdbc:call-procedure>
</jdbc:statement>
</input>
</nds></jdbc:document>
<operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user" groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true" operation="modify">
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
</operation-data>
</status>
</output>
</nds>


[/HTML]


2.Option where statements are separated and statement event-id differs:
Working:
- both queries were executed
Problems:
- We don't receive status from both statements


[HTML]
<nds dtdversion="4.0" ndsversion="8.x">
<source>
<product edition="Advanced" version="4.7.0.0">DirXML</product>
<contact>NetIQ Corporation</contact>
</source>
<input>
<jdbc:statement xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:call-procedure jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
<jdbc:param>
<jdbc:value>TSTGNL6</jdbc:value>
</jdbc:param>
<jdbc:param>
<jdbc:value>CASH</jdbc:value>
</jdbc:param>
<jdbc:param/>
<jdbc:param/>
<jdbc:param/>
</jdbc:call-procedure>
<operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user" groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true" operation="modify">
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
</operation-data>
</jdbc:statement>
<jdbc:statement xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:call-procedure jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
<jdbc:param>
<jdbc:value>TSTGNL6</jdbc:value>
</jdbc:param>
<jdbc:param>
<jdbc:value>LEDGER</jdbc:value>
</jdbc:param>
<jdbc:param/>
<jdbc:param/>
<jdbc:param/>
</jdbc:call-procedure>
<operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user" groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true" operation="modify">
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
</operation-data>
</jdbc:statement>
</input>
</nds>
[09/28/18 14:00:37.859]:Basenet DEV ST:Stripping operation data from input document
[09/28/18 14:00:37.859]:Basenet DEV ST:{call IDAM.PACK_BASENET_IDAM.ADD_GROUP(?,?,?,?,?)}
[09/28/18 14:00:37.859]:Basenet DEV ST: IN @ index 1, param 'PI_USERNAME', field '$1', length: 7, value = 'TSTGNL6'
[09/28/18 14:00:37.859]:Basenet DEV ST: IN @ index 2, param 'PI_GROUPID', field '$2', length: 4, value = 'CASH'
[09/28/18 14:00:37.859]:Basenet DEV ST: OUT @ index 3, param 'PO_STATUS', field '$3'
[09/28/18 14:00:37.859]:Basenet DEV ST: OUT @ index 4, param 'PO_USERNAME', field '$4'
[09/28/18 14:00:37.859]:Basenet DEV ST: OUT @ index 5, param 'PO_MESSAGE', field '$5'
[09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 3, param 'PO_STATUS', field '$3', value = 0
[09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 4, param 'PO_USERNAME', field '$4', length: 7, value = 'TSTGNL6'
[09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 5, param 'PO_MESSAGE', field '$5', value = null
[09/28/18 14:00:37.875]:Basenet DEV ST:{call IDAM.PACK_BASENET_IDAM.ADD_GROUP(?,?,?,?,?)}
[09/28/18 14:00:37.875]:Basenet DEV ST: IN @ index 1, param 'PI_USERNAME', field '$1', length: 7, value = 'TSTGNL6'
[09/28/18 14:00:37.875]:Basenet DEV ST: IN @ index 2, param 'PI_GROUPID', field '$2', length: 6, value = 'LEDGER'
[09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 3, param 'PO_STATUS', field '$3'
[09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 4, param 'PO_USERNAME', field '$4'
[09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 5, param 'PO_MESSAGE', field '$5'
[09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 3, param 'PO_STATUS', field '$3', value = 0
[09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 4, param 'PO_USERNAME', field '$4', length: 7, value = 'TSTGNL6'
[09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 5, param 'PO_MESSAGE', field '$5', value = null
[09/28/18 14:00:37.875]:Basenet DEV ST:ROLLBACK
[09/28/18 14:00:37.875]:Basenet DEV ST:Restoring operation data to output document
[09/28/18 14:00:37.875]:Basenet DEV ST:SubscriptionShim.execute() returned:
[09/28/18 14:00:37.875]:Basenet DEV ST:
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20180222_0550" instance="Basenet DEV" version="4.1.0.0">DirXML Driver for JDBC</product>
<contact>NetIQ Corporation</contact>
</source>
<output>
<jdbc:out-parameters event-id="" jdbc:number-of-params="3">
<jdbc:param/>
<jdbc:param/>
<jdbc:param jdbc:name="PO_STATUS" jdbc:param-type="OUT" jdbc:position="3" jdbc:sql-type="java.sql.Types.DECIMAL">
<jdbc:value>0</jdbc:value>
</jdbc:param>
<jdbc:param jdbc:name="PO_USERNAME" jdbc:param-type="OUT" jdbc:position="4" jdbc:sql-type="java.sql.Types.VARCHAR">
<jdbc:value>TSTGNL6</jdbc:value>
</jdbc:param>
<jdbc:param jdbc:name="PO_MESSAGE" jdbc:param-type="OUT" jdbc:position="5" jdbc:sql-type="java.sql.Types.VARCHAR"/>
<operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user" groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true" operation="modify">
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
</operation-data>
</jdbc:out-parameters>
<status level="success">
<operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user" groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true" operation="modify">
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
</operation-data>
</status>
<status event-id="" level="error" type="app-general">
<description>Unable to obtain value(s) from stored procedure 'IDAM.PACK_BASENET_IDAM.ADD_GROUP'. Unable to retrieve statement results.</description>
<jdbc:exception jdbc:class="java.lang.NullPointerException"/>
<jdbc:document xml:space="preserve"><nds dtdversion="4.0" ndsversion="8.x">
<source>
<product edition="Advanced" version="4.7.0.0">DirXML</product>
<contact>NetIQ Corporation</contact>
</source>
<input>
<jdbc:statement xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:call-procedure jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
<jdbc:param>
<jdbc:value>TSTGNL6</jdbc:value>
</jdbc:param>
<jdbc:param>
<jdbc:value>CASH</jdbc:value>
</jdbc:param>
<jdbc:param/>
<jdbc:param/>
<jdbc:param/>
</jdbc:call-procedure>
</jdbc:statement>
<jdbc:statement event-id="_opData0" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:call-procedure jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
<jdbc:param>
<jdbc:value>TSTGNL6</jdbc:value>
</jdbc:param>
<jdbc:param>
<jdbc:value>LEDGER</jdbc:value>
</jdbc:param>
<jdbc:param/>
<jdbc:param/>
<jdbc:param/>
</jdbc:call-procedure>
</jdbc:statement>
</input>
</nds></jdbc:document>
<operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user" groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true" operation="modify">
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
</operation-data>
</status>
</output>
</nds>
[/HTML]


3.Option where we separate statements into 2 documents. (nds)
Working:
Problems:
- Only one statement is executed


[HTML]
<nds dtdversion="4.0" ndsversion="8.x">
<source>
<product edition="Advanced" version="4.7.0.0">DirXML</product>
<contact>NetIQ Corporation</contact>
</source>
<input>
<jdbc:statement event-id="basenet015_524-NDS#20180928150452#3#1:b6cddf3f-22b2-4183-9015-848b7669eb5b" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:call-procedure jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
<jdbc:param>
<jdbc:value>TSTGNL6</jdbc:value>
</jdbc:param>
<jdbc:param>
<jdbc:value>CASH</jdbc:value>
</jdbc:param>
<jdbc:param/>
<jdbc:param/>
<jdbc:param/>
</jdbc:call-procedure>
<operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user" groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true" operation="modify">
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
</operation-data>
</jdbc:statement>
</input>
</nds>
<nds dtdversion="4.0" ndsversion="8.x">
<source>
<product edition="Advanced" version="4.7.0.0">DirXML</product>
<contact>NetIQ Corporation</contact>
</source>
<input>
<jdbc:statement event-id="basenet015_524-NDS#20180928150452#3#1:b6cddf3f-22b2-4183-9015-848b7669eb5b" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:call-procedure jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
<jdbc:param>
<jdbc:value>TSTGNL6</jdbc:value>
</jdbc:param>
<jdbc:param>
<jdbc:value>LEDGER</jdbc:value>
</jdbc:param>
<jdbc:param/>
<jdbc:param/>
<jdbc:param/>
</jdbc:call-procedure>
<operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user" groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true" operation="modify">
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
</operation-data>
</jdbc:statement>
</input>
</nds>
[09/28/18 17:04:52.612]:Basenet DEV ST:Stripping operation data from input document
[09/28/18 17:04:52.612]:Basenet DEV ST:Fetching metadata for routine 'idam.PACK_BASENET_IDAM.ADD_GROUP'.
[09/28/18 17:04:52.612]:Basenet DEV ST:{call idam.PACK_BASENET_IDAM.ADD_GROUP(?,?,?,?,?)}
[09/28/18 17:04:52.612]:Basenet DEV ST: IN @ index 1, param 'PI_USERNAME', field '$1', length: 7, value = 'TSTGNL6'
[09/28/18 17:04:52.612]:Basenet DEV ST: IN @ index 2, param 'PI_GROUPID', field '$2', length: 4, value = 'CASH'
[09/28/18 17:04:52.612]:Basenet DEV ST: OUT @ index 3, param 'PO_STATUS', field '$3'
[09/28/18 17:04:52.612]:Basenet DEV ST: OUT @ index 4, param 'PO_USERNAME', field '$4'
[09/28/18 17:04:52.612]:Basenet DEV ST: OUT @ index 5, param 'PO_MESSAGE', field '$5'
[09/28/18 17:04:52.628]:Basenet DEV ST: OUT @ index 3, param 'PO_STATUS', field '$3', value = 0
[09/28/18 17:04:52.628]:Basenet DEV ST: OUT @ index 4, param 'PO_USERNAME', field '$4', length: 7, value = 'TSTGNL6'
[09/28/18 17:04:52.628]:Basenet DEV ST: OUT @ index 5, param 'PO_MESSAGE', field '$5', value = null
[09/28/18 17:04:52.628]:Basenet DEV ST:Restoring operation data to output document
[09/28/18 17:04:52.628]:Basenet DEV ST:SubscriptionShim.execute() returned:
[09/28/18 17:04:52.628]:Basenet DEV ST:
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20180222_0550" instance="Basenet DEV" version="4.1.0.0">DirXML Driver for JDBC</product>
<contact>NetIQ Corporation</contact>
</source>
<output>
<jdbc:out-parameters event-id="basenet015_524-NDS#20180928150452#3#1:b6cddf3f-22b2-4183-9015-848b7669eb5b" jdbc:number-of-params="3">
<jdbc:param/>
<jdbc:param/>
<jdbc:param jdbc:name="PO_STATUS" jdbc:param-type="OUT" jdbc:position="3" jdbc:sql-type="java.sql.Types.DECIMAL">
<jdbc:value>0</jdbc:value>
</jdbc:param>
<jdbc:param jdbc:name="PO_USERNAME" jdbc:param-type="OUT" jdbc:position="4" jdbc:sql-type="java.sql.Types.VARCHAR">
<jdbc:value>TSTGNL6</jdbc:value>
</jdbc:param>
<jdbc:param jdbc:name="PO_MESSAGE" jdbc:param-type="OUT" jdbc:position="5" jdbc:sql-type="java.sql.Types.VARCHAR"/>
<operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user" groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true" operation="modify">
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
</operation-data>
</jdbc:out-parameters>
<status event-id="basenet015_524-NDS#20180928150452#3#1:b6cddf3f-22b2-4183-9015-848b7669eb5b" level="success">
<operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user" groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true" operation="modify">
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
</operation-data>
</status>
</output>
</nds>
[/HTML]
0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

seba4;2488280 wrote:
I have tried multiple options and each has it's own problems:

1.Option where statements are separated and on both statements event-id is clone of main event id:
Problems:
- Only one statement is executed

[HTML]
<nds dtdversion="4.0" ndsversion="8.x">
<source>
<product edition="Advanced" version="4.7.0.0">DirXML</product>
<contact>NetIQ Corporation</contact>
</source>
<input>
<jdbc:statement event-id="basenet015_524-NDS#20180928120842#3#1:6cff2d4a-f485-4982-adc6-0dcba3a48bfd" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:call-procedure jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
<jdbc:param>
<jdbc:value>TSTGNL6</jdbc:value>
</jdbc:param>
<jdbc:param>
<jdbc:value>CASH</jdbc:value>
</jdbc:param>
<jdbc:param/>
<jdbc:param/>
<jdbc:param/>
</jdbc:call-procedure>
<operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user" groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true" operation="modify">
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
</operation-data>
</jdbc:statement>
<jdbc:statement event-id="basenet015_524-NDS#20180928120842#3#1:6cff2d4a-f485-4982-adc6-0dcba3a48bfd" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:call-procedure jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
<jdbc:param>
<jdbc:value>TSTGNL6</jdbc:value>
</jdbc:param>
<jdbc:param>
<jdbc:value>LEDGER</jdbc:value>
</jdbc:param>
<jdbc:param/>
<jdbc:param/>
<jdbc:param/>
</jdbc:call-procedure>
<operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user" groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true" operation="modify">
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
</operation-data>
</jdbc:statement>
</input>
</nds>
[09/28/18 14:08:43.207]:Basenet DEV ST:Stripping operation data from input document
[09/28/18 14:08:43.207]:Basenet DEV ST:{call IDAM.PACK_BASENET_IDAM.ADD_GROUP(?,?,?,?,?)}
[09/28/18 14:08:43.207]:Basenet DEV ST: IN @ index 1, param 'PI_USERNAME', field '$1', length: 7, value = 'TSTGNL6'
[09/28/18 14:08:43.207]:Basenet DEV ST: IN @ index 2, param 'PI_GROUPID', field '$2', length: 4, value = 'CASH'
[09/28/18 14:08:43.207]:Basenet DEV ST: OUT @ index 3, param 'PO_STATUS', field '$3'
[09/28/18 14:08:43.207]:Basenet DEV ST: OUT @ index 4, param 'PO_USERNAME', field '$4'
[09/28/18 14:08:43.207]:Basenet DEV ST: OUT @ index 5, param 'PO_MESSAGE', field '$5'
[09/28/18 14:08:43.207]:Basenet DEV ST: OUT @ index 3, param 'PO_STATUS', field '$3', value = 0
[09/28/18 14:08:43.207]:Basenet DEV ST: OUT @ index 4, param 'PO_USERNAME', field '$4', length: 7, value = 'TSTGNL6'
[09/28/18 14:08:43.207]:Basenet DEV ST: OUT @ index 5, param 'PO_MESSAGE', field '$5', value = null
[09/28/18 14:08:43.207]:Basenet DEV ST:ROLLBACK
[09/28/18 14:08:43.207]:Basenet DEV ST:Restoring operation data to output document
[09/28/18 14:08:43.207]:Basenet DEV ST:SubscriptionShim.execute() returned:
[09/28/18 14:08:43.207]:Basenet DEV ST:
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20180222_0550" instance="Basenet DEV" version="4.1.0.0">DirXML Driver for JDBC</product>
<contact>NetIQ Corporation</contact>
</source>
<output>
<status event-id="basenet015_524-NDS#20180928120842#3#1:6cff2d4a-f485-4982-adc6-0dcba3a48bfd" level="error" type="app-general">
<description>Unable to obtain value(s) from stored procedure 'IDAM.PACK_BASENET_IDAM.ADD_GROUP'. Unable to retrieve statement results.</description>
<jdbc:exception jdbc:class="java.lang.NullPointerException"/>
<jdbc:document xml:space="preserve"><nds dtdversion="4.0" ndsversion="8.x">
<source>
<product edition="Advanced" version="4.7.0.0">DirXML</product>
<contact>NetIQ Corporation</contact>
</source>
<input>
<jdbc:statement event-id="basenet015_524-NDS#20180928120842#3#1:6cff2d4a-f485-4982-adc6-0dcba3a48bfd" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:call-procedure jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
<jdbc:param>
<jdbc:value>TSTGNL6</jdbc:value>
</jdbc:param>
<jdbc:param>
<jdbc:value>CASH</jdbc:value>
</jdbc:param>
<jdbc:param/>
<jdbc:param/>
<jdbc:param/>
</jdbc:call-procedure>
</jdbc:statement>
<jdbc:statement event-id="basenet015_524-NDS#20180928120842#3#1:6cff2d4a-f485-4982-adc6-0dcba3a48bfd_opData0" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:call-procedure jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
<jdbc:param>
<jdbc:value>TSTGNL6</jdbc:value>
</jdbc:param>
<jdbc:param>
<jdbc:value>LEDGER</jdbc:value>
</jdbc:param>
<jdbc:param/>
<jdbc:param/>
<jdbc:param/>
</jdbc:call-procedure>
</jdbc:statement>
</input>
</nds></jdbc:document>
<operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user" groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true" operation="modify">
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
</operation-data>
</status>
</output>
</nds>


[/HTML]


2.Option where statements are separated and statement event-id differs:
Working:
- both queries were executed
Problems:
- We don't receive status from both statements


[HTML]
<nds dtdversion="4.0" ndsversion="8.x">
<source>
<product edition="Advanced" version="4.7.0.0">DirXML</product>
<contact>NetIQ Corporation</contact>
</source>
<input>
<jdbc:statement xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:call-procedure jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
<jdbc:param>
<jdbc:value>TSTGNL6</jdbc:value>
</jdbc:param>
<jdbc:param>
<jdbc:value>CASH</jdbc:value>
</jdbc:param>
<jdbc:param/>
<jdbc:param/>
<jdbc:param/>
</jdbc:call-procedure>
<operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user" groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true" operation="modify">
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
</operation-data>
</jdbc:statement>
<jdbc:statement xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:call-procedure jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
<jdbc:param>
<jdbc:value>TSTGNL6</jdbc:value>
</jdbc:param>
<jdbc:param>
<jdbc:value>LEDGER</jdbc:value>
</jdbc:param>
<jdbc:param/>
<jdbc:param/>
<jdbc:param/>
</jdbc:call-procedure>
<operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user" groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true" operation="modify">
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
</operation-data>
</jdbc:statement>
</input>
</nds>
[09/28/18 14:00:37.859]:Basenet DEV ST:Stripping operation data from input document
[09/28/18 14:00:37.859]:Basenet DEV ST:{call IDAM.PACK_BASENET_IDAM.ADD_GROUP(?,?,?,?,?)}
[09/28/18 14:00:37.859]:Basenet DEV ST: IN @ index 1, param 'PI_USERNAME', field '$1', length: 7, value = 'TSTGNL6'
[09/28/18 14:00:37.859]:Basenet DEV ST: IN @ index 2, param 'PI_GROUPID', field '$2', length: 4, value = 'CASH'
[09/28/18 14:00:37.859]:Basenet DEV ST: OUT @ index 3, param 'PO_STATUS', field '$3'
[09/28/18 14:00:37.859]:Basenet DEV ST: OUT @ index 4, param 'PO_USERNAME', field '$4'
[09/28/18 14:00:37.859]:Basenet DEV ST: OUT @ index 5, param 'PO_MESSAGE', field '$5'
[09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 3, param 'PO_STATUS', field '$3', value = 0
[09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 4, param 'PO_USERNAME', field '$4', length: 7, value = 'TSTGNL6'
[09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 5, param 'PO_MESSAGE', field '$5', value = null
[09/28/18 14:00:37.875]:Basenet DEV ST:{call IDAM.PACK_BASENET_IDAM.ADD_GROUP(?,?,?,?,?)}
[09/28/18 14:00:37.875]:Basenet DEV ST: IN @ index 1, param 'PI_USERNAME', field '$1', length: 7, value = 'TSTGNL6'
[09/28/18 14:00:37.875]:Basenet DEV ST: IN @ index 2, param 'PI_GROUPID', field '$2', length: 6, value = 'LEDGER'
[09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 3, param 'PO_STATUS', field '$3'
[09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 4, param 'PO_USERNAME', field '$4'
[09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 5, param 'PO_MESSAGE', field '$5'
[09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 3, param 'PO_STATUS', field '$3', value = 0
[09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 4, param 'PO_USERNAME', field '$4', length: 7, value = 'TSTGNL6'
[09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 5, param 'PO_MESSAGE', field '$5', value = null
[09/28/18 14:00:37.875]:Basenet DEV ST:ROLLBACK
[09/28/18 14:00:37.875]:Basenet DEV ST:Restoring operation data to output document
[09/28/18 14:00:37.875]:Basenet DEV ST:SubscriptionShim.execute() returned:
[09/28/18 14:00:37.875]:Basenet DEV ST:
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20180222_0550" instance="Basenet DEV" version="4.1.0.0">DirXML Driver for JDBC</product>
<contact>NetIQ Corporation</contact>
</source>
<output>
<jdbc:out-parameters event-id="" jdbc:number-of-params="3">
<jdbc:param/>
<jdbc:param/>
<jdbc:param jdbc:name="PO_STATUS" jdbc:param-type="OUT" jdbc:position="3" jdbc:sql-type="java.sql.Types.DECIMAL">
<jdbc:value>0</jdbc:value>
</jdbc:param>
<jdbc:param jdbc:name="PO_USERNAME" jdbc:param-type="OUT" jdbc:position="4" jdbc:sql-type="java.sql.Types.VARCHAR">
<jdbc:value>TSTGNL6</jdbc:value>
</jdbc:param>
<jdbc:param jdbc:name="PO_MESSAGE" jdbc:param-type="OUT" jdbc:position="5" jdbc:sql-type="java.sql.Types.VARCHAR"/>
<operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user" groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true" operation="modify">
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
</operation-data>
</jdbc:out-parameters>
<status level="success">
<operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user" groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true" operation="modify">
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
</operation-data>
</status>
<status event-id="" level="error" type="app-general">
<description>Unable to obtain value(s) from stored procedure 'IDAM.PACK_BASENET_IDAM.ADD_GROUP'. Unable to retrieve statement results.</description>
<jdbc:exception jdbc:class="java.lang.NullPointerException"/>
<jdbc:document xml:space="preserve"><nds dtdversion="4.0" ndsversion="8.x">
<source>
<product edition="Advanced" version="4.7.0.0">DirXML</product>
<contact>NetIQ Corporation</contact>
</source>
<input>
<jdbc:statement xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:call-procedure jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
<jdbc:param>
<jdbc:value>TSTGNL6</jdbc:value>
</jdbc:param>
<jdbc:param>
<jdbc:value>CASH</jdbc:value>
</jdbc:param>
<jdbc:param/>
<jdbc:param/>
<jdbc:param/>
</jdbc:call-procedure>
</jdbc:statement>
<jdbc:statement event-id="_opData0" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:call-procedure jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
<jdbc:param>
<jdbc:value>TSTGNL6</jdbc:value>
</jdbc:param>
<jdbc:param>
<jdbc:value>LEDGER</jdbc:value>
</jdbc:param>
<jdbc:param/>
<jdbc:param/>
<jdbc:param/>
</jdbc:call-procedure>
</jdbc:statement>
</input>
</nds></jdbc:document>
<operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user" groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true" operation="modify">
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
</operation-data>
</status>
</output>
</nds>
[/HTML]


3.Option where we separate statements into 2 documents. (nds)
Working:
Problems:
- Only one statement is executed


[HTML]
<nds dtdversion="4.0" ndsversion="8.x">
<source>
<product edition="Advanced" version="4.7.0.0">DirXML</product>
<contact>NetIQ Corporation</contact>
</source>
<input>
<jdbc:statement event-id="basenet015_524-NDS#20180928150452#3#1:b6cddf3f-22b2-4183-9015-848b7669eb5b" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:call-procedure jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
<jdbc:param>
<jdbc:value>TSTGNL6</jdbc:value>
</jdbc:param>
<jdbc:param>
<jdbc:value>CASH</jdbc:value>
</jdbc:param>
<jdbc:param/>
<jdbc:param/>
<jdbc:param/>
</jdbc:call-procedure>
<operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user" groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true" operation="modify">
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
</operation-data>
</jdbc:statement>
</input>
</nds>
<nds dtdversion="4.0" ndsversion="8.x">
<source>
<product edition="Advanced" version="4.7.0.0">DirXML</product>
<contact>NetIQ Corporation</contact>
</source>
<input>
<jdbc:statement event-id="basenet015_524-NDS#20180928150452#3#1:b6cddf3f-22b2-4183-9015-848b7669eb5b" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:call-procedure jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
<jdbc:param>
<jdbc:value>TSTGNL6</jdbc:value>
</jdbc:param>
<jdbc:param>
<jdbc:value>LEDGER</jdbc:value>
</jdbc:param>
<jdbc:param/>
<jdbc:param/>
<jdbc:param/>
</jdbc:call-procedure>
<operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user" groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true" operation="modify">
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
</operation-data>
</jdbc:statement>
</input>
</nds>
[09/28/18 17:04:52.612]:Basenet DEV ST:Stripping operation data from input document
[09/28/18 17:04:52.612]:Basenet DEV ST:Fetching metadata for routine 'idam.PACK_BASENET_IDAM.ADD_GROUP'.
[09/28/18 17:04:52.612]:Basenet DEV ST:{call idam.PACK_BASENET_IDAM.ADD_GROUP(?,?,?,?,?)}
[09/28/18 17:04:52.612]:Basenet DEV ST: IN @ index 1, param 'PI_USERNAME', field '$1', length: 7, value = 'TSTGNL6'
[09/28/18 17:04:52.612]:Basenet DEV ST: IN @ index 2, param 'PI_GROUPID', field '$2', length: 4, value = 'CASH'
[09/28/18 17:04:52.612]:Basenet DEV ST: OUT @ index 3, param 'PO_STATUS', field '$3'
[09/28/18 17:04:52.612]:Basenet DEV ST: OUT @ index 4, param 'PO_USERNAME', field '$4'
[09/28/18 17:04:52.612]:Basenet DEV ST: OUT @ index 5, param 'PO_MESSAGE', field '$5'
[09/28/18 17:04:52.628]:Basenet DEV ST: OUT @ index 3, param 'PO_STATUS', field '$3', value = 0
[09/28/18 17:04:52.628]:Basenet DEV ST: OUT @ index 4, param 'PO_USERNAME', field '$4', length: 7, value = 'TSTGNL6'
[09/28/18 17:04:52.628]:Basenet DEV ST: OUT @ index 5, param 'PO_MESSAGE', field '$5', value = null
[09/28/18 17:04:52.628]:Basenet DEV ST:Restoring operation data to output document
[09/28/18 17:04:52.628]:Basenet DEV ST:SubscriptionShim.execute() returned:
[09/28/18 17:04:52.628]:Basenet DEV ST:
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20180222_0550" instance="Basenet DEV" version="4.1.0.0">DirXML Driver for JDBC</product>
<contact>NetIQ Corporation</contact>
</source>
<output>
<jdbc:out-parameters event-id="basenet015_524-NDS#20180928150452#3#1:b6cddf3f-22b2-4183-9015-848b7669eb5b" jdbc:number-of-params="3">
<jdbc:param/>
<jdbc:param/>
<jdbc:param jdbc:name="PO_STATUS" jdbc:param-type="OUT" jdbc:position="3" jdbc:sql-type="java.sql.Types.DECIMAL">
<jdbc:value>0</jdbc:value>
</jdbc:param>
<jdbc:param jdbc:name="PO_USERNAME" jdbc:param-type="OUT" jdbc:position="4" jdbc:sql-type="java.sql.Types.VARCHAR">
<jdbc:value>TSTGNL6</jdbc:value>
</jdbc:param>
<jdbc:param jdbc:name="PO_MESSAGE" jdbc:param-type="OUT" jdbc:position="5" jdbc:sql-type="java.sql.Types.VARCHAR"/>
<operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user" groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true" operation="modify">
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
</operation-data>
</jdbc:out-parameters>
<status event-id="basenet015_524-NDS#20180928150452#3#1:b6cddf3f-22b2-4183-9015-848b7669eb5b" level="success">
<operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user" groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true" operation="modify">
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
<entitlement-impl id="" name="Group" qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA" src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748" state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
</operation-data>
</status>
</output>
</nds>
[/HTML]


I haven't looked it up, but I'm pretty sure your #3 is not valid. You can only have one <nds>...</nds> node in there.

#2 looks ok to me. I'm pretty sure you get back the status of the entire thing, so if either part failed, you'd get a failure.

But if you really want to serialize these so that they happen one at a time, you'll have to go back further in the trace and show how you're trying to break them up. Use of "when=after" should convince the engine that you want to do these one at a time.
0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

dgersic wrote:

>
> seba4;2488280 Wrote:
> > I have tried multiple options and each has it's own problems:
> >
> > *1.Option where statements are separated and on both statements event-id
> > is clone of main event id:*
> > Problems:
> > - Only one statement is executed
> >
> >

>
> > <nds dtdversion="4.0" ndsversion="8.x">
> > <source>
> > <product edition="Advanced" version="4.7.0.0">DirXML</product>
> > <contact>NetIQ Corporation</contact>
> > </source>
> > <input>
> > <jdbc:statement
> > event-id="basenet015_524-NDS#20180928120842#3#1:6cff2d4a-f485-4982-adc6-0dcb
> > a3a48bfd" xmlns:jdbc="urn:dirxml:jdbc">
> > <jdbc:call-procedure
> > jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
> > <jdbc:param>
> > <jdbc:value>TSTGNL6</jdbc:value>
> > </jdbc:param>
> > <jdbc:param>
> > <jdbc:value>CASH</jdbc:value>
> > </jdbc:param>
> > <jdbc:param/>
> > <jdbc:param/>
> > <jdbc:param/>
> > </jdbc:call-procedure>
> > <operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user"
> > groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true"
> > operation="modify">
> > <entitlement-impl id="" name="Group"
> > qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA"
> > src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748"
> > state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
> > <entitlement-impl id="" name="Group"
> > qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA"
> > src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748"
> > state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
> > </operation-data>
> > </jdbc:statement>
> > <jdbc:statement
> > event-id="basenet015_524-NDS#20180928120842#3#1:6cff2d4a-f485-4982-adc6-0dcb
> > a3a48bfd" xmlns:jdbc="urn:dirxml:jdbc">
> > <jdbc:call-procedure
> > jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
> > <jdbc:param>
> > <jdbc:value>TSTGNL6</jdbc:value>
> > </jdbc:param>
> > <jdbc:param>
> > <jdbc:value>LEDGER</jdbc:value>
> > </jdbc:param>
> > <jdbc:param/>
> > <jdbc:param/>
> > <jdbc:param/>
> > </jdbc:call-procedure>
> > <operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user"
> > groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true"
> > operation="modify">
> > <entitlement-impl id="" name="Group"
> > qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA"
> > src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748"
> > state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
> > <entitlement-impl id="" name="Group"
> > qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA"
> > src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748"
> > state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
> > </operation-data>
> > </jdbc:statement>
> > </input>
> > </nds>
> > [09/28/18 14:08:43.207]:Basenet DEV ST:Stripping operation data from
> > input document
> > [09/28/18 14:08:43.207]:Basenet DEV ST:{call
> > IDAM.PACK_BASENET_IDAM.ADD_GROUP(?,?,?,?,?)}
> > [09/28/18 14:08:43.207]:Basenet DEV ST: IN @ index 1, param
> > 'PI_USERNAME', field '$1', length: 7, value = 'TSTGNL6'
> > [09/28/18 14:08:43.207]:Basenet DEV ST: IN @ index 2, param
> > 'PI_GROUPID', field '$2', length: 4, value = 'CASH'
> > [09/28/18 14:08:43.207]:Basenet DEV ST: OUT @ index 3, param
> > 'PO_STATUS', field '$3'
> > [09/28/18 14:08:43.207]:Basenet DEV ST: OUT @ index 4, param
> > 'PO_USERNAME', field '$4'
> > [09/28/18 14:08:43.207]:Basenet DEV ST: OUT @ index 5, param
> > 'PO_MESSAGE', field '$5'
> > [09/28/18 14:08:43.207]:Basenet DEV ST: OUT @ index 3, param
> > 'PO_STATUS', field '$3', value = 0
> > [09/28/18 14:08:43.207]:Basenet DEV ST: OUT @ index 4, param
> > 'PO_USERNAME', field '$4', length: 7, value = 'TSTGNL6'
> > [09/28/18 14:08:43.207]:Basenet DEV ST: OUT @ index 5, param
> > 'PO_MESSAGE', field '$5', value = null
> > [09/28/18 14:08:43.207]:Basenet DEV ST:ROLLBACK
> > [09/28/18 14:08:43.207]:Basenet DEV ST:Restoring operation data to
> > output document
> > [09/28/18 14:08:43.207]:Basenet DEV ST:SubscriptionShim.execute()
> > returned:
> > [09/28/18 14:08:43.207]:Basenet DEV ST:
> > <nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
> > <source>
> > <product build="20180222_0550" instance="Basenet DEV"
> > version="4.1.0.0">DirXML Driver for JDBC</product>
> > <contact>NetIQ Corporation</contact>
> > </source>
> > <output>
> > <status
> > event-id="basenet015_524-NDS#20180928120842#3#1:6cff2d4a-f485-4982-adc6-0dcb
> > a3a48bfd" level="error" type="app-general">
> > <description>Unable to obtain value(s) from stored procedure
> > 'IDAM.PACK_BASENET_IDAM.ADD_GROUP'. Unable to retrieve statement
> > results.</description>
> > <jdbc:exception jdbc:class="java.lang.NullPointerException"/>
> > <jdbc:document xml:space="preserve"><nds dtdversion="4.0"
> > ndsversion="8.x">
> > <source>
> > <product edition="Advanced" version="4.7.0.0">DirXML</product>
> > <contact>NetIQ Corporation</contact>
> > </source>
> > <input>
> > <jdbc:statement
> > event-id="basenet015_524-NDS#20180928120842#3#1:6cff2d4a-f485-4982-adc6-0dcb
> > a3a48bfd" xmlns:jdbc="urn:dirxml:jdbc">
> > <jdbc:call-procedure jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
> > <jdbc:param>
> > <jdbc:value>TSTGNL6</jdbc:value>
> > </jdbc:param>
> > <jdbc:param>
> > <jdbc:value>CASH</jdbc:value>
> > </jdbc:param>
> > <jdbc:param/>
> > <jdbc:param/>
> > <jdbc:param/>
> > </jdbc:call-procedure>
> > </jdbc:statement>
> > <jdbc:statement
> > event-id="basenet015_524-NDS#20180928120842#3#1:6cff2d4a-f485-4982-adc6-0dcb
> > a3a48bfd_opData0" xmlns:jdbc="urn:dirxml:jdbc">
> > <jdbc:call-procedure jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
> > <jdbc:param>
> > <jdbc:value>TSTGNL6</jdbc:value>
> > </jdbc:param>
> > <jdbc:param>
> > <jdbc:value>LEDGER</jdbc:value>
> > </jdbc:param>
> > <jdbc:param/>
> > <jdbc:param/>
> > <jdbc:param/>
> > </jdbc:call-procedure>
> > </jdbc:statement>
> > </input>
> > </nds></jdbc:document>
> > <operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user"
> > groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true"
> > operation="modify">
> > <entitlement-impl id="" name="Group"
> > qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA"
> > src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748"
> > state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
> > <entitlement-impl id="" name="Group"
> > qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA"
> > src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748"
> > state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
> > </operation-data>
> > </status>
> > </output>
> > </nds>
> >
> >
> >
> >
> >
> > *2.Option where statements are separated and statement event-id
> > differs:*
> > Working:
> > - both queries were executed
> > Problems:
> > - We don't receive status from both statements
> >
> >
> >

>
> > <nds dtdversion="4.0" ndsversion="8.x">
> > <source>
> > <product edition="Advanced" version="4.7.0.0">DirXML</product>
> > <contact>NetIQ Corporation</contact>
> > </source>
> > <input>
> > <jdbc:statement xmlns:jdbc="urn:dirxml:jdbc">
> > <jdbc:call-procedure
> > jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
> > <jdbc:param>
> > <jdbc:value>TSTGNL6</jdbc:value>
> > </jdbc:param>
> > <jdbc:param>
> > <jdbc:value>CASH</jdbc:value>
> > </jdbc:param>
> > <jdbc:param/>
> > <jdbc:param/>
> > <jdbc:param/>
> > </jdbc:call-procedure>
> > <operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user"
> > groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true"
> > operation="modify">
> > <entitlement-impl id="" name="Group"
> > qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA"
> > src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748"
> > state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
> > <entitlement-impl id="" name="Group"
> > qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA"
> > src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748"
> > state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
> > </operation-data>
> > </jdbc:statement>
> > <jdbc:statement xmlns:jdbc="urn:dirxml:jdbc">
> > <jdbc:call-procedure
> > jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
> > <jdbc:param>
> > <jdbc:value>TSTGNL6</jdbc:value>
> > </jdbc:param>
> > <jdbc:param>
> > <jdbc:value>LEDGER</jdbc:value>
> > </jdbc:param>
> > <jdbc:param/>
> > <jdbc:param/>
> > <jdbc:param/>
> > </jdbc:call-procedure>
> > <operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user"
> > groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true"
> > operation="modify">
> > <entitlement-impl id="" name="Group"
> > qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA"
> > src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748"
> > state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
> > <entitlement-impl id="" name="Group"
> > qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA"
> > src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748"
> > state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
> > </operation-data>
> > </jdbc:statement>
> > </input>
> > </nds>
> > [09/28/18 14:00:37.859]:Basenet DEV ST:Stripping operation data from
> > input document
> > [09/28/18 14:00:37.859]:Basenet DEV ST:{call
> > IDAM.PACK_BASENET_IDAM.ADD_GROUP(?,?,?,?,?)}
> > [09/28/18 14:00:37.859]:Basenet DEV ST: IN @ index 1, param
> > 'PI_USERNAME', field '$1', length: 7, value = 'TSTGNL6'
> > [09/28/18 14:00:37.859]:Basenet DEV ST: IN @ index 2, param
> > 'PI_GROUPID', field '$2', length: 4, value = 'CASH'
> > [09/28/18 14:00:37.859]:Basenet DEV ST: OUT @ index 3, param
> > 'PO_STATUS', field '$3'
> > [09/28/18 14:00:37.859]:Basenet DEV ST: OUT @ index 4, param
> > 'PO_USERNAME', field '$4'
> > [09/28/18 14:00:37.859]:Basenet DEV ST: OUT @ index 5, param
> > 'PO_MESSAGE', field '$5'
> > [09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 3, param
> > 'PO_STATUS', field '$3', value = 0
> > [09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 4, param
> > 'PO_USERNAME', field '$4', length: 7, value = 'TSTGNL6'
> > [09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 5, param
> > 'PO_MESSAGE', field '$5', value = null
> > [09/28/18 14:00:37.875]:Basenet DEV ST:{call
> > IDAM.PACK_BASENET_IDAM.ADD_GROUP(?,?,?,?,?)}
> > [09/28/18 14:00:37.875]:Basenet DEV ST: IN @ index 1, param
> > 'PI_USERNAME', field '$1', length: 7, value = 'TSTGNL6'
> > [09/28/18 14:00:37.875]:Basenet DEV ST: IN @ index 2, param
> > 'PI_GROUPID', field '$2', length: 6, value = 'LEDGER'
> > [09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 3, param
> > 'PO_STATUS', field '$3'
> > [09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 4, param
> > 'PO_USERNAME', field '$4'
> > [09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 5, param
> > 'PO_MESSAGE', field '$5'
> > [09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 3, param
> > 'PO_STATUS', field '$3', value = 0
> > [09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 4, param
> > 'PO_USERNAME', field '$4', length: 7, value = 'TSTGNL6'
> > [09/28/18 14:00:37.875]:Basenet DEV ST: OUT @ index 5, param
> > 'PO_MESSAGE', field '$5', value = null
> > [09/28/18 14:00:37.875]:Basenet DEV ST:ROLLBACK
> > [09/28/18 14:00:37.875]:Basenet DEV ST:Restoring operation data to
> > output document
> > [09/28/18 14:00:37.875]:Basenet DEV ST:SubscriptionShim.execute()
> > returned:
> > [09/28/18 14:00:37.875]:Basenet DEV ST:
> > <nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
> > <source>
> > <product build="20180222_0550" instance="Basenet DEV"
> > version="4.1.0.0">DirXML Driver for JDBC</product>
> > <contact>NetIQ Corporation</contact>
> > </source>
> > <output>
> > <jdbc:out-parameters event-id="" jdbc:number-of-params="3">
> > <jdbc:param/>
> > <jdbc:param/>
> > <jdbc:param jdbc:name="PO_STATUS" jdbc:param-type="OUT"
> > jdbc:position="3" jdbc:sql-type="java.sql.Types.DECIMAL">
> > <jdbc:value>0</jdbc:value>
> > </jdbc:param>
> > <jdbc:param jdbc:name="PO_USERNAME" jdbc:param-type="OUT"
> > jdbc:position="4" jdbc:sql-type="java.sql.Types.VARCHAR">
> > <jdbc:value>TSTGNL6</jdbc:value>
> > </jdbc:param>
> > <jdbc:param jdbc:name="PO_MESSAGE" jdbc:param-type="OUT"
> > jdbc:position="5" jdbc:sql-type="java.sql.Types.VARCHAR"/>
> > <operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user"
> > groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true"
> > operation="modify">
> > <entitlement-impl id="" name="Group"
> > qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA"
> > src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748"
> > state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
> > <entitlement-impl id="" name="Group"
> > qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA"
> > src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748"
> > state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
> > </operation-data>
> > </jdbc:out-parameters>
> > <status level="success">
> > <operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user"
> > groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true"
> > operation="modify">
> > <entitlement-impl id="" name="Group"
> > qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA"
> > src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748"
> > state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
> > <entitlement-impl id="" name="Group"
> > qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA"
> > src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748"
> > state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
> > </operation-data>
> > </status>
> > <status event-id="" level="error" type="app-general">
> > <description>Unable to obtain value(s) from stored procedure
> > 'IDAM.PACK_BASENET_IDAM.ADD_GROUP'. Unable to retrieve statement
> > results.</description>
> > <jdbc:exception jdbc:class="java.lang.NullPointerException"/>
> > <jdbc:document xml:space="preserve"><nds dtdversion="4.0"
> > ndsversion="8.x">
> > <source>
> > <product edition="Advanced" version="4.7.0.0">DirXML</product>
> > <contact>NetIQ Corporation</contact>
> > </source>
> > <input>
> > <jdbc:statement xmlns:jdbc="urn:dirxml:jdbc">
> > <jdbc:call-procedure jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
> > <jdbc:param>
> > <jdbc:value>TSTGNL6</jdbc:value>
> > </jdbc:param>
> > <jdbc:param>
> > <jdbc:value>CASH</jdbc:value>
> > </jdbc:param>
> > <jdbc:param/>
> > <jdbc:param/>
> > <jdbc:param/>
> > </jdbc:call-procedure>
> > </jdbc:statement>
> > <jdbc:statement event-id="_opData0" xmlns:jdbc="urn:dirxml:jdbc">
> > <jdbc:call-procedure jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
> > <jdbc:param>
> > <jdbc:value>TSTGNL6</jdbc:value>
> > </jdbc:param>
> > <jdbc:param>
> > <jdbc:value>LEDGER</jdbc:value>
> > </jdbc:param>
> > <jdbc:param/>
> > <jdbc:param/>
> > <jdbc:param/>
> > </jdbc:call-procedure>
> > </jdbc:statement>
> > </input>
> > </nds></jdbc:document>
> > <operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user"
> > groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true"
> > operation="modify">
> > <entitlement-impl id="" name="Group"
> > qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA"
> > src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748"
> > state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
> > <entitlement-impl id="" name="Group"
> > qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA"
> > src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748"
> > state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
> > </operation-data>
> > </status>
> > </output>
> > </nds>
> >
> >
> >
> > *3.Option where we separate statements into 2 documents. (nds)*
> > Working:
> > Problems:
> > - Only one statement is executed
> >
> >
> >

>
> > <nds dtdversion="4.0" ndsversion="8.x">
> > <source>
> > <product edition="Advanced" version="4.7.0.0">DirXML</product>
> > <contact>NetIQ Corporation</contact>
> > </source>
> > <input>
> > <jdbc:statement
> > event-id="basenet015_524-NDS#20180928150452#3#1:b6cddf3f-22b2-4183-9015-848b
> > 7669eb5b" xmlns:jdbc="urn:dirxml:jdbc">
> > <jdbc:call-procedure
> > jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
> > <jdbc:param>
> > <jdbc:value>TSTGNL6</jdbc:value>
> > </jdbc:param>
> > <jdbc:param>
> > <jdbc:value>CASH</jdbc:value>
> > </jdbc:param>
> > <jdbc:param/>
> > <jdbc:param/>
> > <jdbc:param/>
> > </jdbc:call-procedure>
> > <operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user"
> > groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true"
> > operation="modify">
> > <entitlement-impl id="" name="Group"
> > qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA"
> > src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748"
> > state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
> > <entitlement-impl id="" name="Group"
> > qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA"
> > src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748"
> > state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
> > </operation-data>
> > </jdbc:statement>
> > </input>
> > </nds>
> > <nds dtdversion="4.0" ndsversion="8.x">
> > <source>
> > <product edition="Advanced" version="4.7.0.0">DirXML</product>
> > <contact>NetIQ Corporation</contact>
> > </source>
> > <input>
> > <jdbc:statement
> > event-id="basenet015_524-NDS#20180928150452#3#1:b6cddf3f-22b2-4183-9015-848b
> > 7669eb5b" xmlns:jdbc="urn:dirxml:jdbc">
> > <jdbc:call-procedure
> > jdbc:name="idam.PACK_BASENET_IDAM.ADD_GROUP">
> > <jdbc:param>
> > <jdbc:value>TSTGNL6</jdbc:value>
> > </jdbc:param>
> > <jdbc:param>
> > <jdbc:value>LEDGER</jdbc:value>
> > </jdbc:param>
> > <jdbc:param/>
> > <jdbc:param/>
> > <jdbc:param/>
> > </jdbc:call-procedure>
> > <operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user"
> > groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true"
> > operation="modify">
> > <entitlement-impl id="" name="Group"
> > qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA"
> > src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748"
> > state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
> > <entitlement-impl id="" name="Group"
> > qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA"
> > src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748"
> > state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
> > </operation-data>
> > </jdbc:statement>
> > </input>
> > </nds>
> > [09/28/18 17:04:52.612]:Basenet DEV ST:Stripping operation data from
> > input document
> > [09/28/18 17:04:52.612]:Basenet DEV ST:Fetching metadata for routine
> > 'idam.PACK_BASENET_IDAM.ADD_GROUP'.
> > [09/28/18 17:04:52.612]:Basenet DEV ST:{call
> > idam.PACK_BASENET_IDAM.ADD_GROUP(?,?,?,?,?)}
> > [09/28/18 17:04:52.612]:Basenet DEV ST: IN @ index 1, param
> > 'PI_USERNAME', field '$1', length: 7, value = 'TSTGNL6'
> > [09/28/18 17:04:52.612]:Basenet DEV ST: IN @ index 2, param
> > 'PI_GROUPID', field '$2', length: 4, value = 'CASH'
> > [09/28/18 17:04:52.612]:Basenet DEV ST: OUT @ index 3, param
> > 'PO_STATUS', field '$3'
> > [09/28/18 17:04:52.612]:Basenet DEV ST: OUT @ index 4, param
> > 'PO_USERNAME', field '$4'
> > [09/28/18 17:04:52.612]:Basenet DEV ST: OUT @ index 5, param
> > 'PO_MESSAGE', field '$5'
> > [09/28/18 17:04:52.628]:Basenet DEV ST: OUT @ index 3, param
> > 'PO_STATUS', field '$3', value = 0
> > [09/28/18 17:04:52.628]:Basenet DEV ST: OUT @ index 4, param
> > 'PO_USERNAME', field '$4', length: 7, value = 'TSTGNL6'
> > [09/28/18 17:04:52.628]:Basenet DEV ST: OUT @ index 5, param
> > 'PO_MESSAGE', field '$5', value = null
> > [09/28/18 17:04:52.628]:Basenet DEV ST:Restoring operation data to
> > output document
> > [09/28/18 17:04:52.628]:Basenet DEV ST:SubscriptionShim.execute()
> > returned:
> > [09/28/18 17:04:52.628]:Basenet DEV ST:
> > <nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
> > <source>
> > <product build="20180222_0550" instance="Basenet DEV"
> > version="4.1.0.0">DirXML Driver for JDBC</product>
> > <contact>NetIQ Corporation</contact>
> > </source>
> > <output>
> > <jdbc:out-parameters
> > event-id="basenet015_524-NDS#20180928150452#3#1:b6cddf3f-22b2-4183-9015-848b
> > 7669eb5b" jdbc:number-of-params="3">
> > <jdbc:param/>
> > <jdbc:param/>
> > <jdbc:param jdbc:name="PO_STATUS" jdbc:param-type="OUT"
> > jdbc:position="3" jdbc:sql-type="java.sql.Types.DECIMAL">
> > <jdbc:value>0</jdbc:value>
> > </jdbc:param>
> > <jdbc:param jdbc:name="PO_USERNAME" jdbc:param-type="OUT"
> > jdbc:position="4" jdbc:sql-type="java.sql.Types.VARCHAR">
> > <jdbc:value>TSTGNL6</jdbc:value>
> > </jdbc:param>
> > <jdbc:param jdbc:name="PO_MESSAGE" jdbc:param-type="OUT"
> > jdbc:position="5" jdbc:sql-type="java.sql.Types.VARCHAR"/>
> > <operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user"
> > groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true"
> > operation="modify">
> > <entitlement-impl id="" name="Group"
> > qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA"
> > src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748"
> > state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
> > <entitlement-impl id="" name="Group"
> > qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA"
> > src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748"
> > state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
> > </operation-data>
> > </jdbc:out-parameters>
> > <status
> > event-id="basenet015_524-NDS#20180928150452#3#1:b6cddf3f-22b2-4183-9015-848b
> > 7669eb5b" level="success">
> > <operation-data Entitlement-IDU="TSTGNL6" class="shipnet_user"
> > groupAddAction="groupModifyByEntitlementAdd" jdbcSP="true"
> > operation="modify">
> > <entitlement-impl id="" name="Group"
> > qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA"
> > src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748"
> > state="1">{"ID":"CASH","ID2":"CASH"}</entitlement-impl>
> > <entitlement-impl id="" name="Group"
> > qualified-src-dn="O=data\OU=users\OU=TST\CN=TSTGNL6" src="UA"
> > src-dn="\BASENET\data\users\TST\TSTGNL6" src-entry-id="80748"
> > state="1">{"ID":"LEDGER","ID2":"LEDGER"}</entitlement-impl>
> > </operation-data>
> > </status>
> > </output>
> > </nds>
> >

>
> I haven't looked it up, but I'm pretty sure your #3 is not valid. You
> can only have one <nds>...</nds> node in there.
>


Probably true about not entirely valid, but I vaguely recall that for SOAP shim
at least, I could have multiple nds nodes in document sent on subscriber thread.
Needed a stylesheet to make it happen tho.

--
If you find this post helpful, and are viewing this using the web, please show
your appreciation by clicking on the star below
Alex McHugh - Knowledge Partner - Stavanger, Norway
Who are the Knowledge Partners
If you appreciate my comments, please click the Like button.
If I have resolved your issue, please click the Accept as Solution button.
0 Likes
Captain
Captain

Hi thank you all for help. In the end i went with option 2 which worked, i just had to add different event-ids for each statement.
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.