[teiid-issues] [JBoss JIRA] (TEIID-5180) Execution of stored procedure with parameters failed on Teiid

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-5180?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-5180.
-----------------------------------
    Fix Version/s: 10.1
       Resolution: Partially Completed


Marking as partially completed.  The import code has been added to infer defaults - but it doesn't appear that most vendors provide that.  The meaning of the omit value for the default handling extension metadata property was expanded so that regardless of the database provides as a default Teiid will not attempt to resolve or use it.

For now the workaround is to mark the parameter as nullable as shown in the previous comment.

> Execution of stored procedure with parameters failed on Teiid
> -------------------------------------------------------------
>
>                 Key: TEIID-5180
>                 URL: https://issues.jboss.org/browse/TEIID-5180
>             Project: Teiid
>          Issue Type: Bug
>            Reporter: Aditi Patel
>            Assignee: Steven Hawkins
>             Fix For: 10.1
>
>
> I have imported SAP IQ stored procedure and trying to execute the same.
>  
> Below is the way I have imported the procedures and related views:
>  
> {code:java}
> <model name="SrcModel_5" type="PHYSICAL" visible="true">
>      <property name="importer.importKeys" value="false"/>
>      <property name="importer.useFullSchemaName" value="true"/>
>      <property name="importer.UseQualifiedName" value="true" />
>      <property name="importer.TableTypes" value="VIEW" />
>      <property name="importer.schemapattern" value="%"/>
>      <property name="importer.importProcedures" value="true" />
> <source name="SrcModel_5" translator-name="sybase" connection-jndi-name="java:/dynamicST-DS-6" />
> </model>
> {code}
>  
> *Execution:*
>  
> EXEC SrcModel_5.dwhdb.dbo.sp_iqfile()
>  
> *Error Log:*
>  
> {color:red}13:12:21,669 WARN  [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue11) sQOZ5DwTHpU0 TEIID30020 Processing exception for request sQOZ5DwTHpU0.0 'TEIID30089 Required parameter 'SrcModel_5.dwhdb.dbo.sp_iqfile.dbspaceName' has no value was set or is an invalid parameter.'. Originally QueryResolverException ResolverUtil.java:505. Enable more detailed logging to see the entire stacktrace.{color}



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)