Troubleshooting an error message of GUMU™ Integration – ‘File does not exist’

GUMU™ for Sage CRM – Sage ERP’s (i.e. 100/EM/500/300/Pro) integration is a real-time bi-directional link where we synchronize all the customer data from Sage ERP’s to Sage CRM and vice versa.  Today in this blog, we will discuss about troubleshooting tips for resolving an error message related to ‘File does not exist’ which occurs on the click of any GUMU tabs and screens from Sage CRM side.

New Stuff: GUMU™ for Sage CRM-Sage100 Integration – Sales Details Customization

Generally this message occurs on Sage CRM server only when-

• If user restore their current Sage CRM database (say CRM74) with previous database (say CRM73 which was already GUMU™ Integrated) or vice versa.
• If Sage CRM path has been changed.

In order to resolve ‘File does not exist’ error message of any GUMU™ Integration product as shown in below screenshot, user will have to follow the below steps.

1. Check whether the Sage CRM path is pointing to correct Sage CRM installation directory or not. User can check by executing the below SQL query,
   select * from Custom_SysParams
   where Parm_Value like ‘%CustomDotNet%’
   
2. If the Sage CRM path is pointing to wrong Sage CRM installation directory then user will have to execute the below update query in order to update it with Sage CRM installation directory path (i.e. where GUMU Integration dll got installed at the time of GUMU™ Installation).
   update Custom_SysParams
   set Parm_Value=‘C:\Program Files (x86)\Sage\CRM\CustomDotNet\’
   where Parm_Value like ‘%CustomDotNet%’
3. Once the above SQL query is get executed then user will have run refresh Metadata in Sage CRM. Refer below screenshot.
   
4. If the Sage CRM path is correct and user is still getting same error message ‘File does not exist’ then user will have to just execute refresh Metadata in Sage CRM.

Using above steps error message ‘File does not exist’ will get resolve and user can access all GUMU tabs ans screens.

About Us
Greytrix a globally recognized Premier Sage Gold Development Partner is a one stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.

Greytrix has some unique integration solutions for Sage CRM with Sage ERPs (Sage Enterprise Management (Sage X3), Sage Intacct, Sage 100, Sage 500 and Sage 300).We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users and Sage PSG worldwide. Greytrix helps in migrating of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes Greytrix Business Manager, Sage CRM Project Manager, Sage CRM Resource Planner, Sage CRM Contract Manager, Sage CRM Event Manager, Sage CRM Budget Planner, Gmail Integration, Sage CRM Mobile Service Signature and Sage CRM CTI Framework.

Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage Enterprise Management – Sage CRM integration also listed on Sage Marketplace.

For more information on our integration solutions, please contact us at sage@greytrix.com. We will be glad to assist you.