XSA: Cannot add HDI Container or HANA Database to SAP Web IDE for SAP HANA Database Explorer

[stefra]

Hello colleagues,

we have a local installation of HANA 2.0 SP03 on our RHEL 7.5 linux machine with the SID "HP2". There is also an S/4HANA Business Suite running on a separate tenant "BS1" of the hana system HP2.

I configured the Web IDE and XSA according the "SAP_Web_IDE_for_SAP_HANA_Installation_Guide_en" so i have my development space in my organization and the di builder service is running.

My goal is now to develop my first MTA project with the SAP Web IDE for SAP HANA. So i created a project called "TRAINING" in my workspace and added an HDB module "DB" with an CDS artefact where i created just one table "users". The project got built successful and the HDI Container is created: MyUser-tc470e9bs6p5melh-TRAINING-hdi_db

The HDI container is listed in the "Add Database" selection screen and i can choose it:

But if i try to connect by clikcing "ok" in this dialog, i am getting the following message:

The database could not be added to the Database Explorer.

Error core: AUDIT_FAILED

An error occured while attempting to security audit this action. The action has been cancelled.

I am also not able to connect to the SYSTEMDB of HP2 for example. Here am i getting the following error:

The database could not be added to the Database Explorer.

Error code: DATABASE_CONNECTION_ERROR

Unable to create database connection: An error occurred while attempting to security audit this action. The action has been cancelled.

I have no idea what to do or to check now. Can anyone please help me? Fun fact: If i try to open the SYSTEMDB of HP2 with the SAP HANA Cockpit or better the database explorer of the H4C am i able to connect and view the catalog.

Thanks in advance and best regards,

Stefan

[former_member199076]

This issue can happen if the credentials used by the database explorer to communicate with the audit log service get out of sync. It can usually be resolved by rebinding the database explorer service to the auditlog service. Execute the following commands:

xs unbind-service hrtt-service hrtt-auditlog
xs delete-service hrtt-auditlog
xs restart auditlog-server
xs create-service auditlog free hrtt-auditlog
xs bind-service hrtt-service hrtt-auditlog
xs restart hrtt-service

Kind regards,

- Eric Farrar

[stefra]

Hello Sampath,

did you installed just the HANA rev.34? I also installed the XSA update "EXTAPPSER00P_97-70001316.SAR". I sadly can't tell you if it is the new version of XSA or maybe an recreated sync during or after this update progress like Eric supposed what solved my problem. In fact, i didn't had to rebind the database explorer service to the auditlog service myself.

Best regards,

Stefan

[former_member514240]

Hi Stefan / Eric,

Thanks for your inputs , We are on HANA 2, rev33 and executed the re binding commands as suggested. Still we are getting the same issue while adding HANA MDC to the database explore in XS webide.

Next step as Stefan suggested - I have upgraded HANA from rev33 to rev34 and re executed again the binding commands,But issue remain same in our case.

Any other further suggestions here?

xs unbind-service hrtt-service hrtt-auditlog
xs delete-service hrtt-auditlog
xs restart auditlog-server
xs create-service auditlog free hrtt-auditlog
xs bind-service hrtt-service hrtt-auditlog
xs restart hrtt-service

[former_member514240]

Hi Stefan,

You managed to solve this issue? Exact same issue we are facing in our Landscape.

Could you please guide me if you got a way to solve this issue?

Thanks and Regards

Sampath R.

[stefra]

Hello Sampath,

I was able to solve my problems by installing the latest Support packages yeterday evening. You should check if there are updates available for your HANA System and install them. It should work afterwards.

Best regards,

Stefan