Latest Contributions by WilliamCraft

‎12-16-2013

In general, it definitely is possible to replicate an SDE geodatabase and base it on a different version other than SDE.DEFAULT. In fact, replicas can be based on any version you'd like; in other words, you can pick a version within your lineage to be a parent version and generate child replicas (and thus, child versions) from them. Just give some thought about which user account is going to be specified when generating the child replica; that user account will become the owner of the replica. We do this all the time; our replicas are based on a different version than SDE.DEFAULT in all of our enterprise geodatabases. Just remember, though, that if you take your database to State 0 then you will need to give some thought about dropping and rebuilding the replica(s) or synchronizing the replica(s) appropriately such that their corresponding versions (i.e., SYNC_SEND_XXX) end up with the same state ID as their parent and eventually as SDE.DEFAULT. This all being said, these are typically the rules for traditional replication. I'm not 100% sure if they apply in the same fashion for geodata services, but I think they do.

‎12-16-2013

At this point, I'm at a bit of a loss. On reboot when the services are stopped, what happens if you try to start them all manually via ArcCatalog? Also, how many CPU cores on your machine and how much RAM? What are the min and max SOC instances for your services?

‎12-16-2013

My mistake; I realize now that I'd provided you info on how to change the duration of tokens in ArcGIS for Server and not for Portal. I apologize. I can actually reproduce the issue you described. That being said, I combed through the various configuration files on the file system for Portal and through the application itself. I can't find anything specific to Portal for token duration. You should probably contact Tech Support.

‎12-16-2013

Ok, now I see more of what you're saying. At the PostgreSQL level, what version of the RDBMS are you using and which PostgreSQL data type are you using for that field? http://www.postgresql.org/docs/9.1/static/datatype-numeric.html http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002p0000006p000000 If you said DOUBLE in ArcGIS, then it's probably a NUMERIC data type in PostgreSQL. Are you certain that your precision and scale in PostgreSQL are set to 38 and 8, respectively?

‎12-16-2013

In looking at your error, it seems like you could be trying to insert rows into the GDB itself rather than a feature class or table within the GDB. Are any of your object classes successfully getting rows copied or does it error out on the first object class?

‎12-16-2013

I have a tiled map service with addresses labeled on it. Sometimes a label gets partially cut off (see attached). Is there a way to prevent this from happening. I'm guessing this is occurring at the edge of a tile.[ATTACH=CONFIG]29912[/ATTACH] Which version of ArcGIS Desktop and ArcGIS Server are you using? In terms of your building layers' label properties, are the labels being generated directly from the buildings polygon layer or from a point layer in the map document? The behavior you're seeing probably IS due to there being two adjacent tiles, as you've suspected. When the cache tiles are created, the caching process re-renders the layers in the map document at a particular scale and extent for each tile. You should probably check your lebeling Placement Properties; my guess is that the labels are drawing in different places around your features depending on the extent of your map document. If the label is drawn on in the middle of the feature for one tile, and then the map document centers on a new extent and therefore shifts for the next tile to be created, the label might be drawn to the right, left, top, or bottom of the feature instead.. or it simply might not draw at all depending on your label weights compared to what other features are nearby. Later when rendering those tiles next to one another, it looks like the label is cut off. That's my theory anyways. What you might need to do is "force" your labels to stay in the same place no matter where the map document pans for a particular scale. I find this easier to do with a point layer; that is, generate building centroids and symbolize them to nothing and force the label to always draw on top of the point location giving them a high weight in the pecking order.

‎12-16-2013

I have connection to PostGis database through ArcSDE, and all double type numeric fields are cutting numbers after comma. For example, instead 255,11 i have in my field 255. Does anyone know how can i fix this problem? Can you please be more specific about the issue you're seeing? You should also provide the version of ArcSDE, ArcGIS, etc. you are using along with the exact version of the RDBMS. With regard to the issue you're facing, it seems like you indicate that the fields in question are numeric (DOUBLE, to be specific)... then you mention "255" and "11"; are you saying that 255 is your precision and 11 is your scale? If you explore the tables directly from a database management tool, do you see the same behavior as you see from ArcGIS Desktop?

‎12-16-2013

Can you check c:\arcgisserver\logs\JAMAL-SONY\errorreports to see if an error report was produced per the messages in the log?

‎12-16-2013

