Bertram Gerteisen wrote: > > I think I've got a corrupted catalog. When connecting with > SQLStudio it > gives the error: > SQL Studio does not support the catalog view when connected > to databases > prior to 7.3.0 > > As mentioned in http://lists.mysql.com/maxdb/9612 I tried to send the > query: > Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed > Base table not found;-4004 POS(23) Message not available:TABLES. > SELECT TABLETYPE FROM DOMAIN.TABLES WHERE TABLENAME = 'TABLES' > > Is there a way to repair or recreate the catalog? > > I'm using SAPDB7.4.3.27
Hi, for me it looks like a missing load_systab. Error -4004 is :unknown table name. and the view TABLES is created during load_systab (loading the systemtables). And therefore I do not think that your catalog (with your user-data) is corrupt, just the systemtables/views are missing respectively too old. Loading the systemtables anew should help. Otherwise please let us know. Elke SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
