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

Generate model from DDL with UDF doesn't work

    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.

        Gliffy Diagrams

          Attachments

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

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: