Latest Contributions by BirajaNayak

‎08-03-2016

Hi Saroj, You can check the following steps to append data from Excel sheet to feature class: 1. In ArcMAP, Add data > Browse to the excel sheet > Add the excel in the ArcMap. 2. Right click on the excel from table of content > Display XY data > An "event layer" will be created. 3. Geoprocessing > ArcToolbox > Data Management toolbox > General > Append 4. Input Dataset : Event layer that created in step 2. 5. Target Dataset : Feature class that you want to append 6. Schema Type : No_Test 7. Field map : Right click on the fields and map it to the excel fields. 8. OK Here are some links that you can follow- Append: http://desktop.arcgis.com/en/desktop/latest/tools/data-management-toolbox/append.htm Understanding how to use Microsoft Excel files in ArcGIS: http://desktop.arcgis.com/en/desktop/latest/manage-data/tables/understanding-how-to-use-microsoft-excel-files-in-arcgis.htm Thanks, Biraja

‎08-03-2016

As per article, query is as per below: SELECT OWNER, NAME, TYPE FROM DBA_DEPENDENCIES WHERE REFERENCED_OWNER='MDSYS' AND REFERENCED_NA ME = 'ST_GEOMETRY' AND REFERENCED_TYPE = 'TYPE' AND TYPE='TABLE'; Please run the above query as it is using "sys" login. This may help. Thanks, Biraja

‎08-02-2016

Hi Randy, When you upgrade geodatabase and sqlserver, views are created in 10.2.2 will be intact. No need to recreate those views. Mxd will have same view and joins/relates remain same with those existing views. Thanks, Biraja

‎08-02-2016

If the issue still reproducible, then please log a support case with ESRI to troubleshoot the issue.

‎08-02-2016

Hi Joseph, Have you checked "versioned view" option to get all edits from A and D table. This may help. Regarding identify tool in query layer, that should work. Please contact ESRI support to look into it at your end to troubleshoot the issue. Thanks, Biraja

‎08-01-2016

Hi APA, As you can not rename geodatabase name to access by SDE, hence I suggested to create another sqlserver instance and create same name geodatabase in UAT. So basically UAT will have 2 separate sqlserver instance and one has UAT instance and another will have production copy geodatabase. Thanks, Biraja

‎08-01-2016

This looks like known issue. BUG-000093032 : ‘Create Role’ tool fails with ‘Error Creating Role’ error for SQL Server geodatabases at 10.4 NIM102049: Unable to revoke database roles from SQL Server 2012 users using the Create Role geoprocessing tool or arcpy.CreateRole_management. What is the ArcGIS Desktop Version you are using.

‎08-01-2016

Hi APA, In that case, create a new sqlserver instance in UAT and restore backup from production or copy data using sqlserver tools. Thanks, Biraja

‎08-01-2016

Hi APA, Can you please elaborate the requirement. When you say refresh data from production to UAT, do you mean update everyday edits from production to UAT. If that is the requirement then Jake already provided solution using Geodatabase Replication. Thanks, Biraja

‎08-01-2016

Hi Joseph, How you are creating view in 10.4. Please provide detail workflow including script used, Have you tried creating view using geoprocessing tool called "create database view". Regarding query layer, how you are creating query layer and what is the error message. Thanks, Biraja

‎07-08-2016

After closing/stopping all client application accessing geodatabase, if you still find connections are present in process_information table of sde schema then those are orphan connections. You can just truncate the table to clear it. If you find these orphan connections very often then you need to monitor your ArcGIS workflow or any network drop. - Biraja

‎07-08-2016

You can take a look at the following procedure which generally we follow on testing environment: 1. Drop all user except sde with cascade option 2. Drop sde user with cascade option 3. Recreate all users including sde 4. Grant required permission 5. Reload the data by imp or impdp - import sde schema 6. Import remaining schema. Hope this helps. - Biraja

‎05-27-2016

It is difficult to say what is happening at your end during edit. You can log a support call to analyze the issue better. Few suggestion you can try: 1. Save edits and come out of ArcMAP or any other client accessing and editing data. 2. Make sure no orphan connection or orphan locks 3. Compress the geodatabase to state_id 0 4. start edit again Please note that suggested version editing workflow is to create child version of default as QC/QA version and from QA version create editor versions to edit. This will help you avoid any data loss as you mentioned and also have better management of data quality. This is just a suggestion.

‎05-26-2016

Hi Link, How and what you are updating programmatically. If the feature class are not registered with version, you are good to go by just removing user and locks. If the feature class is registered as version, then you need to consider version view or compress geodatabase to state_id 0 before updating. Thanks, Biraja

‎05-26-2016

Another question is to understand your overall requirement so that we can suggest if there is any better approach to it. Please explain your holistic requirement and will go from there.

Online Status	Offline
Date Last Visited	a month ago

My Ideas

Latest Contributions by BirajaNayak

Re: Database table in SQL Server

Re: Create Enterprise Geodatabase failure: Failed to setup st_geometry type.Failed to create the ST_Geometry metadata tables during install.

Re: Converting from SDE Command Line Views to SQL Server Views (Do MXDs need to be modified?)

Re: Enable Enterprise GDB Failed

Re: Identify Fails w/ Oracle Database Views

Re: Refresh SQL Server Database

Re: Can someone please tell me why create role doesn't work?

Re: Refresh SQL Server Database

Re: Refresh SQL Server Database

Re: Identify Fails w/ Oracle Database Views

Re: Multiple connections from one machine to a single database

Re: Cant Delete ArcSDE ORACLE

Re: Unable to reconcile: the target version is currently being reconciled against

Re: When is it safe to disconnect an active session from an enterprise geodatabase?

Re: Is there a way to copy a Enterprise Geodatabase (SDE) to another remote location with out shutting down the database.

Re: sql view error in Pro

Re: Enable Enterprise GDB Failed

Re: GeoData replication to lower EGDB version?

Re: How to Configure ArcSDE on PostgreSQL 10 and h...

Re: Versioning toolbar Refresh button doesn't pull...