|
| Oracle JDBC driver - Invalid value for column 'TABLE_KEY' |
 |
Thu, 15 May 2008 16:46:02 GMT |
We're trying to change our event log to key off of a new column.
PK_EMPLOYEE_NUMBER instead of PK_ENCRYPTED_EMPLID. However, even
though the event log is updated and the events appear with the new name
we receive the following error from the driver:
Message: <description>Invalid row: 276024. Invalid value for column
'TABLE_KEY'. Incomplete key. Number of RDNs does not match number of
columns in key.</description>
I've updated the driver's schema to include this new column and have it
mapped to an attribute in eDir. I've refreshed the application schema
through iManager and it sees the new attributes. Then I just tried
rebuilding the driver from scratch... that didn't help either. :(
Example eventlog entry:
RECORD_ID, TABLE_KEY, STATUS, EVENT_TYPE, EVENT_TIME, PERPETRATOR,
TABLE_NAME, COLUMN_NAME OLD_VALUE, NEW_VALUE
1000, PK_EMPLOYEE_NUMBER=29770, N, 6, 2008-05-01 09:40:00, UserID,
EDIR_VW_TEST, NULL, NULL, NULL
I'm not entirely sure what step I've forgotten since the driver still
works if I create an eventlog entry for the PK_ENCRYPTED_EMPLID
manually...
I've gone through more hair pulling and driver changing trying to get
this to work to no avail. I feel like I'm missing something obvious,
but I'm not sure what it is. Does anyone have any ideas on how to
resolve this issue or perhaps where to look next? Please let me know.
:)
Thanks,
James
--
JWMerrow
------------------------------------------------------------------------
JWMerrow's Profile: http://forums.novell.com/member.php?userid=882
View this thread: http://forums.novell.com/showthread.php?t=328108
|
| Post Reply
|
| Re: Oracle JDBC driver - Invalid value for column 'TABLE_KEY' |
 |
Fri, 16 May 2008 14:26:02 GMT |
JWMerrow;1558327 Wrote:
> We're trying to change our event log to key off of a new column.
> PK_EMPLOYEE_NUMBER instead of PK_ENCRYPTED_EMPLID. However, even
> though the event log is updated and the events appear with the new name
> we receive the following error from the driver:
>
> Message: <description>Invalid row: 276024. Invalid value for column
> 'TABLE_KEY'. Incomplete key. Number of RDNs does not match number of
> columns in key.</description>
>
> I've updated the driver's schema to include this new column and have it
> mapped to an attribute in eDir. I've refreshed the application schema
> through iManager and it sees the new attributes. Then I just tried
> rebuilding the driver from scratch... that didn't help either. :(
>
> Example eventlog entry:
> RECORD_ID, TABLE_KEY, STATUS, EVENT_TYPE, EVENT_TIME, PERPETRATOR,
> TABLE_NAME, COLUMN_NAME OLD_VALUE, NEW_VALUE
> 1000, PK_EMPLOYEE_NUMBER=29770, N, 6, 2008-05-01 09:40:00, UserID,
> EDIR_VW_TEST, NULL, NULL, NULL
>
> I'm not entirely sure what step I've forgotten since the driver still
> works if I create an eventlog entry for the PK_ENCRYPTED_EMPLID
> manually...
>
> I've gone through more hair pulling and driver changing trying to get
> this to work to no avail. I feel like I'm missing something obvious,
> but I'm not sure what it is. Does anyone have any ideas on how to
> resolve this issue or perhaps where to look next? Please let me know.
> :)
>
>
> Thanks,
> James
I was able to find a solution that seems to work. I renamed the column
of PK_ENCRYPTED_EMPLID to ENCRYPTED_EMPLID and refreshed the application
schema. After that I was able to synch on the new key. :)
-James
--
JWMerrow
------------------------------------------------------------------------
JWMerrow's Profile: http://forums.novell.com/member.php?userid=882
View this thread: http://forums.novell.com/showthread.php?t=328108
|
| Post Reply
|
|
|
|
|
|
|
|
|
|