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

Execution of stored procedure with parameters failed on Teiid

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Partially Completed
    • Affects Version/s: None
    • Fix Version/s: 10.1, 8.12.14.6_4
    • Component/s: None
    • Labels:
      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.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                adi22 Aditi Patel
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: