I am using IDM 3.5.1, SQL Server 2005 database, Triggerless - Direct,
Database to IDM Sync.

Downloaded sqljdbc.jar from Microsoft
set classpath to c:\Novell\path where jar file is stored.


The driver finds a view match and terminates unexpectedly.

Thanks in advance.

Here's a level 3

[01/17/08 18:28:13.577]:Test PT:END Get database properties.
[01/17/08 18:28:13.577]:Test PT:BEGIN Get table metadata.
[01/17/08 18:28:13.577]:Test PT: Searching for table/view 'idm.view'
using type filter ["TABLE"].
[01/17/08 18:28:13.577]:Test PT: No match.
[01/17/08 18:28:13.577]:Test PT: Searching for table/view 'idm.view'
using type filter ["VIEW"].
[01/17/08 18:28:13.592]:Test PT: Match found.
[01/17/08 18:28:13.623]:Test PT: BEGIN Close connection 'dedicated0'.
[01/17/08 18:28:13.623]:Test PT: END Close connection.
[01/17/08 18:28:13.623]:Test PT: Shutting down...
[01/17/08 18:28:13.702]:Test PT: Shut down.
[01/17/08 18:28:13.702]:Test PT:PublicationShim.start() returned:
[01/17/08 18:28:13.702]:Test PT:
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20070918_0743" instance="DBTest"
version="3.5.2">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<status level="fatal" type="driver-general">
<description>View 'idm.view' is not syncable. No columns are
constrained as primary keys. At least one column must be prefixed with
'pk_' (case-insensitive).</description>
</status>
</output>
</nds>
[01/17/08 18:28:13.717]:Test PT:Applying input transformation
policies.
[01/17/08 18:28:13.717]:Test PT:Applying policy: %+C%14C'Email
notifications for failed password subscriptions'%-C.
[01/17/08 18:28:13.717]:Test PT: Applying to status #1.
[01/17/08 18:28:13.717]:Test PT: Evaluating selection criteria for
rule 'Send e-mail on a failure when subscribing to passwords'.
[01/17/08 18:28:13.717]:Test PT: (if-global-variable
'notify-user-on-password-dist-failure' equal "true") = TRUE.
[01/17/08 18:28:13.717]:Test PT: (if-operation equal "status") =
TRUE.
[01/17/08 18:28:13.717]:Test PT: (if-xpath true
"self::status[@level !=
'success']/operation-data/password-subscribe-status") = FALSE.
[01/17/08 18:28:13.733]:Test PT: Rule rejected.
[01/17/08 18:28:13.733]:Test PT: Evaluating selection criteria for
rule 'Send e-mail on failure to reset connected system password using
the IDM data store password'.
[01/17/08 18:28:13.733]:Test PT: (if-global-variable
'notify-user-on-password-dist-failure' equal "true") = TRUE.
[01/17/08 18:28:13.733]:Test PT: (if-operation equal "status") =
TRUE.
[01/17/08 18:28:13.733]:Test PT: (if-xpath true
"self::status[@level !=
'success']/operation-data/password-reset-status") = FALSE.
[01/17/08 18:28:13.733]:Test PT: Rule rejected.
[01/17/08 18:28:13.733]:Test PT:Policy returned:
[01/17/08 18:28:13.733]:Test PT:
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20070918_0743" instance="DBTest"
version="3.5.2">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<status level="fatal" type="driver-general">
<description>View 'idm.view' is not syncable. No columns are
constrained as primary keys. At least one column must be prefixed with
'pk_' (case-insensitive).</description>
</status>
</output>
</nds>
[01/17/08 18:28:13.748]:Test PT:Applying schema mapping policies to
input.
[01/17/08 18:28:13.748]:Test PT:Applying policy:
%+C%14CSchema+Mapping+Rule%-C.
[01/17/08 18:28:13.748]:Test PT:Resolving association references.
[01/17/08 18:28:13.748]:Test PT:
DirXML Log Event -------------------
Driver: \abcdTEST1\systems\abcd-set\DBTest
Channel: Publisher
Status: Fatal
Message: <description>View 'idm.view' is not syncable. No
columns are constrained as primary keys. At least one column must be
prefixed with 'pk_' (case-insensitive).</description>
[01/17/08 18:28:13.748]:Test PT:
DirXML Log Event -------------------
Driver: \abcdTEST1\systems\abcd-set\DBTest
Channel: Publisher
Status: Fatal
Message: Code(-9005) The driver returned a "fatal" status
indicating that the driver should be shut down. Detail from driver:
<description>View 'idm.view' is not syncable. No columns are
constrained as primary keys. At least one column must be prefixed with
'pk_' (case-insensitive).</description>
<application>DirXML</application>
<module>DBTest</module>
<object-dn></object-dn>
<component>Publisher</component>
[01/17/08 18:28:13.764]:Test PT:Killing driver from publisher thread;
after PublicationShim.start().
[01/17/08 18:28:13.764]:Test PT:Requesting termination.
[01/17/08 18:28:13.780]:Test PT:Ending publisher thread.
[01/17/08 18:28:13.795]:Test ST:Leaving event loop.
[01/17/08 18:28:13.795]:Test ST:Shutting down DirXML driver
\abcdTEST1\systems\abcd-set\DBTest.
[01/17/08 18:28:13.795]:Test STriverShim.shutdown() returned:
[01/17/08 18:28:13.795]:Test ST:
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20070918_0743" instance="DBTest"
version="3.5.2">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<status level="success"/>
</output>
</nds>
[01/17/08 18:28:13.795]:Test ST:Waiting for Publisher thread to
terminate...
[01/17/08 18:28:13.795]:Test ST:Publisher thread terminated.
[01/17/08 18:28:13.811]:Test STriver terminated.


--
raverich
------------------------------------------------------------------------
raverich's Profile: http://forums.novell.com/member.php?userid=1659
View this thread: http://forums.novell.com/showthread.php?t=307954