by Rolustech

Become more efficient! Enter everything just once. Automatically sync Emails, Calendars, Contacts, and Documents between Google Apps and Sugar. Get your Gmail, Contacts, Calendar items and Documents automatically synced instantly with this seamless integration.

Free Trial

By clicking you consent to share your profile with the developer

#1141 - Sync isn't working

Closed Bug? created by TJP 7 years ago

We have installed and set up the module but are unable to sync anything. Here is the error log:

Wed Feb 4 08:45:08 2015 [19248][da912058-fad5-b851-8583-540f3235571c][ERROR] Unable to get proper side for link project_name_link Wed Feb 4 08:45:08 2015 [19248][da912058-fad5-b851-8583-540f3235571c][ERROR] Unable to get proper side for link project_name_link Wed Feb 4 13:54:22 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][FATAL] GSync- Calendar job created Wed Feb 4 13:54:22 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][FATAL] GSync- Contacts job created Wed Feb 4 13:54:22 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][FATAL] GSync- Drive job created Wed Feb 4 13:54:22 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][FATAL] GSync- Archive Emails job created Wed Feb 4 13:54:22 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][FATAL] Google Sync installed successfully... Wed Feb 4 14:06:38 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][FATAL] setting redirect for google authorization token for user: Al Merando Wed Feb 4 14:06:38 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][FATAL] redirecting... Wed Feb 4 14:06:38 2015 [19249][471e3f71-6816-164c-1035-5335b76717e3][FATAL] redirecting to .... Wed Feb 4 14:12:50 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][FATAL] Google Auth settings has been updated for user : Al Merando to sync docs Wed Feb 4 14:46:10 2015 [19249][471e3f71-6816-164c-1035-5335b76717e3][ERROR] Error: Missing mapping entry for module. Wed Feb 4 18:45:50 2015 [19249][471e3f71-6816-164c-1035-5335b76717e3][ERROR] Unable to load related bean by id Wed Feb 4 21:25:00 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][ERROR] Unable to find relationship projects_contacts_resources Wed Feb 4 21:25:00 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][FATAL] project_resource for projects_contacts_resources failed to load

Wed Feb 4 21:25:00 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][FATAL] error loading relationship project_resource Wed Feb 4 21:25:00 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][ERROR] Unable to find relationship projects_contacts_resources Wed Feb 4 21:25:00 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][FATAL] project_resource for projects_contacts_resources failed to load

Wed Feb 4 21:25:00 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][FATAL] error loading relationship project_resource Wed Feb 4 21:25:01 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][ERROR] Unable to find relationship projects_contacts_resources Wed Feb 4 21:25:01 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][FATAL] project_resource for projects_contacts_resources failed to load

Wed Feb 4 21:25:01 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][FATAL] error loading relationship project_resource Wed Feb 4 21:25:01 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][ERROR] Unable to find relationship projects_contacts_resources Wed Feb 4 21:25:01 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][FATAL] project_resource for projects_contacts_resources failed to load

Wed Feb 4 21:25:01 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][FATAL] error loading relationship project_resource Wed Feb 4 21:26:27 2015 [19249][471e3f71-6816-164c-1035-5335b76717e3][ERROR] Unable to find relationship projects_contacts_resources Wed Feb 4 21:26:27 2015 [19249][471e3f71-6816-164c-1035-5335b76717e3][FATAL] project_resource for projects_contacts_resources failed to load

Wed Feb 4 21:26:27 2015 [19249][471e3f71-6816-164c-1035-5335b76717e3][FATAL] error loading relationship project_resource Wed Feb 4 21:31:11 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][ERROR] Unable to load related bean by id Wed Feb 4 21:35:03 2015 [19248][-none-][FATAL] SECURITY: User authentication for Tejeev failed Wed Feb 4 21:35:03 2015 [19248][-none-][FATAL] FAILED LOGIN:attempts[1] - Tejeev Wed Feb 4 21:35:31 2015 [19249][da912058-fad5-b851-8583-540f3235571c][FATAL] SECURITY: User authentication for Tejeev failed Wed Feb 4 21:35:31 2015 [19249][da912058-fad5-b851-8583-540f3235571c][FATAL] FAILED LOGIN:attempts[3] - Tejeev Wed Feb 4 21:42:44 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][ERROR] Unable to find relationship projects_contacts_resources Wed Feb 4 21:42:44 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][FATAL] project_resource for projects_contacts_resources failed to load

