locked
CRM Index Rebuild - [dbo].[p_ReindexAll] RRS feed

  • Question

  • Hi All,

    We are performing SQL CRM DB index maintenance using CRM job scheduler and we are using SP - [dbo].[p_ReindexAll] in CRM job scheduler for index maintenance.

    We are getting below error message in CRM job editor tool. Can you please advise how to increase the time out value for below task OR how to fix below issue.

    Sunday, September 4, 2016 8:34 AM

All replies

  • Hi PraveenKumar,

    U need to configure the time outs, CRM Time Outs.

    Greetings,

    JP

    Monday, September 5, 2016 9:36 PM
  • Hi PraveenKumar,

    It seems that your Auto logout timeout is of fixed interval.

    Which means, even when you login into your CRM through Web Browser, it`ll log you out after fixed period. This is the reason, I suppose, after every fixed period you get an error in your application.

    This can be solved by increasing the Auto logout timeout interval. This needs to be done on the ADFS server.

    1.       Open PowerShell.

    2.       If you are on ADFS 2.0, then use the below command or else skip to point 3.
              Add-PSSnapin Microsoft.Adfs.Powershell

    3.       Then check the current TimeOut interval.
              Get-ADFSRelyingPartyTrust -Name:"Relying Party"

    4.       Now, set the TimeOut interval as much you want to.
              Set-ADFSRelyingPartyTrust -TargetName "Relying Party" -TokenLifetime 480

    5.       You can again check the new TimeOut Interval.
             Get-ADFSRelyingPartyTrust -Name:"Relying Party"

    Notes:
    ·         480 in the point 4 is in minutes which means 8 hours.
    ·         Relying Party example “auth.crm.com”

    Thanks,

    Sam

                                                                                                                                                                                                                                                                                                           

    Inogic | Blog | news@inogic.com

    If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"

    Wednesday, September 7, 2016 12:42 PM