All,
Mac got it right. The issue is fixed when you change all three items. Now how do we make sure BMC send all of that to anyone having the same issue I did? Take care and thank you Mac, Howard From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mac Rhoades Sent: Thursday, August 16, 2012 9:26 AM To: arslist@ARSLIST.ORG Subject: Re: Report limit in ITSM 7.6.4 ** 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 <mailto:cmrho...@rockwellcollins.com> cmrho...@rockwellcollins.com <http://www.rockwellcollins.com/> www.rockwellcollins.com From: Howard Richter <hbr4...@gmail.com> To: arslist@ARSLIST.ORG Date: 08/16/2012 09:18 AM Subject: Re: Report limit in ITSM 7.6.4 Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> _____ ** 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:arslist@ARSLIST.ORG> mailto:arslist@ARSLIST.ORG] On Behalf Of Mac Rhoades Sent: Thursday, August 16, 2012 8:08 AM To: arslist@ARSLIST.ORG 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> 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 <mailto:cmrho...@rockwellcollins.com> cmrho...@rockwellcollins.com <http://www.rockwellcollins.com/> www.rockwellcollins.com From: Howard's Gmail < <mailto:hbr4...@gmail.com> hbr4...@gmail.com> To: <mailto:arslist@ARSLIST.ORG> arslist@ARSLIST.ORG Date: 08/15/2012 08:00 PM Subject: Report limit in ITSM 7.6.4 Sent by: "Action Request System discussion list(ARSList)" < <mailto:arslist@ARSLIST.ORG> arslist@ARSLIST.ORG> _____ 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 <http://www.wwrug.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"