Re: [cisco-voip] Cisco and 911

2016-04-08 Thread Ryan Huff
Out of CUCM natively, but not automatically (which is what I think you want), 
through CDRs.

Informacast Advanced Notification would be good for this requirement too.

Thanks,

Ryan

On Apr 8, 2016, at 4:58 PM, Tim Kenyon 
> wrote:

Does anyone know if there is a way to generate some type of alerts out of CUCM 
when a user dials 911 that would give the extension number and maybe the MAC 
and source IP address of the phone without using CER?

Tim
___
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] Cisco and 911

2016-04-08 Thread Tim Kenyon
Does anyone know if there is a way to generate some type of alerts out of CUCM 
when a user dials 911 that would give the extension number and maybe the MAC 
and source IP address of the phone without using CER?

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


Re: [cisco-voip] Monitoring Cisco Expressway and Conductor servers

2016-04-08 Thread Lelio Fulgenzi

I've got an expressway deployment planned in the next month or so. We have a 
default setup where we send syslog messages to a syslog server, and email any 
out to the group. As time goes on, we configure things to be ignored. We use 
SEC as our syslog parsing tool. 

It's not idea, but it's what we have for now. 

Lelio 


--- 
Lelio Fulgenzi, B.A. 
Senior Analyst, Network Infrastructure 
Computing and Communications Services (CCS) 
University of Guelph 

519‐824‐4120 Ext 56354 
le...@uoguelph.ca 
www.uoguelph.ca/ccs 
Room 037, Animal Science and Nutrition Building 
Guelph, Ontario, N1G 2W1 

- Original Message -

From: "Fred Hunt"  
To: cisco-voip@puck.nether.net 
Sent: Friday, April 8, 2016 4:34:45 PM 
Subject: [cisco-voip] Monitoring Cisco Expressway and Conductor servers 



I'm wondering what others are using to monitor services, errors, etc. for Cisco 
Expressway and Conductor servers. Since there isn't a way to setup RTMT alerts, 
like is possible for other Cisco UC software, is there some third party 
solution that people use? 

Thanks, 
Fred 
___ 
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] Monitoring Cisco Expressway and Conductor servers

2016-04-08 Thread Fred Hunt
I'm wondering what others are using to monitor services, errors, etc. for
Cisco Expressway and Conductor servers.  Since there isn't a way to setup
RTMT alerts, like is possible for other Cisco UC software, is there some
third party solution that people use?

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


Re: [cisco-voip] 8861 Bug????

2016-04-08 Thread Brian Meade
I think it's equivalent to this Cius bug-
https://bst.cloudapps.cisco.com/bugsearch/bug/CSCts32008

Definitely a new issue.

On Fri, Apr 8, 2016 at 1:39 PM, Scott Voll  wrote:

> I have a user who uses extension mobility on a 8861 phone.  firmware is
> 11.0.1.11
>
> when he leaves at night he forwards to VM.  we log everyone out of
> extension mobility after 12 hours.
>
> The next morning when he logs in he as  "forward all" not "forward off".
>  pressing the "forward all"  does unforward the phone.  I'm not seeing a
> bug in the search tool and was wondering if this is a known bug
>
> 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] 8861 Bug????

2016-04-08 Thread Scott Voll
I have a user who uses extension mobility on a 8861 phone.  firmware is
11.0.1.11

when he leaves at night he forwards to VM.  we log everyone out of
extension mobility after 12 hours.

The next morning when he logs in he as  "forward all" not "forward off".
 pressing the "forward all"  does unforward the phone.  I'm not seeing a
bug in the search tool and was wondering if this is a known bug

TIA

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


Re: [cisco-voip] Digicert Wildcard cert

2016-04-08 Thread Eric Pedersen
Digicert lets you put specific hosts into the SAN in addition to the wildcard. 
I haven't seen any other certificate provider with anything close to the 
flexibility of Digicert. I haven't tried them on CUCM but they work perfectly 
on VCS, even for the connection to WebEx.

Eric

From: cisco-voip [mailto:cisco-voip-boun...@puck.nether.net] On Behalf Of 
Norton, Mike
Sent: 07 April 2016 5:13 PM
To: cisco-voip@puck.nether.net; dan...@ohnesorge.me; jcolon...@gmail.com
Subject: Re: [cisco-voip] Digicert Wildcard cert

I use Digicert wildcard certs a lot for totally unrelated uses. Just did one 
yesterday. I have never seen them want to generate the private key for me. That 
would be silly. If anyone other than me had the private key, then it wouldn’t 
be very private, would it? Maybe there is a way to have them generate the 
private key, but I can confirm it certainly isn’t mandatory.

After submitting the CSR, before signing, they do allow you to change the CN to 
wildcard on their site.

They do allow you to get multiple certs with the same wildcard CN using 
different keypairs. They call it “Get a duplicate” and it doesn’t cost anything 
extra.

The only piece I’m not sure about is if they allow multiple SANs on a wildcard 
cert. Other than possibly that, I know the rest is doable.

Like I said, I am using them for non-UC stuff. If Cisco says they don’t support 
it then I’d be hesitant to do it even if it is doable.

-mn


From: cisco-voip [mailto:cisco-voip-boun...@puck.nether.net] On Behalf Of 
Daniel Ohnesorge via cisco-voip
Sent: April-07-16 4:18 PM
To: ryanh...@outlook.com; 
jcolon...@gmail.com; Cisco VOIP 
>
Cc: Cisco VOIP >
Subject: Re: [cisco-voip] Digicert Wildcard cert

Jose,

A few things to know; most wildcard certs from Verisign, GoDaddy etc. generate 
a key pair (private and public key) for you and send you a passphrase protected 
.pfx or .p12 file which can then be imported to IIS, Apache or any application 
(even Expressway for that matter). CUCM however does not allow private key 
import as it sees it a security risk and mandates that keys must be generated 
on CUCM via CSR.

The next thing to know is how CUCM deals with changes between its CSR and the 
certificate. The rule is that the Common Name of the CSR doesn't have to match 
but the SAN entries must match. So if you generate a Multi-SAN certificate CSR, 
CUCM will automatically put all CUCM/CUPS nodes in the list and you/the CA are 
expected to ensure those entries match. Theoretically, the CA could change the 
Common Name to *.domain.com during signing and you could 
actually import it in to CUCM. The challenge here is a) finding a CA which 
allows distinct individual keys/certs for the same wildcard Common Name and b) 
finding a CA that allows multiple SAN entries although the Common Name is a 
wildcard.

You would be better off to work with the CA to refund the Wildcard certificate 
and swap it with a Multi-SAN product.

Sent from my iPhone

On 8 Apr 2016, at 07:34, Ryan Huff 
> wrote:
As far as I am aware, true wildcard certificates (*.domain.tld) are not 
supported with UCOS (despite whether they work or not).

Thanks,

Ryan

On Apr 7, 2016, at 5:30 PM, Jose Colon II 
> wrote:
After reading the numerous posts saying that the wildcard certs would work I 
purchased the wild card cert. Just wondering how people got them to work.

Thanks

On Thu, Apr 7, 2016 at 4:24 PM, Ryan Huff 
> wrote:
Jose,

I believe what you want are multi server (SAN) certificates for tomcat. You 
specify the distribution when generating the CSR.

Thanks,

Ryan

> On Apr 7, 2016, at 5:21 PM, Jose Colon II 
> > wrote:
>
> I have read a lot on forums that the digicert wildcard certs work great for 
> UC apps as long as I am on 10.5 which I am.
>
> Can someone lay out the process of uploading these certs as I am having a 
> hard time with them. What format do I need them. What cert goes where etc.
>
> Thanks in advance.
>
> Jose
> ___
> 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
 
 
The contents of this message may contain confidential and/or privileged 
subject matter. If this message has been received in error, please contact 
the sender and 

Re: [cisco-voip] Additional historical reports available on CCO

2016-04-08 Thread Kevin Przybylowski
You also have to put together that Cisco’s official new ccx reports would fall 
under the ‘custom’ umbrella!

From: cisco-voip [mailto:cisco-voip-boun...@puck.nether.net] On Behalf Of Ed 
Leatherman
Sent: Friday, April 8, 2016 11:37 AM
To: Anthony Holloway ; Justin Steinberg 

Cc: Cisco VOIP 
Subject: Re: [cisco-voip] Additional historical reports available on CCO


Hours ago actually lol, I never looked through the sp !

On Fri, Apr 8, 2016, 11:20 AM Anthony Holloway 
> 
wrote:
Defect in question: https://bst.cloudapps.cisco.com/bugsearch/bug/CSCul06940

Funny, Ed himself just posted this defect to the list a few days ago.  ;)

On Fri, Apr 8, 2016 at 10:16 AM, Justin Steinberg 
> wrote:
those reports have the temp tables issue.   they need to be imported using the 
uccxhrc user.

Which makes me really question using these reports in production since the QA 
on these must have been really minimal to document that they should be imported 
with uccxhruser.

On Fri, Apr 8, 2016 at 11:14 AM, Anthony Holloway 
> wrote:
Update: I rebooted my UCCX to see if that helped, and now I cannot run the 
Reason Code Report by Agent Grouping report, as it fails with the same database 
error.  So, it got worse.

On Fri, Apr 8, 2016 at 9:44 AM, Ed Leatherman 
> wrote:
Hmm i'll try the other ones - both reason code reports resulted in the same 
errors. I tried the second one using CUIC as the data source just to see if it 
made a difference. Thats the same type of error that i got though. Trying to 
find out if TAC will support these or not also.

On Fri, Apr 8, 2016 at 10:42 AM, Anthony Holloway 
> wrote:
Update:  After importing all reports, I can only run two of the five:

  1.  All Agent Fields Report - GOOD
  2.  Contact Service Queue Activity by Window Duration - Database status Failed
  3.  CSQ All Fields Report - Database status Failed
  4.  Reason Code Report by Agent Grouping - GOOD (This was coincidentally the 
first one I imported)
  5.  Reason Code Report by Reason Code Grouping -  - Database status Failed
As one example of the error output from a failed run is:

Error information:

com.cisco.ccbu.cuic.businesslogic.datasource.CuicDbException: DbException: 
CuicDataSourceServiceManagerImpl.getDataSet() { Nested SQLException; SQLState: 
IX000 Vendor code: -313 Message: Not owner of table. } at 
com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.getDataSetBuilder(CuicDataSourceServiceManagerImpl.java:952)
 at 
com.cisco.ccbu.cuic.businesslogic.engine.CuicReportEngineWorker.executeQueryUsingDatasetBuilder(CuicReportEngineWorker.java:80)
 at 
com.cisco.ccbu.cuic.businesslogic.engine.CuicReportEngineWorker.runReport(CuicReportEngineWorker.java:37)
 at com.cisco.ccbu.cuic.businesslogic.enginebase.Worker.run(Worker.java:329) at 
