[cisco-voip] DMA 4.1.3 to 6.1.4
Wes Sisk
wsisk at cisco.com
Fri Jul 9 10:57:47 EDT 2010
Hi Johnny,
Note the device name: SEP9CAFCHFFEEE7
For 7942 (tkProduct 333) the require format for the devicename is:
admin:run sql select first 10 * from typeproduct where enum = 333
enum name moniker tkmodel maxports showindropdown
devicenameformat isinstalleddefault devicenamestring
==== ========== ================== ======= ======== ==============
================================= ================== ================
333 Cisco 7942 PRODUCT_CISCO_7942 434 0 t
([sS][eE][pP]|BAT)[0-9a-fA-F]{12} f SEP[mac]
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.
/Wes
On Thursday, July 08, 2010 5:27:50 PM, <Johnny.Crothers at datacraft.co.nz>
wrote:
>
> Thanks for the reply Wes,
>
>
>
> 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 J
>
>
>
> 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?
>
>
>
> Row: 1968 SQL error: -746(491)
>
> Warning message (Business Rule Violation): The specified name has
> invalid characters or is not formatted correctly for this device type.
>
> pkid
> df998bc5-1d10-42e6-8df6-54d81cd10c8f NOT MODIFIABLE
>
> Name SEP9CAFCHFFEEE7
>
> Description SEP9CAFCHFFEEE7
>
> tkModel 434 NOT MODIFIABLE
>
> tkDeviceProtocol 0
>
> tkProtocolSide 1
>
> SpecialLoadInformation
>
> fkDevicePool
> 7360b332-14fc-4f56-8c20-929d7a966ab0
>
> fkPhoneTemplate 2706004c-154b-4c25-9137-d21d17f80dfe
>
> fkCallingSearchSpace 4544d8da-914f-405a-a0c5-cfc41ba0597d
>
> CtiID 1968 NOT MODIFIABLE
>
> tkClass 1
>
> fkProcessNode NOT MODIFIABLE
>
> DefaultDTMFCapability 10
>
> fkLocation
> 48d00e7c-68e1-4f6b-b8e1-ffa1c9a97590
>
> tkProduct 333
>
> DialPlanWizardGenID
>
> DeviceLevelTraceFlag false
>
> fkEndUser
>
> AllowHotelingFlag true
>
> tkDeviceProfile 0
>
> ikDevice_DefaultProfile bcb4ab32-26a3-4e84-9a5c-4a91a6304740
>
> fkMediaResourceList
>
> UserHoldMOHAudioSourceID
>
> NetworkHoldMOHAudioSourceID
>
> Unit 0
>
> SubUnit 0 NOT MODIFIABLE
>
> XML
>
> tkCountry
>
> tkUserLocale
>
> tkProduct_Base
>
> fkCallingSearchSpace_AAR
>
> fkAARNeighborhood
>
> fkSoftkeyTemplate adee351c-b4db-49d1-9be3-f9d21b9832c6
>
> retryVideoCallAsAudio false
>
> RouteListEnabled false
>
> fkCallManagerGroup
>
> tkStatus_MLPPIndicationStatus 2
>
> tkPreemption 2
>
> tkStatus_BuiltInBridge 2
>
> mTPRequired false
>
> tkQSIG 4 NOT MODIFIABLE
>
> tkPacketCaptureMode 0
>
> PacketCaptureDuration 60
>
> AuthenticationString
>
> tkCertificateStatus 1
>
> UpgradeFinishTime
>
> fkMlppDomain
>
> TransmitUTF8 false
>
> ignorePI false
>
> tkNetworkLocation 0
>
> V150ModemRelayCapable false
>
> tkCertificateOperation 1
>
> fkSecurityProfile
> 93cbc0f2-6135-4dab-b5d8-4df04f45e274
>
> fkDialRules
>
> fkCallingSearchspace_reroute
>
> fkCallingSearchspace_refer
>
> unattended_port false
>
> tkDTMFSignaling 1
>
> requireDTMFReception false
>
> publicKey
>
> fkSIPProfile
>
> RFC2833Disabled false
>
> AllowCTIControlFlag true
>
> DateTimeInserted
>
> sshpassword
>
> sshuserID
>
> fkCallingSearchspace_restrict
>
> fkMatrix_Presence
> ad243d17-98b4-4118-8feb-5ff2e1b781ac
>
> fkCommonPhoneConfig
> ac243d17-98b4-4118-8feb-5ff2e1b781ac
>
> tkkeyauthority 0
>
> tkSIPCodec_MTPPreferredOrigCodec 1
>
> md5hash
>
> SRTPAllowed false
>
> isStandard false NOT MODIFIABLE
>
> resetToggle false
>
> tkReset 2
>
> VersionStamp
> 1278596784-a97509fe-cfea-4207-8452-f3c97b2b1cd7
>
> fkCommonDeviceConfig 321d0d25-9f15-439b-9b5f-3fc583cd1864
>
> huntListForVM false
>
> remoteDevice false
>
> tkStatus_DeviceMobilityMode 2
>
> DNDTimeout 0
>
> tkDNDOption 0
>
> tkRingSetting_DND
>
> IsDualMode false NOT MODIFIABLE
>
> fkCallingSearchspace_CgPNTransform
>
> fkEndUser_Mobility
>
> tkOutboundCallRollover 0
>
> tkPhonePersonalization 3
>
> tkStatus_joinacrosslines 2
>
> tkBarge 3
>
> ikDevice_PrimaryPhone
>
> tkStatus_AudibleAlertingIdle 2
>
> tkStatus_AudibleAlertingBusy 2
>
> IsActive true
>
> tkStatus_AlwaysUsePrimeLine 2
>
> tkStatus_AlwaysUsePrimeLineForVM 2
>
>
>
> Kind Regards,
>
>
>
> Johnny
>
>
>
> *From:* Wes Sisk [mailto:wsisk at cisco.com]
> *Sent:* Friday, July 09, 2010 1:58 AM
> *To:* Johnny Crothers at Professional Services at DCNZ-WLG
> *Cc:* cisco-voip at puck.nether.net
> *Subject:* Re: [cisco-voip] DMA 4.1.3 to 6.1.4
>
>
>
> 2 errors, 271 and 27157. Thanks to
> CSCsq37173 CLI to allow usage of "finderr" & "cdr finderr"
>
> <quote>
> admin:show tech dberrcode 271
> ------------------------- show tech dberrcode --------------------------
> -271 Could not insert new row into the table.
> This problem has many possible causes, including a locked table or a
> full disk. Check the accompanying ISAM error code for more
> information.
> If the error code is related to cdr, errorcode means
> 271 *Error* <271> is not a known Enterprise Replication error
>
> admin:show tech dberrcode 27157
> ------------------------- show tech dberrcode --------------------------
> -27157 Internal error: no receiving buffer available.
> If this internal error recurs, note all circumstances and
> contact IBM Technical Support.
> If the error code is related to cdr, errorcode means
> 27157 *Error* <27157> is not a known Enterprise Replication error
> </quote>
>
> 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?
>
> 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.
>
> /Wes
>
> On Wednesday, July 07, 2010 5:41:38 PM,
> <Johnny.Crothers at datacraft.co.nz>
> <mailto:Johnny.Crothers at datacraft.co.nz> wrote:
>
> Hi everyone,
>
>
>
> Good ole DMA...
>
>
>
> Has anyone seen this error before?
>
>
>
> ***> DATA PROCESSING TESTS REVEALED AN ISSUE WHICH GENERATED THE
> FOLLOWING EVENT:
>
> The error number is: [-271]
>
> The error message is: [-27157 Internal error: no
> receiving buffer available.
>
> ]
>
> The following additional event information is available:
>
> This is a transient error related to DMA/DB
> data access issues.
>
> It is a general issue. While possibly related
> to the record / request being processed,
>
> it does not indicate a problem with that
> record / request.
>
> DMA was unable to perform migration testing
> due to a failure accessing the data.
>
> This may have been due to resource constraints
> on the system or other activity.
>
> SUGGESTED ACTION: Re-boot the server and
> re-execute DMA.
>
> Sorry. Unable to parse and format record info from log
> message. Raw Message follows:
>
> [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.|
>
> ]
>
>
>
> ***> DATA PROCESSING TESTS REVEALED AN ISSUE WHICH GENERATED THE
> FOLLOWING EVENT:
>
> Sorry. Unable to parse and identify error number. Raw
> Message follows:
>
> 07/07/2010 22:12:39.759 installdb| installFull *ERROR*
> Prior Cancel or Error Processing installCsv
> (c:\tmp\dbinstalldir\dbtables)|
>
> Cheers,
>
>
>
> Johnny
>
>
>
>
> *****************************************************************************
> This email and all contents are subject to the following disclaimer:
>
> http://www.datacraft-asia.com/disclaimer
> *****************************************************************************
>
>
> ------------------------------------------------------------------------
>
>
>
>
> _______________________________________________
> 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
>
>
>
>
> *****************************************************************************
> This email and all contents are subject to the following disclaimer:
>
> http://www.datacraft-asia.com/disclaimer
> *****************************************************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20100709/d2e3580b/attachment.html>
More information about the cisco-voip
mailing list