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
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.
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
