S/4HANA IDES data location

[Olda]

Hello,

I have installed S4/HANA IDES system. I would like to ask you where can I find data? There should be tables as LFA1, EKKO, EKPO etc, but I couldnt find them.

I connect to DB via HANA Studio, database user.

tahnk you

[ORU]

can you logged in with user saphanadb through studio?

[Olda]

Hello Oliver,

I did it as you adviced:

hidadm@HANAIDES:/usr/sap/HID/HDB00/exe> hdbuserstore list
DATA FILE : /usr/sap/HID/home/.hdb/HANAIDES/SSFS_HDB.DAT
KEY FILE : /usr/sap/HID/home/.hdb/HANAIDES/SSFS_HDB.KEY

KEY DEFAULT
ENV : hanaides:30015
USER: SAPHANADB

I restarted Hana studio, but this user there is not. What is wrong?

[ORU]

Or better go ahead as described here to set user and password again

https://help.sap.com/viewer/b3ee5778bc2e4a089d3299b82ec762a7/2.0.02/en-US/ddbdd66b632d4fe7b3c2e0e6e3...

example:

./hdbuserstore set DEFAULT <host:port> SAPHANADB <password>

[ORU]

Hi John,

as suspected the Keyfile is missing. On which instance number is your HDB up and running 00?

regards Oliver

[Olda]

Hello Oliver,

there is the result:

hidadm@HANAIDES:/usr/sap/HID/HDB00/exe> hdbuserstore list
DATA FILE : /usr/sap/HID/home/.hdb/HANAIDES/SSFS_HDB.DAT

Is it OK?

[ORU]

Hi John,

don't check the content. Please switch to folder as described before and run command hdbuserstore list with user sidadm and give me the result.

[ORU]

Hi John,

can you please verify if key file is missing as follow:

su - sidadm

cd /usr/sap/SID/D00/exe/hdbclient

hdbuserstore list

what is the result?

regards Oliver

[Olda]

Hello Oliver,

I checked it and folder or file hdbclient is missing in /usr/sap/HID/HDB00/exe

there is only file hdbuserstore

[Olda]

Probably I found a clue. There is problem with authorization.

I dont see any data table as for example LFA1 table. But I am able to search it by searching box.

When I wanted to display content (data), I saw this error:

there is this information in trace file:

[10920]{200364}[63/-1] 2020-04-29 21:39:42.371778 i Authorization    SQLFacade.cpp(02614) : User SYSTEM is missing valid privilege SELECT for TABLE SAPABAP1.LFA1
[10920]{200364}[63/-1] 2020-04-29 21:39:42.371845 i Authorization    query_check.cc(04796) : User SYSTEM tried to execute 'SELECT TOP 1000 * FROM "SAPABAP1"."LFA1"'
[10797]{200350}[60/4435677] 2020-04-29 21:40:06.831068 i TraceContext     TraceContext.cpp(01114) : UserName=SYSTEM, ApplicationUserName=    , ApplicationName=HDBStudio, ApplicationSource=csns.sql.editor.SQLExecuteFormEditor$4$1.run(SQLExecuteFormEditor.java:938);, StatementHash=c59b52c215b48ac5ae6df71ef9317e08, StatementExecutionID=844433520158239
[10797]{200350}[60/4435677] 2020-04-29 21:40:06.831047 i SQLSessionCmd    Statement.cc(07360) : INI configuration is changed by 200350, client ip=192.168.0.13, client port=14860, query=alter system alter configuration ('indexserver.ini','SYSTEM') unset
 ('trace','authorization') with reconfigure

Oliver was right. I am really connected via SYSTEM user, because my SIDADM user is missing in HANA Studio. (on OS level is working).

Could you help me? I used this step by step guide for installation S/4 HANA IDES

link

legend:

HID - HANA db, instance 00

HIA - application server

HIF - frontend server

my host: hanaides

ip: 192.168.0.18

[Olda]

Any idea what is wrong?

[Olda]

Hello, user is shown as SYSTEM, but I conected as SIDADM - in my case HIDADM. I checked

SAPHANADB user too, but it seems that there is not between users.

user2.jpg

[ORU]

Hi John,

it seems that the user SYSTEM has not the corresponding rights for seen all schemas (it is correct) Please try again with user SAPHANADB and check.

regards Oliver

[Olda]

Could be the reason some authorization issue? But I am connecting to DB via database user.

[Olda]

When I logged into client 400 and check table LFA1, there are data

[former_member291029]

Hi John,

looks really strange for me. Any chance that you upload the installation-logs here?

BR,

Jan

[Olda]

Do you advice where I find them in Linux?

[former_member291029]

Hi,

can you please check in Schema SAP<SID>?

I crossed checked in ourcurrent system and could find the table there.

BR,

Jan

[Olda]

There are only these "folders". Schema is missing

[Olda]

Can I display data in Hana Studio?

[former_member291029]

Hi John,

please check in client 400.

This is the default client for IDES!

BR,

Jan

[Olda]

I know but I want to check it in Hana Studio and there is not possible to choose client

[JoergWolf]

Hi John,

which system/release do you mean (there is no IDES shipment anymore at least for the recent S/4HANA releases) ?
If it's about the S/4HANA Fully-Activated Appliance: look in schema SAPHANADB in HANA Studio (user SAPHANADB / <Your Master Password of the CAL Instance>)

Best, Joerg

[Olda]

Hello Joerg, it is S/4HANA IDES 1610. It is available at launchapad.support.sap.com