Report在執行時Error, 訊息為:
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request xxxxxxx.
Review your concurrent request log and/or report output file for more detailed information.
Log的訊息為:
REP-0300: ORACLE error occurred.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-300: ORACLE error occurred.
.....
Program exited with status 1
.....
Post-processing of request xxxxxxx failed at 30-JUN-2017 16:25:17 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.
查看OPP log中的資訊:
java.io.FileNotFoundException
.....
(No such file or directory (errno:2))
應是輸出檔沒有正常產生, 看不出是什麼問題, 而且只有特定user不定時發生.
查看所下的參數, 的確也有不同. 以report中SQL直接執行, 經過一段時間, 出現rollback segment too small的error. 依此推論, 可能是這造成Program exited with status 1.
調過SQL後, 執行狀況正常, 再繼續觀察.
--
補充, 若report中的formula有error, 也可能出現此錯誤訊息.
沒有留言:
張貼留言
注意：只有此網誌的成員可以留言。