Latest Contributions by MartinAmeskamp

Hi Jesús, why would you want to do that? Anyway, without knowing the constraints of your environment, using a second version inside the first might be the way to go: Discarding all changes means rolling back a long transactions, and long transaction are implemented by versions in ArcGIS. So if you want to roll back your changes while keeping your transaction alive, use a second layer of transactions: Create verison V1 off DEFAULT, and then create V2 off V1 before you start editing (in V2, of course). Then you caeither post your changes to V1, or delete V2 to return V1 to its original state. As long as V1 has only one subversion, there shouldn't be any noticeable performance overhead. Martin ... View more

Hi Pramod, without having a complete answer, here are some things to consider: If you're working with triggers and want to insert records into some other table from the trigger, you probably know about autonomous transactions in the trigger. You don't say which RDBMS you're using, for Oracle, there's a pragma autonomous_transaction, SQL Server doesn't seem to have this directly, but there's linked servers which might help. The STATE_ID of a record in an A table may change a couple of times before the records gets posted to DEFAULT and conversely, a record may get posted to DEFAULT without the STATE_ID changing, so I'm not really sure how to detect the post through a trigger on the A table... If you want to know whether a given record in an A table is part of DEFAULT, you would at least have to check whether that state is part of the SDE.DEFAULT lineage, and whether there are D table entries that neutralize the A record. Altogether, I should think that application functionality (ArcObjects, GP, ...) will be an easier and safer way to manage secondary databases... Good luck, Martin ... View more

So, what do I tell the client who has 800 copies of their 30-table schema and a couple of thousand ArcGIS Server services to handle all these copies: Yes, that's the way to go, just get more hardware!?? Your security requirements are all wrong, open up!?? Sorry if this sounds a bit contrary, but these are real problems. Martin ... View more

