Community
Select to view content in your preferred language

Publishing Image Service from Viewer Connection to Enterprise Database

195
2
2 weeks ago
AlanDodson
by
Regular Contributor
2 weeks ago

I posted this in the Image Server community on Thursday but no replies yet; maybe this community is better suited to assisting on this topic?   Original post in Image Server community 

-----

I cannot publish an image service to my Enterprise Portal from a Viewer sde connection to my database. I can publish the same imagery from a Creator connection to the database. Is it just not possible to publish a mosaic dataset image service from a Viewer, or is there something wrong with my configuration? I'll provide as many details as I can below.

  • I am using ArcGIS Pro 3.2.2. (I also have ArcGIS Pro 2.9.5 for this test).
  • I have an enterprise geodatabase in an SQL Server (2016). 
  • From that geodatabase I have a Creator connection and a Viewer connection. These are created for me by our IT staff but have always worked as expected for publishing referenced vector layers. This is the first attempt for an image service.
  • I've created a Mosaic Dataset using the Creator connection and done all my processing there (overviews, boundary, etc). No issues while doing any of the work.
  • My source rasters are referenced and the UNC path is registered to the Image Server as a folder Data Store. The path is confirmed to be accessible by the server.
  • Both my Viewer and Creator sde connections are registered as Database Data Stores on the Image Server.
  • The Image Server is licensed.
  • I am an Administrator of my Enterprise Portal which is at version 11.2. I also have a 10.9.1 Portal that I've used in this test (with Administrator).
  • If I register the Viewer connection to the Hosting server I can publish vector features from the database without any issues

To publish an Image Service I follow the Esri workflow: right-click on the MD in the Catalog pane and select 'Share as web layer', then fill out all the stuff and select the Image Server. When I do this from the Creator connection to the database, I can publish the image service without any issues. This works from ArcGIS Pro 3.2.2 to Portal 11.2 and also from ArcGIS Pro 2.9.5 to Portal 10.9.1. However, when I try to do this from the Viewer connection to the database the software either blows up (ArcGIS Pro 2.9.5) or returns an unhelpful 'Error publishing' from ArcGIS Pro 3.2.2. 

I cannot figure out what the issue is. I have 2 Esri on-site contractors helping me and they cannot figure it out either. My guesses are:

1. It is not possible to do this from the Viewer connection. Some dodgy AI prompts have told me this because publishing a MD is complicated and requires some SQL SELECT commands on various tables in the database during the Analyze part of publishing that aren't available at the Viewer level, but of course the dodgy AI does not cite any authoritative sources so I don't believe it about the reason (yet).

2. There is a permission issue with the Viewer connection that I am unaware of. We have no problems publishing referenced Vector datasets from Viewer connections but perhaps those are more basic than Mosaic Datasets to the image server...

Does anyone have any advice on this? It would be very much appreciated. Happy to post more details if anyone has questions.

 

0 Kudos
2 Replies
ChrisUnderwood
by Esri Regular Contributor
Esri Regular Contributor
Thursday

Hello @AlanDodson ,  I'm assuming you have used Add Database Connection in ArcGIS Pro, and are maybe using Database Authentication in there. So can you expand on what you mean by a Viewer & Creator connection to your Geodatabase ?

0 Kudos
AlanDodson
by
Regular Contributor
Thursday

Sure. I think it's fairly well-explained above but maybe I've missed some details.

The MD sits in an enterprise geodatabase. To connect to this geodatabase I have 2 sde connections - the first is what we refer to as a Creator connection. It is the most permissive and lets us do all the operations we need to when creating and modifying a MD. It also lets us publish an image service from this MD, so it passes through the analyzer step and successfully publishes to the image server. The other sde connection is what we refer to as a Viewer connection. It has less permissions - in effect it is 'read-only' so that users cannot change the underlying data. As I said, this is a strategy we are re-using from our Vector service conditioning and publishing. It is less permissive than the Creator, and fails to publish. It may be failing in the analyzer stage (which is our suspicion) or it may fail further on in the publishing. Our leading suspicion is that during the analyzer stage the software tries to use some SELECT functions to ensure the tables inside the database are good to go, but the SELECT functions are not inherently allowed. We don't get descriptive error messages to help us diagnose what is going on.

 

We are now trying to change some permissions in the Viewer connection to see if that changes anything.

Does this give a better impression about the connections I refer to?

0 Kudos