Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsWindows Server 2003Windows 2000Windows NTSmall Business ServerVirtual ServerExchange ServerIISHost Integration ServerISA ServerSMSWSUSMOMWindows Media ServerSecurityCertification
Related Topics
SQL ServerMS WindowsMS OfficePC HardwareMore Topics ...

Windows Server Forum / Systems Management Server / Setup / December 2008

Tip: Looking for answers? Try searching our database.

ConfigMgr 2007 R2 Reporting Services Issues

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Darryl V. - 09 Oct 2008 00:58 GMT
This was also posted in the CfgMgr Setup/Deployment forum.

Hi There,

I've been trying to get R2 SQL Reporting services Point to work and continue
to run into issues that won't allow me to move forward with this.  Errors
are showing up in the component status.

Here is my setup:

Single Site,
SCCM R2 running on Win2k8 x64 Std Ed. (3 different servers to balance roles)
Remote SQL 2005 x64 std Edition server on Win2k8 x64.  Reporting services is
also running on this server and there are 3 instances (My OpsMgr 2007
reports are here as well as sharepoint 2007).
Reporting Services Role is installed on the SQL Server
There is no "Reporting Point" role installed
I have reporting services setup and configured to the best of my knowledge
based on the MS articles for doing so.  I can get to my SMSReports instance
using the browser.

When I go to the ConfigMgr Reporting Services Object and pull up the
properties, I am unable to actually specify any information in any of the
tabs of the dialogue box.  I can't specify datasource, server name, or
anything else.  Its all greyed out and the General Tab simply says
"Unavailable" for all items other then the name of the server hosting the
reporting services point.

Thanks very much for any assistance you can provide.

Cheers,

-Darryl

Here are some logs:

Application Event Log on SQL Server where Reporting Service Point is
installed:

On 10/7/2008 10:51:17 PM, component SMS_SRS_REPORTING_POINT on computer
VM-VICSQL reported: SMS SRS web service is not running on SRS Reporting
point server "VM-VICSQL".

SRSRP.log

SMS_EXECUTIVE started SMS_SRS_REPORTING_POINT as thread ID 3304 (0xCE8).
$$<SMS_SRS_REPORTING_POINT><Tue Oct 07 22:51:05.245 2008 Pacific Daylight
Time><thread=1772 (0x6EC)>
This is a SRS Reporting Point Role as SRSRP registry key exists.~
$$<SMS_SRS_REPORTING_POINT><Tue Oct 07 22:51:05.386 2008 Pacific Daylight
Time><thread=3304 (0xCE8)>
~Waiting for changes for 0 minutes  $$<SMS_SRS_REPORTING_POINT><Tue Oct 07
22:51:05.386 2008 Pacific Daylight Time><thread=3304 (0xCE8)>
Timed Out...~  $$<SMS_SRS_REPORTING_POINT><Tue Oct 07 22:51:05.386 2008
Pacific Daylight Time><thread=3304 (0xCE8)>
STATMSG: ID=7403 SEV=E LEV=M SOURCE="SMS Server"
COMP="SMS_SRS_REPORTING_POINT" SYS=VM-VICSQL SITE=ABE PID=5452 TID=3304
GMTDATE=Wed Oct 08 05:51:17.651 2008 ISTR0="VM-VICSQL" ISTR1="" ISTR2=""
ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0
$$<SMS_SRS_REPORTING_POINT><Tue Oct 07 22:51:17.651 2008 Pacific Daylight
Time><thread=3304 (0xCE8)>
Failures reported during periodic health check by the SRS Server VM-VICSQL.
Will retry check in 57 minutes~  $$<SMS_SRS_REPORTING_POINT><Tue Oct 07
22:51:17.651 2008 Pacific Daylight Time><thread=3304 (0xCE8)>
~Waiting for changes for 57 minutes  $$<SMS_SRS_REPORTING_POINT><Tue Oct 07
22:51:17.667 2008 Pacific Daylight Time><thread=3304 (0xCE8)>

SRSRPSetup.log

<10-07-2008 22:51:01>
====================================================================
<10-07-2008 22:51:01> SMSSRSRP Setup Started....
<10-07-2008 22:51:01> Parameters: \\VM-VICSQL\L$\SMS\bin\i386\ROLESE~1.EXE
/install /siteserver:VM-VICSCM01 SMSSRSRP
<10-07-2008 22:51:01> Installing Pre Reqs for SMSSRSRP
<10-07-2008 22:51:01>         ======== Installing Pre Reqs for Role SMSSRSRP
========
<10-07-2008 22:51:01> Found 0 Pre Reqs for Role SMSSRSRP
<10-07-2008 22:51:01>         ======== Completed Installion of Pre Reqs for
Role SMSSRSRP ========
<10-07-2008 22:51:01> Installing the SMSSRSRP
<10-07-2008 22:51:01> Invoking process
"C:\Windows\Microsoft.NET\Framework\v2.0.50727\RegAsm.exe"
"L:\SMS\bin\i386\SRSSERVER.dll"
<10-07-2008 22:51:02> Registered DLL L:\SMS\bin\i386\SRSSERVER.dll
<10-07-2008 22:51:02> Installation was successful.

SMSAdminUI.log

[4][10/7/2008 4:07:31 PM] ystem.Management.ManagementException\r\nNot found
\r\n   at
System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus
errorCode)
  at System.Management.ManagementObject.Initialize(Boolean getObject)
  at System.Management.ManagementBaseObject.get_wbemObject()
  at System.Management.PropertyData.RefreshPropertyInfo()
  at System.Management.PropertyDataCollection.get_Item(String propertyName)
  at System.Management.ManagementBaseObject.GetPropertyValue(String
propertyName)
  at
Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlConnectionManager.RefreshSiteControlFile(ManagementBaseObject
managementObject)\r\nManagementException details:
instance of __ExtendedStatus
{
Operation = "GetObject";
ParameterInfo =
"SMS_SCI_SysResUse.FileType=2,ItemName=\"[\\\"Display=\\\\\\\\VM-VICSQL\\\\\\\"]MSWNET:[\\\"SMS_SITE=ABE\\\"]\\\\\\\\VM-VICSQL\\\\,SMS
Distribution Point\",ItemType=\"System Resource Usage\",SiteCode=\"ABE\"";
ProviderName = "WinMgmt";
};
\r\n
[4][10/7/2008 4:07:57 PM] ystem.Management.ManagementException\r\nNot found
\r\n   at
System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus
errorCode)
  at System.Management.ManagementObject.Initialize(Boolean getObject)
  at System.Management.ManagementBaseObject.get_wbemObject()
  at System.Management.PropertyData.RefreshPropertyInfo()
  at System.Management.PropertyDataCollection.get_Item(String propertyName)
  at System.Management.ManagementBaseObject.GetPropertyValue(String
propertyName)
  at
Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlConnectionManager.RefreshSiteControlFile(ManagementBaseObject
managementObject)\r\nManagementException details:
instance of __ExtendedStatus
{
Operation = "GetObject";
ParameterInfo =
"SMS_SCI_SysResUse.FileType=2,ItemName=\"[\\\"Display=\\\\\\\\VM-VICSQL\\\\\\\"]MSWNET:[\\\"SMS_SITE=ABE\\\"]\\\\\\\\VM-VICSQL\\\\,SMS
SRS Reporting Point\",ItemType=\"System Resource Usage\",SiteCode=\"ABE\"";
ProviderName = "WinMgmt";
};
\r\n
[4][10/7/2008 4:12:35 PM] :Creating folder name 'ConfigMgr_ABE', path '/'.
[4][10/7/2008 4:13:08 PM] :Client found response content type of 'text/html;
charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
 <title>
  SQL Server Reporting Services
 </title><meta name="Generator" content="Microsoft SQL Server Reporting
Services 9.00.3073.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<style>
  BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt;
COLOR:black}
  H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
  LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt;
DISPLAY:inline}
  .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt;
COLOR:gray}
  A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC;
TEXT-DECORATION:none}
  A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLORFF3300;
TEXT-DECORATION:underline}
  A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC;
TEXT-DECORATION:none}
  A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; colorFF3300;
TEXT-DECORATION:underline}

 </style>
</head><body bgcolor="white">
 <h1>
  Reporting Services Error<hr width="100%" size="1" color="silver" />
 </h1><ul>
  <li>An internal error occurred on the report server. See the error log
for more details. (rsInternalError) <a
href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.
Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=Microsoft%20SQ
L%20Server%20Reporting%20Services&ProdVer=9.00.3073.00
"
target="_blank">Get Online Help</a></li><ul>
   <li>For more information about this error navigate to the report server
on the local server machine, or enable remote errors</li>
  </ul><hr width="100%" size="1" color="silver" /><span
class="ProductInfo">SQL Server Reporting Services</span>
 </ul>
</body>
--.
Eric Zhang[MSFT] - 10 Oct 2008 11:03 GMT
Hello Darryl,

Thank you for your post.
My name is Eric  Zhang, and it is my pleasure to work with you on this
issue!
Please understand that this newsgroup is for SMS related issues.

