[cisco-voip] Insert Phones > Missing key in referenced table for referential constraint (informix.fk_blfspeeddial_fknumplan).

[Ryan Ratliff (rratliff)]

Does the import really take "xxx in partition" for the DN?  The blfspeeddial table has an fknumplan reference and unless something is doing that conversion correctly that looks like an area ready to fail your insert.

What do the bps logs say?

-Ryan

On Jul 30, 2013, at 9:30 AM, Jason Aarons (AM) <jason.aarons at dimensiondata.com<mailto:jason.aarons at dimensiondata.com>> wrote:


I’m not spotting the problem, the phone SEPb4e9b08cd4ac goes in but not a single of the 5 BLFs go in. Identical problem on all the BLFs.  If I manually go add them and Export it looks identical.  Only the Insert fails.

<image001.png>



Screen capture from Notepad++;

<image002.png>



Insert Phones - All Details

Begin Time : 07/29/2013 19:37:59

Query :

Insert Phones in /common/bps/csvfiles/phones/insert/all/Import-072813.csv

Failure Details :

MAC Address/Device Name Error Code Error Description

-----------------------------------------------------------------------------------------

SEP8875567a68b8 Index: 1, Size: 1

SEPb4e9b08cd4ac BLF :: Error : Missing key in referenced table for referential constraint (informix.fk_blfspeeddial_fknumplan).


_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20130730/87a73759/attachment.html>