Latest Contributions by WilliamCraft

I agree with you.  This could very well be a bug, too.  At the very least, the step I provided to you should suffice to re-point your log output to the desired folder once installation is complete.  You may need to restart the ArcGIS for Server service in addition to what we discussed. ... View more

From reading your post, it feels like the issue clears up after some time... is that true?  Is there something specific that you're doing to force queries to work again the REST Admin application (i.e., restart ArcGIS for Server, recycle an IIS app pool, restart IIS, reboot the server, etc.) or does it seem to just fix itself randomly?  Are you positive that, prior to clicking the Query button in the REST Admin UI, the Start Time and End Time are empty or contain a valid value?  The only way I could reproduce the behavior you're describing is to actually input a value of 0 into both fields.  Otherwise, I'm able to query via the REST Admin application and the ArcGIS Server Manager application without issue.  [ATTACH=CONFIG]29782[/ATTACH] In case the issue is related to something specific within your environment, please download, install, and run Fiddler while reproducing this behavior.  Check to see if you are getting any errors when this occurs. ... View more

Per your results from step 3, please go ahead and run sdegdbrepair -o repair_tables -d ORACLE11G -V ALL (with the rest of your connection information).  Doing so should fix the issue uncovered with your A table.  Once complete, please perform another compress and let me know if records begin appearing in the base table as expected. ... View more

