by CM & Sugar

Creating individual workflow processes and define detailed automatization tasks for your CRM. Break out of the standard Sugar workflow frame and extend your CRM with your very own, personal BI. No need of hiring external consultants doing your customizations; stop dealing with compatibility problems and communication issues that come with it. Save money and get done faster! Keep your CRM as it is meant to be, your CRM!

Cancel at any time!
Free Trial

#3797 - Update Not Working

Open Bug? created by shaveekapoor 2 years ago

I am using sugar 6.5 and i wrote an update flow and its not working.

  1. cm_sugar member avatar

    CM & Sugar Provider Affiliate

    2 years ago

    I need a bit more input. Have you went through the full installation guide as described? What is the issue. Just "not working" is hard to support.
    Thanks,

    • shaveekapoor member avatar

      shaveekapoor

      2 years ago

      Yes , installation is complete. I do see workflow under schedulers . I added a workflow action to update lead status to custom value and scheduled it to run everyday at certain time. It’s not updating

  2. cm_sugar member avatar

    CM & Sugar Provider Affiliate

    2 years ago

    There must be more than just a workflow action given. For running you also need to have certain conditions being successful. Actions can be only triggered after a condition matches. If you want to do sth at Lead status change, you will have to figure out your conditions and also check the the workflow setup.
    For detailed support you can host a websession or record your setup and errors by video and send by e-mail.

    • shaveekapoor member avatar

      shaveekapoor

      2 years ago

      This is what I am getting when i view the log

      Query Failed: UPDATE cms_workflowactionqueues SET
                          status = 'running',
                          date_modified = NOW()
                          WHERE deleted = 0
                          AND status = 'queued': MySQL error 1146: Table 'sugarprod.cms_workflowactionqueues' doesn't exist

    • cm_sugar member avatar

      CM & Sugar Provider Affiliate

      2 years ago

      Please do a repair. After installing you need to do a double repair, as mentioned at install doc. There should be an output, which you can accept and execute. Do another repair and verify, if the output is empty.
      Afterwards that error should be gone.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.