com.cisco.ccbu.infra.threads.InstrumentedRunnable.run(InstrumentedRunnable.java:92)
 at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) 
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) 
at java.lang.Thread.run(Thread.java:724) at 
com.cisco.ccbu.infra.threads.ThreadPoolThread.run(ThreadPoolThread.java:164) 
Caused by: java.sql.SQLException: Not owner of table. at 
com.informix.jdbc.IfxSqli.a(IfxSqli.java:3643) at 
com.informix.jdbc.IfxSqli.E(IfxSqli.java:3974) at 
com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2695) at 
com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2611) at 
com.informix.jdbc.IfxSqli.a(IfxSqli.java:1830) at 
com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1768) at 
com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1699) at 
com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:210) at 
com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1237) at 
com.informix.jdbc.IfxPreparedStatement.executeQuery(IfxPreparedStatement.java:401)
 at 
com.informix.jdbc.IfxCallableStatement.executeQuery(IfxCallableStatement.java:241)
 at 
com.mchange.v2.c3p0.impl.NewProxyCallableStatement.executeQuery(NewProxyCallableStatement.java:2131)
 at 
com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.executeAndLoadDataset(CuicDataSourceServiceManagerImpl.java:1072)
 at 
com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.getDataSetBuilder(CuicDataSourceServiceManagerImpl.java:938)
 ... 8 more Caused by: java.sql.SQLException at 
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:413) at 
com.informix.jdbc.IfxSqli.E(IfxSqli.java:3979) ... 20 more


On Fri, Apr 8, 2016 at 9:30 AM, Anthony Holloway 

Re: [cisco-voip] Additional historical reports available on CCO

2016-04-08 Thread Ed Leatherman
Hours ago actually lol, I never looked through the sp !

On Fri, Apr 8, 2016, 11:20 AM Anthony Holloway <
avholloway+cisco-v...@gmail.com> wrote:

> Defect in question:
> https://bst.cloudapps.cisco.com/bugsearch/bug/CSCul06940
>
> Funny, Ed himself just posted this defect to the list a few days ago.  ;)
>
> On Fri, Apr 8, 2016 at 10:16 AM, Justin Steinberg 
> wrote:
>
>> those reports have the temp tables issue.   they need to be imported
>> using the uccxhrc user.
>>
>> Which makes me really question using these reports in production since
>> the QA on these must have been really minimal to document that they should
>> be imported with uccxhruser.
>>
>> On Fri, Apr 8, 2016 at 11:14 AM, Anthony Holloway <
>> avholloway+cisco-v...@gmail.com> wrote:
>>
>>> Update: I rebooted my UCCX to see if that helped, and now I cannot run
>>> the Reason Code Report by Agent Grouping report, as it fails with the same
>>> database error.  So, it got worse.
>>>
>>> On Fri, Apr 8, 2016 at 9:44 AM, Ed Leatherman 
>>> wrote:
>>>
 Hmm i'll try the other ones - both reason code reports resulted in the
 same errors. I tried the second one using CUIC as the data source just to
 see if it made a difference. Thats the same type of error that i got
 though. Trying to find out if TAC will support these or not also.

 On Fri, Apr 8, 2016 at 10:42 AM, Anthony Holloway <
 avholloway+cisco-v...@gmail.com> wrote:

> Update:  After importing all reports, I can only run two of the five:
>
>1. All Agent Fields Report - GOOD
>2. Contact Service Queue Activity by Window Duration - Database
>status Failed
>3. CSQ All Fields Report - Database status Failed
>4. Reason Code Report by Agent Grouping - GOOD (This was
>coincidentally the first one I imported)
>5. Reason Code Report by Reason Code Grouping -  - Database status
>Failed
>
> As one example of the error output from a failed run is:
>
> *Error information:*
> com.cisco.ccbu.cuic.businesslogic.datasource.CuicDbException:
> DbException: CuicDataSourceServiceManagerImpl.getDataSet() { Nested
> SQLException; SQLState: IX000 Vendor code: -313 Message: Not owner of
> table. } at
> com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.getDataSetBuilder(CuicDataSourceServiceManagerImpl.java:952)
> at
> com.cisco.ccbu.cuic.businesslogic.engine.CuicReportEngineWorker.executeQueryUsingDatasetBuilder(CuicReportEngineWorker.java:80)
> at
> com.cisco.ccbu.cuic.businesslogic.engine.CuicReportEngineWorker.runReport(CuicReportEngineWorker.java:37)
> at 
> com.cisco.ccbu.cuic.businesslogic.enginebase.Worker.run(Worker.java:329)
> at
> com.cisco.ccbu.infra.threads.InstrumentedRunnable.run(InstrumentedRunnable.java:92)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:724) at
> com.cisco.ccbu.infra.threads.ThreadPoolThread.run(ThreadPoolThread.java:164)
> Caused by: java.sql.SQLException: Not owner of table. at
> com.informix.jdbc.IfxSqli.a(IfxSqli.java:3643) at
> com.informix.jdbc.IfxSqli.E(IfxSqli.java:3974) at
> com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2695) at
> com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2611) at
> com.informix.jdbc.IfxSqli.a(IfxSqli.java:1830) at
> com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1768) at
> com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1699) at
> com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:210) at
> com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1237) at
> com.informix.jdbc.IfxPreparedStatement.executeQuery(IfxPreparedStatement.java:401)
> at
> com.informix.jdbc.IfxCallableStatement.executeQuery(IfxCallableStatement.java:241)
> at
> com.mchange.v2.c3p0.impl.NewProxyCallableStatement.executeQuery(NewProxyCallableStatement.java:2131)
> at
> com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.executeAndLoadDataset(CuicDataSourceServiceManagerImpl.java:1072)
> at
> com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.getDataSetBuilder(CuicDataSourceServiceManagerImpl.java:938)
> ... 8 more Caused by: java.sql.SQLException at
> com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:413) at
> com.informix.jdbc.IfxSqli.E(IfxSqli.java:3979) ... 20 more
>
> On Fri, Apr 8, 2016 at 9:30 AM, Anthony Holloway <
> avholloway+cisco-v...@gmail.com> wrote:
>
>> I'm only just seeing this now for the first time, and so, I just
>> tried to import one report, and so far it worked for me.  I'll try the 
>> rest
>> in a moment, 

Re: [cisco-voip] UCCx 10.5 custom stored procedure for reporting

2016-04-08 Thread Brian Meade
I use AGS Server Studio as well.  This is how I do it and make sure the
permissions are okay:

DROP FUNCTION sp_exec_summary(datetime,datetime,integer,lvarchar);

CREATE FUNCTION sp_exec_summary (
p_startTime DATETIME YEAR TO FRACTION(3),
p_endTime DATETIME YEAR TO FRACTION(3),
p_sortBy INT DEFAULT 0,
p_appNameList LVARCHAR(4000) DEFAULT 'NULL' )
END FUNCTION;

grant execute on function
sp_exec_summary(datetime,datetime,integer,lvarchar) to 'public';


AGS Server Studio tries to add 'uccxhruser' in front of the stored
procedure names.  I just get rid of those to make sure it's accessible to
everything.

On Thu, Apr 7, 2016 at 6:06 PM, Bill Talley  wrote:

> Hi all,
>
> Has anyone imported custom stored procedures into the db_cra for use in
> CUIC?  I'm having an issue getting a new stored proc loaded using either
> RazorSQL or AGS Server Studio.  From what I've read, I need to execute the
> stored proc; however, when I do that I get an error that uccxhruser doesn't
> have permission to execute the stored proc.  It seems I can't apply
> permissions to the uccxhruser account on the stored proc until the stored
> proc is loaded.   Would anyone have any tips on how I can go about getting
> the stored proc loaded to the database?
>
> Hopefully this makes sense to someone ;-)
>
> TIA,
> Bill
>
> ___
> 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] Additional historical reports available on CCO

2016-04-08 Thread Anthony Holloway
Defect in question: https://bst.cloudapps.cisco.com/bugsearch/bug/CSCul06940

Funny, Ed himself just posted this defect to the list a few days ago.  ;)

On Fri, Apr 8, 2016 at 10:16 AM, Justin Steinberg 
wrote:

> those reports have the temp tables issue.   they need to be imported using
> the uccxhrc user.
>
> Which makes me really question using these reports in production since the
> QA on these must have been really minimal to document that they should be
> imported with uccxhruser.
>
> On Fri, Apr 8, 2016 at 11:14 AM, Anthony Holloway <
> avholloway+cisco-v...@gmail.com> wrote:
>
>> Update: I rebooted my UCCX to see if that helped, and now I cannot run
>> the Reason Code Report by Agent Grouping report, as it fails with the same
>> database error.  So, it got worse.
>>
>> On Fri, Apr 8, 2016 at 9:44 AM, Ed Leatherman 
>> wrote:
>>
>>> Hmm i'll try the other ones - both reason code reports resulted in the
>>> same errors. I tried the second one using CUIC as the data source just to
>>> see if it made a difference. Thats the same type of error that i got
>>> though. Trying to find out if TAC will support these or not also.
>>>
>>> On Fri, Apr 8, 2016 at 10:42 AM, Anthony Holloway <
>>> avholloway+cisco-v...@gmail.com> wrote:
>>>
 Update:  After importing all reports, I can only run two of the five:

1. All Agent Fields Report - GOOD
2. Contact Service Queue Activity by Window Duration - Database
status Failed
3. CSQ All Fields Report - Database status Failed
4. Reason Code Report by Agent Grouping - GOOD (This was
coincidentally the first one I imported)
5. Reason Code Report by Reason Code Grouping -  - Database status
Failed

 As one example of the error output from a failed run is:

 *Error information:*
 com.cisco.ccbu.cuic.businesslogic.datasource.CuicDbException:
 DbException: CuicDataSourceServiceManagerImpl.getDataSet() { Nested
 SQLException; SQLState: IX000 Vendor code: -313 Message: Not owner of
 table. } at
 com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.getDataSetBuilder(CuicDataSourceServiceManagerImpl.java:952)
 at
 com.cisco.ccbu.cuic.businesslogic.engine.CuicReportEngineWorker.executeQueryUsingDatasetBuilder(CuicReportEngineWorker.java:80)
 at
 com.cisco.ccbu.cuic.businesslogic.engine.CuicReportEngineWorker.runReport(CuicReportEngineWorker.java:37)
 at com.cisco.ccbu.cuic.businesslogic.enginebase.Worker.run(Worker.java:329)
 at
 com.cisco.ccbu.infra.threads.InstrumentedRunnable.run(InstrumentedRunnable.java:92)
 at
 java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
 at
 java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
 at java.lang.Thread.run(Thread.java:724) at
 com.cisco.ccbu.infra.threads.ThreadPoolThread.run(ThreadPoolThread.java:164)
 Caused by: java.sql.SQLException: Not owner of table. at
 com.informix.jdbc.IfxSqli.a(IfxSqli.java:3643) at
 com.informix.jdbc.IfxSqli.E(IfxSqli.java:3974) at
 com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2695) at
 com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2611) at
 com.informix.jdbc.IfxSqli.a(IfxSqli.java:1830) at
 com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1768) at
 com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1699) at
 com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:210) at
 com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1237) at
 com.informix.jdbc.IfxPreparedStatement.executeQuery(IfxPreparedStatement.java:401)
 at
 com.informix.jdbc.IfxCallableStatement.executeQuery(IfxCallableStatement.java:241)
 at
 com.mchange.v2.c3p0.impl.NewProxyCallableStatement.executeQuery(NewProxyCallableStatement.java:2131)
 at
 com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.executeAndLoadDataset(CuicDataSourceServiceManagerImpl.java:1072)
 at
 com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.getDataSetBuilder(CuicDataSourceServiceManagerImpl.java:938)
 ... 8 more Caused by: java.sql.SQLException at
 com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:413) at
 com.informix.jdbc.IfxSqli.E(IfxSqli.java:3979) ... 20 more

 On Fri, Apr 8, 2016 at 9:30 AM, Anthony Holloway <
 avholloway+cisco-v...@gmail.com> wrote:

> I'm only just seeing this now for the first time, and so, I just tried
> to import one report, and so far it worked for me.  I'll try the rest in a
> moment, but for now...
>
> Here's what I have, and what I did.
>
> My UCCX is 10.6.1.11001-31
>
>1. Downloaded CCX_NEWREPORTS.zip from http://www.cisco.com/
>2. Extracted CCX_NEWREPORTS.zip to folder CCX_NEWREPORTS
>3. Opened 

Re: [cisco-voip] Additional historical reports available on CCO

2016-04-08 Thread Justin Steinberg
those reports have the temp tables issue.   they need to be imported using
the uccxhrc user.

Which makes me really question using these reports in production since the
QA on these must have been really minimal to document that they should be
imported with uccxhruser.

On Fri, Apr 8, 2016 at 11:14 AM, Anthony Holloway <
avholloway+cisco-v...@gmail.com> wrote:

> Update: I rebooted my UCCX to see if that helped, and now I cannot run
> the Reason Code Report by Agent Grouping report, as it fails with the same
> database error.  So, it got worse.
>
> On Fri, Apr 8, 2016 at 9:44 AM, Ed Leatherman 
> wrote:
>
>> Hmm i'll try the other ones - both reason code reports resulted in the
>> same errors. I tried the second one using CUIC as the data source just to
>> see if it made a difference. Thats the same type of error that i got
>> though. Trying to find out if TAC will support these or not also.
>>
>> On Fri, Apr 8, 2016 at 10:42 AM, Anthony Holloway <
>> avholloway+cisco-v...@gmail.com> wrote:
>>
>>> Update:  After importing all reports, I can only run two of the five:
>>>
>>>1. All Agent Fields Report - GOOD
>>>2. Contact Service Queue Activity by Window Duration - Database
>>>status Failed
>>>3. CSQ All Fields Report - Database status Failed
>>>4. Reason Code Report by Agent Grouping - GOOD (This was
>>>coincidentally the first one I imported)
>>>5. Reason Code Report by Reason Code Grouping -  - Database status
>>>Failed
>>>
>>> As one example of the error output from a failed run is:
>>>
>>> *Error information:*
>>> com.cisco.ccbu.cuic.businesslogic.datasource.CuicDbException:
>>> DbException: CuicDataSourceServiceManagerImpl.getDataSet() { Nested
>>> SQLException; SQLState: IX000 Vendor code: -313 Message: Not owner of
>>> table. } at
>>> com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.getDataSetBuilder(CuicDataSourceServiceManagerImpl.java:952)
>>> at
>>> com.cisco.ccbu.cuic.businesslogic.engine.CuicReportEngineWorker.executeQueryUsingDatasetBuilder(CuicReportEngineWorker.java:80)
>>> at
>>> com.cisco.ccbu.cuic.businesslogic.engine.CuicReportEngineWorker.runReport(CuicReportEngineWorker.java:37)
>>> at com.cisco.ccbu.cuic.businesslogic.enginebase.Worker.run(Worker.java:329)
>>> at
>>> com.cisco.ccbu.infra.threads.InstrumentedRunnable.run(InstrumentedRunnable.java:92)
>>> at
>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>>> at
>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>>> at java.lang.Thread.run(Thread.java:724) at
>>> com.cisco.ccbu.infra.threads.ThreadPoolThread.run(ThreadPoolThread.java:164)
>>> Caused by: java.sql.SQLException: Not owner of table. at
>>> com.informix.jdbc.IfxSqli.a(IfxSqli.java:3643) at
>>> com.informix.jdbc.IfxSqli.E(IfxSqli.java:3974) at
>>> com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2695) at
>>> com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2611) at
>>> com.informix.jdbc.IfxSqli.a(IfxSqli.java:1830) at
>>> com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1768) at
>>> com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1699) at
>>> com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:210) at
>>> com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1237) at
>>> com.informix.jdbc.IfxPreparedStatement.executeQuery(IfxPreparedStatement.java:401)
>>> at
>>> com.informix.jdbc.IfxCallableStatement.executeQuery(IfxCallableStatement.java:241)
>>> at
>>> com.mchange.v2.c3p0.impl.NewProxyCallableStatement.executeQuery(NewProxyCallableStatement.java:2131)
>>> at
>>> com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.executeAndLoadDataset(CuicDataSourceServiceManagerImpl.java:1072)
>>> at
>>> com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.getDataSetBuilder(CuicDataSourceServiceManagerImpl.java:938)
>>> ... 8 more Caused by: java.sql.SQLException at
>>> com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:413) at
>>> com.informix.jdbc.IfxSqli.E(IfxSqli.java:3979) ... 20 more
>>>
>>> On Fri, Apr 8, 2016 at 9:30 AM, Anthony Holloway <
>>> avholloway+cisco-v...@gmail.com> wrote:
>>>
 I'm only just seeing this now for the first time, and so, I just tried
 to import one report, and so far it worked for me.  I'll try the rest in a
 moment, but for now...

 Here's what I have, and what I did.

 My UCCX is 10.6.1.11001-31

1. Downloaded CCX_NEWREPORTS.zip from http://www.cisco.com/
2. Extracted CCX_NEWREPORTS.zip to folder CCX_NEWREPORTS
3. Opened the Import Guide MS Word document from within the ZIP
archive and began reading the instructions to import the first report
4. Downloaded AGS Server Studio from
http://www.serverstudio.com/downloads/
5. Followed AGS instructions to install and register the product
6. Logged into UCCX App Admin 

Re: [cisco-voip] Additional historical reports available on CCO

2016-04-08 Thread Anthony Holloway
Update: I rebooted my UCCX to see if that helped, and now I cannot run
the Reason Code Report by Agent Grouping report, as it fails with the same
database error.  So, it got worse.

On Fri, Apr 8, 2016 at 9:44 AM, Ed Leatherman 
wrote:

> Hmm i'll try the other ones - both reason code reports resulted in the
> same errors. I tried the second one using CUIC as the data source just to
> see if it made a difference. Thats the same type of error that i got
> though. Trying to find out if TAC will support these or not also.
>
> On Fri, Apr 8, 2016 at 10:42 AM, Anthony Holloway <
> avholloway+cisco-v...@gmail.com> wrote:
>
>> Update:  After importing all reports, I can only run two of the five:
>>
>>1. All Agent Fields Report - GOOD
>>2. Contact Service Queue Activity by Window Duration - Database
>>status Failed
>>3. CSQ All Fields Report - Database status Failed
>>4. Reason Code Report by Agent Grouping - GOOD (This was
>>coincidentally the first one I imported)
>>5. Reason Code Report by Reason Code Grouping -  - Database status
>>Failed
>>
>> As one example of the error output from a failed run is:
>>
>> *Error information:*
>> com.cisco.ccbu.cuic.businesslogic.datasource.CuicDbException:
>> DbException: CuicDataSourceServiceManagerImpl.getDataSet() { Nested
>> SQLException; SQLState: IX000 Vendor code: -313 Message: Not owner of
>> table. } at
>> com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.getDataSetBuilder(CuicDataSourceServiceManagerImpl.java:952)
>> at
>> com.cisco.ccbu.cuic.businesslogic.engine.CuicReportEngineWorker.executeQueryUsingDatasetBuilder(CuicReportEngineWorker.java:80)
>> at
>> com.cisco.ccbu.cuic.businesslogic.engine.CuicReportEngineWorker.runReport(CuicReportEngineWorker.java:37)
>> at com.cisco.ccbu.cuic.businesslogic.enginebase.Worker.run(Worker.java:329)
>> at
>> com.cisco.ccbu.infra.threads.InstrumentedRunnable.run(InstrumentedRunnable.java:92)
>> at
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>> at
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>> at java.lang.Thread.run(Thread.java:724) at
>> com.cisco.ccbu.infra.threads.ThreadPoolThread.run(ThreadPoolThread.java:164)
>> Caused by: java.sql.SQLException: Not owner of table. at
>> com.informix.jdbc.IfxSqli.a(IfxSqli.java:3643) at
>> com.informix.jdbc.IfxSqli.E(IfxSqli.java:3974) at
>> com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2695) at
>> com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2611) at
>> com.informix.jdbc.IfxSqli.a(IfxSqli.java:1830) at
>> com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1768) at
>> com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1699) at
>> com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:210) at
>> com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1237) at
>> com.informix.jdbc.IfxPreparedStatement.executeQuery(IfxPreparedStatement.java:401)
>> at
>> com.informix.jdbc.IfxCallableStatement.executeQuery(IfxCallableStatement.java:241)
>> at
>> com.mchange.v2.c3p0.impl.NewProxyCallableStatement.executeQuery(NewProxyCallableStatement.java:2131)
>> at
>> com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.executeAndLoadDataset(CuicDataSourceServiceManagerImpl.java:1072)
>> at
>> com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.getDataSetBuilder(CuicDataSourceServiceManagerImpl.java:938)
>> ... 8 more Caused by: java.sql.SQLException at
>> com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:413) at
>> com.informix.jdbc.IfxSqli.E(IfxSqli.java:3979) ... 20 more
>>
>> On Fri, Apr 8, 2016 at 9:30 AM, Anthony Holloway <
>> avholloway+cisco-v...@gmail.com> wrote:
>>
>>> I'm only just seeing this now for the first time, and so, I just tried
>>> to import one report, and so far it worked for me.  I'll try the rest in a
>>> moment, but for now...
>>>
>>> Here's what I have, and what I did.
>>>
>>> My UCCX is 10.6.1.11001-31
>>>
>>>1. Downloaded CCX_NEWREPORTS.zip from http://www.cisco.com/
>>>2. Extracted CCX_NEWREPORTS.zip to folder CCX_NEWREPORTS
>>>3. Opened the Import Guide MS Word document from within the ZIP
>>>archive and began reading the instructions to import the first report
>>>4. Downloaded AGS Server Studio from
>>>http://www.serverstudio.com/downloads/
>>>5. Followed AGS instructions to install and register the product
>>>6. Logged into UCCX App Admin and set the password for the
>>>Historical Reporting User (uccxhruser) under Tools > Password Management
>>>7. Entered the connections details for UCCX into AGS Server Studio
>>>per this guide
>>>
>>> 

Re: [cisco-voip] Additional historical reports available on CCO

2016-04-08 Thread Ed Leatherman
Hmm i'll try the other ones - both reason code reports resulted in the same
errors. I tried the second one using CUIC as the data source just to see if
it made a difference. Thats the same type of error that i got though.
Trying to find out if TAC will support these or not also.

On Fri, Apr 8, 2016 at 10:42 AM, Anthony Holloway <
avholloway+cisco-v...@gmail.com> wrote:

> Update:  After importing all reports, I can only run two of the five:
>
>1. All Agent Fields Report - GOOD
>2. Contact Service Queue Activity by Window Duration - Database status
>Failed
>3. CSQ All Fields Report - Database status Failed
>4. Reason Code Report by Agent Grouping - GOOD (This was
>coincidentally the first one I imported)
>5. Reason Code Report by Reason Code Grouping -  - Database status
>Failed
>
> As one example of the error output from a failed run is:
>
> *Error information:*
> com.cisco.ccbu.cuic.businesslogic.datasource.CuicDbException: DbException:
> CuicDataSourceServiceManagerImpl.getDataSet() { Nested SQLException;
> SQLState: IX000 Vendor code: -313 Message: Not owner of table. } at
> com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.getDataSetBuilder(CuicDataSourceServiceManagerImpl.java:952)
> at
> com.cisco.ccbu.cuic.businesslogic.engine.CuicReportEngineWorker.executeQueryUsingDatasetBuilder(CuicReportEngineWorker.java:80)
> at
> com.cisco.ccbu.cuic.businesslogic.engine.CuicReportEngineWorker.runReport(CuicReportEngineWorker.java:37)
> at com.cisco.ccbu.cuic.businesslogic.enginebase.Worker.run(Worker.java:329)
> at
> com.cisco.ccbu.infra.threads.InstrumentedRunnable.run(InstrumentedRunnable.java:92)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:724) at
> com.cisco.ccbu.infra.threads.ThreadPoolThread.run(ThreadPoolThread.java:164)
> Caused by: java.sql.SQLException: Not owner of table. at
> com.informix.jdbc.IfxSqli.a(IfxSqli.java:3643) at
> com.informix.jdbc.IfxSqli.E(IfxSqli.java:3974) at
> com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2695) at
> com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2611) at
> com.informix.jdbc.IfxSqli.a(IfxSqli.java:1830) at
> com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1768) at
> com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1699) at
> com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:210) at
> com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1237) at
> com.informix.jdbc.IfxPreparedStatement.executeQuery(IfxPreparedStatement.java:401)
> at
> com.informix.jdbc.IfxCallableStatement.executeQuery(IfxCallableStatement.java:241)
> at
> com.mchange.v2.c3p0.impl.NewProxyCallableStatement.executeQuery(NewProxyCallableStatement.java:2131)
> at
> com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.executeAndLoadDataset(CuicDataSourceServiceManagerImpl.java:1072)
> at
> com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.getDataSetBuilder(CuicDataSourceServiceManagerImpl.java:938)
> ... 8 more Caused by: java.sql.SQLException at
> com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:413) at
> com.informix.jdbc.IfxSqli.E(IfxSqli.java:3979) ... 20 more
>
> On Fri, Apr 8, 2016 at 9:30 AM, Anthony Holloway <
> avholloway+cisco-v...@gmail.com> wrote:
>
>> I'm only just seeing this now for the first time, and so, I just tried to
>> import one report, and so far it worked for me.  I'll try the rest in a
>> moment, but for now...
>>
>> Here's what I have, and what I did.
>>
>> My UCCX is 10.6.1.11001-31
>>
>>1. Downloaded CCX_NEWREPORTS.zip from http://www.cisco.com/
>>2. Extracted CCX_NEWREPORTS.zip to folder CCX_NEWREPORTS
>>3. Opened the Import Guide MS Word document from within the ZIP
>>archive and began reading the instructions to import the first report
>>4. Downloaded AGS Server Studio from
>>http://www.serverstudio.com/downloads/
>>5. Followed AGS instructions to install and register the product
>>6. Logged into UCCX App Admin and set the password for the Historical
>>Reporting User (uccxhruser) under Tools > Password Management
>>7. Entered the connections details for UCCX into AGS Server Studio
>>per this guide
>>
>> 
>>8. Now I'm connected to UCCX DB, and I can see the DB details in AGS
>>Server Studio
>>9. I expand Databases on the left, then right click the db_cra
>>database and select New > SQL Editor
>>10. I open the .sql commands in Notepad++ for the first report in the
>>file from the ZIP archived 

Re: [cisco-voip] Additional historical reports available on CCO

2016-04-08 Thread Anthony Holloway
Update:  After importing all reports, I can only run two of the five:

   1. All Agent Fields Report - GOOD
   2. Contact Service Queue Activity by Window Duration - Database status
   Failed
   3. CSQ All Fields Report - Database status Failed
   4. Reason Code Report by Agent Grouping - GOOD (This was coincidentally
   the first one I imported)
   5. Reason Code Report by Reason Code Grouping -  - Database status Failed

As one example of the error output from a failed run is:

*Error information:*
com.cisco.ccbu.cuic.businesslogic.datasource.CuicDbException: DbException:
CuicDataSourceServiceManagerImpl.getDataSet() { Nested SQLException;
SQLState: IX000 Vendor code: -313 Message: Not owner of table. } at
com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.getDataSetBuilder(CuicDataSourceServiceManagerImpl.java:952)
at
com.cisco.ccbu.cuic.businesslogic.engine.CuicReportEngineWorker.executeQueryUsingDatasetBuilder(CuicReportEngineWorker.java:80)
at
com.cisco.ccbu.cuic.businesslogic.engine.CuicReportEngineWorker.runReport(CuicReportEngineWorker.java:37)
at com.cisco.ccbu.cuic.businesslogic.enginebase.Worker.run(Worker.java:329)
at
com.cisco.ccbu.infra.threads.InstrumentedRunnable.run(InstrumentedRunnable.java:92)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724) at
com.cisco.ccbu.infra.threads.ThreadPoolThread.run(ThreadPoolThread.java:164)
Caused by: java.sql.SQLException: Not owner of table. at
com.informix.jdbc.IfxSqli.a(IfxSqli.java:3643) at
com.informix.jdbc.IfxSqli.E(IfxSqli.java:3974) at
com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2695) at
com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2611) at
com.informix.jdbc.IfxSqli.a(IfxSqli.java:1830) at
com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1768) at
com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1699) at
com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:210) at
com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1237) at
com.informix.jdbc.IfxPreparedStatement.executeQuery(IfxPreparedStatement.java:401)
at
com.informix.jdbc.IfxCallableStatement.executeQuery(IfxCallableStatement.java:241)
at
com.mchange.v2.c3p0.impl.NewProxyCallableStatement.executeQuery(NewProxyCallableStatement.java:2131)
at
com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.executeAndLoadDataset(CuicDataSourceServiceManagerImpl.java:1072)
at
com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.getDataSetBuilder(CuicDataSourceServiceManagerImpl.java:938)
... 8 more Caused by: java.sql.SQLException at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:413) at
com.informix.jdbc.IfxSqli.E(IfxSqli.java:3979) ... 20 more

On Fri, Apr 8, 2016 at 9:30 AM, Anthony Holloway <
avholloway+cisco-v...@gmail.com> wrote:

> I'm only just seeing this now for the first time, and so, I just tried to
> import one report, and so far it worked for me.  I'll try the rest in a
> moment, but for now...
>
> Here's what I have, and what I did.
>
> My UCCX is 10.6.1.11001-31
>
>1. Downloaded CCX_NEWREPORTS.zip from http://www.cisco.com/
>2. Extracted CCX_NEWREPORTS.zip to folder CCX_NEWREPORTS
>3. Opened the Import Guide MS Word document from within the ZIP
>archive and began reading the instructions to import the first report
>4. Downloaded AGS Server Studio from
>http://www.serverstudio.com/downloads/
>5. Followed AGS instructions to install and register the product
>6. Logged into UCCX App Admin and set the password for the Historical
>Reporting User (uccxhruser) under Tools > Password Management
>7. Entered the connections details for UCCX into AGS Server Studio per this
>guide
>
> 
>8. Now I'm connected to UCCX DB, and I can see the DB details in AGS
>Server Studio
>9. I expand Databases on the left, then right click the db_cra
>database and select New > SQL Editor
>10. I open the .sql commands in Notepad++ for the first report in the
>file from the ZIP archived CCX_NEWREPORTS\Report Stored
>Procedures\sp_reasoncode_agent_grouping.sql
>11. Copy those commands from Notepad++ and paste them into the SQL
>Editor pane in AGS Server Studio
>12. Click the Execute button (Green Arrow in Tools Bar) Or you can
>press CTRL+E
>13. Scroll through output in bottom pane and check for errors, I saw
>none
>14. Logged into CUIC as application administrator
>15. Created a new folder under the Reports folder and named it
>"Non-Stock"
>16. Clicked 

Re: [cisco-voip] Additional historical reports available on CCO

2016-04-08 Thread Kevin Przybylowski
I had issues with the reason code reports, the others went in fine.

From: cisco-voip [mailto:cisco-voip-boun...@puck.nether.net] On Behalf Of 
Anthony Holloway
Sent: Friday, April 8, 2016 10:30 AM
To: Ed Leatherman 
Cc: Cisco VOIP 
Subject: Re: [cisco-voip] Additional historical reports available on CCO

I'm only just seeing this now for the first time, and so, I just tried to 
import one report, and so far it worked for me.  I'll try the rest in a moment, 
but for now...

Here's what I have, and what I did.

My UCCX is 10.6.1.11001-31

  1.  Downloaded CCX_NEWREPORTS.zip from http://www.cisco.com/
  2.  Extracted CCX_NEWREPORTS.zip to folder CCX_NEWREPORTS
  3.  Opened the Import Guide MS Word document from within the ZIP archive and 
began reading the instructions to import the first report
  4.  Downloaded AGS Server Studio from http://www.serverstudio.com/downloads/
  5.  Followed AGS instructions to install and register the product
  6.  Logged into UCCX App Admin and set the password for the Historical 
Reporting User (uccxhruser) under Tools > Password Management
  7.  Entered the connections details for UCCX into AGS Server Studio per this 
guide
  8.  Now I'm connected to UCCX DB, and I can see the DB details in AGS Server 
Studio
  9.  I expand Databases on the left, then right click the db_cra database and 
select New > SQL Editor
  10. I open the .sql commands in Notepad++ for the first report in the file 
from the ZIP archived CCX_NEWREPORTS\Report Stored 
Procedures\sp_reasoncode_agent_grouping.sql
  11. Copy those commands from Notepad++ and paste them into the SQL Editor 
pane in AGS Server Studio
  12. Click the Execute button (Green Arrow in Tools Bar) Or you can press 
CTRL+E
  13. Scroll through output in bottom pane and check for errors, I saw none
  14. Logged into CUIC as application administrator
  15. Created a new folder under the Reports folder and named it "Non-Stock"
  16. Clicked Import Reports button at top of Reports page
  17. Clicked Browse to open the report definition for the report I'm importing 
CCX_NEWREPORTS\Report Templates\New Reports\Reason Code Report by Agent 
Grouping.zip
  18. Selected the "Non-Stock" folder as the Save To folder and clicked Import
  19. Got an error about needing to pick data sources, so I picked UCCX as the 
data source for both the definition and the value lists, then clicked Import 
again
  20. I now see a new folder under the folder "Non-Stock" for the report I just 
imported
  21. Within that new folder, which is the name of the report "Reason Code 
Report by Agent Grouping" the report itself is in there, with the same name 
"Reason Code Report by Agent Grouping" (Nesting is good right?)
  22. I click the new report, set some filter, run it and bam, I have a new 
report
The hardest part was obtaining, installing, registering, and configuring AGS 
Server Studio to connect to the UCCX database.  With that done, I can start on 
step 9 for the remainder of the reports.

On Fri, Apr 8, 2016 at 8:30 AM, Ed Leatherman 
> wrote:
Good morning,

It was pointed out to me that there were a handful of new historical reports 
for UCCX/CUIC 10.6/11 up for download on CCO in the downloads section. Others 
might be interested also.

Anyone try these out? I added in the Reason Code Report by agent (added SP and 
template OK) but I just get a Dataset status is Failed (Database error) and 
then a big pile of java error that makes no sense to me. I'm importing the 
report as the appadmin user account so that I can import it into the stock 
reports folder for my internal customers and change permissions on it so they 
can all access it.
Thanks!

--
Ed Leatherman

___
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] Additional historical reports available on CCO

2016-04-08 Thread Anthony Holloway
I'm only just seeing this now for the first time, and so, I just tried to
import one report, and so far it worked for me.  I'll try the rest in a
moment, but for now...

Here's what I have, and what I did.

My UCCX is 10.6.1.11001-31

   1. Downloaded CCX_NEWREPORTS.zip from http://www.cisco.com/
   2. Extracted CCX_NEWREPORTS.zip to folder CCX_NEWREPORTS
   3. Opened the Import Guide MS Word document from within the ZIP archive
   and began reading the instructions to import the first report
   4. Downloaded AGS Server Studio from
   http://www.serverstudio.com/downloads/
   5. Followed AGS instructions to install and register the product
   6. Logged into UCCX App Admin and set the password for the Historical
   Reporting User (uccxhruser) under Tools > Password Management
   7. Entered the connections details for UCCX into AGS Server Studio per this
   guide
   

   8. Now I'm connected to UCCX DB, and I can see the DB details in AGS
   Server Studio
   9. I expand Databases on the left, then right click the db_cra database
   and select New > SQL Editor
   10. I open the .sql commands in Notepad++ for the first report in the
   file from the ZIP archived CCX_NEWREPORTS\Report Stored
   Procedures\sp_reasoncode_agent_grouping.sql
   11. Copy those commands from Notepad++ and paste them into the SQL
   Editor pane in AGS Server Studio
   12. Click the Execute button (Green Arrow in Tools Bar) Or you can press
   CTRL+E
   13. Scroll through output in bottom pane and check for errors, I saw none
   14. Logged into CUIC as application administrator
   15. Created a new folder under the Reports folder and named it
   "Non-Stock"
   16. Clicked Import Reports button at top of Reports page
   17. Clicked Browse to open the report definition for the report I'm
   importing CCX_NEWREPORTS\Report Templates\New Reports\Reason Code Report by
   Agent Grouping.zip
   18. Selected the "Non-Stock" folder as the Save To folder and clicked
   Import
   19. Got an error about needing to pick data sources, so I picked UCCX as
   the data source for both the definition and the value lists, then clicked
   Import again
   20. I now see a new folder under the folder "Non-Stock" for the report I
   just imported
   21. Within that new folder, which is the name of the report "Reason Code
   Report by Agent Grouping" the report itself is in there, with the same name
   "Reason Code Report by Agent Grouping" (Nesting is good right?)
   22. I click the new report, set some filter, run it and bam, I have a
   new report

The hardest part was obtaining, installing, registering, and configuring
AGS Server Studio to connect to the UCCX database.  With that done, I can
start on step 9 for the remainder of the reports.

On Fri, Apr 8, 2016 at 8:30 AM, Ed Leatherman 
wrote:

> Good morning,
>
> It was pointed out to me that there were a handful of new historical
> reports for UCCX/CUIC 10.6/11 up for download on CCO in the downloads
> section. Others might be interested also.
>
> Anyone try these out? I added in the Reason Code Report by agent (added SP
> and template OK) but I just get a Dataset status is Failed (Database error)
> and then a big pile of java error that makes no sense to me. I'm importing
> the report as the appadmin user account so that I can import it into the
> stock reports folder for my internal customers and change permissions on it
> so they can all access it.
> Thanks!
>
> --
> Ed Leatherman
>
> ___
> 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] UCCx 10.5 custom stored procedure for reporting

2016-04-08 Thread Ed Leatherman
Glad to help. I've had tac do the workaround before so if you find you need
the temp tables it's a easy fix - they just have to shell into your UCCX to
create the extra account for you.

On Fri, Apr 8, 2016 at 10:18 AM, Bill Talley  wrote:

> Closing the loop here, this was my issue. I was able to execute a stored
> procedure which wasn't creating a temp table.  Thanks again for sharing Ed.
>
> On Fri, Apr 8, 2016 at 7:27 AM, Ed Leatherman 
> wrote:
>
>> Bill,
>>
>> Does your SP use temporary tables? look at CSCul06940 - I dont know that
>> its resolved in 10.X yet.
>>
>> Ed
>>
>>
>>
>> On Thu, Apr 7, 2016 at 6:06 PM, Bill Talley  wrote:
>>
>>> Hi all,
>>>
>>> Has anyone imported custom stored procedures into the db_cra for use in
>>> CUIC?  I'm having an issue getting a new stored proc loaded using either
>>> RazorSQL or AGS Server Studio.  From what I've read, I need to execute the
>>> stored proc; however, when I do that I get an error that uccxhruser doesn't
>>> have permission to execute the stored proc.  It seems I can't apply
>>> permissions to the uccxhruser account on the stored proc until the stored
>>> proc is loaded.   Would anyone have any tips on how I can go about getting
>>> the stored proc loaded to the database?
>>>
>>> Hopefully this makes sense to someone ;-)
>>>
>>> TIA,
>>> Bill
>>>
>>> ___
>>> cisco-voip mailing list
>>> cisco-voip@puck.nether.net
>>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>>
>>>
>>
>>
>> --
>> Ed Leatherman
>>
>
>


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


Re: [cisco-voip] UCCx 10.5 custom stored procedure for reporting

2016-04-08 Thread Bill Talley
Closing the loop here, this was my issue. I was able to execute a stored
procedure which wasn't creating a temp table.  Thanks again for sharing Ed.

On Fri, Apr 8, 2016 at 7:27 AM, Ed Leatherman 
wrote:

> Bill,
>
> Does your SP use temporary tables? look at CSCul06940 - I dont know that
> its resolved in 10.X yet.
>
> Ed
>
>
>
> On Thu, Apr 7, 2016 at 6:06 PM, Bill Talley  wrote:
>
>> Hi all,
>>
>> Has anyone imported custom stored procedures into the db_cra for use in
>> CUIC?  I'm having an issue getting a new stored proc loaded using either
>> RazorSQL or AGS Server Studio.  From what I've read, I need to execute the
>> stored proc; however, when I do that I get an error that uccxhruser doesn't
>> have permission to execute the stored proc.  It seems I can't apply
>> permissions to the uccxhruser account on the stored proc until the stored
>> proc is loaded.   Would anyone have any tips on how I can go about getting
>> the stored proc loaded to the database?
>>
>> Hopefully this makes sense to someone ;-)
>>
>> TIA,
>> Bill
>>
>> ___
>> cisco-voip mailing list
>> cisco-voip@puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>
>>
>
>
> --
> Ed Leatherman
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip


[cisco-voip] Additional historical reports available on CCO

2016-04-08 Thread Ed Leatherman
Good morning,

It was pointed out to me that there were a handful of new historical
reports for UCCX/CUIC 10.6/11 up for download on CCO in the downloads
section. Others might be interested also.

Anyone try these out? I added in the Reason Code Report by agent (added SP
and template OK) but I just get a Dataset status is Failed (Database error)
and then a big pile of java error that makes no sense to me. I'm importing
the report as the appadmin user account so that I can import it into the
stock reports folder for my internal customers and change permissions on it
so they can all access it.
Thanks!

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


Re: [cisco-voip] bandwidth restrictions for MRA clients - necessary or not?

2016-04-08 Thread Lelio Fulgenzi

Thanks Daniel. This is fantastic information. 



- Original Message -

From: dan...@ohnesorge.me 
To: "Lelio Fulgenzi"  
Cc: cisco-voip@puck.nether.net 
Sent: Wednesday, April 6, 2016 6:29:27 PM 
Subject: Re: [cisco-voip] bandwidth restrictions for MRA clients - necessary or 
not? 



Lelio, 

Jabber has been using something call CPVE for a while; Cisco Precision Video 
Engine. CPVE comes from the Tandberg acquisition and was mainly used in 
Tandberg Movi (later Jabber Video). CPVE indeed starts at a low quality bitrate 
and then assesses the network using RTCP and other technologies to up-scale and 
down-scale as needed. 

You stated your requirement in your initial email - " i'd like to make sure we 
have the best video quality while on-campus". While it's fine to assume that 
over 3G/4G video may be disabled or perhaps a low bandwidth, what about MRA 
clients using home or cafe WiFi? If said WiFi has a fast bandwidth e.g. 50 Mbps 
and your Jabber MRA device calls an on-prem video device, you have no control 
over the bandwidth. 

The idea behind Device Mobility is quite simple, for your case you could do it 
like this; 

- Create a Device Pool named Internet_DP 
- Create Internet_RG region and assign Internet_RG to Internet_DP (Internet_RG 
has region relationships to your on-campus regions limiting the bandwidth e.g. 
512 Kbps max video) 
- Create a Physical Location Internet_PL and Device Mobility Group Internet_DMG 
and assign both to Internet_DP 
- Create a Device Mobility Info (basically a subnet) called Internet_DMI and 
give it the IP of your Expressway-C with subnet mask of 32 e.g. 10.10.10.100/32 
- Associate Internet_DP with the Internet_DMI 
- Enable Device Mobility from CallManager Service Parameters (enabled Device 
Mobility for all phones) or enable on a per-phone basis via BAT or individually 



What happens now is that anytime a BOT/TCT/TAB/CSF/78XX/88XX phone registers 
via Expressway, it's registration IP will always be the IP of Expressway-C. 
CUCM realizes this and essentially changes the DP to Internet_DP where you have 
defined your lower bandwidth region relationships. Once that device comes back 
to the corporate network it will no longer have a registration IP of the 
Expressway-C, rather a normal DHCP IP and will of course use the normal Device 
Pool which you configured which may have a maximum BW of 10 Mbps. 

Hope this helps! 



On 2016-04-07 00:05, Lelio Fulgenzi wrote: 


I honestly don't know. 
I'm new to the whole Jabber world, as well as to video codecs and bit rates. 
I could be worrying about something that I don't need to be, i.e. a 10 minute 
Jabber video call will never use more than X megabytes of data. 
Then again, it's only a matter of time until clients will want to use the 
quality that comes with a mobile phone front facing camera to have a HD video 
call from anywhere. 
--- 
Lelio Fulgenzi, B.A. 
Senior Analyst, Network Infrastructure 
Computing and Communications Services (CCS) 
University of Guelph 
519‐824‐4120 Ext 56354 
le...@uoguelph.ca 
www.uoguelph.ca/ccs 
Room 037, Animal Science and Nutrition Building 
Guelph, Ontario, N1G 2W1 
- Original Message -

From: "Dennis Heim"  
To: "Lelio Fulgenzi" , cisco-voip@puck.nether.net 
Sent: Wednesday, April 6, 2016 10:00:11 AM 
Subject: RE: [cisco-voip] bandwidth restrictions for MRA clients - necessary or 
not? 


Can many mobile jabber devices with cellular connectivity do more than 360p? 




From: cisco-voip [mailto:cisco-voip-boun...@puck.nether.net] On Behalf Of Lelio 
Fulgenzi 
Sent: Wednesday, April 06, 2016 9:53 AM 
To: cisco-voip@puck.nether.net 
Subject: Re: [cisco-voip] bandwidth restrictions for MRA clients - necessary or 
not? 











Thanks Eric. 





I had a similar discussion with a Cisco engineer. Basically, let Jabber figure 
things out. Which is all fine and dandy, until you read that Canada pays some 
of the highest fees for mobile data in the world. lol. 





There are not many unlimited data plans available, and a simple 10 minute video 
call at 10mbps (using 5mbps for calc) could probably use up 3gb of data 
traffic. 





But then, I don't want to impact quality for Jabber clients on wifi 
connections. 





I'm guessing that I might go with leaving device mobility out of the picture 
for now and ensuring video calling is disabled while on mobile networks. 















- Original Message -



From: "Eric Pedersen" < peders...@bennettjones.com > 
To: "Lelio Fulgenzi" < le...@uoguelph.ca >, cisco-voip@puck.nether.net 
Sent: Monday, April 4, 2016 11:00:36 AM 
Subject: RE: [cisco-voip] bandwidth restrictions for MRA clients - necessary or 
not? 





Jabber apparently monitors packet loss and sets the video rate accordingly, 
which is why the quality starts out really low and them improves with the call. 
I don't think any of the phones do that, but I believe the 8845 maximum 
bandwidth is 2mpbs. 

Re: [cisco-voip] UCCx 10.5 custom stored procedure for reporting

2016-04-08 Thread Bill Talley
Cool, this includes everything I had been doing as far as I can tell.  Thanks a 
lot for sharing these details Ed!

Sent from an Apple iOS device with very tiny touchscreen input keys.  Please 
excude my typtos.

> On Apr 8, 2016, at 7:29 AM, Ed Leatherman  wrote:
> 
> I haven't touched this in 2 years - here's notes I took when I was playing 
> around with this before in case it will help:
> http://www.evernote.com/l/AAVCJ8P2UbJG5o0yqjxIO6-9p7edydMHCfE/
> 
>> On Fri, Apr 8, 2016 at 8:27 AM, Ed Leatherman  wrote:
>> Bill,
>>  
>> Does your SP use temporary tables? look at CSCul06940 - I dont know that its 
>> resolved in 10.X yet.
>> 
>> Ed
>> 
>> 
>> 
>>> On Thu, Apr 7, 2016 at 6:06 PM, Bill Talley  wrote:
>>> Hi all,
>>> 
>>> Has anyone imported custom stored procedures into the db_cra for use in 
>>> CUIC?  I'm having an issue getting a new stored proc loaded using either 
>>> RazorSQL or AGS Server Studio.  From what I've read, I need to execute the 
>>> stored proc; however, when I do that I get an error that uccxhruser doesn't 
>>> have permission to execute the stored proc.  It seems I can't apply 
>>> permissions to the uccxhruser account on the stored proc until the stored 
>>> proc is loaded.   Would anyone have any tips on how I can go about getting 
>>> the stored proc loaded to the database?
>>> 
>>> Hopefully this makes sense to someone ;-)
>>> 
>>> TIA,
>>> Bill
>>> 
>>> ___
>>> cisco-voip mailing list
>>> cisco-voip@puck.nether.net
>>> https://puck.nether.net/mailman/listinfo/cisco-voip
>> 
>> 
>> 
>> -- 
>> Ed Leatherman
> 
> 
> 
> -- 
> Ed Leatherman
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip


Re: [cisco-voip] UCCx 10.5 custom stored procedure for reporting

2016-04-08 Thread Bill Talley
It does.  I'll take a look at it.  Thanks!

Sent from an Apple iOS device with very tiny touchscreen input keys.  Please 
excude my typtos.

> On Apr 8, 2016, at 7:27 AM, Ed Leatherman  wrote:
> 
> Bill,
>  
> Does your SP use temporary tables? look at CSCul06940 - I dont know that its 
> resolved in 10.X yet.
> 
> Ed
> 
> 
> 
>> On Thu, Apr 7, 2016 at 6:06 PM, Bill Talley  wrote:
>> Hi all,
>> 
>> Has anyone imported custom stored procedures into the db_cra for use in 
>> CUIC?  I'm having an issue getting a new stored proc loaded using either 
>> RazorSQL or AGS Server Studio.  From what I've read, I need to execute the 
>> stored proc; however, when I do that I get an error that uccxhruser doesn't 
>> have permission to execute the stored proc.  It seems I can't apply 
>> permissions to the uccxhruser account on the stored proc until the stored 
>> proc is loaded.   Would anyone have any tips on how I can go about getting 
>> the stored proc loaded to the database?
>> 
>> Hopefully this makes sense to someone ;-)
>> 
>> TIA,
>> Bill
>> 
>> ___
>> cisco-voip mailing list
>> cisco-voip@puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
> 
> 
> 
> -- 
> Ed Leatherman
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip


Re: [cisco-voip] UCCx 10.5 custom stored procedure for reporting

2016-04-08 Thread Ed Leatherman
I haven't touched this in 2 years - here's notes I took when I was playing
around with this before in case it will help:
http://www.evernote.com/l/AAVCJ8P2UbJG5o0yqjxIO6-9p7edydMHCfE/

On Fri, Apr 8, 2016 at 8:27 AM, Ed Leatherman 
wrote:

> Bill,
>
> Does your SP use temporary tables? look at CSCul06940 - I dont know that
> its resolved in 10.X yet.
>
> Ed
>
>
>
> On Thu, Apr 7, 2016 at 6:06 PM, Bill Talley  wrote:
>
>> Hi all,
>>
>> Has anyone imported custom stored procedures into the db_cra for use in
>> CUIC?  I'm having an issue getting a new stored proc loaded using either
>> RazorSQL or AGS Server Studio.  From what I've read, I need to execute the
>> stored proc; however, when I do that I get an error that uccxhruser doesn't
>> have permission to execute the stored proc.  It seems I can't apply
>> permissions to the uccxhruser account on the stored proc until the stored
>> proc is loaded.   Would anyone have any tips on how I can go about getting
>> the stored proc loaded to the database?
>>
>> Hopefully this makes sense to someone ;-)
>>
>> TIA,
>> Bill
>>
>> ___
>> cisco-voip mailing list
>> cisco-voip@puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>
>>
>
>
> --
> Ed Leatherman
>



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


Re: [cisco-voip] UCCx 10.5 custom stored procedure for reporting

2016-04-08 Thread Ed Leatherman
Bill,

Does your SP use temporary tables? look at CSCul06940 - I dont know that
its resolved in 10.X yet.

Ed



On Thu, Apr 7, 2016 at 6:06 PM, Bill Talley  wrote:

> Hi all,
>
> Has anyone imported custom stored procedures into the db_cra for use in
> CUIC?  I'm having an issue getting a new stored proc loaded using either
> RazorSQL or AGS Server Studio.  From what I've read, I need to execute the
> stored proc; however, when I do that I get an error that uccxhruser doesn't
> have permission to execute the stored proc.  It seems I can't apply
> permissions to the uccxhruser account on the stored proc until the stored
> proc is loaded.   Would anyone have any tips on how I can go about getting
> the stored proc loaded to the database?
>
> Hopefully this makes sense to someone ;-)
>
> TIA,
> Bill
>
> ___
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>


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


Re: [cisco-voip] H323 call rejection using Translation Profile not working

2016-04-08 Thread Jeffrey Girard
Ryan -
Yes, I agree, and thanks for the input.

However, the intent here was not to "meet a customer 
requirement"

I was trying to learn a new skill that I had not previously used

But I certainly appreciate your willingness to help ?

Jeff

From: Ryan Huff [mailto:ryanh...@outlook.com]
Sent: Friday, April 8, 2016 8:00 AM
To: Jeffrey Girard
Cc: Sreekanth; cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] H323 call rejection using Translation Profile not 
working

Hi Jeff,

While I certainly would not want to usurp Sreekanth, since you stated you are 
using CUCME, there may be a much easier way for you to do this;

telephony-service
!
after-hours block pattern 1000 7-24
!

Thanks,

Ryan

On Apr 8, 2016, at 7:46 AM, Jeffrey Girard 
> wrote:
Results of debug voice ccpai inout are below.  I moved the test bed onto an 
actual PSTN line and used my cell phone as the call to be blocked.  Thus I have 
sanitized the number

Snipped output

Apr  8 11:10:38.654: //-1/5BEF8EB8800B/CCAPI/cc_api_call_setup_ind_common:
   Interface=0x4AC94CCC, Call Info(
   Calling Number=TEST CALLING NUMBER,(Calling Name=)(TON=Unknown, NPI=Unknown, 
Screening=Not Screened, Presentation=Allowed),
   Called Number=TEST CALLED NUMBER(TON=Unknown, NPI=Unknown),
   Calling Translated=FALSE, Subscriber Type Str=RegularLine, 
FinalDestinationFlag=TRUE,
   Incoming Dial-peer=100, Progress Indication=ORIGINATING SIDE IS NON ISDN(3), 
Calling IE Present=TRUE,
   Source Trkgrp Route Label=, Target Trkgrp Route Label=, CLID 
Transparent=FALSE), Call Id=-1


Apr  8 11:10:38.662: //4/5BEF8EB8800B/CCAPI/cc_process_call_setup_ind:
   CCAPI handed cid 4 with tag 100 to app "_ManagedAppProcess_Default"  
<< correct dial peer 100
Apr  8 11:10:38.666: //4/5BEF8EB8800B/CCAPI/ccCallDisconnect:
   Cause Value=21, Tag=0x0, Call Entry(Previous Disconnect Cause=0, Disconnect 
Cause=0)  <>>>CCAPI handed cid 5 with tag 0 to app "_ManagedAppProcess_Default"  
mailto:sknt...@gmail.com]
Sent: Friday, April 8, 2016 5:25 AM
To: Jeffrey Girard
Cc: cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] H323 call rejection using Translation Profile not 
working

Can you share these debugs for a test call?
debug voip ccapi inout
debug voip translation
debug voip dialpeer



On 8 April 2016 at 07:05, Jeffrey Girard 
> wrote:
All -
Playing around with call blocking using an H.323 gateway.

Gateway has an FXO port and it is configured as an H323 GW to a 
CUCM.

Here is the code

voice translation-rule 1
rule 1 reject /1000/
exit

voice translation-profile call_block
translate calling 1
exit

dial-peer voice 100 pots
answer-address 1000
translation-profile incoming call_block
call-block translation-profile incoming call_block
call-block disconnect-cause call-reject

If I do a test of the translation profile using
Test voice translation-rule 1 /1000/
I get
/1000/ blocked on rule 1

However, when I have debug voice dialpeer enabled, I see that the incoming call 
matches on the correct dial peer (dial peer 100) and then continues to process 
and searches for an outbound dial peer.

I have tried several variations.  I have taken out the "translation-profile 
incoming call_block" command from the dial peer.  I have tried adding the 
command "translation-profile incoming call_block" directly to the voice port.

In all instances, the correct incoming dial peer matches, but then it seems 
like the translation profile does not get called.

Any thoughts?

Jeff

___
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


Re: [cisco-voip] H323 call rejection using Translation Profile not working

2016-04-08 Thread Jeffrey Girard
That makes sense……

Thanks.  I will take this up with my TELCO and confirm that is what is going on

From: Sreekanth [mailto:sknt...@gmail.com]
Sent: Friday, April 8, 2016 7:58 AM
To: Jeffrey Girard
Cc: cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] H323 call rejection using Translation Profile not 
working

It looks like the original call is being disconnected, and there is a new call.
The original GUID and call leg were:4/5BEF8EB8800B and the call was 
disconnected at 11:10:44
Apr  8 11:10:44.662: //4/5BEF8EB8800B/CCAPI/cc_api_call_disconnect_done:
   Call Disconnect Event Sent
11 seconds later, the second call comes in.
Apr  8 11:10:55.558: //-1/6602DE26800F/CCAPI/cc_api_display_ie_subfields:

You might want to check if the Telco is sending the call back to us as a 
redundant mechanism after we reject it.
debug vpm signal, debug voip vtsp default will provide more input on what 
happens on the FXO side.
Sreekanth


On 8 April 2016 at 17:15, Jeffrey Girard 
> wrote:
Results of debug voice ccpai inout are below.  I moved the test bed onto an 
actual PSTN line and used my cell phone as the call to be blocked.  Thus I have 
sanitized the number

Snipped output

Apr  8 11:10:38.654: //-1/5BEF8EB8800B/CCAPI/cc_api_call_setup_ind_common:
   Interface=0x4AC94CCC, Call Info(
   Calling Number=TEST CALLING NUMBER,(Calling Name=)(TON=Unknown, NPI=Unknown, 
Screening=Not Screened, Presentation=Allowed),
   Called Number=TEST CALLED NUMBER(TON=Unknown, NPI=Unknown),
   Calling Translated=FALSE, Subscriber Type Str=RegularLine, 
FinalDestinationFlag=TRUE,
   Incoming Dial-peer=100, Progress Indication=ORIGINATING SIDE IS NON ISDN(3), 
Calling IE Present=TRUE,
   Source Trkgrp Route Label=, Target Trkgrp Route Label=, CLID 
Transparent=FALSE), Call Id=-1


Apr  8 11:10:38.662: //4/5BEF8EB8800B/CCAPI/cc_process_call_setup_ind:
   CCAPI handed cid 4 with tag 100 to app "_ManagedAppProcess_Default"  
<< correct dial peer 100
Apr  8 11:10:38.666: //4/5BEF8EB8800B/CCAPI/ccCallDisconnect:
   Cause Value=21, Tag=0x0, Call Entry(Previous Disconnect Cause=0, Disconnect 
Cause=0)  <
   cisco-desttype=0
   cisco-destplan=0
   cisco-rdie=
   cisco-rdn=
   cisco-rdntype=0
   cisco-rdnplan=0
   cisco-rdnpi=0
   cisco-rdnsi=0
   cisco-redirectreason=0   fwd_final_type =0
   final_redirectNumber =
   hunt_group_timeout =0

Apr  8 11:10:55.558: //-1/6602DE26800F/CCAPI/cc_api_call_setup_ind_common:
   Interface=0x4AC94CCC, Call Info(
   Calling Number=,(Calling Name=)(TON=Unknown, NPI=Unknown, Screening=Not 
Screened, Presentation=Allowed),  <<<(TON=Unknown, NPI=Unknown))
Apr  8 11:10:55.566: //5/6602DE26800F/CCAPI/cc_process_call_setup_ind:
   Event=0x4AC4A460
Apr  8 11:10:55.566: //-1//CCAPI/cc_setupind_match_search:
   Try with the demoted called number 6078350406
Apr  8 11:10:55.566: //5/6602DE26800F/CCAPI/ccCallSetContext:
   Context=0x4BDFE058
Apr  8 11:10:55.566: //5/6602DE26800F/CCAPI/cc_process_call_setup_ind:
   CCAPI handed cid 5 with tag 0 to app "_ManagedAppProcess_Default"  
, saf_enabled=0, saf_dndb_lookup=1, 
dp_result=0
Apr  8 11:35:54.677: //-1//DPM/dpMatchPeersMoreArg:
   Result=SUCCESS(0)
   List of Matched Outgoing Dial-peer(s):
 1: Dial-peer Tag=8350406

So, the question becomes – why does CUCME continue to try to find a matching 
dial peer after the incoming dial peer has already rejected the call?

Jeff

From: Sreekanth [mailto:sknt...@gmail.com]
Sent: Friday, April 8, 2016 5:25 AM
To: Jeffrey Girard
Cc: cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] H323 call rejection using Translation Profile not 
working

Can you share these debugs for a test call?
debug voip ccapi inout
debug voip translation
debug voip dialpeer

On 8 April 2016 at 07:05, Jeffrey Girard 
> wrote:
All –
Playing around with call blocking using an H.323 gateway.

Gateway has an FXO port and it is configured as an H323 GW to a 
CUCM.

Here is the code

voice translation-rule 1
rule 1 reject /1000/
exit

voice translation-profile call_block
translate calling 1
exit

dial-peer voice 100 pots
answer-address 1000
translation-profile incoming call_block
call-block translation-profile incoming call_block
call-block disconnect-cause call-reject

If I do a test of the translation profile using
Test voice translation-rule 1 /1000/
I get
/1000/ blocked on rule 1

However, when I have debug voice dialpeer enabled, I see that the incoming call 
matches on the correct dial peer (dial peer 100) and then continues to process 
and searches for an outbound dial peer.

I have tried several variations.  I have taken out 

Re: [cisco-voip] H323 call rejection using Translation Profile not working

2016-04-08 Thread Ryan Huff
Hi Jeff,

While I certainly would not want to usurp Sreekanth, since you stated you are 
using CUCME, there may be a much easier way for you to do this;

telephony-service
!
after-hours block pattern 1000 7-24
!

Thanks,

Ryan

On Apr 8, 2016, at 7:46 AM, Jeffrey Girard 
> wrote:

Results of debug voice ccpai inout are below.  I moved the test bed onto an 
actual PSTN line and used my cell phone as the call to be blocked.  Thus I have 
sanitized the number

Snipped output

Apr  8 11:10:38.654: //-1/5BEF8EB8800B/CCAPI/cc_api_call_setup_ind_common:
   Interface=0x4AC94CCC, Call Info(
   Calling Number=TEST CALLING NUMBER,(Calling Name=)(TON=Unknown, NPI=Unknown, 
Screening=Not Screened, Presentation=Allowed),
   Called Number=TEST CALLED NUMBER(TON=Unknown, NPI=Unknown),
   Calling Translated=FALSE, Subscriber Type Str=RegularLine, 
FinalDestinationFlag=TRUE,
   Incoming Dial-peer=100, Progress Indication=ORIGINATING SIDE IS NON ISDN(3), 
Calling IE Present=TRUE,
   Source Trkgrp Route Label=, Target Trkgrp Route Label=, CLID 
Transparent=FALSE), Call Id=-1


Apr  8 11:10:38.662: //4/5BEF8EB8800B/CCAPI/cc_process_call_setup_ind:
   CCAPI handed cid 4 with tag 100 to app "_ManagedAppProcess_Default"  
<< correct dial peer 100
Apr  8 11:10:38.666: //4/5BEF8EB8800B/CCAPI/ccCallDisconnect:
   Cause Value=21, Tag=0x0, Call Entry(Previous Disconnect Cause=0, Disconnect 
Cause=0)  <>>>CCAPI handed cid 5 with tag 0 to app "_ManagedAppProcess_Default"  
mailto:sknt...@gmail.com]
Sent: Friday, April 8, 2016 5:25 AM
To: Jeffrey Girard
Cc: cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] H323 call rejection using Translation Profile not 
working

Can you share these debugs for a test call?
debug voip ccapi inout
debug voip translation
debug voip dialpeer


On 8 April 2016 at 07:05, Jeffrey Girard 
> wrote:
All -
Playing around with call blocking using an H.323 gateway.

