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


Message: CREATE PROCEDURE rroad_..._properties failed ... Item 'rroad_..._properties' already exists

Explanation: There are two or more sampling sessions with the same target database, possibly because there are two or more different ODBC DSNs or connection strings that point to the same target database.

When you upgrade Foxhound to a new build, each sampling session tries to update the three Foxhound properties procedures on its target database, and only one attempt will work for each target.

You will see three or more error messages along with the three successful "Info:" exceptions:

2010-06-25 04:32:58.531 Full Build 3706a 1000000006 701.a3(701eh2) CREATE PROCEDURE rroad_engine_properties failed. SQLSTATE = WO005, ERRORMSG() = Server 'p002': [Sybase][ODBC Driver][SQL Anywhere]Item 'rroad_engine_properties' already exists
2010-06-25 04:32:58.531 Full Build 3706a 1000000005 204.d1b(204eh-b6) Info: Procedure rroad_engine_properties has been upgraded from build number 3705 to 3706 on aaa3 ddd11 dba sql
2010-06-25 04:37:21.437 Full Build 3706a 1000000026 702.a3(702eh2) CREATE PROCEDURE rroad_database_properties failed. SQLSTATE = WO005, ERRORMSG() = Server 'p001': [Sybase][ODBC Driver][SQL Anywhere]Item 'rroad_database_properties' already exists
2010-06-25 04:37:21.437 Full Build 3706a 1000000027 204.d6b(204eh-b9) Info: Procedure rroad_database_properties has been upgraded from build number 3705 to 3706 on sales
2010-06-25 04:37:21.687 Full Build 3706a 1000000027 204.e2b(204eh-c3) Info: Procedure rroad_connection_properties has been upgraded from build number 3705 to 3706 on sales
2010-06-25 04:37:21.703 Full Build 3706a 1000000026 700.a3(700eh2) CREATE PROCEDURE rroad_connection_properties failed. SQLSTATE = WO005, ERRORMSG() = Server 'p001': [Sybase][ODBC Driver][SQL Anywhere]Item 'rroad_connection_properties' already exists
It is safe to ignore these error messages, but you might want to check why you have a redundant sampling session; i.e., should it point to a different target database?

See also...
How do I see Foxhound diagnostics, errors and exceptions?


This page was last updated on July 8, 2010.      Foxhound 1.1 FAQ      Foxhound Home      RisingRoad      Breck.Carter@gmail.com