Hi,

I have a weird thing. I am connecting to a MSSQL 2012 database via
indirect tables and eventlog. I have a students and a contracts table
without a fk but with a shared varchar field.

When I receive a student event in the command transformation i try to
query the contracts table. This is where it get's weird.

When I put the batch size on 1 and interval on 10 the query allways
returns the expected results.
When I put the batch size on 8+ and interval on 10 the query always
fails and returns an empty result, no errors or anything.
When I use settings like batch size 4 and interval 10 it will sometimes
fail randomly. The part that fails is the finding of the ID value
(primary key)
SELECT ID FROM OST_META_INSCHRIJF_HIST WHERE STUDENTNUMMER = ? ORDER BY
ID this will return empty and the driver than does not query on.

I think it might be the amount of connections I am allowed to make to
the database, but I find it weird that the driver does not gracefully
fail. Is this a known issue / bug, am I doing something wrong? Would it
be better to remove the primary key of my table?

Here is some version and driver start stuff.

Code:
--------------------

[10/01/14 16:14:38.005]:JDBC ST:Loading Java shim com.novell.nds.dirxml.driver.jdbc.JDBCDriverShim.
[10/01/14 16:14:38.005]:JDBC ST:JDBC driver version info:
version: 3.5.9
built: 20120601_0445
debug: true
activation level: 5
[10/01/14 16:14:38.006]:JDBC ST:Reading XML attribute vnd.nds.stream://IDVAULT-DEV/idvault/services/Driver+Set/JDBC#DirXML-ShimConfigInfo.
[10/01/14 16:14:38.010]:JDBC ST:


--------------------


Code:
--------------------

10/01/14 16:14:38.021]:JDBC ST:Loading descriptors.
[10/01/14 16:14:38.030]:JDBC ST:Loaded.
[10/01/14 16:14:38.031]:JDBC ST:Parameter: 'jdbc-class' Value: 'net.sourceforge.jtds.jdbc.Driver'
[10/01/14 16:14:38.031]:JDBC ST:Parameter: 'jdbc-driver-descriptor' Value: null
[10/01/14 16:14:38.031]:JDBC ST:Parameter: 'database-descriptor' Value: null
[10/01/14 16:14:38.031]:JDBC ST:Searching for driver descriptor file matching 'net.sourceforge.jtds.jdbc.Driver'.
[10/01/14 16:14:38.035]:JDBC STescriptor file '_jtds_jdbc.xml' successfully loaded.
[10/01/14 16:14:38.035]:JDBC ST:Third-Party JDBC Driver is "jTDS JDBC Driver"
[10/01/14 16:14:38.035]:JDBC ST:Applying declared imports to driver descriptor '_jtds_jdbc.xml'.
[10/01/14 16:14:38.036]:JDBC ST:Applying import '_ms_sqlserver_codes.xml'.
[10/01/14 16:14:38.036]:JDBC ST:Applying import '_ms_sqlserver_types.xml'.
[10/01/14 16:14:38.037]:JDBC ST:Parameter: 'sync-filter' Value: 'list'
[10/01/14 16:14:38.037]:JDBC ST:Parameter: 'sync-schema' Value: 'dbo'
[10/01/14 16:14:38.038]:JDBC ST:Parameter: 'sync-tables' Value: [OST_META_STUDENT, OST_META_VRIJVELD, OST_META_INSCHRIJF_HIST, OST_FACULTEIT_UU, OST_CROHO, OST_OPLEIDING]
[10/01/14 16:14:38.038]:JDBC STriver is schema-aware.
[10/01/14 16:14:38.038]:JDBC ST:Parameter: 'force-username-case' Value: null
[10/01/14 16:14:38.039]:JDBC ST:Parameter: 'server' Value: 'jdbc:jtds:sqlserver://somewhere'
[10/01/14 16:14:38.039]:JDBC ST:Parameter: 'user' Value: 'someone'
[10/01/14 16:14:38.039]:JDBC ST:Parameter: 'connection-properties' Value: ''
[10/01/14 16:14:38.039]:JDBC ST:Parameter: 'reuse-statements' Value: [descriptor-dependent]
[10/01/14 16:14:38.040]:JDBC ST:Parameter: 'use-manual-transactions' Value: [descriptor or metadata-dependent]
[10/01/14 16:14:38.040]:JDBC ST:Parameter: 'transaction-isolation-level' Value: [descriptor-dependent]
[10/01/14 16:14:38.041]:JDBC ST:Parameter: 'use-single-connection' Value: [descriptor-dependent]
[10/01/14 16:14:38.042]:JDBC ST:Parameter: 'max-conn-retry' Value: -1
[10/01/14 16:14:38.042]:JDBC ST:Parameter: 'preserve-sql-whitespace' Value: false
[10/01/14 16:14:38.042]:JDBC ST:Parameter: 'minimal-metadata' Value: [descriptor-dependent]
[10/01/14 16:14:38.043]:JDBC ST:Parameter: 'handle-stmt-results' Value: [descriptor-dependent]
[10/01/14 16:14:38.043]:JDBC ST:Parameter: 'connection-tester-class' Value: 'com.novell.nds.dirxml.driver.jdbc.util.connect.JD BCConnectionTester'
[10/01/14 16:14:38.044]:JDBC ST:Parameter: 'enable-refs' Value: true
[10/01/14 16:14:38.044]:JDBC ST:Parameter: 'enable-meta-identifiers' Value: true
[10/01/14 16:14:38.045]:JDBC ST:Parameter: 'left-outer-join-operator' Value: [descriptor-dependent]
[10/01/14 16:14:38.045]:JDBC ST:Parameter: 'include-table-filter' Value: [descriptor-dependent]
[10/01/14 16:14:38.045]:JDBC ST:Parameter: 'exclude-table-filter' Value: [descriptor-dependent]
[10/01/14 16:14:38.046]:JDBC ST:Parameter: 'function-return-method' Value: [descriptor-dependent]
[10/01/14 16:14:38.046]:JDBC ST:Parameter: 'state-dir' Value: '.'
[10/01/14 16:14:38.046]:JDBC ST:Parameter: 'supports-schemas-in-metadata-retrieval' Value: [descriptor-dependent]
[10/01/14 16:14:38.047]:JDBC ST:Parameter: 'column-position-comparator' Value: 'com.novell.nds.dirxml.driver.jdbc.util.config.com p.StringByteComparator'
[10/01/14 16:14:38.047]:JDBC ST:Parameter: 'time-syntax' Value: '1'
[10/01/14 16:14:38.047]:JDBC ST:Parameter: 'enable-locking' Value: false
[10/01/14 16:14:38.048]:JDBC STriverShim.init() returned:
[10/01/14 16:14:38.048]:JDBC ST:
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="ur

