My client called me twice today complaining that their JDBC driver (MS
SQL) crashed. I looked at their logs and saw two different issues, the
first is from the remote loader trace:

Event Type: Error
Event Source: DirXML Remote Loader
Event Category: None
Event ID: 1
Date: 1/6/2009
Time: 1:59:39 PM
User: N/A
Computer: NY-IMIS
Description:
Driver : \ANSI-IDV\org\ansi\Drivers\IDM\IMIS-IDV
Thread : Publisher
Object :
Message : <description>An unexpected exception was thrown during a
triggerless publication polling interval. Unable to advance result set
cursor.</description>
<jdbc:exception jdbc:class="java.sql.SQLException"
jdbc:error-code="601" jdbc:sql-state="HY000"
xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:message>[Microsoft][SQLServer 2000 Driver for
JDBC][SQLServer]Could not continue scan with NOLOCK due to data
movement.</jdbc:message>
<jdbc:stack-trace>java.sql.SQLException: [Microsoft][SQLServer 2000
Driver for JDBC][SQLServer]Could not continue scan with NOLOCK due to
data movement.
at com.microsoft.jdbc.base.BaseExceptions.createExcep tion(Unknown
Source)
at com.microsoft.jdbc.base.BaseExceptions.getExceptio n(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSRequest.proces sErrorToken(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSRequest.proces sReplyToken(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest .processReplyToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.getRow (Unknown Source)
at
com.microsoft.jdbc.sqlserver.SQLServerImplResultSe t.positionCursor(Unknown
Source)
at com.microsoft.jdbc.base.BaseResultSet.next(Unknown Source)
at
com.novell.nds.dirxml.driver.jdbc.util.connect.JDB CResultSet.next(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.util.state.State Mediator.advanceDatabasePointer(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.util.state.State Mediator.stringImplementation(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.util.state.State Mediator.start(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.JDBCTriggerlessP ublicationShim.waitForEvents(Unknown
Source)
at com.novell.nds.dirxml.driver.jdbc.JDBCPublicationS him.poll(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.JDBCPublicationS him.pollLoop(Unknown
Source)
at com.novell.nds.dirxml.driver.jdbc.JDBCPublicationS him.start(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.JDBCPublicationP roxy.start(Unknown
Source)
at com.novell.nds.dirxml.remote.loader.Driver.run(Dri ver.java:851)
at java.lang.Thread.run(Thread.java:534)
</jdbc:stack-trace>
</jdbc:exception>

This would seem to be a problem where some data was changed while the
driver was processing it's polling select statement. Shouldn't the
driver just catch an exception like this and retry?

The second thing I found came from the event log:

DirXML: [12/22/08 22:01:32.17]: TRACE: SELECT a.PK_ID, a.MEMBER_TYPE,
a.CATEGORY, a.STATUS, a.CO_ID, a.LAST_NAME, a.MIDDLE_NAME, a.FIRST_NAME,
a.DESIGNATION, a.HOME_PHONE, a.TOLL_FREE, a.GENDER, a.COUNTY, a.PREFIX,
a.CO_MEMBER_TYPE, a.MEMBER_STATUS, a.EXCLUDE_MAIL, a.EXCLUDE_DIRECTORY,
a.FULL_NAME, a.COMPANY, a.WORK_PHONE, a.FAX, a.FULL_ADDRESS,
a.ADDRESS_1, a.ADDRESS_2, a.CITY, a.STATE_PROVINCE, a.ZIP, a.COUNTRY,
a.SEC_GRP, a.EMAIL, a.WEBSITE, a.OLD_LOGIN, a.D_NAME, a.DATE_ADDED,
a.BIRTH_DATE, a.JOIN_DATE, a.PAID_THRU, a.MEMBER_STATUS_DATE,
a.WEB_LOGIN, a.LOGIN_DISABLED, a.IDM, a.LAST_FIRST, a.INITIAL_PASSWORD
FROM dbo.Members a ORDER BY a.PK_ID ASC

DirXML: [12/22/08 22:02:28.82]:

DirXML Log Event -------------------

Level = fatal

Message = JVM exited unexpectedly (exit code=143)

DirXML: [12/22/08 22:04:19.39]: Loader: Loading JVM

DirXML: [12/22/08 22:04:36.67]: Loader: Starting Java loader

The 143 exit code is that something shut down the process abnormally,
but I don't know what might have done that. The client says they just
found that objects weren't syncing and noticed that the driver was
down.


____________________________
Robert Rawson
Director: Identity Management Practice
Computer Integrated Services Company of New York, LLC
561 Seventh Avenue, 13th Floor
New York, NY 10018
(212) 577-6033
(914) 623-0575


--
rrawson
------------------------------------------------------------------------
rrawson's Profile: http://forums.novell.com/member.php?userid=4898
View this thread: http://forums.novell.com/showthread.php?t=355938