topic Re: cannot add to existing mosaic dataset in ArcGIS Image Server Questions

cannot add to existing mosaic dataset

PeterHoffman — Wed, 10 Apr 2013 16:11:57 GMT

I get the following errors:
cannot create an insert cursor using the mosaic dataset
cannot acquire a lock.
This used to work.

Re: cannot add to existing mosaic dataset

RobertRiley — Fri, 03 May 2013 12:52:47 GMT

Receiving the same error trying to Define Overviews in a mosaic dataset.
The function worked fine with the first two mosaic datasets in the same file geoDB.
Third time (and fourth, fifth, and sixth) a charm.

<Errors>
<Error>ERROR 999999: Error executing function.</Error>
<Error>Cannot create an insert cursor using the mosaic dataset.</Error>
<Error>Cannot acquire a lock.</Error>
<Error>Cannot acquire a lock.</Error>
<Error>Failed to execute (DefineOverviews).</Error>
</Errors>

ArcCatalog 10.1 (Build 3143)

Re: cannot add to existing mosaic dataset

PeterHoffman — Fri, 03 May 2013 12:56:20 GMT

Working with ESRI we found that turning off background processing and using the foreground method it worked fine. There is a 64 bit geoprocessing sp1 available but I have not installed it yet.

Re: cannot add to existing mosaic dataset

RobertRiley — Fri, 03 May 2013 18:22:37 GMT

Roger that. Enlisted ESRI help as well.

Even with x64 geoprocessing SP1, had to disable background processing in order to process this particular raster dataset.

Thanks.

BIM

Re: cannot add to existing mosaic dataset

PeterHoffman — Mon, 06 May 2013 13:38:00 GMT

OK, good to know, back to drawing board, thanks,

Re: cannot add to existing mosaic dataset

JacksonTrappett — Tue, 03 Jun 2014 16:06:44 GMT

Working with ESRI we found that turning off background processing and using the foreground method it worked fine. There is a 64 bit geoprocessing sp1 available but I have not installed it yet.

This worked for me too - thanks!

Re: cannot add to existing mosaic dataset

RobertCarlos — Thu, 01 Oct 2015 16:43:43 GMT

Yes. Worked.

Turned off background processing and using the foreground method.

In ArcCatalog go to Geoprocessing at the top and select Geoprocessing Options.

In Geoprocessing Options Offcheck the Checkbox labeled "Enable" within the Background Geoprocessing section. (This is in the upper middle section of the GUI Window.)

Re: cannot add to existing mosaic dataset

CarlyRobbins — Fri, 03 Aug 2018 14:30:41 GMT

Still a working solution in 2018! Thank you.

Re: cannot add to existing mosaic dataset

Anonymous User — Mon, 20 Aug 2018 22:29:29 GMT

this bug is still here 3 years later..sigh. Confirmed though, still works! Thanks Peter.

Re: cannot add to existing mosaic dataset

JingLi4 — Wed, 22 Aug 2018 21:50:25 GMT

I apologize for the inconvenience caused by this issue. I believe this issue has been addressed in ArcGIS 10.6 and later version. Which version are you using when encountering this issue?

If you are using 10.6 or later version and still see this behavior, I would appreciate it if you could detail the steps used so that I can follow it to reproduce the issue in house.

Thanks

Re: cannot add to existing mosaic dataset

Anonymous User — Thu, 23 Aug 2018 16:57:43 GMT

Hi Jing, it was 10.6.1, Win 10, all the latest, for a mosaic in a geodatabase. I couldn't test stopping the service, because it was the main production aerial imagery service. (which would not be acceptable as a workflow) This solution of foreground processing, it worked on the first try. That would lead me to think a resolution could be, that the alternative algorithm (the foreground one), that however it 'works' under the hood, just become the default 'programming logic' under the hood, for the Add Raster tool.

Re: cannot add to existing mosaic dataset

JingLi4 — Thu, 23 Aug 2018 17:44:44 GMT

Hi Kevin. The testing I did with ArcGIS 10.6.x is to add rasters to a mosaic dataset stored in a file geodatabase with 64 bit background geoprocessing enabled. The mosaic dataset is not source of any imagery services.

To make sure we are on the same page, can you confirm the following items?

1. You want to add rasters to the mosaic dataset which is served as the source of the imagery service without stopping the service.

2. If I understand correctly, the foreground processing works for you in this scenario.

Thank you.

Re: cannot add to existing mosaic dataset

Anonymous User — Thu, 23 Aug 2018 18:36:34 GMT

precisely. It said I could not add it. I can't remember the error but something like it was locked or in use. Then, I used the workaround with foreground processing, then it worked.

Also, it built overviews and pyramids fine so the regular imageryservice is working but the tiled service will not tile. I'm still working on it... I have stopped and started several times, rebuilt cache status, restarted caching GP tool on Server (the server is 10.51 though the client I used to add raster was 10.6.1) etc. Tiling always seems to be... interesting. I am finally very comfortable to know what exact setting to get very good quality (bilinear jpg ybcr at 85 in a file gdb, NOT in SDE, etc) but it seems to require careful shepherding. Start it, step back... do not touch lol... come back, it failed.. retry with something slightly different...rinse repeat... all my sys admins and raster people here know what I'm talking about! it's ok I will get it squared eventually. Steady she goes.. The reason is that... we got one tile (just one!) to add to an existing imagery dataset.

Re: cannot add to existing mosaic dataset

JingLi4 — Thu, 30 Aug 2018 16:41:35 GMT

Hi Kevin. Thank you for describing the issue. I think the issue you encountered might have a different workflow than the initial post.

In your scenario, I would recommend you contact Esri Support Services to further investigate. Here is the link to contact Support.

https://support.esri.com/en/contact-tech-support

Regards.