cancel
Showing results for 
Search instead for 
Did you mean: 

SAP database check finished with warning

mohsin_m3
Participant
0 Kudos

Hello All,

In sapcheck folder latest .chk file finished with following warnings

BR0280I BRCONNECT time stamp: 2009-04-01 10.30.50

BR0972I Checking database operations...

BR0973W Database operation alert - level: WARNING, operation: cdzsjafp.log, time: 2009-01-17 05.13.45, condition: Last 'log' operation failed with rc = 3

Kindly help me resolve the issue.

Regards

Mohsin

Accepted Solutions (1)

Accepted Solutions (1)

debasissahoo
Active Contributor
0 Kudos

Hi,

can you find cdzsjafp.log in SAPDATA_HOME folders anywhere?

I wonder what a log opearation can be!

Do you see any warning in DB16?

Thanks,

Debasis.

mohsin_m3
Participant
0 Kudos

Hello

In db16 following warnings find

Check Time 02.04.2009 12:25:43

Check Program BRCONNECT

Condition Type DBO

Condition Level W

Condition Name LAST_OPERATION_FAILED

Check Object

Check Condition

Description Operation: cdzsjafp.log, time: 2009-01-17 05.13.45 failed wi

Correction Type D

Corrective Action Check the operation log

Check Log /oracle/AQ5/sapcheck/ceagozat.chk

Cause of Error /oracle/AQ5/sapreorg/cdzsjafp.log

debasissahoo
Active Contributor
0 Kudos

Then check /oracle/AQ5/sapreorg/cdzsjafp.log. what does it contain?

mohsin_m3
Participant
0 Kudos

Hello,

File (cdzsjafp.log)missing at this location Then check /oracle/AQ5/sapreorg

Regards

Mohsin Mulani

Answers (1)

Answers (1)

Former Member
0 Kudos

>

> Hello All,

>

> In sapcheck folder latest .chk file finished with following warnings

>

> BR0280I BRCONNECT time stamp: 2009-04-01 10.30.50

> BR0972I Checking database operations...

> BR0973W Database operation alert - level: WARNING, operation: cdzsjafp.log, time: 2009-01-17 05.13.45, condition: Last 'log' operation failed with rc = 3

>

> Kindly help me resolve the issue.

>

> Regards

> Mohsin

Hello,

The warning occurs because the database check looks for the logs of all old operations that ended with an error. The text "Last 'log' operation" means: an operation log with the extension ".log"was found for an action that ended with the (error) status RC = 3.

Since the log referred to is old (January 17), you can get rid of it by running:

brconnect -u / -c force -f cleanup -m 60

(60 is the minimum age of the logs to clean up; adapt this value to your requirements)

Also, it is a good idea to schedule the action "Cleanup logs" periodically via DB13.

Regards,

Mark

mohsin_m3
Participant
0 Kudos

Hello Mark,

Just now I have checked latest .chk file

BR0280I BRCONNECT time stamp: 2009-04-07 15.51.48

BR0972I Checking database operations...

BR0973W Database operation alert - level: WARNING, operation: ceahoekr.cln, time: 2009-04-07 15.29.41, condition: Last 'cln' operation failed with rc = 2

BR0973W Database operation alert - level: WARNING, operation: cdzsjafp.log, time: 2009-01-17 05.13.45, condition: Last 'log' operation failed with rc = 3

Can u plz explain what action I should be taken to resolve the issue??

Regards

Mohsin

Edited by: mohsin m on Apr 7, 2009 5:30 PM

Former Member
0 Kudos

Hi Mohsin,

Did you run the "-f cleanup" as instructed?

Rgds,

Mark

Former Member
0 Kudos

Hi again Mohsin,

Sorry I should have looked better at your last post. The cleanup '.cln' itself has run into an error. Could you post the relevant part of that log?

Mark

mohsin_m3
Participant
0 Kudos

Hello Mark,

I have execute this command >>> brconnect -u / -c force -f cleanup -m 60

and execute db check again but warning still persist,

BR0280I BRCONNECT time stamp: 2009-04-13 20.10.22

BR0969I Checking database administration...

BR0970W Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPR3./BIC/FCDP_ASH02

BR0280I BRCONNECT time stamp: 2009-04-13 20.10.22

BR0972I Checking database operations...

BR0973W Database operation alert - level: WARNING, operation: cdzsjafp.log, time: 2009-01-17 05.13.45, condition: Last 'log' operation failed with rc = 3

Kindly suggest me for further action

Thanks

Mohsin

Edited by: mohsin m on Apr 13, 2009 8:11 PM

mohsin_m3
Participant
0 Kudos

plaixlpc066:oraaq5 5> ls -altr cdzsjafp.log

ls: 0653-341 The file cdzsjafp.log does not exist.

plaixlpc066:oraaq5 6> pwd

/oracle/AQ5/sapcheck

plaixlpc066:oraaq5 7>

Former Member
0 Kudos

Hi Mohsin,

As I said in my earlier reply the "brconnect -f cleanup" itself seems to have failed. Could you post the relevant part (errors) of ceahoekr.cln or run the command again online and report the outcome?

Regards,

Mark