02-05-2010 08:56 AM
Here is an issue that has puzzled me for a couple weeks.
When attempting to add a Sales Process Step that has a Mail Merge Action the system generates the following error at the time the template is selected.
The data types varchar and text are incompatible in the equal to operator
We have switched templates and created a new template that only contained the contact.lastname merge field - this made no difference.
I suspected an issue with security. Does the user need to be a local admin to create this mail merge step?
(This user can create and run merge templates. I have also used the same db on a different network and then the error is gone.)
02-05-2010 02:39 PM
Just a guess but it sounds like some field storing information in the sales process about the mail merge is incompatible with the field in the plugin table storing the merge data.
Maybe try running the slxprofilere.exe against the client while you are trying to set it up. When you get the error, look at the profiler to see what fquery is being executed.