Rashed's Way2SAPBASIS.com

Hello Team,
I am installing ECC 6.0 EhP 6 on Win Server 2016.
While installing I am getting the below error during Updating the database statistics.

Error
An error occurred while processing option SAP Business Suite 7i 2011 > Enhancement Package 6 for SAP ERP 6.0 > SAP Application Server ABAP > Oracle > Central System > Central System (Last error reported by the step: Process call 'E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\brconnect.exe -u / -c -o summary -f stats -o SAPSR3 -t all -p 2' exits with error code 3. For details see log file(s) brconnect.log). You can now:
• Choose Retry
to repeat the current step.
• Choose Log Files
to get more information about the error.
• Stop the option and continue later.

Log files are written to C:\Program Files/sapinst_instdir/BS2011/ERP606/AS-ABAP/ORA/CENTRAL/.


Below is the brconnect.log file summery

BR0801I BRCONNECT 7.20 (42)
BR0805I Start of BRCONNECT processing: cfpbtyoh.sta 2024-08-14 09.13.55
BR0484I BRCONNECT log file: E:\oracle\DEV\sapcheck\cfpbtyoh.sta
BR0280I BRCONNECT time stamp: 2024-08-14 09.13.56
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 ('DEV', '20240814091355', 'Update optimizer statistics', '0000000000', '20240814091356', 'E:\oracle\DEV\sapcheck\cfpbtyoh.sta', 'STARTED', '20240814091355', ' ', '0000', ' ')'
ORA-01024: invalid datatype in OCI call
BR0324W Insertion of database log header failed

BR0280I BRCONNECT time stamp: 2024-08-14 09.13.57
BR0813I Schema owner found in database DEV: SAPSR3*
BR0280I BRCONNECT time stamp: 2024-08-14 09.13.57
BR0301E SQL error -1024 at location BrTabListGet-5, SQL statement:
'OPEN curs_52 CURSOR FOR'
'SELECT OWNER, TABLE_NAME, NVL(IOT_NAME, ' '), NVL(TABLESPACE_NAME, ' '), PARTITIONED, NVL(IOT_TYPE, ' '), NVL(NUM_ROWS, -1), NVL(BLOCKS, -1), NVL(EMPTY_BLOCKS, -1), NVL(AVG_SPACE, -1), NVL(CHAIN_CNT, -1), NVL(AVG_ROW_LEN, -1), NVL(AVG_SPACE_FREELIST_BLOCKS, -1), NVL(NUM_FREELIST_BLOCKS, -1), NVL(SAMPLE_SIZE, -1), NVL(TO_NUMBER(TO_CHAR(LAST_ANALYZED, 'YYYYMMDDHH24MISS')), 0), NVL(NEXT_EXTENT, -1), NVL(MAX_EXTENTS, -1), NVL(STATUS, ' '), NVL(LOGGING, ' '), NVL(MONITORING, 'NO'), NVL(DEGREE, '-1'), NVL(ROW_MOVEMENT, ' '), NVL(NESTED, ' '), NVL(COMPRESSION, ' '), NVL(COMPRESS_FOR, ' '), NVL(PCT_FREE, -1), NVL(PCT_USED, -1), NVL(INI_TRANS, -1), NVL(MAX_TRANS, -1), NVL(GLOBAL_STATS, ' '), NVL(TEMPORARY, ' '), NVL(SEGMENT_CREATED, ' ') FROM DBA_TABLES WHERE (OWNER LIKE 'SAPSR3' OR OWNER IN (' ', ' ')) AND (TABLE_NAME LIKE '%' OR IOT_NAME LIKE '%') AND TEMPORARY <> 'Y' ORDER BY OWNER, TABLE_NAME'
ORA-01024: invalid datatype in OCI call

BR0806I End of BRCONNECT processing: cfpbtyoh.sta 2024-08-14 09.13.57
BR0280I BRCONNECT time stamp: 2024-08-14 09.13.57
BR0804I BRCONNECT terminated with errors


I got a SAP note to resolve the error, but not sure how to implement it
3332611 - ORA-01024: invalid datatype in OCI call - BR*Tools (https://me.sap.com/notes/0003332611)

System Details
Win Server 2016
Host Name: server2016
Kernel 7.22
SWPM 70SWPM10SP35_7
Core i5 8 Gen, 6GB RAM on VmWare 17.5


Your kind help is required.
Thanks,
Sumanta Majumdar

Hello Sumanta,

Check SAP NOTE 3332611, it has a solution.

Regards
Rashed

Thank you Sir for your immediate reply.

~ Sumanta Majumdar