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?
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