I recently upgraded from SMS 2k3 to SCCM 2k7 and all the installation seem to have worked ok. Logs look clean, workstations are showing ok the only problem I having is that the reports are not showing. I removed the reporting logs then reinstalled it and I keep getting the same http 500 error page. I am using a mix mode configuration, I checked all the permissions in IIS and they all seem to be ok. Any ideas what else I could check?

 Thanks

While this may seem like a long suggested fix, I would uncheck the role of the reporting point and possibly the MP since this is an IIS issue.

uninstall IIS

reboot

delete the c:\inetpub folder

install IIS and all required components

Add back the role(s) you removed.

It's a 20 minute process and at least you would be starting clean.

While installing the Reporting Point Specify the Exact Port and Website Specification for Proper connection with IIS.

This might help you, verify

If you can Post the Reporting Point Logs && even the Log of Reporting Point Install, we may help you further.

Reporting Point install

 -----------------------------------------------------------------------------------------------
Begin Install CMDLINE=/s /m=D:\SMS\bin\i386\rep.val
Value of WWWROOT = c:\inetpub\wwwroot
System tests (IIS, IE, WSH) ok
Checking c:\inetpub\wwwroot\SMSReporting_XXX directory exists
Initialize installation log at c:\inetpub\wwwroot\SMSReporting_XXX
Check disk space.
Reset apptitle and enable uninstall.
Create GraphImages directory.
Register the shared dlls.
Checking if SMSRPHost.exe is installed yet.
SMSRPHost not yet installed, installing.
Starting SMSRPH.exe as a service.
Shared components not installed, installing.
Increasing Rev Count to 1 for XXX
Installing main Reporting Point files.
Checking if US English specific files are needed.
Installing ENGLISH specific files
Checking if GERMAN specific files are needed.
Checking if JAPANESE specific files are needed.
Checking if FRENCH specific files are needed.
Checking if ChineseSimplified specific files are needed.
Installing the image (.gif) files
Editing global.asa for this specific Reporting Point
setting strSiteCode = XXX in global.asa
setting Session("SQLMachine") = SERVERNAME in global.asa
setting Session("SQLDatabase") = SMS_XXX in global.asa
Creating virtual directory using command line: Csript.exe "c:\inetpub\wwwroot\SMSReporting_001\Admin\CVDIR.VBS" "SMSReporting_XXX","c:\inetpub\wwwroot\SMSReporting_XXX"
Grant read permission to the virtual directory: cacls.exe "c:\inetpub\wwwroot\SMSReporting_XXX" /E /G Users:R
Detected Windows version 5.2 or above so attempting to enable ASP
Executing command line : CScript.exe "c:\inetpub\wwwroot\SMSReporting_XXX\Admin\ENBLEASP.VBS"
Start process to restore backed-up Supplemental Reports (if applicable)
Executing:   Cscript.exe c:\inetpub\wwwroot\SMSReporting_XXX\Admin\sizeSuppRpt.VBS
The backup Supplemental Reports directory is empty.
Installation of Reporting Point Complete.

Humm the reporting log stopped on 11/16/2007

 .....

[7996] 11/16/2007 14:05:42 <SMSRecordset: GetFieldName: Using Application Role> webreport_approle
[7996] 11/16/2007 14:05:42 <SMSRecordset: GetFieldName: Return replaced field name> SMS Unique Identifier
[7996] 11/16/2007 14:05:42 <SMSRecordset: SortRecordset Error> Number=9 Description=Subscript out of range Source=SMSComponent
[7996] 11/16/2007 14:05:42 <SMSReport: ExecuteReport> Call RunReport ReportID=73
[7996] 11/16/2007 14:05:42 <SMSRecordset: NextRecordset> No more recordsets

If I run any report from firefox I get ..

Server object error 'ASP 0177 : 800401f3'

Server.CreateObject Failed

/LM/W3svc/1/Root/SMSReporting_001/global.asa, line 372

800401f3

I checked and my smsreporting.log is not getting any information anymore. I checked all the permissions and settings and I am pretty sure I got everything right. I disabled the "Show friendly HTTP error messages" from IE and I get this...

 Server object error 'ASP 0177 : 800401f3'

Server.CreateObject Failed

/LM/W3svc/1/Root/SMSReporting_001/global.asa, line 372

800401f3

Actually if I disable the "Friendly error messages" in IE I get the same error.

I guess line 372 reference the FormatmessageCtl.dll in inetpub\wwwroot\SMSComponenet.

Hi Orcus,

Did you install: http://support.microsoft.com/kb/945898?

