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) < akram...@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-boun...@puck.nether.net> on behalf of > akramadh <akram...@cisco.com> > Date: Monday, 11 April 2016 at 10:41 AM > To: Kevin Przybylowski <kev...@advancedtsg.com>, Ed Leatherman < > ealeather...@gmail.com>, Anthony Holloway <avholloway+cisco-v...@gmail.com>, > Justin Steinberg <jsteinb...@gmail.com> > > Cc: "cisco-voip@puck.nether.net" <cisco-voip@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 > akram...@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-boun...@puck.nether.net> on behalf of Kevin > Przybylowski <kev...@advancedtsg.com> > Date: Saturday, 9 April 2016 at 1:45 AM > To: Ed Leatherman <ealeather...@gmail.com>, Anthony Holloway < > avholloway+cisco-v...@gmail.com>, Justin Steinberg <jsteinb...@gmail.com> > Cc: "cisco-voip@puck.nether.net" <cisco-voip@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-boun...@puck.nether.net > <cisco-voip-boun...@puck.nether.net>] *On Behalf Of *Ed Leatherman > *Sent:* Friday, April 8, 2016 11:37 AM > *To:* Anthony Holloway <avholloway+cisco-v...@gmail.com>; Justin > Steinberg <jsteinb...@gmail.com> > *Cc:* Cisco VOIP <cisco-voip@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-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