FieldPath must not end with a '.'. ??? MongoDB Connector

1,995 views
Skip to first unread message

Edwin Tam

unread,
Sep 17, 2018, 9:06:01 PM9/17/18
to mongodb-user

Hi folks,

 

I'm trying to connect to MongoDB with Tableau. 

However I'm getting an error. Could anyone help advise what it means?

I don't think it's a Tableau issue -- it's worked before. 


I've also attached the error message & JSON file (link: https://drive.google.com/file/d/1iioM8NpXddTkFDvoAr_IL1LEIG4-haJ_/view?usp=sharing **) here.

Thanks very much!  


** Groups isn't allowing me to attach the file. It's too large (>19MB), hence the link. 

 

ERROR MESSAGE

An error occurred while communicating with the MongoDB BI Connector data source 'phone_specs_phones (caKE5)'.

 

Bad Connection: Tableau could not connect to the data source.

[MySQL][ODBC 8.0(w) Driver][mysqld-5.7.12 mongosqld v2.6.0-beta3]failed to execute aggregate: (Location40353) FieldPath must not end with a '.'.

SELECT 1 AS `Number of Records`,

  `phone_specs_phones`.`_id` AS `_id`,

  `phone_specs_phones`.`phones.name` AS `phones.name`,

  `phone_specs_phones`.`phones.phone_url` AS `phones.phone_url`,

  `phone_specs_phones`.`phones.spec.battery.Music play` AS `phones.spec.battery.Music play`,

  `phone_specs_phones`.`phones.spec.battery.Stand-by` AS `phones.spec.battery.Stand-by`,

  `phone_specs_phones`.`phones.spec.battery.Talk time` AS `phones.spec.battery.Talk time`,

  `phone_specs_phones`.`phones.spec.body.Build` AS `phones.spec.body.Build`,

  `phone_specs_phones`.`phones.spec.body.Dimensions` AS `phones.spec.body.Dimensions`,

  `phone_specs_phones`.`phones.spec.body.Keyboard` AS `phones.spec.body.Keyboard`,

  `phone_specs_phones`.`phones.spec.body.SIM` AS `phones.spec.body.SIM`,

  `phone_specs_phones`.`phones.spec.body.Weight` AS `phones.spec.body.Weight`,

  `phone_specs_phones`.`phones.spec.comms.Bluetooth` AS `phones.spec.comms.Bluetooth`,

  `phone_specs_phones`.`phones.spec.comms.GPS` AS `phones.spec.comms.GPS`,

  `phone_specs_phones`.`phones.spec.comms.Infrared port` AS `phones.spec.comms.Infrared port`,

  `phone_specs_phones`.`phones.spec.comms.NFC` AS `phones.spec.comms.NFC`,

  `phone_specs_phones`.`phones.spec.comms.Radio` AS `phones.spec.comms.Radio`,

  `phone_specs_phones`.`phones.spec.comms.USB` AS `phones.spec.comms.USB`,

  `phone_specs_phones`.`phones.spec.comms.WLAN` AS `phones.spec.comms.WLAN`,

  `phone_specs_phones`.`phones.spec.display.Multitouch` AS `phones.spec.display.Multitouch`,

  `phone_specs_phones`.`phones.spec.display.Protection` AS `phones.spec.display.Protection`,

  `phone_specs_phones`.`phones.spec.display.Resolution` AS `phones.spec.display.Resolution`,

  `phone_specs_phones`.`phones.spec.display.Size` AS `phones.spec.display.Size`,

  `phone_specs_phones`.`phones.spec.display.Type` AS `phones.spec.display.Type`,

  `phone_specs_phones`.`phones.spec.features.Alarm` AS `phones.spec.features.Alarm`,

  `phone_specs_phones`.`phones.spec.features.Browser` AS `phones.spec.features.Browser`,

  `phone_specs_phones`.`phones.spec.features.Clock` AS `phones.spec.features.Clock`,

  `phone_specs_phones`.`phones.spec.features.Games` AS `phones.spec.features.Games`,

  `phone_specs_phones`.`phones.spec.features.Java` AS `phones.spec.features.Java`,

  `phone_specs_phones`.`phones.spec.features.Languages` AS `phones.spec.features.Languages`,

  `phone_specs_phones`.`phones.spec.features.Messaging` AS `phones.spec.features.Messaging`,

  `phone_specs_phones`.`phones.spec.features.Sensors` AS `phones.spec.features.Sensors`,

  `phone_specs_phones`.`phones.spec.launch.Announced` AS `phones.spec.launch.Announced`,

  `phone_specs_phones`.`phones.spec.launch.Status` AS `phones.spec.launch.Status`,

  `phone_specs_phones`.`phones.spec.main camera.Dual` AS `phones.spec.main camera.Dual`,

  `phone_specs_phones`.`phones.spec.main camera.Features` AS `phones.spec.main camera.Features`,

  `phone_specs_phones`.`phones.spec.main camera.Single` AS `phones.spec.main camera.Single`,

  `phone_specs_phones`.`phones.spec.main camera.Triple` AS `phones.spec.main camera.Triple`,

  `phone_specs_phones`.`phones.spec.main camera.Video` AS `phones.spec.main camera.Video`,

  `phone_specs_phones`.`phones.spec.main camera.` AS `phones.spec.main camera.`,

  `phone_specs_phones`.`phones.spec.memory.Call records` AS `phones.spec.memory.Call records`,

  `phone_specs_phones`.`phones.spec.memory.Card slot` AS `phones.spec.memory.Card slot`,

  `phone_specs_phones`.`phones.spec.memory.Internal` AS `phones.spec.memory.Internal`,

  `phone_specs_phones`.`phones.spec.memory.Phonebook` AS `phones.spec.memory.Phonebook`,

  `phone_specs_phones`.`phones.spec.misc.Colors` AS `phones.spec.misc.Colors`,

  `phone_specs_phones`.`phones.spec.misc.Price` AS `phones.spec.misc.Price`,

  `phone_specs_phones`.`phones.spec.misc.SAR EU` AS `phones.spec.misc.SAR EU`,

  `phone_specs_phones`.`phones.spec.misc.SAR` AS `phones.spec.misc.SAR`,

  `phone_specs_phones`.`phones.spec.name` AS `phones.spec.name`,

  `phone_specs_phones`.`phones.spec.network` AS `phones.spec.network`,

  `phone_specs_phones`.`phones.spec.platform.CPU` AS `phones.spec.platform.CPU`,

  `phone_specs_phones`.`phones.spec.platform.Chipset` AS `phones.spec.platform.Chipset`,

  `phone_specs_phones`.`phones.spec.platform.GPU` AS `phones.spec.platform.GPU`,

  `phone_specs_phones`.`phones.spec.platform.OS` AS `phones.spec.platform.OS`,

  `phone_specs_phones`.`phones.spec.selfie camera.Dual` AS `phones.spec.selfie camera.Dual`,

  `phone_specs_phones`.`phones.spec.selfie camera.Features` AS `phones.spec.selfie camera.Features`,

  `phone_specs_phones`.`phones.spec.selfie camera.Single` AS `phones.spec.selfie camera.Single`,

  `phone_specs_phones`.`phones.spec.selfie camera.Triple` AS `phones.spec.selfie camera.Triple`,

  `phone_specs_phones`.`phones.spec.selfie camera.Video` AS `phones.spec.selfie camera.Video`,

  `phone_specs_phones`.`phones.spec.selfie camera.` AS `phones.spec.selfie camera.`,

  `phone_specs_phones`.`phones.spec.sound.3_5mm jack` AS `phones.spec.sound.3_5mm jack`,

  `phone_specs_phones`.`phones.spec.sound.Alert types` AS `phones.spec.sound.Alert types`,

  `phone_specs_phones`.`phones.spec.sound.Loudspeaker` AS `phones.spec.sound.Loudspeaker`,

  `phone_specs_phones`.`phones_idx` AS `phones_idx`

FROM `phone_specs_phones`

LIMIT 1000

Wan Bachtiar

unread,
Sep 20, 2018, 12:36:58 AM9/20/18
to mongodb-user

[MySQL][ODBC 8.0(w) Driver][mysqld-5.7.12 mongosqld v2.6.0-beta3]failed to execute aggregate: (Location40353) FieldPath must not end with a ‘.’.

Hi Edwin,

As the message suggests, based on the example query you have specified a field to select that ends with a . (dot). The offending field is: 

  `phone_specs_phones`.`phones.spec.main camera.` AS `phones.spec.main camera.`,

I would also recommend to replace the space in the field name with an underscore or just combined the two words together. i.e. mainCamera.

Regards,
Wan.

​

Edwin Tam

unread,
Sep 20, 2018, 12:39:17 AM9/20/18
to mongod...@googlegroups.com
Thanks Wan. 
I'll have a go at it. 

--
You received this message because you are subscribed to the Google Groups "mongodb-user"
group.
 
For other MongoDB technical support options, see: https://docs.mongodb.com/manual/support/
---
You received this message because you are subscribed to the Google Groups "mongodb-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mongodb-user...@googlegroups.com.
To post to this group, send email to mongod...@googlegroups.com.
Visit this group at https://groups.google.com/group/mongodb-user.
To view this discussion on the web visit https://groups.google.com/d/msgid/mongodb-user/63bf63e8-fbef-4a5b-ae7d-6b01d4b071f2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Reply all
Reply to author
Forward
0 new messages