Wed Feb 4 21:42:44 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][FATAL] error loading relationship project_resource Wed Feb 4 21:42:45 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][ERROR] Unable to find relationship projects_contacts_resources Wed Feb 4 21:42:45 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][FATAL] project_resource for projects_contacts_resources failed to load

Wed Feb 4 21:42:45 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][FATAL] error loading relationship project_resource Wed Feb 4 21:42:45 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][ERROR] Unable to find relationship projects_contacts_resources Wed Feb 4 21:42:45 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][FATAL] project_resource for projects_contacts_resources failed to load

Wed Feb 4 21:42:45 2015 [19248][471e3f71-6816-164c-1035-5335b76717e3][FATAL] error loading relationship project_resource Wed Feb 4 21:47:14 2015 [19249][471e3f71-6816-164c-1035-5335b76717e3][ERROR] Error: Missing mapping entry for module.

Thank you, TJ

  1. rolustech member avatar

    Rolustech Provider Affiliate

    7 years ago

    Hi TJP,

    Can you Please make sure that installation went successful. Please check for following points to make sure: -Schedulers of GSync are working correctly If cron job is setup - License Key is entered correctly under GSync License Management and Enabled Users List contain Users Enabled. - Gmail ID and Password is entered correctly under Admin Profile settings and Authentication has been done successful.

    If above mentioned steps are done correctly then GSync would work smoothly.

    For more help Please go through following FAQs section and Installation Guide which may resolve most of the troubles.

    FAQs: https://www.sugaroutfitters.com/docs/gmail-sync/faqs User Guide: https://www.sugaroutfitters.com/docs/gmail-sync/sugar6-user-guide Installation Guide: https://www.sugaroutfitters.com/docs/gmail-sync/sugar6-installation-guide

    Hope it helps. Please let us know if it works or need any more assistance.

    We shall help you out accordingly.

    Regards Rolustech Support

  2. TJP member avatar

    TJP

    7 years ago

    License key is accurate Gmail id and password tests ok There is no cronjob under root so this is probably our issue

    Any assistance figuring this out would be much appreciated. Thank you, TJ

  3. TJP member avatar

    TJP

    7 years ago

    Here is some more info that may be related:

    The contents of crontab:

            • cd /srv/users/serverpilot/apps/sugar/public; php -f cron.php > /dev/null 2>&1 0 13 * * * sh /srv/users/serverpilot/backups/data-backup/bck_nayacrm.sh > /srv/users/serverpilot/backups/data-backup/bck_nayacrm.log 2>&1 0 14 * * 7 sh /srv/users/serverpilot/backups/data-backup/bck_crmdevelnaya.sh > /srv/users/serverpilot/backups/data-backup/bck_crmdevelnaya.log 2>&1

    We were working with the following: cd /var/www/html/sugar && /usr/bin/php -c /etc/php5/apache2/php.ini -f cron.php 2>&1 cd /srv/users/serverpilot/apps/crmdevelnaya/public && sudo /usr/bin/php5.6-sp -c /etc/php5.6-sp/php.ini -f cron.php 2>&1

    When we ran into the following error: Undefined index: module in /srv/users/serverpilot/apps/crmdevelnaya/public/modules/AOW_WorkFlow/AOW_WorkFlow.php on line 134

    The function it is referencing:

    130    /**
    131     * Select and run all active flows for the specified bean
    132     */
    133    function run_bean_flows(SugarBean &$bean){
    134        if($_REQUEST['module'] != 'Import'){
    135
    136            $query = "SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = '".$bean->module_dir."' AND aow_workflow.status = 'Active' AND aow_workflow.deleted = 0 ";
    137
    138            $result = $this->db->query($query, false);
    139            $flow = new AOW_WorkFlow();
    140            while (($row = $bean->db->fetchByAssoc($result)) != null){
    141                $flow ->retrieve($row['id']);
    142                if($flow->check_valid_bean($bean))
    143                    $flow->run_actions($bean, true);
    144            }
    145        }
    146        return true;
    147    }
    
  4. TJP member avatar

    TJP

    7 years ago

    Lets try that again... I wish the editor had a preview button. I suppose I should have checked what sort of formatting this system uses first...

    Here is some more info that may be related:

    The contents of crontab:

    *    *    *    *    *     cd /srv/users/serverpilot/apps/sugar/public; php -f cron.php > /dev/null 2>&1
    0    13   *    *    *     sh /srv/users/serverpilot/backups/data-backup/bck_nayacrm.sh > /srv/users/serverpilot/backups/data-backup/bck_nayacrm.log 2>&1
    0    14   *    *    7     sh /srv/users/serverpilot/backups/data-backup/bck_crmdevelnaya.sh > /srv/users/serverpilot/backups/data-backup/bck_crmdevelnaya.log 2>&1
    

    We were working with the following:

        cd /var/www/html/sugar && /usr/bin/php -c /etc/php5/apache2/php.ini -f cron.php 2>&1
        cd /srv/users/serverpilot/apps/crmdevelnaya/public && sudo /usr/bin/php5.6-sp -c /etc/php5.6-sp/php.ini -f cron.php 2>&1
    

    When we ran into the following error:

    Undefined index: module in /srv/users/serverpilot/apps/crmdevelnaya/public/modules/AOW_WorkFlow/AOW_WorkFlow.php on line 134

    The function it is referencing:

    130    /**
    131     * Select and run all active flows for the specified bean
    132     */
    133    function run_bean_flows(SugarBean &$bean){
    134        if($_REQUEST['module'] != 'Import'){
    135
    136            $query = "SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = '".$bean->module_dir."' AND aow_workflow.status = 'Active' AND aow_workflow.deleted = 0 ";
    137
    138            $result = $this->db->query($query, false);
    139            $flow = new AOW_WorkFlow();
    140            while (($row = $bean->db->fetchByAssoc($result)) != null){
    141                $flow ->retrieve($row['id']);
    142                if($flow->check_valid_bean($bean))
    143                    $flow->run_actions($bean, true);
    144            }
    145        }
    146        return true;
    147    }
    
  5. TJP member avatar

    TJP

    7 years ago

    Well this seems to have fixed itself somehow but these are the current issues we would need resolutions to in order to make Gsync our syncing solution of choice:

    Didn't seem to import the user column consistently or it didn't import all registered users accounts for some reason. (It imported one group of contacts with no user and never did sync the updates made to them) How does it interpret/handle duplicates? We need to be able to just sync what we want and leave the rest or personal contacts out.

  6. rolustech member avatar

    Rolustech Provider Affiliate

    7 years ago

    Hi TJP, It seems your cron job is working fine now therefore We are replying against your following queries only.

    1- Didn't seem to import the user column consistently or it didn't import all registered users accounts for some reason. It imported one group of contacts with no user and never did sync the updates made to them. (GSync works for Contacts Sync, not for accounts sync., Please elaborate if We are taking some thing wrong regarding this question) 2- How does it interpret/handle duplicates? (** If there are two contacts in sugar having same email IDs than both will be synced in Google on the basis of their Record Id as both contains different & their own record ID.)** 3- We need to be able to just sync what we want and leave the rest or personal contacts out. (By default GSync works to sync all Contacts, If you want to sync a particular type of contacts then We can do customization for you, For this Please contact at support@rolustech.com)

    Hope it helps

    Regards Rolustech Support

  7. rolustech member avatar

    Rolustech Provider Affiliate

    7 years ago

    Hi TJP,

    Please let us know what can we help you? Or every thing is working smooth?

    Regards Rolustech Support

  8. TJP member avatar

    TJP

    7 years ago

    No, we never got it working the way we would have liked so we moved on.

  9. rolustech member avatar

    Rolustech Provider Affiliate

    7 years ago

    Hi TJP,

    You can let us know about the problems by posting here at support@rolustech.com and We shall get back to you instantly with solution of the problem.

    Currently, closing this Case.

    Regards Rolustech Support.

  10. rolustech member avatar

    Rolustech Provider Affiliate

    7 years ago

    Also We can do customization for your Contacts Sync as Per our previous comments against your queries.

    Looking Forward

  11. TJP member avatar

    TJP

    7 years ago

    There were three basic items that we needed that this didn't seem to provide:

    1. A simpler "just works" install or better documentation outlining the possible pitfalls and what we should see.
    2. The ability to manage duplicates before they hit the database.
    3. The ability to sync just the important contacts (could do it by group, by company, or anything else you come up with, but syncing ALL contacts then weeding out the ones we don't need just isn't an option)

    We can't at this time justify paying for these basic features, but if we can, we will keep you in mind.

  12. rolustech member avatar

    Rolustech Provider Affiliate

    7 years ago

    Hi TJP, Ok Thank you, Do write to us at support@rolustech.com if need above customizations in GSync plugin in future.

    Regards Rolustech Support.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
  • "Amazing Product and beyond amazing support. For the price and the level of support... it is a bargin."

    Read More Reviews