R3load -testconnection failed in import abap for EHP7-HANA

[Former Member]

Hi,

Iam facing an error of r3load -testconnection failed in import abap step.The r3load is not able to communicate with my DB.

Please find below the error message and log.We are using HANA db path 68 & its an distributed installation(Separate HANA box, Sepa APP box) SAP ERP6.0 EHP7

R3loadexe.log

sapparam: sapargv(argc, argv) has not been called!

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

/usr/sap/Q10/SYS/exe/uc/linuxx86_64/R3load: START OF LOG: 20131105155710

/usr/sap/Q10/SYS/exe/uc/linuxx86_64/R3load: sccsid @(#) $Id: //bas/740_REL/src/R3ld/R3load/R3ldmain.c#2 $ SAP

/usr/sap/Q10/SYS/exe/uc/linuxx86_64/R3load: version R7.40/V1.7 [UNICODE]

Compiled Apr 10 2013 20:29:51

/usr/sap/Q10/SYS/exe/uc/linuxx86_64/R3load -testconnect

DbSl Trace: Connect to database failed, rc=1, rcSQL=-10709

(DB) ERROR: db_connect rc = 256

DbSl Trace: Connect to database failed, rc=1, rcSQL=-10709

(DB) ERROR: DbSlErrorMsg rc = 99

/usr/sap/Q10/SYS/exe/uc/linuxx86_64/R3load: job finished with 1 error(s)

/usr/sap/Q10/SYS/exe/uc/linuxx86_64/R3load: END OF LOG: 20131105155716

-Vinodh

[MvW]

SAP Note 2154997 helped me but my error was caused by another problem.

The passwords, I used, contained special characters like 'ä' or 'ö'. Setting this passwords manually in SSFS I received a message of invalid letters.

After restarting the whole procedure with "better" passwords, everything went fine (no error with R3load -testconnect anymore).

Also make sure, that the database user is not locked due to many failed logon attempts.

Here my setup:

Kernel 7.45 PL 201 (R3load PL 212)

HANA DB Migration from NW 7.5 from MaxDB

[former_member208699]

Hi,

in my case the problem was solved by setting a default key in hdbuserstore.

It seems that SWPM has problems when you give avirtual hostname as DB host.

That is what I used and not the hostname of the server.

Cheers

Cornell

[Former Member]

Hi vinodh, has this been solved? If yes, please advice your solution We are currently facing the same issue. Thanks so much!

[Former Member]

Hi Maria,

This is very old thread but still I will share what we did in our system when we had this errror while installing on HANA.

Basically if you are on Unix and installing with root user, the root user is not aware of HANA db environment that's why we get this error.

You will also have to define a hana HDB userstore for root user. Check this note 1625203. I think key should be named as DEFAULT. After this do these steps

1. Stop SAP installation

2. Chang to root user shell to "C-Shell".

3. Executed below command to import <sid>adm users enviornment to ROOT users environment

   # csh    

   # source /export/home/sidadm/.sapenv_<hostname>.csh

   # source /export/home/sidadm/.dbenv_<hostname>.csh

   # setenv rsdb_ssfs_connect 1

   # R3load -testconnect

Then run import/install again from this session .

This should solve your errror.

Thanks

Amit

Reference:

[Former Member]

Hi,

Despite the fact my issue was exactly when installing NW740 SP09 on a HANA multitenancy database, I got the same error.

To fix the error during the installation, I downloaded the latest ABAP Kernel from Marketplace, it seems I was using a previous version from 2014, there's a new one from 2015 that should be downloaded in case you want to install on Multitenancy environments.

ZIP51049350_5SAP Kernel 7.42 Linux on x86_64 64bit Info178436415.01.2015

ps: I tried the solutions proposed as well, but I didn't get any positive results..

Thanks,
Daniel

[Former Member]

Hi,

Please download the Latest SAP Kernel (SAPEXE_200_20012215.SAR , SAPEXEDB_200_20012231.SAR)

1) Stop SAP installation  & Stop HANA DB

2) Upgrade the Kernel.

3) Start HANA DB

3) Check the DB connection R3load - testconnect.

4) Retry the SAP installation.

Thanks

Pratap

[Former Member]

I'm facing the same issue, I'm running it on a test environment where the NW74 SP08 system was already installed before several times with both HANA SPS090 and SPS095..

My HANA DB is running in Multi Tenancy mode. The NW7.4 SP08 system was installed with HANA SPS90 and also with SPS95 but NOT when running HANA with Multi Tenancy. When I try to reinstall everything using MT database, I get the same error...

[Former Member]

hdb is not working ........but know it is working fine

thanks sir

[Former Member]

hi

i am also facing same issue while installation sap on suse11 for SAP it test the connection to sap but unable to connect but my database is working fine and able to ping..

thanks

[sunny_pahuja2]

Hello,

Please check if hdbuserstore information is correct on application server. Use command hdbuserstore list to check if all details like hostname, port no. and user is correct.

Thanks,

Sunny

[Former Member]

Thanks Guys,

My issue got resolved..

I have given mount directory as /SAPMNT/SID during installation. so its created as duplication of SID as shown below.So  uninstalled sap and started sap installation again without mentioning SID in mount directory

[Former Member]

Hi,

Still getting same error..i have done r3load and lib file update and also kernel update but no luck..

kernel level is 740 patch 38

Regards,

Vinodh

[Former Member]

Guys,

Any solution for this issue.

-Vinodh

[sunny_pahuja2]

Could you please paste some additional logs from installation directory?

Thanks,

Sunny

[former_member45419]

Hi ,

pls check this link

http://scn.sap.com/community/netweaver/blog

[Former Member]

Hi,

Check this link for you issue..

http://www.saptechies.org/hana-r3load-import-db-error-ddl-statement-failed/

• 1931083 - system status of ECC 6.0 EHP7 system
• HANA R3load import: (DB) ERROR: DDL statement failed. Note : 1900445 Symptom
• SAP EHP 7 for SAP ERP 6.0 - Release Information Note : 1865866 

BR,

Prabhakar

[Former Member]

Hi,

Please check the Kernel for R3load...New/ latest kernel will help.

http://scn.sap.com/community/netweaver/blog

BR,

Prabhakar

[sunny_pahuja2]

Hello,

It looks like APP box is not able to connect to HANA Box. Are you able to ping HANA host from your application server host ?

Thanks,

Sunny

[Former Member]

Dear Sunny,

I can able to ping HDB from my application server.

Regards,

Vinodh

[sunny_pahuja2]

Could you please paste some more error logs from the installation directory?

Thanks,

Sunny

[Former Member]

Hi,

Please check if the HANA SQLDBC is causing it but the note says that it was for the partition tables. No harm in trying...

1912332 - SQL array DML operations fail with error code "-10709"

Try to download the latest R3load and see if it helps.

Thanks

Rishi abrol