topic Re: Query layer has a complex query in ArcGIS Desktop Deutschland Questions

Query layer has a complex query

CelineKayitana — Fri, 01 Jun 2018 11:58:50 GMT

Hello,

I am trying to publish a query layer from ArcMap, however I keep getting en arror stating the Query has complex query.

I have an Inner Join and Where clause in my Query layer. I am using time slider in my Query layer file.
The database is Oracle 12 c.

Note: I have been running the same king of QL in SQL Server and it works perfectly for different datasets.

May you kindly advise me on what to do?

Below is a screenshot of the error

Regards,
Celine

Re: Query layer has a complex query

MichaelVolz — Fri, 01 Jun 2018 13:30:05 GMT

Maybe try removing features one at a time to see where the issue lies - time slider first, then where clause and then inner join.

Re: Query layer has a complex query

CelineKayitana — Fri, 01 Jun 2018 13:40:26 GMT

Thanks Michael,

It's true Query layer does require simple queries without clauses like Inner Join. But when used with time slider ( for SQL Server case),it consider it as simple query than a complex one.

And I cannot get rid of the Inner join and time slider since I want to create a dynamic map with data values that change with time. I join a shapefile with a standalone table.

Re: Query layer has a complex query

MichaelVolz — Fri, 01 Jun 2018 13:53:32 GMT

I am just suggesting that you find which component of your query layer is throwing the error and then maybe you can start an incident with ESRI to see if they currently support your query layer architecture.

Re: Query layer has a complex query

CelineKayitana — Fri, 01 Jun 2018 14:01:49 GMT

Alright I get you, I did and it is the Inner join that causes that error.

How do we normally escalate to Esri ?

Thanks,

Celine

Re: Query layer has a complex query

MichaelVolz — Fri, 01 Jun 2018 14:10:09 GMT

What version of ArcMap are you using?

Can you export the shapefile to a file geodatabase and try to create the query layer from there?

ESRI support is 1-888-377-4575 and you would need to be on maintenance and provide your Customer ID. Not sure if this number is for outside the United States.