Tag Info

Hot answers tagged

2

It looks like EZConnect can't connect for whatever reason (3a works/3b doesn't). You can try adding "ezconnect" to NAMES.DIRECTORY_PATH in the sqlnet.ora file. Hopefully that will make 3b from @Albert Godfrind's answer work. The LDAP connection may fail from QGIS because you have something like the Oracle Instant Client somewhere in the path before your ...


2

Those sort of issues can be hard to track. My approach would be to remove QGIS and SDE from the picture and make sure the connection works with plain Oracle tools. That will also help your IT support debug the issue. 1) Do: $ tnsping <tns_name> Does this work ? Or does it fail the same way 2) Do: $ tnsping ...


2

I think your proposed solution may be too complicated. I don't think there really is any such thing as a "non-spatial database". In my view, there's just data, some of which happens to have geometry, and some of which doesn't happen to have direct relationship to geometry (in the end, most data is at least somewhat spatial). Best practice for integration ...


2

Situations requiring edit sessions: Feature classes participating in a topology Feature classes participating in a geometric network Versioned datasets in ArcSDE geodatabases Some object and feature classes with class extensions I'd say you need to start an edit session, and save the edits before you do the append. The Editor class allows use of ...


2

You may use ListWorkspaces method (once you make the connection) to list the existing databases within SDE: Lists all of the workspaces within the set workspace. Search conditions can be specified for the workspace name and workspace type to limit the list that is returned. workspaces = arcpy.ListWorkspaces("*", "SDE") for workspace in ...


2

Yes, you will need to use the external procedure agent if you want to access the XML columns in the SDE.GDB_ITEMS_VW views. By default, the XML columns in the GDB_* tables are stored using ESRI's XML implementation. The functionality to convert these to a CLOB is included in the ST_Geometry library, which is accessed using the external procedure agent. ...


1

The answer which I found yesterday, and PolyGeo referenced in his comment above, was to use the full path to the sde instead of the relative path. I still don't understand why the IDLE GUI/shell can't use the relative path when the ArcMap python window can.


1

I don't think you can enable attachments more than once per feature class. The easiest way would be to have different feature classes for which attachments you want visible through the feature service.


1

ArcGIS is very sensitive to database names. You cannot restore data unless the database name is identical. You will need to use Feature Class to Feature Class or a copy/paste, or any of the other ways to copy data with Desktop or ArcPy (the list of options can be daunting). All transfers should be done as the data owner(s), not as the administrative 'sde' ...


1

You will need the sys password of that Oracle instance in order to run the create enterprise geodatabase. If you have another user with dba privileges you can run this to change the password: alter user sys identified by NEWPASSWORD; If you have a database administrator in your organization, they should have the sys password. Optionally, if you have an ...


1

Right click the layer and select "Properties..." to open the "Layer Properties" window. Select the "Source" tab and check to see if the "Geometry Type:" is "Multipoint" or a similar type of geometry. If so than there will be multiple points/polygons that correspond to one record and will result in the behavior you describe.


1

You can't have a service point at a different instance (or even user) depending on the connected user, but you could configure a proxy to point at different services. This would require N, N+1, or N+2 services for each logical service (depending on whether you have test and production requirements as well). You'd probably be better off with personal USER ...



Only top voted, non community-wiki answers of a minimum length are eligible