Environment
Novell Identity Manager Driver- JDBC Driver
Novell Identity Manager Identity Manager 3.5
Situation
Upgraded from Novell Identity Manager 3.01 to
3.5.
Upgraded the JDBC Driver.
Now getting NullPointerException errors during
synchronization.
Engine Trace:
05/07/07 13:21:02.150]:JDBC -> PT:
Remote Loader Trace shows that there are several NULL values
in data fields.
Ex.DirXML: [05/07/07 13:21:02.04]: TRACE: record_id: 20734623
DirXML: [05/07/07 13:21:02.04]: TRACE: table_key: 'EMEMP#=2005134'
DirXML: [05/07/07 13:21:02.04]: TRACE: status: 'N'
DirXML: [05/07/07 13:21:02.04]: TRACE: event_type: 2; update field
DirXML: [05/07/07 13:21:02.04]: TRACE: perpetrator: NULL
DirXML: [05/07/07 13:21:02.04]: TRACE: table_name: 'cims_emp'
DirXML: [05/07/07 13:21:02.04]: TRACE: column_name: 'emtdat'
DirXML: [05/07/07 13:21:02.04]: TRACE: old_value: NULL
DirXML: [05/07/07 13:21:02.04]: TRACE: new_value: NULL
DirXML: [05/07/07 13:21:02.04]: TRACE: table_key: 'EMEMP#=2005134'
DirXML: [05/07/07 13:21:02.04]: TRACE: status: 'N'
DirXML: [05/07/07 13:21:02.04]: TRACE: event_type: 2; update field
DirXML: [05/07/07 13:21:02.04]: TRACE: perpetrator: NULL
DirXML: [05/07/07 13:21:02.04]: TRACE: table_name: 'cims_emp'
DirXML: [05/07/07 13:21:02.04]: TRACE: column_name: 'emtdat'
DirXML: [05/07/07 13:21:02.04]: TRACE: old_value: NULL
DirXML: [05/07/07 13:21:02.04]: TRACE: new_value: NULL
We also see that these Null values are OK according to the
definitions in the remote loader trace:
Ex.
DirXML: [05/07/07 13:19:41.86]: TRACE: Name: 'perpetrator'
DirXML: [05/07/07 13:19:41.86]: TRACE: SQL Type: java.sql.Types.VARCHAR
DirXML: [05/07/07 13:19:41.86]: TRACE: Native Type: varchar
DirXML: [05/07/07 13:19:41.86]: TRACE: Parameter Type: IN
DirXML: [05/07/07 13:19:41.86]: TRACE: Length: 64
DirXML: [05/07/07 13:19:41.86]: TRACE: Position: 6
DirXML: [05/07/07 13:19:41.86]: TRACE: Nullable: YES
DirXML: [05/07/07 13:19:41.86]: TRACE: SQL Type: java.sql.Types.VARCHAR
DirXML: [05/07/07 13:19:41.86]: TRACE: Native Type: varchar
DirXML: [05/07/07 13:19:41.86]: TRACE: Parameter Type: IN
DirXML: [05/07/07 13:19:41.86]: TRACE: Length: 64
DirXML: [05/07/07 13:19:41.86]: TRACE: Position: 6
DirXML: [05/07/07 13:19:41.86]: TRACE: Nullable: YES
Search: unkown source GetPerpetrator
getPerpetratorsAsString appendCustomEventInfo 851 595 -851
-595