topic Re: Mosaicking Rasters Error (A column was specified that does not exist) in Geoprocessing Questions

Mosaicking Rasters Error (A column was specified that does not exist)

MeredithGreen — Thu, 15 May 2014 21:06:49 GMT

I am trying to mosaic two rasters. I have run several mosaics today all with the same exact settings and no issue, but with my two larger raster datasets the mosaic tool just keeps looping at building pyramids over and over again and doesn't progress any further. When I cancel it I get several "A column was specified that does not exist" error messages as well as the error message "All geometries involved in this operation must have the same spatial reference." All the other raster mosaics I have run have the exact same settings so the only thing I could think of was maybe the file size is too big. So I moved the rasters to the C drive on my computer and tried again, same problem. Anyone have a possible solution to this?

Any help would be greatly appreciated.

Re: Mosaicking Rasters Error (A column was specified that does not exist)

DuncanHornby — Thu, 15 May 2014 21:24:46 GMT

I think you need to give more information about these rasters, what are their:

Size

Type

Projection

cell size

are they overlapping

Re: Mosaicking Rasters Error (A column was specified that does not exist)

MeredithGreen — Thu, 15 May 2014 21:46:52 GMT

I think you need to give more information about these rasters, what are their:

Size

Type

Projection

cell size

are they overlapping

Size:
Input- 136.11MB
Target- 2.06GB
Type:
Input- GRID
Target- FGDBR
Projection:
Input- StatePlane_Georgia_West_FIPS_1002_Feet Foot_US
Target- UTM_Zone_16N Foot_US
Cell Size:
Input- 10,10
Target- 10,10
Overlapping: Yes

I'd like to also add that I tried reprojecting the Input raster first to match the target but got the same errors and looping problem. I've also mosaicked other FGDBR in the same GDB with other GRIDS following the same characteristics and had no issues at all. This is why I am leaning towards the file size given the the rasters I'm having these problems with are the largest of the bunch. However, moving them to the C drive didn't work either so I'm kind of at a loss.

Re: Mosaicking Rasters Error (A column was specified that does not exist)

MeredithGreen — Fri, 16 May 2014 11:33:39 GMT

Size:
Input- 136.11MB
Target- 2.06GB
Type:
Input- GRID
Target- FGDBR
Projection:
Input- StatePlane_Georgia_West_FIPS_1002_Feet Foot_US
Target- UTM_Zone_16N Foot_US
Cell Size:
Input- 10,10
Target- 10,10
Overlapping: Yes

I'd like to also add that I tried reprojecting the Input raster first to match the target but got the same errors and looping problem. I've also mosaicked other FGDBR in the same GDB with other GRIDS following the same characteristics and had no issues at all. This is why I am leaning towards the file size given the the rasters I'm having these problems with are the largest of the bunch. However, moving them to the C drive didn't work either so I'm kind of at a loss.

So I came back to this problem this morning and tried one more thing. Initially I tried changing the Type of the input raster to the same as the target raster and it didn't work. Then I reversed it and converted the target raster to a GRID instead. It worked!