Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-3188

Generate model from DDL with UDF doesn't work

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Done
    • Affects Version/s: 11.1.3
    • Fix Version/s: 11.1.3
    • Component/s: Dynamic VDBs
    • Labels:
      None
    • Steps to Reproduce:
      Hide

      Generate models and VDB:

      1. Create the empty project
      2. Import viewUdfVDB-VDB.xml (from the attachment) to the project
      3. Right-click on the viewUdfVDB-VDB.xml and choose Modeling > Generate VDB Archive and Models and select View Model
      4. Click next and Generate button

      Import view model from the DDL file :

      1. Create the empty project
      2. Click File > Import
      3. Choose Teiid Designer > DDL File (Teiid) >> Source or View Model
      4. Choose _viewUdfModel.ddl _(from the attachment)
      5. Click next
      Show
      Generate models and VDB: Create the empty project Import viewUdfVDB-VDB.xml (from the attachment) to the project Right-click on the viewUdfVDB-VDB.xml and choose Modeling > Generate VDB Archive and Models and select View Model Click next and Generate button Import view model from the DDL file : Create the empty project Click File > Import Choose Teiid Designer > DDL File (Teiid) >> Source or View Model Choose _viewUdfModel.ddl _(from the attachment) Click next

      Description

      Generate models and VDB from dynamic VDB (XML file) which contains UDF function doesn't work. After click on generate button, "the problem occurred" windows appears (generate_from_xml.png) with

      An exception occurred while performing a VDB operation
       * null
      

      An exception stack trace is not available in the Error log.

      Also, generate view model from the DDL file which contains UDF function doesn't work. The last step in the wizard shows NullPointerException (generate_from_ddl.png) and in the log is this stack trace:

      java.lang.Exception: java.lang.NullPointerException
      	at org.teiid.core.designer.util.OperationUtil.perform(OperationUtil.java:54)
      	at org.teiid.designer.ddl.importer.DdlImporter.importDdl(DdlImporter.java:116)
      	at org.teiid.designer.ddl.importer.ui.DdlImportDifferencesPage$1.run(DdlImportDifferencesPage.java:232)
      	at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)
      Caused by: java.lang.NullPointerException
      	at java.util.Hashtable.put(Hashtable.java:460)
      	at org.teiid.designer.relational.model.RelationalProcedure.handleInfoChanged(RelationalProcedure.java:578)
      	at org.teiid.designer.relational.model.RelationalProcedure.setJavaMethodName(RelationalProcedure.java:321)
      	at org.teiid.designer.ddl.importer.node.teiid.TeiidDdlImporter.processTeiidProcedureOptions(TeiidDdlImporter.java:1189)
      	at org.teiid.designer.ddl.importer.node.teiid.TeiidDdlImporter.processTeiidStandardOptions(TeiidDdlImporter.java:996)
      	at org.teiid.designer.ddl.importer.node.teiid.TeiidDdlImporter.processOptions(TeiidDdlImporter.java:975)
      	at org.teiid.designer.ddl.importer.node.teiid.TeiidDdlImporter.createVirtualProcedure(TeiidDdlImporter.java:684)
      	at org.teiid.designer.ddl.importer.node.teiid.TeiidDdlImporter.createObject(TeiidDdlImporter.java:894)
      	at org.teiid.designer.ddl.importer.node.teiid.TeiidDdlImporter.importNode(TeiidDdlImporter.java:778)
      	at org.teiid.designer.ddl.importer.DdlImporter.importTeiidDdl(DdlImporter.java:322)
      	at org.teiid.designer.ddl.importer.DdlImporter.importDdl(DdlImporter.java:163)
      	at org.teiid.designer.ddl.importer.DdlImporter.importDdl(DdlImporter.java:151)
      	at org.teiid.designer.ddl.importer.DdlImporter$1.tryToDo(DdlImporter.java:132)
      	at org.teiid.core.designer.util.OperationUtil.perform(OperationUtil.java:41)
      	... 3 more
      

      I have tried all these cases with TD 11.1.1 and they work.

        Attachments

        1. generate_from_ddl.png
          generate_from_ddl.png
          150 kB
        2. generate_from_xml.png
          generate_from_xml.png
          150 kB
        3. viewUdfModel.ddl
          0.5 kB
        4. viewUdfVDB-vdb.xml
          0.9 kB

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            mkralik Matej Kralik
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: