Latest Contributions by MarcoBoeringa

I have granted all the privileges to the sde user...those on the list, and everything else, for the test only. Now I cannot even connect, so I must restore the gdb from backup. Should I maybe have done this as a SYS or SYSTEM user? What should be my next steps? Tnx. M. Have you checked the temporary tablespace settings, as per the Oracle links I linked in the last post? Restoring your geodatabase from backup, and contacting ESRI Tech support to guide you through the upgrade is probably the wisest thing at this point. You have a triple set of "upgrades" going on: geodatabase version, oracle version and switch from 32bit to 64bit database. That means a lot of details and points where it may go wrong. ... View more

It seems you aren't able to edit the DBTUNE table using the account with which you logged in. You might check if this is the case with the tools in the database. Do you have Insert and Update rights on the table. This Help page also mentions to ensure the ArcSDE administrator has sufficient permissions to do the upgrade (unfortunately, on it isn't mentioned which ones. Undoubtedly documented somewhere else...): "Grant the ArcSDE administrator the permissions necessary to upgrade a geodatabase." OK, I think they are listed here: User permissions for geodatabases in Oracle http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002n0000002v000000 Probably wise to contact Tech support like Vince suggested, but here are two links concerning the Oracle error code: https://forums.oracle.com/forums/thread.jspa?threadID=969107 http://neeraj-dba.blogspot.nl/2011/04/ora-25153-temporary-tablespace-is-empty.html ... View more

Your question is so generic, that I think most people will have a hard time answering it. There's plenty to suggest, but I think you should do better to start thinking about what it is you want to do with your current setup, and read technical and marketing documentation by ESRI to get some feeling of what is possible, e.g. read the pages under "Products" and for example "Business Analyst", "Production Mapping", "ArcGIS for Aviation", "ArcGIS for Maritime" etc. depending on your organizations main focus. Anyway, for a more detailed technical insight into ArcSDE Technology, you may find this recent document by myself, posted in another thread, interesting to read. "The ESRI Geodatabase Framework" ... View more

Now I keep getting error that states that the app cannot load libraries. Found this: http://support.esri.com/en/knowledgebase/techarticles/detail/36510 It opposes your suggestion, but I tried it also, also no result... Any other suggestions? Thanks a lot. Regards, M. Since you seem to correctly have installed the 32bit version of the Oracle Client on the new machine with ArcGIS for Desktop from which you are trying to upgrade the geodatabase (at least you mention installing 32bit in your first post), I don't think this issue is related to your problems. This issue happens when you install a 64bit version of Oracle Client. ArcGIS for Desktop can not use a 64bit database client (ArcGIS for Server and the ArcSDE Application Server can). Again, I think this is unrelated. I think your main issue is that, according to the ESRI documentation in this Help page, you need to upgrade the geodatabase on the existing machine first (in your case your 9.2 production server). It must be upgraded to a 32bit Oracle database, ArcGIS 10.0 SP5 install. After that, you can migrate the upgraded geodatabase to the new server with 64bit Oracle and also ArcGIS 10.0 SP5 geodatabase. You did not do this, you moved the existing 9.2 geodatabase to the new 64bit Oracle database server, and than attempted to upgrade to 10.0 SP5 using the ArcGIS 10.0 SP5 installed on the new server. Again, if I understand the Help page well, you will need down time for maintenance on your production server to do the upgrade, unless you are able to create a second, temporary, identical 9.2 server with a copy of the Oracle 32bit database, to do the upgrade to 10.0 SP5 there. You could than migrate the data to the new 64bit server from there, and migrate somehow any data changes on your production server to the new 10.0 SP5 geodatabase on the new server. ... View more

Have you edited the PATH environment variable as referred to on this Help page?: http://resources.arcgis.com/en/help/main/10.1/index.html#//002n00000038000000 Also check your connection properties against the options listed for the Instance string in Oracle on this page: http://resources.arcgis.com/en/help/main/10.1/index.html#/Database_connections_in_ArcGIS_for_Desktop/019v00000003000000/ And check all steps listed here in the 10.0 Help about upgrading: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002n000000p0000000 Also, there are some caveats to take notice of when doing an upgrade from a 32bit to 64bit Oracle version in the same process. See this Help page. To be honest, you may wish to call in ESRI support for an upgrade like this... and it may even not be possible without temporarily making your production database unavailable for maintenance to allow an upgrade of the geodatabase there, if I understand the instructions well on this Help page: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Migrating_to_ArcSDE_64_bit_on_Windows_when_the_existing_DBMS_is_32_bit/002n000000q0000000/ ... View more

I think your issue is with the entry of the "serviceName". Unless you modified the Windows services file on your client PC to supply the corresponding TCP/IP number, you will not be able to connect by entering a service name (for some details regarding editing the services file, see this Help page). You may try entering the port number instead. In a default installation of ArcSDE, the port number is 5151, so enter that instead of "ssss.sss.sss.sss.au" ? OR "MyEDB" (database?) It should allow you to connect without specifying the service name. In addition, it is better to include the file extension "*.sde" to the name of the connection file, so "myConn.sde". An introduction to setting up and connecting too an Application Server can be found in this ESRI Australia blog article: http://esriaustraliatechblog.wordpress.com/2012/09/27/creating-an-arcsde-service-on-windows-using-arcgis-10-1/ All of this assumes you have an ArcSDE Application Server running on a server, and don't attempt to connect via Direct Connect, for which the "Create ArcSDE Connection File" tool is not meant to be used. If you are not familiar with the distinction between Direct Connect and an ArcSDE Application Server, you may also wish to read the document I recently posted in another thread: http://forums.arcgis.com/threads/83644-quot-The-ESRI-Geodatabase-Framework-quot-PDF ... View more

3) Contact Esri Tech Support (these Forums are not Tech Support). - V Agree. Marco ... View more

You need to create a new layer (schapefile) first. But if you have no experience at all using any form of GIS, I really recommend you to start reading some QGIS documentation first. Since QGIS is not an ESRI product, you are also better of asking questions on another dedicated QGIS forum, or a more general GIS forum like http://gis.stackexchange.com/ ... View more

According to this Help page, 51 is just a generic error code generated when ArcSDE doesn't recognize the DBMS error. Have you checked the logs as in the Help text?: "Underlying DBMS error (-51) An error was returned from the database that was not recognized by ArcSDE or the client application. Check the DBMS logs for more information." It is probably a completely unsupported operation by ESRI, but since it only affects two layers and it seems to concern orphaned rows "referencing non-existent states", you might consider joining the SDE_states system table to the A and D tables (User1.A172 etc.) that have the orphaned rows. This will quickly tell you which rows are orphaned, as there will be no join results from the SDE_states table for those records in the A and D tables that are orphaned. You could than delete those, or maybe even better copy them first to another table for reference and examining to make sure nothing important is lost upon delete. *** EDIT ***: Only do the above if your Feature Classes do not participate in any geodatabase behavior (e.g. no relationship classes, topology, network dataset etc. defined), so Simple Feature layers only. Otherwise the layers and A and D tables may, or better said will, have relationships and dependencies on other tables and Feature Classes, and that may cause additional issues. Backup the database beforehand. ... View more

Many thanks guys for the help, All what I did is giving the user �??never notify�?� property in the user account control (UAC). And it did work. I could edit the applications [ATTACH=CONFIG]24048[/ATTACH] What do you think? Best Jamal "Never notify" means that you also will no longer receive messages when any malicious software attempts to make changes to your server. Making a more "surgical" change by following the instructions in the link posted by PietaS175 and only allow the minimum necessary to solve your issue is a more appropriate action if you like to follow "best practices". ... View more

