BizTalk360 Analytics Report CPU Graphs Issue

Problem:

I am using BizTalk360 version 8.9.5112.2201 in a BizTalk2016 environment. In setting up reports, I came across an interesting issue.  If you have looked at the CPU usage reports, you may have noticed that the graphs do not match actual performance.

Consider the following SQL Servers Performance graph.

SQL Servers Performance
SQL Servers Performance

You will notice that the left-side legend is displaying 0-100%. I make the assumption that this is Total CPU and the right-side legend is memory usage.

Continue reading BizTalk360 Analytics Report CPU Graphs Issue

SQLSTATE=IM014,Native error=0,msg='[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application’

Error:

SQLSTATE=IM014,Native error=0,msg='[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application'

Continue reading SQLSTATE=IM014,Native error=0,msg='[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application’

Determine DLLs hosted by Process

tasklist /m /fi "IMAGENAME eq wmiprvse.exe"

/M     [module]         Lists all tasks currently using the given
exe/dll name. If the module name is not
specified all loaded modules are displayed.

/FI    filter           Displays a set of tasks that match a
given criteria specified by the filter.

If you want DLL's hosted by any/all processes, remove the /FI filter parameter. In the example, we list dll's in use by the WMIPRVSE services.

Another example might be;

tasklist /m /fi "IMAGENAME eq cmd.exe"

You can filter on many different items, such as PID. Below we list dll's used by the SYSTEM process.

tasklist /m /fi "pid eq 4"

UDP Client Testing

There are many applications that use UDP ports in operation. When firewalls are in place, it can be difficult to determine if the problem connecting is due to the firewall, or simply the application.

The attached files can help with this.

udpserv.ps1 is a quick PowerShell script that will listen on a defined port for incoming UDP data and display the received data on the screen.

To use the udpserv.ps1 script;

  •  Change $port = 2020 to the port you want to test.
  • Open a PowerShell window.
  • Change to script download location
  • Execute script by typing ".\udpserv.ps1" and process enter. The script will block until complete.

The client script udpclient.ps1 will connect to the defined port on the defined server and will send 10 lines indicating the iteration of the UDP test.

To use the udpclient.ps1 script;

  • Change the $IP = "10.0.0.1" line to match the IP of the system running udpserv.ps1.
  • Change the [int] $Port = 2020 to match the port specified in the udpserv.ps1 script above.
  • Open a PowerShell window.
  • Change to script download location
  • Execute script by typing ".\udpclient.ps1" and process enter.

You can download the udptest.zip file which contains the client and server scripts.