working with Date/Time Fields while synching IBM Domino with IBM Tivoli Directory Integrator
Vladislav Tatarincev 31 July 2017 16:45:26
If you try sync Date/TIME fields from SQL (JDBC connector) to IBM Domino database, you may see error similar to one below.Since it took me a while to solve this, I hope this will help some one sometimes.
16:44:48,020 ERROR - [LotusNotesConnector] CTGDIS810E handleException - cannot handle exception , addonly
NotesException: Unknown or unsupported object type in Vector
at lotus.domino.local.Document.NreplaceItemValue(Native Method)
at lotus.domino.local.Document.replaceItemValue(Unknown Source)
at com.ibm.di.connector.DominoConnector.inner_modDocument(DominoConnector.java:1328)
at com.ibm.di.connector.DominoConnector.inner_putEntry(DominoConnector.java:863)
at com.ibm.di.connector.DominoConnector.run(DominoConnector.java:1606)
at java.lang.Thread.run(Thread.java:736)
16:44:48,021 ERROR - CTGDIS266E Error in NextConnectorOperation. Exception occurred: NotesException: Unknown or unsupported object type in Vector
NotesException: Unknown or unsupported object type in Vector
at lotus.domino.local.Document.NreplaceItemValue(Native Method)
at lotus.domino.local.Document.replaceItemValue(Unknown Source)
at com.ibm.di.connector.DominoConnector.inner_modDocument(DominoConnector.java:1328)
at com.ibm.di.connector.DominoConnector.inner_putEntry(DominoConnector.java:863)
at com.ibm.di.connector.DominoConnector.run(DominoConnector.java:1606)
at java.lang.Thread.run(Thread.java:736)
16:44:48,030 INFO - CTGDIS100I Printing the Connector statistics.
Creating of fields with DateTime type may not give you best result.
Try to use following construction to create a DateTime object and fill it with proper value.
in may case attribute name was Sakuma_datums (Start Date)
var itemName = "sakuma_datums"
sqlDate = work.getObject(itemName);
javaDate = new java.util.Date(sqlDate.getTime());
session = LotusNotesConnector.connector.getDominoSession(); 'this creates session to IBM Domino
domDate = session.createDateTime(javaDate); 'we create kind of NotesDateTime variable and fill it with data
ret.value = domDate; 'we return attribute value
- Comments [0]