SAP Knowledge Base Article - Preview

2504627 - BRCONNECT does not accept 'SYSTEM' password in SUM phase DBQUERY_PRE or TABSPC_PREP

Symptom

  • Scenario 1: You are performing an upgrade using the Software Update Manager (SUM), when you receive the following error in the phase PREP_INPUT/DBQUERY_PRE
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: You are performing an upgrade using SUM and receive the following error in the phase PREP_SPACECALC/TABSPC_PREP
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 , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.