Skip to Content
0

Unable to access service layer in SAP B1 9.2 HANA DB

Oct 24, 2017 at 06:46 AM

452

avatar image
Former Member

When I am accessing service layer I am getting below error

"Fail to get the bound database instance from SLD"

Please help me on this

- Venkat

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

ANKIT CHAUHAN
Oct 24, 2017 at 10:23 AM
0

Hi,

1. Confirm the HANA Revision Version and SAP Business One Version.

2. Change the DbUserName and DbPassword to plaintext username and password in the b1s.conf file and restart Service Layer.

(currently DbUserName and DbPassword in b1s.conf file has encrypted values)
+ Send a login request to Service Layer by external/internal address:

POST https://<server>:50000/b1s/v1/Login
{"UserName": "manager","Password": "1234","CompanyDB": "DEMODB"}

3. Query on the table HostingUnit and get the HOSTINGUNIT_ID. Then Query on the table B1ServiceLayers and see the HOSTING_ID value. What is there in the HOSTING_ID?

Kind regards,

ANKIT CHAUHAN

SAP SME Support

Show 7 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Ankit,

Thank you for your support.

We are using HANA 1.0 platform version and SAP B1 9.2 PL08 HF#03.

As per your suggestion we have configure the b1s.conf with HANA DB user name and password with plain text. but we are getting same error.

Is there any alternate solution kindly let us know.

Thanks and Regards

Venkat

0

Hi,

What about the point no. 3 which I mentioned in my previous reply?

Kind regards,

ANKIT CHAUHAN

SAP SME Support

0

HI Ankit,

I am unable to find these tables. Please help me on this.

Thank you.

Regards

Venkat

0

Hi,

These tables can be found under "SLDData" schema.

Kind regards,

ANKIT CHAUHAN

SAP SME Support

0

Hi Ankit,

We have identified SLDData Schema. Below are the parameters with values.

HostingUnit : HOSTINGUNIT_ID (But is shows as ReferenceHostingunit_ID) value "?"

B1ServiceLayers : HOSTING_ID value "1"

Please help us to resolve this issue.

Thanks & Regards

Venkat

0
Former Member

Hi Ankit,

Any update on above query.

Thanks & Regards

Venkat P

0

Hi,

I would suggest you to raise an incident to SAP Support for the same.

Kind regards,

ANKIT CHAUHAN

SAP SME Support

0
Damian Schwegler Dec 01, 2017 at 12:34 PM
0

Hi,

I have the same issue with the same SAP Version. Did you get a solution?

Damian

Share
10 |10000 characters needed characters left characters exceeded
Jacob Tan
Jan 26 at 01:13 PM
0

Hi,

To resolve this issue, please follow the steps:

1. Uninstall Service Layer component

2. Run the Installer from your B1H Installation Package.Linux folder (not your installed location) to install Service Layer again.


image001.png (240.6 kB)
image002.png (91.8 kB)
Share
10 |10000 characters needed characters left characters exceeded