Skip to Content
0
Former Member
Feb 15, 2007 at 10:28 AM

ORA-01652: unable to extend temp segment by 1280 in tablespace TEMP

153 Views

We have a lot of version 8.5 crystal report templates, now, as required, we want to use JRC (pure java) to export those templates to PDF / RTF etc.

We have done a lot, for the most of templates, works fine, but there are some reports, once the data is large, an error coming :ORA-01652: unable to extend temp segment by 1280 in tablespace TEMP

for this problem:

1. I have read the migration guide first :http://support.businessobjects.com/communityCS/TechnicalPapers/cr_xi_designer_migration.pdf

2. I have tested the templates with the same parameters in designer, they are just fine ( and obviously, the old templates can work with COM components in wintel platform , we used VB )

3. Because 2 works fine, I tried to extend our oracle temporary tablespace, but everytime I extend, I can see it will always be fully occupied by the JRC export function.

4. The problem is occured in the repSrc.export(expOpt, reqCont) function

I am now trying to find out the reasons:

1. checking the parameters real value in the report

2. enable log4j for JRC to see the real SQL statement

This is really annoying problem, I would appreciate if anyone could give me help.