Latest Contributions by User35489

Greetings All, I have a folder containing various Layer files, Vector and Raster. Vector layers are connecting to SDE through Application Server Connect. I want to write a script which help me identify Vector Layers from folder and change their connection from 'Application Server' type to 'Direct Connect' Can you please help me with the best way i can change their connection type from 'Application Server' type to 'Direct Connect' Environment: ArcGIS 10.1/10.3 Desktop, ArcSDE 10.1, RHEL 6, Oracle 11g With Best Regards -AS ... View more

Greetings, In our company ArcGIS Desktop Users have tens of mxd's with saved user credentials. To follow our company standards, users need to change their passwords once in 3 months. For large number of ArcGIS Desktop users it is very difficult to open all MXD's(containing SDE and/or ArcGIS Server connections) and update the passwords. Due to this users end up with locked database account except those who dont save their credentials in document. Please share the best practices for this scenario. Our Environment: ArcSDE 10.1, RHEL 6, ArcGIS Desktop 10.1 & 10.3, Oracle 11g2 Thanks -AS ... View more

Greetings All, My Environment: ArcSDE 10.1, Linux RHEL 6, Oracle 11g2 In our environment we have a two corporate databases Database1(non-spatial) and Database 2(geodatabase). Database 1(non-spatial) has a table TAB1 with geometry column and it gets continiously updated. I want to create a spatially enabled view in DATABASE2(geodatabase) of this table to get updates simultaneously to our GIS users using Database2(geodatabase). Please help me with the best way to do this. My Homework: In DATABASE2 .. I created oracle view .. registered it as layer, but it failed to draw geography in ArcMap with message"Spatial Index needed". It once again failed when i tried to create spatial index on the view. Thanks -AS ... View more

It would be extremely useful for geodatabase administrators to add a mechanism which keeps information about unsuccessful login attemps made towards geodatabase. This feature or mechanism would obviously play a vital role in geodatabase security. ... View more

Greetings, My Environment: ArcSDE 10.1, RHEL 6, Oracle 11g We changed a password on an Oracle schema, but apparently we have some rogue SDE clients - probably old ArcGIS map services or map documents somewhere - attempting to connect with the old password. SDE is causing Oracle to lock out the schema because of the rapidfire attempts to connect with the bad password. I found that Oracle audit always trace SDE server name as it is unable to see the underneath connections of SDE application server. Is there any way to detect where the bad login attempts are coming from? My Environment: ArcSDE 10.1, RHEL 6, Oracle 11g Thanks ... View more

Greetings All, I am trying to grant a Layer access to a Database Role through ArcCatalog --> Rt. Click Layer --> Privileges --> Add..... But to my surprise i cannot see all the roles available in database. I can see all the users/schemas present in database and i can see few roles. I cannot see all roles present in database. Can you please shed some light on this issue? Environment: ArcSDE 10.1 SP1, Oracle 11g, ArcGIS Desktop 10.1 SP1 / ArcGIS Desktop 10.3 Thanks --AS ... View more

Greetings, I am using ArcMAP 10.1 SP1 and when i try to open/drag topology from File Geodatabase in ArcMAP, it crashes. Can any one please shed some ligh on this issue about how to overcome this issue in ArcMAP 10.1 SP1. Note: However, This issue has been addressed in 10.2 version NIM086831 Adding a Topology containing all particpating feature classes crashes ArcMap. Thanks in advance -AS ... View more