DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

REP-0177: Error while running in remote server ORA-128 01:

541649Oct 24 2006 — edited Oct 25 2006

Hi,
i have scheduled a report to run and it takes a very long time to run over an hour in 10g but it used to take about 20 mins in 9i. The job should create a pdf file and email that to the user who scheduled the report. The report fails with the following error:

Using command line: rwclient.sh server=repprodvega report=l_finr0021 MODE=BITMAP DESFORMAT=pdf DESTYPE=FILE RECURSIVE_LOAD=NO PARAMFORM=NO BATCH=YES DESNAME=/u01/app/callista/prod/jbs/output/l_finj0021.lst.163548 P_REQUEST_JOB_RUN_ID=163548 P_COMMENT= P_PREVIEW_MODE=0

Running Report

REP-0177: Error while running in remote server

'cf_total_with_previousformula': Fatal PL/SQL error occurred.

ORA-128 01: error signaled in parallel query server

Error occurred executing report

Can someone please help, any suggestions, comments would be great.

thank you!
Jaque