Failed to create subscription datatbase "BizTalkMsgBoxdb" on server"XXX"
Statements could not be prepared
Conflicting locking hints specified
Conflicting locking hints specified
Conflicting locking hints specified
SqlScript file "C:\ProgramFiles\MicrosoftBizTalkserver2004\schema\\msgboxlogic.sql"
SqlCommandBatch:"Create procedure [dbo].[int_PurgeMessageZeroSumTAble]@.
Aggressive int
as
declare..."
Can someone ehelp me out to resolve this error
Thanks and Regards
Rohit
I got this error trying to install BizTalk 2004 on SQL Server 2005.
To work around this error, I edited the file C:\Program Files\Microsoft BizTalk Server 2004\Schema\MsgBoxLogic.sql, as follows:
Find this procedure:
CREATE PROCEDURE [dbo].[int_PurgeMessageZeroSumTable]
After the ELSE, look for
DELETE FROM MessageParts WITH (ROWLOCK)
And remove the “WITH (ROWLOCK)”
Do the same for these:
DELETE FROM Spool WITH (ROWLOCK)
DELETE FROM TrackedMessages WITH (ROWLOCK)
Then find:
CREATE PROCEDURE [dbo].[int_PurgePartZeroSumTable]
And after the ELSE find these and do the same thing:
DELETE FROM Fragments WITH (ROWLOCK)
DELETE FROM Parts WITH (ROWLOCK)
After making these changes to the file, you can get past this point in the configuration wizard. You will then encounter another error:
Deploying BAM infrastructure: Failed to set up BAM database(s). Invalid column name 'XLOCK'. Invalid column name 'ROWLOCK'. Parameters supplied for object 'dbo.bam_Metadata_RTAMutex' which is not a function. If the parameters are intended as a table hint, a WITH keyword is required.
In the database BamPrimaryImport, set the compatibility level to SQL Server 2000. You can then hit Retry in the configuraiton wizard, and the next error is:
Failure to add BAM Primary Import database (database: BAMPrimaryImport, server: MyServer) to BizTalk group (database: BizTalkMgmtDb, server: MyServer).
Darnit, someone went and changed sp_helpuser!
This is where I'm stuck.
|||Hi,
Did u solve this problem? i m also stuck up exactly in the same place..plz give me a solution, if u ve solved it...
Sumanesh
|||The same problem here, did anyone find out how to solve this?|||I was told this is because SQL Server 2005 and BizTalk 2004 are not compatible.|||If you get the message"Failure to add BAM Primary Import database (database:
BAMPrimaryImport, server: MyServer) to BizTalk group (database:
BizTalkMgmtDb, server: MyServer). "
When using SQL Server 2004 it appears to be due to biztalk not cleaning up after itself after a configuration failure.
Open Control Panels > User Accounts click on the Advanced tab and then on the Advanced button.
Delete the following groups (some may not exist yet depending when the past failure occured)
BizTalk Application Users
BizTalk Isolated Host Users
BizTalk Server Administrators
EDI Subsystem Users
SSO Administrators
SSO Affiliate Administrators
This got past the error mentioned above when using SQL Server 2004|||
i got the same problem
any solutions ?
the last post does not got past the error if using SQL Server 2005
|||Hi,
I am also configuring Biztalk Server 2004 on SQL Server 2005.
You work around helped, but it only creaded the first three databases.
While it was still on "Now Configuring: Biztalk WMI" it throws the following error:
"ActiveX component can't create object"
Please help
Wonder Andile Hlongwane
