Re: [OSL | CCIE_Voice] Interesting Project

[Bruno Nonogaki]

Hi Emanuel,

Yeah, small world... =) I will private message you later...

Well, I didn't face that issue when I did my upgrade.
Are you using the same IP Address, Subnet Mask, Hostname, when making the
7.1.5 installation? DNS are properly configured?
I have seen these errors just when addind a Subscriber to the cluster, but
never when installing a Publisher...

Maybe the way will be to import everything manually... hehe!
But I really don't remeber if we can export configurations with BAT on 4.x,
just like we do on 7.1.x... And even if you can, you will have a lot of
Excel work to make the import files...

Good luck on your studies! :)

Bruno

On Wed, Feb 8, 2012 at 9:24 PM, Emanuel Damasceno wrote:

> Sorry, I forgot to attach the file... Here it goes...
> *Emanuel Damasceno*
> CCNP Voice
>
>
>
>
>
>
> On Wed, Feb 8, 2012 at 9:20 PM, Emanuel Damasceno 
> wrote:
>
>> Bruno!!!
>>
>> It's good to see more Brazilians on the study list. :)
>>
>> Small world Well, let me explain to you what happens.
>>
>> It's not about the DMA. I can get the tar file just fine. I tried with
>> 7.0.2, and 7.1.5. Tomorrow I will try what you suggested me, but like I
>> said, the problem is not the tar file. When we finish it, it gives me the
>> file with warnings. Thousands of warnings. Ok, I start installing CUCM
>> 7.1.5 just fine, it installs, it goes all the way until the end of the
>> installation. But instead of finishing, it actually shows me what is in the
>> picture attached. Every single time, no matter what I do. I will follow
>> your advice and try that, but I am sick of making DMAs, and when it comes
>> to that part, it gives me the same error, over and over again.
>> *
>> *I've sent the log files to Cisco Systems, and this is the response I
>> got (btw, my first name is Antonio and I HATE that name lol):*
>>
>> Antonio,
>> If you could send me the most diagnostics from the most recent attempt.
>> Once I have these I will look at them to try and find what exactly is
>> causing your current issue.
>> If you have any questions or concerns, please feel free to email or call
>> me.
>> Thanks,
>> +1 919-574-5984, 0900-1630 EST (GMT -5)
>> Cisco Customer Support Engineer
>> Unified Communications Infrastructure
>> RTP, NC, USA*
>>
>> Ok, I removed the engineer's name. But that's not the kind of answer I
>> was expecting of him. I've sent them over 6 log files of all the errors and
>> they NEVER gave me a plausible answer. By the way, that is the 3rd engineer
>> on the case. I am really not dealing with Cisco anymore. I have to go all
>> over the DB and make an Excel file so I can export. Tomorrow will be my
>> last attempt on this. I am giving my best, but I don't see any effort from
>> Cisco to help me out. That's why I posted this here.
>>
>> Thanks for answering in such detail. I will go over them tomorrow. I
>> still got my 5 hour study block to face and I just got home (9:20 pm). My
>> exam is getting closer and I intend to nail it. But I do need to get this
>> problem out of the way before I can study with peace of mind.
>>
>> Best regards.
>> *Emanuel Damasceno*
>> CCNP Voice
>>
>>
>>
>>
>>
>>
>> On Wed, Feb 8, 2012 at 2:56 PM, Bruno Nonogaki  wrote:
>>
>>> Hi Emanuel,
>>>
>>> I have just talked with Andre Mulato regarding this issue (we worked
>>> together some years ago! hehe).
>>>
>>> I have already seen this warnings before when I made an upgrade from 4.2
>>> to 6.1.x, but the DMA could be restored without problems, even with these
>>> warnings. I still have the warnings and errors logs here for that
>>> particular DMA, and I do see the same message as you:
>>>
>>> Warning: Numplan (NULL) for User linhara1 is invalid. Ignoring the user
>>>
>>> Condition: Primary Extension for this user is invalid. It does not exist
>>> in the database
>>>
>>> Solution: Please ensure that the user is associated with a valid primary
>>> extension/numplan
>>>
>>> When you generate the tar file, you have a file inside called
>>> DMAResult.txt. Do you have any errors in there?
>>> In mine I have:
>>> Validation = Success with Warnings
>>>
>>> So I think the Warnings are not a big deal... maybe you have to fix one
>>> or other thing manually, but you will still be able to import the DMA to
>>> the new system.
>>> Didn't you get an error (not warning)? I can see the only error you got
>>> was that one on FAC table, but I think you have already solved that by
>>> removing special characters, right?
>>>
>>> I remember that when I made this upgrade, TAC suggested me to use the
>>> DMA version 6.1.3 or 6.1.5. He said 6.1.2 had a bug and the import would
>>> fail. So maybe it is a bug with the version you are using. Why don't you
>>> try to use 6.1.5 and import it to a CUCM 6.1.x? And then upgrade it to 8.5?
>>>
>>> Here are useful links provided by TAC when I made this upgrade:
>>>
>>> 
>>>
>>> DMA user guide to DMA 6.1.3, but you can follow the exact s

