Unable to delete a jobflow, and when we try to open the jobflow it is showing as empty.

Was trying to delete the job flow which was corrupted, not able to delete the flow. When we try to open the jobflow it is showing empty. There was continuous data transfer from Friday on the Diyotta Agent 2 to the SQL Server. Need to know how can we stop or delete this kind of flows

Unable to delete a jobflow, and when we try to open the jobflow it is showing as empty.

Beginner Asked on April 6, 2021 in Diyotta Studio.
Add Comment
1 Answer(s)

This issue is happening as we having circular links between the two jobs present in the jobflow as shown below. Circular linking is not allowed in Diyotta. Only Forward linking is allowed.

RE: Unable to delete a jobflow, and when we try to open the jobflow it is showing as empty.

We imported the attached jobflow JSON file in our local labs and used the below metadata queries to find the links between the jobs and tried to delete them. Once the links between the jobs are deleted then we were able to open the jobflow.

QUERIES:

select * from dxflow_fwd_lnk where dxflow_id = ;
Delete from dxflow_fwd_lnk where dxflow_id =;

Include the jobflow id present in the URL and try to delete them. Once the links are deleted then open the jobflow.

Jobflow Id can be obtained from the URL as shown below

RE: Unable to delete a jobflow, and when we try to open the jobflow it is showing as empty.

Expert Answered on April 20, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.