Hi all,

I have a NetWare 6.5 sp7/eDir 8.7.3.9 box with IDM 3.5.1 and JDBC
driver. Running the remote loader on a Windows 2k box with MSDE as my
database. When I try to sync(add) a user from E-Dir to MSDE I get the
following error message. I'm not expierenced with XML so I'm not sure
what to edit. First below is the error in the JDBC driver. Below
that, the XML code from the policy that is giving the error below. If
you know how to change the code to fix my error that would be great.

Thanks,

Brian Payne
MVNU



Message 22:
Mon Jun 30 08:34:10 EDT 2008
Error
No description provided.
Code(-9061) Error processing XSLT policy:
vnd.nds.stream://MVNC_EDU/mvnc/main/test/IDM2+MVNU+Driver+Set/MSSQL/Subscriber/SubscriberCommandTransformSS#XmlData
(6): <xsl:copy>: attribute 'timestamp' added after children were added


Message 23:
Mon Jun 30 08:34:10 EDT 2008
Error
No description provided.
Code(-9061) Error processing XSLT policy:
vnd.nds.stream://MVNC_EDU/mvnc/main/test/IDM2+MVNU+Driver+Set/MSSQL/Subscriber/SubscriberCommandTransformSS#XmlData
(6): <xsl:copy>: attribute 'type' added after children were added


Message 24:
Mon Jun 30 08:34:10 EDT 2008
Error
<status level="error">Code(-9037) One or more errors occurred while
processing an XSLT policy.<application>DirXML</application>
<module>MSSQL</module>
<object-dn>\MVNC_EDU\mvnc\main\jhill4</object-dn>
<component>Subscriber</component>
</status>
\MVNC_EDU\mvnc\main\jhill4


Here is the XLM code...

<?xml version="1.0" encoding="UTF-8"?><xsl:transform version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xslaram name="destQueryProcessor"/>
<xslaram name="srcQueryProcessor"/>
<!-- identity template -->
<xsl:template match="node()|@*">
<xsl:copy>
<xsl:apply-templates select="node()|@*"/>
</xsl:copy>
</xsl:template>
<!-- Adds a database user/login account -->
<xsl:template match="input/add[@class-name='User']"
xmlns:jdbc="urn:dirxml:jdbc">
<xsl:variable name="acctname"
select="add-attr[@attr-name='CN']/value[1]"/>
<xsl:choose>
<xsl:when test="$acctname">
<xsl:call-template name="add-add-sql">
<xsl:with-param name="acctname" select="$acctname"/>
</xsl:call-template>
</xsl:when>
<xsltherwise>
<xsl:message>
<status level="error" type="password-set-operation">
<xsl:text>Unable to create user/login account. </xsl:text>
<xsl:text>Missing 'acctname' value.</xsl:text>
</status>
</xsl:message>
</xsltherwise>
</xsl:choose>
</xsl:template>
<!-- Adds SQL to add a database user/login account -->
<xsl:template name="add-add-sql"
xmlns:Mapping="http://www.novell.com/nxsl/java/com.novell.nds.dirxml.driver.jdbc.util.MappingPoli cy"
xmlns:jdbc="urn:dirxml:jdbc">
<xslaram name="acctname"/>
<xsl:copy>
<xsl:variable name="attrs" select="add-attr[@attr-name='Given Name'
or @attr-name='Surname']"/>
<xsl:variable name="blah" select="Mapping:FirstPerReplica(., $attrs,
$srcQueryProcessor)"/>
<xsl:attribute name="jdbc:transaction-id">0</xsl:attribute>
<xsl:attribute name="jdbcp-id">0</xsl:attribute>
<xsl:attribute
name="jdbcp-type">password-set-operation</xsl:attribute>
<xsl:apply-templates select="node() | @*"/>
<password>
<xsl:value-of select="$acctname"/>
</password>
</xsl:copy>
<jdbc:statement jdbcp-id="0" jdbc:transaction-id="0"
jdbc:transaction-type="manual">
<jdbc:sql>
<xsl:text>UPDATE emp SET acctname = '</xsl:text>
<xsl:value-of select="$acctname"/>
<xsl:text>' WHERE empno = {$empno}</xsl:text>
</jdbc:sql>
</jdbc:statement>
</xsl:template>
<!-- Drops a database user/login account -->
<xsl:template match="input/delete[@class-name='User']"
xmlns:jdbc="urn:dirxml:jdbc"
xmlns:query="http://www.novell.com/nxsl/java/com.novell.nds.dirxml.driver.XdsQueryProcessor">
<xsl:variable name="query">
<jdbc:statement>
<xsl:copy-of select="association"/>
<jdbc:sql>SELECT acctname FROM emp WHERE empno =
{$empno}</jdbc:sql>
</jdbc:statement>
</xsl:variable>
<xsl:variable name="result"
select="query:query($destQueryProcessor,$query)"/>
<xsl:variable name="acctname"
select="$result//jdbc:result-set[1]/jdbc:row[1]/jdbc:column[@jdbc:name='acctname']/jdbc:value"/>
<xsl:choose>
<xsl:when test="$acctname">
<xsl:call-template name="add-drop-sql">
<xsl:with-param name="acctname" select="$acctname"/>
</xsl:call-template>
</xsl:when>
<xsltherwise>
<xsl:message>
<status level="error" type="password-set-operation">
<xsl:text>Unable to drop user/login account. </xsl:text>
<xsl:text>Unable to retrieve account information.</xsl:text>
</status>
</xsl:message>
</xsltherwise>
</xsl:choose>
</xsl:template>
<!-- Adds SQL to drop user/login account -->
<xsl:template name="add-drop-sql" xmlns:jdbc="urn:dirxml:jdbc">
<xslaram name="acctname"/>
<xsl:copy>
<xsl:attribute name="jdbcp-id">0</xsl:attribute>
<xsl:apply-templates select="node() | @*"/>
</xsl:copy>
</xsl:template>
<!-- Handles multi-valued to single-valued attribute mappings for
modify events.
Ensures that the first value on this replica is synced to the
database -->
<xsl:template match="input/modify[@class-name='User']"
xmlns:Mapping="http://www.novell.com/nxsl/java/com.novell.nds.dirxml.driver.jdbc.util.MappingPoli cy"
xmlns:query="http://www.novell.com/nxsl/java/com.novell.nds.dirxml.driver.XdsQueryProcessor">
<xsl:copy>
<xsl:variable name="attrs" select="modify-attr[@attr-name='Given
Name' or @attr-name='Surname']"/>
<xsl:variable name="blah" select="Mapping:FirstPerReplica(., $attrs,
$srcQueryProcessor)"/>
<xsl:apply-templates select="node()|@*"/>
</xsl:copy>
</xsl:template>
</xsl:transform>


--
bpayne11
------------------------------------------------------------------------
bpayne11's Profile: http://forums.novell.com/member.php?userid=2670
View this thread: http://forums.novell.com/showthread.php?t=334596