Forums - Enterprise GIS

query versioned view in Microsoft SQL Server Manager extremely slow

SRoberts — Wed, 15 May 2013 17:37:06 GMT

I created a versioned view for a feature class with about 60,000 features and am querying the view with a simple select statement in MSSMS. The query to select 1 indexed field takes about 5 minutes to complete. We do a low volume of editing on the database, and have a nightly automated job to do a compress, rebuild indexes, and analyze datasets. Any ideas on how to improve the performance?

Code:

SELECT apn FROM gis.PARCEL_VW

Oracle Query Layer not Displaying

CrystalCarreon — Thu, 09 May 2013 14:14:24 GMT

I am having an issue with an Oracle query layer using SDO_Geometry not displaying. I have created a polygon layer/table within oracle, registered the table with the SDO_GEOM_METADATA and created a spatial index...twice. Unfortunately, I am still unable to see the polygons display in an ArcMap query layer. I am able to bring the data into arcmap, open the table, select and identify it and actually see the shape flash, so I know it is there. Also, I can export a shapefile and the shapes render perfectly fine, but for some reason they will not display from the query layer directly. I have checked over the index parameters in the registry and nothing seems off, see: INSERT INTO all_sdo_geom_metadata (owner, table_name, column_name, diminfo, srid) VALUES ('DB', 'TABLE', 'GEOM', MDSYS.sdo_dim_array (MDSYS.sdo_dim_element ('X', -180,180,5.0e-10), MDSYS.sdo_dim_element ('Y',-90,90,5.0e-10)),4326); index creation: CREATE INDEX wm_dim_table_si ON TABLE (geom) INDEXTYPE IS MDSYS.spatial_index PARAMETERS ('tablespace=DB_INDEX03 layer_gtype=MULTIPOLYGON');

I've done everything, others have prescribed but I still can't view the data directly...Any hints as to what else I should try or should be looking at? Any help is greatly appreciated. My nexts thoughts are that I should check and validate the geometry on the polygons. Also, there are about 30,000 polygons in this table, is there a threshold in armap for query layers? It wouldn't seem so, however I am at a loss right now...

Custom symbology - how to share symbols I built with other users in my office

natgeo1984 — Wed, 24 Apr 2013 21:41:19 GMT

Hello,
I created some symbols and by default they are stored in my User.style folder but I want others in my office to be able to see and
use these labels too. How or where can I save these symbols so that when someone else in the office wants to use them, they can
find them in their Symbol Selector?

record count (oracle <-> arcmap)

chrisnig83 — Wed, 17 Apr 2013 09:38:14 GMT

hi there,

i think this might be a simple question for you guys. today we've noticed that the number of records (for one feature class) in our
ArcMap is not equal to the number of records in our oracle DB. Am i missing something? We are using versioning with ArcSDE 9.3.1 and Oracle 11g. For example:

records in feature-class in arcmap : 500
records of the table in oracle: 450

could this be an versioning, reconcile or post error (everything hast been reconciled and posted well)? got no problems with the number of records so far. this problem occures in just one scheme.

kind regards,
chris

SDE Feature Class Fields are null

ldcarto — Thu, 11 Apr 2013 18:27:26 GMT

Hello,

I am having a weird issue with some fields in a SDE feature class version 9.3.1. I needed to add some new fields to an existing feature class, so I deleted the old feature class in ArcCatalog and imported the new feature class from a personal geodatabase. The strange thing about it is that all of the new fields that I added are coming through as null values for every record even though there are values in the personal geodatabase. It seems as if, even though I deleted the original feature class, Arccatalog has a memory of what fields were there. It recognizes all the data from the fields that were there previously, but any of the new fields are given null values across the board.
Has anyone seen this behavior? Do you have any ideas of how to fix it?
I could import the geodatabase with a new feature class name, but then I would have to redirect many layer files and other connections and I would prefer to avoid that if at all possible.
The personal geodatabase was created in Arccatalog. I run a process in Access every night to populate the fields and that process does work correctly. Somehow in the process to update the feature class, something goes wrong. The fields don't even come over into ArcGIS in the correct order. It moves the new fields to the very end of the list even though they are located throughout the assortment of fields.
There are map services pointing to the feature class and we did have to turn those off to be able to delete the old feature class and import the new. I am not sure if that has some affect as I have never run into this before and I have been managing SDE data for years and many of the feature classes I have managed have the same set-up (initially created from an Arccatalog personal geodatabase, and fields populated through Access). I have never encountered this before.

Any advice or suggestions would be greatly appreciated.
Thank you in advance.

Lisa Dygert

System Design Tool - New Model Input Values

walves — Wed, 03 Apr 2013 14:22:38 GMT

How to build a new Model input?
How to get a service time parameter to Tier Input (Application Virtualization, Web Application Server, Web Services, GIS Services and Data)?

For example:

Having a quick look at model 'ArcGIS Server REST Mapping Vector ArcSDE' we can see a default SPECint rate 13,62 and 13,42.
If I'am design with a better hardware for example SPECint rate 41,75, the "service time" will be the same? or The System Design tool calculate this difference internally?

