CA Service Management

  • Private Community

  • 1.  database changes taking time to reflect in front end

    Posted Mar 28, 2018 08:34 AM

    after updating change workflow in database, the changes which in front end takes 30 min approx what could be the reason ?



  • 2.  Re: database changes taking time to reflect in front end

    Posted Mar 28, 2018 09:15 AM

    Which product are you referring to ? Whether it's SDM or Catalog, you should not update records directly in the Database, that's not the correct way to modify records.



  • 3.  Re: database changes taking time to reflect in front end

    Posted Mar 28, 2018 10:09 AM

    CA Service Desk 14.4.04



  • 4.  Re: database changes taking time to reflect in front end

    Broadcom Employee
    Posted Mar 28, 2018 11:53 AM

    Kunal.....

     

    Why are you updating records directly via the database?

     

    What table(s) are you updating?

     

    This is not recommended.



  • 5.  Re: database changes taking time to reflect in front end

    Posted Mar 28, 2018 12:55 PM

    We are workflow table , i think my approach is worn i should rather use rest API. 



  • 6.  Re: database changes taking time to reflect in front end

    Broadcom Employee
    Posted Mar 28, 2018 01:06 PM

    Have you tried a cache refresh on the impacted tables?

     

    For example, pdm_cache_refresh -t Workflow_Task