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

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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Normal
    • Resolution: Fixed
    • None
    • None
    • sqlserver
    • None
    • Windows
    • Windows 2019-02-20
    • Needs Assessment
    • Major
    • 2 - 5-25% of Customers
    • 3 - Serious
    • 5 - $$$$$$
    • 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.
    • 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

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

              Dates

                Created:
                Updated:
                Resolved:

                Zendesk Support