-4004,Unknown table name or unknown schema

[Former Member]

Hi,

I want to create statistics for table "SAP<SID>"."D010LINF".

The command in transaction DB13 shown is:

UPDATE STAT "SAP<SID>"."D010LINF" ESTIMATE

But the job aborts with a

rc = -942 (POS(1) Unknown table name)

or

-4004,Unknown table name or unknown schema

Other tables could be refreshed.

But if I start a select * from "SAP<SID>"."D010LINF" I get data (all with the same user).

In se11 and se14 everything is fine.

I droped the index and recreated it but nothing helped!

I reloaded the system tables again, but this did not help.

What could be the problem?

Thanks.

Best regards

Christian

[Former Member · Accepted solution]

Hi,

I could fix it myself.

I updated the tobdo flag in dbstatc for the views blocking the update statistics run.

Now everything is fine.

Best regards

Christian