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 cmrho...@rockwellcollins.com www.rockwellcollins.com From: Howard's Gmail <hbr4...@gmail.com> To: 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)" <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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
