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 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...
Connecting to Target Databases