Query execution issues - 6.3

Troubleshooting for MDM SQL Storage

EnrichVersion
6.3
task
Installation and Upgrade
EnrichPlatform
Talend MDM Server

For query execution issues, MDM dumps the parsed query structure (joins, where conditions). For example:

[SELECT]
        Types
                Person
        Selected fields
                [FIELD]
                        Person/firstname
                [FIELD]
                        Address/Street
                [FIELD]
                        Country/name
        Join
                [JOIN]
                        [LEFT]
                                [FIELD]
                                        addresses/address
 
                        [RIGHT]
                                [FIELD]
                                        Address/Id
                                        Address/enterprise
                [JOIN]
                        [LEFT]
                                [FIELD]
                                        Address/country
                        [RIGHT]
                                [FIELD]
                                        Country/id
        Condition
                <NONE>
        Order by
                <NONE>

Common causes of exceptions (full text queries):

  • Full text search includes conditions other than full text: this is a known limitation due to the technology used for full text searches. Operators supported with a full text search are: greater than (>), greater than or equals (>=), less than (<), less than or equals (<=).

Common causes of exceptions (all other queries):

  • Join is performed on a field that cannot be reached from the main selected type.
  • A IsEmptyOrNull is performed on a repeatable element.