In some cases, Dynamics will throw a "Generic SQL Error" message related to ClickDimensions functions. These errors are not related to the solution itself but are more likely the result of an existing issue within your Dynamics deployment occurring at the SQL Server. Generic SQL Errors usually crop up when the SQL Server is under-optimized, and can cause failed system jobs, such as plugin execution. (Often the first symptom of this that a user notices is that an Email Send's statistics are not updating, or gets an error pop-up about a failed plugin.)
Common causes for these issues include missing or highly-fragmented indexes on the tables in the SQL Server.
Here are some options you can take to investigate the root cause:
- Have your IT team check if SQL Server could use some maintenance.
- Enable Dynamics tracing - This option may provide you more information on the source of the issue, but in most instances you will just see a repeat of the same vague error that appear during the import.
- Run SQL Profiler - This will be the most useful tool to determine the source of the issue given that the source of the problem is likely related to a SQL object with one of the Dynamics databases.
- Contact your Dynamics partner or Microsoft Dynamics Support - For many of our customers that do not have the technical resources in-house or use Dynamics Online this is the most viable option.