Skip to main content

Posts

Mass Export Service Manager 2012 [SCSM2012] Management Packs

Backup All Unsealed Management Packs In preparation to upgrade our instance from SCSM 2012 R2 to SCSM 2016, I wanted to backup all management packs in the current instance. Here is a PowerShell script to export all of the management packs to a backup directory.  Alter at your pleasure. Import-Module smlets Get-SCManagementPack|where-object {! $_.Sealed}|Export-SCManagementPack -TargetDirectory c:\backup This script requires smlets.  You can get smlets from here:  http://smlets.codeplex.com/ Use at your own risk, I take no responsibility or infer any warranty on this code.
Post a Comment
Read more
Recent posts

PowerShell - Add telnet client to Windows Server 2012 R2

I was trying to check port specific communication on  a server, so I decided to power up good old telnet.  Much to my surprise it was not installed on the Server. PowerShell to fix that issue! Add-WindowsFeature telnet-client  All set.  No Reboot needed. -AJ
1 comment
Read more

CRM 2011 - Workflow Email Error

[Microsoft.Crm.Workflow: Microsoft.Crm.Workflow.Activities.EvaluateExpression] [EvaluateExpression] Workflow Error: Unhandled Exception: Microsoft.Crm.CrmException: Cannot create the given type without the required parameters Found a workaround for an annoying issue i ran across today when overhauling a slew of old email notifications. https://rule30.wordpress.com/2014/04/10/fix-microsoft-crm-crmexception-cannot-create-the-given-type-without-the-required-parameters/ In short, dynamic email addresses can get funky.  Remove the To, CC, and BCC values, save.  Then recreate the dynamic connections.
Post a Comment
Read more

SCSM Data Warehouse Cube / Dimensions do not process - Event 33573 / 35574

Recently I received an alert from our SQL server "OLE DB error: OLE DB or ODBC Error: Operation Cancelled HY008.   Around that same time, I found a few errors in our Operations Manager log on our SCSM 2012 R2 DataWarehouse Management Server.  Specifically Events 33573 and 33574. Event 33573 Warning Message : An Exception was encountered while trying during cube processing.  Message=  Processing warning encountered - Location: , Source: Microsoft SQL Server 2012 Analysis Services Code: 1092550657, Description: Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'WorkItemDim', Column: 'WorkItemDimKey', Value: '18553'. The attribute is 'WorkItemDimKey'..     Well, that appears that a overnight job did not run for our SCSM data warehouse.  However, when I looked at the Data Warehouse Jobs in the SCSM Console, all of the status were either set to Not Started, or success. Going back to the logs on the SCSM
2 comments
Read more

SQl Upgrade Error - Access to the Path C:\Program Files\Microsoft SQL Server\110\License Terms\SQLServer2012_License_SQLBI_1033.rtf is denied

SQL Upgrade Error - Access to License Denied Ahh a wonderful time to experience an error, when you are upgrading SQL, during a limited window for downtime.  Sop much for the weekend plans eh? No worries, this one is easy.  In my case I received the following when downgrading an edition for a reporting Server that houses several instances.  After the first one processed, I received this error: If I browse to that path, we notice the file is set to read only. Easy enough, lets un-check read only and try again.  Success!  I had to do this for each instance install.  So if you have multiple instances be prepared to set the file to read/write each time.
5 comments
Read more

Unable to Load SQL Configuration Manager

While trying to determine and configure some settings in SQL 2012 I ran across this error:   Seems this can occur, from Microsoft:  http://support.microsoft.com/kb/956013 Open a Administrative command prompt, and run this to fix for SQL 2012:  mofcomp "%programfiles(x86)%\Microsoft SQL Server\ 110 \Shared\sqlmgmproviderxpsp2up.mof" Then restart the WMI service.
Post a Comment
Read more