Problem getting Reporting to work - HTTP Error 500.0 - Internal Server Error

[redrock]

Hi

I have an issue with getting the reporting to work in SCCM 2007, over one week ago, the PXE Server and the reporting stopped working. Following the threads here I got the PXE working again, but I still have issues with the reporting part.

 

When it opens a webpage it generates the following error (got a different error before, now i get this):

 

HTTP Error 500.0 - Internal Server Error

The page cannot be displayed because an internal server error has occurred.

Detailed Error Information

Module

IsapiModule

Notification

ExecuteRequestHandler

Handler

ASPClassic

Error Code

0x800700aa

Requested URL

http://Serversdress:80/SMSReporting_XXX/Report.asp?ReportId=125

Physical Path

C:\inetpub\wwwroot\SMSReporting_XXX\Report.asp

Logon Method

Anonymous

Logon User

Anonymous

 

This is what I have tride so far.

1. Remove reporting point

2. Remove IIS role

3. Remove Windows Process activation Service (Had issues reinstalling the IIS role)

4. Do a full reinstallation of .net framework 3.5 SP1, 4 Client profile and 4 Extended

5. Add the ISS role (yes ASP is installed on it)

6. Add the reporting point back

 

 

SMSReportingInstall.log says the following:

Begin Install CMDLINE=/s /m=C:\PROGRA~1\MIF083~1\bin\i386\rep.val /deinstall

Error running smswwwroot.vbs script

Begin Install CMDLINE=/s /m=C:\PROGRA~1\MIF083~1\bin\i386\rep.val

Error running smswwwroot.vbs script

 

Rsetup.log says the following:

==========================================

Initialize variables.

Deinstallation beginning

IIS is installed.

Start web services.

Configuring Registry.

Executing: ReportingInstall /s /m=C:\PROGRA~1\MIF083~1\bin\i386\rep.val /deinstall

ReportingInstall.exe returned 0

Cannot remove the Reporting registry key - Still in use.

Finished

==========================================

Initialize variables.

IIS is installed.

Start web services.

Configuring Registry.

Executing: ReportingInstall /s /m=C:\PROGRA~1\MIF083~1\bin\i386\rep.val

ReportingInstall.exe returned 0

Finished

 

 

Im a bit fresh to SCCM (but have some experience) and have been banging my head against the wall now for a week. Any help would be appreciated.

[slater7607]

Does this happen for every report that you are trying to run, or is it only on some that would return a large number of records?

 

We had an issue that was very annoying and not very easy to track down the problem. Try running a report that would only return < 100 or so records and see if it works.

[Acx]

Did you get a resolution for this?

[GarthMJ]

Try re-install the Reporting point.