Question: CREATE PROCEDURE rroad_..._properties failed ... Item 'rroad_..._properties' already exists
Answer: 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:
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?
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
How do I see Foxhound diagnostics, errors and exceptions?