Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4146

Using JDG Library Mode, unable to perform insert (

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Critical Critical
    • 9.0, 8.12.5
    • 8.12.5
    • Misc. Connectors
    • None

      Trying to run the JDG local cache quickstart, get the following error when trying to perform an insert:

      15:09:34,027 WARN [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue12) TEIID30020 Processing exception for request O25SlCY41bD5.6 'TEIID30492 Element StockCache.Stock.StockObject of StockCache.Stock is neither nullable nor has a default value. A value must be specified in the insert.'. Originally QueryValidatorException Request.java:330. Enable more detailed logging to see the entire stacktrace.

      The issue is because the StockObject column is set to be NullType.unknown, instead of NullType.Nullable. This is because the metadata processor in the translator-object is setting it incorrectly.

      Workaround:

      • Using Teiid Designer to import the source model and change the null type.
      • use dynamic vdb and define the DDL metadata to set the null type.

              van.halbert Van Halbert (Inactive)
              van.halbert Van Halbert (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: