CSV load fails with operation could not be found error

Hi @wouter.goslinga 

Try to restart the server you experience this on, or perhaps just the various ODX Services and make sure all TX is not running.

Hi @wouter.goslinga 

Try to remove the CSV data source from the ODX by deleting it in TX and in the instance mapping.

Then go to this folder.

Delete the CSV folder and its content. 

Then map the CSV data source again and see that it is recreated there.

When this is done do another restart and see if this have resolved the issue.

@Thomas Lind I removed the CSV folder and cloned the erroneous datasource. The CSV directory reappeared. But still the same error, also in the cloned datasource.

@AvanWijnen how can I select a specific provider version in the portal?

@AvanWijnen okay, now we're getting somewhere :). The new datasource with the 8669 version does work. So how can I change the version of the erroneous datasource. Using a new datasource would require me to remap all the tables...

We have just implemented the solution which @AvanWijnen mentioned. The result is that some datasources succesfully complete a full transfer and some still give the exact same error @wouter.goslinga mentioned at the beginning of this post.

See the attached screenshot. 

Datasource in the TX portal is .8669.0

Could someone please assist. Thanks in advance. 

Hello @Thomas Lind ,

Thank you for your reply and help! 

A quick look shows these differences:

• 1. Aggregation of CSV files. 2. No aggregation
• 1. Rowscan depth 1000 2. Normal row scan depth of 100

The datasource with the aggregation is the one that works. 

My collegeau just created a new csv datasource and created new .RSD files. 

Apparently the old .RSD files did not work with the newer datasources. 

New RSD files add the following code to the .RSD

  <api:script method="GET">
    <api:call op="csvproviderGet">
      <api:push/>
    </api:call>
  </api:script>

  <api:script method="POST">
    <api:call op="csvproviderAdd">
      <api:push/>
    </api:call>
  </api:script>

  <api:script method="MERGE">
    <api:call op="csvproviderMerge">
      <api:push/>
    </api:call>
  </api:script>

  <api:script method="DELETE">
    <api:call op="csvproviderDelete">
      <api:push/>
    </api:call>
  </api:script>
</api:script>

Old RSD only contain

  <api:script method="GET">
    <api:call op="csvproviderCSVOPTIONSWRAPPER">
      <api:push/>
    </api:call>
  </api:script>
</api:script>

If a CSV datasource receives an update is there a way to auto update .RSD files?

Thanks in advance.