‘File -> Export’ has stopped working in Oracle Apps 11.5.10.2

The symptoms for this specific client issue was File->Export seems to be functioning as normal.
The red progress bar with percentage counter is moving except at the end where a browser window should pop up and offer to download and save or open the output is not happening.

Pop-up blockers were disabled and security settings of the site’s URL in browsers set to trusted.

To determine if its related to tablespace size constraint:

SQL> SELECT SUM(bytes) FROM DBA_FREE_SPACE WHERE tablespace_name=’CTXD’;

Size smaller that 50MB (like in this site) triggers this issue.

To adjust the tablespace size, its related datafile should be resized or another datafile should be added. In our case i choosed to resize.

First identify the datafile(s) fro CTXD tablespace:

SQL> select substr(file_name,1,50), tablespace_name, bytes/1024/1024 from dba_data_files where tablespace_name = ‘CTXD’;

SUBSTR(FILE_NAME,1,50) TABLESPACE_NAME BYTES/1024/1024
—————————- ——————- —————
/d/oracle/prod3data/ctxd01.dbf CTXD 500

Currently the size is set to 500M. To resize the datafile to 1GB:

SQL> ALTER DATABASE DATAFILE ‘/d/oracle/prod3data/ctxd01.dbf’ RESIZE 1024M;

Referrence:
‘Export’ Function Has Stopped Working In All Modules (Doc ID 272526.1)

Advertisements

About this entry