Technical Articles

Former Member

September 4, 2019 Less than a 1 minute read

Interested in news about database support for the service layer?

Dear all,

Since its introduction in SAP Business One there has been discussions about the missing official support of the service layer for Microsoft SQL Server.

Now there are important news, read Andreas Wolfinger’s comment on this improvement request on customer influence platform (anyone with an s-user can be active there).

<update on Dec 18 2019> Even though it is not yet available with version 10 PL00, it is planned as described in our updated product road map. Please pay attention to further communication on upcoming patches.

Best regards, Peter

11 Comments

You must be Logged on to comment or reply to a post.

Manuel Dias

January 24, 2020 at 10:15 am

Hi Peter,

Service Layer availability for MS SQL is important to support organizations that rely on MS SQL data eco-systems, to support both SAP B1 and other LB solutions that integrate with B1.

Do you have any date when first SL version will be released for MS SQL?

Thanks

Former Member

Blog Post Author

January 24, 2020 at 11:31 am

Dear Manuel, this is planned very soon, unfortunately we are not allowed to make a clear or binding statement here.
I personally assume the GA (general availability) version of Business One 10 should be very interesting.
Best, Peter

Paolo Fornari

February 6, 2020 at 10:53 am

Hi,
I took it for granted SL support for SQL Server on B1 10.

I've just installed B1 10 PL01 and tryed a login using Postman, here is the response:

{
   "odata.metadata": "https://server-doc:50000/b1s/v1/$metadata#B1Sessions/@Element",
   "SessionId": "212d4e66-48cd-11ea-8071-005056875584",
   "Version": "1000110",
   "SessionTimeout": 30
}

So... seems to work, tried also an oData Get on a BP and it's working.

Please, let me understand state of art and if support is official or not.

Thank you

Paolo

Former Member

Blog Post Author

February 6, 2020 at 11:19 am

As above, indeed it's supported and official.

Miguel Adauto

February 13, 2020 at 7:53 pm

I have this problem with the SL for SQL Server on B1.

{
   "error": {
      "code": -311,
      "message": {
         "lang": "en-us",
         "value": "Fail to get the bound database instance from SLD."
      }
   }
}

Bilal Sultan

March 29, 2020 at 9:06 am

Paolo Fornari

Have you configured anything?
i can’t access service layer through https://Server:50000

is there any configuration i have to do?
or is there a specific installation i have to install?

I'm running SAP Business One 10 PL01

Please Help.

Best Regards,

Paolo Fornari

April 1, 2020 at 8:23 am

Bilal Sultan

You need to separately install it.

You can find the setup under the Packages.x64\ComponentsWizard folder.

Paolo

dhana sekar

June 6, 2020 at 2:53 pm

Hi ,

How to fix following error "SERVICE LAYER NOT FOUND FOR THIS DATABASE SERVER" in SAP BUSINESS ONE 10 PL02 SQL

Please help me to sort out this issues

Former Member

Blog Post Author

February 6, 2020 at 11:18 am

Dear all, I'm pleased to clarify that Service Layer service is enabled for Microsoft SQL Server wince Version 10 PL01, see SAP Note 2875568.

Best regards, Peter

Darren Grayson

February 13, 2020 at 12:43 pm

When used on Microsoft SQL, is there anything missing from Service Layer? Such as the JS script engine (https://blogs.sap.com/2017/09/01/implementing-service-layers-script-engine/)?

Thiago de Castro Mendes

February 26, 2020 at 9:28 am

Hi Darren,

You can find here the documentation with features and scope of the Service Layer for both MS SQL Server and SAP HANA.

Please refer to page 51 where we state Semantic Layer through SL is obviously only available for SAP HANA, or to page 120 explaining the same for the parameter isCaseInsensitive.

Hope it helps,
Thiago Mendes.

Technical Articles

Interested in news about database support for the service layer?

Assigned Tags