ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORACLE ERP点文件>导出 功能后一闪而过无法导出

ORACLE ERP点文件>导出 功能后一闪而过无法导出

原创 Linux操作系统 作者:oldboy0352 时间:2011-02-09 16:32:06 0 删除 编辑

ORACLE ERP点文件>导出 功能后一闪而过无法导出的原因是因为CTXD表空间不够导致,增加此表空间大小来解决。


alter tablespace CTXD add datafile '/**/**/ctxd02.dbf' size 100m;(100m应该足够,请根据实际情况调整)

或 alter   database   datafile   '/**/**/ctxd01.dbf  resize   100M;

 

详情详见METALINK note:

'Export' Function Has Stopped Working In All Modules [ID 272526.1]

Applies to:

Oracle Application Object Library - Version: 11.5.10 to 11.5.10.2
This problem can occur on any platform.

Symptoms

The export function appears to work as normal, gathering the table data and progresses through the red export-status bar, but then terminates with no output.

In order to debug the issue and see actual error message do the following steps:
a- Turn on export debug by going to (Help -> Diagnostics -> Examine) menu option.
b- Set Block = GLOBAL, Set Field = FND_EXPORT_DEBUG, Set Value = TRUE
c- Retest the issue and it will fail after the message:
   Export: Writing prompts for type WEB
   Export: Exception OTHERS

As well when you generate FRD log file, the following error will be shown there:
Unhandled Exception ORA-100501

Cause

One of the reason might be the table space problem.
Need to review the error of the sql script. given and take action based on the error.

Solution

1- Run the following in SQL*Plus as APPS user:

set serveroutput on
declare
db_file NUMBER;
mime_type VARCHAR2(255) := 'text/plain';
out_string VARCHAR2(32767) := 'Just some plain text that is stored.';
web_server_prefix VARCHAR2(500);
url VARCHAR2(500);
begin
db_file := fnd_gfm.file_create(content_type => mime_type, program_name =>'export');
fnd_gfm.file_write_line(db_file, out_string);
db_file := fnd_gfm.file_close(db_file);
url := fnd_gfm.construct_download_url(fnd_web_config.gfm_agent, db_file, TRUE);
dbms_output.put_line(url);
end;
/


2- If the error points to space quota problem then database administrator has to be contacted to fix it.

The following might help in doing so.

2.1. Determine the total available tablespace storage space:

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


2.2. If storage is low, add a datafile to the problem tablespace:

SQL> ALTER TABLESPACE ADD DATAFILE 'filespec' SIZE xxM


Replace with the name of the tablespace - CTXD.
Replace 'filespec' with the full pathname of the datafile, including the datafile name. Remember to enclose this in quotes.
Replace xxM with the size of the datafile in MB, for example 50M.

2.3. Grant unlimited quota to the user on that tablespace.

ALTER USER QUOTA UNLIMITED ON ;


Replace with CTXSYS
Replace with CTXD

3. If the problem continues to occur after performing any of the above, then issue the following command:

GRANT RESOURCE TO ;

References

NOTE:167635.1 - How To Perform. Forms Runtime Diagnostics (FRD) Tracing in Applications 11i

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/171851/viewspace-686908/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-12-09

  • 博文量
    18
  • 访问量
    86673