DDIC & RFC Problem - disp + work.EXE STOPPED - Sol...

Hi everybody,

I try to install the Solution Manager 7.2 on a Windows Server 2012 R2!

As you can see I got the following ERROR during the Installation.

The DDIC and the password of the DDIC is correct, but I can not start SM3.

Unable to open RFC connection to SAP System SM3.

-> disp + work.EXE (Dispatcher) Status -> Stopped

I restart the system and restart the installation but it doesn't solve the problem.

When I restart the SM3 at the beginning it is green, but it skips to yellow it comes to this abrupt stop.

Please guide me how to solve this connection problem.

Regards,

Mohammed Rajab

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (3)

This message was moderated.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hello Mohammed,

Can you paste the log of one of the work processes (e.g. w0 / w1 / etc.) and also the information that Yuksel mentioned from R3trans -d on the command line? This will help us understand why it is failing.

Best regards
Rui

Hello Mohammed,

Make sure HANA DB is open.

Try running "R3trans -d" from cmd using sidadm user. Does it return 0? If not can you attacht trans.log file created on the same folder.

Can you also attach dev_ms, dev_disp and dev_w0 trace files?

Regards,

Yuksel AKCINAR

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi,

Could you please post developer trace of disp+work.EXE?

Regards,

Ganesan

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi experts,

thank you all for your prompt replies!

You will find the trace files in the attachments!

Also see the result of "r3trans -d"

Hello Mohammed,

Thank you for the logs, I was able to detect the issue now.

Can you please try the following? On the command line of the application server execute the following command :

hdbuserstore list

And please check if there is an entry for DEFAULT. If there is not execute the following command:

hdbuserstore set DEFAULT <hostname>:<port> <user> <password>

Where you should replace the values between < > by your specific values. If you need any help, you can check other entries, or perhaps run the same command on the HANA DB server.

After that, please execute again the hdbuserstore list command to confirm the DEFAULT key is listed, and if so, try starting again the system and let me know if that solved it.

Best regards

Rui

Hi all,

the long protocol and the files which I posted are wrong because the database was not active.

Here are the correct files.

Sorry!

Best regards,

Mohammed

Hi Mohammed,

That is strange. The database connection test returned succcessfully... Can you please try again to execute r3trans -d and confirm the return code is still 0?

Best regards

Rui

Hi Rui Sousa,

I tried the „R3trans –d“ again and now i get the error code “0012”.

Thanks for your fast reply!

Mohammed

Hi Mohammed,

You are most welcome

At least we know there is an issue connecting to the HANA DB. When you execute the r3trans -d command, it creates a file within the folder you executed the command called trans.log. Can you please provide that file to understand why it is not able to connect to the DB?

Best regards

Rui

Hi Rui,

thanksss;-)

I attached the requested file.

Best greets,

Mohammed

Hi Mohammed,

Thank you, but I think you sent the wrong file 😕 it should be called trans.log. You need to check on the same folder that you are when executing the R3trans -d command.

Best regards

Rui

Hi Rui,

sorry, my fault.

4 ETW000 r3trans version 6.25 (release 745 - 27.11.15 - 20:15:12).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 21.07.2016 - 15:41:49

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: r3trans -d

4 ETW000 trace at level 1 opened for a given file pointer

4 ETW000 [ dev trc,00000] Thu Jul 21 15:41:49 2016

4 ETW000 [ dev trc,00000] Loading DB library 'dbhdbslib.dll' ...

4 ETW000 [ dev trc,00000] Library 'dbhdbslib.dll' loaded

4 ETW000 [ dev trc,00000] Version of 'dbhdbslib.dll' is "745.04", patchlevel (0.100)

4 ETW000 [ dev trc,00000] switch DBSL TRACE LEVEL from 3 to 1

4 ETW000 [ dev trc,00000] DBHDBSLIB : version 745.04, patch 0.100 (Make PL 0.100)

4 ETW000 [ dev trc,00000] HDB shared library (dbhdbslib) patchlevels (last 10)

