Some SCCM reports timeout after 5 min
- When I run some reports they timeout after 5 min.
SCCM Server is Windows 2008
DB server is Windows 2003 w/ SQL 2005
The link below was someone that had the same issue but this didn't work in my case.
http://systemcentertools.blogspot.com/2009/03/sccm-reporting-timeout-under-windows.html
This is how I configured WEBDAV IIS and BITS complements to myitforum for it
- In Server Manager, on the Features node, start the Add Features Wizard.
- On the Select Features page, select BITS Server Extensions.
- When prompted, click Add Required Role Services to add the dependent components, including the Web Server (IIS) role.
- On the Select Features page, select Remote Differential Compression, and then click Next.
- On the Web Server (IIS) page, click Next.
- On the Select Role Services page, under IIS 6 Management Compatibility, select IIS 6 WMI Compatibility.
- Under Application Development, select ASP.NET and, when prompted, click Add Required Role Services to add the dependent components.
- Update: Add ASP (required for ConfigMgr Reporting Point to function - thanks to Jens Ole Kragh for pointing this out)
- Under Security, select Windows Authentication, and then click Next.
- On the Confirmation page, click Install, and then complete the rest of the wizard.
- Download the x86 or x64 version of WebDAV at http://go.microsoft.com/fwlink/?LinkId=108052.
- Run either webdav_x86_golive.msi or webdav_x64_golive.msi, depending on your processor.
- Enable WebDAV and create an Authoring Rule, as follows:
- Open Internet Information Services (IIS) Manager.
- In the Connections pane, expand the Sites node in the tree, and then click SMSWEB if you are using a custom Web site or click Default Web Site if you are using the default Web site for the site system.
- In the Features View, double-click WebDAV Authoring Rules.
- When the WebDAV Authoring Rules page is displayed, in the Actions pane, click Enable WebDAV.
- After WebDAV has been enabled, in the Actions pane, click Add Authoring Rule.
- In the Add Authoring Rule dialog box, under Allow access to, click All content.
- Under Allow access to this content to, click All users.
- Under Permissions, click Read, and then click OK.
- Change the property behavior as follows:
- In the WebDAV Authoring Rules page, in the Actions pane, click WebDAV Settings.
- In the WebDAV Settings page, under Property Behavior, set Allow anonymous property queries to True.
- Set Allow Custom Properties to False.
- Set Allow property queries with infinite depth to True.
- If this is a BITS-enabled distribution point, under WebDAV Behavior, set Allow access to hidden files to True.
- In the Action pane, click Apply.
- Close Internet Information Services (IIS) Manager.
- In Server Manager, on the Features node, start the Add Features Wizard.
All Replies
Try these, particularly the last two.
http://technet.microsoft.com/en-ca/library/bb680896.aspx
http://www.enhansoft.com/- 5 minutes? What report are you running?????
John Marcum | http://www.TrueSec.com/en/Training.htm | http://myitforum.com/cs2/blogs/jmarcum - Hi,
To configure the ASP script timeout setting in IIS 7.0
-
On the reporting point computer, open Internet Information Services (IIS) Manager.
-
Navigate to < server name > \ Sites \ Default Web Site .
-
Click SMSReporting_< site name > , and then double-click ASP in Features View .
-
Expand Limits Properties , configure the Script Time-out setting, press Enter , and then click Apply in the Actions pane.
How to Configure the ASP Script Timeout Setting
http://technet.microsoft.com/en-ca/library/bb632464.aspx- Marked As Answer byEric Zhang - MSFTMSFT, ModeratorThursday, October 29, 2009 10:26 AM
- Unmarked As Answer bym1721c Monday, November 02, 2009 10:05 PM
-
I am running the can software report. Software 02D. Computers with a specific software product. I choose all windows workstations collection and I choose the software I’m interested in getting info on. The browser looks like its loading and it timeout after 5 mins.
doesn't work that is what the link has me do at the top of my post
You changed both the ASP AND connection times out? The connection time is not listed within Steve’s Blog post but is listed within the docs that I pointed you to.
http://www.enhansoft.com/- Yes I changed both. Report still times out
- What if you run the same report directly in SQL? How many computers do you have? That report shouldn't be taking 5 minutes.
John Marcum | http://www.TrueSec.com/en/Training.htm | http://myitforum.com/cs2/blogs/jmarcum Can you please run the report and check the IIS logs ? if the issue is with the ASP buffer limit then error "Response_Buffer_Limit_Exceeded "should be appear in the IIS logs.
If same error is appearing then please run that report directly in SQL and see how many rows it returned.
and then apply the workaround given in the link http://technet.microsoft.com/en-us/library/cc875797.aspx (Please see question "There seems to be a limitation on the Web Reporting tool of 10,000 records. Is there any way to increase that?" and "When my web reports contain a column that has more than 5000 records I get an IIS error 500 on my IIS 6.0 reporting point. How do I fix this?")
For IIS 7 please refer this video....
http://learn.iis.net/page.aspx/373/editing-configuration-files/
Abhishek Joshi http://blogcastrepository.com/blogs/abi/default.aspx http://blogcastrepository.com/members/Abhishek.aspx- Unmarked As Answer bym1721c Monday, November 02, 2009 10:05 PM
- Marked As Answer byEric Zhang - MSFTMSFT, ModeratorThursday, October 29, 2009 10:26 AM
- As this thread has been quiet for a while, we assume that the issue has been resolved. At this time, we will mark it as ‘Answered’ as the previous steps should be helpful for many similar scenarios.
If the issue still persists and you want to return to this question, please reply this post directly so we will be notified to follow it up. You can also choose to unmark the answer as you wish.
In addition, we’d love to hear your feedback about the solution. By sharing your experience you can help other community members facing similar problems.
Thanks! Still getting errors, I can run the report directly from SQL and I have no problems. I didn't see any errors in the IIS logs. We are using server 2008 so, IIS 7
Copy || Export || Print || Add to Favorites || E-mail
Report Name:
Software 02D - Computers with a specific software product
Category:
Asset Intelligence
Comment:
This is extended from the previous report. This report shows all the computers that have a specific software product
Parameters:
Collection
SMS00004
Software ID
6CC89E78-84AB-404C-8F10-2C1A68103ABE
Software Properties Hash (Optional):
Top of Form
An error occurred when the report was run. The details are as follows:
Timeout expired
Error Number:
-2147217871
Source:
Microsoft OLE DB Provider for SQL Server
Native Error:
0
Bottom of Form
I've got a similar issue. For exemple Report 364 returns the following error
<SMSRecordset: RunReport Error (ReportID=364 SecurityKey=SIT00364 ConnectionString=Provider=SQLOLEDB;Initial Catalog=DBNAME;Data Source=DBSERVER\MDB00P;Trusted_Connection=Yes;Application Name=SMS Reporting;Use Procedure for Prepare=0;Auto Translate=FALSE DllFolderPath=c:\inetpub\wwwroot\SMSReporting_SIT\00000409 AppRoleName=webreport_approle)> Number=-2147217871 Description=Timeout expired Source=Microsoft OLE DB Provider for SQL Server NativeError=0
I've tried to increase asp command timeout from 5 minutes to 15 minutes and got no improvements.
Also tried to increase aspbufferlimit whith no results.SQL is not the problem. Running the same query in SQL Management Studio takes 12s ! So, what's wrong on the IIS side ?
Db is SQL 2005 and reporting server is running Server 2003.- Hi M1721c,
It looks like a buffer limit issue in IIS, if so you will see Response_Buffer_Limit_Exceeded.
If this is the case you need to increase is under ASP properties "REsponse Buffer limit". Default value is 4194304, as per this value it can respond up to 4000 records in your reports. if it is more than that increase the buffer limit to your max record count * 1024 Ex (9000 records * 1 MB (1024) = 9216000 or 9000 records * 2 MB = 18432000).
Surendar Reddy- Proposed As Answer byReddy Surendar Wednesday, November 04, 2009 1:40 PM
- Hi
For my part, there is no "Response_Buffer_Limit_Exceeded" in the logs. ASPBufferLimit is set to 40MB. Still not working ! - Did you run the query in DB how many rows it is returning?
if your ASP Bufer limit is set to 40 MB means value is "40960" is very less, as i mentioned if you are trying to view 5000 records you have to update buffer limit to (5000*1024) = '5120000'
Try this and let me know.
Surendar Reddy - It seems to be a report BUG in product, work around to run this report you need to select "Software Properties Hash (Optional):" without this query is trying to pull duplicate records.
Surendar Reddy- Proposed As Answer byReddy Surendar Wednesday, November 04, 2009 4:00 PM
- Unproposed As Answer byTorsten [MVP]MVP, ModeratorWednesday, November 04, 2009 4:02 PM
- I just unproposed that one because I am pretty sure that you cannot tell that there's a bug without having seen the affected site.
Hi Torsten,
Thanks for the quick response, I am able to repro this. could you please check the same from your side aswell.Reports --> Asset Intelligence ---> Software 02D - Computers with a specific software products-- Select collection SMS00004 (All Windows Workstation or Professional Systems) --> then select Software ID which has multiple versions on work stations --> then click on Display.
if you select Software Properties Hash (Optional) it is working fine.
I do not have any strong justification to say this is a BUG as we have a workaround to select version, however it can be a pain for some customers until they know about this option.
Surendar ReddyTo declare this a bug within the product you must rule out IIS and ASP.
The only way to do that is to use run the query within SQL Server Management Studio (SSMS).
This query run fine within SSMS. Although I don’t have all the AI enable in my lab (Just enabled it) it does run correctly, therefore this can't be a bug.
Run the query in SSMS yourself and see what you get.
http://www.enhansoft.com/
Somewhat related -- we're not seeing timeouts but we have been seeing issues with aspbuffering limit when running reports. 50K+ clients, reports being run are fairly basic. Could someone tell me if aspbuffering is required for SCCM reports or if it can be turned off? What impact would we see if aspbuffering is turned off?
Thank you,
Karen- If you disable the ASP buffering, reports will not run. However I never tried it.
If ASP buffering is turned on, this property controls the maximum number of bytes that an ASP page can write to the response buffer before a flush occurs.
And that the reason, if buffer limit is less then we get error 500 or time out error when the number of rows increased in the report. However increasing the ASP buffer limit may impact server performance.
Some ref link about ASP buffering
http://msdn.microsoft.com/en-us/library/ms526001.aspx
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/ea7e9c3f-d0c8-4e5c-8965-0d0429a3b8f1.mspx?mfr=true
Abhishek Joshi http://blogcastrepository.com/blogs/abi/default.aspx http://blogcastrepository.com/members/Abhishek.aspx- Proposed As Answer byAbhishek.JoshiMVPSunday, November 08, 2009 9:52 AM
