otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTMFAQ Tutorials

OTM SIG
MavenWire

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

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


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

Tags: , , , ,

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: 816
Blog Entries: 7
Thanks: 53
Thanked 199 Times in 121 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 10
chrisplough has a spectacular aura aboutchrisplough has a spectacular aura aboutchrisplough has a spectacular aura about
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
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
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
[SOLVED] Exporting large reports to Excel causes crash chrisplough Reports / FTI and Other Analytics 0 October 2nd, 2007 18:13
Exporting reports to excel in OTM 5.0 geetika Reports / FTI and Other Analytics 0 September 21st, 2007 05:15
Error while exporting matrix report to Excel soujanya Reports / FTI and Other Analytics 0 August 16th, 2007 14:36
[SOLVED] Linking Air Freight Rate Records to Schedules joecallan Rating 8 August 7th, 2007 16:06
[SOLVED] screens neelimachenta Branding, Screen Sets, XSL/CSS and Translations 3 June 28th, 2007 07:09



All times are GMT. The time now is 18:42.
Copyright © 2008, Open Book Solutions LLC. All rights reserved.

Sponsored by MavenWire - MavenWire.com


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