Report is hang,never finished(R12)

我在R11i里面没碰到过，但在R12里面有碰到，现象就是只要是有输出的报表比如“有效用户”都会一直运行，从不结束。目前为止，碰到过2个平台的，一个是在AIX，一个是在Solaris，并且两个处理方法也不一样。

 

AIX：按照官方的安装文档，如果步骤都很正确，那这个问题也会被解决。

Solaris：用trace发现，有报错如下：

[2009/9/19 7:10:22:635] Exception 50125 (): Caught exception: java.lang.IllegalArgumentException
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
        at oracle.reports.utility.Utility.newRWException(Utility.java:758)
        at oracle.reports.utility.Utility.newRWException(Utility.java:771)
        at oracle.reports.comm.NetworkConfig.open(NetworkConfig.java:168)
        at oracle.reports.comm.NetworkUtility.initNetwork(NetworkUtility.java:63)
        at oracle.reports.server.RWServer.startServer(RWServer.java:656)
        at oracle.reports.server.RWServer.run(RWServer.java:289)
        at java.lang.Thread.run(Thread.java:534)

 

官方的解释如下：

The configuration file rwnetwork.conf is corrupt which is causing this error. The corruption could be due to missing tag "/" or  missing IP address.

按照官方的解决方法，操作如下：

1. Take a backup and remove rwnetwork.conf from $ORACLE_HOME/reports/conf
2. Bounce Applications tier.
3. Need to ensure rwnetwork.conf is got created on its own. As rwnetwork.conf  is removed , the system should generate new file.
4. Reproduce the issue. And check the below commands are works fine to ensure the issue is resolved.
   a) rwdiag.sh -findAll
   b) rwrun help=yes
   c) $INST_TOP/ora/10.1.2/bin/appsrwrun.sh userid=apps/compard mode=character report=$FND_TOP/reports/US/FNDSCURS.rdf batch=yes destype=file desname=./compard.out desformat=$FND_TOP/reports/HPL pagesize=132x66 traceopts=trace_all tracefile=compard.trc tracemode=trace_replace

其实仔细比较就知道该文件产生的时候PORT信息丢失了，直接填写进去也可以。