Howard, What is even funnier is that the one they gave you has nothing to do with the number of records you pull for a report. That only has to do with exporting of records that you have already pulled. I ran into that one because I changed the webreport entry from the default of 2000 to 5000 but when the folks wanted to save them in a CSV file, that entry was still set to 2000 so I bumped it up to 5000 and everything worked.
Mac Rhoades / Sr Programmer/Analyst-Specialized Systems / Service Management MS 352-100, 2205 Northmont Pkwy., Duluth, GA, USA Phone: 678-252-4364 / VPN: 252-4364 [email protected] www.rockwellcollins.com From: Howard Richter <[email protected]> To: [email protected] Date: 08/16/2012 09:18 AM Subject: Re: Report limit in ITSM 7.6.4 Sent by: "Action Request System discussion list(ARSList)" <[email protected]> ** Mac, We were trying to go to 15k. What is funny is that you have two additional changes that I was not given by BMC. arsystem.nativereport.onscreen_max_entries=5000 arsystem.webreport.onscreen_max_entries=5000 In fact the two entries above, are not in our config.properties file. The one we were given was this one. #Maximum entries to be exported to CSV file arsystem.FileExport_max_entries=15000 More incomplete info from BMC support. Howard From: Action Request System discussion list(ARSList) [ mailto:[email protected]] On Behalf Of Mac Rhoades Sent: Thursday, August 16, 2012 8:08 AM To: [email protected] Subject: Re: Report limit in ITSM 7.6.4 ** Howard, We were having the same problem with our reports. Here is what we got back from BMC. These numbers worked for us but you may need different ones. The only additional thing I did was to bump the CSV file entry below to 5000. I don't know of a limit on what the numbers can be but obviously the higher the number the heavier the load on processing. You will need to have Midtier 7.6.04 sp3 installed and then apply the hotfix dated July 7th. The hotfix can be downloaded from ftp://ftp.bmc.com/outgoing/7604sp3_hotfix. Once the hotfix applied, the following needs to be added to the midtier's config.properties file: #Maximum entries to be fetched for AR System/Native report to be displayed on screen arsystem.nativereport.onscreen_max_entries=5000 arsystem.webreport.onscreen_max_entries=5000 #Maximum entries to be exported to CSV file arsystem.FileExport_max_entries=2000 Mac Rhoades / Sr Programmer/Analyst-Specialized Systems / Service Management MS 352-100, 2205 Northmont Pkwy., Duluth, GA, USA Phone: 678-252-4364 / VPN: 252-4364 [email protected] www.rockwellcollins.com From: Howard's Gmail <[email protected]> To: [email protected] Date: 08/15/2012 08:00 PM Subject: Report limit in ITSM 7.6.4 Sent by: "Action Request System discussion list(ARSList)" < [email protected]> Good morning, afternoon and evening (depending on your time zone) All, I wonder if anyone else has seen a limit on the amount of data (records), that the new reporting tool can pull back? For example if I run a query for the past 21days of reported incidents in the help desk form I pull back around 12k of incidents. However, if I create a report (with the new web reporting tool) with the same query, I only get back 2k of incidents. Am I crazy (be nice) or did I just find an issue with the new reporting tool? Howard Sent from one of Howard's iPads _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
