完整圖文版：http://note.youdao.com/share/?id=4fed991700c3eaa12f951d7bbe4f0e37&type=note
小強反映，很多跑的請求都是completed and warning狀態。
我們View log看一下情況。根據下面粗體內容，大概可以知道，可能是並發管理器數量不夠的問題。並且，日誌提示我們，可以適當提高OPP Response Timeout的等待時間。
+---------------------------------------------------------------------------+ DJI SCM: Version : UNKNOWN Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved. XXPO_RECEIVE module: DJI_採購收料通知單 +---------------------------------------------------------------------------+ Current system time is 11-JUN-2014 18:59:45 +---------------------------------------------------------------------------+ **Starts**11-JUN-2014 18:59:46 **Ends**11-JUN-2014 18:59:46 +---------------------------------------------------------------------------+ Start of log messages from FND_FILE +---------------------------------------------------------------------------+ +---------------------------------------------------------------------------+ End of log messages from FND_FILE +---------------------------------------------------------------------------+ +---------------------------------------------------------------------------+ Executing request completion options... Output file size: 779 +------------- 1) PUBLISH -------------+
Beginning post-processing of request 426785 on node ERP at 11-JUN-2014 18:59:46.
Post-processing of request 426785 failed at 11-JUN-2014 19:03:46 with the error message:
The Output Post-processor is running but has not picked up this request.
No further attempts will be made to post-process this request, and the request will be marked
with Warning status.
Setting the profile option Concurrent: OPP Response Timeout to a higher value may be necessary. +--------------------------------------+ +------------- 2) PRINT -------------+ Not printing the output of this request because post-processing failed. +--------------------------------------+ Finished executing request completion options. +---------------------------------------------------------------------------+ Concurrent request completed Current system time is 11-JUN-2014 19:03:46 +---------------------------------------------------------------------------+
在kingnod顧問dba Jack的指導下，以及根據： The Output Post-processor Is Running But Has Not Picked Up This Request.(文檔 ID 1547102.1) Concurrent Requests Fail Due to Output Post Processing (OPP) Timeout(文檔 ID 352518.1) 我們做了以下變更。
根據Option 1: Increase the value (in seconds) for the profile option 'Concurrent:OPP Response Timeout'. System的profile：Concurrent:OPP Response Timeout 從120改到900
根據Option 2: Increase the number of processes or threads (or both) of the OPP via Oracle Applications Manager (see Note 291792.1 for the detailed instructions) Output Post Processor 管理器的process從1改成5
並且在資料庫執行了以下sql，這是管理器java記憶體值的修改。 update fnd_cp_services set developer_parameters = 'J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx2048m' where service_id = (select manager_type from fnd_concurrent_queues where concurrent_queue_name = 'FNDCPOPP'); commit;
即將J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx512m 改成了J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx2048m。
啟示：這次的跑請求緩慢問題，是管理器數量不足，或者說，是預先設定的問題。我們發現，還有很多管理器，數量是1的，也可以考慮整改得更大。
