topic Re: Could not load data from the data source in Data Management Questions

Could not load data from the data source

AngeletaWilson — Fri, 18 Oct 2013 15:53:04 GMT

I am trying to access some data from a version 10.0 SDE GDB using Desktop 10.2 but for some of the layers, when i try to access the table i get the error "Could not load data from the data source". This only happens with some layers and on others i can open the table but it comes up either blank or with the field values all set to '0'. I found an old post that spoke to the field names using incorrect field names, but i checked all the fields and they seem fine http://forums.esri.com/Thread.asp?c=2&f=1719&t=293619.

Apparently that issue was fixed in 10.0, but i cannot find any information relating to 10.1 or higher. Can someone assist please?

Re: Could not load data from the data source

NidhinKarthikeyan — Sun, 20 Oct 2013 06:24:38 GMT

Angeleta,

Check whether the name of the Feature class/Table/Field, doesn't contain a space/special character or begin with number. For the purpose of test, try renaming the feature class and table. Make sure you have a complete backup before the test.

Regards,

Re: Could not load data from the data source

BrooksKelley — Tue, 03 Dec 2013 15:18:18 GMT

Did you ever figure this out? We're experiencing the same thing with ArcGIS Desktop 10.2 and an SDE 10 GDB. It seems to only occur over a slower network connection.

Re: Could not load data from the data source

AngeletaWilson — Thu, 03 Apr 2014 13:36:45 GMT

Did you ever figure this out? We're experiencing the same thing with ArcGIS Desktop 10.2 and an SDE 10 GDB. It seems to only occur over a slower network connection.

No, and issue persists; another colleague is also having the same issue as well...

Re: Could not load data from the data source

AsrujitSengupta — Thu, 03 Apr 2014 14:17:15 GMT

Angela,

Can you please try a OLEDB connection and check whether that gives you the same issue.

Adding OLE DB connections to databases:
http://resources.arcgis.com/en/help/main/10.2/index.html#//006600000452000000

Re: Could not load data from the data source

AngeletaWilson — Thu, 03 Apr 2014 15:51:57 GMT

Angela,

Can you please try a OLEDB connection and check whether that gives you the same issue.

Adding OLE DB connections to databases:
http://resources.arcgis.com/en/help/main/10.2/index.html#//006600000452000000

I tried this and i can view the tables fine through the OLEDB connection.

Re: Could not load data from the data source

George_Thompson — Thu, 03 Apr 2014 18:39:00 GMT

Angeleta,

What RDBMS and O/S are you using for your 10.0 SDE?

Thanks!
George

Re: Could not load data from the data source

AngeletaWilson — Thu, 03 Apr 2014 18:48:34 GMT

I got this issue resolved today by a nice ESRI support guy, Nitesh J. Apparently even though I was running the SQL Server Native Client, I needed to run SQL Server Native Client Release 2. After uninstalling the sqlncli and installing sqlncli release 2, my tables were loading fine!

http://www.microsoft.com/en-in/download/details.aspx?id=16978 - First go to Installation Instructions and scroll down to Microsoft® SQL Server® 2008 R2 Native Client. You have to ensure that you are installing the one that is compatible with your machine.