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