4 ETW000 [ dev trc,00000] (0.100) SAP Support Package Stack Kernel 7.45 Patch Level 100 (note 2276394)

4 ETW000 [ dev trc,00000] (0.018) Describe on a decimal datatype with a large scale value (note 2220646)

4 ETW000 [ dev trc,00000] (0.013) Use connection variables instead of table M_CONNECTIONS (note 2207349)

4 ETW000 [ dev trc,00000] (0.008) Session variables processing via dbsl (note 2182777)

4 ETW000 [ dev trc,00000] (0.005) Substitute literals in select list (note 2182777)

4 ETW000 [ dev trc,00000] (0.004) Cancel FDA SQL statement (note 2177669)

4 ETW000 [ dev trc,00000]

4 ETW000 [ dev trc,00000] Loading SQLDBC client runtime ...

4 ETW000 [ dev trc,00000] SQLDBC Module : D:\usr\sap\SM3\hdbclient\libSQLDBCHDB.dll

4 ETW000 [ dev trc,00000] SQLDBC Runtime : libSQLDBCHDB 1.00.102.01 Build 1444147999-1530

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

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

4 ETW000 [ dev trc,00000] Thu Jul 21 15:41:50 2016

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=10061:No connection could be made be\

4 ETW000 [ dev trc,00000] cause the target machine actively refused it)

4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error -10709 performing CON

4 ETW000 [ dblink ,00000] ***LOG BY0=>Connection failed (RTE:[89006] System call 'connect' failed, rc=10061:No connection could be made because the target machine actively refused it)

2EETW169 no connect possible: "DBMS = HDB --- SERVER = '' PORT = ''"

*** The Database Hana is running on a Linux Server. (successfully)

***** I did the installation of the Solution Manager 7.2 on the Windows Server 2012 R2.

***** During the installation of the Solution Manger 7.2, i set for the database host the public IP.

Thanks alot,

Mohammed Rajab

Hello Mohammed,

Check below discussions.

ERP 6 EHP7 on HANA upgrade error | SCN

Regards,

Yuksel AKCINAR

Hi Mohammed,

This is perfect thanks! It is pointing to the error I mentioned before. Can you please execute the following command and check if there is an entry for the DEFAULT key?

hdbuserstore list

If not, please execute the following command

hdbuserstore set DEFAULT <hostname>:<port> <user> <password>

That should fix your issue!

Best regards

Rui

Hi Rui,

you mean this:

It is set.

Thanksss,

Mohammed

Hi Yuksel,

thankssssss, i will.

Hope to solve as soon as possible.

Best regards,

Mohammed

Hi Mohammed,

Exactly, and can you confirm the details are correct? I suspect they might be wrongly defined.

Is the user SAPABAP3 right? And the hostname and password? That error message is usually linked to an authentication problem on that, and the log file is pointing to an error on the DEFAULT key so I would recommend that you change the DEFAULT key and set it again with the correct parameters, and that should fix the issue

Best regards

Rui

Hi Rui,

so many thanks.

Now we pinged the linux system (Linux Server (set the HANA DB on it)) from the Windows Server 2012 R2 (Solution Manager 7.2 (goal:-))) and find out, I couldn't ping the Linux Server.

We try to get the connectivity?

I will post / reply the result.

Thanks and best regards,

Mohammed

Hi Mohammed,

Absolutely, glad to be of some assistance

Have you confirmed that you have added the respective hostnames to the hosts file on both servers? You should check that the hosts file on windows can resolve the hostname to the HANA DB server, and also from linux check that the hosts file is resolving the hostname to the Application Server. Let me know if that helped!

Best regards

Rui

Hi,

Database was not connected after checking for secure store according to the trans.log provided by you. It seems that secure store entries are not validated for database connection. Could you please check it with the following note. You need to either update the SSFS entries again or disable SSFS connection and try again.

2168574 - rc=111:Connection refused to HANA after migration using SSFS

Regards,

Ganesan

Hi Mohammed,

Any luck on solving this?

Best regards

Rui

Ask a Question

Top Q&A Solution Author

User

Count