otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
 Follow New Posts:Twitter
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTM Wiki

OTM SIG
OTM Wiki
MavenWire

Go Back   Oracle OTM / G-Log GC3 Community Support > OTM / G-Log - Technical Topics > Reports / BI / FTI and Other Analytics
Reload this Page

[SOLVED] Exporting more than 1000 records to Excel - Screens and Reports


Reports / BI / FTI and Other Analytics Integrating OTM / G-Log with Oracle Reports, BI, FTI (OBIEE) and creating custom reports / analytics.

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old September 26th, 2007, 12:43
chrisplough's Avatar
Site Moderator
 
Join Date: Jun 2006
Location: West Chester, PA
Posts: 1,167
Blog Entries: 8
Groans: 0
Groaned at 1 Time in 1 Post
Thanks: 143
Thanked 259 Times in 161 Posts
Rep Power: 10
chrisplough is a jewel in the roughchrisplough is a jewel in the roughchrisplough is a jewel in the rough
Send a message via AIM to chrisplough
[SOLVED] Exporting more than 1000 records to Excel - Screens and Reports

Hello,

There is an issue with OTM, where you can't export more than 1000 records from a finder screen to Excel, or from an HTML report to Excel. This is limited via a property on the OTM Web Server's glog.properties file.

The issue is that the property listed in the properties file is incorrectly named, so that changing it won't update the behavior. The old property is:
Code:
glog.webserver.finderresults.maxexportcount
Instead, you need to add and set the following property:
Code:
glog.webserver.finder.export_limit
Keep in mind that Oracle gives the following suggestions:
  • We do not suggest you use the UI to export large amounts of data (for example, any more than 1000 records)
  • We have identified this as a problem and in version 5.5 have added a property to limit the user to the amount of data that can be exported. (the default is 1000)
  • You should limit the export to smaller data sets and then combine them manually.
  • If you need to export larger volumes than this, we suggest that you use the CSV export functionality.
This is slated to be fixed in OTM v5.5 CU4 (bug 6319538 and 631952

Thanks,
Chris
__________________
Chris Plough
MavenWire

www.MavenWire.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Reports in Excel anirban1982 Reports / BI / FTI and Other Analytics 2 August 24th, 2009 12:01
Exporting reports to excel in OTM 5.0 geetika Reports / BI / FTI and Other Analytics 1 May 8th, 2009 09:29
Exporting a List Of Reports from Reports Servlet cspadola Reports / BI / FTI and Other Analytics 2 July 4th, 2008 06:46
[SOLVED] Exporting large reports to Excel causes crash chrisplough Reports / BI / FTI and Other Analytics 0 October 2nd, 2007 18:13
Error while exporting matrix report to Excel soujanya Reports / BI / FTI and Other Analytics 0 August 16th, 2007 14:36



All times are GMT. The time now is 04:36.
Copyright © 2006-2009, Open Book Solutions LLC. All rights reserved.


Inactive Reminders By Icora Web Design

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40