Encountering "Base Table not found" error

[Former Member]

Hi,

I am encountering this error when trying to view the content of the table in MaxDB studio:

Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed

Base table not found;-4004 POS(16) Unknown table name:GRC_DM_AE_BSUBPROT.

SELECT * FROM "SAPAJ4DB"."GRC_DM_AE_BSUBPROT"

This is happening to all the tables I try to view. SQL queries yield the same error. I am not a DBA, so any support is appreciated.

Thanks!

Ankur

SAP GRC RIG

[former_member229109 · Accepted solution]

Hello Ankur,

Did you connect to the database as SAPAJ4DB to run the SQL statement?

Please update the thread with output of the SQL statement:

u201Cselect * from usersu201D

Thank you and best regards, Natalia Khlopina

[former_member366047 · Accepted solution]

Natalia,

I connected to the DB as SUPERDBA.

Here is the output:

CONTROL CONTROL ADMIN MULTIPLE ? ? ? DEFAULT 2009-10-01 19:54:32 2009-10-01 19:54:32 2009-10-01 19:54:32 AJ4 iwdf4112 0 NO ?

SUPERDBA SUPERDBA SYSDBA MULTIPLE ? ? ? DEFAULT 2009-10-01 19:54:32 2010-01-05 00:54:00 2009-10-01 19:54:32 AJ4 iwdf4112 10 NO ?

SUPERDBA SAPAJ4DB DBA SINGLE ? ? ? UNICODE 2009-10-01 19:54:45 2010-01-05 00:54:25 2009-12-21 21:41:21 AJ4 iwdf4112 28 NO ?

SUPERDBA SAP_TEMP DBA SINGLE ? ? ? DEFAULT 2009-12-22 00:22:11 2009-12-22 21:43:10 2009-12-22 00:22:11 AJ4 iwdf4112 29 NO ?

Thanks!

Ankur

SAP GRC RIG

[former_member229109 · Accepted solution]

Hello Ankur,

please connect to the database as SAPAJ4DB to check the application tables.

Please post the output of the SQL statement connected as superdba user:

"select tablename from tables where owner = 'SAP_TEMP' "

"select tablename from tables where owner = 'SAPAJ4DB' "

Thank you and best regards, Natalia Khlopina

[former_member366047 · Accepted solution]

Natalia,

This are the outputs:

Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed

Column not found;-4005 POS(8) Unknown column name:GRC_DM_CC_RISK.

select GRC_DM_CC_RISK from tables where owner = 'SAP_TEMP'

Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed

Column not found;-4005 POS(8) Unknown column name:GRC_DM_CC_RISK.

select GRC_DM_CC_RISK from tables where owner = 'SAPAJ4DB'

When I tried connecting as SAPAJ4DB, I get a "-8022 POS(1) User already connected" error.

Thanks!

Ankur

SAP GRC RIG

[former_member366047 · Accepted solution]

Natalia,

Please let me know if you want access to the DB that I am having issues with. I will email you the credentials. Thanks!

Ankur

SAP GRC RIG

[lbreddemann · Accepted solution]

> When I tried connecting as SAPAJ4DB, I get a "-8022 POS(1) User already connected" error.

That's because this user was created as exclusive session user.

Run "alter user SAPAJ4DB not exclusive" as superdba to allow multiple parallel sessions.

regards,

Lars

[former_member229109 · Accepted solution]

Hello Ankur,

1. The question is why you had the SAPAJ4DB user in the single mode?

What is the version of your system?

What is the current status of the system?

What is the version of the database?

2. Please post the output of the SQL statements:

"select tablename from tables where owner = 'SAP_TEMP' "

"select tablename from tables where owner = 'SAPAJ4DB' "

What the table GRC_DM_CC_RISK for?

3. Could you create the Internal message & send me the servername info to login to the database & check the status.

Thank you and best regards, Natalia Khlopina

Greetings from PA PAL08 to PA PAL05:)

[former_member366047 · Accepted solution]

Natalia,

I just assigned the internal CSS message to you and provided all the login details for the DB. Please let me know if you need anything else via email.

Thanks!

Ankur

SAP GRC RIG

[Former Member]

Hi Ankur,

You can see the table by using the following command.

Connect as dba user

SELECT * FROM SAPAJ4DB.GRC_DM_AE_BSUBPROT

not

SELECT * FROM "SAPAJ4DB"."GRC_DM_AE_BSUBPROT"

Can you please try and let us know the result ?

Regards.

Rajesh Narkhede

[Former Member]

Hi,

pPerhaps one should explain some basics about privileges in the database.

You connected as sysdba, named superdba.

The table(s) you are looking for have been created by the user SAPAJ4DB.

If a user creates a table, noone !!, really noone is allowed to select them except this owner.

Not even the sysdba is allowed to select them.

And it is good that it is like this. I personally do have some private info in tables and do NOT

want to let them being seen by my boss being the sysdba of the db.

If the owner wants to allow access to this table, he has to grant privileges to other users.

There are select, insert, update, delete ( to name the DML-privileges ).

If the owner of the table you are looking for, did not do this, the sysdba is not allow to see them.

And then he will receive the error -4004.

Yes, the table DOES exist. But for the user not having a privileges for this table,

this table looks like not existing, causing this error to occur.

Therefore: connect as the owner, select there what you want.

And then think about your needs and grant the corresponding privileges to other users / the sysdba.

Have a nice weekend,

Elke