Hi,

I have a very straight forward JDBC driver, only syncing on publisher
channel.
Only one table, PERSON mapped to the user class in eDir.

However, when I run the driver it does the expected query when
converting the modify to add the RL converts the query to not onlt the
PERSON table as expected but involves 2 others as well and if I get any
result back from those (whitch I do) it errors out since those
attributes will not be filterd out by the filter.

How/where do I stop the RL from query the other 2 tables/views or if
that is some database voodoo I cant decide over is there a way to filter
out all attributes that are not present in the filter?

This is the Engine side query:
[04/25/14 07:20:24.233]:VS Extens VH-Medb PT:Applying schema mapping
policies to input.
[04/25/14 07:20:24.233]:VS Extens VH-Medb PT:Applying policy:
%+C%14CNOVLSYBDISYN-smp%-C.
[04/25/14 07:20:24.233]:VS Extens VH-Medb PT: Mapping class-name
'PERSON' to 'User'.
[04/25/14 07:20:24.233]:VS Extens VH-Medb PT: Mapping attr-name
'BIRTHDAY' to 'workforceID'.
[04/25/14 07:20:24.233]:VS Extens VH-Medb PT: Mapping attr-name
'BIRTHDAY' to 'workforceID'.
[04/25/14 07:20:24.233]:VS Extens VH-Medb PT: Mapping attr-name 'ADR'
to 'SA'.
[04/25/14 07:20:24.233]:VS Extens VH-Medb PT: Mapping attr-name 'ADR'
to 'SA'.
[04/25/14 07:20:24.233]:VS Extens VH-Medb PT: Mapping attr-name
'EFTERNAMN' to 'Surname'.
[04/25/14 07:20:24.233]:VS Extens VH-Medb PT: Mapping attr-name
'EFTERNAMN' to 'Surname'.
[04/25/14 07:20:24.233]:VS Extens VH-Medb PT: Mapping attr-name
'POSTNR' to 'Postal Code'.
[04/25/14 07:20:24.233]:VS Extens VH-Medb PT: Mapping attr-name
'POSTNR' to 'Postal Code'.
[04/25/14 07:20:24.233]:VS Extens VH-Medb PT: Mapping attr-name
'FORNAMN' to 'Given Name'.
[04/25/14 07:20:24.233]:VS Extens VH-Medb PT: Mapping attr-name
'FORNAMN' to 'Given Name'.
[04/25/14 07:20:24.233]:VS Extens VH-Medb PT: Mapping attr-name 'ORT'
to 'Physical Delivery Office Name'.
[04/25/14 07:20:24.233]:VS Extens VH-Medb PT: Mapping attr-name 'ORT'
to 'Physical Delivery Office Name'.
[04/25/14 07:20:24.233]:VS Extens VH-Medb PT: Mapping attr-name
'PERSONID' to 'vPersonnrShort'.
[04/25/14 07:20:24.233]:VS Extens VH-Medb PT: Mapping attr-name
'PERSONID' to 'vPersonnrShort'.
[04/25/14 07:20:24.233]:VS Extens VH-Medb PT:Resolving association
references.
[04/25/14 07:20:24.233]:VS Extens VH-Medb PT:No event transformation
policies.
[04/25/14 07:20:24.233]:VS Extens VH-Medb PT:No associated objects.
[04/25/14 07:20:24.233]:VS Extens VH-Medb PT:Applying publisher filter.
[04/25/14 07:20:24.233]:VS Extens VH-Medb PT:Publisher processing modify
for PERSONID=123456-1234,table=PERSON.
[04/25/14 07:20:24.233]:VS Extens VH-Medb PT:Converting <modify> to
<add>
[04/25/14 07:20:24.233]:VS Extens VH-Medb PT:Reading relevant attributes
from PERSONID=123456-1234,table=PERSON.
[04/25/14 07:20:24.233]:VS Extens VH-Medb PT:
<nds dtdversion="4.0" ndsversion="8.x">
<source>
<product edition="Advanced" version="4.0.2.4">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<query class-name="User" scope="entry">
<association>PERSONID=123456-1234,table=PERSON</association>
<read-attr attr-name="Given Name"/>
<read-attr attr-name="Physical Delivery Office Name"/>
<read-attr attr-name="Postal Code"/>
<read-attr attr-name="SA"/>
<read-attr attr-name="Surname"/>
<read-attr attr-name="vPersonnrShort"/>
<read-attr attr-name="workforceID"/>
</query>
</input>
</nds>

