Latest Contributions by MarcoBoeringa

Think of something like a Point and Polyline Feature Class, one representing valves, the other pipes from a pipeline. You add them to a "Geometric Network", and than start editing the network. You move the valve (original Point Feature Class), and the attached Pipes move with it. Or you determine which endpoints in the utility network will be affected by shutting down this valve. This kind of "behavior" requires all kinds of relationships and constraints in the DBMS and in ArcMap to be maintained automatically. That is "behavior" in the context of geodatabases. You don't really "set it", you create it automatically once you define and start using those special complex datatypes like Geometric Networks, Network Datasets, Parcel Fabrics and so on... ... View more

I have contacted the local ESRI dealer, and they will come to assistance today, since they are but busy... ... It seems that now everything works... I have copied everything, and all the data is now on Oracle 11g under SDE 10 SP5. Seems to me it's just going to be coffee and tea with ESRI... 😉 Anyway, may not be a bad thing to have just one last "check-up" on the finished work by someone with a fresh look on it and able to assist you directly versus "remote"... Thanks to you guys, your suggestions saved me. P.S. If I run into more troubles, I'll come back 🙂 You're welcome, and let us know the final outcome! ... View more

It seems that we think alike, Vince 🙂 I didn't give up, instead I decided to follow this manual: 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/ I deleted the geodatabase, created a new one, empty, and installed ArcSDE from the scratch...created the repository, user and voila....the authorization passed without a glitch. So it wasn't the license code... Then, I created the service, started also without problems. Good to hear you finally managed to make headway and get it running! 🙂 But hey, didn't I point out that Help link before to you?!! :confused: ... ;););) Everything went well, with minor stops because of the relationship classes and extensions, privileges, roles creation etc...but now I get the error in the attach, and do not know what it is: [ATTACH=CONFIG]24308[/ATTACH] Any ideas? Tnx, M. Can you provide some more context to this. Is "UTARC" a Feature Class or Stand-alone Table in the original 9.2 geodatabase? And is there a field called "CO_C_JOINT_TYPE" in the attribute table? Is this UTARC table potentially from another business system, registered with the geodatabase but not initially created by ArcGIS? I think you mentioned this whole database involved an Utility Extension? Have you thought of installing that on the new server and client PCs, so that ArcGIS knows about specific custom objects added to the geodatabase base model? ... View more

So, as the things are going badly, this is how it is going to be: Since the ArcGIS Desktop is here used as a base form some Utillity Extension, I will create a new empty gdb, create new SDE user and repository, and use the extensions tools to export/upgrade the data and then bulk load it back to the ArcSDE. I do not see any other solution. ... I just give up, since I have an alternative...not a better one, but an usable one. Milos, Sorry to hear that, but you are probably right it is now the best way to go. I am out of ideas of helping you "remotely"... If you can solve your issues this way, than by all means go for it and don't waste any more time on the impossible "upgrade path". There is something very wrong in the way upgrades are ment to be performed, or in the software configuration that was asked from the extension manufacturer, or maybe in the position of the stars for the past two weeks that I have lost doing this. 🙂 Yeh, I guess the stars didn't align up well... 😉 Good luck with rebuilding and loading the data. Marco ... View more

Can't say if this is the issue, but you're not working on the officially supported release with 9.2.4. Higher release numbers may, or may not, work. Usually, it is best to stick with the ESRI recommended environments. See this Help page: PostgreSQL database requirements for ArcGIS 10.1 ... View more

Milo, Have you ever tried to run the post installation with the specific right-click menu option "Run as Administrator"? It may be a long shot, but sometimes, even when your logged on as Administrator, you still need "Run as Administrator" to get something to work, especially with legacy software. Marco ... View more

Milo, now you seem to have valid 10.0 licence keys, maybe trying to manually update the keys in the "server_config" table using: sqlplus sde/password@instance UPDATE server_config SET char_prop_value='arcsdeserver,100,ecpYOUR_ArcSDE10_CODE,none,YOUR_ArcSDE10_CODE' WHERE prop_name = 'AUTH_KEY'; might be an option. I hope Vince can confirm this as a valid operation or not. ... View more

That was my reply. The file contains the line that starts with arcsdeserver, only it is not a new line, but it only continues the line end of the previous feature (eg. svrstandard,100,ecp....arcsdeserver,100,ecp....). Sorry, overlooked that one, you had confirmed it before. This thread is starting to become a bit long. I have asked them to give me the credentials, but they refused saying it will lead me to them again... Weird, I only have an ArcGIS for Home Use licence currently available with ArcSDE Personal, and I can simply login using my ESRI Global Account credentials. Even better, if I am already logged in here on the Forums using my Global Account, and switch to Customer Care, it automatically detects me and allows access. It gives me access to all the downloads and licencing information for my Home Use licence, I downloaded 10.1 from there without issue. I guess it won't be different for big enterprise clients... Are you the only one involved in the ESRI licencing at your organization, and the only one having a Global Account? What annoys me the most is that I cannot do a direct connect... Through sqlplus it works from several machines, but through arccatalog it does not...I tried one more machine, but it will not connect the damn thing. If the licence process is not successfully finished, I think that is no surprise. One thing though: are you absolutely sure you are using the right 32-bit Oracle Client when connecting? If ArcGIS somehow tries to use any 64-bit Oracle Client libraries to connect, it will fail. ArcGIS for Desktop is 32-bit and needs the 32-bit Oracle Client. Uninstall any 64-bit Oracle Client libraries if necessary to be sure it doesn't interfere (Leave them on the server, as ArcGIS for Server is 64-bit). ... View more

Yes, I have asked them to check version they gave me with the licenses. They say it is ok... I have reinstalled the server, Installed everything from the start, and still cannot do a direct connect. Also, the license update will not pass no matter what I try. The errors are all the same... This is useless! M. Milo, you have not answered Vince's question that will also answer whether your ESRI representatives are right with "...it is ok...": See this text by Vince in one of the post above: "Does the new license file have a line that starts with "arcsdeserver,100"? What tool are you using to apply the new license? (Hint: It should be "sdesetup -o update_key", and the binary should be from an SP5-patched ArcSDE 10.0 Oracle 11g 64-bit SDEHOME)" If your licence file doesn't start with the arcsdeserver,100, it is almost a certainty they gave you the wrong licence files, no matter what they are saying to you. Again, if you do get the credentials for the Customer Care portal, you no longer rely on your local representatives, you can than access your downloads and licences directly (if they are properly registered at ESRI USA). ... View more

Marco, I looked at my install DVD and could not find the installation of SQL Server Express, only ArcSDE for SQL Server... Does this mean, that I have the Enterprise DVD? M. I can't say for sure, but it looks like it. Although this error message you posted still bothers me: ArcSdeServer license not found in license file(-8001). Error reading license information Error: (-8001) You are not licensed for SdeWorkGroup.. As you correctly wondered, why this error about SdeWorkGroup? Anyway, have you now requested the proper licence files from ESRI? ... View more

Also, on my question, is the CD they gave me Enterprise or Workgroup, they said : "That is the only SDE install CD we have, so it must be correct. " 🙂 🙂 😞 Well, actually, I don't know if there are actually any differences in installation, so they might be right in the end. To be honest, it is quite a while I had to install ArcSDE myself. Yes, the log had no errors or warnings and it said that it finished succesfully. Also I tried to connect using ArcCatalog 9.2 and it said that it cannot access the later ArcSDE from an older release of ArcCatalog (or something like that). And the old server SDE service cannot start, so I think that the upgrade went ok. It sounds so... I think you may be OK as far as the geodatabase upgrade concerns. That still leaves you with the question to get valid licence files. If the files are wrong, nothing you do or we suggest will help and you really do need to get new *.ecp licence files for your 10.0 ArcSDE Enterprise Standard licence. P.S. On this page: http://www.esri.com/software/arcgis/arcgisserver/features/enterprise-workgroup it says (note this is 10.1, but I guess this hasn't changed), that Workgroup edition ArcGIS for Server comes shipped with SQL Server Express 2008 R2, limited to 10GB databases. Was that installation included on your DVDs? Might be an indication as to what installation you have. ... View more

I do think contacting your ESRI representative to find out if you have the right licence files and ArcSDE installation, and getting them if not, is now important. Also find out the Customer Care login so you can see what is there, maybe you can download the right install there. If not, you are not properly registered at ESRI and your ESRI representative should change that. ... View more

