Hi Ben Lower
I'm no expert in the SDK side of Tableau, but exercised my Tableau Ambassador contacts to find who might be best placed to answer this one...and I was given you name!! (by Derrick Austin). Vathsala is is one of our developers working on the automation of our TDE creation
Derrick did give me this possible reason, but Vathsala is only reading when she gets this error (and not inserting)?
With ours, we have always created the extracts in Python instead of loading them from existing sources, but I have seen that error before.
If I recall correctly, it happened to us when the "column number" of the column we were trying to insert didn't match the definition. (IE: trying to insert a 10th column when there were only 9 columns defined)
If this is happening randomly from existing extracts, it might be a bug or something funny in your extracts that the extract API hasn't accounted for.
Any help/advice is greatly appreciated.
Did you ever manage to find any resolution to this ?
I'm hitting an identical problem in reading and existing extract, with no way of knowing what columns this refers to to try identity the cause.
1 of 1 people found this helpful
As far as I know this is caused because new columns have been created through Tableau Desktop and these new columns sit in the Datasource definition but not in a way that the SDK can access it.
What worked for us (at Atheon) was to create a TDE from scratch and publish that, then when new columns are created they sit in the workbook instead of the datasource. This separation then lets us use the SDK on the datasource for inserting new rows of data.
I hope that helped.
Cheers for the reply. I did a lot of testing and rebuilding of the troublesome data source over the weekend, and eventually found this to be a seemingly corrupt or old extract. Removing the Extract from the data source and re creating this afresh resolved out issues in the end .