Skip to Content
avatar image
Former Member

BW4HANA NLS connection with Hadoop - Short dump

Hi,

While creating NLS connection between BW4HANA system and Hadoop (via spark sql )we are facing couple of step by step short dump.

While creating that NLS setting I have setup remote connection setting through SM59 for webhcat and webhdfs and both settings were showing fine at the time of checking the NLS settings.Remote source has been also set up from HANA studio under provision node.

Initially we experienced HTTP communication error later we have solved after tracing the log and identified.But after that we have received another erroneous short dump :-Error while creating virtual table something like :- &/BIC/OVMD_SORG_Y@VT and exception occured :- CL_RSSDA_FEDERATION_SERVICES==004 and CL_RSSDA_CONNECTION_IMPL===CM00I.

Specifically it was creating two tables by itself while SAP was searching those two tables initially and third one SAP couldn't create that.

Tables which gets created by itself :-

(“t_1ebic_1eonmd__sorg__b” and “t_1ebic_1eovmd__sorg__b”

Third table :- “t_1ebic_1eoumd__sorg__b” which couldn't create.Since we dont have any further option to get that created so we manually created that found below error.

HTTP PUT status code 409 for URI '/v1/ddl/database/sapb4h/table/t_1ebic_1eonmd__sorg'”.

FAILED: SemanticException [Error 10072]: Database does not exist: sappw4

, exitcode=88) .

Please help us if someone has any previous experience in this kind of short dump same dump.

Any kind of help or direction would be much appreciated since we are impacting due to this interruption of presetly on going research on NLS.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 02, 2017 at 09:26 AM

    Hello

    Unfortunately your description is a bit vage. Which SP are you using with BW 7.50 on HANA?

    You can find correction for the Hadoop NLS usage in the SAP Launchpad as described here

    https://blogs.sap.com/2015/11/17/increasing-the-sap-nls-performance/#sapcorrections

    https://blogs.sap.com/2016/10/12/sap-nls-solution-sap-bw/#implementation

    Add comment
    10|10000 characters needed characters exceeded

  • May 03, 2017 at 07:48 AM

    Hello Roland,

    We are using BW4HANA and the version and SP Details are provided in the attached document. We have checked the Hadoop connectivity for all the 3 nodes of our Hadoop cluster from the BW system, and they are fine.

    Nevertheless the error is persisting. We have now been trying for couple of months now. Kindly help !!!!!

    Regards

    Prateek

    Mobile +91 9836023523

    Add comment
    10|10000 characters needed characters exceeded