CUIS Archiver reporting environment error..

Unanswered Question
Jan 29th, 2010
User Badges:

When I point the datasource to the AWDB the report runs fine. However, When I point the report to Archiver_data it gives me environment error. I noticed that there are few views missing in the archiver_data database in compate to AWDB database. Eg Agent_Skill_Group_Half_Hour view is missing, so not able run the Agent details historical report on the Archiver_data datasource.


  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 4 (1 ratings)
Chad Stachowicz Fri, 01/29/2010 - 22:11
User Badges:
  • Silver, 250 points or more


   I actually just talked to the CCBU about this today.  Basically the connector for the ICM AW/HDS only pulls a few tables as an example of a connector, so developers have a refernce.  All 19 canned reports are meant to run against the AW/HDS unless you expand the connector to fit all the tables neessary and edit the templates yourself to point at the archiever.  Basically the only reason you really need the archiever server is if you need a data market, or if you have the wanting to build custom datasource connector for the archiever.   Silly I know....

Hope this helps,


manoj_anantha Fri, 01/29/2010 - 23:03
User Badges:

Thanks Chad, Can you point to one canned report that works with the archiver?

For 8X146 HDD MCS server for the CUIS DB is not worth I guess.


david.macias Sat, 01/30/2010 - 09:44
User Badges:
  • Blue, 1500 points or more


That's really good info, I've been playing with CUIS the last couple of weeks and had no idea that was the case.



Chad Stachowicz Sat, 01/30/2010 - 15:56
User Badges:
  • Silver, 250 points or more


  No Problem, I have done quite a lot with CUIS as of late, trying to ramp up on it.  Next week I plan to make a custom connector to PostGRE Database that I am working on as a test and POC.  Also, I have a custom Email Notification hosted web application for use with CUIS I am developing as a POC, I plan to let people use for free I will release soon.

Hope all is well..



This Discussion