Latest Contributions by NCSCMNCSCM

‎03-16-2020

Unable to execute Advanced Arcmap Settings, after installing ArcGIS Desktop 10.8, anyone have any idea to resolve

‎05-18-2015

Hi, While trying to create/paste a feature class in database( ArcSde) instance we are getting following error. Regards, Ramya

Re: user based schema geodatabase · ‎05-01-2015

Thanks for your response.as suggested please find the result of the query.

user based schema geodatabase · ‎05-01-2015

Hi, Have created user-schema geodatabase .while trying to shift from sde.DEFAULT version of the master sde geodatabase to user-schema geodatabase from the Schema drop-down list . am getting below attached error. Thanks Ramya

‎10-10-2014

How do I get the description returned instead of the value? In other words we are getting the value of 'MFT' but I would like returned 'Mudflat'. I can see in the REST directory that the all the info is there, I am just not sure how to display 'Mudflat' instead of 'MFT'. Any sample code or help would be greatly appreciated. Environment: Web map Server: ArcGIS Server 10.1 Service: REST API: Silverlight Operating System: Windows 7 SP1, Windows Server 2012 R2 Regards, Muruganandam

‎05-26-2014

Hi Crafty, Finally we brought our data's from rman backup, thanks for your help!!! Regards Muruganandam R

‎05-26-2014

Hi, Our problem got resolved after deleting the some of the feature name which exist in gdbitems table. Thanks for all to assist me Regards

‎05-02-2014

ArcSDE 10.1 for Oracle 11g Oracle database in both machine are same version too

‎05-02-2014

The process you described is something we follow as well, and it works fine for us. The error you showed suggests the absence or invalidity of a particular package which is part of the SDE schema. I am not sure why that is happening. However, one thing to note is that Oracle 11g R2 (11.2.0.1) is no longer supported beginning at ArcGIS 10.2.1. The 10.2 release of ArcGIS was the last supported release with your version of Oracle database. What is the ArcGIS version of your geodatabase? From what you posted initially, it looks like it could also be 10.2.1 in addition to your desktop software. Are both Oracle databases at the same Oracle release? ArcSDE 10.1 for Oracle 11g

‎05-02-2014

Yes, we were exporting the entire SDE Schema Hi Crafty, The actual problem we are facing is, In our organization, we need to take regular backup of the sde database from oracle server for disaster recovery. On test basis, I am trying to import the sde backup into the another machine, after importing I am unable to connect sde user in ArcCatalog and I am getting the earlier said error message. So, now I don't know whether I am following the right procedure or not, so, me the correct steps or command to export and import the sde datafiles. Regards Muruganandam

‎05-02-2014

Yes, you need to import the packages along with the data from the dump file before you can compile them. The privileges above for the SDE user are system privileges and can be granted before the dump file is imported, with the exception of the GRANT EXECUTE lines which need to be run after the import completes but before the compiles are done. I looked at your export command that you provided earlier and it seemed like you exported the entire SDE schema; but can you confirm that is the case? Yes, we were exporting the entire SDE Schema

‎05-01-2014

Hi Crafty, Thanks for your reply, we have granted all the necessary permission as per your code, but when we are trying to compile the SDE.pinfo_util, its through error message "Object Pinfo_util does not exist" For your reference, we have attached the error message. Note: we just grant the permission, we didnt import the dump file yet, kindly just us should we want import the dmp file and then need to compile?. Regards, Muruganandam

‎05-01-2014

We use IMP and EXP often to refresh the SDE schema and other user schemas for our 11g test databases. I think you have the syntax right, and it looks like you were able to export and import fine. The error looks to occur in ArcGIS Desktop. I would first suggest that you try recompiling any invalid objects then try again to connect. Run this in SQLplus as SYS user: EXEC DBMS_UTILITY.compile_schema(schema => 'SDE'); Post back with your results. Hi, Thanks for your reply.still we are facing same problem even after executing the above said command. Regards, Muruganandam Ncscm

‎04-30-2014

Hi, In our organization, system configuration for ArcSDE 10.2.1: Database: Oracle 11g versions:11.2.0.1 Operating System: Windows Server 2008 R2 SP1 ArcGIS for Desktop: 10.2.1 We were taking sde back-up using export command of oracle database "exp system/password file=filelocation.dmp full=y". After this, while we were trying to import the dmp file to the test machine (with same configuration as mentioned above), the following error occurs: "Error executing stored procedure sde.pinfo_util.get_sde_idORA-06508:PL/SQL: could not find program unit being called" (kindly see the attached error message) Before importing we were creating the user called sde with default tablespace SDE and temp tablespace, after creation of SDE user, we were using import command "imp system/password file=location fromuser=sde touser=sde" Kindly suggest whether we were using correct syntax or else let us know the correct procedures/steps to export and import the sde geodatabase from one machine to another. Thanks in advance Muruganandam R NCSCM

‎03-19-2014

Hi Crafty, We are using Win 7 SP1 Prof, today, my boys are left for the day, I will see the event log tomorrow and I will come back to you. Thanks for your reply. Hi Mousaem, Thanks for your reply, kindly clarify me, whether I need to check in the server path or in client machine temp path. Hi Karthi, Its nice to see one off my BARD guys is replying for my queries, I have downloaded the patch, I didn't apply, since some off editing is in midway, once completed I will take backup data and I will apply the patch.

Online Status	Offline
Date Last Visited	‎11-01-2023 01:32 PM

My Ideas

Latest Contributions by NCSCMNCSCM

Unable to execute Advanced Arcmap Settings

Database error

Re: user based schema geodatabase

user based schema geodatabase

Unable to retrive description in the coded value domain field from ArcGIS Sever 10.1 Silverlight API

Re: How to take backup of the SDE database and steps to export and import the databas

Re: ArcMap crashes, while saving the edits

Re: How to take backup of the SDE database and steps to export and import the databas

Re: How to take backup of the SDE database and steps to export and import the databas

Re: How to take backup of the SDE database and steps to export and import the databas

Re: How to take backup of the SDE database and steps to export and import the databas

Re: How to take backup of the SDE database and steps to export and import the databas

Re: How to take backup of the SDE database and steps to export and import the databas

How to take backup of the SDE database and steps to export and import the database

Re: ArcMap crashes, while saving the edits