Re: Report limit in ITSM 7.6.4 (fixed thanks to Mac)
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
Re: Report limit in ITSM 7.6.4 (fixed thanks to Mac)
Howard, Reading the thread I am minorly confused... Can you provide together all three of the items to add to the config.properties. I will say that the August 10th Mid-Tier patch is much better than the July 7th. I just checked and the July 7th patch is no longer available. Claire From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Howard Richter Sent: Thursday, August 16, 2012 11:27 AM To: arslist@ARSLIST.ORG Subject: Re: Report limit in ITSM 7.6.4 (fixed thanks to Mac) ** 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Report limit in ITSM 7.6.4 (fixed thanks to Mac)
Claire, I was actually on the June 21st Hotfix when I added those lines to my config.properties file. Still haven't added either the July 7th or the August 10th patch. Since they are supposed to be cumulative, then the August 10th patch should work also for this (but I am only guessing at that). Change the below numbers to what your system can work with. My current patch level on Mid Tier: Version 7.6.04 SP3 201206211707 Hotfix #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: Sanford, Claire claire.sanf...@memorialhermann.org To: arslist@ARSLIST.ORG Date: 08/16/2012 03:17 PM Subject:Re: Report limit in ITSM 7.6.4 (fixed thanks to Mac) Sent by:Action Request System discussion list(ARSList) arslist@ARSLIST.ORG ** Howard, Reading the thread I am minorly confused? Can you provide together all three of the items to add to the config.properties. I will say that the August 10th Mid-Tier patch is much better than the July 7th. I just checked and the July 7th patch is no longer available. Claire From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG] On Behalf Of Howard Richter Sent: Thursday, August 16, 2012 11:27 AM To: arslist@ARSLIST.ORG Subject: Re: Report limit in ITSM 7.6.4 (fixed thanks to Mac) ** 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 _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
Re: Report limit in ITSM 7.6.4 (fixed thanks to Mac)
Mac and Claire, The funny (or sad part), is when we had another issue with our mid-tiers the support engineer said we were on the latest patch. However, those lines were missing. Well on to the next issue. Thanks to all and take care of your kidneys (maybe give one up to a friend in need), Howard From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mac Rhoades Sent: Thursday, August 16, 2012 3:32 PM To: arslist@ARSLIST.ORG Subject: Re: Report limit in ITSM 7.6.4 (fixed thanks to Mac) ** Claire, I was actually on the June 21st Hotfix when I added those lines to my config.properties file. Still haven't added either the July 7th or the August 10th patch. Since they are supposed to be cumulative, then the August 10th patch should work also for this (but I am only guessing at that). Change the below numbers to what your system can work with. My current patch level on Mid Tier: Version 7.6.04 SP3 201206211707 Hotfix #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:Sanford, Claire claire.sanf...@memorialhermann.org To:arslist@ARSLIST.ORG Date:08/16/2012 03:17 PM Subject:Re: Report limit in ITSM 7.6.4 (fixed thanks to Mac) Sent by:Action Request System discussion list(ARSList) arslist@ARSLIST.ORG _ ** Howard, Reading the thread I am minorly confused. Can you provide together all three of the items to add to the config.properties. I will say that the August 10th Mid-Tier patch is much better than the July 7th. I just checked and the July 7th patch is no longer available. Claire From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG] On Behalf Of Howard Richter Sent: Thursday, August 16, 2012 11:27 AM To: arslist@ARSLIST.ORG Subject: Re: Report limit in ITSM 7.6.4 (fixed thanks to Mac) ** 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 _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