Skip to Content
0

BW4HANA NLS connection with Hadoop - Short dump

Apr 14, 2017 at 03:01 PM

150

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Roland Kramer
May 02, 2017 at 09:26 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 03, 2017 at 07:48 AM
0

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


nls-error.png (54.3 kB)
Share
10 |10000 characters needed characters left characters exceeded