Latest Contributions by WilliamCraft

Is your ArcGIS for Desktop client also 10.2?  Please also provide the version of the SQL Server database to which you are connecting (e.g., SQL Server 2005 Standard 32-bit, SQL Server Express 2008 R2, etc.). ... View more

I tried this workflow in SQL Server Express 2012 and in Oracle 11g R2 (11.2.0.2) using a 10.2 client: Create table called TEST Register table TEST as versioned, then enable Archiving Check in RDBMS to see if TEST_EVW was created Create feature class called TEST1 Register feature class TEST1 as versioned, then enable Archiving Check in RDBMS to see if TEST1_EVW was created In the case of SQL Server Express, I observed that step 3 did not show that a version view of the TEST table was created (either before or after Archiving was enabled).  However, step 6 did yield a version view of the TEST1 feature class which got created upon registering it as versioned.  In the case of Oracle, I observed that both step 3 and step 6 yielded version views as expected based upon how Esri's documentation is written.  Therefore, I can only conclude that in SQL Server the automatic creation does not work for tables upon registration as versioned, but it does work for feature classes.  This could potentially be a bug. ... View more

Try changing your user and role store back to ArcGIS Server Built-in, saving these changes, and then re-configuring your site to use Users and roles from an existing enterprise system (LDAP or Windows Domain) again.  Something may have gotten hosed up during the upgrade and perhaps re-setting the user and role stores would help.  Another possibility is that the credentials from the domain account used during the user and role store setup is no longer valid.  Can you confirm that account is not locked? ... View more

Perhaps this article about Enabling SQL Access (for 10.2) will explain some possible reasons for what you're seeing... Version views are also automatically created when you enable archiving on nonversioned datasets beginning with ArcGIS for Desktop 10.2.  Additionally, there are situations when a version view will not exist: You have tables or feature classes that were registered as versioned prior to ArcGIS 10.1 and did not manually create a versioned view using the sdetable �??o create_mv_view command. You registered a table or feature class as versioned using ArcGIS 10.1 or a later release, but you did not have the privileges necessary to create a view in the database. You enabled archiving on a nonversioned table or feature class, but you did not have the privileges necessary to create a view in the database. The version view was deleted mistakenly using SQL or database management system tools. For these situations, you can Enable SQL Access on those specific datasets from ArcGIS for Desktop.  Could any of these be the possible cause in your case? ... View more

Hi Jamal, versioned views used to be called multiversion views.  Versioned views are automatically created for datasets that are registered as versioned using ArcGIS for Desktop 10.1 or higher.  If you were using ArcGIS prior to 10.1, you would have needed to manually create the multiversion views using the ArcSDE command line tools.  In your example, I see that some data registered as versioned have versioned views and some data do not based on your screenshots.  Was this geodatabase upgraded from a pre-10.1 release? ... View more

This behavior is by design.  One way to avoid the copying of relationship classes and related tables is to use Feature Class to Feature Class geoprocessing tool.  This tool should only copy the input feature class to the specified destination, ignoring the related objects.  I believe the Feature Class to Geodatabase tool also achieves this behavior.  If you use either of these tools, however, I believe the OBJECTIDs in your source will not be the same in your destination. ... View more

There is not a way to do this if you want changes in the text file to be reflected in the map layout.  For example, you can add the text file to your map document using Add Data, then open it as an attribute table, and choose the Add Table to Layout option from the Table Options drop-down menu on the top left.  The process I followed is outlined here.  However, no row information ever appears in the layout when the table item is added... only the field names from the text file appear.  I have tried this with a TXT file and a CSV file, and I get the same results each time.  See screenshot below... [ATTACH=CONFIG]32885[/ATTACH] I suspect this functionality would work with DBF tables or other types of input, but unfortunately displaying information from a text file does not.  However, if you don't require that updated information in the text file be reflect 'real-time' within the layout, you can simply import your text file into a spreadsheet (e.g., MS Excel), format it the way you want, and then take a screenshot of the table to produce a JPG, BMP, PNG, etc.  From there, open the Insert menu and select Picture to import the screenshot into your layout.  It's static, but it gets the table into the map document layout.  So, in summary, the answer to your question is "there isn't a way to do this in you need to preserve a link between the text file and the map document layout". ... View more

