R3trans authentication failed after interrupted system copy via SWPM

[former_member629252]

Cannot start the ABAP instance. Executing R3trans -d and seeing trans.log it says SQL10 authentication failed. Could it be because when I ran the system copy and defined parameters in SWPM, I defined the schema to be SAPSMD instead of the source SCHEMA which is SAPSMP. What do you think is the issue? The system copy was interrupted a few minutes after SWPM executed the actual system copy (after defining the parameters).

[Johan_sapbasis]

Hi Erik,

Loading SQLDBC client runtime (pid=10917)...

4 ETW000 [ dev trc,00000] SQLDBC Module : /usr/sap/EEP/hdbclient/libSQLDBCHDB.so

4 ETW000 [ dev trc,00000] SQLDBC Runtime : libSQLDBCHDB 2.15.019.1671632641

4 ETW000 [ dev trc,00000] SQLDBC client runtime is 2.15.019.1671632641

4 ETW000 [ dev trc,00000] Try to connect via secure store (DEFAULT) on connection 0 ...

4 ETW000 [ dev trc,00000] connect property [APPLICATION = ABAP:EEP]

4 ETW000 [ dev trc,00000] connect property [APPLICATIONVERSION = 773 PL 200]

4 ETW000 [ dev trc,00000] no connection data found for key (DEFAULT) in HANA secure store

4 ETW000 [ dev trc,00000] Try to connect via environment (localhost:7878) on connection 0 ...

4 ETW000 [dbhdbsql.cpp,00000] *** ERROR => Connect to database failed, rc=1, rcSQL=-10709

4 ETW000 [ dev trc,00000] SQLCODE : -10709

4 ETW000 [ dev trc,00000] SQLERRTEXT : Connection failed (RTE:[89006] System call 'connect' failed, rc=111:Connection refused ([::1]:40404 \

4 ETW000 [ dev trc,00000] -> localhost:7878))

1. Make sure after the interrupted copy that your kernel directories are completed and contains the same versions of libraries and all necessary libraries. If you see inconsistencies. You may need to have to re-extract your kernel in the kernel directories.

2. Make sure your HANA Client is correct version, correct permissions and extracted correctly for location /usr/sap/EEP/hdbclient.

3. Also when viewing log of R3trans it is trying to connect to localhost, is your APP and HANA DB on same host? I doubt it which means this is part of your problem. Should have hostname/I.P. of your HANA database server.

4. Here is the key in the in the log:

no connection data found for key (DEFAULT) in HANA secure store

Use the following SAP notes please.

3093786 - Key DEFAULT is not found in SAP HANA user store

2250144 - FAQ: SAP HANA Secure User Store

During configuration this may become relevant.

2460799 - no connection data found for key (DEFAULT) in HANA secure store in wp traces but R3trans -d works

Kind Regards,

Johan. manually.

[former_member447016]

translog3.txt

[alichtenau]

Hi Redjie,

can you please attach the trans.log file?

Many thanks and best regards,
Andreas