2933050 - Cannot Connect to SBOCOMM DB with DB User B1_SBOCOMMON

Prévia do material em texto

29330502022-12-28
2933050 - Cannot Connect to SBOCOMM DB with DB 
User: B1_SBOCOMMON
Version 2 Type SAP Business One Notes
Language English Master Language English
Priority Correction with high priority Category Program error
Release Status Released for Customer Released On 03.03.2021
Component SBO-BC-SLD ( System Landscape Directory )
Please find the original document at https://launchpad.support.sap.com/#/notes/ 2933050
Symptom
Login to all company databases failed with the following database related errors displayed:
'Connection to the database failed; contact your system administrator (ODBC -1102) [Message 131-183].'
In C:\ProgramData\SAP\SAP Business One\Log\SAP Business One\${UserFolder}\BusinessOne folder → 
SAP Business One client logs, you can find an error such as: 'Cannot connect to sbo common DB with DB 
user: SAPB1_DB_USER_SBOCOMMON'.
Reproducing the issue
Scenario:
Open an SAP Business One client.1. 
Choose any company.2. 
Log on to the company database.3. 
Expected behavior:
The logon to the company database is successful.
Actual behavior:
The logon fails with the following error messages:
Connection to the database failed; contact your system administrator (ODBC -1102) [Message 131-
183]
1. 
Cannot connect to sbo common DB with DB user: SAPB1_DB_USER_SBOCOMMON (in 
C:\ProgramData\SAP\SAP Business One\Log\SAP Business One\${UserFolder}\BusinessOne folder → 
SAP Business One client logs)
2. 
Solution
SAP intends to provide a patch or patches to solve the problem described. The section References below 
will list the relevant patches once they become available, and the Related Info content of relevant patches 
available in the SAP Support Portal will show this SAP Note. Be aware that these references can only be set 
at patch release date. SAP delivers patches only for selected releases at its own discretion, based on the 
business impact and the complexity of the implementation.
Workaround:
1 of© 2022 SAP SE or an SAP affiliate company. All rights reserved 2
https://launchpad.support.sap.com/#/notes/%0d%0a%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%202933050
29330502022-12-28
 
1.Stop all the Business One related services on the machine. Server Tools, Service Layer etc. Close all the 
SAP Business One Clients.
2. Go to HANA database - > Security - > Users -> Click on the user B1_SBOCOMMON -> Click Activate 
User.
3. Perform the same steps for the user B1_SBOCOMMON_RW unlock if needed.
Products
SAP B1 10.0 FOR SAP HANA
SAP BUSINESS ONE 10.0
This document is referenced by
SAP Note/KBA Title
2948656 Overview Note for SAP Business One 10.0 FP 2008, version for SAP HANA
2948670 Overview Note for SAP Business One 10.0 FP 2008
Terms of use | Copyright | Trademark | Legal Disclosure | Privacy
2 of© 2022 SAP SE or an SAP affiliate company. All rights reserved 2
https://support.sap.com/support-programs-services/about/terms-of-use.html
http://www.sap.com/corporate-en/about/legal/copyright/index.html
http://www.sap.com/corporate-en/about/legal/copyright/index.html#trademark
http://www.sap.com/corporate-en/about/legal/impressum.html
http://www.sap.com/corporate-en/about/legal/privacy.html