Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5180

Execution of stored procedure with parameters failed on Teiid

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 10.1, 8.12.14.6_4
    • None
    • None
    • None

    Description

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

      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.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            adi22 Aditi Patel (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: