|
POST
|
Nice blog, and great conversation here. I agree that it is confusing, especially when we start using terms for multiple things. While we can't always manage the terms people use on the fly, we can at least try to guide the vernacular. We appreciate your effort to keep this topic clear. As always, too, we are available for more discussion on the phone if you'd like to call Esri Support. Just ask for a Desktop Analytics analyst (formerly known as geodata) and let them know you would like to have a conversation about enterprise geodatabases and semantics.
... View more
10-24-2017
08:35 AM
|
1
|
2
|
2545
|
|
POST
|
Would a join help you more so than a relationship class? Add your data to ArcMap. Right click the data that has the spatial column (the feature class that can be symbolized). In the Joins and Relates section, add the join to your table with the extra information. Once the join is created, right click the feature class again in ArcMap table of contents. Go to properties, the symbology tab, then choose Categories. Do you see your Oracle table fields in the Value Field Drop down? I just tested this in ArcMap 10.6 beta: Create new feature class in Oracle 11g geodatabase. Use SQL to create an Oracle table (not registered with geodatabase), and insert data. Add the feature class and Oracle table to ArcMap 10.6. Create a join on my id columns, keep all records. Open layer properties for the feature class, Symbology tab, Categories. I can use my Oracle table fields to symbolize. Questions/Clarity needed: If this workflow is different from your own, please clarify. Please also clarify if you are working with any data that is not registered with the geodatabase (Can verify this in ArcCatalog, right click the table/feature class-> Properties-> General tab...if it is not registered then there will only be 3 tabs...there will be more tabs if it is registered). What version of ArcMap are you using?
... View more
10-24-2017
08:23 AM
|
0
|
4
|
2660
|
|
POST
|
You guys got it. Error: Failed to connect to database. General function failure Unexpected error from external database driver Solution or Workaround Open the .xls file in Microsoft Excel, save it as a .xlsx, and install the 2007 Office System driver (if it is not already installed). Alternatively, open ArcToolbox and navigate to System Toolboxes > Conversion Tools > Excel > Excel To Table geoprocessing tool to import the .xls file as a table.
... View more
10-24-2017
07:36 AM
|
1
|
0
|
2109
|
|
POST
|
you are 100% correct that ArcSDE refers to the product which provides an application server connection. At 10.1 we discontinued that product, and received messaging to start using the term enterprise geodatabase to refer to what we historically called SDE geodatabases. Even in that time though, an application server service is not a type of geodatabase, but a method to connect to a geodatabase. For example, I can have a single 10.2.2 geodatabase that is accessed by two different users...one user may connect using direct connect and the other may connect using an application server connect (if that is set up of course). This does not change the enterprise geodatabase itself. Sorry for the confusion, and thank you for trying to clear up this topic! You are right that it is important we are all on the same page with semantics, or at the very least, know that there have been changes in the last few years to be aware of.
... View more
10-24-2017
07:28 AM
|
1
|
4
|
2545
|
|
POST
|
Right, a more accurate description would be: Types of Geodatabases at 10.5.1: Personal (.mdb) File (.gdb) Enterprise (.sde) Desktop License- via Direct Connect access only in SQL Express. Workgroup License- via Direct Connect access only in SQL Express. Enterprise License- via Direct Connect access only in SQL Server, Oracle, PostgreSQL, DB2, or Informix RDBMS. *ArcDesktop 10.5.1 can connect to 10.1-10.2.2 geodatabase via Application Server connection (3-tier).
... View more
10-24-2017
07:10 AM
|
3
|
2
|
4452
|
|
POST
|
Support for this will be coming! ENH-000082601 : When collecting or editing data points in Collector for ArcGIS, provide the ability to collect and update Z values in the same way as X and Y values. Collector does not support directly storing the altitude on the z-value of a geometry. This will be supported in an upcoming release. Currently, you can capture the altitude values of point features, and use the ProjectZ geoprocessing tool to transfer these values to geometry z-values." http://doc.arcgis.com/en/collector/windows/create-maps/troubleshoot-create-map.htm#anchor4
... View more
10-23-2017
11:58 AM
|
0
|
0
|
2356
|
|
IDEA
|
If you are using an enterprise geodatabase you can create a database view. You use SQL in the definition to define what fields show up in the view and the order can be defined as well. For example, if my cities feature class has fields: OBJECTID, NAME, STATE, SHAPE, and all I want to show is STATE then NAME, then I would create a new view with the SQL "select STATE, NAME from cities", and my output view will only have those two fields in that order. Unfortunately, this is not an option for .mdb (personal) or .gdb (file) geodatabases.
... View more
10-23-2017
11:20 AM
|
1
|
1
|
1535
|
|
POST
|
Nice blog. When I explain Desktop, Workgroup and Enterprise lisences, I explain them as different products that user's can purchase based on their organization's needs. Much like ArcGIS Desktop license levels (basic, standard and advanced), folks can choose what license level of the enterprise geodatabase they need as well. The three types of geodatabases are personal (.mdb extension), file (.gdb extension) and enterprise (.sde extension or a .gds extension that can be saved as a .sde extension). The enterprise geodatabase type has three different license levels that can be purchased- Desktop, Workgroup and Enterprise (so there is an enterprise geodatabase type with the enterprise license...we must have ran out of words to use). The biggest difference between the enterprise geodatabase license levels are the number of people who can connect and edit simultaneously, with the enterprise license level being unlimited. We connect to each type of geodatabase differently from ArcCatalog. We use folder connections to connect to .gdb and .mdb geodatabase. We use the Database Server section in ArcCatalog to connect to enterprise geodatabases licensed with desktop and/or workgroup. These connections get a .gds extension, and you can save the .gds extension as a .sde extension for distribution purposes. We connect to enterprise geodatabases with enterprise licenses through the Database Connections section in ArcCatalog. One note on the blog, I'd update the point about application server connections, as this is not a type of geodatabase as much as it is a method to access geodatabases. These connection methods are only supported to a 10.2.2 or older geodatabase, I.e. you will not be able to connect to a 10.5.1 geodatabase using a three tier connection. ArcSDE geodatabase: an enterprise geodatabase to which connections are made via the ArcSDE application server.
... View more
10-23-2017
10:55 AM
|
2
|
11
|
4452
|
|
BLOG
|
What is it? The synchronization process is made up of multiple tasks involving sending and receiving data and acknowledgements between the two geodatabases that participate in the replica. The Disconnected Synchronization process allows the user to manually complete each of these individual tasks. One way to think of synchronization can be to compare it to a phone conversation between two people, speaking and listening to each other. Why use it? To provide a method of synchronization for customers with replication between geodatabases that are in a disconnected environment. To troubleshoot issues with replicas in a connected environment. To get a deeper understanding of the synchronization process. How to use it? There are three ways you can access the tools needed to perform a disconnected synchronization. ArcCatalog Context Menu: ArcToolbox Geoprocessing tools: ArcMap Distributed Geodatabase toolbar: Before running any tools, use the replica manager to confirm which geodatabase in your replica is the data sender. *Always check this status from both the parent and the child. Step 1: Export Data Changes from the Data Sender. If you are using a two way replica, and need to synchronize data in both direction, check the 'Switch to being a receiver once the message has been exported' so this workflow can be done in the opposite direction later. Exporting the changes to Delta Geodatabase allows you to see the records with updates, inserts, and deletes that are being synchronized. If features have not been updated, inserted or deleted since the last synchronization then you will not see those records in your Delta Geodatabase. Esri Support insight: If other synchronization methods fail, this is my go-to option for troubleshooting that failure. This step can be compared to saying “Hello” to start a conversation. Step 2: Import those data changes into the Data Receiver using the Import Messages Wizard. Since our output in step 1 was a file geodatabase, we will choose to import a delta file geodatabase here. This step can be compared to hearing someone say “hello” to you to start a converstaion. Step 3: Export an Acknowledgement Message from the Data Receiver. This output will be an XML document. This step can be compared to saying “hello” back to someone who just greeted you. Step 4: Import that Acknowledgement Message into the Data Sender. This step can be compared to someone hearing your “hello” reply. The four steps are needed in order to perform a synchronization in one direction of a single replica. If you are using a two way replica, and need to send data in both directions, then you will need to repeat these four steps again in the opposite direction. *Use the Advanced tab in the Replica Properties to see the history of your replica geodatabases conversations. Parent geodatabase Replica Properties Child geodatabase Replica Properties The Current Generation of the Data Sender increases when data changes are exported from the sender geodatabase. From the Data Receiver, The relative replica generation increases when new data changes are imported into the receiver geodatabase. The Last Acknowledged Generation of the Data Sender increases when this geodatabase imports the acknowledgement message For Fun! *Always check this status from both the parent and the child. Now that you have completed the disconnected synchronization workflow, let’s look at the statement above. Can you now think of WHY it is important to check the status from both the parent and the child? If you see both the parent and the child have the same status, what would you do to reconcile that so that only one geodatabase is the sender, and the other is the receiver? *Use the Advanced tab in the Replica Properties to see the history of your replica geodatabases conversations. This blog uses images to show the generations of a parent and child geodatabase. In the images, the generations are "in sync", meaning that the conversation between the two geodatabases is completed...one said hello, and the other said hello back. The generation numbers are 3-3-1 in the parent, and 1-1-3 in the child. Can you determine how many times the parent has sent data to the child? Can you determine how many times the child has sent data to the parent? Can you determine what needs to be done if those numbers were 3-2-1 and 1-1-3? esrisupport
... View more
10-20-2017
01:59 PM
|
10
|
9
|
4506
|
|
POST
|
Take a look at these Microsoft resources discussing files and filegroups, as well as growing log files... Using Files and Filegroups to Manage Database Growth Help! My SQL Server Log File is too big!!! - TechRepublic See the part about database recovery model in ^ article.
... View more
10-20-2017
08:51 AM
|
1
|
1
|
1755
|
|
POST
|
What tools are you using to replicate your data? I see you mention AGS and services...are you replicating from a geodata service? If so, you could try using the workflow documented here... Publishing a geodata service with a map service—Documentation | ArcGIS Enterprise It talks about using a map service (with same name as your geodata service and in same AGS folder) to create the replica. Using this method, you have all the data you want replicated in the map service, add the map service to ArcMap and use the Create Replica tool on the Distributed Geodatabase toolbar. Using this toolbar, instead of Create Replica from Server geoprocessing tool, allows you to use the option to 'register existing data only'. That means that before you create the replica you manually copy and paste the data you wish to include in the replica into the child, so that the data is already present in both parent and child geodatabases. When you then run the Create Replica wizard, it simply registers the existing data, rather than copying the data itself.
... View more
10-20-2017
08:38 AM
|
0
|
4
|
2059
|
|
BLOG
|
Very good point Rick! Today organizations are growing so fast, taking advantage of many features and functionality from multiple softwares. Our users are getting increasingly creative as well, using workflows that they have found to work for them. That's great, we love that, but we need to understand that in order to help. I will use myself as an example. My background is in the RDBMS, and with that I often work within the RDBMS, ArcDesktop (geodatabase management), ArcGIS Enterprise (formerly ArcGIS for Server), and Collector for ArcGIS. If a user reports an issue with the Network Analyst extension on data in their enterprise geodatabase stored in Oracle, but the same workflow on the same data stored in a file geodatabase works fine, then that case would come to me. As you probably know, many of our tools require some prerequisite, like specific types data to be added to a map first, or an edit session to be started. At that point, the most time efficient way for me to get up to speed on the exact tools and workflow the customer is using is to learn that from the customer themselves, rather than attempting to digest general concepts from colleagues (if they are not also busy) or written resources in a short amount of time. Our customers teach me SO much!
... View more
10-20-2017
08:29 AM
|
0
|
0
|
2445
|
|
BLOG
|
I want to bring up, also, that sometimes there are issues with attachments when cases are logged through email. I have had users mention that they had attached intercepts, crash dumps, issue details, etc when logging the case through MyEsri, only to have the analyst ask for those items again. Sadly, I have had these interactions myself, and when I check the case attachments there aren't any there. I am looking into what may cause attachments to be stripped from cases while they are first being logged, but just keep in mind that these technical difficulties can happen. When I get that information I will be sure to update this post for you.
... View more
10-19-2017
12:58 PM
|
0
|
0
|
2445
|
|
BLOG
|
Rebecca, Thank you for your comment! That is a great question. I will need to check in on the specifics of format/size limitations when requesting a case, however, if you prepare your details in a Word document, or your favorite text editor, you should be able to attach the document to the case. You can then refer to the attached files in the body of your support case request for the analyst to review. I hope this helps, and we look forward to hearing from you! -TM
... View more
10-18-2017
04:33 PM
|
0
|
0
|
2445
|
|
BLOG
|
We have all been there. Your stomach is growling, yet all of your mental energy is focused on fixing the car in front of you going fifty in the fast lane. When people are hangry (hungry/angry) they may come off irritable and agitated, maybe even point out every little thing that is going wrong, when the issue at hand is as simple as “I am hungry. Feed me!”. Misdiagnosis happens all the time and can translate into many other facets of life, including software issues, but could you diagnose software issues when it seems like your software is being hangry? The good news is that with some practice, and skills of observation, anyone can categorize software issues like a pro. This blog will help guide you when encountering software issues. The intention is to lift the many layers that can complicate issues, so that you may accurately, yet simply state the issue you need help with. Symptoms of software issues are observable by the end user in many forms, such as an error, performance degradation, or a software crash, to name a few. Hopefully, these interruptions prompt users to call to Esri Support and log a case for investigation. At Esri Support, our analysts have a specific skillset. Few of us are generalists, and this structure is designed to provide our customers with elite technical support…in other words, we don’t use scripts. Why is this important? One of the first steps to logging a case with Esri Support is providing a description of the issue, which will be used to form a subject line in the case. These subject lines can be altered as more knowledge is gained on the issue through investigation, but this initial subject line is big factor in determining which analyst owns the case first. Determining the overall symptom helps guide the triage process and the lifetime of the case. Let’s explore these symptoms in more detail. 1. Error: Error messages will stop us in our tracks. Sometimes the messages are very useful, and tell us exactly what we need to know to proceed, sometimes not so much. When users encounter errors we always request a screenshot of the error and the workflow (clicks) leading up to the error. For example, “Error: invalid coordinate system identifier” is seen when adding data from an Oracle enterprise geodatabase into ArcMap. 2. Performance degradation: Personally, this is the most frustrating issue to encounter. There is no error; instead, the process is slow, and the spinning hour glass doesn’t tell you when you can expect performance to return. When performance cases come to my desk, I first gauge the slowness, because “slowness” is a relative term, and something that is slow in one environment may be optimal in another. The symptom here isn’t just performance, but specifically performance degradation. In other words, there was a more optimal performance, which has now degraded. Symptoms of slow performance can be caused by many things including workflows, overloaded resources, and software compatibility to name a few. To get started troubleshooting it is always helpful to have a comparison case available for investigation. If you believe you are seeing slowness in software, first ask yourself ‘this is slow compared to what?” For example, “using ArcMap 10.1 sp1 to do the same workflow on the same data takes 1 seconds, while using ArcMap 10.5.1 takes 20 seconds”, or “Previewing feature class A in ArcCatalog takes 1 second, while previewing feature class B takes 20 seconds. Both features are stored in the same enterprise geodatabase”. These examples give us a “fast” example and a “slow” example that can be compared to each other. Notice in these examples that there is only one difference in the workflows, giving us controlled variables and a single dependent variable to review…right, like scientists. 3. Unexpected results: This symptom, like performance, will not produce an error, but unlike performance symptoms, these processes will complete, seemingly successful. However, when the results are analyzed they are incorrect or incomplete. Unexpected results can also take the form of tools being disabled, or grayed out. For example, “I open ArcCatalog to enable Editor Tracking on my feature class, but Enable Editor Tracking is grayed out”, or “I created a replica of my U.S. States feature class, but only 48 of the states were replicated into the child geodatabase”. Most of the time unexpected results stem from a workflow issue. Some setting that needed to be turned on for this tool to work was not turned on, or properties/constraints on this data caused the unexpected results. In the first example above the connection must be made as the data owner to enable Editor Tracking. Any other user connection will see the Editor Tracker option grayed out. The second example, where not all data has been replicated, may be due to filters placed on the data being replicated, or relationship classes enforcing database referential integrity. 4. Crash: Click, click boom goes the dynamite. There is no error. The best you can do is re-open the software and try again. Esri considers all crashes a bug. We want our software to give you a meaningful error that will help you complete your work. Crashes occur when the software encounters an argument that it doesn’t know how to resolve. Always report crashes to Esri Support so we can ensure our software understands how to handle these situations. Software issues can be complex, can employ multiple technologies that require different levels of expertise on many different subjects. These issues can be more approachable by answering the question, “What did I observe during my daily work that prompted me to request help”? While there are always exceptions, 90% of the time I can start answering that question with one, or more, of the symptoms discussed in this blog. I hope this helps brighten up the perceived darkness around software issues, and as always, give us a call if you encounter any of these issues, or just have questions for us. esrisupport
... View more
10-18-2017
04:04 PM
|
24
|
9
|
4781
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 01-26-2016 02:45 AM | |
| 1 | 03-05-2015 06:09 AM | |
| 1 | 03-09-2018 09:01 AM | |
| 1 | 03-08-2018 08:53 AM | |
| 1 | 10-24-2017 11:14 AM |
| Online Status |
Offline
|
| Date Last Visited |
11-11-2020
02:24 AM
|