Failed subscription triggers are slowing the UI after "Get it Now"

[GoebelL]

From @uhu133 on November 17, 2017 12:56

OSCM 17.4.
Provisioning Service based on APP (Powershell)

When using user "cmgt-business" and subcribing to a service (HyperV), the UI change from "Get it Now" to the configuration dialog takes 2 seconds which is very good.
When using the user "cmgt-it" (who is in the supplier organization) and subcribing to the same service (HyperV) the change from "Get it Now" to the configuration dialog takes about 180 seconds which is too long.
Please investigate

Copied from original issue: servicecatalog/oscm#49

[GoebelL]

Checking the data from both users the cause gets clear.
In opposite to "cmgt-business" the user “ctmg-it” has defined a Create Subscription trigger. This trigger is not correctly configured, respectively the URL points to a location where either no notification service is deployed or this service is not functional.

“java.io.IOException: Error 404 while retrieving http://ESCM-SERVER:8880/approval/notification?wsdl”

There are about 130 trigger processes and it takes time to read them from DB. This is a rather special case than a general performance bug.
Solution is to remove the failed trigger processes.