Filip Sergeys wrote: > All of a sudden it has become impossible for certain dbusers to select > from tables in the sys schema. > As a result, in sql studio, it is not possible to browse the > tables list > in the catalog manager. Also it is not possible in Ms Access > to link to > maxdb via odbc because we cannot get the list of tables. Al fail with > exact the same error message. But the same user is still able > to select > data from his own tables. > Now, the strange thing is that user dba still can select from > tables in > the sys schema and can connect with Ms Access. > I checked the knldiag en knldiag.err files but there is > nothing relevant > about this in it. > It seems to have started after I deleted a massive amount of data from > the database (I deleted the primary key build up of 5 columns > from a 10 > million record table). This took very very long to run, that > is the only > indication I have. > > Where and how can I check what is happening. I already used the "check > database structure ,..." in the Data Manager. It did not report any > specific problems. > > The dbversion is 7.5.0 > The OS is SuSE linux 9.0 Prof.
Hi, it looks like a problem with the catalog information of the dbusers. Please post a vtrace of a select with the error perhaps this will bring some ligth into the darkness. Information about vtrace and how to create it you'll find here: http://sapdb.2scale.net/moin.cgi/VTrace Best regards, Holger SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
