Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
3vecesleo
Contributor
Contributor

Error QVX_SYNTAX_ERROR

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
Labels (1)
3 Replies
Patric_Nordstrom
Employee
Employee

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
Partner - Contributor
Partner - Contributor

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
Employee
Employee

Can you post a sample of your data?

Thanks,

Patric