<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Johnny,<br>
<br>
Note the device name: SEP9CAFCHFFEEE7<br>
<br>
For 7942 (tkProduct 333) the require format for the devicename is:<br>
admin:run sql select first 10 * from typeproduct where enum = 333<br>
enum name moniker tkmodel maxports showindropdown
devicenameformat isinstalleddefault devicenamestring <br>
==== ========== ================== ======= ======== ==============
================================= ================== ================ <br>
333 Cisco 7942 PRODUCT_CISCO_7942 434 0 t
([sS][eE][pP]|BAT)[0-9a-fA-F]{12} f SEP[mac] <br>
<br>
Note that "H" is not a valid hexadecimal character and is not included
in [a-f] or [A-F]. Those devices would have status "unknown" because
they likely have never registered. Phones are hard coded to use their
mac address as device name. H is not a valid hex character so this
cannot be a real device name for a real phone.<br>
<br>
/Wes<br>
<br>
On Thursday, July 08, 2010 5:27:50 PM,
<a class="moz-txt-link-rfc2396E" href="mailto:Johnny.Crothers@datacraft.co.nz"><Johnny.Crothers@datacraft.co.nz></a> wrote:<br>
<blockquote
cite="mid:A0C4637C20DE02419E6142E16FE6835704BD3685@nz-wlg-exmb01.Datacraft-Asia.Com"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
        {font-family:Wingdings;
        panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
        {font-family:Wingdings;
        panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
        {font-family:Consolas;
        panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";
        color:black;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
pre
        {mso-style-priority:99;
        mso-style-link:"HTML Preformatted Char";
        margin:0in;
        margin-bottom:.0001pt;
        font-size:10.0pt;
        font-family:"Courier New";
        color:black;}
span.EmailStyle17
        {mso-style-type:personal;
        color:black;}
span.HTMLPreformattedChar
        {mso-style-name:"HTML Preformatted Char";
        mso-style-priority:99;
        mso-style-link:"HTML Preformatted";
        font-family:Consolas;
        color:black;}
span.EmailStyle20
        {mso-style-type:personal-reply;
        font-family:"Arial","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page WordSection1
        {size:595.3pt 841.9pt;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
        {page:WordSection1;}
-->
</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">Thanks
for the reply Wes,<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">I’m
assuming that something was trying to use the DB at the time
this was run. I rebooted as per the solution and it fixed the issue,
simple as
that </span><span
style="font-size: 10pt; font-family: Wingdings; color: rgb(31, 73, 125);">J</span><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">Although,
now that that has been fixed, I’m now getting some
warnings which i cant decipher, I’ve checked the names and they are
device
names so not entirely sure why that are coming up as warnings, any
idea’s?<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">Row:
1968 SQL error: -746(491)<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
Warning message (Business Rule Violation): The specified name
has invalid characters or is not formatted correctly for this device
type.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
pkid
df998bc5-1d10-42e6-8df6-54d81cd10c8f NOT MODIFIABLE<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
Name SEP9CAFCHFFEEE7<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
Description SEP9CAFCHFFEEE7<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkModel 434 NOT
MODIFIABLE<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkDeviceProtocol 0<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkProtocolSide 1<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
SpecialLoadInformation <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
fkDevicePool 7360b332-14fc-4f56-8c20-929d7a966ab0<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
fkPhoneTemplate 2706004c-154b-4c25-9137-d21d17f80dfe<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
fkCallingSearchSpace 4544d8da-914f-405a-a0c5-cfc41ba0597d<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
CtiID 1968 NOT MODIFIABLE<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkClass 1<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
fkProcessNode NOT
MODIFIABLE<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
DefaultDTMFCapability 10<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
fkLocation
48d00e7c-68e1-4f6b-b8e1-ffa1c9a97590<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkProduct 333<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
DialPlanWizardGenID <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
DeviceLevelTraceFlag false<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
fkEndUser <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
AllowHotelingFlag true<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkDeviceProfile 0<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
ikDevice_DefaultProfile bcb4ab32-26a3-4e84-9a5c-4a91a6304740<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
fkMediaResourceList <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
UserHoldMOHAudioSourceID <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
NetworkHoldMOHAudioSourceID <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
Unit 0<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
SubUnit 0 NOT
MODIFIABLE<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
XML <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkCountry <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkUserLocale <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkProduct_Base <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
fkCallingSearchSpace_AAR <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
fkAARNeighborhood <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
fkSoftkeyTemplate adee351c-b4db-49d1-9be3-f9d21b9832c6<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
retryVideoCallAsAudio false<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
RouteListEnabled false<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
fkCallManagerGroup <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkStatus_MLPPIndicationStatus 2<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkPreemption 2<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkStatus_BuiltInBridge 2<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
mTPRequired false<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkQSIG 4 NOT MODIFIABLE<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkPacketCaptureMode 0<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
PacketCaptureDuration 60<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
AuthenticationString <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkCertificateStatus 1<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
UpgradeFinishTime <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
fkMlppDomain <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
TransmitUTF8 false<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
ignorePI false<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkNetworkLocation 0<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
V150ModemRelayCapable false<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkCertificateOperation 1<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
fkSecurityProfile 93cbc0f2-6135-4dab-b5d8-4df04f45e274<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
fkDialRules <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
fkCallingSearchspace_reroute <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
fkCallingSearchspace_refer <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
unattended_port false<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkDTMFSignaling 1<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
requireDTMFReception false<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
publicKey <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
fkSIPProfile <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
RFC2833Disabled false<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
AllowCTIControlFlag true<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
DateTimeInserted <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
sshpassword <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
sshuserID <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
fkCallingSearchspace_restrict <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
fkMatrix_Presence ad243d17-98b4-4118-8feb-5ff2e1b781ac<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
fkCommonPhoneConfig
ac243d17-98b4-4118-8feb-5ff2e1b781ac<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkkeyauthority 0<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkSIPCodec_MTPPreferredOrigCodec 1<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
md5hash <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
SRTPAllowed false<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
isStandard false NOT
MODIFIABLE<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
resetToggle false<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkReset 2<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
VersionStamp
1278596784-a97509fe-cfea-4207-8452-f3c97b2b1cd7<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
fkCommonDeviceConfig 321d0d25-9f15-439b-9b5f-3fc583cd1864<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
huntListForVM false<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
remoteDevice false<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkStatus_DeviceMobilityMode 2<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
DNDTimeout 0<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkDNDOption 0<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkRingSetting_DND <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
IsDualMode false NOT
MODIFIABLE<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
fkCallingSearchspace_CgPNTransform <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
fkEndUser_Mobility <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkOutboundCallRollover 0<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkPhonePersonalization 3<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkStatus_joinacrosslines 2<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkBarge 3<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
ikDevice_PrimaryPhone <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkStatus_AudibleAlertingIdle 2<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkStatus_AudibleAlertingBusy 2<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
IsActive true<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkStatus_AlwaysUsePrimeLine 2<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">
tkStatus_AlwaysUsePrimeLineForVM 2<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">Kind
Regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);">Johnny<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<div>
<div
style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p class="MsoNormal"><b><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif"; color: windowtext;"
lang="EN-US">From:</span></b><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif"; color: windowtext;"
lang="EN-US">
Wes Sisk [<a class="moz-txt-link-freetext" href="mailto:wsisk@cisco.com">mailto:wsisk@cisco.com</a>] <br>
<b>Sent:</b> Friday, July 09, 2010 1:58 AM<br>
<b>To:</b> Johnny Crothers@Professional Services@DCNZ-WLG<br>
<b>Cc:</b> <a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>
<b>Subject:</b> Re: [cisco-voip] DMA 4.1.3 to 6.1.4<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">2 errors, 271 and 27157. Thanks to<br>
CSCsq37173 CLI to allow usage of "finderr" &
"cdr finderr" <br>
<br>
<quote><br>
admin:show tech dberrcode 271<br>
------------------------- show tech dberrcode
--------------------------<br>
-271 Could not insert new row into the table.<br>
This problem has many possible causes, including a locked table or a<br>
full disk. Check the accompanying ISAM error code for more<br>
information.<br>
If the error code is related to cdr, errorcode means <br>
271 *Error* <271> is not a known Enterprise Replication error<br>
<br>
admin:show tech dberrcode 27157<br>
------------------------- show tech dberrcode
--------------------------<br>
-27157 Internal error: no receiving buffer available.<br>
If this internal error recurs, note all circumstances and<br>
contact IBM Technical Support.<br>
If the error code is related to cdr, errorcode means <br>
27157 *Error* <27157> is not a known Enterprise Replication
error<br>
</quote><br>
<br>
DMA does not invoke replication so we can ignore that. Are you low on
disk space? Are low on available memory either physical, virtual, or
kernel?<br>
<br>
There really shouldn't be anything concurrently accessing the informix
instance
for DMA. It is possible an entierprising adminstrator was accessing
the
database. Before embarking on a lengthy troubleshooting endeavor it
may
be worth a reboot and re-run of DMA.<br>
<br>
/Wes<br>
<br>
On Wednesday, July 07, 2010 5:41:38 PM, <a moz-do-not-send="true"
href="mailto:Johnny.Crothers@datacraft.co.nz"><Johnny.Crothers@datacraft.co.nz></a>
wrote:<br>
<br>
<o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";">Hi
everyone,</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";">Good
ole DMA...</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";">Has
anyone seen this error before?</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";">***>
DATA PROCESSING TESTS REVEALED AN ISSUE WHICH GENERATED THE FOLLOWING
EVENT: </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";">
The error number is: [-271]</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";">
The error message is: [-27157 Internal error: no receiving
buffer available.</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";">]</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";">
The following additional event information is available: </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";">
This is a transient error related to DMA/DB data access issues. </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";">
It is a general issue. While possibly related to the record / request
being processed, </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";">
it does not indicate a problem with that record / request. </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";">
DMA was unable to perform migration testing due to a failure accessing
the
data. </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";">
This may have been due to resource constraints on the system or other
activity. </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";">
SUGGESTED ACTION: Re-boot the server and re-execute DMA. </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";">
Sorry. Unable to parse and format record info from log message. Raw
Message follows:</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";">
[07/07/2010 22:12:38.040 installdb|*ERROR* Error executing "Insert into
crsapplication ( aakeypadmapping, aapromptname, fkenduser,
fnamealtpronun,
lnamealtpronun, pkid ) values ('453669254766', 'GlennyAlison',
'7ec81be3-a8c4-4282-8389-148f4c812d5a', '', '',
'40191cd3-25c0-4d71-91db-912409c1289b' )": [Informix][Informix ODBC
Driver][Informix]Unspecified System Error = -271.|</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";">]</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";">***>
DATA PROCESSING TESTS REVEALED AN ISSUE WHICH GENERATED THE FOLLOWING
EVENT: </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";">
Sorry. Unable to parse and identify error number. Raw Message
follows:</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";">
07/07/2010 22:12:39.759 installdb| installFull *ERROR* Prior Cancel
or Error Processing installCsv (c:\tmp\dbinstalldir\dbtables)|</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";">Cheers,</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";">Johnny</span><o:p></o:p></p>
<div>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";"> </span><o:p></o:p></p>
</div>
<pre><o:p> </o:p></pre>
<pre>*****************************************************************************<o:p></o:p></pre>
<pre>This email and all contents are subject to the following disclaimer:<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre><a moz-do-not-send="true"
href="http://www.datacraft-asia.com/disclaimer">http://www.datacraft-asia.com/disclaimer</a><o:p></o:p></pre>
<pre>*****************************************************************************<o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre style="text-align: center;">
<hr align="center" size="4" width="90%">
</pre>
<pre><o:p> </o:p></pre>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>cisco-voip mailing list<o:p></o:p></pre>
<pre><a moz-do-not-send="true"
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><o:p></o:p></pre>
<pre><a moz-do-not-send="true"
href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a><o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<pre>
*****************************************************************************
This email and all contents are subject to the following disclaimer:
<a class="moz-txt-link-freetext" href="http://www.datacraft-asia.com/disclaimer">http://www.datacraft-asia.com/disclaimer</a>
*****************************************************************************
</pre>
</blockquote>
<br>
</body>
</html>