Livecache table doesn't exist

[Former Member]

Hello,

I've scheduled the task Update Statistics for Selected Tables on DB13 and I'm always getting an error that says:

ERROR : SELECT schemaname, tabname FROM "/MAXDB/UPDSTATS"

rc = -942 (POS(34) Unknown table name:/MAXDB/UPDSTATS)

I've tried to looking for this table but It doesn't exist "schema"."/MAXDB/UPDSTATS" Not Found

What differente there between this task and Update All Optimizer Statistics?

Regards.

[former_member229109]

Hello,

Did you select the tables with option
"Mark tables requiring statistics update" before running the job
"Update statistics for marked tables"?

To help you further with this case => create the SAP message to BC-DB-LVC component and get SAP support.

Regards, Natalia Khlopina

[Former Member]

Hello Natalia,

Where can I select previously the tables for statistics update before running the job?

Regards.

[former_member229109]

Hello,

- What liveCache tables are you planning to update statistics?

To help you further with this case => create the SAP message to BC-DB-LVC component and get SAP support.

Regards, Natalia Khlopina