[cisco-voip] Additional historical reports available on CCO

Ed Leatherman ealeatherman at gmail.com
Fri Apr 8 11:36:44 EDT 2016 

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/20160408/3b18e376/attachment.html>

More information about the cisco-voip mailing list