You are browsing the archive for reporting.

Avatar of alkin

by alkin

SCSM The report server cannot process the report or shared dataset

7:33 am in SytemCenter by alkin

 

I encountered the following issue while trying to run a report from the Service Manager console:

scsm

This was a total new installation (done by the Power Depoloyment Toolkit) and everything was installed fine without any errors so I doubled check my SQL, my datawarehouse server, my SQL reporting Service and by digging deeper and deeper into the reports themself on the SQL report I discovered the following error:

 

image

So that was the culprit!  To solve this issue, open the configuration of each report, go to data sources and select the DWDataMart Data source:

image

 

click OK and now you will be able to run reports again!

 

Thanks,

Alexandre Verkinderen

Avatar of alkin

by alkin

How to change SCOM reporting to use Kerberos instead of NTLM

12:06 pm in Uncategorized by alkin

One of the Domain admins at one of my customers was complaining about all the NTLM request generated by the scom server to the reporting server. One of the issues with NTLM is that you need to re-authenticate every time, with Kerberos you receive a ticket that is valid for a longer period of time (by default 10hours). You can find more info about NTLM VS Kerberos here: http://blogs.technet.com/b/authentication/archive/2006/04/07/ntlm-s-time-has-passed.aspx 

 

All the SQL servers at this customer are configured to use Kerberos but apparently when the SCOM reporting is being installed and modifying the RSReportServer config file it will change the authentication method as well back to NTLM!! Although Microsoft is recommending Kerberos over NTLM for almost 10 years now, new products like SCOM 2012 are still using NTLM!!

 

To change the report server authentication settings, edit the XML elements and values in the RSReportServer.config file.

You can find the file in the following location: C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer

 

clip_image002

Change the setting from RSWindowsNTLM to RSWindowsNegotiate

clip_image004

 

Important note Important

Using RSWindowsNegotiate will result in a Kerberos authentication error if you configured the Report Server service to run under a domain user account and you did not register a Service Principal Name (SPN) for the account. Make sure to create the SPN for the SQL reporting service as described here: http://blogs.technet.com/b/stefan_stranger/archive/2012/07/31/opsmgr-2012-what-should-the-spn-s-look-like-visual-representation.aspx

 

Thanks,

Alex


Avatar of alkin

by alkin

Unique Opsmgr 2007 training event (Belgium) : Management Pack Development Course

5:23 pm in Uncategorized by alkin

Hi all,

I am very proud to be able to announce that we will be able to host a Unique Opsmgr 2007 training event in Belgium.

Is the average training not meeting the depth of technical content you need? Would you like the receive your training from someone that received the prestigious MVP Award? Wished you could receive training from someone that co-authored a book on the topic he is teaching? Are you looking for real 400 level training? Want training from a consultant with plenty of real-life experience? Ever wished you could receive training from the folks that gave those sessions at Teched (Us or Europe)? Here is your chance!

What is being delivered?

The  Management pack development course organized by Infront Consulting & RealDolmen

Description

This class is designed to provide attendees with the knowledge they require to create a custom Management Pack. The hands-on labs in this class will walk the attendees through the process of creating a custom Management Pack from the design and planning stages through to the creation of reports. This class will use a ‘popular’ application and step through the MP development process as an exercise that results in a production quality MP that can be used in a production environment. This class will use the Exchange Server 2007 MP developed by Microsoft as an example.

http://infrontconsulting.com/docs/SCOM2007-OpsMgr2007MPDevelopment.pdf

Who is delivering this?

Delivered by a very senior level MVP specializing in the System Center Suite of Products, experience gained with working with large enterprise customers giving them the ability to bring their real-life know-how to their training deliveries.

When will this take place?

This unique 4day training event will take place from Thuesday the 17th of November till Friday the 20th of November 2009 included.

Class will be from 9 AM till 5 PM, with a break before and after noon and a lunch at 12:00 AM.

Where Does it take place?

This event will take place at the training facilities of the “RealDolmen” http://www.realdolmen.com

