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資訊丢失了，直接填寫進去也可以。