Are you using an RDBMS or local data (I.e., file GDB)?  If you have access to the SDE command tools and credentials to create a view at the RDBMS level (assuming you're using oracle or SQL Server) then you could use the SDETABLE  -O CREATE_VIEW command to generate a spatial view.  It's supported and may give faster performance depending on the amount of data you have joined.  The 10.0 help should still be applicable here: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002n000000t1000000 ... View more

Also you may wish to run SELECT * FROM SDE.COMPRESS_LOG ORDER BY START_TIME DESC to see if your compress is finishing or failing. ... View more

Please run SELECT * FROM SDE.VERSIONS to verify that SDE.DEFAULT is the only version.  Please also run SDEGDBREPAIR -O DIAGNOSE_TABLES -V ALL (refer to esri help for remainder of command) to check if there might be issues in your state lineage Please also run SDEGDBREPAIR -O DIAGNOSE_METADATA (refer to esri help for remainder of command) ... View more

I don't believe editing the contents of the second (or third, fourth, etc.) table is possible if a join exists.  That being said, what type of application are you using to consume the service and perform edits?  It is possible to edit RELATED tables using functionality available through the various web APIs (Sliverlight, Flex, Javascript).  You might need to develop a custom widget to modify the related records assuming that you put relationship classes in place within the geodatabase.  Alternative, I am wondering if it might be possible to publish your query layer to a map service and then subsequently publish the individual tables as part of a feature service with Editing capabilities enabled.  As an example to this, I have configured a few Flex applications which use the map service for specific operations like identify and search but use the feature service when the editing widget it activated.  I just grabbed the layer or table endpoint IDs from the REST application and plugged those into my various Flex configuration files. ... View more

1. Export layers\tables: Mr. Macro has indicated too that this property can�??t be set and thus all users who have �??select�?� property will be able to export layers. At the same time, my business requirement dectates to ban users from being able to export layers while they have other permission granted. 2. Create tables\layers on the enterprise geodatabase 3. Create domains on the enterprise geodatabase 4. Delete tables\layers: this property is set by default and thus all users are not able to delete tables\feature classes What might be the solution? 1. Any user who has access to an ArcGIS Desktop client (ArcMap, ArcCatalog) will be able to export the data if they have CONNECT and if they have SELECT privileges on the table in question.  As I mentioned before, if they can "see" the data then they can export it.  To prevent this, either don't give them an ArcGIS Desktop client or develop custom code to restrict specific menu options and buttons within the desktop suite of products based on the role of the user logging in.  You can do this with a custom login DLL, but it's a long road to get to this point.  2. To restrict users from creating tables within the geodatabase, ensure the users do not have the CREATE TABLE privilege.  As I mentioned before, I believe this can be achieved by the assigning only db_datareader role to the users.  3. Only geodatabase administrators should have the rights to create domains within the SQL Server geodatabase.  That being said, if a user only has the db_datareader role then that should prevent them from being able to do this.  Alternatively, simply revoking INSERT, UPDATE and DELETE on the SDE tables for a given user should also do the trick.  4. Similar to #2 above... to restrict users from deleting tables within the geodatabase, ensure the users do not have the DROP TABLE privilege.  As I mentioned before, I believe this can be achieved by the assigning only db_datareader role to the users. ... View more

Using ArcCatalog, create a connection to your ArcGIS Server as an Administrator and then right click it; then select Server Properties.  [ATTACH=CONFIG]29718[/ATTACH] Change the path specified under the Logs path and click Apply and OK. ... View more

What is annoying in the create replica of the �??distributed deodatabase too bar�?� is that all feature classes are required to be added to the table of contents to create a replica for them. I couldn't agree with you more, which is why I keep a saved map document handy in cases where I need to re-create a replica with the same data from time to time.  In terms of why the GP tool might be experiencing failures compared to the toolbar in ArcMap completing successfully, that might be a bit difficult to uncover.  Are you running the GP tool as part of a model or independently? ... View more

From the looks of it, your screenshots appear to represent an enterprise geodatabase stored in SQL Server.  You also appear to be using the DBO schema rather than the SDE schema.  Have a look at this Esri help resource to learn more about user permissions for SQL Server geodatabases: http://resources.arcgis.com/en/help/main/10.2/index.html#//002q0000002s000000 The level of permissions that a user has (u1, u2, etc.) within the database depends on what you grant to begin with.  Sometimes you may grant specific permissions such as GRANT INSERT, UPDATE, DELETE, SELECT to u1 on 'TABLE1'; additionally you may wish to simply assign a role to a particular user.  A role, such as 'db_owner' or 'db_datareader' has a predefined set of permissions associated with it that you should become familiar with before assigning them to user accounts.  These are called Fixed Database Roles, and here is a quick once-over article on what they include: http://msdn.microsoft.com/library/ms189612.aspx.  Think of the Fixed Database Roles as 'system permissions' and think of the specific grants I mentioned earlier as 'object permissions'.  So, getting back to your question, if you wish to "ban" other users from being able to perform specific operations you need to understand how the permissions work at the RDBMS level and act accordingly.  To prevent exporting of data, I think you would have to simply prevent a user from connecting at all.  It is my understanding that, if a user can see the data by being able to CONNECT and view a table via the ArcGIS Desktop tools, then that user can perform an export via ArcMap or ArcCatalog.  Modifying domains usually requires administrative privileges to the geodatabase.  I believe this would require the DBO user itself or any user who is assigned the 'db_owner' role.  The ability to create a feature class would require CREATE TABLE, CREATE PROCEDURE, and CREATE VIEW permissions.  I believe the 'db_owner' role would suffice here as well based on the two URLs I provided. ... View more

I believe you would want your native client version to match the version of your server's database.  Please try to upgrade the client (either 32 or 64 bit) to match the server and let me know if this resolves the issue. ... View more

According to Microsoft this could be a bug based on what you may be trying to do.  A such, one work around suggestion might be to use a Float data type rather than a Decimal: http://www-01.ibm.com/support/docview.wss?uid=swg21483818 However, as a first measure it might be best to install the Feature Pack for SQL Server 2008, service pack 3. It should be available as a 32- or 64-bit installer.  I would suggest this first to see if it clears up your issue before changing data types. ... View more

Your pictures and related documents can't be stored in the file geodatabase, but they can be cataloged in the file geodatabase and used as attributes (hyperlinks or direct file paths, perhaps, depending on how you plan to make calls to them).  If you end up using an RDBMS, then it's possible to store the related files within the Oracle or SQL Server database but there are many reasons why that would still not be ideal.  In either case, if you have a data model and your relationship class structure is sound then it sounds like you're halfway there already.  The Crystal Report reporting engine and authoring tools used to be provided with ArcGIS (I think at the 9.3 and earlier releases), but I think they are no longer part of the application installation files.  Unfortunately, Esri does not provide a reporting engine that really suits your needs I don't think.  However, from a web application standpoint, you may be able to leverage one of the web APIs (Silverlight, Flex, Javascript) to generate a report but that would require custom coding.  Otherwise, you may require the use of an off-the-shelf solution as mentioned earlier but you'd still need custom code to integrate the reports with your web application I believe.  I don't know if there is an all-inclusive solution out there that contains a web GIS viewer and reporting interface but you might try some online searches to see if any vendors pop up. ... View more

This functionality is more dependent upon your web mapping application or the API you may be using.  I am not sure how to do this with GeoCortex.  If your database relationships are set up properly, I think the next place to focus is on how to expose those relationships based on the application itself.  One thing to try might be building a Query Layer in the map document before publishing the service.  The query layer would need to be a join between your spatial data and your non-spatial data.  Otherwise, you can build a spatial view at the RDBMS level using the SDETABLE command (and edit the view's SQL via your RDBMS tools later if you wish).  In either case, those would become layers in your map document.  However, since you mentioned a 1-to-many relationship then I am not sure how much this would benefit you. ... View more