Symptom
You are connected to MaxDB database via DBMCLI or SQLCLI but when you are executing command to select table from /SAPAPO/ORDMAP or any other tables from MaxDB Live Cache, it’s keep failing.
dbmcli on PRD>sql_execute select LOGSYS, count(*) from "SAPR3"."/SAPAPO/ORDMAP" group by logsys ERR -24988,ERR_SQL: SQL error -4004,Unknown table name:/SAPAPO/ORDMAP ---
Solution
There are might be multiple reason for this. Follow below steps to ensure you are executing on the right steps and procedures.
1. Logout from your MaxDB instance database and try to connect again using below sequence. Ensure your control and superdba password are working fine.
ITSITI> dbmcli -d PRD -u control,control
dbmcli on PRD> sql_connect superdba, admin
2. Execute below command to list all the DBM operator and database user on your MaxDB database. From the output, the Live Cache user is SAPPRD. FYI, user SAPR3 is not used anymore for MaxDB 7.5 >. The newer version of MaxDB will be using the SAPSID.
dbmcli on PRD>sql_execute select * from users OK END 'CONTROL';'';'CONTROL';'ADMIN';'MULTIPLE';(null);(null); 'SUPERDBA';'';'SUPERDBA';'SYSDBA';'MULTIPLE';(null);(null); 'SUPERDBA';'';'SAPPRD';'DBA';'MULTIPLE';(null);(null); ---
3. Now, execute below command to connect as the SAPPRD user. Try to execute the command again. Hopefully, this will helps!
dbmcli on PRD> sql_connect sapprd,password
dbmcli on PRD>sql_execute select LOGSYS, count(*) from "SAPPRD"."/SAPAPO/ORDMAP" group by logsys OK END ITSITI00;5435 ARA_30;621 UMICL400;434 CICCL100;12324
4. Alternative to above steps, you can also find the table /SAPAPO/ORDMAP or any SQL table of Live Cache from your SAP (SCM/APO) itself. This can be done via transaction code LC10. Enter your database connection and choose Live Cache : Monitoring with DBA Cockpit. Under Diagnostics > Database Objects. Double click on Tables/Views/Synonyms. Press F8 or execute. The next page will have the details, information on the table.
