Adding phones via BAT; IP SERVICE PARAMETER :: Error : Cannot insert a null into column (telecastersubscribedparameter.fktelecasterserviceparameter).

[mazenelhourani]

Hi team,

I am using the BAT to export phones from one server to another one. I reconfigured everything from CSS, Partitions, gateways, etc.. etc..

I have 253 phones, I succeeded to insert back (full details) around 175 phones and I still have 58 phones which are giving the following error:

IP SERVICE PARAMETER :: Error :            Cannot insert a null into column  (telecastersubscribedparameter.fktelecasterserviceparameter).

I am stuck there, all the phones services have been added to the new server. I think it's a something in the service parameters but I don't know where.

Thanks in advance for you help guys!

Regards,

Mazen

[phooghen]

There is a bug related to the error message you are getting:

CSCsu97248   Cannot insert null into a null column TelecasterSubscribedParameter

Symptom:
 
 Receiving error Insert Phones fails with an error "IP service parameter error,
cannot insert a null into a column. Description: TelecasterSubscribed
Parameter.FKTelecasterServiceParameter".
 
 Conditions:
 
 This can occur if you are trying to insert phones with a service subscriber
from an exported phone csv. Parameters were not exported along with correct
services. For ex, if Service1 does not have any parameters and Service2 has
some parameters then Service2's parameters would get associated with Service1.

 
 Workaround:
 
 Edit the exported file for the service parameters and place them against the
correct Phone services.
 In this case the text file has Phone Service - "Cisco Meeting Place" 's
parameters associated to Extension Mobility.
 So associate the correct parameters to the service and import the edited text
file.