Known issues with BizTalk Server 2020 RosettaNet accelerator (Part 1)

%3CLINGO-SUB%20id%3D%22lingo-sub-1297603%22%20slang%3D%22en-US%22%3EKnown%20issues%20with%20BizTalk%20Server%202020%20RosettaNet%20accelerator%20(Part%201)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1297603%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20we%20all%20know%2C%20BizTalk%20Server%202020%20thoroughly%20removed%20old%20native%20SQL%20adapter%20and%20replaced%20it%20with%20WCF-SQL%20adapter.%20This%20change%20has%20resulted%20in%20several%20known%20issues%20with%20some%20existing%20components%20like%20RosettaNet%20accelerator(BTARN)%20that%20used%20old%20SQL%20adapter%20previously.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBefore%20Microsoft%20releases%20official%20fix%20of%20the%20BTARN%20problems%2C%20you%20can%20also%20follow%20the%20steps%20below%20to%20work%20around%20them%20by%20yourself.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CU%3ESteps%3A%3C%2FU%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFirst%20of%20all%2C%20you%20need%20to%20correct%20the%20binding%20of%20receive%20locations%3A%20LOB_To_PrivateInitiator%20and%20LOB_To_PrivateResponder.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EUse%20XmlPolling%3C%2FLI%3E%0A%3CLI%3ESet%20Xml%20SP%20Root%20Node%20Name%20to%3A%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20LOBMessage%3C%2FLI%3E%0A%3CLI%3ESet%20Xml%20SP%20Namespace%20to%3A%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3CA%20href%3D%22http%3A%2F%2Fschemas.microsoft.com%2Fbiztalk%2Fbtarn%2F2004%2FLOBMessage%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fschemas.microsoft.com%2Fbiztalk%2Fbtarn%2F2004%2FLOBMessage%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EPolledDataAvailableStatement%20to%3A%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Select%201%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20the%20screenshots%20below%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22WenJun_Zhang_0-1586502445273.jpeg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F183555iE5DBB49791F8BF71%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22WenJun_Zhang_0-1586502445273.jpeg%22%20alt%3D%22WenJun_Zhang_0-1586502445273.jpeg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22WenJun_Zhang_1-1586502445283.jpeg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F183556i20084C7790A98C59%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22WenJun_Zhang_1-1586502445283.jpeg%22%20alt%3D%22WenJun_Zhang_1-1586502445283.jpeg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22WenJun_Zhang_2-1586502445290.jpeg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F183557iBD042B3D9FAC2754%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22WenJun_Zhang_2-1586502445290.jpeg%22%20alt%3D%22WenJun_Zhang_2-1586502445290.jpeg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22WenJun_Zhang_3-1586502445295.jpeg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F183559i07DF959B80FDE356%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22WenJun_Zhang_3-1586502445295.jpeg%22%20alt%3D%22WenJun_Zhang_3-1586502445295.jpeg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAfter%20that%2C%20you%20also%20need%20to%20correct%20binding%20of%20Send%20ports%3A%20PrivateInitiator_To_LOB%20and%20PrivateResponder_To_LOB.%3C%2FP%3E%0A%3CP%3EEspecially%20pay%20attention%20to%20the%20SOAP%20Action%20header%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22WenJun_Zhang_4-1586502445300.jpeg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F183560i437BEFEE5A9D81C3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22WenJun_Zhang_4-1586502445300.jpeg%22%20alt%3D%22WenJun_Zhang_4-1586502445300.jpeg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EA%20further%20problem%20was%20that%20PrivateInitiator_To_LOB%20port%20uses%20an%20outbound%20map%20to%20transform%20LOBMessage%20into%20the%20schema%20of%20native%20SQL%20adapter(SQLSCMessageOut)%20before%20being%20inserted%20into%20MessagesToLOB%20table.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22WenJun_Zhang_5-1586502445302.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F183558iB837DE95658BE575%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22WenJun_Zhang_5-1586502445302.png%22%20alt%3D%22WenJun_Zhang_5-1586502445302.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20this%20case%2C%20we%20also%20need%20to%20generate%20new%20Wcf-Sql%20based%20schema%20and%20create%20corresponding%20map%20to%20transform%20LOBMessage%20Into%20Wcf-Sql%20Insert%20message%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22WenJun_Zhang_6-1586502445309.jpeg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F183561iD4EB3CD362901656%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22WenJun_Zhang_6-1586502445309.jpeg%22%20alt%3D%22WenJun_Zhang_6-1586502445309.jpeg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20generated%20schema%20and%20map%20files%20I%20use%20are%20in%20attachment.%20The%20script%20functoid%20in%20the%20map%20is%20quite%20simple%20that%20converts%20string%20type%26nbsp%3BDelivered%20value(%220%22%20or%20%221%22)%20to%20boolean.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CEM%3Epublic%20bool%20getDelivered(string%20delivered)%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3E%7B%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3E%26nbsp%3B%20%26nbsp%3B%20if(delivered%20%3D%3D%20%221%22)%3C%2FEM%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3CEM%3Ereturn%20true%3B%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3E%26nbsp%3B%20%26nbsp%3B%20return%20false%3B%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3E%7D%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20same%20changes%20need%20to%20be%20applied%20to%20PrivateResponder_To_LOB%20port%20as%20well.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAfter%20all%20the%20above%20changes%2C%20the%20BTARN%20Loopback%20sample%20should%20be%20back%20to%20work%20fine.%20Next%2C%20let's%20move%20on%20and%20continue%20to%20resolve%20issues%20with%20DoubleAction%20scenario%3A%3C%2FP%3E%0A%3CP%3E%3CA%20title%3D%22Known%20issues%20with%20BizTalk%20Server%202020%20RosettaNet%20accelerator%20(Part%202)%22%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fbiztalk-server%2Fknown-issues-with-biztalk-server-2020-rosettanet-accelerator%2Fm-p%2F1297641%22%20target%3D%22_self%22%3EKnown%20issues%20with%20BizTalk%20Server%202020%20RosettaNet%20accelerator%20(Part%202)%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Microsoft

