question

raymondmli avatar image
raymondmli asked

Resolving error 2786 (data type does not match)?

Hi We are new to the SQL Server world an need some help on this error. I was able to run this without any issues: EXEC sys.sp_fulltext_load_thesaurus_file 1031 Command(s) completed successfully. ...but when applications start, I can see lot of error message (Error 2786) appending to SQL Server logs. We did some changes on OS/SQL Server. it was German OS/SQL Server installed and worked fine with applications. After we changed the OS/SQL Server to English we are starting to see these error in SQL Server logs. Any advice/help will be really appreciated!!! Error: 50000 Severity: 16 State: 1 Error 2786, Level 16, State 1, Procedure sp_fulltext_load_thesaurus_file, Line 41, Message: The data type of substitution parameter 1 does not match the expected type of the format specification
error-messageerrordatatypeserrors
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

It seems to be related to the parameter values that are being passed into to sproc. Can you post examples of the exec statements that are generating the errors? Can you also post the sproc definition? It's quite plausible that you can run the sproc successfully with the values you are passing in, but unsuccessfully with another set of values.
0 Likes 0 ·

1 Answer

·
raymondmli avatar image
raymondmli answered
Thanks for reply. it was due to missing row in: select Lcid=lcid, Name=convert(varchar(15), name) from sys.fulltext_languages where lcid =1 after added it, it worked now.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.