Biztalk navigation
Generellt | Orkestrering | Mappning | XSLT | Scheman | Pipelines | Annat - Bindings, Adapters..

BizTalk - Tips & Sökvägar
Tips & Tricks
Generellt
Logga
System.Diagnostics.EventLog.WriteEntry("BizTalk Server", "test", System.Diagnostics.EventLogEntryType.Warning, 0);

Max storlek för inkommande meddelanden
Default: 65536
Max size for WCF (32-bit signed integer) 2147483647

Installera i GAC:en
gacutil -i "C:\\Program Files (x86)\\Microsoft BizTalk Server\\Pipeline Components\\Base64Decoder.dll"
Avinstallera ur GAC:en
gacutil –u 

BizTalk Message Datatype
Microsoft.XLANGs.BaseTypes.XLANGMessage

XML Ampersand &
&

XML CDATA
>
    ]]>

WCF-SQL
Exempel på connectionstring
mssql://BTSQLTest:1433//LTBIPDB?
CompositeOperation

Bygge / Deploy
Egna pipeline komponenter
Visual Studio: Sedan i toolbox så får man högerklicka och välja Choose Items
DLL ska läggas i C:\\Program Files (x86)\\Microsoft BizTalk Server\\Pipeline Components
ELLER
DLL ska GAC:as (gacutil -i "DLLPATH")

Fel och hur man löser dem
Generellt
Starta Visual Studio som admin för att kunna deploy:a till BizTalk
Could not change the bindings for orchestration as one or more instances of the orchestration still exist
Gå till Biztalk group och terminate:a suspended instances (Alternativt gör full-stop på applikationen)
preprocessor directive must appear as the first token on a line
Fel encoding på orkestrering, ändra till UTF-8
you must specify at least one already-initialized correlation set for a non-activation receive that is on a non-selfcorrelating port
Se till att Receive-shape:n är aktiverad
The given BizTalk assembly is not strong named. A strong named BizTalk assembly is required if any of the options are specified.
Signing krävs på projektet (properties)
a non-serializable object type 'IP0356_Plasmafil_Octapharma.Helper.WordReader WordReader' can only be declared within an atomic scope or service
[Serializable]
behövs som attribut på helper-klassen
Visual Studio locking dll file
GAC:a DLL:en
Inga ändringar i en pipeline komponent
Du behöver ta bort den ur GAC:en, den tar prioritet

Biztalk deploy application Error MSB4018 The "UpdateVersionTask" task failed unexpectedly.
Newtonsoft.Json 13 är inte kompatibel med BizTalk 2020 CU4
Så man får backa till Newtonsoft.Json 12.0.3
A workaround for this issue is to add the old version of Newtonsoft.Json to the Global Assembly Cache (GAC). Here’s how you can do it
NuGet\\Install-Package Newtonsoft.Json -Version 12.0.3
gacutil /i packages\\Newtonsoft.Json.12.0.3\\lib\\net45\\Newtonsoft.Json.dll

Biztalk correlation sets
Correlation is the process of matching an incoming message with the appropriate instance of an orchestration.
    
Sökvägar
# GAC_MSIL
C:\Windows\Microsoft.NET\assembly\GAC_MSIL

# Pipeline Components
C:\Program Files (x86)\Microsoft BizTalk Server\Pipeline Components

# PipelineTools
C:\Program Files (x86)\Microsoft BizTalk Server\SDK\Utilities\PipelineTools

# Mapper Extensions
C:\Program Files (x86)\Microsoft BizTalk Server\Developer Tools\Mapper Extensions

# gacutil
C:\Program Files (x86)\Microsoft SDKs\Windows\v10.0A\bin\NETFX 4.8 Tools
C:\Windows\Microsoft.NET\Framework64\v4.0.30319


Schedulering med hjälp av WCF-SQL (Receive)
URI: mssql://btsqltest:1433/LTBIPDB?
PolledDataAvailableStatement: SELECT CASE WHEN DATEPART(hour, GETDATE()) = 12 AND DATEPART(minute, GETDATE()) <= 15 THEN 1 ELSE 0 END
PollingStatement: SELECT 'trigger' AS 'Trigger'
PollingIntervalInSeconds: 900 (t.ex. då blir det var 15e minut)

Schedulering med hjälp av WCF-SQL (Receive) - Riktig XML result
InboundOperationType: XmlPolling
PollingStatement: 
WITH XMLNAMESPACES ('http://IP0297.Schemas.MD_DBuser' AS ns0)
SELECT 
    '12345' AS 'ns0:queue_id',
    '67890' AS 'ns0:id',
    'true' AS 'ns0:synced'
FOR XML PATH('ns0:cchuser_biztalk_sync_queue'), ELEMENTS, ROOT('Root');

Sedan behöver man använda XMLReceive pipeline:n och mappa mot ett schema