Severe error(s) occurred in phase PREP_IMPORT/UPDATE_DBSTATS_TODIR!

[tan_michael]

Hi Everyone!

I'm having trouble in upgrading our system from SAP ECC 6 EHP0 to EHP8.
I am stuck in Severe error(s) occurred in phase PREP_IMPORT/UPDATE_DBSTATS_TODIR! error.

Here is the Error:

then the logs:

SAPup> Starting subprocess in phase 'UPDATE_DBSTATS_TODIR' at <ID>
*CENV: BR_ISP=1
ENV: DBMS_TYPE=ora
ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
ENV: ORACLE_HOME=E:\oracle\PRD\12102
ENV: ORACLE_SID=PRD
ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC;.CPL
ENV: PATH=F:\usr\sap\prd\sum\abap\exe;E:\oracle\PRD\12102\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Users\prdadm\AppData\Local\Microsoft\WindowsApps;D:\usr\sap\PRD\SYS\exe\uc\NTAMD64
ENV: RSEC_SSFS_DATAPATH=\\<HOST>\sapmnt\PRD\SYS\global\security\rsecssfs\data
ENV: RSEC_SSFS_KEYPATH=\\<HOST>\sapmnt\PRD\SYS\global\security\rsecssfs\key
*CENV: SAPCHECK=F:\usr\sap\prd\sum\abap\tmp
ENV: SAPDATA_HOME=G:\oracle\PRD
ENV: SAPSYSTEMNAME=PRD
*DBENV: dbs_ora_schema=SAPSR3
ENV: dbs_ora_tnsname=PRD
ENV: rsdb_ssfs_connect=1
*DBENV: (auth_shadow_upgrade)
PWD: F:\usr\sap\prd\sum\abap\tmp

EXECUTING F:\usr\sap\prd\sum\abap\exe\brconnect.EXE -u -p F:\usr\sap\prd\sum\abap\tmp\OPTSTAT.LST -c -f stats -f allsel,collect -p 6 -RDB
BR0801I BRCONNECT 7.40 (49)
BR0280I BRCONNECT time stamp: 2024-11-25 10:39:46
BR0262I Enter database user name[/password]:
BR0805I Start of BRCONNECT processing: cfpvjioo.sta 2024-11-25 10:39:46
BR0484I BRCONNECT log file: F:\usr\sap\prd\sum\abap\tmp\cfpvjioo.sta
BR0280I BRCONNECT time stamp: 2024-11-25 10:39:53
BR0301W SQL error -1024 at location brc_dblog_open-5, SQL statement:
'INSERT INTO SAP_DBATL (SYS_ID, OPER_ID, TASKNAME, JOB_NR, UPD_OP, TLOGNAME, STATUS, BEGIN_OP, END_OP, RC, INTERNAL) VALUES ('PRD', '20241125103946', 'Update optimizer statistics', '0000000000', '20241125103953', 'F:\usr\sap\prd\sum\abap\tmp\cfpvjioo.sta', 'STARTED', '20241125103946', ' ', '0000', ' ')'
ORA-01024: invalid datatype in OCI call
BR0324W Insertion of database log header failed

BR0280I BRCONNECT time stamp: 2024-11-25 10:39:54
BR0813I Schema owners found in database PRD: SAPSR3*, SAPSR4DB
BR0280I BRCONNECT time stamp: 2024-11-25 10:39:54
BR0301E SQL error -1024 at location BrIndListGet-1, SQL statement:
'OPEN curs_78 CURSOR FOR'
'SELECT OWNER, INDEX_NAME, INDEX_TYPE, TABLE_OWNER, TABLE_NAME, NVL(TABLESPACE_NAME, ' '), NVL(PARTITIONED, ' '), NVL(UNIQUENESS, ' '), NVL(COMPRESSION, ' '), NVL(PREFIX_LENGTH, 0), NVL(GENERATED, ' '), NVL(JOIN_INDEX, ' '), NVL(STATUS, ' '), NVL(LOGGING, ' '), NVL(NUM_ROWS, -1), NVL(BLEVEL, -1), NVL(LEAF_BLOCKS, -1), NVL(DISTINCT_KEYS, -1), NVL(AVG_LEAF_BLOCKS_PER_KEY, -1), NVL(AVG_DATA_BLOCKS_PER_KEY, -1), NVL(CLUSTERING_FACTOR, -1), NVL(SAMPLE_SIZE, -1), NVL(TO_NUMBER(TO_CHAR(LAST_ANALYZED, 'YYYYMMDDHH24MISS')), 0), NVL(INITIAL_EXTENT, -1), NVL(NEXT_EXTENT, -1), NVL(MAX_EXTENTS, -1), NVL(DEGREE, '-1'), NVL(PCT_FREE, -1), NVL(INI_TRANS, -1), NVL(MAX_TRANS, -1), NVL(GLOBAL_STATS, ' '), NVL(TEMPORARY, ' ') FROM DBA_INDEXES WHERE OWNER = 'SAPSR3' AND INDEX_TYPE <> 'CLUSTER' AND INDEX_TYPE <> 'LOB' AND TABLE_OWNER = 'SAPSR3' AND TABLE_NAME = 'TODIR' AND TEMPORARY <> 'Y' ORDER BY OWNER, TABLE_NAME, INDEX_NAME'
ORA-01024: invalid datatype in OCI call