Re: [OSL | CCIE_Voice] Interesting Project

[Emanuel Damasceno]

Bruno!!!

It's good to see more Brazilians on the study list. :)

Small world Well, let me explain to you what happens.

It's not about the DMA. I can get the tar file just fine. I tried with
7.0.2, and 7.1.5. Tomorrow I will try what you suggested me, but like I
said, the problem is not the tar file. When we finish it, it gives me the
file with warnings. Thousands of warnings. Ok, I start installing CUCM
7.1.5 just fine, it installs, it goes all the way until the end of the
installation. But instead of finishing, it actually shows me what is in the
picture attached. Every single time, no matter what I do. I will follow
your advice and try that, but I am sick of making DMAs, and when it comes
to that part, it gives me the same error, over and over again.
*
*I've sent the log files to Cisco Systems, and this is the response I got
(btw, my first name is Antonio and I HATE that name lol):*

Antonio,
If you could send me the most diagnostics from the most recent attempt.
Once I have these I will look at them to try and find what exactly is
causing your current issue.
If you have any questions or concerns, please feel free to email or call me.
Thanks,
+1 919-574-5984, 0900-1630 EST (GMT -5)
Cisco Customer Support Engineer
Unified Communications Infrastructure
RTP, NC, USA*

Ok, I removed the engineer's name. But that's not the kind of answer I was
expecting of him. I've sent them over 6 log files of all the errors and
they NEVER gave me a plausible answer. By the way, that is the 3rd engineer
on the case. I am really not dealing with Cisco anymore. I have to go all
over the DB and make an Excel file so I can export. Tomorrow will be my
last attempt on this. I am giving my best, but I don't see any effort from
Cisco to help me out. That's why I posted this here.

Thanks for answering in such detail. I will go over them tomorrow. I still
got my 5 hour study block to face and I just got home (9:20 pm). My exam is
getting closer and I intend to nail it. But I do need to get this problem
out of the way before I can study with peace of mind.

Best regards.
*Emanuel Damasceno*
CCNP Voice





On Wed, Feb 8, 2012 at 2:56 PM, Bruno Nonogaki  wrote:

> Hi Emanuel,
>
> I have just talked with Andre Mulato regarding this issue (we worked
> together some years ago! hehe).
>
> I have already seen this warnings before when I made an upgrade from 4.2
> to 6.1.x, but the DMA could be restored without problems, even with these
> warnings. I still have the warnings and errors logs here for that
> particular DMA, and I do see the same message as you:
>
> Warning: Numplan (NULL) for User linhara1 is invalid. Ignoring the user
>
> Condition: Primary Extension for this user is invalid. It does not exist
> in the database
>
> Solution: Please ensure that the user is associated with a valid primary
> extension/numplan
>
> When you generate the tar file, you have a file inside called
> DMAResult.txt. Do you have any errors in there?
> In mine I have:
> Validation = Success with Warnings
>
> So I think the Warnings are not a big deal... maybe you have to fix one or
> other thing manually, but you will still be able to import the DMA to the
> new system.
> Didn't you get an error (not warning)? I can see the only error you got
> was that one on FAC table, but I think you have already solved that by
> removing special characters, right?
>
> I remember that when I made this upgrade, TAC suggested me to use the DMA
> version 6.1.3 or 6.1.5. He said 6.1.2 had a bug and the import would fail.
> So maybe it is a bug with the version you are using. Why don't you try to
> use 6.1.5 and import it to a CUCM 6.1.x? And then upgrade it to 8.5?
>
> Here are useful links provided by TAC when I made this upgrade:
>
> 
>
> DMA user guide to DMA 6.1.3, but you can follow the exact same steps for
> 6.1.5:
>
>
> http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/dma/6_1_3/dmaug613.html#wp37764
>
> Additional info regarding DMA 6.1.5:
>
>
> http://www.cisco.com/en/US/partner/docs/voice_ip_comm/cucm/dma/6_1_5/dma-rel_note-615.html
>
>
> Hope that helps...
>
> Rgs,
>
> Bruno
>
>
>
>
> On Wed, Feb 8, 2012 at 1:24 PM, Ki Wi  wrote:
>
>> Maybe there's better way but I would have staged it in lab environment.
>>
>> I have seen first error before but can't really remember how to resolved
>> it. All I remember is some name with - or _ might not work. You might want
>> to verify or just remove the device association under this user as well
>> which is what the error message suggest.
>>
>> Basically after you try out, you need to run DMA again to see whether
>> that certain error message goes away for that specific phone/user. I did
>> manually fix before but that time was for 100+ users before.
>>
>> That was like 3 to 4 years ago since I encountered this type of issue.
>> Surprising I have done > 10 such upgrade, only one customer I encounter
>> this.
>>
>> Sent from my iPhone
>>

