posted on Thursday, February 03, 2005 11:05 AM
by
Benjy
Dr.Watsons Revenge? - BTS 2004 SP1
I cant help thinking that this must be Dr.Watsons Revenge. In my previous post I had accused the system of lying to me about the configuration errors (although I did say that HWS would come back to haunt me sometime later).
Now I installed Sp1 and lo and behold, the installation worked fine but a custom action to do with updating the database for HWS has failed! Here's an excerpt from the log file.
If anyone has seen this problem before and knows the solution, do let me know. I will post the issue to the BTS newsgroup later. Right now if I have to post it i need to use my email address and that is setting myself up for a ton of spam
SETUP LOG FILE EXCERPT
[02/03/05 10:31:48] Apply patch: Server="UKLDN005123", Database="BizTalkMgmtDb", Script="C:\Program Files\Microsoft BizTalk Server 2004\Hws\Hws Admin Server\SQL\Hws_ActionManager_SPs.sql".
[02/03/05 10:31:48] dataSource.Open HRESULT=0
[02/03/05 10:31:48] session.Open HRESULT=0
[02/03/05 10:31:48] file.Open HRESULT=0
[02/03/05 10:31:48] Processing... HRESULT=0
[02/03/05 10:31:48] ExecuteCommand HRESULT=0x80040e14
[02/03/05 10:31:48] There is no such user or group 'HWS_WS_USER'. HRESULT=0x80040e14
[02/03/05 10:31:48] SQL error: 42000 Native error code: 4604 HRESULT=0x80040e14
[02/03/05 10:31:48] file.Close HRESULT=0
[02/03/05 10:31:48] session.Close HRESULT=0
[02/03/05 10:31:48] dataSource.Close HRESULT=0
[02/03/05 10:31:48] Failed to apply patch. HRESULT=0x80040e14
[02/03/05 10:31:48] Abort distributed transaction.
[02/03/05 10:31:48] Failed to patch one or more BizTalk databases. See log for details. (HRESULT=0x80040e14)
[02/03/05 10:31:48] The custom action returned -2147217900.
[02/03/05 10:31:48] One of the custom actions failed. The installation cannot continue. See log for details.