BR0806I End of BRCONNECT processing: cfpvjioo.sta 2024-11-25 10:39:54
BR0280I BRCONNECT time stamp: 2024-11-25 10:39:54
BR0804I BRCONNECT terminated with errors
SAPup> Process with PID 12460 terminated with status 3 at 20241125103954!

Is there any SAP Notes for this error?

Thanks,

[S_Sriram]

Hi Michael,

Check this SAP Note 3332611

Regards

SS

[tan_michael]

I followed SAP Note 3332611

Set the correct env
Re-installed sap kernel
installed correct brtools
re-installed db client
updated db client 

but still error persists 

[S_Sriram]

Hi Michael, Could you share the full error log, and check the overall disk space in SAP USR folder and DB log

[tan_michael]

Hi Sriram,

What log file I need to view for the DB log.

For disk space I have more than 100GB left in the disk.
Thanks,

[tan_michael]

Hi Sriram, 

Here are the logs I found:

ORAUPDATE:

EXECUTING F:\usr\sap\prd\sum\abap\exe\brconnect.EXE -u -p F:\usr\sap\prd\sum\abap\tmp\OPTSTAT.LST -c -f stats -f allsel,collect -p 6 -RDB
BR0801I BRCONNECT 7.40 (49)
BR0280I BRCONNECT time stamp: 2024-11-26 06:28:19
BR0262I Enter database user name[/password]:
BR0805I Start of BRCONNECT processing: cfpvnkbj.sta 2024-11-26 06:28:19
BR0484I BRCONNECT log file: F:\usr\sap\prd\sum\abap\tmp\cfpvnkbj.sta
BR0280I BRCONNECT time stamp: 2024-11-26 06:28:23
BR0301W SQL error -1024 at location brc_dblog_open-5, SQL statement:
'INSERT INTO SAP_DBATL (SYS_ID, OPER_ID, TASKNAME, JOB_NR, UPD_OP, TLOGNAME, STATUS, BEGIN_OP, END_OP, RC, INTERNAL) VALUES ('PRD', '20241126062819', 'Update optimizer statistics', '0000000000', '20241126062823', 'F:\usr\sap\prd\sum\abap\tmp\cfpvnkbj.sta', 'STARTED', '20241126062819', ' ', '0000', ' ')'
ORA-01024: invalid datatype in OCI call
BR0324W Insertion of database log header failed

BR0280I BRCONNECT time stamp: 2024-11-26 06:28:24
BR0813I Schema owners found in database PRD: SAPSR3*, SAPSR4DB
BR0280I BRCONNECT time stamp: 2024-11-26 06:28:24
BR0301E SQL error -1024 at location BrIndListGet-1, SQL statement:
'OPEN curs_78 CURSOR FOR'
'SELECT OWNER, INDEX_NAME, INDEX_TYPE, TABLE_OWNER, TABLE_NAME, NVL(TABLESPACE_NAME, ' '), NVL(PARTITIONED, ' '), NVL(UNIQUENESS, ' '), NVL(COMPRESSION, ' '), NVL(PREFIX_LENGTH, 0), NVL(GENERATED, ' '), NVL(JOIN_INDEX, ' '), NVL(STATUS, ' '), NVL(LOGGING, ' '), NVL(NUM_ROWS, -1), NVL(BLEVEL, -1), NVL(LEAF_BLOCKS, -1), NVL(DISTINCT_KEYS, -1), NVL(AVG_LEAF_BLOCKS_PER_KEY, -1), NVL(AVG_DATA_BLOCKS_PER_KEY, -1), NVL(CLUSTERING_FACTOR, -1), NVL(SAMPLE_SIZE, -1), NVL(TO_NUMBER(TO_CHAR(LAST_ANALYZED, 'YYYYMMDDHH24MISS')), 0), NVL(INITIAL_EXTENT, -1), NVL(NEXT_EXTENT, -1), NVL(MAX_EXTENTS, -1), NVL(DEGREE, '-1'), NVL(PCT_FREE, -1), NVL(INI_TRANS, -1), NVL(MAX_TRANS, -1), NVL(GLOBAL_STATS, ' '), NVL(TEMPORARY, ' ') FROM DBA_INDEXES WHERE OWNER = 'SAPSR3' AND INDEX_TYPE <> 'CLUSTER' AND INDEX_TYPE <> 'LOB' AND TABLE_OWNER = 'SAPSR3' AND TABLE_NAME = 'TODIR' AND TEMPORARY <> 'Y' ORDER BY OWNER, TABLE_NAME, INDEX_NAME'
ORA-01024: invalid datatype in OCI call

BR0806I End of BRCONNECT processing: cfpvnkbj.sta 2024-11-26 06:28:24
BR0280I BRCONNECT time stamp: 2024-11-26 06:28:24
BR0804I BRCONNECT terminated with errors
SAPup> Process with PID 5576 terminated with status 3 at 20241126062824!

