Execution cannot be started when the Data Flow contains stand-alone steps.

Kaden B

Hello, I'm working on a data flow using Oracle Analytics Cloud through NetSuite Analytics Warehouse. Everything looks good in the data preview, but when I run the flow, I get the error "Execution cannot be started when the Data Flow contains stand-alone steps." There are no stand-alone steps in the flow, but I've narrowed it down to a problem with the join by trying a Save Data step after every step up to that point. Has anybody had this issue or know how to address it?

Federico Venturin - Oracle

Hi @Kaden B ,

Instead of using the Branch step in your data flow, you should add your input dataset twice. In this way there will be no errors when you add a Join step.

Mallikarjuna Kuppauru-Oracle

Hi Kaden,

FYI, Below is the notes from MOS doc -

you must use two Data Sources instead of using a branch .

The way to do this without causing massive rework is to create a new Workbook / Data Set

and use it as the Data Source, multiple times as needed.

1) Create the new DataSet

2) Replace Branch with join of the DataSet_Columns and DataSet_Aggregate,

3) This WorkAround will prevent the error

4) Also using this method avoids re-creation of the same duplicated steps prior to the branch.

Regards,

Arjun

Mallikarjuna Kuppauru-Oracle

Hi Kaden,

Can you check below MOS doc -

Data Flow Error "Execution cannot be started when the Data Flow contains stand-alone steps" (Doc ID 2876950.1)

Regards,

Arjun

Kaden B

@Mallikarjuna Kuppauru-Oracle thank you for the quick response. Unfortunately I cannot access that document. It requires access to Oracle support, which I don't have.

Kaden B

@Federico Venturin @Mallikarjuna Kuppauru-Oracle Thank you both for the help. Your solutions worked!

Mallikarjuna Kuppauru-Oracle

Hi @Kaden B

Good to see your update as its worked . You can mark as Answered so that community peoples will take its as reference if any body got the same issue.

To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence. Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!

Regards,

Arjun