Re: [cisco-voip] UCCX CUIC Reports Stopped Working After Certain Date

[Abhiram Kramadhati (akramadh)]

Team,

The final cop has been posted and is available with TAC, will be on CCO as 
well. The primary issue is on the UCCX DB and therefore, has the potential to 
impact reporting clients (not just CUIC). If you have any questions or 
challenges, let me know.

Regards,
Abhiram Kramadhati
Technical Solutions Manager, CCBU
CCIE Collaboration # 40065

From: Erick Bergquist >
Date: Tuesday, 13 September 2016 at 12:26 PM
To: akramadh >
Cc: Brian Meade >, Anthony Holloway 
>, 
"cisco-voip@puck.nether.net" 
>
Subject: Re: [cisco-voip] UCCX CUIC Reports Stopped Working After Certain Date


Also, if you have any scheduled reports those may be stuck or failed (red x).  
If you rerun the scheduled reports after the fix that are stuck it fixes them.

Wallboard servers or dashboards using the report functions effected will also 
be impacted.


On Monday, September 12, 2016, Abhiram Kramadhati (akramadh) 
> wrote:
This impacts agent based reports and not just CUIC (can attempt 8.x as well). 
Reports we know:
Agent Sumary
Agent Not Ready State
CAD email reports

Best way to confirm if the report error is due to this issue is by running the 
corresponding SQL query on the UCCX CLI and verifying the error:
admin:run uccx sql db_cra {call sp_agent_summary('2016-09-10 
07:00:00','2016-09-11 06:59:59','0',null,'John Doe,Dan 
Marino','Support',null,null,null,null,null,null,null,null,null,null,null)}

Internal CLI Error: java.sql.SQLException: Overflow occurred on a datetime or 
interval operation.

The issue is triggered when the date is 8th September and later.

Regards,
Abhiram Kramadhati
Technical Solutions Manager, CCBU
CCIE Collaboration # 40065

From: > 
on behalf of Brian Meade 
>
Date: Tuesday, 13 September 2016 at 11:50 AM
To: Anthony Holloway 
>
Cc: akramadh 
>, 
"cisco-voip@puck.nether.net"
 
>
Subject: Re: [cisco-voip] UCCX CUIC Reports Stopped Working After Certain Date

Agent Not Ready State report was the big one that hit our clients.  It's any 
report/stored procedure that utilizes the datediff function.

Anything including a date after September 8th seemed to be an issue.

On Mon, Sep 12, 2016 at 9:44 PM, Anthony Holloway 
>
 wrote:
So, should this be impacting every CUIC install in the world?  Does this impact 
all reports or just some?  For the reports which are impacted, is only when 
certain date filters are applied, or any filters?  Are there any instances 
where a system wouldn't be impacted by reportgate?  I just ran one random 
report on a 10.6(1)SU1 system, and I don't see a problem.

On Mon, Sep 12, 2016 at 7:57 PM, Abhiram Kramadhati (akramadh) 
> wrote:
Hi all,

There is a cop already available which has been provided to TAC. Only the CAD 
email reports are yet to be fixed, so we have a fix already there but just 
formalising it as a cop. We will have one cop released externally which will 
fix all the reports – the cop currently available fixes everything apart from 
CAD email reports. For that, please ask TAC for a manual workaround (there will 
be one cop very soon with all the fixes).

A bit of context:
There is a datediff function which calculates the time difference between 
today’s date and reference date. The reference date hardcoded is 1985-01-01 
00:00:00 and starting from 8th September 2016, this difference is coming out to 
be a length that cannot be handled by the variable supposed to be storing it.

This will be fixed and cop will be available. This cop should be installed on 
both the nodes via CLI and requires no restarts.

Apologies, I am on travel – was meaning to send a heads-up when this got 
highlighted. Please feel free to reach out in case you are having challenges. 
Thank you.

Regards,
Abhiram Kramadhati
Technical Solutions Manager, CCBU
CCIE Collaboration # 40065

From: cisco-voip 
>
 on behalf of Erick Bergquist 
>
Date: Tuesday, 13 September 2016 at 

[cisco-voip] T.37 OffRamp Faxing on ISR G3 4351/4451

[Jonathan Charles]

The new Cisco 4000 series routers do not appear to support the fax/mta
commands for T.37 offramp faxing.

Have the commands been changed? Or is it no longer supported on this series
of routers?

IOW, is the TCL script: app_faxmail_onramp.2.0.1.3.tcl supported any more,
is there a new way to do offramp faxing?






Jonathan
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] SRST for SIP phones on 4000 Series

[Jonathan Charles]

Right, if I try mode esrst it complains about the network-id under the
pool... so, can it be enabled (we need the call park)?



Jonathan

On Wed, Sep 14, 2016 at 12:02 AM, Sreekanth  wrote:

> Mode esrst does not mandate the use of the SRST manager. You can configure
> mode esrst and then configure the router using the CLI.
> Esrst provides many more features to the phones over traditional SRST.
>
> Are you not getting the 'id network' option under voice register pool for
> mode esrst?
>
> Thanks
>
> On Sep 13, 2016 9:34 PM, "Jonathan Charles"  wrote:
>
>> Is there a way to deploy conventional SRST on the new 4000 series routers
>> without the SRST manager?
>>
>> It only gives me the option of mode cme or esrst, and when I try to
>> configure the pool it asks for a mac or device-id...
>>
>> Is automatic SRST no longer a thing on the 4000 series?
>>
>>
>>
>> Jonathan
>>
>>
>>
>> ___
>> cisco-voip mailing list
>> cisco-voip@puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>
>>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] AQM Setup...