Thanks William I�??ll be checking the logs of ArcGIS Server and Windows the next time I get this problem [ATTACH=CONFIG]29901[/ATTACH] From the looks of your screenshot for ArcGIS Server Manager, you will most likely need to change the logging level filter to ERROR or somehting more granular to see the issues. Make sure you've set the logging level to actually record at ERROR level or better. Good luck!

‎12-16-2013

I believe you can specify a "custom" identifer field in place of the default OBJECTID field that ArcGIS creates. When using the sdelayer -o register command to reigster your table with ArcSDE, specify the field you want in the -C parameter as such: sdelayer -o register -l <table,column> [-e <entity_mask>] {[-C NONE] | [-C <row_id_column>[,{SDE|USER}[,<min_ID>]]]} [Spatial_Index] [-S <layer_description_str>] [-q] [-k <config_keyword>] [-i <service>] [-s <server_name>] -u <DB_User_name> [-p <DB_User_password>] [-D <database>] Note: the custom field you specify needs to be of number(38) data type.

‎12-16-2013

Thanks for your reply. Since we have now 10.2 is the same applicable to current version of Arcgis server. What do you mean by HA and where is network load balancer? Do we require still only two licences of arcgis server and same time we are using power of four machines? Do you recommend any new architecture? "HA" means High Availability. At the 10.2 version of ArcGIS for Server, the Site load balances itself. There isn't really a need for a separate load balancer anymore, although there may be one or two specific use cases that are not common in most environments. You should know that ArcGIS for Server's licensing model is by the CPU core; so for every machine that runs a SOC instance you would require licensing on all of its cores. I suppose this would be a function of how many servers you add to your ArcGIS for Server Site.

‎12-16-2013

"You can edit the data VALUES" Is it true for ArcGIS Desktop Basic (former ArcView) and file geodatabase? As I understood from previous post it is possible trouble due file geodatabase locks? Thanks Oleg I looked at a comparison chart for the basic, standard, and advanced levels of ArcGIS for Desktop. The standard and advanced levels have "Edit a multiuser enterprise geodatabase" specified as a capability but the basic level does not. That being said, I'm not sure if that translates into the functionality you're describing. If you have a seat of ArcGIS for Desktop Basic, give it a try and post your results. I'm just as curious as you at this point.

‎12-16-2013

Hi, Is there any way to edit data in file geodatabase with ArcGIS Basic and share it for viewing with ArcGIS Server map service without stop\start service by user? It seems I could edit data in personal geodatabase in ArcMap and see changed data in ArcIMS ArcMap service earlier. Thanks Oleg You can edit the data VALUES of your published object classes using a desktop or web client while the services are running. I don't think the level of AGS dictates this. But typically you cant make schema changes to those objects though since services place a lock on them when running. Technically, you could modify the schema while the service is running if you change the schema locking setting in the service configuration file but unexpected results can occur until you restart the service anyways.

‎12-15-2013

These tables can be created in advance using the SQL below (formatted for Oracle in the example below) for 9.3.1; you should do some research to see if the same concepts apply in later versions of SDE. However, notice that I am creating the tables as Global Temp Tables for Oracle. Esri doesn't do a good job at clearing these tables out when users make large selection sets and then log out. Global Temp Tables are tables in Oracle that get cleared out automatically by the database when the user disconnects his or her session. We do this and it's worked very well to help reduce the size of the database overall. There may be a SQL Server equivalent but I'm not sure of the syntax. CREATE GLOBAL TEMPORARY TABLE USER_NAME.SDE_LOGFILE_DATA ( logfile_data_id NUMBER(*,0) NOT NULL ENABLE, sde_row_id NUMBER(*,0) NOT NULL ENABLE ) ON COMMIT PRESERVE ROWS / CREATE INDEX USER_NAME.SDE_LOGFILE_DATA_IDX1 ON USER_NAME.SDE_LOGFILE_DATA(LOGFILE_DATA_ID,SDE_ROW_ID) / CREATE INDEX USER_NAME.SDE_LOGFILE_DATA_IDX2 ON USER_NAME.SDE_LOGFILE_DATA(SDE_ROW_ID) / GRANT DELETE ON USER_NAME.SDE_LOGFILE_DATA TO SDE / CREATE GLOBAL TEMPORARY TABLE USER_NAME.SDE_LOGFILES ( logfile_name VARCHAR2(256) NOT NULL ENABLE, logfile_id NUMBER(*,0) NOT NULL ENABLE, logfile_data_id NUMBER(*,0) NOT NULL ENABLE, registration_id NUMBER(*,0) NOT NULL ENABLE, flags NUMBER(*,0) NOT NULL ENABLE, session_tag NUMBER(*,0) NOT NULL ENABLE, logfile_data_db VARCHAR2(32), logfile_data_owner VARCHAR2(32), logfile_data_table VARCHAR2(98), column_name NVARCHAR2(32) ) ON COMMIT PRESERVE ROWS / CREATE UNIQUE INDEX USER_NAME.SDE_LOGFILES_PK ON USER_NAME.SDE_LOGFILES(LOGFILE_ID) / CREATE UNIQUE INDEX USER_NAME.SDE_LOGFILS_UK ON USER_NAME.SDE_LOGFILES(LOGFILE_NAME) / CREATE UNIQUE INDEX USER_NAME.SDE_LOGFILES_UK2 ON USER_NAME.SDE_LOGFILES(LOGFILE_DATA_ID) / GRANT DELETE ON USER_NAME.SDE_LOGFILES TO SDE /

