cancel
Showing results for 
Search instead for 
Did you mean: 

Severe error(s) occurred in phase PREP_INPUT/SUMCHK!

Former Member
0 Kudos

Hi ,

while performing the EHP7 upgrade during the extraction phase I faced below error.

Severe error(s) occurred in phase PREP_INPUT/SUMCHK!

Last error code set: tp failed with return code 232, check G:\SUM\abap\log\TPSQLSTD.OUT

I have tried implementing the below parameter disp+work is stopped

Env variable rsdb_ssfs_connect = 1

rsdb/ssfs_connect = 0

I have attached the TPSQLSTD log file below,Kindly share your inputs to fix above error.

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member182657
Active Contributor
0 Kudos

Hi,

Try to configure SSFS as per doc

Regards,

Gaurav

former_member182657
Active Contributor
0 Kudos

Hi,


switch back to 721 kernel DISP+work is stopped , below was the trans.log details

Please share complete trans.log file for analysis.

Thanks,

Gaurav

Former Member
0 Kudos

Hi Gaurav,

I have tired above suggested option but it gives me error as shown below .

4 ETW000  [    D:/depot,00000] *** ERROR => Connect via SAPUSER not supported for kernel >= 740.         34  0.042353

4 ETW000  [     dev trc,00000]     Only Secure Connect method possible.                                   16  0.042369

4 ETW000  [     dev trc,00000]     DbSlConnect(con=-1) -> orc=0, 15=DBSL_ERR_UNSUPPORTED                  40  0.042409

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET)                        30  0.042439

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET)                        25  0.042464

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-

divyanshu_srivastava3
Active Contributor
0 Kudos

Hi Mohan,

If you want to use older version.

1905775 - SSFS connection is not working

For newer.

1904826 - Upgrade error "Connect via SAPUSER not supported for kernel >= 740"


Add env variable and parameter to profile.


Divyanshu

former_member182657
Active Contributor
0 Kudos

Hi Krishan,

Have a close look with logs


SAPup> Starting subprocess in phase 'SUMCHK' at 20140727092403

    ENV: DBMS_TYPE=ora

    ENV: NLS_LANG=AMERICAN_AMERICA.UTF8

    ENV: ORACLE_HOME=C:\oracle\QEC\11203

    ENV: ORACLE_SID=QEC

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

    ENV: PATH=D:\usr\sap\QEC\DVEBMGS00\exe;C:\oracle\QEC\11203\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\usr\sap\QEC\SYS\exe\uc\NTAMD64

    ENV: SAPDATA_HOME=F:\ORACLE\QEC

    ENV: SAPSYSTEMNAME=QEC

    ENV: dbs_ora_schema=SAPSR3

    ENV: dbs_ora_tnsname=QEC

    ENV: rsdb_ssfs_connect=1

EXECUTING D:\usr\sap\QEC\DVEBMGS00\exe\tp.EXE  "pf=J:\SUM\abap\var\DEFAULT.TPP" execdbscript QEC -x ..\var\SMODILOGCHECK.XQL

This is D:\usr\sap\QEC\DVEBMGS00\exe\tp.EXE version 380.04.07 (release 720, unicode enabled)

TRACE-INFO: 1:  [     dev trc,00000]  Sun Jul 27 09:24:03 2014                                                         2967  0.002967

TRACE-INFO: 2:  [     dev trc,00000]  DlLoadLib success: LoadLibrary("dboraslib.dll"), hdl 0, addr 000007FEE71F0000

TRACE-INFO: 3:                                                                                                           19  0.002986

TRACE-INFO: 4:  [     dev trc,00000]      using "D:\usr\sap\QEC\DVEBMGS00\exe\dboraslib.dll"                              8  0.002994

TRACE-INFO: 5:  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1       350  0.003344

TRACE-INFO: 6:  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK)                              13  0.003357

TRACE-INFO: 7:  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET)                                11  0.003368

TRACE-INFO: 8:  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET)                                12  0.003380

TRACE-INFO: 9:  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=74=DBSL_CMD_CON_INFO_EXT_SUPPORT) -> rc=0=DBSL_ERR_OK, con_vers=0

TRACE-INFO: 10:                                                                                                           36  0.003416

As you are using kernel release 720.Parameter rsdb_ssfs_connect =1 will play role if you'll use kernel release higher than current.For use of SSFS try to upgrade kernel with the latest 740 or 741 and retry the phase again.

Regards,

Gaurav

Former Member
0 Kudos

Hi Gaurav,

I tried updating the 740 kernel  D:\usr\sap\SID\SYS\exe\uc\NTAMD64 MMC shows red .

I switch back to 721 kernel DISP+work is stopped , below was the trans.log details

4 ETW000  [     dev trc,00000]  read_ssfs_record(): deregister callback ssfs_dbi_trace                    20  0.003100

4 ETW000  [dbcon.c     ,00000]  *** ERROR => Connect to R/3 failed. USERID and/or PASSWD could not be retrieved from SSFS

4 ETW000                                                                                                  35  0.003135

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET)                        31  0.003166

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET)                        22  0.003188

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO)                     22  0.003210

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET)                    36  0.003246

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION)                  25  0.003271

4 ETW000  [     dev trc,00000]                 -> 'OCI_10201_SHARE, '                                     32  0.003303

2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = 'QEC'"

former_member182657
Active Contributor
0 Kudos

Share the current value for parameter rsdb_ssfs_connect. If you opt 740 then value of the parameter should be set to 1.


Reagan
Advisor
Advisor
0 Kudos

Hello

Do not put kernel 740 for the main system.

You need to setup SSFS by following the procedure mentioned in this SAP note

1639578 - SSFS as password storage for primary database connect

Once done restart the system and start the upgrade.

Regards

RB

Former Member
0 Kudos

Hi Regan,

I followed the above sap note 1639578 but still have issue can't start the main system .

disp+work is stopped below attached was the trans.log

former_member182657
Active Contributor
0 Kudos

Hi Mohan,

Under logs error


ORA-00942: table or view does not exist 

is happening on .For the resolution please follow SAP Note  662644 - Composite SAP Note: ORA-00942


Regards,

Gaurav

former_member182657
Active Contributor
0 Kudos

Hi Mohan,


ORA-00942: table or view does not exist and rc=103=DBSL_ERR_DBOBJECT_UNKNOWN

Issue related with OPS$ users.For this please refer SAP Note  400241 - Problems with ops$ or sapr3 connect to Oracle

In addition try to update kernel 721 with the latest patch available.

Regards,

Gaurav

Reagan
Advisor
Advisor
0 Kudos

Hello Krishna


4 ETW000  [     dev trc,00000]  Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'

4 ETW000                                                                                                  31  0.078499

4 ETW000  [     dev trc,00000]  charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE                      20  0.078519

4 ETW000  [     dev trc,00000]  Connecting as SYSTEM/<pwd>@QEC on connection 0 (nls 0) ... (dbsl 721 140314, UNICODE[2])

Why is your SAP system trying to connect the database with the SYSTEM user ?

It should be connecting with the schema user which is SAPSR3 for your system.

Again, setup the SSFS as suggested in the SAP note.

Regards

RB

Former Member
0 Kudos

Hi Regan,

I have run the below command again,It worked  

rsecssfx put DB_CONNECT/DEFAULT_DB_USER  SAPSR3 -plain

rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD  Password

Thanks everyone for your inputs

divyanshu_srivastava3
Active Contributor
0 Kudos

Hi Krishna,

Can you execute R3trans -d and share trans.log file.

Also, are you using SSFS?

Can you share more traces from log and temp folder.

Divyanshu

Former Member
0 Kudos

Hi Divyanshu,

As requested I have attached the trans.log below .

divyanshu_srivastava3
Active Contributor
0 Kudos

This is fine, checked

Can you share other logs too.

Divyanshu