{"action":"created","issue":{"url":"https://api.github.com/repos/PowerShell/xSQLServer/issues/252","repository_url":"https://api.github.com/repos/PowerShell/xSQLServer","labels_url":"https://api.github.com/repos/PowerShell/xSQLServer/issues/252/labels{/name}","comments_url":"https://api.github.com/repos/PowerShell/xSQLServer/issues/252/comments","events_url":"https://api.github.com/repos/PowerShell/xSQLServer/issues/252/events","html_url":"https://github.com/PowerShell/xSQLServer/issues/252","id":197008013,"number":252,"title":"DSC PowerShell MSFT_xSQLServerScript error on Test-TargetResource","user":{"login":"emitodiaz","id":10839567,"avatar_url":"https://avatars.githubusercontent.com/u/10839567?v=3","gravatar_id":"","url":"https://api.github.com/users/emitodiaz","html_url":"https://github.com/emitodiaz","followers_url":"https://api.github.com/users/emitodiaz/followers","following_url":"https://api.github.com/users/emitodiaz/following{/other_user}","gists_url":"https://api.github.com/users/emitodiaz/gists{/gist_id}","starred_url":"https://api.github.com/users/emitodiaz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/emitodiaz/subscriptions","organizations_url":"https://api.github.com/users/emitodiaz/orgs","repos_url":"https://api.github.com/users/emitodiaz/repos","events_url":"https://api.github.com/users/emitodiaz/events{/privacy}","received_events_url":"https://api.github.com/users/emitodiaz/received_events","type":"User","site_admin":false},"labels":[{"id":200152074,"url":"https://api.github.com/repos/PowerShell/xSQLServer/labels/question","name":"question","color":"cc317c","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":16,"created_at":"2016-12-21T19:00:13Z","updated_at":"2017-01-03T11:48:31Z","closed_at":null,"body":"\r\nHi, I'm trying the xSQLServerScript and I don't know if it's an error or I'm making a mistake calling the  resource. \r\nThanks in advance, Emiliano.\r\n\r\n**Error**:\r\n\r\n`DEPURACIÓN: [SERVER26]:                            [[xSQLServerScript]SqlSettings] SQLPS module imported.\r\nDEPURACIÓN: [SERVER26]:                            [[xSQLServerScript]SqlSettings] Popping location back to what it was before importing SQLPS module.\r\nDETALLADO: [SERVER26]: LCM:  [ FinalizarProbar   ]  [[xSQLServerScript]SqlSettings]  en 0.5780 segundos.\r\nEl recurso de DSC de PowerShell MSFT_xSQLServerScript generó uno o más errores de no terminación al ejecutar la funcionalidad de Test-TargetResource. Estos errores se registran en el canal \r\nETW llamado Microsoft-Windows-DSC/operativo. Consulte este canal para obtener más detalles.\r\n    + CategoryInfo          : InvalidOperation: (:) [], CimException\r\n    + FullyQualifiedErrorId : NonTerminatingErrorFromProvider`\r\n\r\n\r\n**Details**\r\n`Powershell version on Windows 2012 R2, 64 BITS, Spanish.\r\nPSVersion                      4.0                                                                                                                                                                                                                               \r\nWSManStackVersion              3.0                                                                                                                                                                                                                               \r\nSerializationVersion           1.1.0.1                                                                                                                                                                                                                           \r\nCLRVersion                     4.0.30319.36366                                                                                                                                                                                                                   \r\nBuildVersion                   6.3.9600.17400                                                                                                                                                                                                                    \r\nPSCompatibleVersions           {1.0, 2.0, 3.0, 4.0}                                                                                                                                                                                                              \r\nPSRemotingProtocolVersion      2.2                                                                                                                                                                                                                               \r\n\r\n**Module:** xSQLServer versión: 4.0.0.0    \r\n`\r\n\r\n\r\n\r\nPS C:\\Windows\\system32> Start-DscConfiguration -Path \"E:\\DSC Resources\" -Wait -Verbose -Force -Debug\r\nDETALLADO: Realice la operación 'Invocar método de CIM' con los parámetros siguientes, ''methodName' = SendConfigurationApply,'className' = MSFT_DSCLocalConfigurationManager,'namespaceName' = \r\nroot/Microsoft/Windows/DesiredStateConfiguration'.\r\nDETALLADO: Se recibió una llamada de método de LCM desde el equipo DES001 con el SID de usuario S-1-5-21-3370056077-3368664693-1737765451-1238.\r\nDETALLADO: [SERVER26]: LCM:  [ IniciarEstablecer]\r\nDETALLADO: [SERVER26]: LCM:  [ IniciarRecurso  ]  [[xSQLServerScript]SqlSettings]\r\nDETALLADO: [SERVER26]: LCM:  [ IniciarProbar   ]  [[xSQLServerScript]SqlSettings]\r\nDEPURACIÓN: [SERVER26]:                            [[xSQLServerScript]SqlSettings] Unloading SQLPS module.\r\nDEPURACIÓN: [SERVER26]:                            [[xSQLServerScript]SqlSettings] SQLPS module changes CWD to SQLSERVER:\\ when loading, pushing location to pop it when module is loaded.\r\nDETALLADO: [SERVER26]:                            [[xSQLServerScript]SqlSettings] 2016-12-21_13-12-54: Importing SQLPS module.\r\nDEPURACIÓN: [SERVER26]:                            [[xSQLServerScript]SqlSettings] Called Initialization method\r\nDEPURACIÓN: [SERVER26]:                            [[xSQLServerScript]SqlSettings] Starting extension DAC\r\nDEPURACIÓN: [SERVER26]:                            [[xSQLServerScript]SqlSettings] Starting extension DataCollection\r\nDEPURACIÓN: [SERVER26]:                            [[xSQLServerScript]SqlSettings] Starting extension SQLPolicy\r\nDEPURACIÓN: [SERVER26]:                            [[xSQLServerScript]SqlSettings] Starting extension Utility\r\nDEPURACIÓN: [SERVER26]:                            [[xSQLServerScript]SqlSettings] Starting extension SQLRegistration\r\nDEPURACIÓN: [SERVER26]:                            [[xSQLServerScript]SqlSettings] Starting extension SQLSERVER\r\nDEPURACIÓN: [SERVER26]:                            [[xSQLServerScript]SqlSettings] Starting extension SQL\r\nDEPURACIÓN: [SERVER26]:                            [[xSQLServerScript]SqlSettings] Starting extension SSIS\r\nDEPURACIÓN: [SERVER26]:                            [[xSQLServerScript]SqlSettings] Starting extension XEvent\r\nDEPURACIÓN: [SERVER26]:                            [[xSQLServerScript]SqlSettings] Starting extension DatabaseXEvent\r\nDEPURACIÓN: [SERVER26]:                            [[xSQLServerScript]SqlSettings] Starting extension SQLAS\r\nDEPURACIÓN: [SERVER26]:                            [[xSQLServerScript]SqlSettings] ItemExists: SQLSERVER:\\\r\nDEPURACIÓN: [SERVER26]:                            [[xSQLServerScript]SqlSettings] ItemExists: SQLSERVER:\\\r\nDEPURACIÓN: [SERVER26]:                            [[xSQLServerScript]SqlSettings] SQLPS module imported.\r\nDEPURACIÓN: [SERVER26]:                            [[xSQLServerScript]SqlSettings] Popping location back to what it was before importing SQLPS module.\r\nDETALLADO: [SERVER26]: LCM:  [ FinalizarProbar   ]  [[xSQLServerScript]SqlSettings]  en 0.5780 segundos.\r\nEl recurso de DSC de PowerShell MSFT_xSQLServerScript generó uno o más errores de no terminación al ejecutar la funcionalidad de Test-TargetResource. Estos errores se registran en el canal \r\nETW llamado Microsoft-Windows-DSC/operativo. Consulte este canal para obtener más detalles.\r\n    + CategoryInfo          : InvalidOperation: (:) [], CimException\r\n    + FullyQualifiedErrorId : NonTerminatingErrorFromProvider\r\n    + PSComputerName        : SERVER26\r\n \r\nLa función SendConfigurationApply no se completó correctamente.\r\n    + CategoryInfo          : NotSpecified: (root/Microsoft/...gurationManager:String) [], CimException\r\n    + FullyQualifiedErrorId : MI RESULT 1\r\n    + PSComputerName        : SERVER26\r\n \r\nDETALLADO: La operación 'Invocar método de CIM' se completó.\r\nDETALLADO: El tiempo que tarda el trabajo de configuración en completarse es de 0.688 segundos\r\n\r\n\r\n\r\n**_On the EventViewer I see the next two errors:_**\r\n`Trabajo {43D6E94B-C7AB-11E6-80D1-00155D03053C}: \r\nEste evento indica que se generó un error de no terminación cuando DSCEngine ejecutaba Test-TargetResource en el recurso de DSC MSFT_xSQLServerScript. FullyQualifiedErrorId: System.IO.FileLoadException,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand. ErrorMessage: El ensamblado de modo mixto se ha compilado con la versión 'v2.0.50727' del runtime y no se puede cargar en el runtime 4.0 sin información de configuración adicional..\r\n\r\n\r\nTrabajo {43D6E94B-C7AB-11E6-80D1-00155D03053C}: \r\nEste evento indica un error cuando LCM procesa la configuración. ErrorId: 0x1. ErrorDetail: La función SendConfigurationApply no se completó correctamente.. ResourceId: [xSQLServerScript]SqlSettings. SourceInfo: ::14::9::xSQLServerScript. ErrorMessage: El recurso de DSC de PowerShell MSFT_xSQLServerScript generó uno o más errores de no terminación al ejecutar la funcionalidad de Test-TargetResource. Estos errores se registran en el canal ETW llamado Microsoft-Windows-DSC/operativo. Consulte este canal para obtener más detalles..\r\n`\r\n\r\n\r\n**My testing script:**\r\n`configuration SQLSettings\r\n{   \r\nparam \r\n\t(\r\n\t\t[Parameter(Mandatory=$false)] \r\n        [ValidateNotNullorEmpty()] \r\n        [PsCredential] $CredencialUSR\r\n\t)\r\n\t\r\n    Import-DscResource -ModuleName 'xSQLServer'\r\n\r\n    Node $AllNodes.NodeName\r\n    { \r\n         xSQLServerScript SqlSettings\r\n        {\r\n            ServerInstance = $Node.InstanceName\r\n            SetFilePath = \"C:\\temp\\Set-SQlsettings.sql\"\r\n            TestFilePath = \"C:\\temp\\Test-SQlsettings.sql\"\r\n            GetFilePath = \"C:\\temp\\Get-SQlsettings.sql\"\r\n            Credential = $CredencialUSR\r\n            Variable = @(\"FilePath=C:\\temp\\\")\r\n        } \r\n    } \r\n}\r\n\r\n$configData = @{ \r\n    AllNodes = @(  \r\n        @{ \r\n            NodeName = 'SERVER26'\r\n            InstanceName = 'SERVER26\\SQL2014SE'\r\n            PsDscAllowPlainTextPassword= $true\r\n            PSDscAllowDomainUser = $true\r\n        }\r\n    ) \r\n}\r\n\r\nSQLSettings -ConfigurationData $configData -OutputPath \"E:\\DSC Resources\\\" -CredencialUSR $cred`"},"comment":{"url":"https://api.github.com/repos/PowerShell/xSQLServer/issues/comments/270098428","html_url":"https://github.com/PowerShell/xSQLServer/issues/252#issuecomment-270098428","issue_url":"https://api.github.com/repos/PowerShell/xSQLServer/issues/252","id":270098428,"user":{"login":"emitodiaz","id":10839567,"avatar_url":"https://avatars.githubusercontent.com/u/10839567?v=3","gravatar_id":"","url":"https://api.github.com/users/emitodiaz","html_url":"https://github.com/emitodiaz","followers_url":"https://api.github.com/users/emitodiaz/followers","following_url":"https://api.github.com/users/emitodiaz/following{/other_user}","gists_url":"https://api.github.com/users/emitodiaz/gists{/gist_id}","starred_url":"https://api.github.com/users/emitodiaz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/emitodiaz/subscriptions","organizations_url":"https://api.github.com/users/emitodiaz/orgs","repos_url":"https://api.github.com/users/emitodiaz/repos","events_url":"https://api.github.com/users/emitodiaz/events{/privacy}","received_events_url":"https://api.github.com/users/emitodiaz/received_events","type":"User","site_admin":false},"created_at":"2017-01-03T11:48:31Z","updated_at":"2017-01-03T11:48:31Z","body":"Thanks You @johlju and @PlagueHO for your time!!!.\r\nI'll try with WMF 5 and verify if it's work.\r\nThanks again, good year!\r\n"}}
{"actor":{"display_login":"emitodiaz"}}