Define a new Model Input is pretty mystery about System Design Tool.

See attached file.

Thank you

Attached Thumbnails

Randomly lost connection to SDE Database

kbabcock — Mon, 25 Mar 2013 18:01:57 GMT

Hello All,

Recently upgraded to 10.1 and everything was working fine. All of sudden now, I've lost my connection to the SDE. When I click on either SDE connection, I receive the following error message; "Failed to connect to the specificed server. Do you want to continue? Invalid database name." No one else in my organization is having this issue. As far as I can tell no changes have been made to either my user account or my database connections. Thanks in advance!

Kurt

ArcInfo Concurrent License Ghost User

bdebruyne — Thu, 21 Mar 2013 13:49:18 GMT

I have a mystery. We run concurrent info,Editor and ArcView licenses for the Installation. There are two primary Info license users and they are in my office. Every now and then one of the Info users can't get in because it states that all licenses are in use. finally I downloaded LMUTIL and found who it was. Only problem was, it wasn't him. The user name and computer name were his, but he was not in Arc at all. When I checked his desktop Administrator, it was set for ArcView license. We can't change our license's on our own since we have no Admin privileges. We use CAC cards and PIN numbers and his card was in his computer, so it can't be anyone logging in as him. Anyone have any idea what could be causing this??

ArcGIS Server Image Server Extension

aziegler — Mon, 18 Mar 2013 19:59:58 GMT

Hello all,

I have received conflicting information on deploying a multi-machine ArcGIS Server site with an ArcGIS Server Image Server extension. What I am trying to nail down is, does each ArcGIS Server instance within my site need to have the extension or does one license of the extension cover the site? I am planning for a 10.1 environment, so that's the answer I'm looking for.

Thanks,
Adam Z

Estimated Cost of Hosting ArcGIS for Server on Amazon EC2 (Cloud)

dawagh — Mon, 11 Mar 2013 04:28:58 GMT

Hi,

Can anyone with experience of hosting a Flex front end on the EC2 cloud, let me know estimated costs please. We are looking at 200-300 users, if I categorise usage it would be light occasionally medium.

Any help appreciated, as it very confusing looking at the EC2 price lists.

Regards

Dilip

Uninstalling Production Mapping 10.0

andy_trcka — Wed, 06 Mar 2013 17:55:27 GMT

All,

When uninstalling Production Mapping 10.0 I encounter the following error:

Error I066 : Could Not Access Network Location NULL

Does anyone know how to correct this problem?

Thanks!

System Designer Workflows and Mapping to Applications

ldmitruk — Tue, 05 Mar 2013 17:04:24 GMT

Hi,

I've been doing a some work with the System Designer tool and I was wondering if it's possible to map a workflow to more than one application. For example I have a workflow that draws an image from an image service. I would like to use this workflow in several applications. As near as I can tell it appears you only map one workflow to one one application indicating the workflow would have to be copied and renamed for each application I would to use it in. Is my assumption correct?

Cheers!

Autodesk Vault 2012 and ESRI

Ernestocd — Sat, 02 Mar 2013 11:31:46 GMT

I like to learn about Autodesk Vault 2012 and Esri integration? If a company wants to become more GIS-centric, should they just acquire ArcGIS for Server instead of Autodesk Vault 2012? As far as I understand, once the CAD files are loaded into the enterprise GDB, and versions are created, CAD users can work with them within their CAD environment and even make modifications (edit processes), right?

Can somebody enlighten me?!

SQL Server Permission granted - No access to database SDE

mbly29 — Wed, 27 Feb 2013 23:34:12 GMT

Hi Folks,

I have recently added a new user to our SQL based SDE environment. The user is set up as all others have been through SQL management studio with same access and permission settings.

However on the user machine I cannot access the database through ArcCatalog when trying to set up a new database connection. I should not have to do this in the first place as the users are set with OSA for access to the data. Users are linked to certain roles, and the role has been granted privilege to the database.

Data in the mxd is set to pull from a certain version of the SDE, however of course when I open their project all the data sources are broken and non repairable with no access to the database from that machine?

Any thoughts as to why this would be occurring?

Thanks,

Mike

Layer file Join issue with SQL server view

antonypaulm — Tue, 26 Feb 2013 03:03:01 GMT

Hi All,

I am having a layer file which I am trying to join with SQL server view. The idea is to get the customer more atribute information.

The layer file is ArcSDE 9.3 / Oracle
SQL server 2005
Desktop 10.1

When I validate join I am getting the following error from ArcMAp

"Field names containing invalid characters can cause the join to fail, the following fields containing invalid characters:
- [start Date from Contains invalid character ' '
- [start Date / Duration ]from Contains invalid character ' /'
- [start Date / Duration ]from Contains invalid character ' '

What date format 10.1 desktop is expecting here? Can anyone adcvice me on this?

The same layer file join with SQL server view worksfine in 9.3 and in defenition query I have given io_P_area.OBJECTTID > 0 and "Start Date" > date '30-01-2012', This works in desktop 9.3 environment

Please help

Cheers
Antony