SAP Knowledge Base Article - Preview

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

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.