Will Schneider;1884746 Wrote:
> Post a trace of the direct SQL failing. Let's look at that one.
> Also post the XML policy for that.


Great, thanks for the help.

I have the "Login Disabled" attribute set to Notify, so that it reaches
the command transformation policy in which I have the following rule:


Code:
--------------------
<rule>
<description>Set local variable loginDisabled</description>
<conditions>
<and>
<if-class-name op="equal">User</if-class-name>
<if-op-attr name="Login Disabled" op="available"/>
</and>
</conditions>
<actions>
<do-set-local-variable name="loginDisabled" scope="driver">
<arg-string>
<token-op-attr name="Login Disabled"/>
</arg-string>
</do-set-local-variable>
<do-set-local-variable name="userAssoc" scope="driver">
<arg-node-set>
<token-split delimiter=",">
<token-association/>
</token-split>
</arg-node-set>
</do-set-local-variable>
<do-set-local-variable name="userPK" scope="driver">
<arg-string>
<token-xpath expression="$userAssoc[1]"/>
</arg-string>
</do-set-local-variable>
</actions>
</rule>
--------------------


Then in the output transformation I have the following rule to build
the SQL:


Code:
--------------------
<rule>
<description>If loginDisabled is set to true, then disable all tags associated with the person</description>
<conditions>
<and>
<if-local-variable name="loginDisabled" op="equal">true</if-local-variable>
</and>
</conditions>
<actions>
<do-append-xml-element expression="/nds/input" name="jdbc:statement"/>
<do-set-xml-attr expression="/nds/input/jdbc:statement" name="jdbc:type">
<arg-string>
<token-text xml:space="preserve">update</token-text>
</arg-string>
</do-set-xml-attr>
<do-set-xml-attr expression="/nds/input/jdbc:statement" name="jdbc:transaction-type">
<arg-string>
<token-text xml:space="preserve">manual</token-text>
</arg-string>
</do-set-xml-attr>
<do-set-xml-attr expression="/nds/input/jdbc:statement" name="jdbc:transaction-id">
<arg-string>
<token-text xml:space="preserve">1</token-text>
</arg-string>
</do-set-xml-attr>
<do-append-xml-element expression="/nds/input/jdbc:statement" name="jdbc:sql"/>
<do-append-xml-text expression="/nds/input/jdbc:statement/jdbc:sql[1]">
<arg-string>
<token-text xml:space="preserve">UPDATE TAG SET TAG_SUSPEND=1 WHERE </token-text>
<token-local-variable name="userPK"/>
</arg-string>
</do-append-xml-text>
</actions>
</rule>
--------------------


An event log is attached. Oddly enough, I don't see an obvious failure
in this event log - I'm trying to get back into the source DB to see
whether the action actually processed or not, but am posting this
information while I wait for that access.


+----------------------------------------------------------------------+
|Filename: acsevent-20091111-1012.log |
|Download: http://forums.novell.com/attachment....achmentid=3618 |
+----------------------------------------------------------------------+

--
preycor
------------------------------------------------------------------------
preycor's Profile: http://forums.novell.com/member.php?userid=7822
View this thread: http://forums.novell.com/showthread.php?t=391493