RL side:
DirXML: [04/25/14 07:20:24.24]: TRACE: Remote Loader: DirXML returned:
DirXML: [04/25/14 07:20:24.24]: TRACE: <nds dtdversion="4.0"
ndsversion="8.x">
<source>
<product edition="Advanced" version="4.0.2.4">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<query class-name="PERSON" event-id="0" scope="entry">
<association>PERSONID=123456-1234,table=PERSON</association>
<read-attr attr-name="FORNAMN"/>
<read-attr attr-name="ORT"/>
<read-attr attr-name="POSTNR"/>
<read-attr attr-name="ADR"/>
<read-attr attr-name="EFTERNAMN"/>
<read-attr attr-name="PERSONID"/>
<read-attr attr-name="BIRTHDAY"/>
</query>
</input>
</nds>
DirXML: [04/25/14 07:20:24.24]: TRACE: SELECT PERSONID, BIRTHDAY, ADR,
EFTERNAMN, POSTNR, FORNAMN, ORT FROM PERSON WHERE PERSONID = ?
DirXML: [04/25/14 07:20:24.24]: TRACE: IN @ index 1, field
'PERSONID', length: 11, value = '123456-1234'
DirXML: [04/25/14 07:20:24.24]: TRACE: RS field 'BIRTHDAY', length:
10, value = '1912-34-56'
DirXML: [04/25/14 07:20:24.24]: TRACE: RS field 'ADR', length: 13,
value = 'Vgen 1'
DirXML: [04/25/14 07:20:24.24]: TRACE: RS field 'EFTERNAMN', length:
9, value = 'Andersson'
DirXML: [04/25/14 07:20:24.24]: TRACE: RS field 'POSTNR', length: 6,
value = '123 12'
DirXML: [04/25/14 07:20:24.24]: TRACE: RS field 'FORNAMN', length: 6,
value = 'Anders'
DirXML: [04/25/14 07:20:24.24]: TRACE: RS field 'ORT', length: 7,
value = 'City'
DirXML: [04/25/14 07:20:24.24]: TRACE: RS field 'PERSONID', length:
11, value = '123456-1234'
DirXML: [04/25/14 07:20:24.26]: TRACE: SELECT PERSONIDHANDLED, PERSONID
FROM IST.AKTIVITET WHERE PERSONIDHANDLED = ?
DirXML: [04/25/14 07:20:24.26]: TRACE: IN @ index 1, field
'PERSONIDHANDLED', length: 11, value = '123456-1234'
DirXML: [04/25/14 07:20:24.26]: TRACE: SELECT MOTTAGARID, ADR, POSTNR,
ORT FROM IST.RAKNINGSMOTTAGARE WHERE MOTTAGARID = ?
DirXML: [04/25/14 07:20:24.26]: TRACE: IN @ index 1, field
'MOTTAGARID', length: 11, value = '123456-1234'
DirXML: [04/25/14 07:20:24.28]: TRACE: RS field 'ADR', value = null
DirXML: [04/25/14 07:20:24.28]: TRACE: RS field 'POSTNR', value =
null
DirXML: [04/25/14 07:20:24.28]: TRACE: RS field 'ORT', value = null
DirXML: [04/25/14 07:20:24.28]: TRACE: RS field 'ADR', value = null
DirXML: [04/25/14 07:20:24.28]: TRACE: RS field 'POSTNR', value =
null
DirXML: [04/25/14 07:20:24.28]: TRACE: RS field 'ORT', value = null
DirXML: [04/25/14 07:20:24.28]: TRACE: RS field 'ADR', length: 17,
value = 'Vgen 2'
DirXML: [04/25/14 07:20:24.28]: TRACE: RS field 'POSTNR', length: 6,
value = '124 14'
DirXML: [04/25/14 07:20:24.28]: TRACE: RS field 'ORT', length: 7,
value = 'City'
DirXML: [04/25/14 07:20:24.28]: TRACE: RS field 'ADR', length: 0,
value = ''
DirXML: [04/25/14 07:20:24.28]: TRACE: RS field 'POSTNR', length: 0,
value = ''
DirXML: [04/25/14 07:20:24.28]: TRACE: RS field 'ORT', length: 0,
value = ''
DirXML: [04/25/14 07:20:24.28]: TRACE: RS field 'ADR', value = null
DirXML: [04/25/14 07:20:24.28]: TRACE: RS field 'POSTNR', value =
null
DirXML: [04/25/14 07:20:24.28]: TRACE: RS field 'ORT', value = null
DirXML: [04/25/14 07:20:24.28]: TRACE: RS field 'ADR', value = null
DirXML: [04/25/14 07:20:24.28]: TRACE: RS field 'POSTNR', value =
null
DirXML: [04/25/14 07:20:24.28]: TRACE: RS field 'ORT', value = null
DirXML: [04/25/14 07:20:24.28]: TRACE: RS field 'ADR', value = null
DirXML: [04/25/14 07:20:24.28]: TRACE: RS field 'POSTNR', value =
null
DirXML: [04/25/14 07:20:24.28]: TRACE: RS field 'ORT', value = null
DirXML: [04/25/14 07:20:24.28]: TRACE: Remote Loader: Sending...


--
joakim_ganse
------------------------------------------------------------------------
joakim_ganse's Profile: https://forums.netiq.com/member.php?userid=159
View this thread: https://forums.netiq.com/showthread.php?t=50651