Reflections FAQs

I am trying to reflect to Oracle but I get this error: The provider is not compatible with the version of Oracle client. How do I solve this issue?
Most likely, you are missing the Oracle Data Access Components which comes with the Oracle Client. Refer to the Reflection & Oracle section of the the user guide for more information.
Where and how do I modify my max_allowed_packet for MySQL?
The my.ini file holds your MySQL configurations. This file will be in your MySQL Server folder, look for the [mysqld] section and you can set the max_allowed_packet value there.
Where do I find my SMTP server and port?
Some email providers offer SMTP, you will have to search on the web to find out if you have SMTP available to you.
Does Riptide offer additional product support for Reflection?
We offer Free and Premium Support:

  • Free support (questions, product installation, payments, and bug reports) is available by phone from 9–5 EST, M-F, or by email 24/7 with a 72-hour SLA.
  • Premium support and consulting are available, call for pricing.

Call us at 1-800-RIPTIDE or email us at reflection.support@riptidecloud.com

Make sure that all the services that your database typically needs are actively running.
What security permissions do I need to run Reflection?
There are a variety of security permissions you need to be aware of:

  • Microsoft Windows: The Windows user who installs Reflection must be a member of the administrator group.
  • Internet: The server where Reflection is installed must have permission to access the Internet via HTTP.
  • Salesforce: The Salesforce user that Reflection connects to must have the System Administrator profile. This profile must also have the Modify All Data permission.
  • Target Database: The database user that Reflection connects to must have permissions to SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP tables in the selected database.
My database server does not have access to the Internet. Can I use Reflection?
Unfortunately, no. In order to download data from Salesforce, you must be able to access their website. Additionally, you must be able to access our website in order to validate your license key on installation.
I don't want my database server to have access to the Internet. Do I have to install Reflection on my database server?
No. You do, however, have to configure your network to allow the server where Reflection is installed to access both your database server and the Internet.
The service is taking forever to run. What's going on?
The first time Reflection runs for any Salesforce organization, it has to download all data for that organization. This can easily be hundreds of thousands or even millions of rows. Our tests show that on average, the service can process about 100 records per second (except for attachments). The second and subsequent times that the service runs, it will only process new and changed records, and will run much faster.
The service seems to hang on the Attachments object. What's going on?
The Attachments object in Salesforce can be extremely large. Please be patient.
I started the Reflection service from the Services menu, but there isn't any log file in the Log window or the log file in the Log window is from last week.
First, press [F5] to refresh the log. If that doesn’t work, verify that you have configured the application properly. You should be able to authenticate your credentials for both Salesforce and your local database. Second, verify that the Riptide Reflection service is actually running by checking the service status on the right-hand side of the status bar. If the service is configured and running, press [F3] to open the Event Log to see if an error is preventing the service from running. One common error that can prevent the service from running is when your license has expired.
My log file just... ends. There isn't any summary, it just stops. What happened?
There are two possibilities. First, if you have set the maximum log file size to something less than the default 1,024 megabytes, the log file may have filled up. If that is the case, the log file should continue in the next log file without interruption. If the log file has not filled up, please verify that the service is configured and running properly. If there was a power outage, for example, the log file may have ended abruptly.