Hi,
we use sql transport to pickup message from a sql table to the messagebox. Now we have a problem that after a hour the the storedprocedure is not executed on the sql server. The sqlhost service is still running and so is the sqlserver. It looks like sqlhost service isn't firing any storeprocedures anymore.
my question is why?
So let me recapitulate:
1. You have a SQL RecLoc which reads messages from a SQL table using a stored procedure.
2. After 1 hour the messages are not read anymore.
3. Nothing is reported in Event Viewer (since you started the RecLoc).
4. No messages are suspended in BizTalk.
Questions:
1. Are the above correct?
2. Is it exactly 1 hour?
3. After you restart the host, does it work forever or it works for another hour and then stops again?
4. What SQL Server do you use? Is it SQL 2000?
5. What user are you using? What rights does it have?
6. Could you zip and send me:
- a script which creates the database and the table,
- the stored procedure
- the BizTalk project
Thank you,
Nicu
anwser question 1: Yes
answer question 2: i don't known exactly a hour. Why, does this make a difference?
answer question 3: i don't known, i let you known. I have to look it up.
answer question 4: SQL2000
answer question 5: windows rights: administrator, biztalk application users, iis wpg, sso, users
sql rights: system administrator, dbo op database
answer question 6: Let me look what i can send you.
Thanks,
Christian
My Problem maybe solved!
Microsoft Consultent Martin Rienstra look at my problem and he came up with this fix: http://support.microsoft.com/kb/900822
Thanks Martin.
