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 <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> 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> >>> 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 >>>>>> >>>>>> <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 >>>>>> > 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 >>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>>> >>>> -- >>>> 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