Advanced I Executive 5.Dec.08 02:04 PM a Web browser Profiles2.0Windows
I am having issues with the sync_all_dns.bat process since upgrading to 2.0.1 (with DB2 backend).
After cranking up the logging in the TDI config, it appears as though the PROF_DESCRIPTION field is causing the problems.
[AssemblyLine.AssemblyLines/sync_all_dns_hash_db.2] - [lookup_employees] CTGDIJ081I Retrieving attribute value based on the column name 'PROF_DESCRIPTION'.
[AssemblyLine.AssemblyLines/sync_all_dns_hash_db.2] - [lookup_employees] CTGDIS495I handleException , get, java.lang.NullPointerException
[AssemblyLine.AssemblyLines/sync_all_dns_hash_db.2] - [lookup_employees] CTGDIS810E handleException - cannot handle exception , get
java.lang.NullPointerException
at com.ibm.di.connector.JDBCConnector$SqlMap.buildEntry(Unknown Source)
In looking at the upgrade201.sql file for db2 in the wizard this column is now a CLOB, instead of VARCHAR (so is PROF_EXPERIENCE), and I am of the assumption that this is causing the problem.
Has anyone else seen this? Know how to resolve it?
Return to top
Profile Sync Errors 2.0.1 w/DB2 (Advanced I Exec... 5.Dec.08)
. . 
Print this page
