Assert failed: multiple view entries

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)
        at
com.mckoi.database.jdbc.MStatement.executeQueries(MStatement.java:190)
        at 
com.mckoi.database.jdbc.MStatement.executeQuery(MStatement.java:164)
        at
com.mckoi.database.jdbc.MStatement.executeQuery(MStatement.java:219)

CAUSE: java.lang.RuntimeException: Assert failed:
multiple view entries for APP.vWlisa0
        at
com.mckoi.database.ViewManager.findViewEntry(ViewManager.java:131)
        at
com.mckoi.database.ViewManager.deleteView(ViewManager.java:203)
        at
com.mckoi.database.DatabaseConnection.dropView(DatabaseConnection.java:754)
        at
com.mckoi.database.interpret.ViewManager.evaluate(ViewManager.java:205)
        at
com.mckoi.database.interpret.SQLQueryExecutor.execute(SQLQueryExecutor.java:147)
        at
com.mckoi.database.jdbcserver.AbstractJDBCDatabaseInterface.execQuery(AbstractJDBCDatabaseInterface.java:461)
        at
com.mckoi.database.jdbcserver.JDBCDatabaseInterface.execQuery(JDBCDatabaseInterface.java:251)
        at
com.mckoi.database.jdbcserver.JDBCProcessor.queryCommand(JDBCProcessor.java:352)
        at
com.mckoi.database.jdbcserver.JDBCProcessor.processQuery(JDBCProcessor.java:293)
        at
com.mckoi.database.jdbcserver.JDBCProcessor.processJDBCCommand(JDBCProcessor.java:196)
        at
com.mckoi.database.jdbcserver.StreamJDBCServerConnection.processRequest(StreamJDBCServerConnection.java:133)
        at
com.mckoi.database.jdbcserver.MultiThreadedConnectionPoolServer$1.run(MultiThreadedConnectionPoolServer.java:171)
        at
com.mckoi.database.WorkerThread.run(WorkerThread.java:123)

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


______________________________________________________________________ 
Post your free ad now! http://personals.yahoo.ca


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