Cisco Bug: CSCul56439 - When deleting a range of extensions from a location : " ERROR: updat
Last Modified
Jan 12, 2014
Products (1)
- Cisco Hosted Collaboration Solution (HCS)
Known Affected Releases
8.1(3)
Description (partial)
Symptom: Details: " ERROR: update or delete on table "fintinventory" violates foreign key constraint "fintfeature_providername_fkey1" on table "fintfeature" DETAIL: Key (providername, fintnumber)=(BT-COMMERCIAL, 2011002008001) is still referenced from table "fintfeature"." BT is trying delete the extensions from 8000 to 8008 on location "OG_00_2ND_LINE_SUPPORT" from their system when they get this error. I found this SQL that is causing the issue ... DELETE FROM fintinventory WHERE providername = 'BT-COMMERCIAL' AND resellername = 'BT-COMMERCIAL' AND companyname = 'LOCOG' AND divisionname = 'LOCOG' AND locationname = 'OG_00_2ND_LINE_SUPPORT' AND location_id = '219' AND linetype <> 'UNREG' AND extension BETWEEN '8000' AND '8008'; So I took a closer look and found that the following SQL returns 211 lines ... SELECT COUNT(*) FROM fintfeature WHERE providername = 'BT-COMMERCIAL' AND locationname = 'OG_00_2ND_LINE_SUPPORT'; Prerequisites: 1.BT database 2.Attempt to delete a LOCOG location. 3. Actual Results: The database throws a contraint problem. Expected Results: The fints should be deleted. Conditions: Details: " ERROR: update or delete on table "fintinventory" violates foreign key constraint "fintfeature_providername_fkey1" on table "fintfeature" DETAIL: Key (providername, fintnumber)=(BT-COMMERCIAL, 2011002008001) is still referenced from table "fintfeature"." BT is trying delete the extensions from 8000 to 8008 on location "OG_00_2ND_LINE_SUPPORT" from their system when they get this error. I found this SQL that is causing the issue ... DELETE FROM fintinventory WHERE providername = 'BT-COMMERCIAL' AND resellername = 'BT-COMMERCIAL' AND companyname = 'LOCOG' AND divisionname = 'LOCOG' AND locationname = 'OG_00_2ND_LINE_SUPPORT' AND location_id = '219' AND linetype <> 'UNREG' AND extension BETWEEN '8000' AND '8008'; So I took a closer look and found that the following SQL returns 211 lines ... SELECT COUNT(*) FROM fintfeature WHERE providername = 'BT-COMMERCIAL' AND locationname = 'OG_00_2ND_LINE_SUPPORT'; Prerequisites: 1.BT database 2.Attempt to delete a LOCOG location. 3. Actual Results: The database throws a contraint problem. Expected Results: The fints should be deleted.
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