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

QVX_SYNTAX_ERROR: Failed to process query: Failed to create dataset

Hello,

I'm testing the GeoAnalytics connector, I choose TRAVELAREAS function to identify the vendors overlapping areas. Always get this error message:


QVX_SYNTAX_ERROR: Failed to process query: Failed to create dataset AreaCliente: Malformed POINT geometry: -19.3101506.

[TravelAreas]:

SQL SELECT * FROM TravelAreas(dataset='AreaCliente',costValue='2',costField='',costUnit='Hours',transportation='car')

DATASOURCE AreaCliente INLINE tableName='Clientes',tableFields='CHAVE_CLIENTE,LATITUDE,LOGITUDE',geometryType='POINT',loadDistinct='YES',suffix='',crs='Auto' {CHAVE_CLIENTE LATITUDE LOGITUDE

0102205201 -19.3101506 -48.9277299

(...)

0103820901 -19.3101506 -48.9277299}

I check the post QVX_SYNTAX_ERROR Failed to process query Failed to create dataset  but its didn´t work for me.

Follow my connection parameters:

Screenshot_9.jpg

Where is the error? Can I fix this?

Tks,

Pedro

1 Solution

Accepted Solutions
Patric_Nordstrom
Employee
Employee

Hi Pedro,

Choose "Latitude, longitude point" instead of Point.

The geometry type "Latitude, longitude point" is when there are two separate fields for latitude and longitude.

Point is a point string in one field: '[lat, long]'


Thanks,

Patric

View solution in original post

3 Replies
Patric_Nordstrom
Employee
Employee

Hi Pedro,

Choose "Latitude, longitude point" instead of Point.

The geometry type "Latitude, longitude point" is when there are two separate fields for latitude and longitude.

Point is a point string in one field: '[lat, long]'


Thanks,

Patric

pedrobergo
Employee
Employee
Author

Ok, It´s working now !

Tks a lot !

Pedro

Glaci
Contributor II
Contributor II

Hi Pedro almost the same problem hapened with me, but in my table have 2 field for Latitude, longitude, i had choose the option "Latitude, longitude point" and doesnt working 

Glaci_0-1647960252406.png

for each city hapened this error:
Ocorreram os seguintes erros:
Connector reply error: QVX_SYNTAX_ERROR: Failed to process query: Failed to create dataset POINTS: Invalid latitude or longitude value in CSV, [,]
 
O erro ocorreu aqui:
[ClusterAssociations]: SQL SELECT [CH_UF_MUNICIPIO], [Clusters_ClusterID] FROM Cluster(distance='100000', dataset='POINTS') DATASOURCE POINTS INLINE tableName='ESTRUTURA', tableFields='CH_UF_MUNICIPIO,LATITUDE,LONGITUDE', geometryType='POINTLATLON', loadDistinct='NO', suffix='', crs='Auto' {CH_UF_MUNICIPIO LATITUDE LONGITUDE ROCACOAL -11,433865028685 -61,442944211822