Riva Cloud and Riva On-Premise support Sugar 6.0.4+, 6.1.8+, 6.2.6+, 6.3.2+, 6.4.0+, and 6.5.0+ with a procedure to prevent and recover from Riva "Access is Denied" sync errors resulting from upgrading Sugar to guard against SQL injection attacks.
IMPORTANT NOTICE: SugarCRM Development introduced a patch in all 6.x latest releases that guards against SQL injection attacks. Sugar servers prior to 6.4.2 servers can be manually patched to re-enable Riva connections and data sync. For Riva On-Premise, an upgrade to the latest public release is also required.
Riva Cloud and Riva On-Premise Sync Errors: New Riva clients who have tried to configure Riva against the most recently patched Sugar 6.x servers have encountered Access Denied: You do not have access errors. Clients who have tried to configure Riva to sync to a patched Sugar 6.x server have reported errors with the following symptoms:
Pre Sugar 6.4.2: Riva recommends upgrading Sugar 6.x servers to ensure that the SQL injection attack patch has been applied. After Sugar servers are patched, they need to be configured using the procedure described below.
Sugar 6.4.2+: Sugar 6.4.2+ servers do not need the "manual patch" of the Sugar server described below. For Sugar 6.4.2+ and 6.5.x, Riva Cloud users do not need to take any action, and Riva On-Premise users need only upgrade Riva On-Premise to the latest public release.
Sugar Development has confirmed adding a fix to Sugar 6.x releases to protect the Sugar server from SQL injection attacks. That fix prevents data sync for Riva On-Premise and Riva Cloud sync policies.
With the availability of the Sugar server 6.4.2 release (March 13, 2012), full support for Riva has been restored. The installation files for Sugar 6.4.2+ contain the files required to repair affected Sugar server versions. For Riva Cloud users, no action is required. For Riva On-Premise, an upgrade to the latest public release is required to implement a fix.
Not required: This procedure is not required for Sugar 6.4.2+ and 6.5.0+ versions. For Riva On-Premise, you need to be running release 126.96.36.19949 or higher. Starting with Sugar version 6.4.2, all Sugar servers include the necessary files to work with Riva Cloud and Riva On-Premise.
Required for: These procedures will work for the following releases / versions of Sugar server (all licensed editions including Community Edition):
Procedure: Use the applicable procedure to resolve this issue:
Procedure for Riva Cloud:
Procedure for Riva On-Premise:
Article ID: 679
Last updated: 25 Jun, 2019
Also listed in
Riva On-Premise - CRM Sync -> Manage Riva On-Premise (Admin Guides) -> CRM Systems -> Sugar -> Errors & Troubleshooting