Latest Contributions by WilliamCraft

Is the MXD or SD open in ArcMap?  The error in the screenshot you provided happens when something is accessing the source document supporting the map service.  Make sure you or some other process is not accessing files in the folder containing the service definition or map document.  Source: http://resources.arcgis.com/en/help/main/10.1/index.html#//00vp0000002r001269 If you're certain the service definition or MXD is not open, then there might be a system lock on those files.  If you're using Windows, from the Start menu (or from 'Run' or a CMD prompt) type fsmgmt.msc to open the Shared Folders dialog box.  Click on Open Files at the bottom of the list on the left, then check to see if your map service files are in there.  If they are, right click on them and select Close Open File.  Try re-publishing your service to see if the error goes away. Regarding the issue of missing layers, you mentioned that your layers are referencing SQL Server views.  Are you referring to spatial views that persist in the database?  In other words, a database view which is a join between a stand-alone table and a feature class.  From an ArcGIS Desktop standpoint, the spatial view would 'look and feel' just like a feature class.  One question I have has to do with security: are your data source connections in the map document using database authentication or operating system authentication?  Another question is are you using a domain account or a local account to run your ArcGIS for Server service in the Windows Services dialog box?  The main reason for these two questions has to do with access; I wonder if the account running the service needs to be added to your SQL Server instance and database as a login and user, respectively.  What's confusing to me is why only 10 of the 200 'layers' work.  It could either be permissions or there could be a difference between those 10 layers and the other 190 in terms of the data sources (perhaps those are XY event layers or query layers or some other kind of layer).  We need to isolate the difference between those 10 layers that work and the 190 that don't.  In either case (database auth or OS auth), the user account in the connection properties of each layer would need to have permissions to see those views.  You're certain that your database user account has access to those views?  The answer to this is likely 'yes', but I'm just covering our bases here. ... View more

Nidhin's workflow is a good alternative.  Regarding the error you cited, I am wondering if the instance hosting Database B contains the same logins as with your instance hosting Database A.  I am also curious if you have set up all of the same user accounts and schemas in Database B as you have with Database A.  If not, that may explain the error you're seeing. ... View more

Generally speaking, the number of services you can have that perform reliably well is dependent upon your hardware (e.g., number of cores and amount of memory) and on the complexity of those services to begin with.  There are many, many opinions out there regarding a good formula to follow for determining just how far you can push your ArcGIS for Server Site.  A good rule of thumb that I've always used as a baseline is that a single core will typically support 4 to 6 pooled instances of a service.  The logic here is that a really basic map service with one simple feature class won't require a lot of resources on the machine when it's requested by users.  Conversely, a complex map service with hundreds of layers using sophisticated symbology or a very heavy-lifting geoprocessing service will be more resource-intensive.  The 4 to 6 range I stated is simply a rough guideline; it's not designed to be an exact figure because everyone's environment, usage, and requirements are different.  If you've reached 450 services and you're starting to see performance issues, I guess I'm not surprised... even if all 450 services are very simple services.  Unless you have a huge number of cores available to you across your Site, you'll likely continue to see performance degradation unless you combine some of them as suggested earlier in this thread. ... View more

I'm not sure that any of those errors are related to your issue, either.  That being said, I don't know enough about the timeline of when these errors occurred and when you attempted the copy/paste where it failed thereafter.  If you're using direct connect, the sdedc_Oracle.log file should be somewhere on your machine.  Are you using direct connect or the ArcSDE application service to connect to your enterprise geodatabase?  It would also be good to get the exact version of your RDBMS and ArcGIS/ArcSDE software before going any further. ... View more

Then make a request for data to the server using PCS B from a web application. Both scenarios require a transformation on the fly by the server. Are you talking about inputting a different WKID value for the Image Spatial Reference parameter in the REST export map request issued by your web application?  I gave that a try just now and didn't notice a difference in performance.  Just make sure you only use this approach for dynamic map services and not cached services. ... View more

Manually editing your registry settings should be done with extreme care and not before taking a backup.  In most cases, I wouldn't recommend editing the registry unless you are absolutely positive there will be no negative downstream effects.  When you tried unregistering with the ESRIRegAsm.exe application, was it a 10.0 or a 10.2 ESRIRegAsm.exe executable?  If the registration was initially performed with a 10.0 executable, then perhaps the unregistration process must be performed with the same version.  That is the reason I asked earlier if you had upgraded your desktop software from 10.0 to 10.2 yet. EDIT: Can you try this real quick?  regasm c:\WatershedSOE.Manager.dll /u The regasm.file can be found under the .NET framework directories; for example: C:\Windows\Microsoft.NET\Framework\v4.0.30319.  Try the command above using the regasm.exe under a 4.0 and a 2.0 .NET folder. ... View more

I'm not entirely sure of what to make of the two scenarios you asked about, but I think what you are asking is whether it yields better performance to reproject your data on the fly in a map service as opposed to reproject your data ahead of time and subsequently publish it so that it doesn't have to be reprojected on the fly.  Here are the two scenarios that I am taking away from what I think your question might be: Scenario 1: Your data currently resides in Projected Coordinate System (PCS) "A" but you want it to display in PCS "B", so you change the data frame in your MXD from "A" to "B" and publish the MXD as a service.  While the underlying data exists in "A", it is being rendered in "B".  Scenario 2: You actually perform a one-time, up-front reprojection of all your data using the ArcGIS Desktop tools such that they are modified from PCS "A" to PCS "B".  Now they reside in "B".  Then, you add the data to an MXD and publish it as a service without modifying the data frame.  Let me know if I am understanding your question or not.  Scenario 2 will yield better performance because the data is being published in its native Projected Coordinate System rather than being reprojected on the fly with each request as with Scenario 1. ... View more

You're using direct connect to establish the connection to your enterprise geodatabase, right?  We need to capture the Oracle error code before knowing what the issue might be according to your database.  What does the following log file say? C:\Users\<your_user_ID>\AppData\Local\Temp\sdedc_Oracle.log What do your Oracle database Alert log files show? Typically located at C:\oracle\diag\rdbms\<db_name>\<db_name>\alert\log.xml Typically located at C:\oracle\diag\rdbms\<db_name>\<db_name>\trace\alert_<db_name>.log Note: Replace <db_name> with the name of your Oracle database SID. ... View more

The MINIMAL System privileges for the SDE user in Oracle are these: CREATE SESSION CREATE SEQUENCE CREATE TABLE CREATE TRIGGER CREATE PROCEDURE SELECT ANY TABLE However, these won't do everything you mentioned.  If you want to disconnect sessions, you will need to grant DBA role to the SDE user or grant these to SDE instead: ALTER SYSTEM SELECT_CATALOG_ROLE If you want to analyze objects outside of the SDE schema (user-schema geodatabases) then grant these to SDE: ALTER ANY INDEX ANALYZE ANY SELECT ANY DICTIONARY What you decide should be based on whether or not your ArcSDE administrator is the same person as your Oracle DBA. ... View more

What does the referenced error log file contain?  Are you using the SDE user in your input connection file?  Make sure you have granted the correct privileges for the SDE user (I'm not sure if you are using SDE schema or DBO schema).  You might already have done that, but just in case you haven't, take a look at the Privileges to create or upgrade a geodatabase table from the link below: http://resources.arcgis.com/en/help/main/10.2/index.html#//002q0000002s000000 To upgrade the geodatabase, the SDE user requires the following privileges: CREATE FUNCTION CREATE PROCEDURE CREATE TABLE CREATE VIEW The SDE user must be added to the db_owner role in the database to upgrade.  Alternatively, the upgrade can be run by a user (other than sde) who is in the db_owner database role or sysadmin fixed server role.  The dbo user already has the required privileges to create a geodatabase inside a database. EDIT: Looks like privileges might not be an issue since your screenshot says "User has required privileges for geodatabase setup". ... View more

I've not worked with FILESTREAM in the past, and I doubt that you'll find many others on this forum who have.  Hopefully someone will reply with their experiences.  Some quick research tells me that the FILESTREAM storage attribute in SQL server is binary (BLOB) data stored as a VARBINARY(MAX) column.  According to Esri documentation (I'm going with 10.2.x since you didn't mention your software version), that data type is 'seen' by the Esri software as a BLOB and is supported.  The documentation is here.  Specifying the FILESTREAM attribute on a VARBINARY(MAX) column causes SQL Server to store the data on the local file system instead of in the database.  Microsoft's documentation also states that a ROWGUID field with a unique non-clustered index is required to augment the attachment field.  So, while I can't say I have direct experience with this, at first glance it should be possible to achieve what you're trying to do. ... View more

While technically possible to perform inserts, updates, and deletes against an enterprise geodatabase through Microsoft Access, I would not recommend it in most cases.  To set this up, you need to go to the External Data tab in MS Access, clicked the ODBC Database button in the ribbon, and choose the option for "Link to the data source by creating a linked table" option.  This requires that you set up a DSN via the Microsoft ODBC Administrator in Windows (typically found by typing odbcad32.exe from the Start menu).  I just gave this a try with a SQL Server 2008 R2 and an Oracle 11g geodatabase using Access 2010, specifically by updating a few attribute values.  There are multiple problems with doing this.  The first problem occurs when and if your feature class is versioned within the geodatabase.  Working with versioned data involves knowledge of how the delta tables behave in accordance with the business (base) table.  Performing inserts directly against the business table but not in the A table may have negative consequences for your geodatabase.  I would always recommend using an ArcGIS client to perform edits because you can define the transactional version within your connection properties.  Hacking the business table or the delta tables is risky.  The second problem is somewhat related to the first problem.  Best practice for editing versioned data from a non-ArcGIS client is to edit the multiversion view for the feature class rather than the base table.  Multiversion views are database views according to your RDBMS and those are not open for write access via an ODBC connection using the Linked Table method I described above.  If you try to make edits from MS Access to a multiversion view, you will receive a error similar to State XXXXXXX is closed or Error during execution of trigger.  A potential third problem with this method might be that a limitation exists whereby you cannot make geometry edits, only attribute edits.  Even if you could alter the values of the SHAPE field, I would NEVER recommend doing this outside an ArcGIS client especially if you're using SDELOB.  If you're using ST_Geometry or SDO_GEOMETRY, you might be able to edit the shape using SQL but now you are talking about something way more sophisticated than a basic Form UI within MS Access.  In summary, the answer to your question is "yes, sort of, but not recommended in most cases". ... View more

This error can be caused by corrupted cookies, cookies that aren't sent, or cookies that are blocked.  It can also happen if you are requesting the Portal site from bad bookmarks.  Try clearing the local cache and the cookies from your browser and then re-requesting the Portal site.  http://kb.mozillazine.org/The_page_is_not_redirecting_properly If this does not resolve the problem... Does this issue occur with other browsers such as IE, Chrome, Opera, or Safari?  What happens if you disable all firewalls from the client and try again? ... View more

What happens if you open a CMD prompt using "Run As Administrator" using either of the following? cd c:\windows\system32 regsvr32 -u C:\WatershedSOE.Manager.dll cd c:\windows\SysWOW64 regsvr32 -u C:\WatershedSOE.Manager.dll Also, have you already upgraded ArcGIS Desktop to 10.2? ... View more

Assuming you are using some version of Microsoft Windows, what does the Event Viewer show for the time when the crash occurred? ... View more