Question

Mosaic raster files loading into an ArcSDE Geodatabase Failed

  • 17 June 2021
  • 1 reply
  • 7 views

Badge

hello everyone,

 

I'am trying to load a mosaic raster into aan ArcSDE Geodatabase. I made a simple workspace (build 20825) white a GEODATABASE_FILE_RASTER_DATASET reader and GEODATABASE_SDE_RASTER_DATASET writer. 

 

workspace 

These are my settings of the writer:

Writer_settingsWhen I publish this workspace to FME server (same build 20825) and run I get the following error:

 

  

73	2021-6-11 07:57:48 | A default z-value of '0' will be used for all 3D features where z-values are not provided
74 2021-6-11 07:57:48 | Geodatabase Writer: Not simplifying geometries being written to the Geodatabase
75 2021-6-11 07:57:48 | Transactions are being used by the Geodatabase Writer
76 2021-6-11 07:57:51 | Failed to write raster data tile when writing to raster dataset 'GEO_OWNER.AHN3_TEST_FEMSERACC'. The error number from ArcObjects is: '-2147155566'
77 2021-6-11 07:57:51 | Storing feature(s) to FME feature store file `D:\Applic\Safe Software\FME Server\resources\logs\engine\current\jobs\0\job_172_log.ffs'
78 2021-6-11 07:57:51 | +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
79 2021-6-11 07:57:51 | Feature Type: `GEO_OWNER.AHN3_TEST_FEMSERACC'
80 2021-6-11 07:57:51 | Attribute(string)        : `fme_basename' has value `DSM5M_desktest'
81 2021-6-11 07:57:51 | Attribute(string)        : `fme_feature_type' has value `DSM5M_desktest'
82 2021-6-11 07:57:51 | Attribute(string)        : `fme_geometry' has value `fme_undefined'
83 2021-6-11 07:57:51 | Attribute(string)        : `fme_type' has value `fme_no_geom'
84 2021-6-11 07:57:51 | Attribute(32 bit integer): `geodb_raster_compression_quality' has value `75'
85 2021-6-11 07:57:51 | Attribute(string)        : `geodb_raster_compression_type' has value `geodb_raster_compression_type_LZ77'
86 2021-6-11 07:57:51 | Attribute(32 bit integer): `geodb_raster_pyramid_level' has value `-1'
87 2021-6-11 07:57:51 | Attribute(string)        : `geodb_raster_pyramid_resample_type' has value `geodb_raster_pyramid_resample_type_nearest'
88 2021-6-11 07:57:51 | Attribute(32 bit integer): `multi_reader_full_id' has value `0'
89 2021-6-11 07:57:51 | Attribute(32 bit integer): `multi_reader_id' has value `0'
90 2021-6-11 07:57:51 | Attribute(string)        : `multi_reader_keyword' has value `GEODATABASE_FILE_RASTER_DATASET_2'
91 2021-6-11 07:57:51 | Attribute(string)        : `multi_reader_type' has value `GEODATABASE_FILE_RASTER_DATASET'
92 2021-6-11 07:57:51 | Attribute(string)        : `multi_writer_id' has value `0'
93 2021-6-11 07:57:51 | Coordinate System: `_Netherlands-RDNew-2008_0'
94 2021-6-11 07:57:51 | Geometry Type: IFMENull
95 2021-6-11 07:57:51 | ===========================================================================
96 2021-6-11 07:57:51 | GEODATABASE_SDE_RASTER_DATASET writer: A fatal error has occurred. Check the logfile above for details
97 2021-6-11 07:57:51 | GEODATABASE_SDE_RASTER_DATASET writer: A fatal error has occurred. Check the logfile above for details
98 2021-6-11 07:57:51 | GeodatabaseRelationshipFeaturesPipeline::GeodatabaseRelationshipFeatures (SortFactory): Finished sorting a total of 0 features.
99 2021-6-11 07:57:51 | Transaction #1 rolled back. Rerun translation specifying transaction #0 for the keyword 'TRANSACTION'
100 2021-6-11 07:57:51 | Closing the Geodatabase writer

If I search for the error number from ArcObjects "-21471555566" I get the following result:

https://resources.arcgis.com/en/help/arcobjects-java/api/arcobjects/constant-values.html

public static final int SDE_E_SE_INVALID_IMAGE_ORIGIN "-2147155566"

 

As a test I tried to read a raster from the ArcSDE (reading a raster from that ArcSDE is no problem)  and write it as a copy back to the same ArcSDE and it gives the same error.

The strange thing is when I write the same input raster (frome the FileGeodatabase) to the same ArcSDE geodatabase with a ArcPy script there is no problem. 

 

Do I miss a setting or is this a bug in the FME ArcSDE raster writer?

 

I hope someone can help me with this, thanks!

 

best regards, Danny


1 reply

Badge

I have the same kind of problem when writing to ArcSDE Raster Dataset. To me it appears that the issue is with the size of the raster and inability for FME to create raster tiling as ArcGIS tooling can do.

I get the same error: Failed to write raster data tile when writing to raster dataset 'x'. The error number from ArcObjects is: '-2147155566'.

Input is GeoTIFF.

  • Write the raster to ArcGIS File Geodatabase (FGDB) is OK
  • Write smaller extent to ArcSDE is OK (e.g. clip smaller piece of complete raster)
  • Write to ArcGIS FGDB and copy raster from FGDB to ArcSDE is NOK
  • Write to ArcSDE is NOK
  • Load raster (GeoTIFF) into ArcSDE using ArcGIS tooling is OK

Something wrong in the FME Writer?

Reply