Sage CRM

 View Only
  • 1.  slow performance after linking Sage CRM with Sager

    Posted 11-06-2013 11:04
    slow performance after linking Sage CRM with Sager ERP - 7.1 SP2 to 4.5 Standard. Integraton of the two has brought creating SO's and Customer maintenance to its knees when hitting accept button. Anyone experience this and/or fix it?


  • 2.  RE: slow performance after linking Sage CRM with Sager

    Posted 11-06-2013 11:23
    I don't recall seeing this but have emailed my team to find out. Hate to suggest it but you might want to call Sage on this one if the problem is as bad as you say.


  • 3.  RE: slow performance after linking Sage CRM with Sager

    Posted 11-06-2013 13:54
    @alanniergarth - apparently we have seen something similar in the past. I'm not sure if this is exactly what you faced or not but our solution was as follows (if you don't feel comfortable doing this steps, feel free to give me a call or email): Steps VIA SQL Mgmt Studio: 1. Get all users out of CRM. 2. Backup DB. 3. Disable all Triggers on emaillink table 4. update EmailLink set eLink_SyncedWithMAS90 ='1' where elink_syncedwithmas90!='1' 5. Enable all triggers on emaillink table EXCEPT emaillink_instUPD 6. Disable all Triggers on phonelink table 7. update PhoneLink set PLink_SyncedWithMAS90 ='1' where PLink_SyncedWithMAS90 <> '1' 8. Enable all triggers on emaillink table EXCEPT phonelink_instUPD Extra Notes per MS: All records should have values of _syncedwithmas90=1 (even if the record does not have a relationship to mas) 0 values are records that were not synced for some reason due to a power outage/system failure/service failure/etc. (if anything...a small number)