Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 8.12.13.6_4
    • Fix Version/s: 11.0
    • Component/s: Misc. Connectors
    • Labels:
      None

      Description

      When using automatic procedure import from SQL Server (I used 2016) with a model like this:

      <model name="mymodel">
              <property name="importer.useFullSchemaName" value="false"/>
              <property name="importer.UseQualifiedName" value="false" />
              <property name="importer.procedureNamePattern" value="echo%"/>
              <property name="importer.importProcedures" value="true" />
              <source connection-jndi-name="java:/mssql2016"
                  name="mySource" translator-name="sqlserver" />
          </model>
      

      There is a procedure named echo in SQL server. It is imported into the VDB as "mymodel"."echo;1" (not sure why the ;1). When I afterwards try to execute it using

      EXEC "mymodel"."echo;1"();
      

      , I will get this exception from SQL server which suggests that Teiid mapped the procedure to the wrong name in the source database:

      com.microsoft.sqlserver.jdbc.SQLServerException: Could not find stored procedure 'echo;1'.
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                jmartisk Jan Martiska
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: