Add filed too slowly in SAP B1 for HANA
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.
System.Net.WebException: The remote server returned an error: (502) Bad Gateway.
[Mon Nov 02 21:58:02.460582 2015] [proxy_http:error] [pid 1278:tid 140729532618496] (70007)The timeout specified has expired: [client 10.189.4.41:49215] AH01102: error reading status line from remote server 127.0.0.1:50001
[Mon Nov 02 21:58:02.460648 2015] [proxy:error] [pid 1278:tid 140729532618496] [client 10.189.4.41:49215] 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.