Error 4 Mismatched row counts after incremental refresh of Extract

tableaucommunity@tableau.com — Fri, 26 Apr 2013 09:05:04 GMT

I have this issue on only one of my connexions to my MySQL database.

Actually this conexion uses a Table with a Left Join on itself.

Here is the pattern in ore details:

Steps:

Live connection to our MySQL database, and creation of a data connection:

Left outer join between a field of a table (id of a user's friend) and a different field of the same table (id of the user himself).

→ OK, the connection is created, and displayed data is correct.

Launch of a data extraction with “All rows” setting.

→ OK, the extract is created in the expected folder, and displayed data is still correct.

Launch of an incremental refresh of the extract based on a timestamp field.

→ not OK, this time an Error 4: Scan::Next: Mismatched row counts is displayed:

When clicking on “OK” button, then:

“Locate the extract” leads to the same error: “Extract not found”.

Clicking on “Cancel” button closes the error windows, the data connection is still working and above all the extract is updated with the latest data. So clearly the Error detected above is not justified.

But after saving the workbook, closing it and re-opening it leads to the same “Extract not found” error sop the workbook becomes unusable.

Does anyone experience the same issue, or have a fix?

I believe there's a "false positive" bug here, and it's become a big problem for us as we have to Refresh entire extract because of the failure of Incremental extraction.

If you're a Tableau developer, please contact me: I can send you logs and ata.

Thanks for you help,

Louis

OData connectio, to Facebook Insights

tableaucommunity@tableau.com — Thu, 08 Sep 2011 16:13:31 GMT

Hi,

I manage several pages and apps on Facebook and since Facebook has started giving access to their insights data through OData, I'd like to see this data on Tableau directly instead of having to export to CSV.

It should work through a Facebook app here: http://apps.facebook.com/insightsodata/

Once installed it does give me OData URLs, but I haven't managed to make them work on Tableau 6.

has anyone had more luck?

thanks

Louis.

Content in Tableau Community Forums

Error 4 Mismatched row counts after incremental refresh of Extract

OData connectio, to Facebook Insights