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

[Aditi Patel (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-5180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13505346#comment-13505346 ] 

Aditi Patel commented on TEIID-5180:
------------------------------------

Below is the link of the discussion we had on this issue:

[https://developer.jboss.org/thread/276699|http://example.com]

> 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
>
> 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)