Guest

Preview Tool

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
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.