--------------------



Code:
--------------------

<publisher-options>
<disable display-name="Disable Publisher?">_</disable>
<publication-mode display-name="Publication mode:">_</publication-mode>
<log-table display-name="Event log table name:">eventlog</log-table>
<delete-from-log display-name="Delete processed rows?">0</delete-from-log>
<optimize-update display-name="Optimize updates?">_</optimize-update>
<allow-loopback display-name="Allow loopback?">_</allow-loopback>
<disable-locking display-name="Disable statement-level locking?">0</disable-locking>
<startup-option display-name="Startup option:">_</startup-option>
<handle-future-events display-name="Enable future event processing?">_</handle-future-events>
<ignore8 display-name="Use custom timestamp statement?">0</ignore8>
<current-timestamp-stmt display-name="Current timestamp statement:"></current-timestamp-stmt>
<ignore9 display-name="Show polling-related parameters?">show</ignore9>
<polling-interval display-name="Polling interval (in seconds):">1</polling-interval>
<time-of-day display-name="Polling time of day:"></time-of-day>
<post-poll-stmt display-name="Post polling statements:"></post-poll-stmt>
<batch-size display-name="Batch size:">4</batch-size>
<query-limit display-name="Query Limit (default 10000):">10000</query-limit>
<pub-heartbeat-interval display-name="Heartbeat interval (in minutes):">1</pub-heartbeat-interval>
</publisher-options>
</init-params>
</input>
</nds>
[10/01/14 16:14:38.235]:JDBC PT:Parameter: 'publication-mode' Value: 1
[10/01/14 16:14:38.237]:JDBC PT:Parameter: 'disable' Value: false
[10/01/14 16:14:38.239]:JDBC PT:Parameter: 'pub-heartbeat-interval' Value: 60000
[10/01/14 16:14:38.240]:JDBC PT:Parameter: 'batch-size' Value: 4
[10/01/14 16:14:38.242]:JDBC PT:Parameter: 'polling-interval' Value: 1000
[10/01/14 16:14:38.244]:JDBC PT:Parameter: 'disable-locking' Value: null
[10/01/14 16:14:38.246]:JDBC PT:Parameter: 'handle-future-events' Value: false
[10/01/14 16:14:38.248]:JDBC PT:Parameter: 'current-timestamp-stmt' Value: [descriptor-dependent]
[10/01/14 16:14:38.250]:JDBC PT:Parameter: 'log-table' Value: 'eventlog'
[10/01/14 16:14:38.252]:JDBC PT:Parameter: 'optimize-update' Value: false
[10/01/14 16:14:38.254]:JDBC PT:Parameter: 'delete-from-log' Value: false
[10/01/14 16:14:38.256]:JDBC PT:Parameter: 'allow-loopback' Value: false
[10/01/14 16:14:38.258]:JDBC PT:PublicationShim.init() returned:

--------------------


--
albertjanstevens
------------------------------------------------------------------------
albertjanstevens's Profile: https://forums.netiq.com/member.php?userid=664
View this thread: https://forums.netiq.com/showthread.php?t=51875