Unknown table name

[Former Member]

Hello.

After opening the SQL studio I get the following error.

-

---

Error -

---

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

Base table not found;-4004 POS(21) Unknown table name:SYS_MYAUTOSUPPOSE.

SELECT SUPPOSE FROM SYSDBA.SYS_MYAUTOSUPPOSE WHERE TYPE = 0

I've checked - such table does not exist.

Should I create it manually?

If so, what are its parameters (columns)?

Thank Yyou, LUCAS.

[Former Member · Accepted solution]

Hello,

you can download a SQL Studio version 7.6 from

http://dev.mysql.com/downloads/maxdb/7.6.00.html

Regards

Wolfgang

[Former Member · Accepted solution]

OK. It works fine. Thank You.

[Former Member]

Hello,

the table SYS_MYAUTOSUPPOSE is a SQL Studio system table which was used in a previous version of SQL Studio (7.5). In new database releases the table does not exist. Please install the newest SQL Studio. The newest version of SQL Studio does not need the table SYS_MYAUTOSUPPOSE.

Regards

Wolfgang

[Former Member]

It may be the reason.

I have downloaded 7.4 version.

Where I can download the newest version from?

Thank You, Lucas.

[Former Member]

Hi Lucas,

can you tell me the MAXDB version/build, as well as the SQL Studio version and patch level?

After this error, is SQL Studio connecting to the database? Can you see other objects in MAXDB?

Thanks,

Ashwath