Harvest : The given key was not present in the dictionary.

Reply

Dennis van der Stelt Posted: Mon, Apr 21 2008 6:31 PM

rated by 0 users

I'm having problems with Harvest and I think it's with the multiple communities I had running. It's the same error message as in this thread : http://dev.communityserver.com/forums/t/498239.aspx

Here's the discussion I had earlier about CS2008 and multiple communities : http://dev.communityserver.com/forums/t/498580.aspx

Here's the exact error :

[KeyNotFoundException: The given key was not present in the dictionary.]
   System.ThrowHelper.ThrowKeyNotFoundException() +39
   System.Collections.Generic.Dictionary`2.get_Item(TKey key) +5296983
   Telligent.Reporting.Library.BaseClasses.ReportBase.FormatExternalLink(String linkName, DataRow dataRow) +143
   Telligent.Reporting.CommunityServer.Blogs.MostPopularBlogsDetailedReport.FormatReportTableRow(DataRow currentRow, Boolean isAlternateItem, Int32 counter, StringBuilder sb) +411
   Telligent.Reporting.Library.ReportingTemplate.ᐁ(Object , EventArgs , Boolean ) +147
   System.Web.UI.Control.OnDataBinding(EventArgs e) +133
   System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +170
   Telligent.Reporting.Library.ᐁ.DataBind() +16
   System.Web.UI.Control.DataBindChildren() +4403007
   System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +182
   System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource) +701
   System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) +68
   Telligent.Reporting.Library.ReportingGrid.DataBind() +31
   Telligent.Reporting.Web.Controls.ReportViewContainer.GenerateReport(ReportParams reportParams) +2242
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +48
   System.Web.UI.Control.OnLoad(EventArgs e) +133
   System.Web.UI.Control.LoadRecursive() +66
   System.Web.UI.Control.LoadRecursive() +191
   System.Web.UI.Control.LoadRecursive() +191
   System.Web.UI.Control.LoadRecursive() +191
   System.Web.UI.Control.LoadRecursive() +191
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2604

Reply

Dennis van der Stelt replied on Tue, Apr 22 2008 4:25 PM

rated by 0 users

bump.... anyone?

Reply

dpenton replied on Wed, Apr 23 2008 12:57 AM

rated by 0 users

Dennis,

This sounds like introductory data wasn't inserted into rs_ConfigTable as required.  How was the code installed?  From the installation tool or from you running the sql statements?  What does this sql statement return:

select * form rs_ConfigTable

Thanks,
David L. Penton 

Reply

Dennis van der Stelt replied on Wed, Apr 23 2008 2:31 AM

rated by 0 users

I changed localhost to the real address, but it's still not working.

I generated the tables through the SQL script, until I figured out the install tool. I ran the install tool and it worked.

I must say that the root page works, I get visitor registration stuff and all... Clicking the forms works as well, but I have no forms setup so there's no data there. Clicking the blogs gives me the error above.

Thanks for the help so far...
Regards,
Dennis

Reply

dpenton replied on Wed, Apr 23 2008 10:21 AM

rated by 0 users

 Dennis,

When you ran the install tool, did you start with a clean database?  I am a little concerned that some of the SQL statements were not executed ( scripts/HarvestReporting.sql and also CommunityServerReporting.sql should have been executed in that order).  If it was, and only the handful of records are in rs_ConfigTable then here are the other records to prepopulate with:

set nocount on

INSERT INTO rs_ConfigTable VALUES ('csr_BlogCategoryData', '_A')
INSERT INTO rs_ConfigTable VALUES ('csr_BlogCommentData', '_A')
INSERT INTO rs_ConfigTable VALUES ('csr_BlogPostData', '_A')
INSERT INTO rs_ConfigTable VALUES ('csr_EventData', '_A')
INSERT INTO rs_ConfigTable VALUES ('csr_ForumCategoryData', '_A')
INSERT INTO rs_ConfigTable VALUES ('csr_ForumPostData', '_A')
INSERT INTO rs_ConfigTable VALUES ('csr_ForumThreadData', '_A')
INSERT INTO rs_ConfigTable VALUES ('csr_ModerationData', '_A')
INSERT INTO rs_ConfigTable VALUES ('csr_PageData', '_A')
INSERT INTO rs_ConfigTable VALUES ('csr_ReferrerData', '_A')
INSERT INTO rs_ConfigTable VALUES ('csr_RLinkData', '_A')
INSERT INTO rs_ConfigTable VALUES ('csr_RoleData','_A')
INSERT INTO rs_ConfigTable VALUES ('csr_TrackbackData','_A')
INSERT INTO rs_ConfigTable VALUES ('csr_UserData','_A')

INSERT INTO rs_ConfigTable VALUES ('Link_CSReports_BlogsPostID', '/blogs/[PostID].aspx')
INSERT INTO rs_ConfigTable VALUES ('Link_CSReports_BlogsTag', '/blogs/[SectionID]/archive/tags/[Category]/default.aspx')
INSERT INTO rs_ConfigTable VALUES ('Link_CSReports_ForumsPostID', '/forums/p/[ThreadId]/[PostID].aspx#[PostID]')
INSERT INTO rs_ConfigTable VALUES ('Link_CSReports_ForumsSectionID', '/forums/[SectionID].aspx')
INSERT INTO rs_ConfigTable VALUES ('Link_CSReports_ForumsThreadID', '/forums/t/[ThreadId].aspx')
INSERT INTO rs_ConfigTable VALUES ('Link_CSReports_UsersRole', '/user/members.aspx?search=1&r=[RoleId]')
INSERT INTO rs_ConfigTable VALUES ('Link_CSReports_UsersUserName', '/members/[UserName].aspx')
INSERT INTO rs_ConfigTable VALUES ('Link_CSReports_AggregateTag', '/tags/[Category]/default.aspx')
INSERT INTO rs_ConfigTable VALUES ('Link_CSReports_ReferringUrl', 'http://[Referring Url]')

set nocount off

Thanks,
David L. Penton

Reply

Dennis van der Stelt replied on Wed, Apr 23 2008 10:59 AM

rated by 0 users

I acted as a normal user and you're (of course) right...

Thanks a lot!

Reply

dpenton replied on Wed, Apr 23 2008 11:32 AM

rated by 0 users

 Dennis,

Glad you got it working!!!

Thanks,
David

Reply

Anand replied on Fri, Nov 7 2008 9:44 AM

rated by 0 users

Hi Dennis van der Stelt,

Can you tell me how you configured second instance/service for Harvest report. Im not a expert. So you have to explaine me in detail,

I have 2 communities running on one machine. one is 2008 version an other one is 2008.5. I have license for both of them. So no problem for installing Harvest report.

I didnt do the first harvest report installation. First one is working fine. I tried to install for my second community. So I used the installer.It created a database for me. and copied the files within my community. So I can now view the page.

Problem is telligent service. In c:\Program files folder\Tellegent\Tellegent.tasks it override the first Harvest report files/setings.My questions are..

1. Is that we are going to use one Telligent service for both Harvest reporting server?
2. Or else we are going to create and other folder within Program files called Telligent2/Telligent.Tasks and other set of files?
3. If not, that means if we are using one folder for both, how to set two connection strings and tasks?)
4. If we are going to have two services how to create an other service?with the installer or manually?

You have configured two reporting for your sites. So you have experience, Can you please point me the way? or any documentation that I can read.

Thanks