Issue : The issue is raster data is not getting loaded in mosaic dataset on Oracle SDE. As a workaround, successfully loaded the data in FGDB first, and then copied the data from FGDB to Oracle SDE which is in couple of minutes. So is it best practise to load the data in two steps? If not what is the root cause for this issue?
The details of this issue are as given below. Please let me know if any resolution.
Environment :
The environment details are given below:-
- ArcGIS Desktop : 10.4.1
- Oracle : 12c
- Geometry used for storing boundary, footprint of Mosaic Dataset - SDO_GEOMETRY
- Spatial reference is “British National Grid”
Python Script :
arcpy.AddRastersToMosaicDataset_management(in_mosaic_dataset="D:\SDE_Conn\MGR\SDE.sde\SCHEMA.RASTER", raster_type="Raster Dataset", input_path="'\\[IP]\[Folder]\Raster Data\Color\FinalList'", update_cellsize_ranges="UPDATE_CELL_SIZES", update_boundary="UPDATE_BOUNDARY", update_overviews="NO_OVERVIEWS", maximum_pyramid_levels="", maximum_cell_size="0", minimum_dimension="1500", spatial_reference="", filter="#", sub_folder="SUBFOLDERS", duplicate_items_action="OVERWRITE_DUPLICATES", build_pyramids="BUILD_PYRAMIDS", calculate_statistics="CALCULATE_STATISTICS", build_thumbnails="NO_THUMBNAILS", operation_description="#", force_spatial_reference="NO_FORCE_SPATIAL_REFERENCE", estimate_statistics="ESTIMATE_STATISTICS", aux_inputs="")
GPMessage output :
Messages
Executing: AddRastersToMosaicDataset D:\SDE_Conn\MGR\SDE.sde\SCHEMA.RASTER "Raster Dataset" '\\[IP]\[Folder]\OS Raster Data\Color\FinalList'
UPDATE_CELL_SIZES UPDATE_BOUNDARY NO_OVERVIEWS # 0 1500 # # SUBFOLDERS OVERWRITE_DUPLICATES BUILD_PYRAMIDS CALCULATE_STATISTICS NO_THUMBNAILS #
NO_FORCE_SPATIAL_REFERENCE ESTIMATE_STATISTICS #
Start Time: Mon Jan 09 07:28:55 2017
2017-01-09T07:29:02.050: Loading raster datasets
2017-01-09T07:29:09.253: Completed crawling 350 data source items. Added 350 mosaic dataset items.
2017-01-09T07:29:09.347: Synchronizing items associated with raster type instance 'Raster Dataset' [ID: 1].
2017-01-09T07:29:09.378: Distributing mosaic dataset operation across 2 parallel instances on the specified host: [HOSTNAME].
2017-01-09T07:29:17.347: Error: 8004205a: Unable to load remotely built mosaic dataset items.
2017-01-09T07:29:17.347: Error: 8004205c: Raster command failed or returned an invalid result. [ID: 0; Status: 80070057]
2017-01-09T07:29:17.363: Error: 8004205a: Unable to load remotely built mosaic dataset items.
2017-01-09T07:29:17.378: Error: 8004205c: Raster command failed or returned an invalid result. [ID: 1; Status: 80070057]
2017-01-09T07:29:21.425: Error: 8004205a: Unable to load remotely built mosaic dataset items.
2017-01-09T07:29:21.472: Error: 8004205c: Raster command failed or returned an invalid result. [ID: 2; Status: 80070057]
2017-01-09T07:29:25.379: Error: 8004205a: Unable to load remotely built mosaic dataset items.
2017-01-09T07:29:25.379: Error: 8004205c: Raster command failed or returned an invalid result. [ID: 3; Status: 80070057]
2017-01-09T07:29:25.394: Error: 8004205a: Unable to load remotely built mosaic dataset items.
2017-01-09T07:29:25.394: Error: 8004205c: Raster command failed or returned an invalid result. [ID: 4; Status: 80070057]
2017-01-09T07:29:31.176: Error: 8004205a: Unable to load remotely built mosaic dataset items.
2017-01-09T07:29:31.176: Error: 8004205c: Raster command failed or returned an invalid result. [ID: 5; Status: 80070057]
