From: Becker, Holger (holger.beckersap.com)
Date: Mon Mar 08 2004 - 10:16:27 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]