RealDolmen
Industriezone Zenneveld
A. Vaucampslaan 42
1654 Huizingen

tel: +32 2 362 56 17
e-mail: education@realdolmen.com

What is it going to cost?

The course will cost 2150 € (Excl tva.) for the 4 day training including a lunch.

Where do I Sign up?

More info about the event, and details on how to signup for this event can be found here:

http://www.realdolmen.com/Commercial/Default.aspx?id=1776

Please be advised that seats are limited and that there are currently no plans for repeating this event!

Avatar of alkin

by alkin

Export SQL reports in PDF landscape

12:53 pm in Uncategorized by alkin

I had to create some reports for a customer this week and the layout of the report didn’t satisfied my client. The reports are exported in portrait format and not in landscape format.

 

First part of the report

image

and on the second page I got the rest of my report.

image

 

Very ugly……….

 

How to export a scom report in pdf landscape format?

 Only solution here is to render the pdf in landscape format, so I start googling and found this blog http://www.bictt.com/blogs/bictt.php/2009/03/17/sql-reporting-services-render-pdf-in-a4-1  and also some information msdn http://msdn.microsoft.com/en-us/library/ms156281.aspx 

 

So to resolve our problem we have to add some code in the Rsreportserver.config file that you can find under “Program Files\Microsoft SQL Server\MSSQL.5\Reporting Services\ReportServer\”

 

You can specify rendering extension parameters in the RSReportServer configuration file to override default report rendering behavior for reports that run on a Reporting Services report server. You can modify rendering extension parameters to achieve the following objectives:

  • Change how the rendering extension name appears in the Export list of the report toolbar (for example, to change “Web archive” to “MHTML”), or localize the name to a different language.
  • Create multiple instances of the same rendering extension to support different report presentation options (for example, a portrait and landscape mode version of the Image rendering extension).
  • Change the default rendering extension parameters to use different values (for example, the Image rendering extension uses TIFF as the default output format; you can modify the extension parameters to use EMF instead).

 

Locate the render section in the rsreportserver.config file

 Capture

 

We are going to add two extra entries to the export list.

Below the pdf entry paste the following code:

<Extension Name="PDF (A4 Landscape)" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering">

        <OverrideNames>

            <Name Language="en-US">PDF in A4 Landscape</Name>

        </OverrideNames>

        <Configuration>

            <DeviceInfo>

                <OutputFormat>PDF</OutputFormat>

                <PageHeight>8.27in</PageHeight>

                <PageWidth>11.69in</PageWidth>

            </DeviceInfo>

        </Configuration>

</Extension>

<Extension Name="PDF (A4 Portrait)" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering">

        <OverrideNames>

            <Name Language="en-US">PDF in A4 Portrait</Name>

        </OverrideNames>

        <Configuration>

            <DeviceInfo>

                <OutputFormat>PDF</OutputFormat>

                <PageHeight>11.69in</PageHeight>

                <PageWidth>8.27in</PageWidth>

            </DeviceInfo>

        </Configuration>

</Extension>

Save the file and close it. I also did a IIsreset and a restart of my sql reporting services just to be sure.

When I want to export a report I have two extra entries:

image

 

Now when I want to export a report in landscape format I just choose to export in pdf in A4 landscape format and this is the result:

image

 

Everything perfectly fits on one page and I have a happy client now :-) !!  Thanks to Bob Cornelissen for his blog.

 

Hope this helps,

Alexandre Verkinderen

Avatar of alkin

by alkin

Opsmgr on Social Forum!

5:40 pm in Uncategorized by alkin

We just moved from the old news servers to the new social forum platform!

 

So start asking your questions, issues, share your knowledge etc on the new platform and make it as good as the old NNTP groups!

 

http://social.technet.microsoft.com/Forums/en-US/category/systemcenteroperationsmanager

 

grtz,

ALexandre Verkinderen

http://scug.be

 

Avatar of alkin

by alkin

Opsmgr Data Warehouse failed to enumerate database components to be deployed

9:04 am in Uncategorized by alkin

