Troubleshooting illegal characters

If you see an error message about illegal characters in insert statements into the topology database, follow these steps to troubleshoot the problem.

If you have network devices with characters in their descriptions that are not allowed in the locale set in the database, you might see an error message similar to the following:

Warning: W-RIV-002-206: [4115626896t] CMdlDbEntityMgr.cc(647) A database 'execute' operation has failed : SQLRETURN = -1 CNcpODBCSth.cc line 233 : [<database>][<database> ODBC Driver][<database>]An illegal character has been found in the statement.
  1. Back up and edit the SnmpStackSchema.cfg file.
  2. Locate the line that configures an insert into the snmpStack.conversionCfg table and edit it to the following: 
    insert into snmpStack.conversionCfg values (1);
  3. Save and close the file.
The SNMP Helper substitutes characters returned from devices that are not allowed in the database locale with the question mark character: '?'.

The SNMP Helper substitutes characters on only those objects that are configured in the snmpStack.multibyteObjects table.