SAP HANA Express: Error when creating a virtual table for an OData Remote Source

[chholzermsg]

Hi,

I have installed a fresh HANA Express on GCP and activated the OData SDI option (using sdi.tgz). I have added the ODataAdapter to SYS.Adapters_ and I have define my SAP Marketing Cloud instance as Remote source.

When I try to create a virtual table using the OData service provided by my SAP Marketing Cloud instance, I get the following error message:

Could not execute 'CREATE VIRTUAL TABLE YDP_PAPM_SCORING AT "MARKETING_PAPM".YY1_PAPM_SCORING_CDS' Error: (dberror) [476]: invalid remote object name: exception 70000000: No error; $message$=not well-formed (invalid token) ErrorCode=4 lineNumber=1 columnNumber: 181 : line 0 col -1 (at pos 0)

Strangly I did the same procedure in November. At that time it worked.

I have attached the trace of my HANA express instance and the metadata of the called service.

Do you see, where the problem lies? Or is there a way to get a more detailed description of the problem or a way to identify which part of what xml is the issue?

BR Christian

[chholzermsg · Accepted solution]

To solve above problem was quite simple. Problem was that the documentation and the error message was not detailed enough at that point - the error message directed me even in the wrong direction.

Since I used "PASSWORD" for authenticaton, it was not enough to define "WITH CREDENTIAL TYPE 'PASSWORD' USING", but also had to define "password" as CredentialEntry, so "<CredentialEntry name="password">". I had used a different name, for me more meaningful name here.