Re: Assert failed: multiple view entries

Hi,

You can delete both the duplicate views from the sUSRView system table 
with the following query;

   DELETE FROM SYS_INFO.sUSRView
    WHERE "schema" = 'APP' AND "name" = 'vWlisa0'

You should also delete the grant information for the view from the 
sUSRGrant table with the following query;

   DELETE FROM SYS_INFO.sUSRGrant
    WHERE "param" = 'APP.vWlisa0'

Before modifying the system tables make sure you backup the database. 
After you have made the changes, shutdown and restart the database.

Can you think of anything specific that may have caused the duplicate 
view entries to occur?  Did you run the repair tool before the error 
started?  In some cases the repair tool can cause duplicate record 
entries to occur.

Toby.


Hendrik Schwachenwalde wrote:
> In my program I create a view that is recreated every
> time the program is run. Therefore before recreating
> the view (vWlisa0) the prog issues the command DROP
> VIEW vWlisa0.
> After running the prog succesfully a couple hundred
> times I suddenly get the following error:
> 
> com.mckoi.database.jdbc.MSQLException: Assert failed:
> multiple view entries for APP.vWlisa0
>         at
> com.mckoi.database.jdbc.RemoteDatabaseInterface.execQuery(RemoteDatabaseInterface.java:280)
>         at
> com.mckoi.database.jdbc.MConnection.executeQuery(MConnection.java:442)
>         at
> com.mckoi.database.jdbc.MConnection.executeQueries(MConnection.java:425)
> 
> A check of SYS_INFO.sUSRTableInfo reveals indeed two
> entries for the VIEW vWlisa0 !!!
> I ran the repair tool to no avail. I am still running
> 1.0.2 as a server. How do I get rid of the additional
> view? I don't dare switching to 1.0.3 while the db is
> still corrupted.
> 
> Has anyone else encountered such a problem? I searched
> but couldn't find any references.
> 
> Hendrik


---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]