There is a limitation in BizTalk360 (till version 7.5) user interface when it comes to removing an orphaned application or any other artifacts like send ports, receive locations, orchestrations etc. When the user removes the application/artifacts via BizTalk Administration Console during deployment, the UI will not allow you to remove it. This limitation has been addressed in our 7.8 version, but if you are on a lower version (below 7.8), currently the only option is to remove them manually from the database via scripts and reconfigure them in the UI if necessary.


NOTE: In the following sample scripts, we used BizTalk EDI Application as sample application, you need to replace it with your own application name. ​You can use the first select statements to make sure the right ones are selected, and then run the DELETE statement to remove them.


Removing orphaned Application

SELECT * FROM dbo.b360_alert_Monitor WHERE
MonitorGroupType = 'Application' AND
MonitorGroupName = 'BizTalk EDI Application'

DELETE * FROM dbo.b360_alert_Monitor WHERE
MonitorGroupType = 'Application' AND
MonitorGroupName = 'BizTalk EDI Application'


Removing orphaned Receive Locations

SELECT * FROM dbo.b360_alert_Monitor WHERE
MonitorGroupType = 'Application' AND
MonitorGroupName = 'BizTalk EDI Application' AND
MonitorName = 'ReceiveLocations'

DELETE FROM dbo.b360_alert_Monitor
WHERE
MonitorGroupType = 'Application' AND
MonitorGroupName = 'BizTalk EDI Application' AND
MonitorName = 'ReceiveLocations'


Removing orphaned Send Ports

SELECT * FROM dbo.b360_alert_Monitor WHERE
MonitorGroupType = 'Application' AND
MonitorGroupName = 'BizTalk EDI Application' AND
MonitorName = 'SendPorts'

DELETE FROM dbo.b360_alert_Monitor WHERE
MonitorGroupType = 'Application' AND
MonitorGroupName = 'BizTalk EDI Application' AND
MonitorName = 'SendPorts'
 

Removing orphaned Orchestrations

SELECT * FROM dbo.b360_alert_Monitor WHERE
MonitorGroupType = 'Application' AND
MonitorGroupName = 'BizTalk EDI Application' AND
MonitorName = 'Orchestrations'

DELETE FROM dbo.b360_alert_Monitor WHERE
MonitorGroupType = 'Application' AND
MonitorGroupName = 'BizTalk EDI Application' AND
MonitorName = 'Orchestrations'
 

Removing orphaned NT Services

SELECT * FROM dbo.b360_alert_Monitor WHERE
MonitorGroupType = 'BizTalk' AND
MonitorGroupName = 'KOVAIBTSSERVER' AND
MonitorName = 'NTService'

DELETE FROM dbo.b360_alert_Monitor WHERE
MonitorGroupType = 'BizTalk' AND
MonitorGroupName = 'KOVAIBTSSERVER' AND
MonitorName = 'NTService'


Removing orphaned SQL Jobs

SELECT * FROM dbo.b360_alert_Monitor WHERE

MonitorGroupType = 'SqlServerInstance' AND

MonitorGroupName = '<SQL Instance Name>' AND

MonitorName = 'SqlJobs'


DELETE FROM dbo.b360_alert_Monitor WHERE

MonitorGroupType = 'SqlServerInstance' AND

MonitorGroupName = '<SQL Instance Name>' AND

MonitorName = 'SqlJobs'


From version 7.8, we have added the ability to remove the Orphaned Artifacts from the UI. Say for instance, you have configured monitoring for certain artifacts like BizTalk applications, receive locations, send ports, SQL jobs etc., and later you either rename them or remove them completely in your environments. By doing so, the artifacts configured for monitoring move to an orphaned state. These orphaned artifacts can be removed right from the UI instead of manually removing those configurations at the database level by clicking the 'Remove Orphaned' button under Monitoring and Notifications -> Applications.