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

Generate model from DDL with UDF doesn't work

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Blocker
    • 11.1.3
    • 11.1.3
    • Dynamic VDBs
    • None
    • 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

            Unassigned Unassigned
            mkralik@redhat.com Matej Kralik
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: