Error tp failed with return code 232 while doing upgrade from EHP4 TO EHP7

[former_member209962]

Hi Friends,

We are doing upgarde of our ecc6 system from EHP4 to EHP7 at Extraction stage we are gettinn an error as

Severe error(s) occured in phase PREP_INPUT/SQLDB_LIST_AVERS!

Last error code set: tp failed with return code 232, check D:\usr\sap\trans\SUM\abap\log\TPSQLSTD.OUT

operating system is WIN 2008

Database is Oracle

Pleae find attached TPSGLSTD.OUT log for your reference.

Thanks

Tabrayz

TPSQLSTD.OUT.txt.zip

[paul_power · Accepted solution]

Hi Tabrayz,

I see in the attached log

*** ERROR => Connect via SAPUSER not supported for kernel >= 740.                  30  0.009450

For the kernel release 7.40 the SSFS connection method is necessary.

Please follow the description in the notes:
#1622837 - New connect method of AS ABAP to Oracle via SSFS
#1611877   Support for ABAP SSFS during database connect

and configure the SSFS connection.
Afterwards the error message should be disappeared.

regards,

Paul

[former_member209962 · Accepted solution]

Hi Paul,

We followed note 1622837 and created additional directories  gave permissions etc..

but still same error r3trans -d is fine

C:\Users\siddm>R3trans -d
This is R3trans version 6.23 (release 720 - 31.10.12 - 20:12:06).
unicode enabled version
R3trans=>sapparam(1c): No Profile used.
R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
R3trans finished (0000).

Thanks

Tabrayz

[Former Member · Accepted solution]

Hi,

What is the error log.

Thanks

Rishi Abrol

[Former Member · Accepted solution]

Hi,

Please go through the below note.

1860519 - SAP fails to connect to the database

Thanks

Rishi Abrol

[Reagan · Accepted solution]

You problem can be fixed if you update the Oracle Instant Client.

Bear in mind that the from EH6 onwards you need to have a higher version of OS and DB.

As you have Oracle you need to have 11G version for EHP6 onwards.

If the database is already on 11G then update the client.

Follow what I've told you yesterday.

Note 998004 - Update the Oracle Instant Client on Windows

Regards

RB

[former_member209962 · Accepted solution]

sorry my mistake i forgot Environment variable: rsdb_ssfs_connect 1

after setting Environment variable: rsdb_ssfs_connect 1  issue is solved

now its fine

Thanks you Pual and others too.

Thanks

Tabrayz

[Reagan]

Hello

TRACE-INFO: 14:  [     dev trc,00000]  Oracle client version: 10.2.0.4.0, (dbsl 740 190413, UNICODE[2])                 6969  0.009397
TRACE-INFO: 15:  [     dev trc,00000]  Detailed Oracle client (patch) info not available.                                 23  0.009420
TRACE-INFO: 16:  [    D:/depot,00000]  *** ERROR => Connect via SAPUSER not supported for kernel >= 740.                  30  0.009450
TRACE-INFO: 17:  [     dev trc,00000]     Only Secure Connect method possible.                                            17  0.009467
TRACE-INFO: 18:  [     dev trc,00000]     DbSlConnect(con=-1) -> orc=0, 15=DBSL_ERR_UNSUPPORTED                           25  0.009492

Two things :

1 - Update the Oracle Instant Client to 11G version

2 - Set up SSFS like Paul mentioned.

Regards

RB

[Former Member]

Hi,

Connect via SAPUSER not supported for kernel >= 740

Please configure SSFS

Note 1622837 - Secure connection of AS ABAP to Oracle via SSFS

thanks

Rishi abrol