[cisco-voip] Additional historical reports available on CCO
Anthony Holloway
avholloway+cisco-voip at gmail.com
Tue Apr 12 15:13:39 EDT 2016
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) <
akramadh at 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-bounces at puck.nether.net> on behalf of
> akramadh <akramadh at cisco.com>
> Date: Monday, 11 April 2016 at 10:41 AM
> To: Kevin Przybylowski <kevinp at advancedtsg.com>, Ed Leatherman <
> ealeatherman at gmail.com>, Anthony Holloway <avholloway+cisco-voip at gmail.com>,
> Justin Steinberg <jsteinberg at gmail.com>
>
> Cc: "cisco-voip at puck.nether.net" <cisco-voip at 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
> akramadh at 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-bounces at puck.nether.net> on behalf of Kevin
> Przybylowski <kevinp at advancedtsg.com>
> Date: Saturday, 9 April 2016 at 1:45 AM
> To: Ed Leatherman <ealeatherman at gmail.com>, Anthony Holloway <
> avholloway+cisco-voip at gmail.com>, Justin Steinberg <jsteinberg at gmail.com>
> Cc: "cisco-voip at puck.nether.net" <cisco-voip at 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-bounces at puck.nether.net
> <cisco-voip-bounces at puck.nether.net>] *On Behalf Of *Ed Leatherman
> *Sent:* Friday, April 8, 2016 11:37 AM
> *To:* Anthony Holloway <avholloway+cisco-voip at gmail.com>; Justin
> Steinberg <jsteinberg at gmail.com>
> *Cc:* Cisco VOIP <cisco-voip at 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-voip at 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 <jsteinberg at 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-voip at 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 <ealeatherman at 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-voip at 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-voip at 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
> <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 <ealeatherman at 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 at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
>
>
>
>
>
>
>
> --
>
> Ed Leatherman
>
>
>
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20160412/b7e84f4c/attachment.html>
More information about the cisco-voip
mailing list