Guest

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

appserv-8.1.4-1

Description (partial)

Symptom:
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

Conditions:
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 Cisco.com 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.