cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-01458: invalid length inside variable character string

Former Member
0 Kudos

Hello colleagues,

In BW system when execute brconnect (brconnect -u / -c -f stats -t SAPBWP."/BIC/B0000121000./BIC/B00001210000000000054" -f allsel,collect -c 10 &)

Show this error,

[1] 14484
sv944:orabwp 2> BR0801I BRCONNECT 7.20 (30)
BR0805I Start of BRCONNECT processing: cemjknlb.sta 2013-10-23 16.07.15
BR0484I BRCONNECT log file: /oracle/BWP/sapcheck/cemjknlb.sta

BR0280I BRCONNECT time stamp: 2013-10-23 16.07.19
BR0813I Schema owner found in database BWP: SAPBWP*
BR0280I BRCONNECT time stamp: 2013-10-23 16.07.19
BR0301E SQL error -1458 at location BrTabListGet-1, SQL statement:
'OPEN curs_52a 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 = 'SAPBWP' AND TABLE_NAME = '/BIC/B0000121000./BIC/B00001210000000000054' AND TEMPORARY <> 'Y' ORDER BY OWNER, TABLE_NAME'
ORA-01458: invalid length inside variable character string

BR0806I End of BRCONNECT processing: cemjknlb.sta 2013-10-23 16.07.19
BR0280I BRCONNECT time stamp: 2013-10-23 16.07.19
BR0804I BRCONNECT terminated with errors

[1]   Exit 3               brconnect -u / -c -f stats -t  ...

Please help me!! Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

karthikeyan_natarajan4
Active Contributor
0 Kudos

Hi Victor,

please paste the value of DB_BLOCK_SIZE from initSID.ora file.

regards

kartik

Former Member
0 Kudos

Hi Karthikeyan, my SAP version is SAP EHP 1 for SAP NetWeaver 7.0.

Thanks

karthikeyan_natarajan4
Active Contributor
0 Kudos

Hi Victor,

Please browse to this location <oracle_home>/database, you will find init<DBSID>.SAP file, please paste the content of it.

regards

kartik

Former Member
0 Kudos

Hi Kar,

The home is ORACLE_HOME=/oracle/SID/112_64 I dont find init<DBSID>.SAP file

Thanks

Former Member
0 Kudos

Hi,

What he is asking is in /oracle/SID/112_64/dbs/

Please try to Increase the buffer size .Please use the below note to increase the Buffer Pool: DB_BLOCK_BUFFERS

Note 789011 - FAQ: Oracle memory areas

Thanks

Rishi Abrol

hasanajsh
Active Contributor
0 Kudos

Hello,

Could you check the following note:

Note 52913 - SAPDBA: ORA-01458 after recovery