Uploaded image for project: 'Modules'
  1. Modules
  2. MODULES-6281

puppetlabs/sqlserver : No error message thrown when TSQL query executed

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: sqlserver
    • Labels:
      None
    • Template:
      MODULES Bug Template
    • Epic Link:
    • Team:
      Windows
    • Sprint:
      Windows 2019-02-20
    • Method Found:
      Needs Assessment
    • CS Priority:
      Major
    • CS Frequency:
      2 - 5-25% of Customers
    • CS Severity:
      3 - Serious
    • CS Business Value:
      5 - $$$$$$
    • CS Impact:
      Supporting Windows well is important to us, and the SQLServer module is one of the most demanded Windows modules. Not getting back errors from TSQL statements run using this module makes it very difficult to troubleshoot.
    • QA Risk Assessment:
      Needs Assessment

      Description

      Basic Info
      Module Version: 2.0.1
      Puppet Version: PE 2017.2.2
      OS Name/Version: Ubuntu 14.04

      Describe your issue in as much detail as possible...

      Desired Behavior: When a TSQL Query is executed and an error message should be raised, this error message needs to be returned to the user in the Puppet run output.

      Actual Behavior:

      It is thought that since the change to using SQLNCLI11 as a connector instead of SQLOLEDB there may not be the same level of output returned, so there may not be anything for the code at https://github.com/puppetlabs/puppetlabs-sqlserver/blob/master/lib/puppet/type/sqlserver_tsql.rb#L111-L114 to return.
      The desired behaviour is for any error messages to be returned to the user.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              william.hurt William Hurt
              Reporter:
              stefan.pijnappels Stefan Pijnappels
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Zendesk Support