Hi,
We have a JDBC driver connected to Oracle database. The driver is
running on IDM 4.0.2 Patch 6.
Only the publisher channel is enabled. We are using a view and
triggerless mode.

The view contains about 10000 lines but the driver processes only 8597
lines. I launched the driver multiple times and the result was the same
each time.
I deleted the files in the state directory then started the driver, no
change.
I deleted the last record processed by the driver from the database.
When I ran the driver it processed 8596 lines. It seems that the driver
does not read all the view records.

Here is an extract of what happens when the last record is processed:

[11/05/15 18:38:44.197]:JDBC PT:Number of statements allocated on
connection 'dedicated0': 1.
[11/05/15 18:38:44.197]:JDBC PT:Number of statements allocated on
connection 'dedicated1': 0.
[11/05/15 18:38:44.197]:JDBC PT:Current time is: 2015-11-05
18:38:44.197
[11/05/15 18:38:44.197]:JDBC PT:Closing idle connections.
[11/05/15 18:38:44.197]:JDBC PT:The next idle connection will be closed
at 2015-11-05 18:43:42.138.
[11/05/15 18:38:44.197]:JDBC PT:Expiring extended queries prior to
current time.
[11/05/15 18:38:44.197]:JDBC PT:There are no more extended queries to
expire.
[11/05/15 18:38:44.197]:JDBC PT:Sleeping for 8 second(s), 986
millisecond(s).
[11/05/15 18:38:53.198]:JDBC PT:Publisher is awake.
[11/05/15 18:38:53.198]:JDBC PT:Polling for database events...
[11/05/15 18:38:53.198]:JDBC PT:Updating state for class
'V01_USERS_RIGHTS'.
[11/05/15 18:38:53.198]:JDBC PT:Batch size: 1
[11/05/15 18:38:53.198]:JDBC PT:BEGIN V01_USERS_RIGHTS$0 ------------
[11/05/15 18:38:53.198]:JDBC PT:END V01_USERS_RIGHTS$0 ------------
[11/05/15 18:38:53.214]:JDBC PT:BEGIN V01_USERS_RIGHTS$1 ------------
[11/05/15 18:38:53.214]:JDBC PT: {[10000droitAgentUCB], 664211131}
[11/05/15 18:38:53.214]:JDBC PT: {[10018Banque], 2351154441}
[11/05/15 18:38:53.214]:JDBC PT: {[10081droitExterne], 1812304292}
:
:
:
[11/05/15 18:38:58.487]:JDBC PT: {[xxxx.yyyy@abcd.comSurveyor],
288084465}
[11/05/15 18:38:58.487]:JDBC PT:END V01_USERS_RIGHTS$1 ------------
[11/05/15 18:38:58.487]:JDBC PT:SELECT A.PK_ID, A.T01_IDREF,
A.T01_LOGIN, A.T01_NAME, A.T01_SURNAME, A.T03_IDAPPLICATION, A.T02_LABEL
FROM V01_USERS_RIGHTS A ORDER BY A.PK_ID ASC
[11/05/15 18:38:58.502]:JDBC PT: Allocated result set 4c9959e from
statement 15e3cc8e.
[11/05/15 18:38:58.518]:JDBC PT:Current database object:
[10000droitAgentUCB]
[11/05/15 18:38:58.518]:JDBC PT:Current database object:
[10000droitAgentUCB]
[11/05/15 18:38:58.518]:JDBC PT:Current database object: [10018Banque]
[11/05/15 18:38:58.518]:JDBC PT:Read 2 rows for object
[10000droitAgentUCB]
[11/05/15 18:38:58.518]:JDBC PT:Object [10000droitAgentUCB] has NOT
changed.
[11/05/15 18:38:58.518]:JDBC PT:Move object {[10000droitAgentUCB],
664211131}
[11/05/15 18:38:58.518]:JDBC PT:Moved.
:
:
:
11/05/15 18:40:19.421]:JDBC PT:Current directory object:
{[977291TEMPUS_USER], 2195008606}
[11/05/15 18:40:19.437]:JDBC PT: Closed result set 6a9c0fcf.
[11/05/15 18:40:19.437]:JDBC PT:Number of statements allocated on
connection 'dedicated0': 1.
[11/05/15 18:40:19.437]:JDBC PT:Number of statements allocated on
connection 'dedicated1': 0.
[11/05/15 18:40:19.437]:JDBC PT:Current time is: 2015-11-05
18:40:19.437
[11/05/15 18:40:19.437]:JDBC PT:Closing idle connections.
[11/05/15 18:40:19.437]:JDBC PT:The next idle connection will be closed
at 2015-11-05 18:43:42.138.
[11/05/15 18:40:19.437]:JDBC PT:Expiring extended queries prior to
current time.
[11/05/15 18:40:19.437]:JDBC PT:There are no more extended queries to
expire.
[11/05/15 18:40:19.437]:JDBC PT:Sleeping for 10 second(s), 0
millisecond(s).
[11/05/15 18:40:19.437]:JDBC PT:Shutting down...
[11/05/15 18:40:19.437]:JDBC PT:Connection 'dedicated0' is open.
Closing...
[11/05/15 18:40:19.437]:JDBC PT:BEGIN Close connection 'dedicated0'.
[11/05/15 18:40:19.437]:JDBC PT: Connection implementation and/or child
statements need to be closed.
[11/05/15 18:40:19.437]:JDBC PT: Closed statement 15e3cc8e.
[11/05/15 18:40:19.437]:JDBC ST:
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20120601_0445" instance="JDBC"
version="3.5.9">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<status level="success"/>
</output>
</nds>
[11/05/15 18:40:19.437]:JDBC ST:Waiting for Publisher thread to
terminate. Maximum wait time is 60 seconds.
[11/05/15 18:40:19.437]:JDBC PT: Closed connection 600c13d9.
[11/05/15 18:40:19.437]:JDBC PT:END Close connection.
[11/05/15 18:40:19.437]:JDBC PT:Connection is closed.
[11/05/15 18:40:19.437]:JDBC PT:Connection 'dedicated1' is open.
Closing...
[11/05/15 18:40:19.452]:JDBC PT:BEGIN Close connection 'dedicated1'.
[11/05/15 18:40:19.452]:JDBC PT: Connection implementation and/or child
statements need to be closed.
[11/05/15 18:40:19.452]:JDBC PT: Closed connection 6f43198c.
[11/05/15 18:40:19.452]:JDBC PT:END Close connection.
[11/05/15 18:40:19.452]:JDBC PT:Connection is closed.
[11/05/15 18:40:19.452]:JDBC PT:Closing file
'.\jdbc_b8b9413f-d45c-406d-bb16-2caab218a6cd'.
[11/05/15 18:40:19.515]:JDBC PT:File closed.
[11/05/15 18:40:19.515]:JDBC PT:Closing file
'.\jdbc_b8b9413f-d45c-406d-bb16-2caab218a6cd_1'.
[11/05/15 18:40:19.530]:JDBC PT:File closed.
[11/05/15 18:40:19.530]:JDBC PT:Shut down.
[11/05/15 18:40:19.530]:JDBC PT:PublicationShim.start() returned:
[11/05/15 18:40:19.530]:JDBC PT:
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20120601_0445" instance="JDBC"
version="3.5.9">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<status level="success"/>
</output>
</nds>

Has anyone faced this problem?

Thanks


--
moularbi
------------------------------------------------------------------------
moularbi's Profile: https://forums.netiq.com/member.php?userid=1196
View this thread: https://forums.netiq.com/showthread.php?t=54610