cancel
Showing results for 
Search instead for 
Did you mean: 

SAP B1 10 HANA - Connection to the Database is Lost

brunopbaffonso
Active Participant
0 Kudos

I created a VM with:

  • SLES 15 SP 1
  • SAP HANA Platform Ed. 2.0 SPS04 Rev. 45
  • SAP B1 for HANA 10 PL 02

I created, via setup, an SBODEMOUS database

And imported an SBODEMOBR database that was in SAP 9.3 version, and upgraded this base to SAP 10 PL 02.

However, when I logging in SBODEMOUS, with manager, I access to DB!

But there is no access to SBODEMOBR DB, it returned an error The connection to the database is lost; contact your system administrator (ODBC -1102).

In log file (attachment), located at C:\ProgramData\SAP\SAP Business One\Log\SAP Business One\%USERT%\BusinessOne, check the following information:

2020-07-29  15:14:30.804923 Sys         Err           IBizLOG_CreateDBConnection: Using database authentication  to connect to company DB # #TID=6400palogin.c2387Customized=0
2020-07-29  15:14:30.804923 Sys         Err           IBizLOG_CreateDBConnection: Can not connect to company DB with DB user: SAPB1_DB_USER_SBODEMOBR # #TID=6400palogin.c2389Customized=0
2020-07-29  15:14:30.804923 Sys         Err           IBizConnection to the database is lost; contact your system administrator (ODBC -1102)  [Message 131-183] # #TID=6400Customized=0

To try to resolve, I removed the SBOCOMMON object permission from user SAPB1_DB_USER_SBODEMOBR. As indicated in SAP Note: https://launchpad.support.sap.com/#/notes/2865496

And yet, I did not resolve Try to reinstall SAP Client and HANA Client.

But without success.

What else can I do?

ANKIT_CHAUHAN
Product and Topic Expert
Product and Topic Expert

Dear brunopbaffonso,

Your issue might well be related to SAP Note 2933050.

You can raise an incident for SAP Business One Support Team to get it investigated and get a database fix.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

0 Kudos

Hi Bruno,

did you manage to solve the problem? I am in the same situation

View Entire Topic
brunopbaffonso
Active Participant
0 Kudos

Hello!

Upgrade to SAP 10.0 FP 2008 resolve the problem.

Thanks everyone!

Regards;
Bruno Affonso.