Symptom
- Scenario 1: While performing an upgrade using the Software Update Manager (SUM),the upgrade stops on error in the phase PREP_INPUT/DBQUERY_PRE
- The following information is found in the logs:
SAPupConsole.log:
>> 2017/07/14 19:27:36 START OF PHASE PREP_INPUT/DBQUERY_PRE
=========== Required System Passwords ===========
ERROR: Password for 'SYSTEM' does not work, please reenter.
Enter the password for DB user "SYSTEM"
DB PASSWORD: **********
ERROR: ERROR: Password for 'SYSTEM' does not work, please reenter.
<< 2017/07/14 19:58:23 END OF PHASE PREP_INPUT/DBQUERY_PRE
CHKSYSPWD.SAV:
SAPup> Starting subprocess with PID 13768 in phase 'DBQUERY_PRE' at 20170728004432
*CENV: BR_ISP=1
ENV: DIR_LIBRARY=/usr/sap/<SID>/SUM/abap/exe
ENV: LD_LIBRARY_PATH=/usr/sap/<SID>/SUM/abap/exe
ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
ENV: ORACLE_BASE=/oracle
*DBENV:ORACLE_HOME=/usr/sap/<SID>/SUM/abap/tmp
ENV: ORACLE_PSRV=<SID>
*DBENV: ORACLE_SID=<SID>
...
PWD: /usr/sap/<SID>/SUM/abap/tmp
EXECUTING /usr/sap/<SID>/SUM/abap/exe/brconnect -u -c -f dbstate -RDB
BR0801I BRCONNECT 7.20 (17)
BR0262I Enter database user name[/password]:
BR0280I BRCONNECT time stamp: 2017-07-28 00.44.32
BR0301E SQL error -12154 at location db_connect-2, SQL statement:
'CONNECT SYSTEM/*******@<SID>'
ORA-12154: TNS:could not resolve the connect identifier specified
BR0310E Connect to database instance <SID> failed
BR0280I BRCONNECT time stamp: 2017-07-28 00.44.32
BR0804I
BRCONNECT terminated with errors
SAPup> Process with PID 13768 terminated with status 3 at 20170728004432!
- Scenario 2: While performing an upgrade using SUM, the upgrade stops in phase PREP_SPACECALC/TABSPC_PREP
- The following errors can be found in the logs
TABSPCP.LOG
4 ETQ276 Executing SQL-script "TABSPC_PREP.XQL"
3 ETQ120 20180620101813: PID 25373 execute '~/bin_nuc/SAPuptool execdb ../var/TABSPC_PREP.XQL', output written to '../<SID>/SUM/abap/log/SQLSTMTSTD.OUT'.
3 ETQ123 20180620101821: PID 25373 exited with status 0 (time 8.00 real)
3 ETQ399 Reading selections from 'TABSPC_PREP.XUT'.
4 ETQ399 Read 1442 entries for table 'EXTABLES'.
4 ETQ291 Database operation "TABLE-EXISTANCE-TEST" completed successfully
4 ETQ399 Running update statistics for imported tables...
3 ETQ121 20180620101821: PID 25429 execute '~/exe/brconnect -u -p ~/tmp/SPACESTAT.LST -c -f stats -f allsel,collect,space -p 8 -r 16 -RDB' in background, output written to '../<SID>/SUM/abap/log/ORA_SPACESTAT.LOG'.
3WETQ123 20180620101822: PID 25429 exited with status 3 (time 1.00 real)
4 ETQ399 20180620101822: WAITED for 1 processes to finish, 0 aborted.
1EETQ399 Last error code set is: brconnect exited with 3
1EETQ204 Upgrade phase "TABSPC_PREP" aborted with severe errors ("20180620101822")
ORA_SPACESTAT.log
ENV: ORACLE_BASE=/oracle
*DBENV: ORACLE_HOME=../<SID>/SUM/abap/tmp
ENV: ORACLE_PSRV=<SID>
...
PWD: ../<SID>/SUM/abap/tmp
EXECUTING ../<SID>/SUM/abap/exe/brconnect -u -p ../<SID>/SUM/abap/tmp/SPACESTAT.LST -c -f stats -f allsel,collect,space -p 8 -r 16 -RDB
BR0801I BRCONNECT 7.40 (30)
BR0280I BRCONNECT time stamp: 2018-06-20 10:18:22
BR0262I Enter database user name[/password]:
BR0157E Value 'SYSTEM/1;1;;;?2?30?*8536???19:01o86;6<7>896183:sOm9<091>Hg3:0?:8>1;83=34019;L>4+96=;87Sl9:t1=35' of option '-u' longer than 61 characters
BR0806I End of BRCONNECT processing: ceytaiio.log 2018-06-20 10:18:22
BR0280I BRCONNECT time stamp: 2018-06-20 10:18:22
BR0804I BRCONNECT terminated with errors
SAPup> Process with PID 25429 terminated with status 3 at 20180620101822!
Read more...
Product
SAP ERP 6.0
Keywords
BRTOOL option '-u' longer than 61 characters, location db_connect-2, DBQUERY_PRE, Connect to database instance <SID> failed , KBA , BC-UPG-TLS-TLA , Upgrade tools for ABAP , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview