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

[Kevin Przybylowski]

Thanks Abhiram!  I validated the same scenario as well in our lab - broken 
reports now all work as expected in SU2.

We look forward to any/all CCX enhancements, keep em coming!

Kevin P.

From: Abhiram Kramadhati (akramadh) [mailto:akram...@cisco.com]
Sent: Tuesday, April 12, 2016 8:24 PM
To: Ed Leatherman <ealeather...@gmail.com>
Cc: Kevin Przybylowski <kev...@advancedtsg.com>; Anthony Holloway 
<avholloway+cisco-v...@gmail.com>; Justin Steinberg <jsteinb...@gmail.com>; 
cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] Additional historical reports available on CCO

Hi Ed,

After the upgrade, all the reports will be moved into the Stock folder and the 
SP's will be loaded as the Informix user - who has permission over the Temp 
tables, hence you won't have issues.

Thank you, Anthony, for confirming the same.

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

From: Ed Leatherman <ealeather...@gmail.com<mailto:ealeather...@gmail.com>>
Date: Tuesday, 12 April 2016 at 9:02 PM
To: akramadh <akram...@cisco.com<mailto:akram...@cisco.com>>
Cc: Kevin Przybylowski <kev...@advancedtsg.com<mailto:kev...@advancedtsg.com>>, 
Anthony Holloway 
<avholloway+cisco-v...@gmail.com<mailto:avholloway+cisco-v...@gmail.com>>, 
Justin Steinberg <jsteinb...@gmail.com<mailto:jsteinb...@gmail.com>>, 
"cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>" 
<cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>>
Subject: Re: [cisco-voip] Additional historical reports available on CCO

Hi Abhiram,

Thanks for all the background info, and the heads up about SU2 (i've been 
waiting on that one for another bug fix)

Since the new reports are pre-bundled in SU2, do you foresee any problems 
applying SU2 if we've added or tried to add one or more of the new reports 
already? I am mainly thinking of SP's that have been added already.

Ed

On Mon, Apr 11, 2016 at 9:57 PM, Abhiram Kramadhati (akramadh) 
<akram...@cisco.com<mailto:akram...@cisco.com>> wrote:
Hi all,

We had a quick discussion yesterday to address this and here is the summary:

  1.  CUIC currently executes the SP's as (uccxhrc user) - this is a problem 
due to an Informix defect, corrected in the next release. Why is this a 
problem? According to Informix, for a user to delete the temp tables the user 
has to be the owner of the same. The owner of the temp table is usually 
designated to be the same as the owner of the SP - uccxhruser in our case. Now, 
since the execution is happening as uccxhrc user and the owner is uccxhruser, 
there is a conflict and hence the errors. Refreshing the CUIC datasource fixes 
this temporarily because temp tables are cleared out. The permanent fix is to 
import the SP as the uccxhrc user. Since the uccxhrc user does not have default 
privileges to create SP's, please call into TAC and they can run the commands 
for you from the root. This is the defect CSCul06940
  2.  We have pre-bundled these reports in 10.6(1)SU2 and the same has been 
released yesterday. Since they are pre-bundled, you will not have this problem.
  3.  11.0(1) currently does not have this pre-bundled, since it was released a 
few months back. So if you upgrade from 10.6(1)SU2 to 11.0(1), you will lose 
these reports - you will have to reimport them. So please be mindful of point 
1. Tentatively, we will pre-bundle them on SU's on 11.0(1). So you should be 
able to upgrade to that from 10.6(1)SU2 and still have the reports.

The defect CSCul06940 will affect other custom reports as well (because of 
point1). However, in 11.5 the user uccxhrc has been deleted. That is the long 
term fix. It is an informix fix, hence the challenges to back port.

Updated release notes for the reports will be uploaded soon. Please let me know 
if you have any questions.

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

From: cisco-voip 
<cisco-voip-boun...@puck.nether.net<mailto:cisco-voip-boun...@puck.nether.net>> 
on behalf of akramadh <akram...@cisco.com<mailto:akram...@cisco.com>>
Date: Monday, 11 April 2016 at 10:41 AM
To: Kevin Przybylowski <kev...@advancedtsg.com<mailto:kev...@advancedtsg.com>>, 
Ed Leatherman <ealeather...@gmail.com<mailto:ealeather...@gmail.com>>, Anthony 
Holloway 
<avholloway+cisco-v...@gmail.com<mailto:avholloway+cisco-v...@gmail.com>>, 
Justin Steinberg <jsteinb...@gmail.com<mailto:jsteinb...@gmail.com>>

Cc: "cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>" 
<cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>>
Subject: Re: [cisco-voip] Additional historical reports available on CCO

Hi all,

Let me find more details on the issue you are facing. We introduced these 
reports over the last quarter and more will be ava

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

[Abhiram Kramadhati (akramadh)]

Hi Ed,

After the upgrade, all the reports will be moved into the Stock folder and the 
SP’s will be loaded as the Informix user – who has permission over the Temp 
tables, hence you won’t have issues.

Thank you, Anthony, for confirming the same.

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

From: Ed Leatherman <ealeather...@gmail.com<mailto:ealeather...@gmail.com>>
Date: Tuesday, 12 April 2016 at 9:02 PM
To: akramadh <akram...@cisco.com<mailto:akram...@cisco.com>>
Cc: Kevin Przybylowski <kev...@advancedtsg.com<mailto:kev...@advancedtsg.com>>, 
Anthony Holloway 
<avholloway+cisco-v...@gmail.com<mailto:avholloway+cisco-v...@gmail.com>>, 
Justin Steinberg <jsteinb...@gmail.com<mailto:jsteinb...@gmail.com>>, 
"cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>" 
<cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>>
Subject: Re: [cisco-voip] Additional historical reports available on CCO

Hi Abhiram,

Thanks for all the background info, and the heads up about SU2 (i've been 
waiting on that one for another bug fix)

Since the new reports are pre-bundled in SU2, do you foresee any problems 
applying SU2 if we've added or tried to add one or more of the new reports 
already? I am mainly thinking of SP's that have been added already.

Ed

On Mon, Apr 11, 2016 at 9:57 PM, Abhiram Kramadhati (akramadh) 
<akram...@cisco.com<mailto:akram...@cisco.com>> wrote:
Hi all,

We had a quick discussion yesterday to address this and here is the summary:

  1.  CUIC currently executes the SP’s as (uccxhrc user) - this is a problem 
due to an Informix defect, corrected in the next release. Why is this a 
problem? According to Informix, for a user to delete the temp tables the user 
has to be the owner of the same. The owner of the temp table is usually 
designated to be the same as the owner of the SP – uccxhruser in our case. Now, 
since the execution is happening as uccxhrc user and the owner is uccxhruser, 
there is a conflict and hence the errors. Refreshing the CUIC datasource fixes 
this temporarily because temp tables are cleared out. The permanent fix is to 
import the SP as the uccxhrc user. Since the uccxhrc user does not have default 
privileges to create SP’s, please call into TAC and they can run the commands 
for you from the root. This is the defect CSCul06940
  2.  We have pre-bundled these reports in 10.6(1)SU2 and the same has been 
released yesterday. Since they are pre-bundled, you will not have this problem.
  3.  11.0(1) currently does not have this pre-bundled, since it was released a 
few months back. So if you upgrade from 10.6(1)SU2 to 11.0(1), you will lose 
these reports – you will have to reimport them. So please be mindful of point 
1. Tentatively, we will pre-bundle them on SU’s on 11.0(1). So you should be 
able to upgrade to that from 10.6(1)SU2 and still have the reports.

The defect CSCul06940 will affect other custom reports as well (because of 
point1). However, in 11.5 the user uccxhrc has been deleted. That is the long 
term fix. It is an informix fix, hence the challenges to back port.

Updated release notes for the reports will be uploaded soon. Please let me know 
if you have any questions.

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

From: cisco-voip 
<cisco-voip-boun...@puck.nether.net<mailto:cisco-voip-boun...@puck.nether.net>> 
on behalf of akramadh <akram...@cisco.com<mailto:akram...@cisco.com>>
Date: Monday, 11 April 2016 at 10:41 AM
To: Kevin Przybylowski <kev...@advancedtsg.com<mailto:kev...@advancedtsg.com>>, 
Ed Leatherman <ealeather...@gmail.com<mailto:ealeather...@gmail.com>>, Anthony 
Holloway 
<avholloway+cisco-v...@gmail.com<mailto:avholloway+cisco-v...@gmail.com>>, 
Justin Steinberg <jsteinb...@gmail.com<mailto:jsteinb...@gmail.com>>

Cc: "cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>" 
<cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>>
Subject: Re: [cisco-voip] Additional historical reports available on CCO

Hi all,

Let me find more details on the issue you are facing. We introduced these 
reports over the last quarter and more will be available as well; and all of 
them have undergone the regular testing cycle. But let me see how best to 
address this.

[http://www.cisco.com/c/dam/assets/email-signature-tool/logo_07.png?ct=1421802598153]

Abhiram Kramadhati
Technical Solutions Manager
Customer Solutions Success team, CCBU
akram...@cisco.com<mailto:akram...@cisco.com>
Phone: +61 2 8446 6257<tel:%2B61%202%208446%206257>

CCIE Collaboration  - 40065


Cisco Systems Australia Pty Limited
The Forum
201 Pacific Highway
2065
St Leonards
Australia
Cisco.com<http://www.cisco.com/web/AU/>


[http://www.cisco.com/assets/soci

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

[Anthony Holloway]

I took my broken 10.6.(1)SU1 system, upgraded it to 10.6(1)SU2 today, and
the reports I imported are now showing up under Stock reports, and they
work.

On Mon, Apr 11, 2016 at 8:57 PM, Abhiram Kramadhati (akramadh) <
akram...@cisco.com> wrote:

> Hi all,
>
> We had a quick discussion yesterday to address this and here is the
> summary:
>
>1. CUIC currently executes the SP’s as (uccxhrc user) - this is a
>problem due to an Informix defect, corrected in the next release. Why is
>this a problem? According to Informix, for a user to delete the temp tables
>the user has to be the owner of the same. The owner of the temp table is
>usually designated to be the same as the owner of the SP – *uccxhruser*
>in our case. Now, since the execution is happening as *uccxhrc* user
>and the owner is *uccxhruser*, there is a conflict and hence the
>errors. Refreshing the CUIC datasource fixes this temporarily because temp
>tables are cleared out. The permanent fix is to import the SP as the
>*uccxhrc* user. Since the *uccxhrc* user does not have default
>privileges to create SP’s, please call into TAC and they can run the
>commands for you from the root. This is the defect CSCul06940
>2. We have pre-bundled these reports in 10.6(1)SU2 and the same has
>been released yesterday. Since they are pre-bundled, you will not have this
>problem.
>3. 11.0(1) currently does not have this pre-bundled, since it was
>released a few months back. So if you upgrade from 10.6(1)SU2 to 11.0(1),
>you will lose these reports – you will have to reimport them. So please be
>mindful of point 1. Tentatively, we will pre-bundle them on SU’s on
>11.0(1). So you should be able to upgrade to that from 10.6(1)SU2 and still
>have the reports.
>
>
> The defect CSCul06940 will affect other custom reports as well (because of
> point1). However, in 11.5 the user *uccxhrc* has been deleted. That is
> the long term fix. It is an informix fix, hence the challenges to back
> port.
>
> Updated release notes for the reports will be uploaded soon. Please let me
> know if you have any questions.
>
> Regards,
> Abhiram Kramadhati
> Technical Solutions Manager, CCBU
> CCIE Collaboration # 40065
>
> From: cisco-voip <cisco-voip-boun...@puck.nether.net> on behalf of
> akramadh <akram...@cisco.com>
> Date: Monday, 11 April 2016 at 10:41 AM
> To: Kevin Przybylowski <kev...@advancedtsg.com>, Ed Leatherman <
> ealeather...@gmail.com>, Anthony Holloway <avholloway+cisco-v...@gmail.com>,
> Justin Steinberg <jsteinb...@gmail.com>
>
> Cc: "cisco-voip@puck.nether.net" <cisco-voip@puck.nether.net>
> Subject: Re: [cisco-voip] Additional historical reports available on CCO
>
> Hi all,
>
> Let me find more details on the issue you are facing. We introduced these
> reports over the last quarter and more will be available as well; and all
> of them have undergone the regular testing cycle. But let me see how best
> to address this.
>
> *Abhiram Kramadhati*
> Technical Solutions Manager
> Customer Solutions Success team, CCBU
> akram...@cisco.com
> Phone: *+61 2 8446 6257 <%2B61%202%208446%206257>*
>
> CCIE Collaboration  - 40065
>
> *Cisco Systems Australia Pty Limited*
> The Forum
> 201 Pacific Highway
> 2065
> St Leonards
> Australia
> Cisco.com <http://www.cisco.com/web/AU/>
>
> <http://wwwin.cisco.com/marketing/corporate/brand/intelbrand/brandstrat/signature/Insert%20your%20LinkedIn%20link>
>
> Think before you print.
>
> This email may contain confidential and privileged material for the sole
> use of the intended recipient. Any review, use, distribution or disclosure
> by others is strictly prohibited. If you are not the intended recipient (or
> authorized to receive for the recipient), please contact the sender by
> reply email and delete all copies of this message.
>
> Please click here
> <http://www.cisco.com/web/about/doing_business/legal/cri/index.html> for
> Company Registration Information.
>
> From: cisco-voip <cisco-voip-boun...@puck.nether.net> on behalf of Kevin
> Przybylowski <kev...@advancedtsg.com>
> Date: Saturday, 9 April 2016 at 1:45 AM
> To: Ed Leatherman <ealeather...@gmail.com>, Anthony Holloway <
> avholloway+cisco-v...@gmail.com>, Justin Steinberg <jsteinb...@gmail.com>
> Cc: "cisco-voip@puck.nether.net" <cisco-voip@puck.nether.net>
> Subject: Re: [cisco-voip] Additional historical reports available on CCO
>
> You also have to put together that Cisco’s official new ccx reports would
> fall under the ‘custom’ umbrella!
>
>
>
> *From:* cisco-voip 

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

[Ed Leatherman]

Hi Abhiram,

Thanks for all the background info, and the heads up about SU2 (i've been
waiting on that one for another bug fix)

Since the new reports are pre-bundled in SU2, do you foresee any problems
applying SU2 if we've added or tried to add one or more of the new reports
already? I am mainly thinking of SP's that have been added already.

Ed

On Mon, Apr 11, 2016 at 9:57 PM, Abhiram Kramadhati (akramadh) <
akram...@cisco.com> wrote:

> Hi all,
>
> We had a quick discussion yesterday to address this and here is the
> summary:
>
>1. CUIC currently executes the SP’s as (uccxhrc user) - this is a
>problem due to an Informix defect, corrected in the next release. Why is
>this a problem? According to Informix, for a user to delete the temp tables
>the user has to be the owner of the same. The owner of the temp table is
>usually designated to be the same as the owner of the SP – *uccxhruser*
>in our case. Now, since the execution is happening as *uccxhrc* user
>and the owner is *uccxhruser*, there is a conflict and hence the
>errors. Refreshing the CUIC datasource fixes this temporarily because temp
>tables are cleared out. The permanent fix is to import the SP as the
>*uccxhrc* user. Since the *uccxhrc* user does not have default
>privileges to create SP’s, please call into TAC and they can run the
>commands for you from the root. This is the defect CSCul06940
>2. We have pre-bundled these reports in 10.6(1)SU2 and the same has
>been released yesterday. Since they are pre-bundled, you will not have this
>problem.
>3. 11.0(1) currently does not have this pre-bundled, since it was
>released a few months back. So if you upgrade from 10.6(1)SU2 to 11.0(1),
>you will lose these reports – you will have to reimport them. So please be
>mindful of point 1. Tentatively, we will pre-bundle them on SU’s on
>11.0(1). So you should be able to upgrade to that from 10.6(1)SU2 and still
>have the reports.
>
>
> The defect CSCul06940 will affect other custom reports as well (because of
> point1). However, in 11.5 the user *uccxhrc* has been deleted. That is
> the long term fix. It is an informix fix, hence the challenges to back
> port.
>
> Updated release notes for the reports will be uploaded soon. Please let me
> know if you have any questions.
>
> Regards,
> Abhiram Kramadhati
> Technical Solutions Manager, CCBU
> CCIE Collaboration # 40065
>
> From: cisco-voip <cisco-voip-boun...@puck.nether.net> on behalf of
> akramadh <akram...@cisco.com>
> Date: Monday, 11 April 2016 at 10:41 AM
> To: Kevin Przybylowski <kev...@advancedtsg.com>, Ed Leatherman <
> ealeather...@gmail.com>, Anthony Holloway <avholloway+cisco-v...@gmail.com>,
> Justin Steinberg <jsteinb...@gmail.com>
>
> Cc: "cisco-voip@puck.nether.net" <cisco-voip@puck.nether.net>
> Subject: Re: [cisco-voip] Additional historical reports available on CCO
>
> Hi all,
>
> Let me find more details on the issue you are facing. We introduced these
> reports over the last quarter and more will be available as well; and all
> of them have undergone the regular testing cycle. But let me see how best
> to address this.
>
> *Abhiram Kramadhati*
> Technical Solutions Manager
> Customer Solutions Success team, CCBU
> akram...@cisco.com
> Phone: *+61 2 8446 6257 <%2B61%202%208446%206257>*
>
> CCIE Collaboration  - 40065
>
> *Cisco Systems Australia Pty Limited*
> The Forum
> 201 Pacific Highway
> 2065
> St Leonards
> Australia
> Cisco.com <http://www.cisco.com/web/AU/>
>
> <http://wwwin.cisco.com/marketing/corporate/brand/intelbrand/brandstrat/signature/Insert%20your%20LinkedIn%20link>
>
> Think before you print.
>
> This email may contain confidential and privileged material for the sole
> use of the intended recipient. Any review, use, distribution or disclosure
> by others is strictly prohibited. If you are not the intended recipient (or
> authorized to receive for the recipient), please contact the sender by
> reply email and delete all copies of this message.
>
> Please click here
> <http://www.cisco.com/web/about/doing_business/legal/cri/index.html> for
> Company Registration Information.
>
> From: cisco-voip <cisco-voip-boun...@puck.nether.net> on behalf of Kevin
> Przybylowski <kev...@advancedtsg.com>
> Date: Saturday, 9 April 2016 at 1:45 AM
> To: Ed Leatherman <ealeather...@gmail.com>, Anthony Holloway <
> avholloway+cisco-v...@gmail.com>, Justin Steinberg <jsteinb...@gmail.com>
> Cc: "cisco-voip@puck.nether.net" <cisco-voip@puck.nether.net>
> Subject: Re: [cisco-voip] Additi

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

[Abhiram Kramadhati (akramadh)]

Hi all,

We had a quick discussion yesterday to address this and here is the summary:

  1.  CUIC currently executes the SP’s as (uccxhrc user) - this is a problem 
due to an Informix defect, corrected in the next release. Why is this a 
problem? According to Informix, for a user to delete the temp tables the user 
has to be the owner of the same. The owner of the temp table is usually 
designated to be the same as the owner of the SP – uccxhruser in our case. Now, 
since the execution is happening as uccxhrc user and the owner is uccxhruser, 
there is a conflict and hence the errors. Refreshing the CUIC datasource fixes 
this temporarily because temp tables are cleared out. The permanent fix is to 
import the SP as the uccxhrc user. Since the uccxhrc user does not have default 
privileges to create SP’s, please call into TAC and they can run the commands 
for you from the root. This is the defect CSCul06940
  2.  We have pre-bundled these reports in 10.6(1)SU2 and the same has been 
released yesterday. Since they are pre-bundled, you will not have this problem.
  3.  11.0(1) currently does not have this pre-bundled, since it was released a 
few months back. So if you upgrade from 10.6(1)SU2 to 11.0(1), you will lose 
these reports – you will have to reimport them. So please be mindful of point 
1. Tentatively, we will pre-bundle them on SU’s on 11.0(1). So you should be 
able to upgrade to that from 10.6(1)SU2 and still have the reports.

The defect CSCul06940 will affect other custom reports as well (because of 
point1). However, in 11.5 the user uccxhrc has been deleted. That is the long 
term fix. It is an informix fix, hence the challenges to back port.

Updated release notes for the reports will be uploaded soon. Please let me know 
if you have any questions.

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

From: cisco-voip 
<cisco-voip-boun...@puck.nether.net<mailto:cisco-voip-boun...@puck.nether.net>> 
on behalf of akramadh <akram...@cisco.com<mailto:akram...@cisco.com>>
Date: Monday, 11 April 2016 at 10:41 AM
To: Kevin Przybylowski <kev...@advancedtsg.com<mailto:kev...@advancedtsg.com>>, 
Ed Leatherman <ealeather...@gmail.com<mailto:ealeather...@gmail.com>>, Anthony 
Holloway 
<avholloway+cisco-v...@gmail.com<mailto:avholloway+cisco-v...@gmail.com>>, 
Justin Steinberg <jsteinb...@gmail.com<mailto:jsteinb...@gmail.com>>
Cc: "cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>" 
<cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>>
Subject: Re: [cisco-voip] Additional historical reports available on CCO

Hi all,

Let me find more details on the issue you are facing. We introduced these 
reports over the last quarter and more will be available as well; and all of 
them have undergone the regular testing cycle. But let me see how best to 
address this.

[http://www.cisco.com/c/dam/assets/email-signature-tool/logo_07.png?ct=1421802598153]

Abhiram Kramadhati
Technical Solutions Manager
Customer Solutions Success team, CCBU
akram...@cisco.com<mailto:akram...@cisco.com>
Phone: +61 2 8446 6257

CCIE Collaboration  - 40065


Cisco Systems Australia Pty Limited
The Forum
201 Pacific Highway
2065
St Leonards
Australia
Cisco.com<http://www.cisco.com/web/AU/>


[http://www.cisco.com/assets/social_media_icons/linkedin-16x16.png]<http://wwwin.cisco.com/marketing/corporate/brand/intelbrand/brandstrat/signature/Insert%20your%20LinkedIn%20link>


[http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif] Think before you 
print.

This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.

Please click 
here<http://www.cisco.com/web/about/doing_business/legal/cri/index.html> for 
Company Registration Information.


From: cisco-voip 
<cisco-voip-boun...@puck.nether.net<mailto:cisco-voip-boun...@puck.nether.net>> 
on behalf of Kevin Przybylowski 
<kev...@advancedtsg.com<mailto:kev...@advancedtsg.com>>
Date: Saturday, 9 April 2016 at 1:45 AM
To: Ed Leatherman <ealeather...@gmail.com<mailto:ealeather...@gmail.com>>, 
Anthony Holloway 
<avholloway+cisco-v...@gmail.com<mailto:avholloway+cisco-v...@gmail.com>>, 
Justin Steinberg <jsteinb...@gmail.com<mailto:jsteinb...@gmail.com>>
Cc: "cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>" 
<cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>>
Subject: Re: [cisco-voip] Additional historical reports available on CCO

You also have to put together that Cisco’s official new ccx reports would fall

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

[Abhiram Kramadhati (akramadh)]

Hi all,

Let me find more details on the issue you are facing. We introduced these 
reports over the last quarter and more will be available as well; and all of 
them have undergone the regular testing cycle. But let me see how best to 
address this.

[http://www.cisco.com/c/dam/assets/email-signature-tool/logo_07.png?ct=1421802598153]

Abhiram Kramadhati
Technical Solutions Manager
Customer Solutions Success team, CCBU
akram...@cisco.com<mailto:akram...@cisco.com>
Phone: +61 2 8446 6257

CCIE Collaboration  - 40065


Cisco Systems Australia Pty Limited
The Forum
201 Pacific Highway
2065
St Leonards
Australia
Cisco.com<http://www.cisco.com/web/AU/>


[http://www.cisco.com/assets/social_media_icons/linkedin-16x16.png]<http://wwwin.cisco.com/marketing/corporate/brand/intelbrand/brandstrat/signature/Insert%20your%20LinkedIn%20link>


[http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif] Think before you 
print.

This email may contain confidential and privileged material for the sole use of 
the intended recipient. Any review, use, distribution or disclosure by others 
is strictly prohibited. If you are not the intended recipient (or authorized to 
receive for the recipient), please contact the sender by reply email and delete 
all copies of this message.

Please click 
here<http://www.cisco.com/web/about/doing_business/legal/cri/index.html> for 
Company Registration Information.


From: cisco-voip 
<cisco-voip-boun...@puck.nether.net<mailto:cisco-voip-boun...@puck.nether.net>> 
on behalf of Kevin Przybylowski 
<kev...@advancedtsg.com<mailto:kev...@advancedtsg.com>>
Date: Saturday, 9 April 2016 at 1:45 AM
To: Ed Leatherman <ealeather...@gmail.com<mailto:ealeather...@gmail.com>>, 
Anthony Holloway 
<avholloway+cisco-v...@gmail.com<mailto:avholloway+cisco-v...@gmail.com>>, 
Justin Steinberg <jsteinb...@gmail.com<mailto:jsteinb...@gmail.com>>
Cc: "cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>" 
<cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>>
Subject: Re: [cisco-voip] Additional historical reports available on CCO

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 
<avholloway+cisco-v...@gmail.com<mailto:avholloway+cisco-v...@gmail.com>>; 
Justin Steinberg <jsteinb...@gmail.com<mailto:jsteinb...@gmail.com>>
Cc: Cisco VOIP <cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>>
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 
<avholloway+cisco-v...@gmail.com<mailto:avholloway%2bcisco-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 
<jsteinb...@gmail.com<mailto:jsteinb...@gmail.com>> 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<mailto: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 
<ealeather...@gmail.com<mailto:ealeather...@gmail.com>> 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<mailto: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:

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

[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 <avholloway+cisco-v...@gmail.com>; Justin Steinberg 
<jsteinb...@gmail.com>
Cc: Cisco VOIP <cisco-voip@puck.nether.net>
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 
<avholloway+cisco-v...@gmail.com<mailto:avholloway%2bcisco-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 
<jsteinb...@gmail.com<mailto:jsteinb...@gmail.com>> 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<mailto: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 
<ealeather...@gmail.com<mailto:ealeather...@gmail.com>> 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<mailto: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:397

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

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

[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

[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

[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

[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

[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

[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 <ealeather...@gmail.com>
Cc: Cisco VOIP <cisco-voip@puck.nether.net>
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<http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/crs/express_9_02/programming/guide/UCCX_BK_CFD16E30_00_cisco-unified-contact-center-express/UCCX_BK_CFD16E30_00_cisco-unified-contact-center-express_chapter_0100.html#UCCX_TK_B927C100_00>
  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 
<ealeather...@gmail.com<mailto:ealeather...@gmail.com>> 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<mailto: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

[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

[cisco-voip] Additional historical reports available on CCO

[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