[ https://issues.jboss.org/browse/TEIIDDES-1645?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-1645: ----------------------------------- Description: 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} was: 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} -- 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