by diligent

Server-side synchronization between SuiteCRM and Microsoft Exchange

Free 30 day trial
Try it Now

#752 - Not Syncing

Closed General Question created by riyaz.developer a year ago

sir we install Sweeter Sync, and we are in trial mode

actually Syncing (meetings, calls, task, emails, etc.) is not working for me,

  1. Soap Url: OK
  2. Login Url: OK
  3. CRM connection: OK

  4. Exchange Host: OK


    1. Test OK with principal name: XXXXXX

2017-11-09 10:27:31,494 [6] INFO - - GLOBAL - Get users from CRM
2017-11-09 10:27:31,494 [6] INFO - - GLOBAL - Initialize service
2017-11-09 10:22:29,165 [6] INFO - - GLOBAL - Get users from CRM
2017-11-09 10:22:27,915 [6] INFO - - GLOBAL - Login to CRM
2017-11-09 10:22:27,446 [6] INFO - - GLOBAL - Initialize service

please help me.

  1. diligent member avatar

    diligent Provider Affiliate

    a year ago

    Please restart the service. If after this the synchronization is not start, please try these steps:
    1. Backup the suoam_sweetersync_uoam database table
    2. Truncate the suoam_sweetersync_uoam database table
    3. Create only one user in the SweeterSync User Options module
    4. Try to sync.

  2. riyaz.developer member avatar

    riyaz.developer

    a year ago

    Thank You For reply. now its showing Synchronization is disabled but actually it is enable from CRM.

    2017-11-12 11:13:55,819 [29] INFO - - b1bbff05-6b34-cae0-feed-59c0e97db72f - Set last synchronization date and flush fault number of synchronization (if any occured)
    2017-11-12 11:13:55,819 [29] INFO - - b1bbff05-6b34-cae0-feed-59c0e97db72f - [DISABLED] Synchronization is disabled on module by Suite Role: Emails
    2017-11-12 11:13:55,819 [29] INFO - - b1bbff05-6b34-cae0-feed-59c0e97db72f - [DISABLED] Synchronization is disabled on module by Suite Role: Project
    2017-11-12 11:13:55,819 [29] INFO - - b1bbff05-6b34-cae0-feed-59c0e97db72f - [DISABLED] Synchronization is disabled on module by Suite Role: Opportunities
    2017-11-12 11:13:55,819 [29] INFO - - b1bbff05-6b34-cae0-feed-59c0e97db72f - [DISABLED] Synchronization is disabled on module by Suite Role: Cases
    2017-11-12 11:13:55,819 [29] INFO - - b1bbff05-6b34-cae0-feed-59c0e97db72f - [DISABLED] Synchronization is disabled on module by Suite Role: Tasks
    2017-11-12 11:13:55,819 [29] INFO - - b1bbff05-6b34-cae0-feed-59c0e97db72f - [DISABLED] Synchronization is disabled on module by Suite Role: Meetings
    2017-11-12 11:13:55,819 [29] INFO - - b1bbff05-6b34-cae0-feed-59c0e97db72f - [DISABLED] Synchronization is disabled on module by Suite Role: Calls
    2017-11-12 11:13:55,819 [29] INFO - - b1bbff05-6b34-cae0-feed-59c0e97db72f - [DISABLED] Synchronization is disabled on module: Contacts
    2017-11-12 11:13:55,819 [29] INFO - - b1bbff05-6b34-cae0-feed-59c0e97db72f - [DISABLED] Synchronization is disabled on module: Accounts
    2017-11-12 11:13:54,023 [29] INFO - - b1bbff05-6b34-cae0-feed-59c0e97db72f - Initialize Exchange directories
    2017-11-12 11:13:54,023 [29] INFO - - b1bbff05-6b34-cae0-feed-59c0e97db72f - Calendar categories created
    2017-11-12 11:13:53,273 [29] INFO - - b1bbff05-6b34-cae0-feed-59c0e97db72f - Create Calendar categories (Principal name: E108159)
    2017-11-12 11:13:53,273 [29] INFO - - b1bbff05-6b34-cae0-feed-59c0e97db72f - Login to Exchange
    2017-11-12 11:13:53,273 [29] INFO - - b1bbff05-6b34-cae0-feed-59c0e97db72f - Start synchronize user's data. Date of last synchronization: 11/12/2017 7:12:51 AM.
    2017-11-12 11:13:53,273 [7] INFO - - GLOBAL - RunningTasks: b1bbff05-6b34-cae0-feed-59c0e97db72f
    2017-11-12 11:13:52,601 [6] INFO - - GLOBAL - Get users from CRM
    2017-11-12 11:13:52,601 [6] INFO - - GLOBAL - Initialize service

    Regards,
    Riyaz

  3. diligent member avatar

    diligent Provider Affiliate

    a year ago

    Hi Riyaz,

    I think you enabled the synchronization in the SweeterSync User Options module. But you have disabled the modules by CRM roles. The log message is: "Synchronization is disabled on module by Suite Role: Emails". Please check your disabled modules in the CRM regarding the users you wish to use by our module.

    Thank you,
    SweeterSync Team

  4. riyaz.developer member avatar

    riyaz.developer

    a year ago

    Sir, we create one service user with full role access and it start syncing ( syncing happen one way only i.e from CRM to outlook )
    and getting some warning

    2017-11-13 14:39:23,041 [8] INFO - - b1bbff05-6b34-cae0-feed-59c0e97db72f - Create new Exchange items
    at ExchangeSynchronization.Service.SynchronizationManagers.UserDataSynchronizationManager.KnaBwUGFGI(CRMModule , String , String , Int32 ))
    at ExchangeSynchronization.Service.SynchronizationManagers.UserDataSynchronizationManager.tEQMVt9mkudRLMYE9Gw(Object , CRMModule , Object , Int32 , Int32 , Int32 )
    at ExchangeSynchronization.SuiteCRM.SuiteCRMAdapter.GetEntries(CRMModule module, String query, Int32 maxResults, Int32 offset, Int32 includeDeletedItems)
    at ExchangeSynchronization.SuiteCRM.SuiteCRMAdapter.RQIE8JvIwjBLKhFTQS(Object , Object , Object , Object , Object , Int32 , Object , Object , Int32 , Int32 , Boolean )
    at ExchangeSynchronization.WebService.SuiteCRM.sugarsoap.get_entry_list(String session, String module_name, String query, String order_by, Int32 offset, String[] select_fields, link_name_to_fields_array[] link_name_to_fields_array, Int32 max_results, Int32 deleted, Boolean favorites)
    at ExchangeSynchronization.WebService.SuiteCRM.sugarsoap.zQZ8HmgUHO2l2mAhZs(Object , Object , Object )
    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
    2017-11-13 14:39:22,450 [8] WARN - - b1bbff05-6b34-cae0-feed-59c0e97db72f - Cannot get CRM entries by paging: query: () AND (exchange_lastmodified_date_c = '' OR exchange_lastmodified_date_c IS NULL OR calls.date_modified > exchange_lastmodified_date_c OR calls.date_modified > '2017-11-13 10:38:16') AND calls.deleted = 0 (Unknown error in SOAP call: service died unexpectedly -    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
    2017-11-13 14:39:22,166 [8] INFO - - b1bbff05-6b34-cae0-feed-59c0e97db72f - Load CRM and Exchange entries

  5. riyaz.developer member avatar

    riyaz.developer

    a year ago

    2017-11-13 18:24:49,888 [52] WARN - - b1bbff05-6b34-cae0-feed-59c0e97db72f - Cannot get CRM entries by paging: query: () AND (exchange_lastmodified_date_c = '' OR exchange_lastmodified_date_c IS NULL OR meetings.date_modified > exchange_lastmodified_date_c OR meetings.date_modified > '2017-11-13 14:21:45') AND meetings.deleted = 0 (Unknown error in SOAP call: service died unexpectedly -    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

    • riyaz.developer member avatar

      riyaz.developer

      a year ago

      and if i add more then one user nothing is working and getting following error

      2017-11-13 19:29:28,246 [6] ERROR - - GLOBAL - Unknown error in SOAP call: service died unexpectedly -    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
      2017-11-13 19:29:27,731 [6] INFO - - GLOBAL - Get users from CRM

  6. riyaz.developer member avatar

    riyaz.developer

    a year ago

    Thank You So Much.

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