cancel
Showing results for 
Search instead for 
Did you mean: 

Error while exporting data from BOBJ Explorer in excel workbook format

param0308
Participant
0 Kudos

Hi,

I want to export the data from BOBJ explorer tool, But whenever I export record more than 9k it throws error(Attached as a image).

I think its the memory issue, So we raise the

xmx 4G

Perm size 512


Still its throws same error(See the attachment).

Regards

Rajender Singh

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Rajender,

First of all exporting huge amount of data to Excel using explorer is a bad idea.

Explorer is not designed for heavy operations.

Error: GC Overhead limit exceeded is due to memory only.

Kindly increase the xmx in the Exploration server properties to higher value and check.

Regards,

Mithilesh

CdnConnection
Active Contributor
0 Kudos

Raj,

     Depends on what version BI 4.x you are running, you should Export options:

  • Data (CSV)
  • Excel (XLS / XLSX)
  • WebI if source is UNV/UNX
  • Image

I would suggest you try Export as XLSX or as CSV.  Screenshot show Exporting on 2Mil++ Rows to XLSX without any issues on BI 4.1 w/ SP7.

Regards,

Ajay

0 Kudos

Hi,

What did log files record ? Look at Explorer 's log files on the server (master and/or exploration).

Maybe an error could be occured or memory failed during requesting or else ...

Arnaud