Guest

Preview Tool

Cisco Bug: CSCvu21350 - Error : 143 Intercom Default Device cannot be a Device Profile or BAT Template

Last Modified

Sep 01, 2020

Products (1)

  • Cisco Unified Communications Manager (CallManager)

Known Affected Releases

12.5(1.12900.115)

Description (partial)

Symptom:
CUCM version 12.X shows the below error when trying to insert or update a user device Profile (UDP) via BULK and the UDP has an intercom line with the "Default Activated Device" configured. 
-------------------
Error : 143 Intercom Default Device cannot be a Device Profile or BAT Template.
-------------------

[+] From the BPS logs: 
 
2020-05-05 22:00:00,394 DEBUG [Thread-11] common.LogWrapper  - phone-SqlPhone::fnExecuteSql|Error code : 143
java.sql.SQLException: 143
	at com.informix.jdbc.IfxSqli.addException(Unknown Source)
	at com.informix.jdbc.IfxSqli.receiveError(Unknown Source)
	at com.informix.jdbc.IfxSqli.dispatchMsg(Unknown Source)
	at com.informix.jdbc.IfxSqli.receiveMessage(Unknown Source)
	at com.informix.jdbc.IfxSqli.sendStatementExecute(Unknown Source)
	... 17 more
2020-05-05 22:00:00,409 DEBUG [Thread-11] common.LogWrapper  - phone-SqlPhone::fnExecuteSql|Exception : java.sql.SQLException: 143
2020-05-05 22:15:30,411 DEBUG [Thread-11] common.LogWrapper  - DBManager::getDBErrorMessage|Query : SELECT name FROM typedberrors WHERE enum ='143'
2020-05-05 22:00:00,417 DEBUG [Thread-11] common.LogWrapper  - SummaryLog::writeResultDetails|The first element is :8252975-UDP
2020-05-05 22:00:00,417 DEBUG [Thread-11] common.LogWrapper  - SummaryLog::writeResultDetails|The second element is :INTERCOM-LINE :: Error : 143
2020-05-05 22:00:00,417 DEBUG [Thread-11] common.LogWrapper  - SummaryLog::writeResultDetails|The third element is :Intercom Default Device cannot be a Device Profile or BAT Template.
2020-05-05 22:00:00,417 DEBUG [Thread-11] dbl.Connector  - Attempting to close connection

Conditions:
Error received when trying to update the user device profiles via BULK following these steps:

1) UCM admin > Bulk > UDP > Export UDP > All Details. Then Bulk Admin> Upload/Download> Select the file exported> Download. 
2) Open the txt file and confirm that one of the profiles has a phone under the column "Default Activated Device 1"
3) Apply the changes to the file (.txt) and then upload it to the CUCM. Bulk > UDP > Insert UDP> Check "Insert User Device Profiles All Details"  then select the uploaded file> check "Override the existing configuration"> Run immediately. 
4) Navigate to  Bulk Administration> Job Scheduler. The error will be shown in the report. 

Note: The issue happens even if you do not add/ modify any attribute in the txt file, the only condition is to have something configured under the "Default Activated Device 1" column.
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.