CODEWITHSUNDEEP
biztalkbiztalk-2013
Arsen Magomedov
Arsen Magomedov

Reputation: 480

Error converting date while resuming Biztalk instance

When I try to resume BizTalk instance, I am getting the following error from BT console:

Conversion failed when converting date and/or time from character string.

I have BizTalk server 2013 and MsgBox DB on different servers.

Has anyone faced this before?

Upvotes: 0

Views: 123

Answers (1)

Arsen Magomedov
Arsen Magomedov

Reputation: 480

Figured out, that when user resumes an instance, Biztalk executes stored proc, and passes some varchar values (like '2014-08-14 06:52:47.247', which is not using language independent date string format) to it's datetime parameters. The nvarchar->datetime conversion behaviour depends on server @@LANGUAGE and DATEFORMAT properties, which were set to Russian. I've changed default server language of SQL Server with msg box to us_english, and changed default language for all SQL logins on that server to us_english. That solved the problem

Upvotes: 1

Related Questions