Skip to Content
avatar image
Former Member

Detail log display error

Hello,

In the R3 system (4.6C, BRCONNECT 6.20 patch level 136, TOOLS HP-UX 11.23, oracle 9.2), we have scheduled a job CleanupLogs in DB13. The program works successfully but while displaying details logs following error occures.

BR252E Function fopen() failed for '/oracle/<SID>/sapreorg/cdxzmglv.cln'

at location file_printout-1

BR253E errno 2: No such file or directory

External program terminated with exit code 5

Job creates log file cdxzmglv.cln'

in '/oracle/<SID>/sapcheck/cdxzmglv.cln' but while diplaying it is looking at location as above mentioned in error.

Through Brtools we are able to display job log successfully.

Further , other jobs sheduled in DB13 , detail log display works

correctly. The problem is only with CleanupLogs job.

We would like know why while creating and displaying logs it seeks different location.

Request for your guidence please.

Regards

Kailash

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jun 05, 2008 at 12:45 PM

    Hello Kailash,

    Please check if the /oracle/<SID>/sapreorg/ exists and permissions of /oracle/<SID>/sapreorg/ are correct and accessible to ora<sid> userid.

    Regards,

    Siddhesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 05, 2008 at 12:58 PM

    Hello,

    This looks like a parameter problem.

    Do this:

    a) Call Transaction SM51 and log on to the instance on the database server

    b) Call Transaction DB03 -> Active parameters to display any parameter that points to sapreorg

    c) Change it to point to saptrace, i can't recollect which one to change so use your own judgement

    d) Change the same parameter in OS level also in init<SID>.ora

    For reference, have a look at the following note:

    SAP Note Number: 305740 - Display Optimizer Trace File (ORACLE)

    Although the note doesn't point to CleanupLogs, it talks about the error that you see in your log.

    Regards,

    Siddhesh

    Add comment
    10|10000 characters needed characters exceeded