[Matthew Loraditch]

Well I figured that out, now I just can't login to the web admin

Matthew G. Loraditch - CCNP-Voice, CCNA-R, CCDA
Network Engineer
Direct Voice: 443.541.1518

Facebook | 
Twitter | 
LinkedIn 
| G+

From: cisco-voip [mailto:cisco-voip-boun...@puck.nether.net] On Behalf Of 
Matthew Loraditch
Sent: Wednesday, September 14, 2016 10:41 AM
To: cisco-voip@puck.nether.net
Subject: [cisco-voip] AQM Setup...

I am getting an error in Administrator Configuration screen.. Unable to find AD 
Users to Configure.. I do a Wireshark and see NO LDAP activity when it does 
this. Anyone have any clues? Setting up a test system to learn the software... 
I have created the group I specified if LDAP Configuration and have users in it.

Matthew G. Loraditch - CCNP-Voice, CCNA-R, CCDA
Network Engineer
Direct Voice: 443.541.1518
Facebook | 
Twitter | 
LinkedIn 
| G+

___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

[cisco-voip] FW: Finesse Login Issues - Live TAC Case update

[Jason Aarons (AM)]

   Anyone seen this?

We have a new PCCE integration with CUCM and some of the users are not able to 
log into finesse with the following error, until the phone is rebooted and then 
they can.

[cid:image001.png@01D20DA9.06EFF930]

These are the versions we are dealing with:

PCCE : 11.0.2
Finesse : 11.0.1
CUCM: 10.5.1.11901-1


Ø  engaged a PCCE Engineer and they collected PG logs for the re created 
problem on Linelle’s finesse/phone.

Ø  The logs indicate getting a “Device unregistered” system event being 
received by the PG from the CUCM

Ø  Based on these logs, PCCE engineer then open a collaboration with CUCM team.

Ø  I provided related/requested CUCM logs to the new CUCM engineer

Ø  CUCM engineer analyzed them and found nothing out of the ordinary, no error 
messages sent. Phone did not show any signs of reboot either on the phone log 
messages

Ø  A second/recent set of logs were requested and they were provided to TAC, 
with similar result

Ø  TAC then requested logs for a working scenario, collected logs for the 
working scenario, they have been provided to TAC CUCM Team.

Ø  TAC is currently analyzing the working scenario logs to do a comparison with 
the non-working to get any clues on the root cause.

We are still on with TAC on this live call continuing to troubleshoot.

This email and all contents are subject to the following disclaimer:

"http://www.dimensiondata.com/emaildisclaimer;
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Jabber and Recording

[Brian Meade]

Yes, the built-in-bridge recording works with Jabber but not over MRA.

On Wed, Sep 14, 2016 at 11:17 AM, Scott Voll  wrote:

> Currently we use IPC and built in Bridging to do recordings.
>
> Does Jabber have the ability to do this?  How are others migrating to
> Jabber from IPC if not?
>
> TIA
>
> Scott
>
>
> ___
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

[cisco-voip] Jabber and Recording

[Scott Voll]

Currently we use IPC and built in Bridging to do recordings.

Does Jabber have the ability to do this?  How are others migrating to
Jabber from IPC if not?

TIA

Scott
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

[cisco-voip] AQM Setup...

[Matthew Loraditch]

I am getting an error in Administrator Configuration screen.. Unable to find AD 
Users to Configure.. I do a Wireshark and see NO LDAP activity when it does 
this. Anyone have any clues? Setting up a test system to learn the software... 
I have created the group I specified if LDAP Configuration and have users in it.

Matthew G. Loraditch - CCNP-Voice, CCNA-R, CCDA
Network Engineer
Direct Voice: 443.541.1518

Facebook | 
Twitter | 
LinkedIn 
| G+

___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] SRST for SIP phones on 4000 Series

[Sreekanth]

Yes, that is correct. The default mode is traditional SRST.

On 14 September 2016 at 10:59, Evgeny Izetov  wrote:

> I believe when you do 'voice register global' the mode is SRST by default.
> So you are not seeing the option of 'mode srst' because you are already in
> that mode.
>
> On Sep 14, 2016 1:03 AM, "Sreekanth"  wrote:
>
>> Mode esrst does not mandate the use of the SRST manager. You can
>> configure mode esrst and then configure the router using the CLI.
>> Esrst provides many more features to the phones over traditional SRST.
>>
>> Are you not getting the 'id network' option under voice register pool for
>> mode esrst?
>>
>> Thanks
>>
>> On Sep 13, 2016 9:34 PM, "Jonathan Charles"  wrote:
>>
>>> Is there a way to deploy conventional SRST on the new 4000 series
>>> routers without the SRST manager?
>>>
>>> It only gives me the option of mode cme or esrst, and when I try to
>>> configure the pool it asks for a mac or device-id...
>>>
>>> Is automatic SRST no longer a thing on the 4000 series?
>>>
>>>
>>>
>>> Jonathan
>>>
>>>
>>>
>>> ___
>>> cisco-voip mailing list
>>> cisco-voip@puck.nether.net
>>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>>
>>>
>> ___
>> cisco-voip mailing list
>> cisco-voip@puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>
>>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip