2 Replies Latest reply: Nov 20, 2017 2:04 PM by Pedro Bergo RSS

    QVX_SYNTAX_ERROR: Failed to process query: Failed to create dataset

    Pedro Bergo

      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