Symptoms

The error, "Use of the executeUpdate(String) method is not supported on this type of statement," is found in the uptime.log file during the time of the upgrade. This error also appears each time you attempt to start the Uptime Data Collector service.

Solutions

Please choose from the following solutions based on the platform used by your UIM Datastore. 

Upgrading to Uptime 7.6 with a MS SQL datastore

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.

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 UIM database.
  3. Try starting the UIM Data Collector service again. It fails, but does perform some necessary upgrade steps.
  4. Run the SQL statements contained in uptime76_patch_mssql_1_alter.sql.
  5. Once the statements from uptime76_patch_mssql_1_alter.sql are complete, run the statements in uptime76_patch_mssql_2_update.sql.
  6. Start the UIM Data Collector and 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 UIM 7.6 from version 7.5 build 19 using a MySQL datastore, but upgrades from UIM 7.4 and 7.5 build 22 should complete successfully.

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. Open the MySQL client and run:
    cd <uptime_dir>
    mysql\bin\mysql -uuptime puptime -P3308 --protocol=tcp -A uptime
  3. Run the SQL statements contained in revert75.sql in the MySQL client.
  4. Start the UIM Data Collector and UIM 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 UIM versions upgrading to version 7.6.

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. Run the SQL statements contained in revert75.sql in the Oracle Uptime database.
  3. Try starting the UIM Data Collector service again. It fails, but performs some necessary upgrade steps.
  4. Run the SQL statements contained in uptime76_patch_oracle.sql.
  5. Start the UIM Data Collector and UIM Controller services (or uptime_core and uptime_controller on Linux) Uptime should start properly now.

Attachment

Uptime7_6_scripts.zip

  • No labels