Gateway has an FXO port and it is configured as an H323 GW to a 
CUCM.

Here is the code

voice translation-rule 1
rule 1 reject /1000/
exit

voice translation-profile call_block
translate calling 1
exit

dial-peer voice 100 pots
answer-address 1000
translation-profile incoming call_block
call-block translation-profile incoming call_block
call-block disconnect-cause call-reject

If I do a test of the translation profile using
Test voice translation-rule 1 /1000/
I get
/1000/ blocked on rule 1

However, when I have debug voice dialpeer enabled, I see that the incoming call 
matches on the correct dial peer (dial peer 100) and then continues to process 
and searches for an outbound dial peer.

I have tried several variations.  I have taken out the "translation-profile 
incoming call_block" command from the dial peer.  I have tried adding the 
command "translation-profile incoming call_block" directly to the voice port.

In all instances, the correct incoming dial peer matches, but then it seems 
like the translation profile does not get called.

Any thoughts?

Jeff

___
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


Re: [cisco-voip] H323 call rejection using Translation Profile not working

2016-04-08 Thread Sreekanth
It looks like the original call is being disconnected, and there is a new
call.
The original GUID and call leg were:4/5BEF8EB8800B and the call was
disconnected at 11:10:44

Apr  8 11:10:44.662: //4/5BEF8EB8800B/CCAPI/cc_api_call_disconnect_done:
   Call Disconnect Event Sent

11 seconds later, the second call comes in.
Apr  8 11:10:55.558: //-1/6602DE26800F/CCAPI/cc_api_display_ie_subfields:

You might want to check if the Telco is sending the call back to us as a
redundant mechanism after we reject it.
debug vpm signal, debug voip vtsp default will provide more input on what
happens on the FXO side.

Sreekanth


On 8 April 2016 at 17:15, Jeffrey Girard 
wrote:

> Results of debug voice ccpai inout are below.  I moved the test bed onto
> an actual PSTN line and used my cell phone as the call to be blocked.  Thus
> I have sanitized the number
>
>
>
> Snipped output
>
>
>
> Apr  8 11:10:38.654: //-1/5BEF8EB8800B/CCAPI/cc_api_call_setup_ind_common:
>
>Interface=0x4AC94CCC, Call Info(
>
>Calling Number=TEST CALLING NUMBER,(Calling Name=)(TON=Unknown,
> NPI=Unknown, Screening=Not Screened, Presentation=Allowed),
>
>Called Number=TEST CALLED NUMBER(TON=Unknown, NPI=Unknown),
>
>Calling Translated=FALSE, Subscriber Type Str=RegularLine,
> FinalDestinationFlag=TRUE,
>
>Incoming Dial-peer=100, Progress Indication=ORIGINATING SIDE IS NON
> ISDN(3), Calling IE Present=TRUE,
>
>Source Trkgrp Route Label=, Target Trkgrp Route Label=, CLID
> Transparent=FALSE), Call Id=-1
>
>
>
>
>
> Apr  8 11:10:38.662: //4/5BEF8EB8800B/CCAPI/cc_process_call_setup_ind:
>
>CCAPI handed cid 4 with tag 100 to app
> "_ManagedAppProcess_Default"  << correct dial peer
> 100
>
> Apr  8 11:10:38.666: //4/5BEF8EB8800B/CCAPI/ccCallDisconnect:
>
>Cause Value=21, Tag=0x0, Call Entry(Previous Disconnect Cause=0,
> Disconnect Cause=0)  <
> Apr  8 11:10:38.666: //4/5BEF8EB8800B/CCAPI/ccCallDisconnect:
>
>Cause Value=21, Call Entry(Responsed=TRUE, Cause Value=21)
>
> Apr  8 11:10:38.666: //4/5BEF8EB8800B/CCAPI/cc_api_get_transfer_info:
>
>Transfer Number Is Null
>
> Apr  8 11:10:44.658: //4/5BEF8EB8800B/CCAPI/cc_api_call_disconnect_done:
>
>Disposition=0, Interface=0x4AC94CCC, Tag=0x0, Call Id=4,
>
>Call Entry(Disconnect Cause=21, Voice Class Cause Code=0, Retry Count=0)
>
> Apr  8 11:10:44.662: //4/5BEF8EB8800B/CCAPI/cc_api_call_disconnect_done:
>
>Call Disconnect Event Sent
> <
> Apr  8 11:10:44.662: //-1//CCAPI/cc_free_feature_vsa:
>
>
>
> Apr  8 11:10:44.662: :cc_free_feature_vsa freeing 4B8F1520
>
> Apr  8 11:10:44.662: //-1//CCAPI/cc_free_feature_vsa:
>
>
>
> Apr  8 11:10:44.662:  vsacount in free is 0
>
> Apr  8 11:10:55.558: //-1/6602DE26800F/CCAPI/cc_api_display_ie_subfields:
>
>cc_api_call_setup_ind_common:
>
>cisco-username=
>
>- ccCallInfo IE subfields -
>
>cisco-ani=
>
>cisco-anitype=0
>
>cisco-aniplan=0
>
>cisco-anipi=0
>
>cisco-anisi=0
>
>dest=6078350406
>
>cisco-desttype=0
>
>cisco-destplan=0
>
>cisco-rdie=
>
>cisco-rdn=
>
>cisco-rdntype=0
>
>cisco-rdnplan=0
>
>cisco-rdnpi=0
>
>cisco-rdnsi=0
>
>cisco-redirectreason=0   fwd_final_type =0
>
>final_redirectNumber =
>
>hunt_group_timeout =0
>
>
>
> Apr  8 11:10:55.558: //-1/6602DE26800F/CCAPI/cc_api_call_setup_ind_common:
>
>Interface=0x4AC94CCC, Call Info(
>
>Calling Number=,(Calling Name=)(TON=Unknown, NPI=Unknown, Screening=Not
> Screened, Presentation=Allowed),  <<< with no calling number
>
>Called Number=TEST CALLED NUMBER(TON=Unknown, NPI=Unknown),
>
>Calling Translated=FALSE, Subscriber Type Str=RegularLine,
> FinalDestinationFlag=TRUE,
>
>Incoming Dial-peer=0, Progress Indication=ORIGINATING SIDE IS NON
> ISDN(3), Calling IE Present=FALSE,
>
>Source Trkgrp Route Label=, Target Trkgrp Route Label=, CLID
> Transparent=FALSE), Call Id=-1
>
> Apr  8 11:10:55.558: //-1//CCAPI/cc_get_feature_vsa:
>
>
>
> Apr  8 11:10:55.558: :cc_get_feature_vsa malloc success
>
> Apr  8 11:10:55.558: //-1//CCAPI/cc_get_feature_vsa:
>
>
>
> Apr  8 11:10:55.558:  cc_get_feature_vsa count is 1
>
> Apr  8 11:10:55.558: //-1//CCAPI/cc_get_feature_vsa:
>
>
>
> Apr  8 11:10:55.558: :FEATURE_VSA attributes are:
> feature_name:0,feature_time:1267668264,feature_id:5
>
> Apr  8 11:10:55.562: //5/6602DE26800F/CCAPI/cc_api_call_setup_ind_common:
>
>Set Up Event Sent;
>
>Call Info(Calling Number=(TON=Unknown, NPI=Unknown, Screening=Not
> Screened, Presentation=Allowed),
>
>Called Number=6078350406(TON=Unknown, NPI=Unknown))
>
> Apr  8 11:10:55.566: //5/6602DE26800F/CCAPI/cc_process_call_setup_ind:
>
>Event=0x4AC4A460
>
> Apr  8 11:10:55.566: //-1//CCAPI/cc_setupind_match_search:
>
>Try with the demoted called number 6078350406
>
> 

Re: [cisco-voip] H323 call rejection using Translation Profile not working

2016-04-08 Thread Jeffrey Girard
Results of debug voice ccpai inout are below.  I moved the test bed onto an 
actual PSTN line and used my cell phone as the call to be blocked.  Thus I have 
sanitized the number

Snipped output

Apr  8 11:10:38.654: //-1/5BEF8EB8800B/CCAPI/cc_api_call_setup_ind_common:
   Interface=0x4AC94CCC, Call Info(
   Calling Number=TEST CALLING NUMBER,(Calling Name=)(TON=Unknown, NPI=Unknown, 
Screening=Not Screened, Presentation=Allowed),
   Called Number=TEST CALLED NUMBER(TON=Unknown, NPI=Unknown),
   Calling Translated=FALSE, Subscriber Type Str=RegularLine, 
FinalDestinationFlag=TRUE,
   Incoming Dial-peer=100, Progress Indication=ORIGINATING SIDE IS NON ISDN(3), 
Calling IE Present=TRUE,
   Source Trkgrp Route Label=, Target Trkgrp Route Label=, CLID 
Transparent=FALSE), Call Id=-1


Apr  8 11:10:38.662: //4/5BEF8EB8800B/CCAPI/cc_process_call_setup_ind:
   CCAPI handed cid 4 with tag 100 to app "_ManagedAppProcess_Default"  
<< correct dial peer 100
Apr  8 11:10:38.666: //4/5BEF8EB8800B/CCAPI/ccCallDisconnect:
   Cause Value=21, Tag=0x0, Call Entry(Previous Disconnect Cause=0, Disconnect 
Cause=0)  <>>>CCAPI handed cid 5 with tag 0 to app "_ManagedAppProcess_Default"  
mailto:sknt...@gmail.com]
Sent: Friday, April 8, 2016 5:25 AM
To: Jeffrey Girard
Cc: cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] H323 call rejection using Translation Profile not 
working

Can you share these debugs for a test call?
debug voip ccapi inout
debug voip translation
debug voip dialpeer


On 8 April 2016 at 07:05, Jeffrey Girard 
> wrote:
All –
Playing around with call blocking using an H.323 gateway.

Gateway has an FXO port and it is configured as an H323 GW to a 
CUCM.

Here is the code

voice translation-rule 1
rule 1 reject /1000/
exit

voice translation-profile call_block
translate calling 1
exit

dial-peer voice 100 pots
answer-address 1000
translation-profile incoming call_block
call-block translation-profile incoming call_block
call-block disconnect-cause call-reject

If I do a test of the translation profile using
Test voice translation-rule 1 /1000/
I get
/1000/ blocked on rule 1

However, when I have debug voice dialpeer enabled, I see that the incoming call 
matches on the correct dial peer (dial peer 100) and then continues to process 
and searches for an outbound dial peer.

I have tried several variations.  I have taken out the “translation-profile 
incoming call_block” command from the dial peer.  I have tried adding the 
command “translation-profile incoming call_block” directly to the voice port.

In all instances, the correct incoming dial peer matches, but then it seems 
like the translation profile does not get called.

Any thoughts?

Jeff

___
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