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.