cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Help us improve the PTC Community by taking this short Community Survey! X

Cancel Model creation in TWx Analytics

drieder
15-Moonstone

Cancel Model creation in TWx Analytics

Hello everyone,

 

I am facing the problem, that sometimes when I want to create a model with the thingworx Analytics Builder, the state is stuck in "Running" for days, eventhough similar Models were created much faster. They also dont FAIL.

 

How can I cancel these Jobs? Delete does not do anything and also restarting the docker Containers of TWx Analytics keep the state in RUNNING.

 

Any Suggestions?

 

Best Regards,

Dominik

1 ACCEPTED SOLUTION

Accepted Solutions
nsampat
17-Peridot
(To:drieder)

Can you check out the following directory:

 

<user-home>/twx-analytics/transfers/training/training/

 

There will be a master directory with an epoch time. Files should be as: jobStatus.json, jobStatus.touch.json, queuedStatus.json.  The directory that matches the timestamp of the job create in Builder is the one you want to delete.

 

Example:

 

Capture.PNG

 

You will have to remove the directory, then restart the container(s). The Runaway job should then appear as Expired and can be deleted using the Builder delete button.

 

Alternately, you can try doing it this way:

 

docker exec -it <training-container-id> /bin/bash

cd /tmp/microservices/transfers/training/training

grep -R "<job-id>" .

# Returns something like "./1527095319573-5/<file>.json". Delete that directory:
rm -rf ./1527095319573-5

Then restart the container(s)

 

View solution in original post

6 REPLIES 6
nsampat
17-Peridot
(To:drieder)

Dominik,

 

Thank you for posting to the Developer Portal.

 

With the Docker deployment of Analytics, you will have to navigate to the mounted Docker volume and manually delete the parquet references to the run-away job.

 

On the volume, the Model data is stored in the following directory

/ThingWorxAnalyticsServer/data/data/results/data

You will need to find the file with the same Result ID and Model ID of the model and matching timestamps to that file and delete them manually.

Result-Model-ID.PNG

 

Data-Storage.PNG

 

After you do that, you need to restart the Analytics containers, and the run-away jobs will show as "Expired"; and you will be able to remove them using the "Delete" function in Builder, or they will gone already.

 

Please let me know if that helps.

 

Regards,

 

Neel

drieder
15-Moonstone
(To:nsampat)

Hello Neel,

 

I looked into my running docker containers but could't find your directories. Any Idea where they could be? These are my containers:

Screenshot (29).png

 

 

This is how they look inside:

Screenshot (30).png

Regards,

Dominik

nsampat
17-Peridot
(To:drieder)

Dominik,

 

I will have to research this further.

 

I will be in touch as soon as I obtain the proper directory.

 

Regards,

 

Neel

drieder
15-Moonstone
(To:nsampat)

thank you very much!

nsampat
17-Peridot
(To:drieder)

Can you check out the following directory:

 

<user-home>/twx-analytics/transfers/training/training/

 

There will be a master directory with an epoch time. Files should be as: jobStatus.json, jobStatus.touch.json, queuedStatus.json.  The directory that matches the timestamp of the job create in Builder is the one you want to delete.

 

Example:

 

Capture.PNG

 

You will have to remove the directory, then restart the container(s). The Runaway job should then appear as Expired and can be deleted using the Builder delete button.

 

Alternately, you can try doing it this way:

 

docker exec -it <training-container-id> /bin/bash

cd /tmp/microservices/transfers/training/training

grep -R "<job-id>" .

# Returns something like "./1527095319573-5/<file>.json". Delete that directory:
rm -rf ./1527095319573-5

Then restart the container(s)

 

drieder
15-Moonstone
(To:nsampat)

Thank you very much, this worked for me!

Top Tags