|
POST
|
Checked the "Data Store" on the server and have validated all registered connections. Also, reviewed database connection properties with the database name being correct, USER = sde and version=dbo.DEFAULT. Walter
... View more
05-26-2017
07:03 AM
|
0
|
1
|
914
|
|
POST
|
Now that I've realized that not all of my point data has connections to the spatial view that I am creating, therefore, not all the point geometry will show up. Great so far. Thanks Vince... Was successful in populating a unique number in a new column in my spatial view and have added it to my SDE feature class. I've attempted to publish the map service, unfortunately, I get a 'SEVERE' error in ArcGIS server that states: Error: DBMS table not found[42S02:[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'EDMS_GIS_Test_Deploy.xxxx\ARCGISDEV.GRWSPATIALRAD'.]. The spatial view attached in my .mxd document states that it's "EDMS_GIS_Test_Deploy.dbo.GRWSPATIALRAD My Questions: 1. So where do these erroneous names come from? 2. How can the map publishing be successful after no errors were generated during the analyze phase? Walter
... View more
05-26-2017
06:44 AM
|
0
|
1
|
2276
|
|
POST
|
I'm using a pre-tested sql statement and am using ArcCatalog > New > View with the following statement that creates the joins in the view:
... View more
05-24-2017
07:40 AM
|
0
|
1
|
2276
|
|
POST
|
I can open the attribute table and scroll to end of table, but no additional point data is being displayed. Out of the 1,837 data points I have in my GIS related table, approx only half of the point appear either while looking at the attribute table, or not. Walter
... View more
05-24-2017
07:10 AM
|
0
|
0
|
2276
|
|
POST
|
Morning Joshua, I can review the total number of records while in ArcCatalog > Preview > Table. The view contains a 1:M cardinality, with one of our GIS data sets joined to three external database tables. Yes, while in ArcMap, the attribute table lists the complete contents of the view, and I can see from the display that not all of the geometry is being displayed. Walter
... View more
05-24-2017
05:03 AM
|
0
|
1
|
2276
|
|
POST
|
Afternoon, I've created a spatial view with ArcCatalog and have now added it as the data source to my project *.mxd The view contains 149,400 records. lt's been constructed from one of our data sets and inner joined to three other tables from an external database. The view has a 1:M cardinality to the remaining external data. When I attempt to update my map extent in ArcMap, not all of the geometry is being displayed. But only a small fraction of the points display correctly. My Question : Why is the entire collection of points not being displayed? Walter
... View more
05-23-2017
12:27 PM
|
0
|
17
|
4656
|
|
POST
|
Vince, Interesting concept....."Replicating an ideal subset on the join data locally" Could you please expand on this? Walter
... View more
05-18-2017
06:57 AM
|
0
|
1
|
2567
|
|
POST
|
Thank you gentlemen for your responses. We currently use SQL Server as our database. I just need to find the most efficient way of extracting data from another database on the same instance and linking it to our GIS map services. Most views I create from this data is in the 300,000 record range. Currently, I'm using a 1:M ArcMap "Relate" and then publishing the map service to consume on the other end ie. Geocortex But some of our map services ie. Ground Water needs to link to 5x categories of data with an approx. record total of over half million records. My Question: What is the most efficient way of accomplishing this task? Walter
... View more
05-18-2017
04:58 AM
|
0
|
0
|
2567
|
|
POST
|
Afternoon, I'm attempting to create a query layer from a feature class in our SDE database plus three additional tables from an external database that is stored in the same SQL Server instance. The SQL statement supplied contains four joins. One to our feature class, and the remaining three to the external database. I'm using the "Make Query Layer" tool set. It accepts the SQL statement supplied and I select three columns to be the unique identifiers. Great so far. My Question: Is the query layer dynamic? Meaning, does it react like a view where it will continue to read data from the three external tables when additional data is added to those external tables? And finally, it's weird, but the results window states that the process was successful, but I cannot find the output query layer anywhere in my database...!! Walter
... View more
05-17-2017
11:04 AM
|
0
|
6
|
3910
|
|
POST
|
I often create views using ArcCatalog with New>View and add the view to my database. The view is created with the following naming convention: TestDeploy.dbo.SpecialView I then add the view to my .mxd and continue on with my project. During the publishing process, the analyze step flags an error with this view, stating that the view is not recognized and is not registered to the database. I then use the tool "Feature Class to Feature Class" into another temporary .gdb and then copy the view back with the same command. Unfortunately, this step alters the view into a table and does not retain it's view parameters Then, the newly created table will have the following naming convention: TestDeploy.DBO.SpecialView Why does the initial New>View create the view with lower case "dbo"? And why does the transferred table now become "DBO"? Is there an issue with my database connection that it creates a dbo.view and not a DBO.view? Walter
... View more
05-17-2017
05:39 AM
|
0
|
0
|
669
|
|
POST
|
I've published a feature service to our instance of ArcGIS server v 10.4.1 and am attempting to manually apply edits to test out the service. While using the REST endpoint's "ApplyEdits" hyperlink, I'm inserting the following line into the "Adds" section: [{"attributes":{"Junk":"junk,"BeginDate":1428292800000,"EndDate":1428465600000,"CreateDate":1491418656097}}] The error that I'm receiving at this time is: "Unable to complete operation. Internal error during object insert" But after I review the server logs for that feature service, it states: Error: Insufficient permissions. How do I apply the necessary permissions to allow edits to be applied to this feature service? Any help would be appreciated. Walter
... View more
04-06-2017
05:32 AM
|
2
|
2
|
4427
|
|
POST
|
Afternoon, I have a rest end point that contains 24 hour entries for each day regarding precipitation. But I only need to extract the last hour of that day, or the max(date) value. For example: 2005-01-14 01:00:00 2005-01-14 04:00:00 2005-01-14 05:00:00 2005-01-14 08:00:00 2005-01-14 23:00:00 So in the example above, I only need to extract the last value. How does one query the rest end point to extract only that value? Any help would be appreciated.....Walter
... View more
02-10-2017
11:46 AM
|
0
|
2
|
1648
|
|
POST
|
Gentlemen, This is the first time we're trying to use spatial views for our project. I was attempting to publish last week, but since the layer data source was not registered, it was trying to copy the entire database over to ArcGIS server. But initially, it was letting me publish, without the high alert. Now it won't even let me publish. Adam, am not sure if we've installed the server publishing patch. But I will inquire. Walter
... View more
02-06-2017
10:04 AM
|
0
|
0
|
641
|
|
POST
|
Adam, After my view is created in the SDE, I then alter the data source in my mxd to use the newly created view as it's data source. But then when I attempt to create a map service out of this, during the analyze stage, I get a high error alert which then tells me that I need to register the layer with the database and it will not allow me to publish. Walter
... View more
02-06-2017
09:25 AM
|
0
|
2
|
3379
|
|
POST
|
Adam, I need your assistance again. Rather than using ArcCatalog to create the spatial view, I initially used SQL Server Management studio to create the view inside our SDE database. This, I was told, can corrupt the database. Rather, I should have used the Create > View in ArcCatalog and only supply the correct sql statement. But when I attempt to register the view with the SDE database, I get the 001050 error: Either registered with geodatabase already or cannot open the dataset. After additional research, it seems that only feature classes or tables can only be registered with the geodatabase once and only feature classes or tables are supported? Walter
... View more
02-06-2017
07:56 AM
|
0
|
0
|
3379
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 07-17-2017 10:36 AM | |
| 2 | 04-06-2017 05:32 AM | |
| 1 | 08-29-2017 05:44 AM |
| Online Status |
Offline
|
| Date Last Visited |
11-11-2020
02:24 AM
|