[cisco-voip] DMA Warnings

[Wes Sisk]

Hi Pete,

1)  the user was deleted but the user profile still exists.  easiest 
thing is to delete the user profile in DCDirectory.  The user-profile is 
based off the username, but then random string appended, so add user or 
add/delete user is not likely to fix this.  It's mostly harmless though, 
user profile should not be ported.

2) you will need to run some SQL to figure out what's going on here:
select * from device where pkid like '%2a9f9c5a1cff%'
and investigate that device.

a bit of info (devicetype) from:
select * from typemodel where enum=124


3) more sql required. devices which do not support EM should not have a 
device profile
select * from device where pkid like '%c5afee95f747%'
and investigate that device

Backup your database and server before performing any direct SQL 
commands or modifications.  you may be better off contacting TAC to 
assist with the cleanup.

/Wes

On 9/26/2008 12:56 PM, Ruttman, Pete G. wrote:
>
> I am attempting to get a clean DMA fro 4.1(3) to 6.1(2).  I have 
> managed to clean up a lot of items, but here is a sample of the 
> remaining warnings I cannot figure out what to do next.  Anyone run 
> into these?
>
> 1) Warning: PersonalAddressBook: EndUser PAAdministrator not found. 
> Invalid user. 
> PAB-DN=cn=PAAdministrator1125670333868,ou=PersonalAddressBook,ou=PAAdministrator_info,ou=user_info,ou=CCN,o=cisco.com
>
> Condition: Either the user does not exist in the directory or has been 
> tagged invalid
>
> Solution: Please verify that the user exists in the directory and is a 
> valid CCM user; ie. User with profiles
>
> (So, do I really just create a Global User called PAAdministrator and 
> that'll fix this one?)
>
>
> 2) Table: DeviceAddOnModuleMap                2008-09-26 03:02:18
>
>    Row: 47 SQL error: -746(2304)
>    Warning message (Business Rule Violation): This type of expansion 
> module is not supported by this device.
>       pkid                       
> 0a31acea-57de-476f-b9ef-070a1ba3e293    NOT MODIFIABLE
>       fkDevice                   8a208480-7447-451a-a641-2a9f9c5a1cff
>       ModuleIndex                1
>       SpecialLoadInformation    
>       tkModel                    124
>
>
> (We have 32 of these and the only correlation I have to that number is 
> the number of 7906 phones we have. I cannot find the pkid in the 
> devices table.  Is there some other table I can cross-reference to see 
> where these expansion modules are attached to?)
>
> 3) Table: Telecaster                          2008-09-26 03:56:54
>
>    Row: 367 SQL error: -746(423)
>    Warning message (Business Rule Violation): Device Profile can only 
> be created for devices that support Extension Mobility feature.
>
>       pkid                       
> da0730af-3842-4a2b-8a10-0828bdb24432    NOT MODIFIABLE
>       fkDevice                   cc9e804a-1ee1-48b1-ba64-c5afee95f747
>       DirectoryServicesURL1     
>       DirectoryServicesURL2     
>       VoiceMailURL1             
>       VoiceMailURL2             
>       IdleURL                   
>       IdleTimeout               
>       ProxyURL                  
>       AuthenticationURL  
>
> (I can't find another table that this warning connects to either.  I 
> only have two.  Perhaps they are just orphaned?)
>
>
> Thanks for any help,
>
> Pete Ruttman
> Foley & Lardner, LLP
>
>  
>
> The preceding email message may be confidential or protected by the 
> attorney-client privilege. It is not intended for transmission to, or 
> receipt by, any unauthorized persons. If you have received this 
> message in error, please (i) do not read it, (ii) reply to the sender 
> that you received the message in error, and (iii) erase or destroy the 
> message. Legal advice contained in the preceding message is solely for 
> the benefit of the Foley & Lardner LLP client(s) represented by the 
> Firm in the particular matter that is the subject of this message, and 
> may not be relied upon by any other party.
>
> Internal Revenue Service regulations require that certain types of 
> written advice include a disclaimer. To the extent the preceding 
> message contains advice relating to a Federal tax issue, unless 
> expressly stated otherwise the advice is not intended or written to be 
> used, and it cannot be used by the recipient or any other taxpayer, 
> for the purpose of avoiding Federal tax penalties, and was not written 
> to support the promotion or marketing of any transaction or matter 
> discussed herein.
> ------------------------------------------------------------------------
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20080926/101a1a78/attachment.html>