Skip to Content
Nov 03, 2015 at 03:43 AM

Add filed too slowly in SAP B1 for HANA


Hi, Everyone,

I am working on an add-on about SAP Business one for HANA. Need to add filed in user table and SAPB1 table.

There is no problem when add user table filed, but when I tried add field into table ODLN, it is too slow.

At first I tried DI-API, SAPbobsCOM.UserFieldsMD add(), take about 3 minutest to get return value. It is slow but stable.

So I changed to Service Layer, it response 502 gateway error after about 1 minustes, but after about 3 minutes, I can find the field in HANA database, so it add field succeed with error response.

Client Log:

System.Net.WebException: The remote server returned an error: (502) Bad Gateway.

Server Log:

[Mon Nov 02 21:58:02.460582 2015] [proxy_http:error] [pid 1278:tid 140729532618496] (70007)The timeout specified has expired: [client] AH01102: error reading status line from remote server

[Mon Nov 02 21:58:02.460648 2015] [proxy:error] [pid 1278:tid 140729532618496] [client] AH00898: Error reading from remote server returned by /b1s/v1/UserFieldsMD

So here are two problems, could anyone help me?

1. Is there any better way to add field in table ODLN quickly?

2. How to resolve 502 gateway error for this case?

Thank you very much.