cancel
Showing results for 
Search instead for 
Did you mean: 

Detail log display error

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member185954
Active Contributor
0 Kudos

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

former_member185954
Active Contributor
0 Kudos

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

former_member185954
Active Contributor
0 Kudos

Please ignore the earlier comment.

Regards,

Siddhesh