[
https://issues.jboss.org/browse/TEIID-5180?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-5180:
---------------------------------------
Unfortunately there isn't a simple alter statement that can do
that
The closest would be to alter the parameter to be nullable.
{code}
<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" />
<metadata type="NATIVE">
<metadata type="DDL">alter procedure SrcModel_5.dwhdb.dbo.sp_iqfile
alter parameter dbspaceName type string;</metadata>
</model>
{code}
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)