Page History

...

There is a known issue upgrading to UIM 7.6 from all supported versions of UIM. This issue can be verified by checking for the error, "Use of the executeUpdate(String) method is not supported on this type of statement," in the uptime.log file during the time of the upgrade and the error also appears each time you attempt to start the Data Collector service.

To resolve, please perform the following steps. Each .sql file mentioned is attached to this article. For more information, see Starting (or restarting) and Stopping Uptime Infrastructure Monitor.

To resolve this issue

1. Stop the UIM Data Collector and UIM Controller services (or uptime_core and uptime_controller on Linux).
2. Execute the SQL statements contained in revert75.sql in the MS SQL Uptime UIM database.
3. try Try starting the up.time UIM Data Collector service again. It will fail but will have performed fails, but does perform some necessary upgrade steps.
4. run Run the SQL statements contained in uptime76_patch_mssql_1_alter.sql.
5. once Once the statements from uptime76_patch_mssql_1_alter.sql are complete, run the statements in uptime76_patch_mssql_2_update.sql.
6. start Start the up.time UIM Data Collector and up.time UIM Controller services (or uptime_core and uptime_controller on Linux). Uptime should start properly now.

Upgrading to

...

UIM 7.6 from

...

UIM 7.5 build 19 with a MySQL datastore

There is an issue upgrading to Uptime 7.6 from up.time 7.5 build 19 using a MySQL datastore but upgrades from up.time 7.4 and up.time 7.5 build 22 should complete successfully. To resolve the issue experienced with up.time 7.5 build 19, perform the following steps. Each .sql file mentioned is attached to this article. Please see this document for starting and stopping the services: http://docs.uptimesoftware.com/x/z4BF

...

1. execute the SQL statements contained in revert75.sql in the MySQL client
2. start the up.time Data Collector and up.time Controller services (or uptime_core and uptime_controller on Linux) Uptime should start properly now.

Upgrading to

...

UIM 7.6 with

...

an Oracle datastore

A similar issue to the one seen with MS SQL datastores exists with Oracle datastores. This issue affects all supported up.time versions upgrading to Uptime 7.6. To resolve, perform the following steps. Each .sql file mentioned is attached to this article. Please see this document for starting and stopping the services: http://docs.uptimesoftware.com/x/z4BF

1. stop the up.time Data Collector and up.time Controller services (or uptime_core and uptime_controller on Linux)
2. execute the SQL statements contained in revert75.sql in the Oracle Uptime database
3. try starting the up.time Data Collector service again. It will fail but will have performed some necessary upgrade steps
4. run the SQL statements contained in uptime76_patch_oracle.sql
5. start the up.time Data Collector and up.time Controller services (or uptime_core and uptime_controller on Linux) Uptime should start properly now.

Attachment

Uptime7_6_scripts.zip