When you install a Microsoft System Center Configuration Manager (SCCM) 2007 site server before December 1, 2007, the SCCM site server does not process advertisement status summary data. This data is also known as offer status summary data. In this case, status files (.svf) accumulate in the offersum.box folder that is located in the \Program Files\Microsoft Configuration Manager\inboxes folder on the SCCM site server.

Hope this helps,

Regards,

Kenneth

1.       The task sequence does not run on the protected branch distribution points in System Center Configuration Manager 2007

Consider the following scenario. In Microsoft System Center Configuration Manager 2007, you advertise a task sequence that includes an "install software" step to install two packages. The Make this package available on protected distribution points when requested by clients inside the protected boundaries option is enabled on the packages. Additionally, the Download content locally when needed by running task sequence option is enabled in the advertisement. In this scenario, the task sequence does not run on the protected branch distribution points. Instead, the task sequence runs on the regular distribution points.           ---Hotfix available      ---http://support.microsoft.com/kb/942700/en-us

2.       The WMI service stops responding on a computer that is running the .NET Framework 2.0 and System Center Configuration Manager 2007

The Windows Management Instrumentation (WMI) service stops responding on a computer that is running the Microsoft .NET Framework 2.0 and Microsoft System Center Configuration Manager 2007.      ---Hotfix available   Prerequisites: You must have the .NET Framework 2.0 installed before you apply this hotfix. http://support.microsoft.com/kb/932303/en-us

3.       You cannot move created objects into a folder or out of a folder if the folder was created on a secondary site of System Center Configuration Manager 2007

SYMPTOMS -Consider the following scenario: SYMPTOMS

• You have a primary site and a secondary site for Microsoft System Center Configuration Manager 2007.

• Alphabetically, the site code of the primary site appears before the site code of the secondary site. For example, the site code of the primary site is CEN. Additionally, the site code of the secondary site is CHD.

• You create a folder on the primary site. Then, you create an object in the folder. The folder and the object are replicated to the secondary site.

• On the secondary site, you create a local folder and a local object.

• You try to move the local object into the local folder. Or, you try to move the local object out of the local folder.

---Hotfix available http://support.microsoft.com/kb/942536/en-us

4.       Symptom: You don’t get any status Messages at all.

AND You have already verified that Site Settings->Component Configuration->Status Reporting is turned on, and configured.

Then see the Hot Fix at http://support.microsoft.com/kb/945898

SYMPTOMS

When you install a Microsoft System Center Configuration Manager (SCCM) 2007 site server before December 1, 2007, the SCCM site server does not process advertisement status summary data. This data is also known as offer status summary data. In this case, status files (.svf) accumulate in the offersum.box folder that is located in the \Program Files\Microsoft Configuration Manager\inboxes folder on the SCCM site server.

Note If you upgrade from Microsoft System Management Server (SMS) 2003 to SCCM 2007, the offersum.box folder is located in the \SMS\Inboxes folder.

Additionally, the Offersum.log file contains errors that resemble the following:

Tally 00011280001F2000. New Start Time: 12/01/2007 00:00:00, New Expire Time: 12/08/2007 00:00:00 ---->: An exception was raised: Unspecified error Warn>: Could not initialize the summarizers properties.

These error messages occur every minute in the Offersum.log file.

When you install an SCCM site server after December 1, 2007, the SCCM site server cannot process any status messages. This behavior occurs because the offersum.box folder is not created successfully. This blocks the status message system. Additionally, the Statmgr.log file contains entries that resemble the following:

Waiting for SMS_INBOX_MANAGER to create the "Offer Status Summarizer" inbox for summarizer SMS_OFFER_STATUS_SUMMARIZER.

Note No other site system functions are affected by this problem. Only the offer status summarization component is affected by this problem.

hey there

did you check sms reporting user group has right permissions?

check sms reporting permissions on hard drive

check asp is enabled

check and post iis logs while you try to access the reporting point

re-register this dll>>sms_rwpt.dll

do triple check that all required iis componenets are installed and enabled on your iis.

I end up calling MS and they are great. The problem end up being a dll file that was doing a bad call ... I had installed HP Download manager and for some reason it had pointed the atl.dll file to its own folder (hp folder). The entry in the registry was pointing to that folder instead of system32\atl.dll

Brian, sorry for having so many accounts in the blog

checked database connection open or not.........also ur database open in sms db..........chech it now.....it will open...........or.........open ur site setting...then clicked ur sitesystem....ur instance showing........then clicked.....and ticked reporting services........