|
Message: Item 'rroad_..._properties' already exists
Explanation: If you see this message when you are reloading your target database after unloading it, just press Continue to ignore it and proceed:
You may see three consecutive messages; press Continue to ignore each one:
Could not execute statement.
Item 'rroad_engine_properties' already exists
SQLCODE=-110, ODBC 3 State="42S01"
Line 4643, column 1
You can continue executing or stop.
Could not execute statement.
Item 'rroad_database_properties' already exists
SQLCODE=-110, ODBC 3 State="42S01"
Line 4774, column 1
You can continue executing or stop.
Could not execute statement.
Item 'rroad_connection_properties' already exists
SQLCODE=-110, ODBC 3 State="42S01"
Line 4880, column 1
You can continue executing or stop.
|
Here's what might have happened:
-
The Foxhound Monitor was set up to gather samples from your target database.
You decided to unload, recreate and reload that database.
When you unloaded the database, the reload.sql file included CREATE PROCEDURE statements for the three procedures named in the error messages above.
When you started the new database, but before you had a chance to run the reload.sql file, the Foxhound Monitor connected to the new (empty) database.
The Foxhound Monitor then immediately ran its own CREATE PROCEDURE statements for those three procedures. See
Help - Introduction - Connecting to Target Databases
for more information about this process.
When you ran the the reload, it could not execute the CREATE PROCEDURE statements in the reload.sql file because those procedures already existed.
Since they are already there, just press Continue to ignore the messages...
...or, edit the reload.sql file to remove the three CREATE PROCEDURE statements.
See also...
Help - Introduction - Connecting to Target Databases
|