<!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 Pete,<br>
<br>
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.<br>
<br>
2) you will need to run some SQL to figure out what's going on here:<br>
select * from device where pkid<font face="Courier New" size="2"> like
'%2a9f9c5a1cff%'<br>
and investigate that device.<br>
<br>
a bit of info (devicetype) from:<br>
select * from typemodel where enum=124 <br>
<br>
<br>
</font>3) more sql required. devices which do not support EM should not
have a device profile<br>
select * from device where pkid like '%c5afee95f747%'<br>
and investigate that device<br>
<br>
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.<br>
<br>
/Wes<br>
<br>
On 9/26/2008 12:56 PM, Ruttman, Pete G. wrote:
<blockquote
cite="mid:770F911A1491834680AF76208B6C0BF639F871@OHSPREX11.foleylaw.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="MS Exchange Server version 6.5.7638.1">
<title>DMA Warnings</title>
<!-- Converted from text/rtf format -->
<p><font face="Arial" size="2">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?</font></p>
<p><font face="Courier New" size="2">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</font></p>
<p><font face="Courier New" size="2">Condition: Either the user does
not exist in the directory or has been tagged invalid</font>
</p>
<p><font face="Courier New" size="2">Solution: Please verify that the
user exists in the directory and is a valid CCM user; ie. User with
profiles</font>
</p>
<p><font face="Arial" size="2">(So, do I really just create a Global
User called PAAdministrator and that'll fix this one?)</font>
</p>
<br>
<p><font face="Courier New" size="2">2) Table:
DeviceAddOnModuleMap 2008-09-26 03:02:18 </font>
</p>
<p><font face="Courier New" size="2"> Row: 47 SQL error: -746(2304)</font>
<br>
<font face="Courier New" size="2"> Warning message (Business Rule
Violation): This type of expansion module is not supported by this
device.</font>
<br>
<font face="Courier New" size="2"> pkid
0a31acea-57de-476f-b9ef-070a1ba3e293 NOT MODIFIABLE</font>
<br>
<font face="Courier New" size="2"> fkDevice
8a208480-7447-451a-a641-2a9f9c5a1cff</font>
<br>
<font face="Courier New" size="2"> ModuleIndex 1</font>
<br>
<font face="Courier New" size="2"> SpecialLoadInformation </font>
<br>
<font face="Courier New" size="2"> tkModel 124</font>
</p>
<br>
<p><font face="Courier New" size="2">(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?)</font></p>
<p><font face="Courier New" size="2">3) Table:
Telecaster 2008-09-26 03:56:54 </font>
</p>
<p><font face="Courier New" size="2"> Row: 367 SQL error: -746(423)</font>
<br>
<font face="Courier New" size="2"> Warning message (Business Rule
Violation): Device Profile can only be created for devices that support
Extension Mobility feature.</font></p>
<p><font face="Courier New" size="2"> pkid
da0730af-3842-4a2b-8a10-0828bdb24432 NOT MODIFIABLE</font>
<br>
<font face="Courier New" size="2"> fkDevice
cc9e804a-1ee1-48b1-ba64-c5afee95f747</font>
<br>
<font face="Courier New" size="2"> DirectoryServicesURL1 </font>
<br>
<font face="Courier New" size="2"> DirectoryServicesURL2 </font>
<br>
<font face="Courier New" size="2"> VoiceMailURL1 </font>
<br>
<font face="Courier New" size="2"> VoiceMailURL2 </font>
<br>
<font face="Courier New" size="2"> IdleURL </font>
<br>
<font face="Courier New" size="2"> IdleTimeout </font>
<br>
<font face="Courier New" size="2"> ProxyURL </font>
<br>
<font face="Courier New" size="2"> AuthenticationURL </font>
</p>
<p><font face="Courier New" size="2">(I can't find another table that
this warning connects to either. I only have two. Perhaps they are
just orphaned?)</font>
</p>
<br>
<p><font face="Courier New" size="2">Thanks for any help,</font>
</p>
<p><font face="Courier New" size="2">Pete Ruttman</font>
<br>
<font face="Courier New" size="2">Foley & Lardner, LLP</font>
</p>
<div> </div>
<br>
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. <br>
<br>
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.<br>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
cisco-voip mailing list
<a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
<a class="moz-txt-link-freetext" href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a>
</pre>
</blockquote>
</body>
</html>