+1-888-365-2779
Try Now
More in this section

Forums / Bugs & Issues / Exception has been thrown by the target of an invocation - documents and events added via UI

Exception has been thrown by the target of an invocation - documents and events added via UI

4 posts, 0 answered
  1. Gareth Jarvis
    Gareth Jarvis avatar
    4 posts
    Registered:
    09 Aug 2012
    25 Aug 2012
    Link to this post
    We have several documents and news articles that cannot be modifed (eg update the categories, change properties), unpublished (to then try republishing) or deleted (to recreate).

    Trying any of these actions returns "Exception has been thrown by the target of an invocation."

    All of these items were added using the standard admin UI (not progmatically) and all of them are only accessed/modified via the standard out of the box Sitefinity (ie displayed in standard events widget).

    We need to figure out what is causing this, how to resolve it for these events/documents and how to prevent it.
  2. Gareth Jarvis
    Gareth Jarvis avatar
    4 posts
    Registered:
    09 Aug 2012
    25 Aug 2012
    Link to this post
    Update: Resolved by Support (via SQ Lscript to rebuild the taxonomy stats).
  3. Tyler
    Tyler avatar
    9 posts
    Registered:
    10 Jul 2012
    13 Sep 2012
    Link to this post
    I am also running into this with 2 Sitefinity sites..Can you give more specifics on what you did please?

    Thanks!
  4. Gareth Jarvis
    Gareth Jarvis avatar
    4 posts
    Registered:
    09 Aug 2012
    13 Sep 2012
    Link to this post
    Support inidcated that they beleived it was an issue with the taxonomy (there response listed below). We appear to run into this every ~2 weeks and I have had to run the script a few times (which could indicate an area which could stand some Telerik love). YMMV, usual precautions about backups apply etc etc.

    Start Telerik response ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    The experienced problem might indicate issue with the generated taxonomy statistics in previous usages of the categories module. Would it be possible for you to run the below SQL query against your site's database, and let me know if any issues persist? Please make sure to backup your database beforehand.

    /****** Script for SelectTopNRows command from SSMS  ******/

    declare @T table(

          taxon_id uniqueidentifier,

          statistic_type int,

          data_item_type varchar(255),

          item_provider_name varchar(255),

          marked_count bigint,

          id uniqueidentifier,

          duplicated_count int

          )

              

    insert into @T

    SELECT

          [taxon_id]

          ,[statistic_type]

          ,[data_item_type]

          ,item_provider_name

          ,sum(marked_items_count) as marked_count

          ,CAST(MIN(CAST(id AS BINARY(16))) AS UNIQUEIDENTIFIER)

          ,count(*)

    FROM [sf_taxonomy_statistic]

    group by taxon_id, data_item_type, statistic_type, item_provider_name

    having count(taxon_id) > 1

        

    select count(*) from @T

        

    delete [sf_taxonomy_statistic]

    from

          [sf_taxonomy_statistic] as stat

    inner join

          @T as temp

    on

          stat.taxon_id = temp.taxon_id

          and stat.data_item_type = temp.data_item_type

          and stat.statistic_type = temp.statistic_type

          and stat.item_provider_name = temp.item_provider_name

          and stat.id <> temp.id

              

        

    update stat

    set

          marked_items_count = temp.marked_count

    from

          [sf_taxonomy_statistic] stat

    inner join

          @T as temp

    on

          stat.id = temp.id

4 posts, 0 answered