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

Generate model from DDL with UDF doesn't work

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Blocker 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

      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.

        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

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

                Created:
                Updated:
                Resolved: