B1 HANA Service Layer Slow Performance

[former_member260921]

Hi,

My on premise HANA server is B1 Version 9.3 PL03 with HANA 122.05. It is a very low traffic VM VShpere server used only for development and seems to have adequate RAM and processor, both physical and virtual.

Calls to the B1 Service Layer from client javascript (Ajax) are slow even for simple requests like Logon and Logoff. They work fine but are slow.

The slow down does not seem to be caused by the server or the XS Engine which run well when the Service Layer is not being called. The HANA DB itself also seems to perform well when the Service layer is not involved.

I have looked in the Working with SAP Business One Service Layer document but haven't found much help there.

Questions:

1. Has anyone had this problem and resolved it?

2. Are there any blogs or other resources, other than the Service Layer Doc mentioned that might help me determine the cause of the slowness?

3. Are there any system logs or other monitors I should check.

Thanks for any help.

Regards,

Mel

[duncanspeidel · Accepted solution]

Hi Mel,

What are you comparing the SL to? How does the client perform?

There is a lot of blog listed on the extensibility page

https://blogs.sap.com/2014/12/02/sap-business-one-version-for-sap-hana-extensibility-topics/. The service layer logs can be found in

/usr/sap/SAPBusinessOne/ServiceLayer/logs.

Best regards,

Duncan

.

[former_member260921 · Accepted solution]

Hi Duncan,

Thanks for your response.

What are you comparing the SL to?

[former_member260921 · Accepted solution]

Hi Duncan,

Thanks for your response.

The service layer is just slow compared to anything else. For example the Logon running as an ajax request just takes many seconds to complete. It is slow for Logout which is probably not doing much. The B1 client performs well. The XS Browser apps run well until the Service Layer is needed.

This is too slow for production use. Other processes on the server run at a decent speed.

The server seems to have plenty of resources and the network is hard wired and fast.

I am preparing to demo the a mobile HANA app to a potential client and need it to run faster.

Who can help me with this?

Thanks.

Regards,

Mel

$.ajax({
type: "POST",
url: path,
xhrFields: {
withCredentials: true
},
data: JSON.stringify(loginInfo),
error: function(xhr, status, error) {
oLabelLogin.setText("Login Failed");
/*
if (xhr.response.Text) {
oLabel1.setText(xhr.responseText);
} else {
oLabel1.setText("");
}
*/
}
})

[thiago]

Hi Mel,

Please, also consider an upgrade to, at least, 9.3 PL04, which is the initial release for 9.3. Lower PLs should have unpredicted bugs.

Regards,
Thiago.