topic Error on creating query layer in ArcGIS Pro Questions

Error on creating query layer

ClaudiaBlagu2 — Fri, 22 Jan 2021 15:25:00 GMT

Hi all,

I am struggling with a issue related to one geodatabase that I am using for publishing some services on the Portal. I have a Azure SQL server instance with collation set up on Latin, and under that I have 3 databases, 2 of which are having same collation as the server, and another one with collation set to Lithuanian.

If I try to create a query layer in ArcGIS Pro from the SQL database with collation on Lithuanian I get the message that there is an error and the conflict between Latin and Lithuanian cannot be solved.

Can anyone support on how to solve this?

Much appreciate any help.

Claudia

Re: Error on creating query layer

Robert_LeClair — Sat, 23 Jan 2021 23:43:36 GMT

Claudia - this seems related to BUG-000129828 - Enabling a Microsoft Azure SQL Database with Hebrew_CI_AS collation as an enterprise geodatabase in ArcGIS Pro and ArcMap fails with ERROR: Cannot resolve the collation conflict between "Hebrew_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. It does show it being fixed at ArcGIS 10.8.1 though. What release of ArcGIS Pro and ArcMap are you using?

Re: Error on creating query layer

ClaudiaBlagu2 — Mon, 25 Jan 2021 09:06:40 GMT

Hi Robert,

Currently I am using ArcMap 10.7.1 and ArcGIS Pro 2.6. I will try to update and see if I receive same error. Thanks for pointing the bug.

Re: Error on creating query layer

ClaudiaBlagu2 — Tue, 26 Jan 2021 12:30:49 GMT

@Robert_LeClair I updated the version, but the error still persists. I updated the ArcGIS Pro version though, as this is the one that is being used by our staff. Should we switch to ArcMap for the query layers?

Many thanks.

Re: Error on creating query layer

Robert_LeClair — Wed, 27 Jan 2021 15:23:36 GMT

Claudia - hmmm...that's not good. I would recommend reaching out to Esri Support Services to see if this is a new BUG or something else is going on.