Highlighted
Absent Member.
Absent Member.
423 views

Group Membership error with JDBC driver


Hi guys,

We have migrated to a new database, using Microsoft SQL 2008. In this
change the database schema (fields) have changed in the new database but
this has been reflected in the mapping rules.

We are getting the following error when adding a user membership to a
group. Both user and group are associated to the driver.

Can someone please offer me their opinion on why this user does not go
into the group. Thank you.


[11/09/11 13:32:34.470]:DATACENTRAL2 PT:SELECT * FROM
dirxmllog.DC_DirXML_EventLog WHERE status = 'N' ORDER BY record_id ASC
[11/09/11 13:32:34.501]:DATACENTRAL2 PT:BEGIN Row.
[11/09/11 13:32:34.501]:DATACENTRAL2 PT: record_id: 615385
[11/09/11 13:32:34.502]:DATACENTRAL2 PT: table_key:
'employeeID=testNew'
[11/09/11 13:32:34.502]:DATACENTRAL2 PT: status: 'N'
[11/09/11 13:32:34.502]:DATACENTRAL2 PT: event_type: 1; insert field
[11/09/11 13:32:34.503]:DATACENTRAL2 PT: perpetrator: 'dbo'
[11/09/11 13:32:34.503]:DATACENTRAL2 PT: table_name:
'DC_Network_Users_Groups'
[11/09/11 13:32:34.503]:DATACENTRAL2 PT: column_name: 'groupID'
[11/09/11 13:32:34.504]:DATACENTRAL2 PT: old_value: NULL
[11/09/11 13:32:34.504]:DATACENTRAL2 PT: new_value: 'AANewGroup'
[11/09/11 13:32:34.504]:DATACENTRAL2 PT:END Row.
[11/09/11 13:32:34.505]:DATACENTRAL2 PT:Receiving DOM document from
application.
[11/09/11 13:32:34.505]:DATACENTRAL2 PT:
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20100817_0504" instance="DC-LUKE"
version="3.5.5">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<status event-id="615385" level="error" type="driver-general">
<description>Invalid row: 615385. Invalid value for column
'table_key'. Incomplete key. Number of RDNs does not match number of
columns in key.</description>
</status>
</input>
</nds>
[11/09/11 13:32:34.508]:DATACENTRAL2 PT:No input transformation
policies.
[11/09/11 13:32:34.508]:DATACENTRAL2 PT:Applying schema mapping
policies to input.
[11/09/11 13:32:34.509]:DATACENTRAL2 PT:Applying policy:
%+C%14CMappingRule%-C.
[11/09/11 13:32:34.509]:DATACENTRAL2 PT:Resolving association
references.
[11/09/11 13:32:34.510]:DATACENTRAL2 PT:No event transformation
policies.
[11/09/11 13:32:34.510]:DATACENTRAL2 PT:Applying publisher filter.
[11/09/11 13:32:34.511]:DATACENTRAL2 PT:Publisher processing status for
Labels (1)
0 Likes
2 Replies
Highlighted
Absent Member.
Absent Member.

Re: Group Membership error with JDBC driver

Looks like you have an invalid relationship in the key between this
child table and the parent table.
In English:
Your event shows "employeeID=testNew"
For one I suspect that is not a valid value.
Two, is there a corresponding person with an employeeID of "testNew" in
the users table? If not, this won't work.


On 11/8/2011 8:46 PM, billykot28 wrote:
>
> Hi guys,
>
> We have migrated to a new database, using Microsoft SQL 2008. In this
> change the database schema (fields) have changed in the new database but
> this has been reflected in the mapping rules.
>
> We are getting the following error when adding a user membership to a
> group. Both user and group are associated to the driver.
>
> Can someone please offer me their opinion on why this user does not go
> into the group. Thank you.
>
>
> [11/09/11 13:32:34.470]:DATACENTRAL2 PT:SELECT * FROM
> dirxmllog.DC_DirXML_EventLog WHERE status = 'N' ORDER BY record_id ASC
> [11/09/11 13:32:34.501]:DATACENTRAL2 PT:BEGIN Row.
> [11/09/11 13:32:34.501]:DATACENTRAL2 PT: record_id: 615385
> [11/09/11 13:32:34.502]:DATACENTRAL2 PT: table_key:
> 'employeeID=testNew'
> [11/09/11 13:32:34.502]:DATACENTRAL2 PT: status: 'N'
> [11/09/11 13:32:34.502]:DATACENTRAL2 PT: event_type: 1; insert field
> [11/09/11 13:32:34.503]:DATACENTRAL2 PT: perpetrator: 'dbo'
> [11/09/11 13:32:34.503]:DATACENTRAL2 PT: table_name:
> 'DC_Network_Users_Groups'
> [11/09/11 13:32:34.503]:DATACENTRAL2 PT: column_name: 'groupID'
> [11/09/11 13:32:34.504]:DATACENTRAL2 PT: old_value: NULL
> [11/09/11 13:32:34.504]:DATACENTRAL2 PT: new_value: 'AANewGroup'
> [11/09/11 13:32:34.504]:DATACENTRAL2 PT:END Row.
> [11/09/11 13:32:34.505]:DATACENTRAL2 PT:Receiving DOM document from
> application.
> [11/09/11 13:32:34.505]:DATACENTRAL2 PT:
> <nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
> <source>
> <product build="20100817_0504" instance="DC-LUKE"
> version="3.5.5">DirXML Driver for JDBC</product>
> <contact>Novell, Inc.</contact>
> </source>
> <input>
> <status event-id="615385" level="error" type="driver-general">
> <description>Invalid row: 615385. Invalid value for column
> 'table_key'. Incomplete key. Number of RDNs does not match number of
> columns in key.</description>
> </status>
> </input>
> </nds>
> [11/09/11 13:32:34.508]:DATACENTRAL2 PT:No input transformation
> policies.
> [11/09/11 13:32:34.508]:DATACENTRAL2 PT:Applying schema mapping
> policies to input.
> [11/09/11 13:32:34.509]:DATACENTRAL2 PT:Applying policy:
> %+C%14CMappingRule%-C.
> [11/09/11 13:32:34.509]:DATACENTRAL2 PT:Resolving association
> references.
> [11/09/11 13:32:34.510]:DATACENTRAL2 PT:No event transformation
> policies.
> [11/09/11 13:32:34.510]:DATACENTRAL2 PT:Applying publisher filter.
> [11/09/11 13:32:34.511]:DATACENTRAL2 PT:Publisher processing status for


0 Likes
Highlighted
Absent Member.
Absent Member.

Re: Group Membership error with JDBC driver

billykot28,

It appears that in the past few days you have not received a response to your
posting. That concerns us, and has triggered this automated reply.

Has your problem been resolved? If not, you might try one of the following options:

- Visit http://support.novell.com and search the knowledgebase and/or check all
the other self support options and support programs available.
- You could also try posting your message again. Make sure it is posted in the
correct newsgroup. (http://forums.novell.com)

Be sure to read the forum FAQ about what to expect in the way of responses:
http://forums.novell.com/faq.php

If this is a reply to a duplicate posting, please ignore and accept our apologies
and rest assured we will issue a stern reprimand to our posting bot.

Good luck!

Your Novell Product Support Forums Team
http://forums.novell.com/

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.