Incompatible SQL Server types when running SV-6

[Peter Kelley]

I'm trying to run an SV-6 search as specified by the UPDM plugin. I get the SQL Server error:

The data types nvarchar and ntext are incompatible in the equal to operator.

What do I do?

EA version 9.2.922

[Helmut Ortmann]

Hello Peter,

I don't know the SV-6 query.

If you have some experiences with SQL you can solve the problem by yourself. The faulty SQL string and the complete error message you can see at:

%APPDATA%Sparxs Systems\EA\DBError.txt

If you put the SQL string into this Forum someone can help you. It looks like a missing cast to make the two different SQL Server types compatible.

Best regards,

Helmut