Error QVX_SYNTAX_ERROR

[3vecesleo]

please help! 

Se ha producido el siguiente error:

Connector reply error: QVX_SYNTAX_ERROR: Failed to process query: Failed to create dataset Dataset2: Invalid latitude or longitude value in CSV, [,]

El error se ha producido aquí:

[ClosestAssociations]: SQL SELECT [Predio_Dataset2_RelationId], [name], [Id], [Predio_Dataset2_Distance], [Predio_Dataset2_Route] FROM Closest(costUnit='Kilometers', distance='1', distanceType='car', closestCount='5', dataset1='Predio', dataset2='Otros') DATASOURCE Predio INLINE tableName='PredioTable', tableFields='name,lat,long', geometryType='POINTLATLON', loadDistinct='YES', suffix='', crs='Auto' {name lat long T111 19.432919 -99.191606} DATASOURCE Dataset2 INLINE tableName='Proyectos', tableFields='Id,Latitud,Longitud', geometryType='POINTLATLON', loadDistinct='NO', suffix='', crs='Auto' {Id Latitud Longitud 15638 19.43293 -99.19160 15707 19.43000 -99.19157 15639 19.43485 -99.19147

[Patric_Nordstrom]

Looks like there is something wrong with the coordinates.

Check by adding them to a point layer, then load parts of the csv file to narrow down the faulty coordinate. 

Thanks,

Patric

[Mehditamnilinc0ln]

Hello Patric,

I need your help please.
When I place my longitude and latitude data on a QGA map it works fine, but  I've the same issue with Closest, the error :  Error: Connector reply error: QVX_SYNTAX_ERROR: Failed to process query: Failed to create dataset COORDONNEES_PRESTA: Invalid latitude or longitude value in CSV, [,] is generated.

Best regards,

Mehdi

[Patric_Nordstrom]

Can you post a sample of your data?

Thanks,

Patric