Additionally found that there was a bug prior to 7.2e that gave the same error we're receiving...see link below. Strangely we're on the same version that this bug was fixed in.

community.sagecrm.com/.../873.632-17126-error-with-the-holiday-set-field-when-creating-a-new-sla.aspx

We've upgraded our Live server to 7.3 SP3 and it's strangely still getting the error when going from Opportunity Summary to the Opportunity Communications tab. Just to confirm this doesn't happen on our Dev/Test system.

Everything other than that the Live Database contains more data than the Dev Database is the same.

Does anyone know how to resolve the error;

EVariantTypeCastError: Could not convert variant of type (OleStr) into type (Boolean)

There were some schema changes so its probably to do with field types that have changed from one type to another (nvarchar(max) is one seem to remember). i knows its obviously but you should only dev for a live box on the same version.

Also, we avoid SQL triggers like the plague. In almost all circumstances table scripts should be used.

Hi Daniel,

We've upgraded our Live Box to 7.3 SP3 to match our working Dev Box, yet the Stored procedure still doesn't work.

The Live system doesn't seem to like any data being in the comm_opporefid field we've created. If the columns is all NULL, then no problem.

I'll take a look at the field types but I'm certain I created them all exactly the same.

Thanks.

Finally narrowed down the cause of the issue.

If the Opportunity has a communication record against it then it throws up the below error;

EVariantTypeCastError: Could not convert variant of type (OleStr) into type (Boolean)

If there are no communications against the Opportunity then it works fine.

Does anyone know of a work around or experienced this before?