Re: [OSL | CCIE_Voice] Interesting Project

[Bruno Nonogaki]

Hi Emanuel,

I have just talked with Andre Mulato regarding this issue (we worked
together some years ago! hehe).

I have already seen this warnings before when I made an upgrade from 4.2 to
6.1.x, but the DMA could be restored without problems, even with these
warnings. I still have the warnings and errors logs here for that
particular DMA, and I do see the same message as you:

Warning: Numplan (NULL) for User linhara1 is invalid. Ignoring the user
Condition: Primary Extension for this user is invalid. It does not exist in
the database

Solution: Please ensure that the user is associated with a valid primary
extension/numplan

When you generate the tar file, you have a file inside called
DMAResult.txt. Do you have any errors in there?
In mine I have:
Validation = Success with Warnings

So I think the Warnings are not a big deal... maybe you have to fix one or
other thing manually, but you will still be able to import the DMA to the
new system.
Didn't you get an error (not warning)? I can see the only error you got was
that one on FAC table, but I think you have already solved that by removing
special characters, right?

I remember that when I made this upgrade, TAC suggested me to use the DMA
version 6.1.3 or 6.1.5. He said 6.1.2 had a bug and the import would fail.
So maybe it is a bug with the version you are using. Why don't you try to
use 6.1.5 and import it to a CUCM 6.1.x? And then upgrade it to 8.5?

Here are useful links provided by TAC when I made this upgrade:



DMA user guide to DMA 6.1.3, but you can follow the exact same steps for
6.1.5:

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/dma/6_1_3/dmaug613.html#wp37764

Additional info regarding DMA 6.1.5:

http://www.cisco.com/en/US/partner/docs/voice_ip_comm/cucm/dma/6_1_5/dma-rel_note-615.html


Hope that helps...

Rgs,

Bruno



On Wed, Feb 8, 2012 at 1:24 PM, Ki Wi  wrote:

> Maybe there's better way but I would have staged it in lab environment.
>
> I have seen first error before but can't really remember how to resolved
> it. All I remember is some name with - or _ might not work. You might want
> to verify or just remove the device association under this user as well
> which is what the error message suggest.
>
> Basically after you try out, you need to run DMA again to see whether that
> certain error message goes away for that specific phone/user. I did
> manually fix before but that time was for 100+ users before.
>
> That was like 3 to 4 years ago since I encountered this type of issue.
> Surprising I have done > 10 such upgrade, only one customer I encounter
> this.
>
> Sent from my iPhone
> Pls pardon my fat fingers.
>
> On 8 Feb, 2012, at 9:42 PM, Emanuel Damasceno 
> wrote:
>
> Hello Expert.
>
> First I'd like to say this is not CCIE related. I decided to post it here,
> because the majority of us work with voice, and we might help each other.
>
> I received a project a few months ago where I have to upgrade from CUCM
> 4.1.3 to 8.5. There is no upgrade straight through 8.5. I have to go first
> to 7.X and then to 8.5.
>
> This customer has one big structure, where there is 1 CUCM Pub and 5
> Subscribers. He also got 6 Gatekeepers and over 5k devices. Needless to say
> this customer has thousands of users, route patterns, partitions, CSSs etc.
>
> As I run DMA on the Publisher server, I receive a lot of warnings like the
> ones shown below:
>
> *02/01/2012  12:31:49
> Warning: Device or DeviceProfile=001ef7297af9 for user=3028541 not found
> in the database.
> Condition: The Device found in the directory does not exist in the database
>
> Solution: Please verify that the user is associated to a valid device or a
> device profile. Please add the mentioned device or device profile through
> CCM Admin pages or manually delete this value from the users CCN profile
>
> *That's just one of the thousands I get with the same message. Now,
> another couple thousand of these:
> *
> 02/01/2012  12:36:18
> Warning: Numplan (NULL) for User 3008935 is invalid. Ignoring the user
> Condition: Primary Extension for this user is invalid. It does not exist
> in the database
>
> Solution: Please ensure that the user is associated with a valid primary
> extension/numplan*
>
> And another couple thousand of these:
> *
> Row: 4705 SQL error: -746(37129)
>Error executing "update FACInfo set Name='Aloísio Flávio'
> where pkid='2a07d93d-d281-412a-a066-ff9e28edd14a'": [Informix][Informix
> ODBC Driver][Informix]Unspecified System Error =  -746. sqlerrm(37129)
>   Name  Aloísio
> Flávio
>   AuthorizationLevel0
>   Code  925046
>   pkid
>  2a07d93d-d281-412a-a066-ff9e28edd14a NOT MODIFIABLE
>
>
> Table: PhoneButton 2012-02-01 16:09:22*
>
> So, after a long time waiting for Cisco to give us an idea of how to
> handle 