Problem: There will be 10 field guys with laptops with a stripped down ArcGIS on it. They will click on a point (Pole) and a access database form will appear with nested (relationships?) form for the field guys to fill out. The updating features, all the poles are GPS located in the database and have a xy and pole number. This inventory system will have the field crew out and they will fill in the data asked on the nested form. This data will be "new data" added to access columns and selected from drop downs on the forms. Sometimes, the forms will already have data such as "last maintenance" and the field will be updated with the current date. The current data is in a SQL geodatabase. Do I understand it right you are using a Microsoft Access database as a fore front to a SQL Server enterprise database, and call these Access forms from a custom ArcGIS Engine application? To be honest, if so, this might be a better question to pose on a Microsoft Access/SQL Server forum. I don't think to many people here have dealt with this specific setup and will be able to answer this Access specific question. Thanks for your response. I know how to make drop downs, but need nested drop downs. For example, we want logical drop downs, when selecting a utility pole, if you select a wood pole it will give you the wood pole manufacturers and not the metal pole manufacturers and so on. This specific requirement sounds like you want Geodatabase subtypes with their own domains. Start looking into that: A quick tour of subtypes ... View more

Besides installing SP1 for 10.1, there is also a patch you probably want to install. Although you didn't mention it, I assume you are running SQL Server based on the "DBO" type error. It is always good practice to mention all the details of the platform you are working with here on the forums. There is a patch for 10.1 that adresses an issue with replication: ArcGIS 10.1 SP1 for (Desktop, Engine, Server) SQL Server 2012 Support Patch http://support.esri.com/en/downloads/patches-servicepacks/view/productid/160/metaid/1954 The issue described is not yours, but might be related. Can't hurt to install the patch. ... View more

I'm am trying to create new replicas for our new 10.1 Geodatabase. All data is registered as versioned and I have added Global ID's. I am creating a One Way Parent to Child Replica....Register Existing Data only.... I keep getting this error: Create Replica Failed                                      The item was not found                                      Version not found [DBO.sync__send_593_0] (the number changes everytime) Any suggestions?? Was this database upgraded from an earlier versions of ArcGIS? I do see a couple of known and fixed issues listed with the same "Version not found" error on the ESRI website concerning replication: Bug:  Upgrading geodatabases with replicas to version 10 causes the synchronization process to fail ArcGIS 10.0 (Desktop, Engine, Server) Geodatabase Replication Upgrade Patch It may be time to call ESRI technical support... Anyway, maybe this Forum thread is of some help: http://forums.arcgis.com/threads/44790-Synchronize-Replica-Failed-Version-not-found-issue And maybe this is of some help, see the text below from this help page with error messages from ArcSDE: Version not found (-126) "The specified geodatabase version does not exist for this geodatabase. Be sure the geodatabase version you specified is valid for the geodatabase to which you are connecting. This is most often encountered when connecting to a dbo-schema geodatabase in SQL Server. In these geodatabases, the DEFAULT version is owned by dbo, not sde; therefore, to connect to the default version, you must specify dbo.DEFAULT." Is your parent database DBO owned (are the SDE system tables in the DBO schema)? ... View more

I think the length and complexity of this thread make a VERY good case for someone overhauling BOTH the ArcSDE and ArcGIS Server installation documentation. Well, it isn't an overhaul, but I now published a document describing "The ESRI Geodatabase Framework" (as I call it and see it) in another forum thread. It may be a good read for people interested in the contents of this thread and help out with a better understanding of 2-tier Direct Connect and 3-tier Application Server connections to geodatabases: "The ESRI Geodatabase Framework" PDF Please post any comments to the document in that thread and not here. Marco ... View more

This was finally the trick - I didn't realize that the -r -v combos were actually the type of thing being modified and then the actual entry.  I couldn't make sense of that in the instructions anywhere.  So once we figured out that you could only run one combo of -r and -v that did the trick, but we had to do both, one for the database name, another for the User.  Thanks. Good to hear you got it running. I admit the examples given in the Help page I linked, although this page gives a quite comprehensive overview of the actual "sdeservice" command and all its options, aren't the best. The examples and the way they are represented, are confusing. Marco ... View more