Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Data flow won't run after selecting a new data source using the parameter prompt.

Received Response
111
Views
8
Comments
Rank 1 - Community Starter

Hi all, I'm working with a dataflow that is meant to be reused over and over to append new datasets to a master dataset. To make the process as easy as possible we want to use the option to "Prompt to select data source" in the add data step. However, the data flow won't run after selecting a new data source using this prompt. I get the following error and am having trouble figuring out why it is going wrong as everything matches between the old and new dataset except for the names of the datasets themselves. Any ideas?

Also I followed these steps. https://docs.oracle.com/en/cloud/paas/analytics-cloud/tutorial-reuse-data-flow/#step_four

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • If you rename the "input file" to the same name as the original file name — does it then work?

  • Rank 1 - Community Starter

    No, I cannot have two datasets with the same same. When trying to rename the new "input file" I get thrown an error and the rename fails.

  • Rank 8 - Analytics Strategist
    edited May 2024

    @User_0MSAU - The error in log also points to invalid column <column name>, was it verified as well.

  • Rank 1 - Community Starter
    edited May 2024

    @Sumanth V -Oracle Yes, all the columns are the same between the two data sources and the flow runs perfectly when replacing the datasets manually inside the dataflow. It's only when trying to use the dataflow prompt that it will not run with a new data source.

  • Rank 8 - Analytics Strategist

    @User_0MSAU - Please let us know if you are seeing this behaviour in OAC or OAS, for further validation.

  • Rank 1 - Community Starter

    @Sumanth V -Oracle Using OAC

  • @User_0MSAU I am asking — if you rename XLSX on your hard drive and then upload it… does that work? The fact that it works when replacing the file when editing the data flow makes me think there is an issue with renaming the file.

    If so — then the two work arounds would be:
    1. Edit the data flow and replace it there
    2. Rename your file on your hard drive before uploading with the parameter prompt

  • Rank 4 - Community Specialist

    @User_0MSAU can you try removing the special characters # (i.e. invoice #) from the column name and see if that helps

Welcome!

It looks like you're new here. Sign in or register to get started.