Check DB Job failing

[Former Member]

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.

[former_member204746]

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