3 Replies Latest reply on Oct 8, 2018 5:39 PM by Ken Flerlage

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

    Edwin Tam

      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've also attached my JSON file here.

       

       

      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