[cisco-voip] DMA 4.1.3 to 6.1.4

Johnny.Crothers at datacraft.co.nz Johnny.Crothers at datacraft.co.nz
Thu Jul 8 17:27:50 EDT 2010


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
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/2a84fbee/attachment.html>


More information about the cisco-voip mailing list