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}