DBCONNCHK:

4 ETW000 F:\usr\sap\prd\sum\abap\exe\R3trans.EXE version 6.26 (release 754 - 01.08.24 - 14:07:06).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 25.11.2024 - 08:58:08
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: F:\usr\sap\prd\sum\abap\exe\R3trans.EXE -x -w F:\usr\sap\prd\sum\abap\log\DBCONNCHKEXE.LOG
4 ETW000 trace at level 1 opened for a given file pointer
4 ETW000 [ dev trc,00000] Mon Nov 25 08:58:08 2024
4 ETW000 [ dev trc,00000] Loading DB library 'dboraslib.dll' ...
4 ETW000 [ dev trc,00000] Library 'dboraslib.dll' loaded
4 ETW000 [ dev trc,00000] Version of 'dboraslib.dll' is "754.00", patchlevel (0.400)
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): DBSL supports extended connect protocol
4 ETW000 ==> connect info for default DB will be read from ssfs
4 ETW000 [ dev trc,00000] array_buf_size not initialized. Setting standard size.
4 ETW000 [ dev trc,00000] array_buf_size = 130000
4 ETW000 [ dev trc,00000] Statement Cache (size=250) created
4 ETW000 [ dev trc,00000] Oracle client version: 12.1.0.2.0, (dbsl 754 200323, UNICODE[2], LE)
4 ETW000 [ dev trc,00000] Detailed Oracle client (patch) info not available.
4 ETW000 [ dev trc,00000] New environment handle env=2447718B670 for nls=0, con=0 created
4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'
4 ETW000 [ dev trc,00000] local client OS environment: NLS_LANG = 'AMERICAN_AMERICA.UTF8'
4 ETW000 [ dev trc,00000] NLS_NCHAR not set
4 ETW000 [ dev trc,00000] Connecting as SAPSR3/<pwd>@PRD on connection 0 (nls 0) ... (dbsl 754 200323, UNICODE[2], LE)
4 ETW000 [ dev trc,00000] OCIHandleAlloc(con=0, env=2447718B670): New service svc=24477151908 created, rc=0
4 ETW000 [ dev trc,00000] OCIServerAttach(con=0, svc=24477151908): New server hdl. srv=24477196B00 attached to 'PRD'
4 ETW000 [ dev trc,00000] OCISessionBegin(con=0, svc=24477151908, srv=24477196B00='PRD'): start session usr=244771AA430='SAPSR3', rc=0
4 ETW000 [ dev trc,00000] Now 'SAPSR3/<pwd>@PRD' is connected: con=0, nls=0, session=100, time='2024-11-25 08:58:08'
4 ETW000 [ dev trc,00000] DB instance PRD is running on SAPPRDX with ORACLE version 12.1.0.2.0 since NOV 24, 2024, 13:37:27.
4 ETW000 [ dev trc,00000] con=0, V$NLS_PARAMETERS: NLS_LANG=AMERICAN_AMERICA.UTF8, NLS_NCHAR=UTF8
4 ETW000 [ dev trc,00000] con CharacterSet (DB) NCharSet svchp srvhp usrhp nls TNS
4 ETW000 [ dev trc,00000] 0 UTF8 UTF8 24477151908 24477196B00 244771AA430 0 PRD
4 ETW000 [ dev trc,00000] nls CharacterSet (Env) NCharSet envhp errhp er2hp bathp
4 ETW000 [ dev trc,00000] 0 UTF16 AL16UTF16 2447718B670 24477149490 2447713D420 2447714FAF0
4 ETW000 [ dev trc,00000] Connection 0 opened (DBSL handle 0)
4 ETW000 [ dev trc,00000] -->DbSlControl(con=0,cmd=43=DBSL_CMD_SAPRELEASE_SET) -> basis rel.='700'=700)
4 ETW000 Connected to database.
4 ETW000 [ dev trc,00000] Disconnecting from ALL connections:
4 ETW000 [ dev trc,00000] Disconnecting con=0
4 ETW000 [ dev trc,00000] OCISessionEnd(con=0, svc=24477151908, srv=24477196B00='PRD'): Close session usr=244771AA430, rc=0
4 ETW000 [ dev trc,00000] OCIServerDetach(stale1 con=0, svc=24477151908, srv=24477196B00='PRD') successfully detached
4 ETW000 [ dev trc,00000] OCIHandleFree(con=0, svc=24477151908): Server handle srv=24477196B00 freed
4 ETW000 [ dev trc,00000] OCIHandleFree(con=0): Service hdl. svc=24477151908 freed.
4 ETW000 [ dev trc,00000] Disconnected from connection 0
4 ETW000 [ dev trc,00000] statistics db_con_commit (com_total=0, com_tx=0)
4 ETW000 [ dev trc,00000] statistics db_con_rollback (roll_total=0, roll_tx=0)
4 ETW000 Disconnected from database.
4 ETW000 End of Transport (0000).
4 ETW000 date&time: 25.11.2024 - 08:58:08

[S_Sriram]

Hi is it possible do the full system restart and then try the same upgrade phase.