Unable to access service layer in SAP B1 9.2 HANA DB

[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

[jacobahtan]

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.

[former_member1145951]

This works fine before till now. Restarted the services but still error exist. Now we will try your solution. Is there any particular reason why this happens?

[former_member1145951]

able to fix this issue by reinstalling Service Layer Component. Thanks.

[damian79]

Hi,

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

Damian

[ANKIT_CHAUHAN]

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

[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

[ANKIT_CHAUHAN]

Hi,

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

Kind regards,

ANKIT CHAUHAN

SAP SME Support

[Former Member]

HI Ankit,

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

Thank you.

Regards

Venkat

[ANKIT_CHAUHAN]

Hi,

These tables can be found under "SLDData" schema.

Kind regards,

ANKIT CHAUHAN

SAP SME Support

[Former Member]

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

[Former Member]

Hi Ankit,

Any update on above query.

Thanks & Regards

Venkat P

[ANKIT_CHAUHAN]

Hi,

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

Kind regards,

ANKIT CHAUHAN

SAP SME Support