Re: [OSL | CCIE_Voice] Interesting Project

[Ki Wi]

Maybe there's better way but I would have staged it in lab environment. 

I have seen first error before but can't really remember how to resolved it. 
All I remember is some name with - or _ might not work. You might want to 
verify or just remove the device association under this user as well which is 
what the error message suggest. 

Basically after you try out, you need to run DMA again to see whether that 
certain error message goes away for that specific phone/user. I did manually 
fix before but that time was for 100+ users before. 

That was like 3 to 4 years ago since I encountered this type of issue. 
Surprising I have done > 10 such upgrade, only one customer I encounter this. 

Sent from my iPhone
Pls pardon my fat fingers.

On 8 Feb, 2012, at 9:42 PM, Emanuel Damasceno  wrote:

> Hello Expert.
> 
> First I'd like to say this is not CCIE related. I decided to post it here, 
> because the majority of us work with voice, and we might help each other.
> 
> I received a project a few months ago where I have to upgrade from CUCM 4.1.3 
> to 8.5. There is no upgrade straight through 8.5. I have to go first to 7.X 
> and then to 8.5.
> 
> This customer has one big structure, where there is 1 CUCM Pub and 5 
> Subscribers. He also got 6 Gatekeepers and over 5k devices. Needless to say 
> this customer has thousands of users, route patterns, partitions, CSSs etc. 
> 
> As I run DMA on the Publisher server, I receive a lot of warnings like the 
> ones shown below:
> 
> 02/01/2012  12:31:49
> Warning: Device or DeviceProfile=001ef7297af9 for user=3028541 not found in 
> the database.
> Condition: The Device found in the directory does not exist in the database
> 
> Solution: Please verify that the user is associated to a valid device or a 
> device profile. Please add the mentioned device or device profile through CCM 
> Admin pages or manually delete this value from the users CCN profile
> 
> That's just one of the thousands I get with the same message. Now, another 
> couple thousand of these:
> 
> 02/01/2012  12:36:18
> Warning: Numplan (NULL) for User 3008935 is invalid. Ignoring the user
> Condition: Primary Extension for this user is invalid. It does not exist in 
> the database
> 
> Solution: Please ensure that the user is associated with a valid primary 
> extension/numplan 
> 
> And another couple thousand of these:
> 
> Row: 4705 SQL error: -746(37129)
>Error executing "update FACInfo set Name='Aloísio Flávio' 
> where pkid='2a07d93d-d281-412a-a066-ff9e28edd14a'": [Informix][Informix ODBC 
> Driver][Informix]Unspecified System Error =  -746. sqlerrm(37129)
>   Name  Aloísio 
> Flávio
>   AuthorizationLevel0
>   Code  925046
>   pkid  2a07d93d-d281-412a-a066-ff9e28edd14a 
> NOT MODIFIABLE
> 
> 
> Table: PhoneButton 2012-02-01 16:09:22
> 
> So, after a long time waiting for Cisco to give us an idea of how to handle 
> this (they haven't answered us yet), our customer decided that he wants 
> everything built from the ground up. I just wanted to ask you guys what would 
> be the best way to extract over 50k entries. I know I will have to be using 
> Excel for this, but has anybody ever done this that way? We tried doing many 
> things, we modified many things, we removed special characters (that's what 
> cause the 3rd error), but we are always haunted by it. I installed Visual 
> Studio on Publisher and started tweaking a few entries on SQL DB, but no luck.
> 
> What I need is to remove its DB contents and use Excel to BAT it to CUCM 8.5. 
> We don't have any spare time anymore to try fixing the problem with CUCM 
> 4.1.3. We already received the UCSs, and I already installed the whole system 
> in it. It's just waiting for the contents so we can pull the plug on CUCM 
> 4.1.3 by the end of Feb. 
> 
> I am throwing the towel because I need to solve this ASAP so I can go back to 
> my studying. My exam is next month, and this project is my LAST until my 
> exam... HELP! :) 
> 
> Thanks in advance
> Emanuel Damasceno
> CCNP Voice
> 
> 
> 
> ___
> For more information regarding industry leading CCIE Lab training, please 
> visit www.ipexpert.com
> 
> Are you a CCNP or CCIE and looking for a job? Check out 
> www.PlatinumPlacement.com
___
For more information regarding industry leading CCIE Lab training, please visit 
www.ipexpert.com

