Skip to main content
O
otluk1-Visitor
1-Visitor
July 16, 2020
Solved

ThingWorx Flow - Can not delete existing workflow (even with Administrator rights)

  • July 16, 2020
  • 3 replies
  • 1689 views

otluk_0-1594903649827.png

I have the existing workflow, which is enabled - Unable to open the workflow or delete this workflow. Unable to disable the workflow as well.

Is there an option in the settings or is this just a bug that prevents me from deleting this workflow?

Anyone has some hints what I can do to delete the workflow?

 

Remark: Also deleted the connected account

 

 

Best answer by otluk

The issue occured probably because of upgrading Thingworx Flow to a newer version.

The issue I was hitting earlier is that no Flows were showing in the Flow webpage. But after a restart to all the services(Twx+Flow+Nginx+Postgres+RabbitMQ) everything is working. Just to be safe you should make a Backup or snapshot to the DB before starting. To remove them follow these steps:

 

  1. Open pgAdmin and scroll to Databases>thingworx_db>schemas>public>tables
  2. Query the remaining Flows in tables: servicedefinitions & serviceimplementations using: select * from serviceimplementations where name ='flow_name';
  3. Stop all other services except Postgres
  4. Run a delete queries on those entries in both tables. I used: delete from serviceimplementations where name ='flow_name';
  5. Start all services back again. The Flows should be deleted

3 replies

S
slangleyCommunity Manager
Support
July 16, 2020

Hi @otluk.

 

What version of ThingWorx are you running?  What information is available in the logs at \ThingworxStorage\logs?

 

What do you mean by "Also deleted the connected account?"  Are you referring to the account credentials for the external system?

 

Regards.

 

--Sharon

    O
    otluk1-VisitorAuthor
    1-Visitor
    July 16, 2020

    Hi @slangley ,

    Here are my answers:

    What version of ThingWorx are you running? 

    ThingWorxFlow-8.5.3

    What information is available in the logs at \ThingworxStorage\logs?

    ApplicationLog attached

    What do you mean by "Also deleted the connected account?"  Are you referring to the account credentials for the external system? Yes I deleted the account credentials for the external system

    O
    otluk1-VisitorAuthorAnswer
    1-Visitor
    July 28, 2020

    The issue occured probably because of upgrading Thingworx Flow to a newer version.

    The issue I was hitting earlier is that no Flows were showing in the Flow webpage. But after a restart to all the services(Twx+Flow+Nginx+Postgres+RabbitMQ) everything is working. Just to be safe you should make a Backup or snapshot to the DB before starting. To remove them follow these steps:

     

    1. Open pgAdmin and scroll to Databases>thingworx_db>schemas>public>tables
    2. Query the remaining Flows in tables: servicedefinitions & serviceimplementations using: select * from serviceimplementations where name ='flow_name';
    3. Stop all other services except Postgres
    4. Run a delete queries on those entries in both tables. I used: delete from serviceimplementations where name ='flow_name';
    5. Start all services back again. The Flows should be deleted
    Terms & ConditionsAccessibility statement