As you have posted the same thread in our Technet Forum for SCCM, our forum
support engineer will help you to perform the troubleshooting

Thank you for your time and cooperation!

Best regards,

Eric Zhang(MSFT)
Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security

=====================================================
This newsgroup only focuses on MOM technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| From: "Darryl V." <d_vezina@newsgroup.nospam>
| Subject: ConfigMgr 2007 R2 Reporting Services Issues
[quoted text clipped - 12 lines]
| X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18049
| X-MS-CommunityGroup-MessageCategory:
{E4FCE0A9-75B4-4168-BFF9-16C22D8747EC}
| X-MS-CommunityGroup-PostID: {A0F38AA5-5EA3-4CEB-B9FF-C81198C4DF40}
| Newsgroups: microsoft.public.sms.setup
[quoted text clipped - 94 lines]
| [4][10/7/2008 4:07:31 PM] ystem.Management.ManagementException\r\nNot found
| \r\n   at

System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus

| errorCode)
|    at System.Management.ManagementObject.Initialize(Boolean getObject)
[quoted text clipped - 4 lines]
| propertyName)
|    at

Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlConne
ctionManager.RefreshSiteControlFile(ManagementBaseObject
| managementObject)\r\nManagementException details:
| instance of __ExtendedStatus
| {
|  Operation = "GetObject";
|  ParameterInfo =

"SMS_SCI_SysResUse.FileType=2,ItemName=\"[\\\"Display=\\\\\\\\VM-VICSQL\\\\\
\\"]MSWNET:[\\\"SMS_SITE=ABE\\\"]\\\\\\\\VM-VICSQL\\\\,SMS
| Distribution Point\",ItemType=\"System Resource Usage\",SiteCode=\"ABE\"";
|  ProviderName = "WinMgmt";
| };
| \r\n
| [4][10/7/2008 4:07:57 PM] ystem.Management.ManagementException\r\nNot found
| \r\n   at

System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus

| errorCode)
|    at System.Management.ManagementObject.Initialize(Boolean getObject)
[quoted text clipped - 4 lines]
| propertyName)
|    at

Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlConne
ctionManager.RefreshSiteControlFile(ManagementBaseObject
| managementObject)\r\nManagementException details:
| instance of __ExtendedStatus
| {
|  Operation = "GetObject";
|  ParameterInfo =

"SMS_SCI_SysResUse.FileType=2,ItemName=\"[\\\"Display=\\\\\\\\VM-VICSQL\\\\\
\\"]MSWNET:[\\\"SMS_SITE=ABE\\\"]\\\\\\\\VM-VICSQL\\\\,SMS
| SRS Reporting Point\",ItemType=\"System Resource Usage\",SiteCode=\"ABE\"";
|  ProviderName = "WinMgmt";
[quoted text clipped - 38 lines]
|    <li>An internal error occurred on the report server. See the error log
| for more details. (rsInternalError) <a

href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.Reportin
gServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=
Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.3073.00"
| target="_blank">Get Online Help</a></li><ul>
|     <li>For more information about this error navigate to the report server
[quoted text clipped - 4 lines]
|  </body>
| --.
Darryl V. - 10 Oct 2008 18:16 GMT
Hi Eric,

Thanks for your response.

I posted here as there is not currently a newsgroup (other then the technet
forums...) for configMgr 2007 and I wasn't getting any traction in the
forums with my question.  Any idea on when I can expect a response ( I had
assumed 24 hr response given my past experience).

Thanks,

-Darryl

> Hello Darryl,
>
[quoted text clipped - 13 lines]
> Eric Zhang(MSFT)
> Microsoft CSS Online Newsgroup Support
Eric Zhang[MSFT] - 02 Dec 2008 10:16 GMT
Hi,

Here is the link for SCCM technet forum

SCCM TechNet Forums

http://forums.microsoft.com/TechNet/default.aspx?ForumGroupID=488&SiteID=17

Best regards,

Eric Zhang(MSFT)
Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security

=====================================================
This newsgroup only focuses on MOM technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| From: "Darryl V." <d_vezina@newsgroup.nospam>
| References: <A0F38AA5-5EA3-4CEB-B9FF-C81198C4DF40@microsoft.com>
<Kvmtv9rKJHA.1388@TK2MSFTNGHUB02.phx.gbl>
| In-Reply-To: <Kvmtv9rKJHA.1388@TK2MSFTNGHUB02.phx.gbl>
| Subject: Re: ConfigMgr 2007 R2 Reporting Services Issues
[quoted text clipped - 50 lines]
| > Eric Zhang(MSFT)
| > Microsoft CSS Online Newsgroup Support
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.