Today I ran into this issue:

image

 

Data Warehouse failed to enumerate database components to be deployed. Failed to enumerate Data Warehouse components for deployment. The operation will be retried. Exception ‘SqlException': Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. One or more workflows were affected by this. Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Component Instance name: scom.be Instance ID: {AC6FACD9-

 

Issue:This error appears immediately after a management pack is imported. The installaion of the reports in the MP is failing.

Resolution:Run exec sp_updatestats on the OperationsManagerDW db (the data warehouse).

 

When running the exec sp_updatestats doesn’t help follow these steps:

 

Download and extract the following hotfix:

 

http://support.microsoft.com/?kbid=954643

image

 

Run the SQL query Managementpackinstall.sp.sql

image

 

And directly after running the query I got the following event:

image

 

Everything is fine now and I have green management server:

 

image

 

Hope this help,

Alexandre Verkinderen

http://scug.be

Avatar of alkin

by alkin

Third Edition of Microsoft Community Day !!

7:21 am in Uncategorized by alkin

Community Day is back again, are you ready for our Third Edition of Microsoft Community Day?

Eleven Microsoft User Groups combine their efforts to organize this unique networking and knowledge sharing
event. A unique opportunity to learn about Microsoft’s latest developments and technologies like Exchange
2010, Silverlight 3, Visual Studio 2010, SQL Server 2008, Windows 2008R2, Powershell V2, Forefront
Identity Manager 2010, XNA 3.1. and OCS R2.
 
Microsoft Community Day will take place on Thursday 25th June 2009 in Utopolis, Mechelen, where we will
bring together 300 IT Pro’s and developers.
 
The Microsoft Community Day 2009 is supported by BESUG, BIWUG, IT-Talks, MVUG, Pro-Exchange, SCUG, SQLUG, VBIB, Visug, WinSec, XNA-BUG“
 
Register now for free for this all day event!

http://www.communityday.be/CD/

 

The System Center User Belgium will have two slots! We will speak about “Setting up & Configuring SQL Server to support your SCCM & SCOM environment” and “Thin, thick or hybrid imaging in sccm – Notes from the field”.

Hope to see you there!

Grtz,

Alexandre Verkinderen

Avatar of alkin

by alkin

Reporting Deployment and Usage Troubleshooting

6:52 pm in Uncategorized by alkin

Finally!!

 

One guide with the most common reporting issues! Thank you Microsoft!

 

“There are several common configuration and usage issues that can cause Operations Manager Reporting errors.  This document addresses the most common issues you are likely to encounter, solutions to those issues, and tools that you can use to resolve these problems.”

[View:/cfs-file.ashx/__key/CommunityServer.Components.PostAttachments/00.00.00.09.78/OM2007_ReportTrouble.docx]

Have fun,

Alexandre Verkinderen

Avatar of alkin

by alkin

Operations Manager/SSAS and PerformancePoint Scorecards

4:03 pm in Uncategorized by alkin

Daniel Savage posted on the team blog that the performancePoint team released  a sample solution that shows how to build cubes from the Operations Manager DW and then build balanced IT scorecards using Office PerformancePoint server from these cubes.

 

I had to look for 30 minutes on the net before I finally found what I needed!  Because I know you’re all lazy people I just put the links below. :-)

 

Scorecards and Dashboards for your IT Department A solution accelerator to help you create a complete performance management solution for monitoring the health of your IT infrastructure. Go beyond canned operational reports with interactive performance dashboards, comprehensive scorecards, and powerful analytics all built on Microsoft platform components including Microsoft® SQL Server®, Systems Center, Microsoft Office SharePoint® Server 2007, and Microsoft Office PerformancePoint® Server 2007.

 

The following diagram illustrates the major components of the framework, and the flow of data from source data to the finished dashboards. Data processes are numbered one through six in the diagram, with detailed descriptions to follow.

 

 Untitled

 

Greetz,

Alexandre Verkinderen

http://scug.be/blogs/scom

Visit Us On TwitterVisit Us On Linkedin