topic Re: Raster dataset into SQL Server 2017 Enterprise Geodatabase in ArcMap Questions

Raster dataset into SQL Server 2017 Enterprise Geodatabase

Pieterdu_Plooy2 — Fri, 25 Jan 2019 10:45:37 GMT

Hi guys

I am trying to import a raster dataset into an SQL Server 2017 enterprise geodatabase. (Arc 10.6.1)

I am getting errors as can be seen in the attached file.

Any help would be appreciated

Re: Raster dataset into SQL Server 2017 Enterprise Geodatabase

Asrujit_SenGupta — Fri, 25 Jan 2019 10:57:01 GMT

Check if this patch helps, if you are using 10.6.1:

ArcGIS (Desktop, Server) 10.6.1 Raster Patch

Re: Raster dataset into SQL Server 2017 Enterprise Geodatabase

Pieterdu_Plooy2 — Fri, 25 Jan 2019 12:35:18 GMT

Hi Asrujit SenGupta

This does not work. I have installed this patch twice, but still no go

Re: Raster dataset into SQL Server 2017 Enterprise Geodatabase

Pieterdu_Plooy2 — Sat, 26 Jan 2019 08:02:35 GMT

Hi guys

I need to bump this, this is urgent that I get a satisfactory response. (Sorry)

Re: Raster dataset into SQL Server 2017 Enterprise Geodatabase

LanceCole — Sat, 26 Jan 2019 20:46:27 GMT

A few comments/questions:

The few items in the results that stand out are
- the source in the Executing statement is a TIF
- the destination in the Executing statement is pointing to only to the sde connection string
- the "No raster store is configurated" warning
- it looks more like you need to create a create a raster dataset in your SDE first then add the raster image(s) see Creating raster datasets in a geodatabase—Help | ArcGIS Desktop
Also check what level of user credentials are you using to connect to the SDE database, do you have the proper permissions especially if you are not also the DBO
Does this work when importing into a local file geodatabase, as a test?

As you noted this is urgent, have you put a support ticket in with ESRI?

Re: Raster dataset into SQL Server 2017 Enterprise Geodatabase

Pieterdu_Plooy2 — Sun, 27 Jan 2019 03:34:23 GMT

Lance

I can import a feature dataset into the sane geodatabase. I can say that with testing Postgres and Oracle, they also exhibit the same problem.

Importing into a FGDB works. If I export the raster from the FGDB to the Enterprise Geodatabase, that also works

Re: Raster dataset into SQL Server 2017 Enterprise Geodatabase

LanceCole — Sun, 27 Jan 2019 05:42:06 GMT

I was able to locate the file you are trying to use at QGIS-Training-Data/exercise_data/raster at master · qgis/QGIS-Training-Data · GitHub. I was also able to import this to a SDE database running on SQL Server 2017 using the following method as a workaround since Raster to Geodatabase is not working for you.

1) from ArcCatalog, right click on the SDE database Connection and select New>Raster Dataset

2) in the Create Raster Dataset dialog

input the Raster Dataset Name - I used "test"
set the Number of Bands - 4 as this matches the original image
press OK and wait for the blank Raster Dataset to be created

3) Again in ArcGIS Catalog, right click on the new Raster Dataset you just created and select Load>Load Data

4) in the Load data dialog

add the raster files you need
click OK

This will create a mosaic Raster Dataset for you on your SDE database

Re: Raster dataset into SQL Server 2017 Enterprise Geodatabase

Pieterdu_Plooy2 — Sun, 27 Jan 2019 05:56:37 GMT

Lance

Thank you for the response.

In previous versions of Arc I could just import that raster dataset as is without any problems. I did not have to do all the steps you did.

I tested this on 10.6.1 a while back, and if you have an Enterprise GDB, you can use Desktop to import the raster dataset as is, without doing your steps (Have to check this though, as I have reverted to 10.5.1) The last time I checked I was also pretty sure you also could not create mosaic datasets as well. I will install 10.6.1 later and check.

It just feels to me that there was a functionality change to 10.6.1...

So in short, I have just been trying to import a raster dataset (tiff file) into an Enterprise Geodatabase just like in previous versions. (Raster to Geodatabase tool) (Not raster catalog)

Re: Raster dataset into SQL Server 2017 Enterprise Geodatabase

LanceCole — Sun, 27 Jan 2019 17:06:32 GMT

You may want to revisit Asrujit SenGupta's‌ earlier post pertaining to the 10.6.1 Raster Patch. I was setting up a new virtual ArcGIS Desktop 10.6.1 this morning and ran the Raster_to_Geodatabase tool before installing the 10.6.1 Raster Patch. I received the same errors you have reported with the files from the QGIS Training Data. After running the 10.6.1 Raster Patch the Raster to Geodatabase tool ran without issue using the same files.

Make sure you do not have any apps open when running the Patch or better yet run the Patch immediately after a restart as an Administrator.

Check if this patch helps, if you are using 10.6.1:
ArcGIS (Desktop, Server) 10.6.1 Raster Patch

Re: Raster dataset into SQL Server 2017 Enterprise Geodatabase

Pieterdu_Plooy2 — Tue, 29 Jan 2019 14:51:33 GMT

Lance

I did a clean install of 10.6.1, and installed the relevant patches. It is still not working

Re: Raster dataset into SQL Server 2017 Enterprise Geodatabase

LanceCole — Tue, 29 Jan 2019 18:04:55 GMT

I would definitely call Esri Support or put a support ticket in to get a quick reply to this issue.

Re: Raster dataset into SQL Server 2017 Enterprise Geodatabase

Pieterdu_Plooy2 — Tue, 29 Jan 2019 18:47:04 GMT

Just another question. Did you install any other patches?

Re: Raster dataset into SQL Server 2017 Enterprise Geodatabase

LanceCole — Wed, 30 Jan 2019 00:11:44 GMT

ArcGIS Desktop 10.6.1 v10.6.9270

ArcGIS Desktop 10.6.1 Raster Patch (ArcGIS-1061-DT-R-Patch)

I may have also installed ArcGIS Coordinate Systems Data but cannot recall if that was before or after I tested the issue.

You can run this tool Patch Finder for ArcGIS to get a list of installed patches on your system to confirm it is installed.