‎12-15-2013

The problem here is that the tiling schemes between WKID 4326 and WKID 3857 are different; that is, the cached tiles differ between them in terms of tile width/height, scale thresholds at which the tiles were generated, X and Y origin, units, and technically even the coordinate system properties. To be specific, one example here is that the WKID 4326 uses decimal degrees and WKID 3857 uses meters. Another example here is that, if you look at the technical differences between these two WKIDs, you'll see they are inherently different despite the fact that they are so similar: WKID 4326 ArcCatalog projection definition for "WGS 1984 Web Mercator.prj" Name: GCS_WGS_1984_Major_Auxiliary_Sphere Angular Unit: Degree (0.017453292519943299) Prime Meridian: Greenwich (0.000000000000000000) Datum: D_WGS_1984_Major_Auxiliary_Sphere Spheroid: WGS_1984_Major_Auxiliary_Sphere Semimajor Axis: 6378137.000000000000000000 Semiminor Axis: 6378137.000000000000000000 Inverse Flattening: 0.000000000000000000 WKID 3857 ArcCatalog projection definition for "WGS 1984 Web Mercator (Auxiliary Sphere).prj" Name: GCS_WGS_1984 Angular Unit: Degree (0.017453292519943299) Prime Meridian: Greenwich (0.000000000000000000) Datum: D_WGS_1984 Spheroid: WGS_1984 Semimajor Axis: 6378137.000000000000000000 Semiminor Axis: 6356752.314245179300000000 Inverse Flattening: 298.257223563000030000 I've read recently that Google Earth doesn't always have the best reproject capabilities. Sometimes it works, sometimes it doesn't. Clearly in the case of WKID 3857, it doesn't. The only way I can really think of to "reproject" the WKID 3857 service to display correctly in Google Earth would be to reproject is intentionally by re-publishing it in your ArcGIS Server instance locally. In other words, cascade the service... which is not only unsupported by Esri but also unpleasant in terms of visual quality and draw time performance. In the case of doing this, you would add the external WKID 3857 service into a map document and then alter the data frame to be WKID 4326 before publishing the map document.

Online Status	Offline
Date Last Visited	‎07-13-2025 07:13 PM

My Ideas

Latest Contributions by WilliamCraft

Re: Geodata service replicate from other than default working version

Re: What might cause the services to stop as the machine restarts?

Re: Generate Token: Expiration

Re: Problem with double field type in postgis database

Re: Backing up databases

Re: Map Cache Tiles - labels cut off

Re: Problem with double field type in postgis database

Re: What might cause the services to stop as the machine restarts?

Re: What might cause the services to stop as the machine restarts?

Re: Error when adding new element - feature not editable

Re: Migration of Arcgis 10 to 10.1

Re: Problem with File Geodatabase Locking

Re: Problem with File Geodatabase Locking

Re: SDE Shared Log Files

Re: How to display WGS 1984 Web Mercator (Auxiliary Sphere) services in Google Earth?

Re: How to Calculate area in square meters from ce...

Re: (again): A tool to transfer the Add\Delete tab...

Re: Copy_management brings along Relationship Clas...

Re: ArcPy, Determine what version an MXD is?

Re: Admins cant share content to groups they arent...