Latest Contributions by MarcoBoeringa

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

Seems to me it is time for that phone call to your ESRI representative to request the correct 10.0 Enterprise Standard key you need to get it up and running... ... View more

Could I use the 10.1 licenses, or must I request new ones?! Good question, I can't tell. Codes may be - and likely are - tight to specific versions, but only a phone call to ESRI could tell. Clearly, the 9.2 code doesn't work with 10.0, so it probably is version tight and you may need to request a new one. I don't think it would hurt though to run a SQL UPDATE statement and replace "101" with "100". In addition, if the *.ecp file is text, you might even edit that, and run it through the authorization process in the modified form. At worst, you replaced a bad key with another bad and non functional key. Could this be the cause of my trouble!? Well, having "101" where the authorization software maybe expects to read "100", is probably not going to help, although I am not sure if the authorization software even cares to process the ecp file to extract these individual values, or simply tries to run an UPDATE statement against the database (that somehow inexplicably fails than). ... View more

Still no results. Cannot create a direct connection, nor authenticate. If, like seems the case here based on your SQL query result, the key still references the old 9.2 one, it isn't strange you can't connect. Does the authentication for v10 write the key to the registry, or into a table in the database (like 9.2, that writes into SDE.SERVER_CONFIG, if I am correct?) ? I think you answered this yourself by extracting it from the database using the SQL statement Vince supplied. It is clearly stored in the Server_Config table. I don't know if there is a secondary storage in registry, Vince undoubtedly can tell, but it seems highly unlikely to me to have dual storage here for an option like this. If it writes to the registry, maybe I could create a registry key with the contents of the .ecp file I received from ESRI? I think your better shot at this would be to use a SQL UPDATE statement to update the contents of the Server_Config table with the contents of the *.ecp file. E.g. I expect it to look something like this: 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'; I am not sure if the "none" is also included with full ArcSDE server licences, or replaced by something else, but my ArcSDE Personal licence that came with my ArcGIS for Home Use licence, displays "none" in between the ecp code and the final code if I look inside the table in SQL Server Management Studio. And yes, all values are concatenated in one comma separated string. EDIT: I see the "None" is also included in the screenshot you posted of the faulty 9.2 authorization key in the Server_Config table of your installation, so it is also included with full ArcSDE server licences, so you can probably run the statement like above. ... View more

Yes, that was the first thing I did, when the direct connect failed. It works with sqlplus, but in ArcCatalog, it gives me a general error message (Operation failed). I have found in some forum, that the authentication error like this happens when a database name is changed, and I did change it...Now I will try to delete the database, and create a new 11g db, with the sam name as the 10g I did the upgrade and export from. I will post results. Tnx, M. Milo, Vince clearly stated in another thread that changing database names is NOT supported on geodatabases. This is because the database name is included in vital stored procedures and triggers etc. in the ArcSDE Repository. So yes, ensure the database name of the new instance is exactly the same as the old one. ... View more