[cisco-voip] Additional historical reports available on CCO

Fri Apr 8 10:42:14 EDT 2016

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
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20160408/df66e86c/attachment.html>