It sounds like your database needs more resources allocated to the SGA in order to perform the operation.  You can reconfigure your Oracle database's SGA to include at least (max - current) bytes of additional memory.  Try making the MAX SIZE and TARGET values the same: create pfile from spfile (must be done as sys user) ALTER SYSTEM SET sga_max_size=16879104K scope=spfile; ALTER SYSTEM SET sga_target=16879104K scope=spfile; SHUTDOWN IMMEDIATE STARTUP show parameter sga_max_size show parameter sga_target If the database starts up without issue, then: create pfile from spfile If it does not come start up, then perform these steps: SHUTDOWN IMMEDIATE startup pfile=<path to pfile> Alter SGA to whatever values were configured from your old settings (229936K) with scope=spfile SHUTDOWN IMMEDIATE STARTUP (which should start from spfile) If the database starts correctly, then: create pfile from spfile ... View more

Try changing CNT_PT_ID" = "Null" to be "CNT_PT_ID" IS NULL instead.  Does that work? ... View more

The only ways I'm aware of for running scripts on a remote machine is (1) creating a scheduled task for your PY script and issuing a run task command via SCHTASKS; (2) using a third-party tool like PSEXEC; or (3) writing a PowerShell script.  I don't know of a Python library that does what you need.  Try posing your question on StackExchange. ... View more

How about something like this?  I don't know if this is what you're trying to achieve by "testing" the motherboard but the script below will produce information about the remote computer's motherboard.  import os product = os.popen('wmic /user:"DOMAIN\USER" /password:"PASSWORD" /node:"STATION01" baseboard get product').readlines() manuf = os.popen('wmic /user:"DOMAIN\USER" /password:"PASSWORD" /node:"STATION01" baseboard get manufacturer').readlines() serial = os.popen('wmic /user:"DOMAIN\USER" /password:"PASSWORD" /node:"STATION01" baseboard get serialnumber').readlines() model = os.popen('wmic /user:"DOMAIN\USER" /password:"PASSWORD" /node:"STATION01" baseboard get model').readlines() name = os.popen('wmic /user:"DOMAIN\USER" /password:"PASSWORD" /node:"STATION01" baseboard get name').readlines() partnum = os.popen('wmic /user:"DOMAIN\USER" /password:"PASSWORD" /node:"STATION01" baseboard get partnumber').readlines() slot = os.popen('wmic /user:"DOMAIN\USER" /password:"PASSWORD" /node:"STATION01" baseboard get slotlayout').readlines() print product, manuf, serial, model, name, partnum, slot The variable values can then be parsed and piped however you need for the remainder of your script.  Note that the WMIC commands require the use of an account which has administrative access to the remote machine (in this case, STATION01). ... View more

This forum may not be the best place to ask non-Esri question; there are many others for Python if you do some searching.  That being said, what type of command are you wanting to run on the remote Windows computer?  For example, are you trying to launch some specific process on that remote computer or obtain information about the remote computer? ... View more

Can you be more specific about what type of action needs to be performed on the remote Windows machine?  There are ways to run commands on a remote machine using third-party tools and sometimes using Windows batch commands; typically these require that you have Administrator privileges or Log on As Batch Job rights on the remote machine.  Are you looking to perform some Esri-related function or something different?  Please reply with some further details about what you're trying to accomplish and we'll be able to provide some more direction. ... View more

Symbol rotation is not available in the Basic edition of ArcGIS for Desktop.  Take a look at this matrix and search for "Rotate Feature Symbols Interactively or by a Specific Angle".  You'll find this topic listed under the Interactive Symbol Editing section.  It appears the Standard and Advanced editions contain this functionality, but not the Basic edition.  This is the reason why the symbols rotate without issue when you open the MXD using the Advanced installation of ArcGIS for Desktop but not with the Basic installation.  Lastly, "Arithmetic" is referring to the Arithmetic Rotation Style found under the Rotate Points by Angle in this field section, which specifies an orientation and a clockwise/counterclockwise direction. ... View more