{"action":"created","issue":{"url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/3528","repository_url":"https://api.github.com/repos/sqlcollaborative/dbatools","labels_url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/3528/labels{/name}","comments_url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/3528/comments","events_url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/3528/events","html_url":"https://github.com/sqlcollaborative/dbatools/issues/3528","id":314114558,"node_id":"MDU6SXNzdWUzMTQxMTQ1NTg=","number":3528,"title":"Missing classifier function management for the Copy-DbaResourceGovernor command","user":{"login":"suxstellino","id":2568107,"node_id":"MDQ6VXNlcjI1NjgxMDc=","avatar_url":"https://avatars1.githubusercontent.com/u/2568107?v=4","gravatar_id":"","url":"https://api.github.com/users/suxstellino","html_url":"https://github.com/suxstellino","followers_url":"https://api.github.com/users/suxstellino/followers","following_url":"https://api.github.com/users/suxstellino/following{/other_user}","gists_url":"https://api.github.com/users/suxstellino/gists{/gist_id}","starred_url":"https://api.github.com/users/suxstellino/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/suxstellino/subscriptions","organizations_url":"https://api.github.com/users/suxstellino/orgs","repos_url":"https://api.github.com/users/suxstellino/repos","events_url":"https://api.github.com/users/suxstellino/events{/privacy}","received_events_url":"https://api.github.com/users/suxstellino/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":10,"created_at":"2018-04-13T13:48:59Z","updated_at":"2018-09-05T07:58:20Z","closed_at":"2018-09-05T07:58:20Z","author_association":"CONTRIBUTOR","body":"## Bug Report\r\nWhen I migrate the resource governor settings the custom classifier function is not migrated too. The custom classifier function exists on the source server.\r\n### General Troubleshooting steps\r\n\r\n### Version Information\r\n - Operating System Windows Server 2012 R2 Standard\r\n - PowerShell Version: 4.0\r\n\r\n| Name | Value |\r\n|:--------|:-------|\r\n| PSVersion | 4.0 |\r\n| WSManStackVersion | 3.0 |\r\n| SerializationVersion | 1.1.0.1 |\r\n| CLRVersion | 4.0.30319.42000 |\r\n| BuildVersion | 6.3.9600.18773 |\r\n| PSCompatibleVersions | {1.0, 2.0, 3.0, 4.0} |\r\n| PSRemotingProtocolVersion | 2.2 |\r\n\r\n - SQL Server\r\n**SOURCE**\r\nMicrosoft SQL Server 2014 (SP2-CU11) (KB4077063) - 12.0.5579.0 (X64) \r\n\tFeb 21 2018 12:19:47 \r\n\tCopyright (c) Microsoft Corporation\r\n\tEnterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: )\r\n**TARGET**\r\nMicrosoft SQL Server 2016 (SP1-GDR) (KB4057118) - 13.0.4210.6 (X64) \r\n\tDec 22 2017 15:00:27 \r\n\tCopyright (c) Microsoft Corporation\r\n\tEnterprise Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: )\r\n\r\n## Steps to Reproduce\r\n- Create a **custom classifier function** into the source server\r\n- Execute the _Copy-DbaResourceGovernor_ command from the destination server with the following syntax:\r\n`Copy-DbaResourceGovernor -Source SOURCESERVER -Destination TARGETSERVER`\r\n- The cmdlet returns an error like this one: _\"Exception calling 'Query' with '1' argument(s): 'Exception calling ExecuteWithResults with '1' argument(s): 'Execute with results failed for Database 'master'\"_\r\n- Printing the `$error[0]` will return the error about the missing classifier function"},"comment":{"url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/comments/418636219","html_url":"https://github.com/sqlcollaborative/dbatools/issues/3528#issuecomment-418636219","issue_url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/3528","id":418636219,"node_id":"MDEyOklzc3VlQ29tbWVudDQxODYzNjIxOQ==","user":{"login":"potatoqualitee","id":8278033,"node_id":"MDQ6VXNlcjgyNzgwMzM=","avatar_url":"https://avatars1.githubusercontent.com/u/8278033?v=4","gravatar_id":"","url":"https://api.github.com/users/potatoqualitee","html_url":"https://github.com/potatoqualitee","followers_url":"https://api.github.com/users/potatoqualitee/followers","following_url":"https://api.github.com/users/potatoqualitee/following{/other_user}","gists_url":"https://api.github.com/users/potatoqualitee/gists{/gist_id}","starred_url":"https://api.github.com/users/potatoqualitee/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/potatoqualitee/subscriptions","organizations_url":"https://api.github.com/users/potatoqualitee/orgs","repos_url":"https://api.github.com/users/potatoqualitee/repos","events_url":"https://api.github.com/users/potatoqualitee/events{/privacy}","received_events_url":"https://api.github.com/users/potatoqualitee/received_events","type":"User","site_admin":false},"created_at":"2018-09-05T07:58:20Z","updated_at":"2018-09-05T07:58:20Z","author_association":"MEMBER","body":"yes indeed thank you, will close now"}}
{"actor":{"display_login":"potatoqualitee"}}