POST
|
Dan, Yeah, that's what I kinda figured I was going to have to do, but was hoping that I could just write some quick code and, voila!, it's imported and I can go on to the other laundry list of things on this upgrade. Appreciate it. Thanks!
... View more
12-14-2023
07:53 AM
|
0
|
0
|
504
|
POST
|
I'm in the early stages of a migration project from ArcMap 10.8 to ArcPro 3.x. Moving the .mxds are not an issue, but we have a few .tbx files that were created for some customized projects (use/call Python 2.7 scripts with the toolbox taking in parameters). I've used/am using the 2to3 conversion to migrate those scripts to Python 3.x, and was wondering if there was some way to programmatically convert the .tbx structure itself to an .atbx ... I thought ImportToolbox would be the way to go, but I may have been mistaken (got a 99998 error when I attempted). If the Toolbox needs to be rebuilt, that's fine, but it looks like you can import from 2.x to 3.x so I figured there might be a way to migrate from 10.8 to 3?
... View more
12-14-2023
07:37 AM
|
0
|
2
|
516
|
POST
|
Does anyone know if the ArcSDE Java API v10.0's full deprecation is tied to the retirement of ArcMap? I say full because I know that it hasn't been updated in forever, but still exists. We run some spatial update code written in Java that uses items from the com.esri.sde.sdk.geom.SeGeometry family. There's going to be a migration plan with our current code base and I'm trying to find what equivalents are out there on the ArcGIS Pro side. I know the same type of geometry calls exist in the .NET version of ArcMap 10.x.
... View more
12-05-2022
12:55 PM
|
0
|
0
|
355
|
POST
|
But if the shapes were no longer needed on it, and they were nulled out once exported via calculation, then wouldn't you just essentially have a table?
... View more
02-11-2022
09:24 AM
|
0
|
1
|
1147
|
POST
|
That may work. Would I necessarily have to recreate the table from scratch or would a TableToTable function (Import Table to Geodatabase) work just as well?
... View more
02-11-2022
06:13 AM
|
0
|
3
|
1158
|
POST
|
The rename may be on the table as a final option (they don't like to rename or delete anything if possible), but the desire from them is to "unregister" them in such a way that they keep the name and current data, but appear as an SDE Table instead of an SDE Feature Class. You'd think there would be some way to unregister, lol. I'm likely going to have to run a trace and see what all else is touched when I do a delete on an FC.
... View more
02-10-2022
01:44 PM
|
0
|
0
|
1175
|
POST
|
Short answer - the client wants to keep the data on the GDB in case any end users are still using it (there's a lot of old items out there). Part of the unregistration attempt is also to remove confusion when a user attempts to load something in ArcGIS Portal. We want them to load the newer items, but we have "very special" end users, so anything to avoid confusion. I'd guess that the "benefit" is not getting a bunch of trouble tickets from users who don't use the system much and will easily confuse table_a with table_a_st and load the former and have it fail.
... View more
02-10-2022
01:00 PM
|
0
|
0
|
1192
|
POST
|
(Using ArcGIS 10.8.1 and Oracle 19c) I'm trying to unregister some older feature class tables (legacy ESRI Binary geometry) from our geodatabase, since they all have newer ST_GEOMETRY counterparts (either as standalone or as part of a view), as a means of avoiding confusion with the end users as to which is correct. What I'm basically trying to do is to get the (legacy) table to be viewed by Catalog as a table and no longer as a feature class. As I've researched, post-SDE, I don't think there's a straight way to unregister something (these are unversioned), so what I was going to try and do, is run a delete on the sde owned tables and possibly also null out the shape column: delete from SDE.table_registry where owner = 'myschema' and table_name = 'myfeature'; delete from sde.column_registry where owner = 'myschema' and table_name = 'myfeature'; delete from sde.layers where owner = 'myschema' and table_name = 'myfeature'; delete FROM sde.geometry_columns WHERE f_table_schema = 'myschema' AND f_table_name = 'myfeature'; UPDATE myschema.myfeature SET SHAPE = NULL; I've tried it on a test case and it still somehow shows up as a (blank) FC in Catalog, so I'm guessing that there's some place else that still recognizes it as registered. Is there anything else that I would need to do in addition, or instead of this route?
... View more
02-10-2022
12:22 PM
|
0
|
9
|
1198
|
POST
|
Ed, Hi - I was looking to do something similar and found this topic, but didn't see the code you mentioned. Any chance you still have it or could send it? I'm trying to update an FC from an older geometry to ST and was trying to add a second shape field.
... View more
03-02-2021
07:38 AM
|
0
|
0
|
563
|
POST
|
I've tried in all versions we have (10.4.1, 10.8.1 and 2.5). The Geodatabase version I think is 10.4. And yes, I reviewed that document and my data meets all the migration prerequisites.
... View more
03-01-2021
02:07 PM
|
0
|
1
|
2260
|
POST
|
Yes, the tool is being run as the schema owner. The 600 error occurs during the update attempt. I thought it may be related to the 942 error. The FCs are all point, line, polygon ones, no topology or networks.
... View more
03-01-2021
01:24 PM
|
0
|
3
|
2264
|
POST
|
There are a number of feature classes in our current Oracle 12c/19 GDB that are still SDE Binary or ESRI LOB that I'm running an impact analysis on for upgrading to ST_GEOMETRY. When I tried to use the Migrate Storage tool, I received an underlying DBMS error (Error 000955). Upon having a trace run on the backend, we found that The following statements encountered a error during parse: SELECT * FROM SDE.SCH_DATASET Error encountered: ORA-00942 -------------------------------------------------------------------------------- UPDATE MYSCHEMA.BIRDS_FEATURES SET SDE_CONVERSION = SDE.ST_GEOMETRY(:s1,:s2,:s3,:s4,:s5,:s6,:s7,:s8,:s9,:s10,:s11,:s12,:s13,:s14) WHERE SHAPE = :fid1 Error encountered: ORA-00600 So, it appears that SDE.SCH_DATASET doesn't exist (?) - is there a way to remedy this? I think the preferred upgrade path (especially since it's what ESRI suggests) would be the Migrate Storage route. The other route (copy, paste as ST, then rename) while successful, could raise too many impact issues on possible roles inherited, privs, and any underlying tables that get updated from a different interface.
... View more
03-01-2021
09:47 AM
|
0
|
5
|
2267
|
POST
|
Using Oracle 12c and ArcGIS 10.5.1 I’ve been having a bit of a time registering a few spatial views so my group can publish them to a Portal without having to copy the data over. Below is a parsed down example of one of the views, but the principle is still the same: create or replace view schema_x.this_specific_view as: select msv.objectid, msv.shape, msv.segment, msv.size_code, fsiz.install_status from schema_x.my_spatial_view msv, schema_y.feature_sizes fsiz where fsiz.segment = msv.segment and fsiz.size_code = msv.size_code and msv.shape is not null As a few notes: - schema_x.my_spatial_view is essentially made up of: schema_x.bus_table and schema_y.st_geom_features - schema_x and schema_y have grants on each other - the views in question meet the checklist of stuff that ESRI has for views (objectID properly formatted, shape, no missing data, etc) I’ve re-registered schema_y.st_geom_features so they now appear in sde.gdb_items as well as the other sde.layers and related registry tables I’m getting the following phenomena when trying to register this_specific_view: - whacky extent (defined properly in my_spatial_view, but 99990000000000000 upon trying to register this_specific_view - since ArcMap doesn’t let you set the extent of a view and the extent of the underlying spatial data is correct, I’m a bit at a loss as to why this is happening or how to properly correct it) - the view fails to register and returns an ORA 3113 error as well as the ESRI 999999 error (Registration not supported) message. Trace files and core dumps return some parse errors, but nothing that makes any sense (this is from both my and an experienced DBA’s opinons). - when I’ve made a copy of the schema_y features in schema_x (including an alternate spatial view), no problems in registering … which makes no sense to me since both schema have grants on each other We have a registered Geodatabase with our test Portal where these are in. The goal being to be able to publish these and others without having to copy the data. This (and a couple of others like it) are the only ones that I’ve been having a bit of an issue with in resolving. I’m a bit at the end of my rope trying to figure out what could be the issue. Any suggestions would be welcome.
... View more
07-02-2020
05:21 PM
|
0
|
1
|
533
|
POST
|
The security at the place I work is a tad wonky and I'm still wrapping my head around Portal use vs Server. Basically the Services Directory is disabled for Portal and the Token generation route will not be acceptable for where I am, so if I wanted to get the REST endpoint for a feature through the Portal instead of the server, is there a way to do it (without exposing other feature layers/services)? Example: https://[server portal name]/server/rest/services/myPortalTest/portalTestFeatures/FeatureServer - returns Error 403 (Services Directory Disabled) https://[server portal name]/server/rest/services//myPortalTest/portalTestFeatures/MapServer?f=jsapi - returns layers (2 in my sample deploy) So, if I wanted to grab just the first layer https://[server portal name]/server/rest/services//myPortalTest/portalTestFeatures/MapServer/0 or the 2nd layer (../MapServer/1) it gives me a 403 error and I'm trying to see if there's a specific way to get that via Portal with the Services Directory disabled and without being able to generate a token Bart
... View more
08-12-2019
07:45 AM
|
0
|
0
|
388
|
POST
|
Robert, That's along the lines of what I was trying to do. I'm needing to add the points to a list which I was going to put below where the green pin marker was located. From there, they would have the option to remove individual ones or clear the list. Bart
... View more
07-10-2019
01:28 PM
|
0
|
2
|
993
|
Online Status |
Offline
|
Date Last Visited |
12-14-2023
05:17 PM
|