@Marco: I don't have the username and password for customer care... Than I recommend you to get those. I guess your ESRI representative should be able to give them without issues. It could well be that you, as I presume you are the geodatabase administrator, are already registered for the Customer Care portal. Otherwise someone else at your organization who is responsible for buying the licences of ArcGIS. P.S. How do I find out which version of SDE is installed (workgroup, Enterprise... ) ? P.P.S. I am thinking just now and this came to me: I don't know. Maybe you can find it in the Windows Registry, Vince undoubtedly has better instructions. I did the ArcSDE Geodatabase upgrade using a direct connection to the old 10g Oracle server from my new test server, through ArcCAtalog v10. But, I did not uninstall the old ArcSDE on the old server before I did the upgrade! Could this be a problem?! Well, according to the instructions here, you are supposed to uninstall the old ArcSDE before upgrading the geodatabase. But that is also a situation where you intend to install ArcSDE on the same machine again, whereas your situation is different: you want to install the upgraded geodatabase and ArcSDE on a different machine. Maybe, in your case, simply shutting down any running ArcSDE Application Server, is enough to allow a good upgrade of the geodatabase. And, as long as you don't attempt to run the old 9.2 AS again against the geodatabase, it might be good. I think you reported the upgrade finished well with no error? Might be an indication that the actual upgrade of the geodatabase tables / schema went well. Vince can probably give more specific input here. From the Help page: 12.Uninstall the old release of ArcSDE. See either Uninstalling ArcSDE from Windows or Uninstalling ArcSDE from Linux or UNIX for instructions. 13.In Windows, you are prompted to delete the ArcSDE services during the uninstallation process if any are running. Click Yes to delete the service if you are installing a new release of ArcSDE. If you are installing a service pack or patch, you can click No and reuse the service unless the service pack or patch instructions specify that you must re-create the service. (For example, if the service pack or patch fixes something in the service functionality, you most likely need to re-create it.) 14.Install the new release of ArcSDE. On Windows operating systems, do not run the Post Installation wizard. The Post Installation wizard is for new installations only. If installing ArcSDE 10 on Linux, apply service pack 1. ... View more

Got the 10.0 licenses, tried, and nothing changed. When I try to authorize using sdestup, I get this> ArcSdeServer license not found in license file(-8001). Error reading license information Error: (-8001) You are not licensed for SdeWorkGroup.. What does this mean? Is it possible that they gave me a wrong installation CD (Workgroup instead of Enterprise)? M. Might be, have you ever tried to log-in at the ESRI Customer Care portal? If you log in there with the proper credentials associated with your licences, there should be products available for download. You may be able to download the right version from there: http://customers.esri.com/ ... View more

This reminds me of one of my most bizarre client calls: "Do you remember installing ArcView four months ago?" "Yes." "We had a power outage, and now it isn't working.  Can you come fix it?" After confirming the license manager won't start: "What did you change?" "Nothing." An hour is spent working on the lm server... "You must have changed something!" "No, nothing." Two more hours thrashing against the lm server... "Are you sure you didn't change anything?" "Positive." Then someone else pipes up: "Well, there was the one change, but it was months ago..." Yup.  They edited the license file, changing all 3s to 1s, so they wouldn't use as many seats.  It took that long to find it because the license was only read on boot and, as a Unix box, the machine hadn't been rebooted in the intervening months.  And the license manager wasn't reporting an invalid key because they also changed the "3.0" LM version to an undefined "1.0". :D:D:D You cannot change anything in the license string without corrupting it. All the different elements (product, version, expiration,...) are encoded into the key. If anything is different, the key will not validate.  If the license is for the wrong release, contact Customer Service to get the proper license file. - V Yup, sure, that was what I expected, but since I am neither an ESRI employee knowing all the nitty gritty details like you, nor the one who's handling this problem directly and thus can only give "remote help", you sometimes have to poke a little before you finally get somewhere and find out what is wrong. As you discovered then too after hours... I hadn't really expected this to work. My last advice was to get that valid licence file from ESRI. Congrats by the way with your 2000th post here on the forums~! 😉 ... View more