Are you a CCNP or CCIE and looking for a job? Check out 
www.PlatinumPlacement.com

[OSL | CCIE_Voice] Interesting Project

[Emanuel Damasceno]

Hello Expert.

First I'd like to say this is not CCIE related. I decided to post it here,
because the majority of us work with voice, and we might help each other.

I received a project a few months ago where I have to upgrade from CUCM
4.1.3 to 8.5. There is no upgrade straight through 8.5. I have to go first
to 7.X and then to 8.5.

This customer has one big structure, where there is 1 CUCM Pub and 5
Subscribers. He also got 6 Gatekeepers and over 5k devices. Needless to say
this customer has thousands of users, route patterns, partitions, CSSs etc.

As I run DMA on the Publisher server, I receive a lot of warnings like the
ones shown below:

*02/01/2012  12:31:49
Warning: Device or DeviceProfile=001ef7297af9 for user=3028541 not found in
the database.
Condition: The Device found in the directory does not exist in the database

Solution: Please verify that the user is associated to a valid device or a
device profile. Please add the mentioned device or device profile through
CCM Admin pages or manually delete this value from the users CCN profile

*That's just one of the thousands I get with the same message. Now, another
couple thousand of these:
*
02/01/2012  12:36:18
Warning: Numplan (NULL) for User 3008935 is invalid. Ignoring the user
Condition: Primary Extension for this user is invalid. It does not exist in
the database

Solution: Please ensure that the user is associated with a valid primary
extension/numplan*

And another couple thousand of these:
*
Row: 4705 SQL error: -746(37129)
   Error executing "update FACInfo set Name='Aloísio Flávio'
where pkid='2a07d93d-d281-412a-a066-ff9e28edd14a'": [Informix][Informix
ODBC Driver][Informix]Unspecified System Error =  -746. sqlerrm(37129)
  Name  Aloísio
Flávio
  AuthorizationLevel0
  Code  925046
  pkid  2a07d93d-d281-412a-a066-ff9e28edd14a
 NOT MODIFIABLE


Table: PhoneButton 2012-02-01 16:09:22*

So, after a long time waiting for Cisco to give us an idea of how to handle
this (they haven't answered us yet), our customer decided that he wants
everything built from the ground up. I just wanted to ask you guys what
would be the best way to extract over 50k entries. I know I will have to be
using Excel for this, but has anybody ever done this that way? We tried
doing many things, we modified many things, we removed special characters
(that's what cause the 3rd error), but we are always haunted by it. I
installed Visual Studio on Publisher and started tweaking a few entries on
SQL DB, but no luck.

What I need is to remove its DB contents and use Excel to BAT it to CUCM
8.5. We don't have any spare time anymore to try fixing the problem with
CUCM 4.1.3. We already received the UCSs, and I already installed the whole
system in it. It's just waiting for the contents so we can pull the plug on
CUCM 4.1.3 by the end of Feb.

I am throwing the towel because I need to solve this ASAP so I can go back
to my studying. My exam is next month, and this project is my LAST until my
exam... HELP! :)

Thanks in advance*
Emanuel Damasceno*
CCNP Voice
___
For more information regarding industry leading CCIE Lab training, please visit 
www.ipexpert.com

Are you a CCNP or CCIE and looking for a job? Check out 
www.PlatinumPlacement.com