As we all know, BizTalk Server 2020 thoroughly removed old native SQL adapter and replaced it with WCF-SQL adapter. This change has resulted in several known issues with some existing components like RosettaNet accelerator(BTARN) that used old SQL adapter previously.

 

Before Microsoft releases official fix of the BTARN problems, you can also follow the steps below to work around them by yourself.

 

Steps:

 

First of all, you need to correct the binding of receive locations: LOB_To_PrivateInitiator and LOB_To_PrivateResponder.

 

 

See the screenshots below:

 

WenJun_Zhang_0-1586502445273.jpeg

 

 

WenJun_Zhang_1-1586502445283.jpeg

 

WenJun_Zhang_2-1586502445290.jpeg

 

 

WenJun_Zhang_3-1586502445295.jpeg

 

After that, you also need to correct binding of Send ports: PrivateInitiator_To_LOB and PrivateResponder_To_LOB.

Especially pay attention to the SOAP Action header:

WenJun_Zhang_4-1586502445300.jpeg

 

A further problem was that PrivateInitiator_To_LOB port uses an outbound map to transform LOBMessage into the schema of native SQL adapter(SQLSCMessageOut) before being inserted into MessagesToLOB table.

 

WenJun_Zhang_5-1586502445302.png

 

In this case, we also need to generate new Wcf-Sql based schema and create corresponding map to transform LOBMessage Into Wcf-Sql Insert message:

 

WenJun_Zhang_6-1586502445309.jpeg

 

The generated schema and map files I use are in attachment. The script functoid in the map is quite simple that converts string type Delivered value("0" or "1") to boolean.

 

public bool getDelivered(string delivered)
{
    if(delivered == "1") 

         return true;
    return false;
}

 

The same changes need to be applied to PrivateResponder_To_LOB port as well.

 

After all the above changes, the BTARN Loopback sample should be back to work fine. Next, let's move on and continue to resolve issues with DoubleAction scenario:

Known issues with BizTalk Server 2020 RosettaNet accelerator (Part 2) 

0 Replies