I have tried installing CartoDB in Ubuntu 14.04 LTS first on which I could not import datasets. I have raised the question on this viz., Import Files failed with cartoDB installed in Ubuntu 14.04 LTS. But could not find a solution.
As an alternative, I have tried installing the CartoDB following the instructions from the manual "http://cartodb.readthedocs.io/en/latest/install.html" in Ubuntu 12.04 VM. But again when I try to import any file (CSV or shapefile in zip format), I am getting same import error which is decribed as follows.
Error Code : 2001
Error Description : Unable to load data
Imports Log:
{"user":"development","state":"pending","tables":0,"imported_tables":0,"failed_tables":0,"error_code":null,"import_timestamp":"2018-01-30T21:13:16-08:00","queue_server":"ubuntu","database_host":"localhost","service_name":"public_url","data_type":"file","is_sync_import":false,"import_time":0.001509,"file_stats":{},"resque_ppid":null,"user_timeout":13981,"error_source":null,"id":"0a0952bb-b387-48f5-8fbb-e7b5c5be04c5","total_size":0,"cartodbfy_time":0.0,"import_throughput":0.0,"cartodbfy_throughtput":null,"cartodbfy_import_ratio":0.0,"extra_options":{},"retrieved_items":0}
{"user":"development","state":"failure","tables":1,"imported_tables":0,"failed_tables":1,"error_code":2001,"import_timestamp":"2018-01-30T21:13:18-08:00","queue_server":"ubuntu","database_host":"localhost","service_name":"public_url","data_type":"file","is_sync_import":false,"import_time":2.67401697,"file_stats":[{"filename":"sample_csv.csv","type":".csv","size":201,"file_rows":null,"imported_rows":null,"error_percent":null,"fallback_executed":null}],"resque_ppid":9926,"user_timeout":13981,"error_source":"user","id":"0a0952bb-b387-48f5-8fbb-e7b5c5be04c5","total_size":201,"cartodbfy_time":0.0,"import_throughput":75.16781017287262,"cartodbfy_throughtput":null,"cartodbfy_import_ratio":0.0,"extra_options":{},"retrieved_items":0}
CSV File to Import:
lon,lat -50.09765625,38.95940879245421 -50.09765625,38.95940879245421 -50.09765625,38.95940879245421 -50.09765625,38.95940879245421 -50.09765625,38.95940879245421 -50.09765625,38.95940879245421
Also, I am getting a warning like:
"ignoring statsd, because there were a error loading the config"
while starting the server. Do we need to perform any additional configuration for "app_config.yml" or "database.yml" in cartodb?
ogr2ogrconfiguration in yourapp_config.yml? It should point to a validogr2ogrinstallation in your machine (i.e. executing thewhichstatement in your machine must point to a valid path). Also, althought not related to the problem, take into account that all the points that you are trying to import have the same coordinates