Skip to main content
NetApp Response to Russia-Ukraine Cyber Threat
In response to the recent rise in cyber threat due to the Russian-Ukraine crisis, NetApp is actively monitoring the global security intelligence and updating our cybersecurity measures. We follow U.S. Federal Government guidance and remain on high alert. Customers are encouraged to monitor the Cybersecurity and Infrastructure Security (CISA) website for new information as it develops and remain on high alert.

NetApp KCS Award

NetApp Knowledge Base

OnCommand Insight inline upgrade or restore of backup from a previous version to 7.3.11 shows an error in the upgrade.log, error: "Duplicate entry '6' for key 'system_alert_config.PRIMARY'"

Views:
36
Visibility:
Public
Votes:
0
Category:
oncommand-insight
Specialty:
oci
Last Updated:

Applies to

OnCommand Insight 7.3.11

Issue

After performing an inline upgrade of OnCommand Insight (OCI) to 7.3.11 or restoring a database backup from a previous version to a 7.3.11 instance, the application appears to work fine, but an error in the upgrade.log is observed.

Further review shows that the database schema upgrade was not completed, which is indicated by the following symptoms:

  • When navigating to Admin -> System Alerts in the web UI, there is no "Duplicate WWN detected" system alert present
  • When navigating to https://<OCI_SERVER_IP>/uiserver/#admin/advancedTroubleshooting/tools, there is no option PHONE_HOME_TIMEZONE_SHIFT_HOURS option present
  • Review of the upgrade.log file reveals an error during the schema upgrade process

2021-05-07 00:13:12,363 ERROR [main] UpgradeAll (UpgradeAll.java:347) - Failed to inline upgrade schema Failed to restore 
com.onaro.sanscreen.upgrade.UpgraderException: Failed to restore 
    at com.onaro.sanscreen.upgrade.UpgradeRunner.restore(UpgradeRunner.java:1423) ~[upgrade.jar:?]
    at com.onaro.sanscreen.upgrade.UpgradeAll.inlineUpgradeSchema(UpgradeAll.java:345) [upgrade.jar:?]
    at com.onaro.sanscreen.upgrade.UpgradeAll.main(UpgradeAll.java:773) [upgrade.jar:?]
Caused by: com.onaro.sanscreen.upgrade.UpgraderException: Failed to executeUpdateEx:  INSERT INTO sanscreen.system_alert_config VALUES (6, '6', 'Duplicate WWN detected', 'CRITICAl', '', '259200', 0, 0);
Reason: Duplicate entry '6' for key 'system_alert_config.PRIMARY'
    at com.onaro.sanscreen.upgrade.UpgradeRunner$UpgraderEntry.run(UpgradeRunner.java:2084) ~[upgrade.jar:?]
    at com.onaro.sanscreen.upgrade.UpgradeRunner.run(UpgradeRunner.java:1622) ~[upgrade.jar:?]
    at com.onaro.sanscreen.upgrade.UpgradeRunner.restore(UpgradeRunner.java:1406) ~[upgrade.jar:?]
    ... 2 more
Caused by: com.netapp.oci.platform.common.table.TableException: Failed to executeUpdateEx:  INSERT INTO sanscreen.system_alert_config VALUES (6, '6', 'Duplicate WWN detected', 'CRITICAl', '', '259200', 0, 0);
Reason: Duplicate entry '6' for key 'system_alert_config.PRIMARY'
    at com.netapp.oci.platform.common.table.PreparedStatementWrapper.executeUpdateEx(PreparedStatementWrapper.java:341) ~[serverbase-common.jar:?]
    at com.netapp.oci.platform.common.db.SqlFile.executeFile(SqlFile.java:44) ~[serverbase-common.jar:?]
    at com.onaro.sanscreen.upgrade.UpgradeRunner$UpgraderEntry.run(UpgradeRunner.java:2081) ~[upgrade.jar:?]
    at com.onaro.sanscreen.upgrade.UpgradeRunner.run(UpgradeRunner.java:1622) ~[upgrade.jar:?]
    at com.onaro.sanscreen.upgrade.UpgradeRunner.restore(UpgradeRunner.java:1406) ~[upgrade.jar:?]
    ... 2 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '6' for key 'system_alert_config.PRIMARY'
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117) ~[mysql-connector-java-commercial.jar:8.0.22]
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-commercial.jar:8.0.22]
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-commercial.jar:8.0.22]
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) ~[mysql-connector-java-commercial.jar:8.0.22]
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092) ~[mysql-connector-java-commercial.jar:8.0.22]
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1040) ~[mysql-connector-java-commercial.jar:8.0.22]
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1347) ~[mysql-connector-java-commercial.jar:8.0.22]
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1025) ~[mysql-connector-java-commercial.jar:8.0.22]
    at com.netapp.oci.platform.common.table.PreparedStatementWrapper.executeUpdateEx(PreparedStatementWrapper.java:336) ~[serverbase-common.jar:?]
    at com.netapp.oci.platform.common.db.SqlFile.executeFile(SqlFile.java:44) ~[serverbase-common.jar:?]
    at com.onaro.sanscreen.upgrade.UpgradeRunner$UpgraderEntry.run(UpgradeRunner.java:2081) ~[upgrade.jar:?]
    at com.onaro.sanscreen.upgrade.UpgradeRunner.run(UpgradeRunner.java:1622) ~[upgrade.jar:?]
    at com.onaro.sanscreen.upgrade.UpgradeRunner.restore(UpgradeRunner.java:1406) ~[upgrade.jar:?]
    ... 2 more

 

Scan to view the article on your device
CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support