User, group, or role already exists in the current database. SQL error: 42000 Native error code: 15023

When running the configuration wizard for the HIPAA accelerator, I have come across an occurrence where I get the following error:

In looking at the log you will see the following enties

Executed SQL statement on database: BizTalkMgmtDb on computer: {Server}
Executed SQL statement on database: BizTalkMgmtDb on computer: {Server}
User, group, or role ‘{USERID}’ already exists in the current database.
SQL error: 42000 Native error code: 15023
c:\depotsetupv2\private\common\configwizard\confighelper\sqlhelper.cpp(1747): FAILED hr = 80040e14

c:\depotsetupv2\private\common\configwizard\confighelper\sqlhelper.cpp(1955): FAILED hr = 80040e14

c:\depotsetupv2\private\common\configwizard\confighelper\sqlhelper.cpp(1365): FAILED hr = 80040e14

c:\depotsetupv2\private\common\configwizard\confighelper\sqlhelper.cpp(720): FAILED hr = 80040e14

Failed to execute SQL statement on database: BizTalkMgmtDb on computer: {Server}
User, group, or role ‘{User}’ already exists in the current database.
c:\depots\depothipaav33\private\source\hipaaconfig\dll\hipaaconfig.cpp(2179): FAILED hr = 80040e14

The solution is to go into the database and for the property that is running the service uncheck Management database

to

BizTalk Hotrod Issue 3…

My article on a custom method for orchestration-based throttling appeared in BizTalk Hotrod Issue 3.  Wow – this issue was a long time in coming, but it looks well worth the wait.  Looks like a ton of
great content once again.  If you have any comments on the article, please leave
them with this post – I’d love to discuss it with you.

>

The 2007/2008 Imagine Cup – Techology Competition for Students.

I had heard of the Imagine Cup in the past, but did not realise it’s reach.

 

This from Nick Ellery (http://blogs.msdn.com/msozacademic)

“Imagine Cup is the world’s premier technology competition for students. Each year, students are provided with a theme – this year, the theme is extremely topical and relevant – “Imagine A World Where Technology Enables a Sustainable Environment”. Last year, we had over 100,000 students enter worldwide… ”  This year, students can go in the draw to win internships, trips to France, cash prizes, xbox 360’s, HTC touch mobile phones and internships at Readify Consulting. There are 9 categories students can enter:

Software Design – Games Development – IT Challenge – Algorithm – Project Hoshimi Programming Challenge – Photography – Short Film – Interface Design – Embedded Development

Visit: (http://www.microsoft.com/australia/imaginecup/) ”

Application to Reset ISA/IEA Control Numbers to a random value

Have you ever received the error “(80) The document is a duplicate. Contact the sender.” in the Biztalk HIPAA Adapter?.

I’ve only seen it 1.35 million times. Help is on it’s way.

After many years of manually changing ISA/IEA control numbers for the BizTalk HIPAA adapter, I decided I would get some help via VB.NET code. Here is a little application that will generate new HIPAA EDI files from an entire folder with the File Mask you specify with all new ISA/IEA control numbers.

If you’d like it contact me: http://blog.biztalk-info.com/contact.aspx

VSoft FinalBUilder 5.5

VSoft FinalBUilder 5.5

In the last few days I finally got around to test and deploy FinalBuilder. This tool is like a DSL for building software applications. With over 600 actions (almost anything you can imagine), it takes just a couple of hours to set up a Visual Studio solution/projects doing daily builds.

What I did was set it up to automatically build one of my company’s MOSS2007 components, SharePoint Rules, and five of its plug-in’s. I created a project, configured it to get the latest version of the code, created 6 separate “action lists” (==build subroutines), and finished it off by sending a success e-mail. Each of the subroutines just preps up the dependent assemblies, builds the respective solution, and then generates SharePoint’s solution for installation. If anything fails in the process, a failure email is sent.

The usual approach when setting up continuous/daily builds is using either Microsoft’s MSBuild/TFS, or something like CruiseControl.Net . Having been through this in the past, my opinion is: forget it. Buy this product, it is definitely worth it and save you hours if not days. It supports over 10 source control systems (including VSS, TFS, CVS, SubVersion and ClearCase), FTP, NNTP, ICQ, FTP, installers, virtual machine control (VPC, Virtual Server,  and VMWare Server/Workstation), burning CD’s, and a lot more (the list is here). The design experience even includes debugging the build project, and the mandatory breakpoints/watches.

All this said, there are some minor glitches: the lack of an “Undo” means I’ve had to resort to previous versions of the build project a couple of times. Also, I quickly found a difference between the Help File and one specific action (I did post a message in VSoft’s support forum and got a complete reply in under 24 hours explaining the situation — with a solution attached).

Along with CodeSmith and a few other, this is one of the most valuable tools I’ve ever used in development. Highly recommended.

 

Changing topics: one of the things I tried to set up as part of the build project, was generating the CHM help files for the compiled assemblies. The idea was to use the included SandCastle actions to do this. I had a good impression of SandCastle (I used Oct2007 CTP) from what people told me, and of NDoc before that, but never actually tried to use it until now, and I was thoroughly disappointed. SandCastle is far from being a simple tool/product, and usability is near zero. After trying to configure it (for longer than it took me to create the entire build project), hunting for tips in blogs and Xml files, and even failing to get the included samples to work, and always ending up with 0x8000-like errors, I just quit. A colleague had success when using the SandCastle Help File Builder available at CodePlex, but since this is not usable in the automated build scenario, I just disabled the SandCastle actions until a better day comes. A disappointment I wasn’t expecting. Can’t win them all. 🙂

 

Disclosure: as an MVP, I have received a free license for FinalBUilder 5.5 as a 3rd party offer from VSoft Technologies.

Blog list from Microsoft!

Hi All,
Microsoft has recently released aggregated blog list of many BizTalk Bloggers at BizTalk Blogs. This list contains many blogs from known BizTalk MVPs, MSFT, and Biztalk enthusiasts. However, this list also contains information on .net 3.5, VS 2008 and more.
Another good link, i have come across recently is the technorati on biztalk. This is […]