Hi Michael, thanks for your reply. Deactivating the layer, either manually by unchecking it in the TOC or programmatically, is certainly the way to go once the user realizes that the service is unresponsive. My question is whether we can do something about the behaviour of ArcMap (no reaction, whiteout, ...) when the service starts acting up. Since we observe strong fluctuation of response times (2-3 s optimum, maximum >> 60 s), a timeout would be the ideal solution. Switching the service layer off for longer periods of time is not really an option since the information is needed regularly. The reasons for the service being slow are fairly clear - at certain times of the day, the load on the infrastructure (network, servers) etc. simply gets to high and response times go down. Technically, it's fairly obvious how to fix this. The problems lie on the administrative and financial side. I can find out the WMS version if that would help, but since the service itself is out of our control, I haven't checked yet (also, it's not an ArcGIS Server-based service). Martin ... View more

If we're looking at plain ArcMap and a smallish number of tables and users - yes, by all means. On the other hand, I recently came across a situation (no customer of ours) where this approach had resulted in the number of tables being more than 100,000, with thousands of ArcGIS Server services on top. Surprisingly, the system still seems to work... In the context of our application, this is not an option: The application structure and constraints imposed by Schneider Electric ArcFM prohibit the use of multiple sets of tables in one database. Believe me, we have investigated this rather thoroughly. Martin ... View more

Yes, SOI is not a solution for ArcMap, but we've been looking at Pro a lot recently, and there seems to be a strong push away from direct GDB access, towards consuming feature services (for viewing and editing). Our context is utility application. We have a rather complex custom solution on top of ArcMap (also using some Schneider Electric ArcFM functionality), and some our larger customers use their installation, expertise and manpower to provide network documentation as a service to smaller utilities. Right now, they need a separate database for each utility, since access to network documentation is fairly strictly regulated. Number of tables is fairly high, hundreds of feature classes. Martin PS Our main market is Germany. ... View more

OK - clear words. I'd taken this suggestion from the Microsoft SQL Server docs on row level security, and yes, the username wouldn't be my first choice, so forget about that. What about an ID (i.e. project ID, customer ID). Could one take that seriously? If not, why? Any alternatives? I recently heard about Server Object Interceptors that could provide some sort of masking to implement selective access, and we hear that ArcGIS Pro has much better support for editing feature services, but that's still rather far away... Martin ... View more

Hi, coming abit late into this discussion ... Microsoft suggests implementing row-level security by using views: If you want to restrict access by, say, user, put a column USER on your tables and use a view with "where table.USER = CurrentUser()" to restrict access. Question: Would this view be a first class citizen in ArcGIS? Adding data, publishing feature services, ...? Thanks, Martin ... View more

Hi, not sure I understand this correctly, but here's a try: I assume you're using MS SQL Server, otherwise there wouldn't be a DBO around. So your user sets up a database connection using OS autehtication - this seems to indicate that there is a login in your SQL Server instance (e.g. AD user or AD group) that fits your user. Now, if someone else wants to use that connection information, they, too, need to be matched to a login in the SQL Server instance - that doesn't seem to be the case, so I'd suggest you check, and may be post here, the login situation in your database instance. I'm not aware of a functionality that magically replaces the credentials in the SDE connection with DBO (I assume that you have set up your SDE schema to be owned by DBO), but then, I'm fairly new to SQL Server... Martin ... View more

Jens, The incident number is 1202365 (we handled this as a PSS call, it still took a couple of months to process, and I finally talked this over with Tom Brown in Palm Springs last year). Also, we didn’t use st_intersect but rather st_within, but the general problem remains: Oracle (at least) isn’t able to push the geometry operators for enough down, so we’re basically doing Cartesian products here. I have to check how we created the spatial index – at a guess I would say SDE command line tools (this was 10.0) to register the table and create the index, but I’d have to check. Martin Von: Jens Dalsgaard Gesendet: Donnerstag, 26. März 2015 12:12 An: Ameskamp, Dr. Martin Betreff: Re: - Optimizing STIntersects queries GeoNet <http://jiveon.jivesoftware.com/wf/click?upn=Dg1s4x8le7Lmxv8KWGaqo8h7SGfRSMkw-2FpvHGF9-2FW3rK-2Bvs1kL9-2FnG6jjf2NZhrLDz0M-2BrY-2By9IaziQEKVk3Hg-3D-3D_GjRFCNGdMNqdt7rSVIqdH0qHqDDgIeyIXpkS4jn6U-2Fr3fh9mo7Hp47Cmfn-2FKfkYVPSbbPhU0zRTPicqVCMlD7FbwMUYhqnW58oFK-2FGfuLhjSWB4mfL0sBiGx7HYT47eWq8mZfgAZuZP3-2BXaicr5JedovF0BI5zamI98mf2jaELKHtg-2BeHEGXvGQ-2F3SHU1ivAyKMKnkqruWe9JFrBMVlODzXCztGjTUSeyDHdBq411mDflUhfYgBMXyxdEQseVC-2Fkai3r6pofXd-2Bwh7RfVZm-2FdSuj33Oq8SAI3EG4Ap6RBgcfV3gynk4iEqtKmkIaZInMfgAAIjvmRzepB-2FWLriy6Pg-3D-3D> Optimizing STIntersects queries reply from Jens Dalsgaard<http://jiveon.jivesoftware.com/wf/click?upn=Dg1s4x8le7Lmxv8KWGaqo7A4BXwO9PY1WvQ5cXCtK4-2BSRSZ76VBeXE7uzYUPV67Ik1bjaVUiec4mZMqiIZA-2F25kkQEmSP3BTAo5zzmswJlP235Z0mVMDLF-2Fa0gNgtUkl_GjRFCNGdMNqdt7rSVIqdH0qHqDDgIeyIXpkS4jn6U-2Fr3fh9mo7Hp47Cmfn-2FKfkYVPSbbPhU0zRTPicqVCMlD7FbwMUYhqnW58oFK-2FGfuLhjSWB4mfL0sBiGx7HYT47eWq8mZfgAZuZP3-2BXaicr5JeWoJbnR4C3I3jHGnaH3D2Kj98i9wUlfDOAynWe2UI-2BHAN-2Buio5oBaFRuQefaWgwDGm5vPzISpjU2VbDT4oZtPdlanszaqQ4uvoffc2BjMSCBBd0BkjRzOfOZJ8KuVFP-2Bc5X5gjk9wHgyG-2FEVzCYhW9eynkiGY6eM-2BpRGbjRzUkXqPi8RSazhksyXthz5bQxDKg-3D-3D> in Developers - View the full discussion<http://jiveon.jivesoftware.com/wf/click?upn=Dg1s4x8le7Lmxv8KWGaqo0VQjeJBYpG9HGC8QZBT-2FEzFuAN4zRGmsPhJgokMP-2FGoMTbkFv3OoqtkXlXEWg5Rmv3ERQ1OeE-2FADIPzUj2kjHg-3D_GjRFCNGdMNqdt7rSVIqdH0qHqDDgIeyIXpkS4jn6U-2Fr3fh9mo7Hp47Cmfn-2FKfkYVPSbbPhU0zRTPicqVCMlD7FbwMUYhqnW58oFK-2FGfuLhjSWB4mfL0sBiGx7HYT47eWq8mZfgAZuZP3-2BXaicr5JeQlXx-2FyRuuQiFCqBNq4x7lSLFacAXE1K2A0Dwpw-2F-2BADbH8q-2%20BbikgATY2aVbSdhDtLw-2FyPs-2BokVoYacJAqVVoVstC6NaSG-2B1dOiTTIebu8qNlefbutaZINIoRKjTJJ08o3bPIfEwTONwIw75s3B1ijtyw-2FI-2B5Q30wKtEQ-2F5FJlSC-2FXYtVnSgeESSSU7K1P9YycQ-3D-3D> ... View more