[JBoss JIRA] (TEIIDDES-1652) Preview VDB for Teiid Source imported table contains loopback translator type
by Barry LaFond (JIRA)
Barry LaFond created TEIIDDES-1652:
--------------------------------------
Summary: Preview VDB for Teiid Source imported table contains loopback translator type
Key: TEIIDDES-1652
URL: https://issues.jboss.org/browse/TEIIDDES-1652
Project: Teiid Designer
Issue Type: Bug
Components: Data Preview
Affects Versions: 8.1
Reporter: Barry LaFond
Assignee: Mark Drilling
Fix For: 8.1
* Installed a new kit with Teiid Source DDL importer option
* Imported from SQL Server Parts schema to create PartsSupplier model
* Tried to preview right away and got "Set Connection Profile" warning
* Set connection profile
* Previewed and it returned Loopback "ABCDEFJHI" data
* Checked deployed Preview VDB vdb.xml and translator-name == "loopback"
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years
[JBoss JIRA] (TEIIDDES-1650) Filter Preview sources from Teiid Importer
by Mark Drilling (JIRA)
Mark Drilling created TEIIDDES-1650:
---------------------------------------
Summary: Filter Preview sources from Teiid Importer
Key: TEIIDDES-1650
URL: https://issues.jboss.org/browse/TEIIDDES-1650
Project: Teiid Designer
Issue Type: Enhancement
Components: Import/Export
Affects Versions: 8.1
Reporter: Mark Drilling
Assignee: Mark Drilling
Fix For: 8.1
In the Teiid Importer, all of the preview sources are shown. They should be filtered out of the importer source listing.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years
[JBoss JIRA] (TEIIDDES-1649) Update Modeshape jars prior to final release
by Mark Drilling (JIRA)
Mark Drilling created TEIIDDES-1649:
---------------------------------------
Summary: Update Modeshape jars prior to final release
Key: TEIIDDES-1649
URL: https://issues.jboss.org/browse/TEIIDDES-1649
Project: Teiid Designer
Issue Type: Task
Components: Import/Export
Affects Versions: 8.1
Reporter: Mark Drilling
Assignee: Mark Drilling
Fix For: 8.1
The current Designer Modeshape jars are a 3.2 snapshot build from 12April 2013. The modeshape jars need to be updated to 3.2 final when available.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years
[JBoss JIRA] (TEIIDDES-1648) Update DDL Importer to handle Teiid DDL
by Mark Drilling (JIRA)
Mark Drilling created TEIIDDES-1648:
---------------------------------------
Summary: Update DDL Importer to handle Teiid DDL
Key: TEIIDDES-1648
URL: https://issues.jboss.org/browse/TEIIDDES-1648
Project: Teiid Designer
Issue Type: Feature Request
Components: Import/Export
Affects Versions: 8.1
Reporter: Mark Drilling
Assignee: Mark Drilling
Fix For: 8.1
Update the DDL Importer to handle import of Teiid DDL dialect. This required update of the Modeshape sequencer jars.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years
[JBoss JIRA] (TEIIDDES-1644) Eclipse Juno SR2 throws exceptions for option "Generate File Translator Procedures"
by Lucie Fabrikova (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1644?page=com.atlassian.jira.plu... ]
Lucie Fabrikova updated TEIIDDES-1644:
--------------------------------------
Environment:
- Fedora 17,
- eclipse juno, SR2
- abridged jboss tools 4.0 from http://download.jboss.org/jbosstools/updates/development/juno
- teiid designer 8.1.alpha2
was:
- Fedora 17,
- eclipse juno 4.2, SR2
- abridged jboss tools 4.0 from http://download.jboss.org/jbosstools/updates/development/juno
- teiid designer 8.1.alpha2
> Eclipse Juno SR2 throws exceptions for option "Generate File Translator Procedures"
> -----------------------------------------------------------------------------------
>
> Key: TEIIDDES-1644
> URL: https://issues.jboss.org/browse/TEIIDDES-1644
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.0, 8.1
> Environment: - Fedora 17,
> - eclipse juno, SR2
> - abridged jboss tools 4.0 from http://download.jboss.org/jbosstools/updates/development/juno
> - teiid designer 8.1.alpha2
> Reporter: Lucie Fabrikova
>
> Alert appears while creating new Teiid Metadata Model (Relational source model), option Generate File Translator Procedures: when I leave all default options and click Finish, model is created, however an alert appears:
> Error creating XML documents
> Failed to execute runnable (java.lang.NoSuchMethodError: org.eclipse.ui.internal.PopupMenuExtender.<init>(Ljava/lang/String;Lorg/eclipse/jface/action/MenuManager;Lorg/eclipse/jface/viewers/ISelectionProvider;Lorg/eclipse/ui/IWorkbenchPart;)V)
> and next:
> Error creating XML documents
> Could not create new module due to Exception: java.lang.NullPointerException
> Eclipse console:
> Exception in thread "org.teiid.designer.ui.common.viewsupport.UiBusyIndicator runnable parent thread" org.eclipse.swt.SWTException: Failed to execute runnable (java.lang.NoSuchMethodError: org.eclipse.ui.internal.PopupMenuExtender.<init>(Ljava/lang/String;Lorg/eclipse/jface/action/MenuManager;Lorg/eclipse/jface/viewers/ISelectionProvider;Lorg/eclipse/ui/IWorkbenchPart;)V)
> at org.eclipse.swt.SWT.error(SWT.java:4361)
> at org.eclipse.swt.SWT.error(SWT.java:4276)
> at org.eclipse.swt.widgets.Synchronizer.syncExec(Synchronizer.java:196)
> at org.eclipse.ui.internal.UISynchronizer.syncExec(UISynchronizer.java:150)
> at org.eclipse.swt.widgets.Display.syncExec(Display.java:4299)
> at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator$2.run(UiBusyIndicator.java:202)
> at java.lang.Thread.run(Thread.java:662)
> Caused by: java.lang.NoSuchMethodError: org.eclipse.ui.internal.PopupMenuExtender.<init>(Ljava/lang/String;Lorg/eclipse/jface/action/MenuManager;Lorg/eclipse/jface/viewers/ISelectionProvider;Lorg/eclipse/ui/IWorkbenchPart;)V
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years
[JBoss JIRA] (TEIIDDES-1644) Eclipse Juno SR2 throws exceptions for option "Generate File Translator Procedures"
by Lucie Fabrikova (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1644?page=com.atlassian.jira.plu... ]
Lucie Fabrikova updated TEIIDDES-1644:
--------------------------------------
Environment:
- Fedora 17,
- eclipse juno 4.2, SR2
- abridged jboss tools 4.0 from http://download.jboss.org/jbosstools/updates/development/juno
- teiid designer 8.1.alpha2
was:
- Fedora 17,
- my default java is from oracle jdk1.6.0_33, however in Preferences/Java there is java jre1.7.0_17
- eclipse juno 4.2, SR2
- abridged jboss tools 4.0 from http://download.jboss.org/jbosstools/updates/development/juno
- teiid designer 8.1.alpha2
> Eclipse Juno SR2 throws exceptions for option "Generate File Translator Procedures"
> -----------------------------------------------------------------------------------
>
> Key: TEIIDDES-1644
> URL: https://issues.jboss.org/browse/TEIIDDES-1644
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.0, 8.1
> Environment: - Fedora 17,
> - eclipse juno 4.2, SR2
> - abridged jboss tools 4.0 from http://download.jboss.org/jbosstools/updates/development/juno
> - teiid designer 8.1.alpha2
> Reporter: Lucie Fabrikova
>
> Alert appears while creating new Teiid Metadata Model (Relational source model), option Generate File Translator Procedures: when I leave all default options and click Finish, model is created, however an alert appears:
> Error creating XML documents
> Failed to execute runnable (java.lang.NoSuchMethodError: org.eclipse.ui.internal.PopupMenuExtender.<init>(Ljava/lang/String;Lorg/eclipse/jface/action/MenuManager;Lorg/eclipse/jface/viewers/ISelectionProvider;Lorg/eclipse/ui/IWorkbenchPart;)V)
> and next:
> Error creating XML documents
> Could not create new module due to Exception: java.lang.NullPointerException
> Eclipse console:
> Exception in thread "org.teiid.designer.ui.common.viewsupport.UiBusyIndicator runnable parent thread" org.eclipse.swt.SWTException: Failed to execute runnable (java.lang.NoSuchMethodError: org.eclipse.ui.internal.PopupMenuExtender.<init>(Ljava/lang/String;Lorg/eclipse/jface/action/MenuManager;Lorg/eclipse/jface/viewers/ISelectionProvider;Lorg/eclipse/ui/IWorkbenchPart;)V)
> at org.eclipse.swt.SWT.error(SWT.java:4361)
> at org.eclipse.swt.SWT.error(SWT.java:4276)
> at org.eclipse.swt.widgets.Synchronizer.syncExec(Synchronizer.java:196)
> at org.eclipse.ui.internal.UISynchronizer.syncExec(UISynchronizer.java:150)
> at org.eclipse.swt.widgets.Display.syncExec(Display.java:4299)
> at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator$2.run(UiBusyIndicator.java:202)
> at java.lang.Thread.run(Thread.java:662)
> Caused by: java.lang.NoSuchMethodError: org.eclipse.ui.internal.PopupMenuExtender.<init>(Ljava/lang/String;Lorg/eclipse/jface/action/MenuManager;Lorg/eclipse/jface/viewers/ISelectionProvider;Lorg/eclipse/ui/IWorkbenchPart;)V
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years
[JBoss JIRA] (TEIIDDES-1645) IllegalArgumentException setting SQL text for procedure
by Paul Richardson (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1645?page=com.atlassian.jira.plu... ]
Paul Richardson resolved TEIIDDES-1645.
---------------------------------------
Assignee: Paul Richardson
Resolution: Done
> IllegalArgumentException setting SQL text for procedure
> -------------------------------------------------------
>
> Key: TEIIDDES-1645
> URL: https://issues.jboss.org/browse/TEIIDDES-1645
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Transformations
> Affects Versions: 8.1
> Reporter: Barry LaFond
> Assignee: Paul Richardson
> Priority: Critical
> Fix For: 8.1
>
> Attachments: E2eVirtualProceduresTestScript_Teiid7.pdf, TEIIDDES-1645_MPS.zip
>
>
> While running our E2EVirtualProceduresTestScript (attached) the Transformation frameowork has issues with null datatype being passed down to the datatype finder.
> This occurs on most of the procedures creation in this test.
> {code}
> ava.lang.IllegalArgumentException: Expected argument to be non-null but got null
> at org.teiid.core.util.ArgCheck.isNotNull(ArgCheck.java:303)
> at org.teiid.core.util.ArgCheck.isNotNull(ArgCheck.java:289)
> at org.teiid83.type.DataTypeManagerService.getDataTypeClass(DataTypeManagerService.java:68)
> at org.teiid.designer.transformation.util.TransformationMappingHelper.getDatatype(TransformationMappingHelper.java:1500)
> at org.teiid.designer.transformation.util.TransformationMappingHelper.setAttributeType(TransformationMappingHelper.java:1443)
> at org.teiid.designer.transformation.util.TransformationMappingHelper.setGroupAttributeTypes(TransformationMappingHelper.java:1322)
> at org.teiid.designer.transformation.util.TransformationMappingHelper.reconcileTargetAttributes(TransformationMappingHelper.java:769)
> at org.teiid.designer.transformation.util.TransformationMappingHelper.reconcileTargetAttributes(TransformationMappingHelper.java:823)
> at org.teiid.designer.transformation.util.TransformationMappingHelper.reconcileMappingsOnSqlChange(TransformationMappingHelper.java:144)
> at org.teiid.designer.transformation.ui.editors.TransformationObjectEditorPage.handleSqlEditorCommandEvent(TransformationObjectEditorPage.java:2729)
> at org.teiid.designer.transformation.ui.editors.TransformationObjectEditorPage.handleSqlEditorEvent(TransformationObjectEditorPage.java:2689)
> at org.teiid.designer.transformation.ui.editors.TransformationObjectEditorPage.processEvent(TransformationObjectEditorPage.java:2649)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.notifyEventListeners(SqlEditorPanel.java:702)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.fireEditorEvent(SqlEditorPanel.java:646)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel$DocumentChangeListener.documentChanged(SqlEditorPanel.java:2215)
> at org.eclipse.jface.text.AbstractDocument.doFireDocumentChanged2(AbstractDocument.java:769)
> at org.eclipse.jface.text.AbstractDocument.doFireDocumentChanged(AbstractDocument.java:736)
> at org.eclipse.jface.text.AbstractDocument.doFireDocumentChanged(AbstractDocument.java:721)
> at org.eclipse.jface.text.AbstractDocument.fireDocumentChanged(AbstractDocument.java:796)
> at org.eclipse.jface.text.AbstractDocument.set(AbstractDocument.java:1237)
> at org.eclipse.jface.text.AbstractDocument.set(AbstractDocument.java:1217)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.refreshWithDisplayComponent(SqlEditorPanel.java:608)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.setTextInTransaction(SqlEditorPanel.java:476)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel$5.run(SqlEditorPanel.java:517)
> {code}
> * Import attached project
> * open the MMSP03_A procedure in PartsVirtual.xmi model
> * Paste the following SQL text in the transformation editor and click Validate
> {code}
> CREATE VIRTUAL PROCEDURE
> BEGIN
> DECLARE short VARIABLES.x;
> LOOP ON (SELECT PartsVirtual.SupplierInfo.QUANTITY FROM PartsVirtual.SupplierInfo ORDER BY quantity) AS quantityCursor
> BEGIN
> VARIABLES.x = convert((quantityCursor.QUANTITY - 1), short);
> IF(VARIABLES.x = 100)
> BEGIN
> BREAK;
> END
> ELSE
> BEGIN
> CONTINUE;
> END
> END
> SELECT PartsVirtual.SupplierInfo.QUANTITY, VARIABLES.x FROM PartsVirtual.SupplierInfo WHERE PartsVirtual.SupplierInfo.QUANTITY >= VARIABLES.x;
> END
> {code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years