Add filed too slowly in SAP B1 for HANA

[former_member756583]

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 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.

[JoergAldinger]

Hi Tricia:

I figured out a solution for the 502 error. I posted it as a separate document which you can find here:

How to avoid "502 Proxy Error" when adding larg... | SCN

Best regards,

Joerg.

[JoergAldinger]

Dear Tricia:

Have you been able to resolve the 502 proxy error issue?

I know it is basically a timeout between the load balancer ("proxy") and the service layer member.

I have tried elevating the timeout on the client, but since the timeout is not occurring between the client and the SL load balancer, this did not help.

I have also checked the SL configuration folder but have not found any configuration related to a timeout.

Please let me know if you have any suggestions or if you have resolved your problem at all.

Thanks,

Joerg.

[former_member756583]

Could anyone give me some suggestion? Or I should I post this topic in other Board of SAP?

My develop enviroment have 2 CPU and 26G mem, with HANA 0.74, SAP B1 91 PL5 before.

And yesterday I tried PL9 and it seems need HANA 97, and the HANA 0.97 always install failed with error

07:34:46.939 - INFO:	Starting service
07:34:46.940 - INFO:	Starting external program /usr/sap/EDI/HDB00/exe/sapstartsrv
07:34:46.940 - INFO:	Command line is: /usr/sap/EDI/HDB00/exe/sapstartsrv pf=/hana/shared/EDI/profile/EDI_HDB00_suse-hana -D -u ediadm
07:34:46.955 - INFO:	Output line 1: Impromptu CCC initialization by 'rscpCInit'.
07:34:46.955 - INFO:	Output line 2:   See SAP note 1266393.
07:34:47.079 - INFO:	Output line 3: Impromptu CCC initialization by 'rscpCInit'.
07:34:47.079 - INFO:	Output line 4:   See SAP note 1266393.
07:34:47.162 - INFO:	Program terminated with exit code 0
07:34:47.163 - INFO:	Waiting for sapstartsv...
07:34:47.164 - INFO:	sapstartsrv is not running: Net::HTTP: connect: Connection refused
07:34:48.164 - INFO:	sapstartsrv is not running: Net::HTTP: connect: Connection refused
07:34:49.165 - INFO:	sapstartsrv is not running: Net::HTTP: connect: Connection refused
07:34:50.166 - INFO:	sapstartsrv is not running: Net::HTTP: connect: Connection refused
07:34:51.167 - INFO:	sapstartsrv is not running: Net::HTTP: connect: Connection refused
07:34:52.167 - INFO:	sapstartsrv is not running: Net::HTTP: connect: Connection refused
07:34:53.168 - INFO:	sapstartsrv is not running: Net::HTTP: connect: Connection refused
07:34:54.169 - INFO:	sapstartsrv is running

07:34:54.169 - INFO:   ---------------------------------------------------------

07:34:54.169 - INFO:   Starting SAP HANA Database system...

07:34:54.169 - INFO:   ---------------------------------------------------------

07:34:54.169 - INFO:	Starting instance on local host...
07:34:54.170 - INFO:	Parameters: instance number = 00, user = ediadm
07:34:54.172 - INFO:	Sending HTTP request, function = Start, maximum number of retries = 3
07:34:54.173 - ERR :	Start request failed: Instance already started
07:34:54.173 - ERR :	Start instance 00 on local host failed.
07:34:54.174 - INFO:	Messages from trace files
07:34:54.174 - ERR :	Check the log file for SAP HANA Database error messages

07:34:54.174 - INFO:   ---------------------------------------------------------

07:34:54.174 - INFO:   END: Start SAP HANA Database system (start: 07:34:54.169 duration: 00:00:00.004)

07:34:54.174 - INFO:   ---------------------------------------------------------

07:34:54.174 - ERR :   Cannot start system

07:34:54.174 - INFO: -----------------------------------------------------------

07:34:54.174 - INFO: END: Create System (start: 07:32:34.410 duration: 00:02:19.764)

07:34:54.174 - INFO: -----------------------------------------------------------

07:34:54.174 - ERR : Cannot create Instance

07:34:54.174 - ERR : error installing

07:34:54.174 - ERR : Installation failed

07:34:54.207 - INFO: Summary of critical errors

07:34:54.174 - ERR :   Installation failed

07:34:54.174 - ERR :	error installing
07:34:54.174 - ERR :	Cannot create Instance
07:34:54.174 - ERR :	Cannot start system
07:34:54.173 - ERR :	Start instance 00 on local host failed.
07:34:54.173 - ERR :	Start request failed: Instance already started
07:34:54.174 - ERR :	Check the log file for SAP HANA Database error messages

:

Could anyone give me suggetion about it? Thank you very much.

[Former Member]

Hi,

HANA 0.97 is faster on adding felds with DI API.

For the Installation Problem, you should read Notification 1266393.

If this doesnt help you, make a Ticket for the SAP support.