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

[otluk]

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

[slangley]

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

[otluk]

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

[otluk · Accepted solution]

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