I've embeeded a query in a rule trying to do a Set XML attribute. I'm
not getting any response back. Can someone help me by telling me what
I'm missing?

<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.5.1.20070411 ">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<modify class-name="User" dest-dn="\ENTERPRISE_TREE\ABC\User161"
dest-entry-id="48974" event-id="161" from-merge="true"
src-dn="PK_ABC_UNIQUE_ID=161,table=PS_ABC_DIRXML_INTP, schema=SYSADM">
<association
state="associated">PK_ABC_UNIQUE_ID=161,table=PS_A BC_DIRXML_INTP,schema=SYSADM</association>
<modify-attr attr-name="CN">
<remove-value>
<value naming="true" timestamp="1226442442#36"
type="string">User161</value>
</remove-value>
</modify-attr>
<modify-attr attr-name="carLicense">
<add-value>
<value type="string">A056BADEDE9F6D94FC1FC867F18F7CC2</value>
</add-value>
</modify-attr>
<modify-attr attr-name="nspmDistributionPassword"><!-- content
suppressed -->
</modify-attr>
</modify>
</input>
</nds>
[11/20/08 11:10:50.891]:jd PT:Applying command transformation policies.
[11/20/08 11:10:50.899]:jd PT:Applying policy: %+C%14CDecrypt Password%-C.
[11/20/08 11:10:50.900]:jd PT: Applying to modify #1.
[11/20/08 11:10:50.900]:jd PT: Evaluating selection criteria for rule
'Get Encrypted Password'.
[11/20/08 11:10:50.901]:jd PT: (if-op-attr 'carLicense' available)
= TRUE.
[11/20/08 11:10:50.901]:jd PT: Rule selected.
[11/20/08 11:10:50.901]:jd PT: Applying rule 'Get Encrypted Password'.
[11/20/08 11:10:50.902]:jd PT: Action:
do-set-local-variable("varpassword",token-op-attr("carLicense")).
[11/20/08 11:10:50.928]:jd PT:
arg-string(token-op-attr("carLicense"))
[11/20/08 11:10:50.929]:jd PT: token-op-attr("carLicense")
[11/20/08 11:10:50.931]:jd PT: Token Value:
"A056BADEDE9F6D94FC1FC867F18F7CC2".
[11/20/08 11:10:50.931]:jd PT: Arg Value:
"A056BADEDE9F6D94FC1FC867F18F7CC2".
[11/20/08 11:10:50.934]:jd PT: Evaluating selection criteria for rule
'Decrypt Password'.
[11/20/08 11:10:50.934]:jd PT: (if-attr 'carLicense' available) = TRUE.
[11/20/08 11:10:50.934]:jd PT: Rule selected.
[11/20/08 11:10:50.934]:jd PT: Applying rule 'Decrypt Password'.
[11/20/08 11:10:50.935]:jd PT: Action:
do-set-xml-attr("Decrypt","jdbc:query","SELECT sysadm.DECRYPT((SELECT
ARCH_TEXT FROM SYSADM.PS_ABC_PORTAL_ARCH), $varpassword) FROM DUAL").
[11/20/08 11:10:50.935]:jd PT: arg-string("SELECT
sysadm.DECRYPT((SELECT ARCH_TEXT FROM SYSADM.PS_ABC_PORTAL_ARCH),
$varpassword) FROM DUAL")
[11/20/08 11:10:50.935]:jd PT: token-text("SELECT
sysadm.DECRYPT((SELECT ARCH_TEXT FROM SYSADM.PS_ABC_PORTAL_ARCH),
$varpassword) FROM DUAL")
[11/20/08 11:10:50.936]:jd PT: Arg Value: "SELECT
sysadm.DECRYPT((SELECT ARCH_TEXT FROM SYSADM.PS_ABC_PORTAL_ARCH),
$varpassword) FROM DUAL".
[11/20/08 11:10:50.937]:jd PT:Policy returned:
[11/20/08 11:10:50.937]:jd PT:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.5.1.20070411 ">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<modify class-name="User" dest-dn="\ENTERPRISE_TREE\ABC\User161"
dest-entry-id="48974" event-id="161" from-merge="true"
src-dn="PK_ABC_UNIQUE_ID=161,table=PS_ABC_DIRXML_INTP, schema=SYSADM">
<association
state="associated">PK_ABC_UNIQUE_ID=161,table=PS_A BC_DIRXML_INTP,schema=SYSADM</association>
<modify-attr attr-name="CN">
<remove-value>
<value naming="true" timestamp="1226442442#36"
type="string">User161</value>
</remove-value>
</modify-attr>
<modify-attr attr-name="carLicense">
<add-value>
<value type="string">A056BADEDE9F6D94FC1FC867F18F7CC2</value>
</add-value>
</modify-attr>
<modify-attr attr-name="nspmDistributionPassword"><!-- content
suppressed -->
</modify-attr>
</modify>
</input>
</nds>


Thanks.
Dan