Details
-
Bug
-
Status: Closed
-
Normal
-
Resolution: Fixed
-
None
-
None
-
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.