Incomplete Export

Expected behavior

Exporting 1376 rows representing our deliveries

Actual behavior

Exporting 1113 rows

Failure Logs

Please include any relevant log snippets, if necessary.

Context

it appears to us that the rows that have missing informations (address, delivery_date)

Please provide any relevant information about your setup.

gem ‘forest_liana’,’>=5’
psql 11.10

Hello @Guillaume_Stockoss, and welcome on our community forum,

I’v tried to export records with missing fields & I can’t reproduce locally on my projects, could you show me an example where I should be able to reproduce? :slight_smile:

Hello @lclisson,

I have the same issue as Guillaume, I “lose” rows between the front of forest and the CSV export,

You can find just below the screen from the export :

And you can find below the link to the csv export from this page : (removed)

The delivery which have id 3059 isn’t in the export,

Hi @Jean-Baptiste_Oger
I’m trying to reproduce your issue.

Can you give me more information?
I wish to replicate your problem locally, and add the relevant tests to our automated test suite.

In order to so so

  • Which stack are you using for you agent? Rails, Express-Mongoose or Express-Sequelize? Those 3 don’t share the same implementation, I don’t know which one to check!
  • Which version of the agent are you using? (so that I can check that this was not already fixed)

Also on the original post of @Guillaume_Stockoss, ~20% of rows were missing from the export.
Is that the case for you as well? or is only the 3059 row missing?

1 Like

Hi romaing,

You can find my answers in blue color :

In order to so so

  • Which stack are you using for you agent? Rails, Express-Mongoose or Express-Sequelize? Those 3 don’t share the same implementation, I don’t know which one to check!
    We are on rails,

  • Which version of the agent are you using? (so that I can check that this was not already fixed)
    It’s the version 6,

Also on the original post of @Guillaume_Stockoss, ~20% of rows were missing from the export.
Is that the case for you as well? or is only the 3059 row missing?

It’s the same issue as Guillaume, the delivery 3059 is just an example,

Hello again @Jean-Baptiste_Oger & @Guillaume_Stockoss !

I think I am reproducing the issue you are both having.

Hopefully the issue I’m seeing is the good one: rows where all varchar columns are null are getting excluded from CSV exports…

We’ll be releasing a patch shortly

Nice, thank you for the answer,

Can you let us know when the patch will be released please ?

Have a nice day

Hello,

I just made a new export from Forest and I still have the issue (rows missing),

Do you know when the patch will be available?

Thanks in advance,
Have a nice day

It should be released this week. I hope tomorrow, or the day after.
It’s in the tracker with the highest priority (as there is no workaround for customers).

Sorry for the inconvenience / the delays

I just released a fix.
It should be in production in ~30 minutes (so that the CD have time to release the new version)

No need to update your agents, just refresh your browser, and the CSV exports should be fixed.

We had a delay with this fix, but it is live now. Can you check if it’s working as expected @Jean-Baptiste_Oger?

Hi Guillaume,

I just try and it’s not fixed,

I log out and log in just after your answer and tried the export,
I still have missing rows,

Please find below the file : Livraisons (30) - Google Sheets

For instance, the delivery 3059 is still missing in the file,
I still have 1653 rows in the file vs 1860 in forest,

Can you send me the logs from your rails agent?
Specifically, I’m interested in the SQL queries which are performed when exporting.