CallManager 8x Bulk Admin > Users > Update Users (from .csv file) fails

Unanswered Question
Sep 22nd, 2010
User Badges:
  • Bronze, 100 points or more

CallManager 8x Bulk Admin > Users > Update Users (from .csv file)

In Job Scheduler I get a failure with below error (note jaarons is the userid, we are AD LDAP integrated),  users are already in End Users, however I’m trying to associate a UDP to the End Users, I’m ignoring some fields using #

jaarons Missing key in referenced table for referential constraint (informix.fk_enduser_fkcallingsearchspace_restrict).

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Jason Aarons Mon, 02/06/2012 - 07:34
User Badges:
  • Bronze, 100 points or more

Can’t find a bug in the toolkit, running CallManager 8.5.(1)SU3


Users > Update Users- Custom File


Fix, can’t leave Template’s Subscribe Calling Search Space set to , can’t put in .csv column with Subscribe Calling Search Space set to #, and NULL doesn’t work either. Only fix is to change template from to something.


http://www.gossamer-threads.com/lists/cisco/voip/137710


If template subscribe css is set to or use Column in csv with # you get;

1001 Missing key in referenced table for referential constraint (informix.fk_enduser_fkcallingsearchspace_restrict).

1015 Missing key in referenced table for referential constraint (informix.fk_enduser_fkcallingsearchspace_restrict).

1055 Missing key in referenced table for referential constraint (informix.fk_enduser_fkcallingsearchspace_restrict).


If in the .csv you create column Subscribe Calling Search Space set to NULL

1001 Missing key in referenced table for referential constraint (informix.fk_enduser_fkcallingsearchspace_restrict).

1015 SUBSCRIBE CALLING SEARCH SPACE : NULL does not exist.

Actions

This Discussion