Foxhound 3.0 FAQ
Foxhound 3.0 FAQ Home      Foxhound Home      RisingRoad           Breck.Carter@gmail.com     


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


This page was last updated on December 30, 2010.      Foxhound 3.0 FAQ Home      Foxhound Home      RisingRoad      Breck.Carter@gmail.com