Severe error(s) occurred in phase MAIN_SHDCRE/SUBMOD_SHDDBCLONE/UPDATE_DBSTATS_SHDCLONE!

[Former Member]

Hi Guys,

I am doing SPS06 to SPS09 upgrade in CRM SND 7.0 EHP3 server using SUM tool. I am getting the following error in preprocessing Phase....

Here are the error details:

Severe error(s) occurred in phase  MAIN_SHDCRE/SUBMOD_SHDDBCLONE/UPDATE_DBSTATS_SHDCLONE!
   

Last error code set: Non single errors (code &gt; 😎 found in logfile 'UPST_SHDCLONE.ELG'<br/> 2 error during parallel execution of processes,   check 'UPST_SHDCLONE.ELG' for details<br/> 4 processes failed, check   'SQLSTMTSTD.*' for details
   

ERROR:
Detected the following errors:
   

    # /sapsource/sum/SUM/abap/log/EXSTATE03.LOG:
3
    ETQ398XSQL: '"AGR_BUFFI3~"' ); END;
3 ETQ398
    SQL: BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME =>
3
    ETQ398XSQL: '"AGR_DEFINE~"' ); END;
1 ETQ000
    ==================================================
4
    ETQ010 Date & Time: 20141129112258
1EETQ008 Error
    message: DBSL error 99 (db code 1114):
ORA-01114: IO error
    writing block to file (block # )
ORA-06512: at
    "SYS.DBMS_STATS", line 23829
ORA-06512: at
    "SYS.DBMS_STATS", line 23880
ORA-06512: at line 1
1EETQ003
    exit code: "12"

Here are the log file:UPST_SHDCLONE.ELG

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

SQL EXECUTION ERRORS and RETURN CODE in EXSTATE01.LOG

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

3 ETQ398XSQL:  '"AEXUP~"' ); END;

3 ETQ398 SQL: BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME =>

3 ETQ398XSQL:  '"AGR_1016~"' ); END;

1 ETQ000 ==================================================

4 ETQ010 Date & Time: 20141129112257 

1EETQ008 Error message: DBSL error 99 (db code 1114):

ORA-01114: IO error writing block to file  (block # )

ORA-06512: at "SYS.DBMS_STATS", line 23829

ORA-06512: at "SYS.DBMS_STATS", line 23880

ORA-06512: at line 1

1EETQ003 exit code: "12"

<NO EXIT CODE FOUND - PROGRAM ABORTED?>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

SQL EXECUTION ERRORS and RETURN CODE in EXSTATE03.LOG

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

3 ETQ398XSQL:  '"AGR_BUFFI3~"' ); END;

3 ETQ398 SQL: BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME =>

3 ETQ398XSQL:  '"AGR_DEFINE~"' ); END;

1 ETQ000 ==================================================

4 ETQ010 Date & Time: 20141129112258 

1EETQ008 Error message: DBSL error 99 (db code 1114):

ORA-01114: IO error writing block to file  (block # )

ORA-06512: at "SYS.DBMS_STATS", line 23829

ORA-06512: at "SYS.DBMS_STATS", line 23880

ORA-06512: at line 1

1EETQ003 exit code: "12"

<NO EXIT CODE FOUND - PROGRAM ABORTED?>

--------------------------------------------------------------------------------------------------------------------------- 

Log file : SAPup_Troubleticket.log

This trouble ticket was created by SAPup on 20141129113103

-------------------------------------------------------------

SAPup broke during phase SUBMOD_SHDDBCLONE/UPDATE_DBSTATS_SHDCLONE in module MAIN_SHDCRE / Import and Modification Transfer

Error Message: Non single errors (code > 😎 found in logfile 'UPST_SHDCLONE.ELG'

2 error during parallel execution of processes, check 'UPST_SHDCLONE.ELG' for details

4 processes failed, check 'SQLSTMTSTD.*' for details

-------------------------------------------------------------

-------------------------------------------------------------

Summary of SAPup:

-------------------------------------------------------------

SAPehpi Release: lmt_008

SAPehpi Version: SAPup release lmt_008 version 53.000

Start Release: 740

Target Release: 740

Please anyone can help me to reslove this issue.

Regards,

Naresh

[Former Member · Accepted solution]

Hi,

Check whether any tablespace/filesystem is full.

regards,

pavan

[Former Member]

Sorry for dealy reply. This issue is resolved. Its faced because of Space problem.

Thanks every one.

Regards,

Naresh

[Former Member]

Hi Naresh,

Please past the alert.log for that time stamp here. Also past the output of command df -h.

Regards,

Pavan Gunda

[Reagan]

Hello

ORA-01114: IO error writing block to file  (block # )
ORA-06512: at "SYS.DBMS_STATS", line 23829
ORA-06512: at "SYS.DBMS_STATS", line 23880

You have problem at the database side. Check the Oracle database alert log to know more about this error. Also check the SAP note 633914 - Error when executing DBMS_STATS for the error ORA-01114.

Reagan