-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: sqlserver
-
Labels:None
-
Template:
-
Team:Modules
-
Method Found:Customer Feedback
-
QA Risk Assessment:Needs Assessment
Basic Info
MSSQL manifest to create/manage database `MQSQL 2017` using module "puppetlabs/sqlserver - Ver 2.5.0" is not working with `Win Agent node`.
Module Version: 2.5.0.
Puppet Version: PE 2019.1.1
OS Name/Version:
Win Server 2016 ( agent)
RHEL 7.3 ( master)
Describe your issue in as much detail as possible...
Customer is getting an error message when running mssql manifest to create/manage MQSQL 2017 using module "puppetlabs/sqlserver"
```
Could not retrieve catalog from remote server: Error 500 on SERVER: Server Error: Evaluation Error: Error while evaluating a Resource Statement, Evaluation Error: Error while evaluating a Function Call, Failed to parse template sqlserver/create/user/permission.sql.erb:Filepath: org/jruby/RubyString.java
Line: 1829
Detail: can't modify frozen String
(file: /etc/puppetlabs/code/environments/production/modules/sqlserver/manifests/user/permissions.pp, line: 51, column: 19) (file: /etc/puppetlabs/code/environments/production/site/mssql/manifests/init.pp, line: 223)
```
Steps to reproduce:
- Manifest file for Master node:
```
node d9zptv23hgj08r7.delivery.puppetlabs.net
Unknown macro: { sqlserver_instance Unknown macro}
sqlserver::config
Unknown macro: { 'MSSQLSERVER'}
sqlserver::database
Unknown macro: { 'testdb'}
sqlserver::login
Unknown macro: { 'vagrant'}
sqlserver::user
Unknown macro: { 'testdb-vagrant'}
sqlserver::user::permissions
Unknown macro: { 'SELECT-testdb-vagrant'}
}
```Error message:
```
2019-09-15T21:12:15.707-07:00 ERROR [qtp1159967607-83] [puppetserver] Puppet Evaluation Error: Error while evaluating a Resource Statement, Evaluation Error: Error while evaluating a Function Call, Failed to parse template sqlserver/create/user/permission.sql.erb:
Filepath: org/jruby/RubyString.java
Line: 1829
Detail: can't modify frozen String
(file: /etc/puppetlabs/code/environments/production/modules/sqlserver/manifests/user/permissions.pp, line: 51, column: 19) (file: /etc/puppetlabs/code/environments/production/manifests/site.pp, line: 49) on node d9zptv23hgj08r7.delivery.puppetlabs.net
```
- relates to
-
MODULES-9917 SQLServer : Audit Upcasing in Permissions Types
-
- Open
-
- mentioned in
-
Page Loading...