[Help] - Upgrading B1 database SAP HANA

[Former Member]

Hi experts,

     When using the upgrade wizard of SAPB1H 9.1 PL05, the upgrader can't see any database server type also I've got an error "no connection information found on your license server ". Also I already tried to restart the sapb1servertools in our HANA server. Please see image below:

[duncanspeidel · Accepted solution]

Hi Bryan,

On the machine where the upgrade wizard is running you must install the HANA client.  The HANA client provides the communication protocols used to talk to the HANA DB.  You should also confirm that you can successfully ping the HANA DB from the Windows host and vice versa.

Best regards,

Duncan

[Former Member · Accepted solution]

Hi ,

     The machine that I'm using for the upgrade has SAP B1 Client and HANA Client, and it successfully login for the DEMO database.

Regards,

[Former Member · Accepted solution]

Moved to:

SAP HANA and In-Memory Computing

[duncanspeidel · Accepted solution]

Bryan,

Have you done the dirty cheat and added update /windows/system32/drivers/etc/hosts to contain the HANA server details?

Best regards,

Duncan

[Former Member · Accepted solution]

Hi ,

     What do you mean "added update /windows/system32/drivers/etc/hosts "? Add the IP address of HANA server?

Regards,

[duncanspeidel · Accepted solution]

Hi Bryan,

Make an entry something like <HANA IP>     <HANA server Name>

Best regards,

Duncan

[Former Member · Accepted solution]

Hi ,

     I'll try this tomorrow, any other solutions if this trick will not work?

Regards,

[duncanspeidel · Accepted solution]

Hi Bryan,

If the issue persists we'll have to see what the logs show.

Best regards,

Duncan

[Former Member · Accepted solution]

Hi ,

     The trick doesn't worked. Which file log do you need to look? %Userprofile%\Local Settings\Application Data\SAP\SAP Business One\Log\Upgrade

This log is from file (BusinessOneUpgradeb1loggerPid2320):

21/07/2015  18:00:43:450250
Genl       
NoteLgAlw   
I
Tec
Computer:SAPB1H-PC, Version:9.10.150, Program:C:\SAPB1H\SAP_9105_u\Wizard\Upgrade.exe, PID:2320 # #
TID=1136
B1Logger.cpp
229





Customized=0


21/07/2015  18:00:43:450250
Genl       
NoteLgAlw   
I
Tec
--------Logger Started-------- at : 21/07/2015  18:00:43:450250 # #
TID=1136
B1FileWriter.cpp
287





Customized=0


21/07/2015  18:00:43:450250
Genl       
NoteLgAlw   
I
Tec
***** Help LOIO: Loading from Resource ***** # #
TID=2428
__HELP.c
206





Customized=0


21/07/2015  18:00:59:637750
Sys       
NoteLgAlw   
I
Biz
sld address: https://192.168.1.30:40000/sld/sld.svc  # #
TID=2428
SLDClient.cpp
53





Customized=0


21/07/2015  18:01:04:856500
Sys       
NoteLgAlw   
I
Biz
SSO--CSLDClientOP::GetNamedDBCred-- database not found   # #
TID=2428
SLDClient.cpp
53





Customized=0


21/07/2015  18:01:04:887750
Sys       
NoteLgAlw   
I
Biz
SSO--CSLDClientOP::GetDBCredentials GetCredential failed server: serverType:None  # #
TID=2428
SLDClient.cpp
53





Customized=0

I can see that the "GetNamedDBCred" database not found.

What is this for?

Regards,

[Former Member]

I installed the 32bit HANA Client. The current installed HANA Client is x64.

Regards,

[duncanspeidel]

Hi Bryan,

I see that you marked my reply from July 20 correct.  Unless you say otherwise I will assume this issue is resolved.

Best regards,

Duncan

[Former Member]

Please help,