nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Error on creating query layer

ClaudiaBlagu2

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

2021-01-22_14h04_28.png

Find more posts tagged with

Content Management

Geodatabase

Desktop

Accepted answers

Robert LeClair

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.

All comments

Robert LeClair

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.

ClaudiaBlagu2

@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.

ClaudiaBlagu2

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.

Robert LeClair

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?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.