Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Nov 05, 2015 at 02:27 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

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

  • May 25, 2016 at 09:32 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • May 26, 2016 at 12:42 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded