where is IPCC ext stored

Sascha Monteiro · ‎06-28-2009

Hi,

I need to set IPCC extension in cucm 5, does anyone know where it's stored in the DB?

stephan.steiner · ‎07-09-2009

Did you check the data dictionary for CCM5? It's probably not enduser but one of the table that links user with extensions.

Alternatively, this might help you figure it out: during off hours, enable debug level traces of the database layer monitor, then look at a user in ccmadmin. To display the user, the admin page will perform a bunch of SQL queries which should show up in the debug level traces - I often turn on debug level traces when I have an issue with AXL and the error message AXL returns doesn't tell me anything.. looking at what is done behind in the database can be very useful in at least figuring out where the problem might lie.

Sascha Monteiro · ‎07-10-2009

I have found it;

bugid: CSCsv31967

In 5.x and later the DN associations to users are in the EndUserNumPlanMap table. There's a tkDNUsage field in the map that allows different types of DN associations:

Enum,Moniker,Name

DOUBLE,VARCHAR(0),DOUBLE

0,DN_USAGE_UNDEF,Undefined

1,DN_USAGE_PRIMARY,Primary

2,DN_USAGE_ICD,ICD

ICD / IPCC share data, right?

The Primary DN assocation in AXL maps to EndUserNumPlanMap record with tkDNUsage = 1. An IPCC extension should be available in AXL corresponding to EndUserNumPlanMap record with tkDNUsage = 2.

ckarawani · ‎03-04-2019

Anyone know what the 0 value means and how such an entry can be generated in the informix database?