Biztalk and SSO reinstall

When you delete the SSO data base it will be removed from the SQL manager. But real data files (MDF I think) are still there. Go delete thos files and you SSO reinstall might work.


Good luck
Kent Seattle

C# dll in orchestration and corrupt data

BizTalk 2010 EDI
When you drop one transaction it looks good when you drop many the data is corrupt.
If you use c# and static variables or methods. It works fine with one transaction, but when you post many transactions the static variables occur once. The data is not isolated and you en up with a mess.

You need to write the DLL with one class and do not use static variables or Methods.

Been a while since I posted

BizTalk 2010 BTSNTSvc.exe.config From BT 2009

If you are movning your old BTSNTSvc.exe.config file to BizTalk 2010. You might need to add


startup useLegacyV2RuntimeActivationPolicy="true"
supportedRuntime version="v4.0" /
/startup

(Had to remove < > tags to post)

If not you may get an error like:


A message received by adapter "FILE" on receive location "TestFromBlue" with URI "C:\BXArchive\Inbound\FromBlue\*.*" is suspended.
Error details: An output message of the component "Unknown " in receive pipeline "Microsoft.BizTalk.Edi.DefaultPipelines.EdiReceive, Microsoft.BizTalk.Edi.EdiPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" is suspended due to the following error:
Error encountered during parsing. The X12 transaction set with id '' contained in functional group with id '924554', in interchange with id '000924621', with sender id '993 ', receiver id '933 ' is being suspended with following errors:
Error: 1 (Miscellaneous error)
6: The document specification from assembly failed to load. Verify the schema for this document specification is deployed and is in the Global Assembly Cache.
.
The sequence number of the suspended message is 1.
MessageId: {DF0A3BA6-7223-4FD5-85A3-9873FE4F9E7D}
InstanceID: {B597C4DF-788F-41EC-84E4-190BD4830742}

BizTalk repeating source data view concurrently

Do you have multiple source data segments you wish to view concurrently?
Use the Cumulative Concatenate functoid. The trick is the second parameter. It is a number usually 2. This number tells the node (above the data) that you concatenate. So you do want get everything in the file.

1. Make sure to use a looping functoid on the node above your data. The node should have min 0 and max “*” or a value such as 99. This means it is a loop.
2. I use a script functoid before the Cumulative Concatenate functoid to add a delimiter to my array.
3. I used an iteration functoid and an equal function to suppress the extra records. Attach the equal to the target node you wish to suppress.
4. I loaded the concatenated data to a script functoid with other fields to calculate the results.

I wish I could post a picture here!!!

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.