Latvia Lotus User Group (www.vlaad.lv)

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
No Comments Found