Skip to main content
Skip table of contents

com.menten.ieffect.mapper.db.engine.write.DataTargetException, SQL state [38501]; error code [-443]

Problem

In a mapping where datasets are written to a DB2 table, the SQL error described above may occur if there is a trigger program attached to the table that cannot be found.

Reason

The reason is the use of the "native" DB2 driver without specifying a library list in the URL.


Solution

The following change can be made in the file /i-effect/V2r9m0/mapper/db/preferences.xml":



BEFORE:

<url>jdbc:as400://mapmam;driver=native;naming=sql;date format=iso;translate binary=true</url>


AFTER:

<url>jdbc:as400://mapmam;naming=sql;date format=iso;translate binary=true</url>



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.