Skip to Content
author's profile photo Former Member
Former Member

Check DB Job failing

Hello Experts,

I'm running a job Check Db and it is failing continuously.

Here is the log that I'm getting in SM37:

Job started

Step 001 started (program RSDBAJOB, variant &0000000000000, user ID BATCHUSER)

ABAP/4 processor: CONNE_IMPORT_WRONG_FIELD_TYPE

Job cancelled

I also have warnings in DB16:

Table: SAPR3.BSIS, value: 1310720 KB * 2 / PSAPBSISD (> 2088944/778224/313304/307184/122864 KB) # Segment can cause tablespace o

Table: SAPR3.ACCTIT, tablespace: PSAPACCTITD # Table or index in wrong tablespace

Table: SAPR3.ZSDCOOP # Table or index has no optimizer statistics

Operation: sdzmplea.tse, time: 2008-12-17 09.57.00 failed with rc = 4 # Last 'tse' operation failed with rc = 4

Operation: cdzkbhwh.chk, time: 2008-12-03 23.06.15 older than 10 days # Last successful 'chk' operation older than 10 days

Time: 2008-12-03 23.16.16, line: Checkpoint not complete

Value: 14505984 (>< 4096,512 KB) # Size of redo log buffer in bytes

Value: 20 (set in parameter file) # Optimizer index cost adjustment

Value: 0 (< 400 MB) # Size of Oracle shared pool

Value: TRUE (set in parameter file) # Maintain internal timing statistics

Can anybody tell me what the problem is and how to solve it.

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Dec 20, 2008 at 03:12 PM

    you have a lot of error messages. the fact that the job is failing is not related to the warnings in DB16.

    *Table: SAPR3.BSIS, value: 1310720 KB * 2 / PSAPBSISD (> 2088944/778224/313304/307184/122864 KB) # Segment can cause tablespace o*

    increase size of PSAPBSISD

    Table: SAPR3.ACCTIT, tablespace: PSAPACCTITD # Table or index in wrong tablespace

    supply contents of tables TAORA, IAORA and TSORA.

    Table: SAPR3.ZSDCOOP # Table or index has no optimizer statistics

    recalc DB stats from DB13 or run:

    brconnect -c -u / -f stats -t missing

    Operation: sdzmplea.tse, time: 2008-12-17 09.57.00 failed with rc = 4 # Last 'tse' operation failed with rc = 4

    last time you tried to extend a tablespace , process failed.

    Operation: cdzkbhwh.chk, time: 2008-12-03 23.06.15 older than 10 days # Last successful 'chk' operation older than 10 days

    DBA job CHECKDB was not successful in over 10 days.

    Time: 2008-12-03 23.16.16, line: Checkpoint not complete

    search SAP notes about this one.

    Value: 14505984 (>< 4096,512 KB) # Size of redo log buffer in bytes

    check SAP note 830576

    Value: 20 (set in parameter file) # Optimizer index cost adjustment

    check SAP note 830576

    Value: 0 (< 400 MB) # Size of Oracle shared pool

    check SAP note 830576

    Value: TRUE (set in parameter file) # Maintain internal timing statistics

    check SAP note 830576

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.