Schema Group Order type - Sequence, choice and all

In the schema editor in a BizTalk project. One of the paramaters for a node is the group order type. Your choices are "Sequence", "Choice" or all.

The sequence requires that the records be for example taged records:

(This is for my example)

40

41

41

42

49

80

Or any sequence re enter

So you could have:

40

41

41

42

42

42

80

Depending on how you set your minimum's and maximum's

For "sequence" This would fail:

40

41

41

49

41

80

If you change to "choice" it would work.

Mapping Superscript Functoids In line code

If you have two superscript functoids. If you use the same name in two different functoids.

FUNCTOID 1 code

//* PayableDenialCode feeds both AdjustmentIndicator and AdjustmentReason *//

public string PayableDenialCodeScript(string AdjustmentIndicator)

{

string ValueOut = "1";

if (AdjustmentIndicator == "00")

{

ValueOut = "0";

}

return ValueOut;

}

Fundtoid 2 code

//* PayableDenialCode feeds both AdjustmentIndicator and AdjustmentReason *//

public string PayableDenialCodeScript(string AdjustmentReason)

{

string ValueOut = AdjustmentReason ;

if (ValueOut == "00")

{

ValueOut = null;

}

return ValueOut;

}

When the 2nd functoid is executed it will use the functoid 1's logic because they have the same name.

BizTalk SSO and groups and security

In BizTalk 2009. I went to at a file receive port and I get a security warning.

To fix this I had to add my name to the BizTAlk Server Administrators group in active directories. This is not the SSO groups on the local machine.

These errors were SSO errors in the event log even though I was in the SSO administrator group on the local machine, I still got the error.

The message in the event log told me to add my self to the SSO administrtor group.

BizTalk Administration Console 2009

Yes people I started working on BizTalk 2009. I could not get into the Server administration console.

I added myself as an sysadmin on the local database. TO do this I had to find someone who had access already.

1. Use Micorsoft SQL server manager.

2. Connect to the server in question, this is where BizTalkMgmtDB resides.

3. Open the "logins" node on the tree on the left.

4. Right click on your logon icon, if one does not exist you must create one.

5. Select the properties box.

6. On the tree on the left select server roles

7. Check the box with SYSADMIN.

Do you need this much capability? I have no idea but it worked for me.

New Flat File Wizard problems

I was assigned to build some flat file maps for some drug data. This was a positional file with carriage return and line feed at the end of each record.

I opened the flat file wizard and generated my positional file that looked like this:

Header1 Required

Header2 Required

Detail1 Optional

Detail2 Optional

Detail3 Optional

Trailer Required

After entering the format I had 3 problems

1. It should look like this:

Header1

Header2

Body

Detail1

Detail2

Detail3

Trailer

The body data is repeating.

2. On the schema node there is a property:

Parser Optimization

This needs to be changed from "speed" to "complex". It will not work with out this be set to "complex".

3. The min and max for each record needs to be as follows

MAX MIN

Header1 1 1

Header2 1 1

Body Unbounded 0

Detail1 Unbounded 1

Detail2 Unbounded 0

Detail3 Unbounded 0

Trailer 1 1

Do not let the min and max default!!! Blank does not mean zero. Put the zero in the minimum or you will have troubles. The record will still be required. Blank means 1.(I think)

Good luck, Let me know if you find other issues?

BizTalk MSI load

Loaded a MSI porcess into a production 2003 server.  I thought it would be good to publish teh issues I had.

1.  The server had not been booted for a long time and it took an hour to get thru the microsoft updates.

2.  I could not delete the application in the 2006 R2 server administrator because the project was the default application.  I had to select another project.

3.  When I deleted the application the dll in the gac did not delete.  This is a problem with the MSI load.  I had to manually uninstall all the related dll from the GAC.  This was evedent because I had versioned all my applications.  make sure you use versioning on your BizTalk applications.

4.  The exported binding file.  Had different versions of the dll in them.  I use notepad to change the version in the binding file to match my new versions.  Remember when you extract the binding file to select the global button in the lower left to pick up the party information. 

HIPAA accelerator 3.3 not recognizing Schemas

When you compile a schema(.VSD) file in your BizTalk project a lot happens.  The HIPAA acclerator 3.3(I suppose other versions) does not execute off the this schema data.

A table is created with the schema information and stored in a database for use by the accelerator at run time.

Some errors may occur when you compile the schema.  These error will not appear anywhere.  The symtom is that the other tools in BizTalk will not recognize the schema.

How to fix(good question).  It could be a problem with the install.  We had to call Micosoft and the called COVAST.

COVAST tried running the programs that run(in the background) with the schema compile.  This did not work.

COVAST purged all the data from the tables and started again and the product seem tobuild.

IIS security for 6.0(2003) and 5.2(XP)

1. IIS is version 6.0 on 2003 servers.  It has different features than 5.2.
2. XP only runs IIS version 5.2 which does not have the features of  IIS 6.0

 IIS version 6.0 on the 2003 server has on DefaultApplpool with an identity tab.  This is where the security is set. 

 You must also set the Application pool to DefaultPool on the main IIS screen under Application Pool.

 

In XP IIS version 5.2 there is no such thing so you must

 

You must do this on XP:

Right click on the web site and select properties.

Select the Directory Security tab.

Select the edit button below.

Check the Anonymous user button(On top).

Check the Integrated Windows Authentication(on bottom)

Enter a user name in the Account used for anonymous access(this account will be used to access the SQL database)

Enter the password.

sgen.exe error in compiling C# dll

I was working with a Biztalk project that called a dll from a expression in a orchestration.
I was working in Visual Studio 2005 SP3. At this date BizTalk requires VS 2005

I go the error sgen.exe.

I found that if I compiled the project in RELEASE I get this error. If I compile in DEBUG I do not.

I do not know if this will effect the speed of the C# process. This step was very small and I was not concerned.

Microsoft called me back and had me go into the properties for this project. On the build tab. I changed the generate sirialzation assembly from AUTO to OFF. This let me compile(Build) in RELEASE mode.