Posted by: Ajeesh | January 30, 2010

Auditing and Logging Service

Unable to log message “An empty batch was received with fr…” to the event log due to exception:
“Login failed for user <domain>\<accountName>”

Ever came across the above error in Biztalk when your orchestration is getting processed?

I did and I hadn’t a clue what the reason was. Neither did googling help. May be very few developers had to face this issue..

It’s easy to guess that some logging service is running under an account with insufficient privileges. If you have worked with Biztalk 2006 and HL7 Accelerator 2.0 for sometime, you prime suspect would be Services -> Auditing and Logging Service.
Check if it’s started.
If already started, then restart it.
Check the account under which the service is running. Check if the account is valid.

Everything looks good. What next?

You feel the current account does not have permissions to read/write somewhere on the File System. So you go and make the account Local Admin.

Still the error doesn’t seem to go?
Well the reason could be this:
Check the Biztalk databases for the BTAHL7 database. Ensure that the service account has read/write access to this database.
Even though you might have not enabled SQL in the Auditing and Logging Store settings in the HL7 Accelerator, it still checks this access, I guess.
I noticed that it doesn’t log add any records in the 2 tables in BTAHL7, but it still requires access to this database.

Normally, Biztalk does add the service account in the list of users for BTAHL7 database during installation. But it could be possible that the user was deleted from the database or the account was changed.

Posted by: Ajeesh | January 30, 2010

BizTalk blues

My current project entitles me to work on BizTalk Server. It’s a totally new thing for me. But it has provided me with a lot of learning in the 5 odd months that I’ve been part of it.
And it has also provided my colleague the privilege of answering my absurd and sometimes dumb queries ;) As a matter of fact, she has around 2 yrs experience working in Biztalk

In the past, my prominent work areas have been Sharepoint (MOSS 2007) and DotNet 2.0.

Some of the high points in the current project-

  • Interaction with clients in the UK.
  • Understanding the messaging system between hospitals abroad.
  • And many others, which I can’t remember now ;) will revisit

Categories