User Profile
NiklasE
Joined Sep 25, 2018
User Widgets
Recent Discussions
Re: BizTalk 2020 WCF-OracleDB adapter Error
NareshDevalla harik98 If you use install.bat the 5th parameter should do the GAC + machine.config also if you set true for this parameter. -------- Install.bat COMPONENT_NAME: (Required) ODAC component to install and configure. Values: ODPM (Managed ODP.NET), ODP.NET4 (Unmanaged ODP.NET), ORAMTS (Oracle Services for MTS), etc., or ALL (all components). ORACLE_HOME_PATH: (Required) Directory to install ODAC into. Be mindful if installing to a protected Windows directory, such as C:\Users\<USER NAME>. These directories may have permission restrictions for who can run and which apps can be run. ORACLE_HOME_NAME: (Required) Unique Oracle Home name. INSTALL_DEPENDENTS: (Optional) When set to true, the script installs any dependencies the components require. Default value is true. MACHINE_WIDE_CONFIGURATION: (Optional) When set to true, the script will configure ODP.NET for machine-wide default use. It makes global changes to the machine's .NET setup, including placing the provider assembly into the Global Assembly Cache (GAC) and updating the <i>machine.config</i> with configuration section handler and DbProviderFactory information. This parameter only works for ODPM (Managed Driver for .NET Framework 4) and ODP.NET4 (Unmanaged Driver for .NET Framework 4). Default is false. TNS_ADMIN_LOCATION: (Optional) Directory that ODAC finds tnsnames.ora and/or sqlnet.ora configuration files. This setting is made in the Windows Registry.1.9KViews0likes0CommentsRe: BizTalk 2020 WCF-OracleDB adapter Error
harik98 I would suggest to restart uninstalling previous attempts/unGAC and try the latest 19c unmanaged XCopy client. https://www.oracle.com/database/technologies/net-downloads.html Oracle XCopy unmanaged .NET client installation : If not default location (ORACLE_HOME\network\admin), create a System Environment Variable for : Name: TNS_ADMIN Path (change to your location) : c:\oracle\network\admin\ CD C:\Oracle\Setup-19x-32bit :: Install all to 32-bit folder, 32-bit home name. You can omit the last TNS_ADMIN location parameter if using the default location install.bat all c:\oracle\ora19c32 ora19c32 true true c:\oracle\network\admin CD c:\oracle\ora19c32 :: Uninstall 32-bit ORAMTS since we will use the 64-bit ORAMTS and you can only have one ORAMTS running. uninstall.bat ORAMTS ora19c32 CD C:\Oracle\Setup-19x-64bit install.bat all c:\oracle\ora19c64 ora19c64 true true c:\oracle\network\admin :: Then manually add these paths to Path System environment variable c:\oracle\ora19c64 c:\oracle\ora19c32 :: check GAC gacutil /l | find /I "4.12" Oracle.DataAccess, Version=4.122.19.1, Culture=neutral, PublicKeyToken=89b483f429c47342, processorArchitecture=AMD64 Oracle.DataAccess, Version=4.122.19.1, Culture=neutral, PublicKeyToken=89b483f429c47342, processorArchitecture=x86 Oracle.ManagedDataAccess, Version=4.122.19.1, Culture=neutral, PublicKeyToken=89b483f429c47342, processorArchitecture=MSIL :: Add AssemblyRedirect in BizTalk .config files and mmc.exe.config for it to use the latest client <runtime> <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1"> <dependentAssembly> <assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89b483f429c47342" culture="neutral" /> <bindingRedirect oldVersion="4.0.0.0-4.65535.65535.65535" newVersion="4.122.19.1" /> </dependentAssembly> </assemblyBinding> </runtime>1.9KViews0likes2CommentsRe: 4K Display issue with BizTalk (in VS and BTS Administration Console)
I have a very large monitor with similar resolution at work, which works fine with RDCMan and 100%. I use external screen only, and then I use 50% of my screen for RDC (left or right half with full height): https://learn.microsoft.com/en-gb/sysinternals/downloads/rdcman Perhaps you can try different RDC options in this? (Both Display settings tab and Remote desktop settings tab)1.3KViews0likes0CommentsRe: BizTalk 2020 Office365 Email Send Port - Errors but emails sent every 5 minutes
This issue should be fixed in latest BizTalk 2020 CU3. Until you have installed CU3, to avoid duplicate emails in earlier version, change retry to 0. Then the email should be sent once and then get suspended, which you can delete.723Views0likes0CommentsRe: Benchmark data on BizTalk 2020 Virtualization
I have seen many customers move from very fast on-prem SAN to slower virtual/cloud disks having performance problems. Usually CPUs are ok as long as you don't share CPUs with lots of VMs. So I would benchmark during load tests the old on-prem disk performance and then compare the virtual/cloud disk performance. In SQL you can also check DMVs for read and write storage latency, which also give good insight. Usually on good systems I see, it is less than 5ms under load.660Views0likes0CommentsRe: The BizTalk Service BizTalk Group : BizTalkServerApplication service terminated unexpectedly.
Sometimes procdump exception log can help you understand what is happening. Stop all BizTalk processes and then monitor the next process to start (-w option waits for it to start and it can only handle one process so need to stop all other processes) :: Download Procdump from Sysinternals and then do the following in admin cmd procdump.exe -e 1 -f "" -w BTSNTSvc.exe >> C:\temp\%computername%-procdumplog.txt :: or for 64-bit BizTalk host instance: procdump.exe -e 1 -f "" -w BTSNTSvc64.exe >> C:\temp\%computername%-procdumplog.txt if they crash is really too fast before the ProcDump debugger can attach to the process, e g if BTSNTSvc.exe does not exist, permissions etc, then the log may not be possible.1.1KViews0likes0CommentsRe: MultiSubnetFailover for BizTalk 2020
BizTalk currently does not use this option. Personally for the quickest (reduce locks as well) and most highly available I would recommend SQL Failover Cluster Instance (FCI), classic Active/Passive cluster. SQL FCI only use one shared storage which is faster than having to wait for SQL AO AG primary and secondary nodes to do the sync operation (CPU and network overhead). In Azure you can use the newer Azure Shared Disk as shared storage for SQL FCI and MSDTC.1.3KViews0likes0CommentsRe: BizTalk 2020 and OLE DB Driver for SQL Server Driver 19 driver issue
BizTalk 2020 currently relies on 18.x version and will not use the new 19.x DLL, which has separate new DLL and provider name. I would recommend the latest 18.x version, which is currently 18.6.3 version. https://docs.microsoft.com/en-us/sql/connect/oledb/release-notes-for-oledb-driver-for-sql-server?view=sql-server-ver15#previous-releases5.4KViews2likes1CommentRe: 4K Display issue with BizTalk (in VS and BTS Administration Console)
Does it help if you set scaling option in Windows display settings to 100% (assuming you may have 150% or 200% instead)? What is the result of this powershell script? (getting details about resolution, scaling, monitors and version of VS 2019) ------- Add-Type -AssemblyName System.Windows.Forms $screen_cnt = [System.Windows.Forms.Screen]::AllScreens.Count $col_screens = [system.windows.forms.screen]::AllScreens $vs2019file = "C:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise\Common7\IDE\devenv.exe" $info_screens = ($col_screens | ForEach-Object { if ("$($_.Primary)" -eq "True") {$monitor_type = "Primary Monitor "} else {$monitor_type = "Secondary Monitor "} if ("$($_.Bounds.Width)" -gt "$($_.Bounds.Height)") {$monitor_orientation = "Landscape"} else {$monitor_orientation = "Portrait"} $monitor_type + "(Bounds) " + "$($_.Bounds)" $monitor_type + "(Primary) " + "$($_.Primary)" $monitor_type + "(Device Name) " + "$($_.DeviceName)" $monitor_type + "(Bounds Width x Bounds Height) " + "$($_.Bounds.Width) x $($_.Bounds.Height) ($monitor_orientation)" $monitor_type + "(Bits Per Pixel) " + "$($_.BitsPerPixel)" $monitor_type + "(Working Area) " + "$($_.WorkingArea)" } ) If ((Test-Path $vs2019file) -eq $True) { $devenvversion = (Get-ChildItem -Path $vs2019file).VersionInfo.ProductVersion } else { $devenvversion = "*Not existing*" } $DPISetting = (Get-ItemProperty 'HKCU:\Control Panel\Desktop\WindowMetrics' -Name AppliedDPI).AppliedDPI Write-Host "VS DevEnv.exe version : $devenvversion" Write-Host "DPI setting (96=100%) : $DPISetting" Write-Host "TOTAL SCREEN COUNT: $screen_cnt" $info_screens ----------1.5KViews0likes2CommentsRe: BizTalk 2020 - Office 365 Outlook Adapter - TMS errors
I would check to test the logon outside and also to recreate the logon to make sure it is correct and check if it is working fine with BizTalk 2020 CU2 and the tips from here to put dependency if there is no dependency already: https://techcommunity.microsoft.com/t5/biztalk-server/biztalk-tms-does-not-start-after-biztalk-server-2020/m-p/15728512.6KViews0likes0CommentsRe: BizTalk and SMB FileShare
I have seen issues with different NAS devices not fully supporting SMB 2/3 protocols where files were locked incorrectly. When locking is not working correctly or if there is a network issue the file can incorrectly become unlocked, which is then picked up by BizTalk. BizTalk has been tested with Windows NTFS file system as mentioned also in documentation: https://docs.microsoft.com/en-us/biztalk/core/file-adapter https://docs.microsoft.com/en-us/biztalk/core/configure-the-file-adapter Here are some tips which may avoid the issue: - use temp file options in file adapter send port options so files are not available to others while in transit - disable antivirus for the BizTalk process (BTSNTSvc*.exe, msdtc.exe, entsso.exe) and file locations used by BizTalk - cluster receive and send file hosts so only one host instance is operating on the file at the same time - ask producer of files (if other applications outside of BizTalk is producing the files) to use temp files and moving/renaming files when they are fully available It can also be related to network issues. Similar to SMB server, some NAS devices may also have tuning/configuration which can be optimised. For those using Windows SMB server, this guide can be useful: https://docs.microsoft.com/en-us/windows-server/administration/performance-tuning/role/file-server/smb-file-server Troubleshooting tips/known issues: https://docs.microsoft.com/en-us/windows-server/storage/file-server/troubleshoot/smb-known-issues https://docs.microsoft.com/en-us/windows-server/storage/file-server/troubleshoot/troubleshooting-smb Disabling SMB 2/3 may work if the NAS i successfully using SMB 1, but this is not recommended as it will cause the whole BizTalk server to use SMB 1, and it is strongly recommended to not use SMB 1 anymore: https://docs.microsoft.com/en-us/windows-server/storage/file-server/troubleshoot/detect-enable-and-disable-smbv1-v2-v3 https://techcommunity.microsoft.com/t5/storage-at-microsoft/stop-using-smb1/ba-p/4258581.4KViews0likes0CommentsRe: BizTalk process Host is not releasing memory until Hosts are manually restarted
I have seen a few issues with logging frameworks leaking memory objects, e g config file watchers and timer objects. Since it was related to timers and events being fired, it was also using more and more resources. I could see millions of .NET objects in memory dumps. So it can be good to replace older logging frameworks and have more control over this yourself if you need logging. As a workaround until you replaced the logging, if not leaking too much memory you could e g on daily basis restart the BizTalk host or set recycling period of the IIS application pool if this is in isolated host.1.8KViews0likes0CommentsRe: BizTalk 2020 WCF-OracleDB adapter Error
If you changed BTSNTSvc.exe.config / BTSNTSvc64.exe.config files, you may also need to change MMC.exe.config (BizTalk admin console) for BizTalk admin console. You may also need to change the Oracle.DataAccess.Client to point to newer version (see below). ----- https://docs.microsoft.com/en-us/biztalk/adapters-and-accelerators/post-installation-steps-for-biztalk-adapter-pack-2016#use-a-newer-oracledataaccessdll-version ----- <dependentAssembly> <publisherPolicy apply="no" /> <assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89b483f429c47342" culture="neutral" /> <bindingRedirect oldVersion="0.0.0.0-65535.65535.65535.65535" newVersion="4.122.19.1" /> <!--<bindingRedirect oldVersion="0.0.0.0-65535.65535.65535.65535" newVersion="4.122.18.3" /> --> </dependentAssembly> </assemblyBinding> </runtime> <system.data> <DbProviderFactories> <add name="Oracle Data Provider for .NET" invariant="Oracle.DataAccess.Client" description="Oracle Data Provider for .NET" type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Version=4.122.19.1, Culture=neutral, PublicKeyToken=89b483f429c47342" /> <!--<add name="Oracle Data Provider for .NET" invariant="Oracle.DataAccess.Client" description="Oracle Data Provider for .NET" type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Version=4.122.18.3, Culture=neutral, PublicKeyToken=89b483f429c47342" />--> </DbProviderFactories> </system.data> ------ I would also make sure to update to the latest BizTalk 2020 CU (CU2 currently) as there were some updates related to Oracle adapter after initial RTM release. I hope this helps.3KViews0likes5CommentsRe: BHM50 update without internet access not work any more
Sorry for the inconvenience. There was a change in update location related to security/authentication, where some older versions couldn't be updated. We created a new fresh installation/setup package. You can download the latest major version on download center and once you have this version installed, you should be able to perform online update again to get to the latest (minor) version. Here is the BHM download center location: https://www.microsoft.com/en-us/download/details.aspx?id=43716 If you have BHM running on BizTalk server without internet and you want to get the latest online update, you can download and update BHM on another internet facing computer and copy/paste the changed files. You can sort files in installation folder by date time and see which files have been updated.1KViews0likes0CommentsRe: Min and Max memory setup on SQL server
sudhanshu3992 16GB sounds too small for such environment. My developer laptop has 64GB. I would recommend also to upgrade to BizTalk 2020 from supportability perspective. I would recommend here to increase to 32GB at least and then put MAX server memory to around 26-28 GB instead. Adding a cpu core to SQL might also be a good idea as it sounds too much to be on 95-100%. With increased memory it may be less, but still sounds like you need more CPU power. To offload SQL pressure, you can change default 500ms maxreceiveinterval (polling) to something larger, e g 2000ms (2s). Try to avoid low latency polling SQL intensively if not really necessary. If needed limit that to one or few hosts only and increase the other batch hosts. For pure receive hosts they don't use dequeue polling since they get their items from other sources so you can even put more, e g 30000ms (30s). Given your logon failures, you may actually also hit MaxConcurrentAPI NTLM netlogon limit. Search and you will find a script to measure if you need to change it (there is some potential area in 15-45s which is not really measurable here though). You can try to increase MaxConcurrentAPI to 10 or 20 on BizTalk and SQL servers (I assume domain controllers already have higher setting) to see if that helps as well, but you should reconfigure SQL to use Kerberos (cached tickets) instead so it doesn't need to go to domain controller on each new connection. BizTalk uses quite a lot of SQL connections. Also, try to minimise or disable tracking if not needed as it will reduce SQL load as well. Some customers have lots of host instances. You need to find good balance as this increases the number of pollings/dequeues also. It depends on your network, cpu, memory, and load. Some may be fine with 40+ BizTalk host instances if having really powerful lots of cpu/128GB SQL server, others it is better with 10-20. But as mentioned, you can also increase polling interval in host settings as a balance here. You can also increase large message size limits in BizTalk group settings. Then your messages are kept larger and not split into lots of small sub-transactions (parts). If BizTalk server has enough memory this may be good if you process larger messages than 100KB. This can have good effect on SQL and general performance as well.1.3KViews0likes0CommentsRe: Tabs gone after WindowsUpdate reboot. How to get all tabs back?
Deleted It seems to work fine last weeks after later updated builds. Today e g now with these builds: 85.0.564.63 (Official build) (64-bit) 86.0.622.38 (Official build) (64-bit) I will keep on testing other canary/beta build also in parallel now. If signed in to my account does this settings auto-propagate to all my computers or I need to watch out when installing new machines? (I use a couple of different machines and test newer Windows 10 builds also on regular basis switching installations quite often. )59KViews0likes1CommentRe: Tabs gone after WindowsUpdate reboot. How to get all tabs back?
Deleted I have been using new Edge for a while now so been using it before the last update+reboot, but not sure if I installed the new before or after upgrade to Windows 10-2004. about: Microsoft Edge is up to date.Version 83.0.478.45 (Official build) (64-bit) I see now that on startup is set to this: "Open a specific page or pages" I will change it to "Continue where you left off" and see if this helps in settings.61KViews0likes3Comments
Recent Blog Articles
No content to show