Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-15911

Add Sequence: "Verify" throws error when using MSSQL-based database sequence

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Fixed
    • Affects Version/s: 6.1.0.1 GA
    • Fix Version/s: 7.1.0 GA
    • Component/s: Database, Step
    • Labels:
    • Story Points:
      0
    • PDI Sub-component:
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Sprint Team:
      Maintenance
    • Steps to Reproduce:
      Hide
      1. MSSQL database with a sequence
      2. Transformation that uses "Add Sequence" step
      3. When executed, the transformation runs successfully
      4. In the "Action" menu, click "Verify"

      Expected Results: No error is shown for the "Add Sequence" step
      Actual Results: An error is displayed due to a datatype mismatch between SQL Server and PDI.

      Show
      MSSQL database with a sequence Transformation that uses "Add Sequence" step When executed, the transformation runs successfully In the "Action" menu, click "Verify" Expected Results: No error is shown for the "Add Sequence" step Actual Results: An error is displayed due to a datatype mismatch between SQL Server and PDI.

      Description

      The Verify process for a transformation shows an error when a transformation uses an "Add Sequence" step which pulls the sequence value from a database object on a Microsoft SQL Server.

      Unable to connect to database to verify sequence because of an error: 
      
      Unexpected error checking whether or not sequence [SEQ_CS_HS_SUPPORT_SCORE] exists
      
      An error occurred executing SQL: 
      SELECT * FROM sys.sequences WHERE name = 'SEQ_CS_HS_SUPPORT_SCORE'
      The "variant" data type is not supported.
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              upihin Uladzimir Pihin (Inactive)
              Reporter:
              mtucker Matt Tucker
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: