CartoDB / cartodb

Location Intelligence & Data Visualization tool
http://carto.com
BSD 3-Clause "New" or "Revised" License
2.75k stars 650 forks source link

Error showing geocoded rows #7096

Closed ernesmb closed 8 years ago

ernesmb commented 8 years ago

The user receives an incorrect message when the geocoding process finishes.

This are the logs for the process:

[#<Geocoding @values={
:table_name=>"address",
:processed_rows=>15,
:created_at=>2016-04-09 12:28:06 +0000,
:updated_at=>2016-04-09 12:28:20 +0000,
:remote_id=>nil,
:formatter=>"{street_number}, {city}, {zip_code}, {state}",
:state=>"finished",
:id=>"***",
:user_id=>"****",
:table_id=>"de9ca4b5-23ff-48a2-8dce-03b535f6698f",
:automatic_geocoding_id=>nil,
:cache_hits=>2,
:kind=>"high-resolution",
:country_code=>nil,
:geometry_type=>nil,
:processable_rows=>22,
:real_rows=>-52,
:used_credits=>17,
:country_column=>nil,
:data_import_id=>nil,
:region_code=>nil,
:region_column=>nil,
:batched=>false,
:error_code=>nil,
:force_all_rows=>false,
:log_id=>"e6cffef9-d693-47bd-8878-cb4a0017fa11",
:geocoder_type=>"heremaps",
:pid=>"15591"}
 #<CartoDB::Log @values={
 :id=>"****",
 :type=>"geocoding",
 :user_id=>"****",
 :created_at=>2016-04-09 12:28:06 +0000,
 :updated_at=>2016-04-09 12:28:20 +0000,
 :entries=>"2016-04-09 12:28:06 UTC: Running geocoding job on server que03.useb.cartodb.net with PID: 15591\n2016-04-09 12:28:06 UTC: TableGeocoderFactory.get()\n2016-04-09 12:28:06 UTC: params: {:original_formatter=>\"{street_number}, {city}, {zip_code}, {state}\",
 :formatter=>\"street_number, ', ', city, ', ', zip_code, ', ', state\",
 :remote_id=>nil,
 :countries=>nil,
 :regions=>nil,
 :geometry_type=>nil,
 :kind=>\"high-resolution\",
 :max_rows=>5\n2016-04-09 12:28:06 UTC: geocoder_class = CartoDB::TableGeocoder\n2016-04-09 12:28:06 UTC: geocoder_type = heremaps\n2016-04-09 12:28:06 UTC: run_geocoding!()\n2016-04-09 12:28:06 UTC: Started searching previous geocoded results in geocoder cache\n2016-04-09 12:28:07 UTC: Finished geocoder cache job\n2016-04-09 12:28:07 UTC: Geocoding cache stats update. Total rows: 17 --- Hits: 2 --- Failed: 0\n2016-04-09 12:28:07 UTC: Initialized non batch Here geocoding job\n2016-04-09 12:28:07 UTC: Total rows to be processed: 16\n2016-04-09 12:28:07 UTC: Geocoding non-batch Here job status update. Status: completed --- Processed rows: 15 --- Success: 15 --- Empty: 0 --- Failed: 0\n2016-04-09 12:28:07 UTC: Non-batch Here geocoding job finished\n2016-04-09 12:28:20 UTC: Geocoding finished\n"}>

This is what the user sees when the process finishes

image001
iriberri commented 8 years ago

I'm going to close this one as the Builder does no longer work in that way :) Let's reopen or open a new one if we find something similar in there.