We are trying to switch Service Plan for subscription however we cannot place order and getting following error:
There is an uncompleted Resource Order #RCXXXXX related with Resource #YYYYY
There is old unprocessed resource order for this subscription. It might be in status Provisioning Failed or Cancelled.
Change status of Resource in PBA-E database:
UPDATE "SubscrParam" SET "RelativeStatus"=10, "Status"=2, "OIID"=NULL WHERE "subscriptionID"=XXXXXXX and "resourceID"=XXXXXX;