Execution of stored procedure failed on Teiid

[adi22]

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:

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

Execution:

EXEC SrcModel_5.dwhdb.dbo.sp_iqcontext()

Error Log:

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.

[shawkins]

> I have imported SAP IQ stored procedure and trying to execute the same.

From what you are showing you are actually executing sq_iqfile.  Teiid expects there to be a dbspaceName parameter.

What is your expectation?  Do you expect that parameter to be optional?

[adi22]

I am importing procedures from SAP IQ and expecting that they should be imported as it is.

Here after importing am not able to run the procedures.

But if I will connect to local server, then I am able to run the procedures.

Please note that the command used to run procedure was same for the virtual db as well as local server.

[shawkins]

> Please note that the command used to run procedure was same for the virtual db as well as local server.

If I understand everything correctly this seems to come down to Teiid expecting the dbspaceName parameter, while Sybase does not.  From what I can see the JDBC import logic currently is only looking at nullability for parameters.  It is not importing the default value - can you log a JIRA issue to add handling for that?

Thanks,

Steve

[adi22]

Can you please share the procedure to log a JIRA issue?

[shawkins]

Under your jboss user account go to - JBoss Issue Tracker and click create.

[adi22]

Thanks Steven

I have raised below:

[TEIID-5180] Execution of stored procedure with parameters failed on Teiid - JBoss Issue Tracker