Threshold Profiles are not generating events
search cancel

Threshold Profiles are not generating events

book

Article ID: 412547

calendar_today

Updated On:

Products

Network Observability Spectrum

Issue/Introduction

EMService.log logs errors:

ERROR | pool-6-thread-1147       | 2025-08-28 10:46:59,939 | com.ca.im.portal.em.inv.NPCInventoryPoller                      
      | Exception during poll.
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [REPLACE INTO items (ItemID,ItemFlags,ItemTypeName,ItemSubTypeName,SourceID,LocalID,ItemName,ItemDesc,UpdatedOn, ItemType,ItemSubType) VALUES (100,16,'group',
.......
; SQL state [HY000]; error code [1366]; Incorrect string value: '\xEF\xBF\xBDa d...' for column 'LocalID' at row 124; nested exception is java.sql.SQLException: Incorrect string value: '\xEF\xBF\xBDa d...' for column 'LocalID' at row 124
      at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1542) ~[spring-jdbc-5.3.28.jar:5.3.28]
      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:667) ~[spring-jdbc-5.3.28.jar:5.3.28]
      at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:960) ~[spring-jdbc-5.3.28.jar:5.3.28]
      at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:1015) ~[spring-jdbc-5.3.28.jar:5.3.28]
      at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:1025) ~[spring-jdbc-5.3.28.jar:5.3.28]
      at com.ca.im.portal.api.common.services.impl.database.JdbcOperationsDelegate.update(JdbcOperationsDelegate.java:359) ~[portal-api-impl.common.services.impl-23.3.13-RELEASE-4.jar:?]
      at com.ca.im.portal.api.common.services.impl.database.TransientDBConnection.execute(TransientDBConnection.java:437) ~[portal-api-impl.common.services.impl-23.3.13-RELEASE-4.jar:?]
      at com.ca.im.portal.em.dao.mysql.MySqlInventoryDao.processItems(MySqlInventoryDao.java:783) ~[classes/:?]
      at com.ca.im.portal.em.inv.NPCInventoryPoller.processInventory(NPCInventoryPoller.java:256) ~[classes/:?]
      at com.ca.im.portal.em.inv.NPCInventoryPoller.pullInventory(NPCInventoryPoller.java:206) ~[classes/:?]
      at com.ca.im.portal.em.inv.NPCInventoryPoller.poll(NPCInventoryPoller.java:109) [classes/:?]
      at com.ca.im.portal.em.util.PollCycleTask.runPollingSteps(PollCycleTask.java:99) [classes/:?]
      at com.ca.im.portal.em.util.PollCycleTask.run(PollCycleTask.java:69) [classes/:?]
      at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:?]
      at java.util.concurrent.FutureTask.run(Unknown Source) [?:?]
      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:?]
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:?]
      at java.lang.Thread.run(Unknown Source) [?:?]
Caused by: java.sql.SQLException: Incorrect string value: '\xEF\xBF\xBDa d...' for column 'LocalID' at row 124
      at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) ~[com.mysql.connector-java-commercial-8.4.0.jar:8.4.0]
      at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:113) ~[com.mysql.connector-java-commercial-8.4.0.jar:8.4.0]
      at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:938) ~[com.mysql.connector-java-commercial-8.4.0.jar:8.4.0]
      at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1106) ~[com.mysql.connector-java-commercial-8.4.0.jar:8.4.0]
      at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1045) ~[com.mysql.connector-java-commercial-8.4.0.jar:8.4.0]
      at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1369) ~[com.mysql.connector-java-commercial-8.4.0.jar:8.4.0]
      at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1030) ~[com.mysql.connector-java-commercial-8.4.0.jar:8.4.0]
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4]
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4]
      at org.springframework.jdbc.core.JdbcTemplate.lambda$update$2(JdbcTemplate.java:965) ~[spring-jdbc-5.3.28.jar:5.3.28]
      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:651) ~[spring-jdbc-5.3.28.jar:5.3.28]
      ... 16 more

Environment

any supported Performance Management release

Cause

 

The core of the error message is:
Incorrect string value: '\xEF\xBF\xBDa d...' for column 'LocalID' at row 124

The 124th set of values in your log is:
(171,0,'group','automatic',4,'Special charts like ñ','Special charts like ñ','Special charts like ñ',1753963438,1,1)

Looking at this specific set of values for the items table columns:

  • ItemID: 171
  • ItemFlags: 0
  • ItemTypeName: 'group'
  • ItemSubTypeName: 'automatic'
  • SourceID: 4
  • LocalID: 'Special charts like ñ'
  • ItemName: 'Special charts like ñ'
  • ItemDesc: 'Special charts like ñ'
  • UpdatedOn: 1753963438
  • ItemType: 1
  • ItemSubType: 1

The problematic string is 'Campaa ' in the LocalID field. The ` character (represented as\xEF\xBF\xBD`) is the Unicode replacement character, which MySQL outputs when it encounters a byte sequence that it cannot interpret correctly based on the column's character set.

 

Resolution

1. Delete the Global Collection with a special Spanish characters in Spectrum and recreate it without using the special character

2. Execute full Spectrum and Data Aggregator sync 

Powered by Wolken Software