Preview Tool

Cisco Bug: CSCvi53853 - idm SQL Error -239 on process restart - Log Noise

Last Modified

Apr 05, 2018

Products (1)

  • Headend System Releases

Known Affected Releases


Description (partial)

idm log shows SQLERR -239 after process restart.

To reproduce:

1) Migrate system from SR7.0 to 8.0 or above
2) Ensure VASP entry values have been re-created to be non-default (with migration)
3) restart appServer processes
4) restart dncs Processes (should include idm)
5) verify IDM log output

VASP entry values have been recreated with migration to replace the default VASP entries - this is for pre-SR 8.0 migration to SR 8.0 and above.

After restarting appserver processes, if dncs processes are restarted (including idm) the below error is observed.

"03/19/2018 10:56:41.411|31876/31876/0xf499e840|SYSLOG|libloggingApi:LogService.C(214)|Program started idm
03/19/2018 10:56:41.414|31876/31876/0xf499e840|SYSLOG|libcommUtil:RPC_Svc.C(1191)|7RPC_Svc@0x5715d6a0 progNum(0x52ffe440/1392501824.2) host(localhost) fd(256) port(56969) xprt=0x5715d9d0 serving program number: 0x52ffe440/1392501824on fd(256)
03/19/2018 10:56:41.414|31876/31876/0xf499e840|SYSLOG|libcommUtil:RPC_Svc.C(1769)|7RPC_Svc@0x5715d6a0 progNum(0x52ffe440/1392501824.2) host(localhost) fd(256) port(56969) xprt=0x5715d9d0 Transient program number selected: 0x52ffe440/1392501824
03/19/2018 10:56:41.417|31876/1326/0xf3fffb40|SYSLOG|libcommUtil:RPC_Svc.C(1191)|26Callee_RemoteFunctorCall_2@0x5715d6a0 progNum(0x52ffe440/1392501824.2) host(localhost) fd(256) port(38971) xprt=0xf3600728 serving program number: 0x52ffe440/1392501824on fd(256)
03/19/2018 10:56:41.433|31876/31876/0xf499e840|INFO|libkeyCertificate:KeyCertificate.C(650)|Root CA Cert verified OK, adding to cache 0x57182ab0 C=US;O=Scientific-Atlanta;OU=Suite C;CN=12345:23456
03/19/2018 10:56:41.436|31876/31876/0xf499e840|SYSLOG|libcommUtil:RPC_Svc.C(1191)|7RPC_Svc@0xffcaab48 progNum(0x20000999/536873369.2) host(localhost) fd(257) port(58259) xprt=0x57182fa8 serving program number: 0x20000999/536873369on fd(257)
03/19/2018 10:56:44.103|31876/31876/0xf499e840|ERROR|libemEsql:dbPdVASP.ecpp(886)|::insert SQLERR[ -239 ]: OPEN <s7019_1> STATEMENT  sqlca.sqlerrm=Unique Index:spnsapaddress_idx SQLSTATE=23000 SQLCODE=-239 Integrity constraint violation
03/19/2018 10:56:44.103|31876/31876/0xf499e840|ERROR|idm:IdmBossFuncs.C(3523)|bossInsertSvcProvider(DncsMsg *msg) /dbPdVASP.ecpp:889[PS_DBError:5106] Attempt to insert a duplicate key into table "sp_profile"."
Bug details contain sensitive information and therefore require a account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.