Query execution issues - 7.2

Troubleshooting for MDM SQL Storage

EnrichVersion
7.2
EnrichProdName
Talend Data Fabric
Talend MDM Platform
Talend Open Studio for MDM
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.