cancel
Showing results for 
Search instead for 
Did you mean: 

Severe error(s) occurred in phase MAIN_SHDRUN/GEN_TABSIZEFILE_CP2SHD! Last error code set: brconnect exited with 3

Former Member
0 Kudos

Dear Experts,

I'm upgrading SAP SOLMAN 7.1 SPS stack to latest 14.

During Phase Preprocessing>ABAP>MAIN_SHDRUN_GEN_TABLESIZEFILE_CP2SHD SUM is throwing below error

Last error code set :

Severe error(s) occurred in phase MAIN_SHDRUN/GEN_TABSIZEFILE_CP2SHD! Last error code set: brconnect exited with 3

tail: ORA_COLLSPCSTAT.SAV

SAPup> Starting subprocess in phase 'GEN_TABSIZEFILE_CP2SHD' at 20160316134212

    ENV: DBMS_TYPE=ora

    ENV: JAVA_HOME=E:\usr\sap\SMD\DVEBMGS00\exe\sapjvm_4

    ENV: NLS_LANG=AMERICAN_AMERICA.UTF8

    ENV: ORACLE_HOME=D:\Oracle\SMD\1124

    ENV: ORACLE_SID=SMD

    ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC

    ENV: PATH=U:\SUM\abap\exe;D:\Oracle\SMD\1124\bin;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\McAfee\MOVE AV Client\;E:\usr\sap\SMD\SYS\exe\uc\NTAMD64

    ENV: SAPCHECK=U:\SUM\abap\tmp

    ENV: SAPDATA_HOME=U:\SUM\abap\tmp

    ENV: SAPSYSTEMNAME=SMD

    ENV: dbs_ora_schema=SAPSR3

    ENV: dbs_ora_tnsname=SMD

    ENV: rsdb_ssfs_connect=1

    PWD: U:\SUM\abap\tmp

EXECUTING U:\SUM\abap\exe\brconnect.EXE -u -p U:\SUM\abap\tmp\SPACESTAT.LST -c -f stats -f allsel,collect,space -p 10 -r 16 -RDB

BR0801I BRCONNECT 7.20 (42)

BR0280I BRCONNECT time stamp: 2016-03-16 13.42.12

BR0262I Enter database user name[/password]:

BR0805I Start of BRCONNECT processing: cessusxg.sta 2016-03-16 13.42.12

BR0484I BRCONNECT log file: U:\SUM\abap\tmp\cessusxg.sta

BR0280I BRCONNECT time stamp: 2016-03-16 13.42.13

BR0813I Schema owners found in database SMD: SAPSR3*, SAPSR3DB%, SAPSR3SHD+

BR0280I BRCONNECT time stamp: 2016-03-16 13.42.46

BR0301E SQL error -3113 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 'SAP%' OR OWNER IN (' ', ' ')) AND (TABLE_NAME LIKE '%' OR IOT_NAME LIKE '%') AND TEMPORARY <> 'Y' ORDER BY OWNER, TABLE_NAME'

ORA-03113: end-of-file on communication channel

Process ID: 8576

Session ID: 352 Serial number: 12565

BR0280I BRCONNECT time stamp: 2016-03-16 13.42.46

BR0301W SQL error -3114 at location db_commit-1, SQL statement:

'COMMIT WORK'

ORA-03114: not connected to ORACLE

BR0327W Disconnect from database instance SMD failed

BR0806I End of BRCONNECT processing: cessusxg.sta 2016-03-16 13.42.46

BR0280I BRCONNECT time stamp: 2016-03-16 13.42.46

BR0804I BRCONNECT terminated with errors

SAPup> Process with PID 4228 terminated with status 3 at 20160316134246!

tail: GENCP2SHDSIZE

4 ETQ290 Starting database operation "TABLE-EXISTANCE-TEST"

2 ETQ399 Requested task ID is 'CHECK_TABLEEXISTS', to be executed in parallel.

3WETQ399 Statement has selections, parallel execution disabled.

3 ETQ399 'LIST': Distributed 2 statements.

3 ETQ399 Generated TQL file 'GEN_TABSIZEFILE_CP2SHD.XQL' with 1 SQL statements, log file 'GEN_TABSIZEFILE_CP2SHD.XUT'.

4 ETQ276 Executing SQL-script "GEN_TABSIZEFILE_CP2SHD.XQL"

3 ETQ120 20160316134211: PID 9108 execute 'U:\SUM\abap\bin\SAPuptool execdb ..\var\GEN_TABSIZEFILE_CP2SHD.XQL', output written to 'U:\SUM\abap\log\SQLSTMTSTD.OUT'.

3 ETQ123 20160316134212: PID 9108 exited with status 0 (time 0.000 real)

3 ETQ399 Reading selections from 'GEN_TABSIZEFILE_CP2SHD.XUT'.

4 ETQ399 Read 2 entries for table 'EXTABLES'.

4 ETQ291 Database operation "TABLE-EXISTANCE-TEST" completed successfully

3 ETQ121 20160316134212: PID 4228 execute 'U:\SUM\abap\exe\brconnect -u -p U:\SUM\abap\tmp\SPACESTAT.LST -c -f stats -f allsel,collect,space -p 10 -r 16 -RDB' in background, output written to 'U:\SUM\abap\log\ORA_COLLSPCSTAT.LOG'.

3WETQ123 20160316134246: PID 4228 exited with status 3 (time 0.000 real)

4 ETQ399 20160316134246: WAITED for 1 processes to finish, 0 aborted.

1EETQ399 Last error code set is: brconnect exited with 3

1EETQ204 Upgrade phase "GEN_TABSIZEFILE_CP2SHD" aborted with severe errors ("20160316134246")

Please suggest the solution. I m stucked in this step.

Regards,

Qazi

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member185239
Active Contributor
0 Kudos

Hi Qazi,

Connection between the oracle database is getting lost.

Kindly check the below error

ORA-03113: end-of-file on communication channel

Process ID: 8576

Session ID: 352 Serial number: 12565

BR0280I BRCONNECT time stamp: 2016-03-16 13.42.46

BR0301W SQL error -3114 at location db_commit-1, SQL statement:

'COMMIT WORK'

ORA-03114: not connected to ORACLE

BR0327W Disconnect from database instance SMD failed

BR0806I End of BRCONNECT processing: cessusxg.sta 2016-03-16 13.42.46

BR0280I BRCONNECT time stamp: 2016-03-16 13.42.46

BR0804I BRCONNECT terminated with errors

SAPup> Process with PID 4228 terminated with status 3 at 20160316134246!

There might be some network issue.

With Regards

Ashutosh Chaturvedi

Former Member
0 Kudos

Hello,

Please help on below

Matt_Fraser
Active Contributor
0 Kudos

It isn't necessary to spam 4 extra discussion threads to try to get people over to your new question.