POST
|
I am going to create caches on some image services. It is said increase number of instances on the CachingTools can improve caching speed. I checked the instance number, it is set as 3. I guess it is the default. My question is that what is the relation between the instances and the system resources. My server is quad-core (8 threads) CPU, 2processors. Am I right that each instance will consume one thread, and hold it until the caching completes? Thanks!
... View more
04-17-2014
11:13 AM
|
0
|
4
|
3945
|
POST
|
Hi Sebastian, Don't have a solution yet. I opened a support request on 11/28, and worked with someone from ESRI geodata team for a few weeks. I was told at least one more user (probably you) experienced same thing, and a quite few tech support people got involved. They were able to reproduce my problem on their site, but couldn't figure out why or a work around. Since the issue is no longer a SQL agent job issue, they transferred my case to the Desktop team in late December. Now I'm still working with them for a solution. You are right, it failed, and only failed, on "import arcpy" and the script being run as a background. Without this statement (or run it interactively), everything works fine. By the way, the domain user I used to run the process is a member of the local administrator group on the DB server. I'll let you know if a solution comes out. Thanks!
... View more
01-02-2013
07:55 AM
|
0
|
0
|
1537
|
POST
|
Hi Randy, It is the same user. I used the same user to login the DB server, run the batch file from command prompt, run the SQL scheduled job, and run the system scheduled task. The one from command worked fine. The other two failed. What troubles me is that when it failed, it left nothing in the logfile, simply quit. Cannot collect any error message. So, don't know if it is the SQL Server problem (apparently not), user's issue (don't know), arcpy's settings (most likely), or something else. By the way, thank you so much for trying to help me!
... View more
12-13-2012
09:38 AM
|
0
|
0
|
1537
|
POST
|
Posted my problem in another forum (GP), and no luck. Try here. Python 2.7 ArcGIS 10.1 (sp1) ArcSDE 10.1 (sp1) SQL Server 2008 R2 Standard (sp2) Windows Server 2008 R2 Standard (sp1) Run a batch file, which calls a python script, as SQL Server scheduled job. If the python script includes "import arcpy" statement, the script will fail without leaving any error message. The script works fine without the "import arcpy" statement. Tried same thing as a system scheduled task, the results are same. While running the batch file from command line, it works fine with or without the "import arcpy" statement. Anyone ever experienced same thing, and have a clue? Thanks in advanced!
... View more
12-12-2012
01:25 PM
|
0
|
10
|
6038
|
POST
|
Python 2.7 ArcGIS 10.1 (sp1) ArcSDE 10.1 (sp1) SQL Server 2008 R2 Standard (sp2) Windows Server 2008 R2 Standard (sp1) Run a batch file, which calls a python script, as SQL Server scheduled job, if the python script includes "import arcpy" statement, the script will fail without leaving any error message. The script works fine without the "import arcpy" statement. Tried samething as a system scheduled task, the results are same. While running the batch file from command line, it works fine with or without the "import arcpy" statement. Anyone ever experienced same thing, and have a clue? Thanks in advanced!
... View more
12-12-2012
10:02 AM
|
0
|
1
|
4782
|
POST
|
I wonder why you need to register a SDE spatial view. I use 'sdetable -o create_view' to create SDE spatial views a lot. Never register the views after creation. They seem working fine with ArcGIS (i.e. ArcCatalog, ArcMap, GP tools).
... View more
07-12-2012
08:04 AM
|
0
|
0
|
422
|
POST
|
You can try to re-create the sde login and map it to the sde user in all of your GDBs under the instance. This probably is the easiest way. But as I said, I never deleted the sde login on my instance, and never want to try, not even on my dev sever. So, don't know if it will work. Thanks!
... View more
02-28-2012
06:56 AM
|
0
|
0
|
1001
|
POST
|
During normal post install of ArcSDE, a sde login is created and that login is associated to a user schema in your spatial database. Along comes a DBA and deletes all logins except sa. I can still connect to my spatial database via Direct Connects. Are the SQL login accounts needed for anything? If a "sde" login was created in postinstallation, you must use the sde schema for your GDB. The "sde" DB user owns all objects in the SDE repository. If your DBA deleted the "sde" login, which login is mapped to the "sde" user in your GDB? I'd say your DBA made a big mistake. I don't know if the "sde" login is absolutely necessary. But I DO believe with the sde schema, even you can map another login to the "sde" DB user and it works, you'll have lots of headaches to manage the SDE repository down the road. I would never want to try it.
... View more
02-27-2012
07:26 AM
|
0
|
0
|
1001
|
POST
|
I agree with you. You posted too many questions at once, and many of them are too long. Those who are capable to provide helps may not want to write a book to answer your questions. Others may not even have patience to go through the questions. Make it short and specific, easier to test and isolate the problem, you'll have better chance to get answers. It is just my opinion. By the way, I checked my SDE GDBs on both my dev and production boxes. The "public" DB role only has permission on sde owned objects, as well as some sys objects. I used the sde schema while creating all my GDBs. So, I don't think the SDE postinstallation is flawed, at least when using sde schema. Are you using dbo schema? If you setup your user correctly, a DB reader shouldn't be able to create GDB feature class in ArcCatalog. You will get error as, Failed to create feature class. Database user name and current user schema do not match. [GDB_TEST.MY_TEST.My_FC] However, that user will be able to create feature dataset. But you may not be able to do anything with that FD. My system: Windows Server 2008 R2 Standard/SQL Server 2008 R2 Standard/ArcSDE 10.0 (sp1) Thanks!
... View more
01-30-2012
08:44 AM
|
0
|
0
|
1137
|
POST
|
You can use "arcpy.CreateFileGDB_management" within a python "for" loop to accomplish this, and should be fairly easy. Thanks!
... View more
01-25-2012
12:13 PM
|
0
|
0
|
124
|
POST
|
You can use "Feature Vertices To Points" GP tool with "BOTH_ENDS" option to create a point FC which only contains polyline start and end points.
... View more
12-14-2011
07:54 AM
|
0
|
0
|
1732
|
POST
|
Did you register the layer as versioned? Or did you choose the non-versioned editing option?
... View more
11-28-2011
09:59 AM
|
0
|
0
|
236
|
POST
|
Hi Nick, I've seen many times in this forum ESRI experts encourage users to use file geodatabase, especially if you just start exploring geodatabase. If I remember it right, the personal geodatabase (Access) will be depracated when ArcGIS moves in full 64-bit. Thanks!
... View more
10-25-2011
07:00 AM
|
0
|
0
|
466
|
Title | Kudos | Posted |
---|---|---|
1 | 09-22-2010 09:23 AM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|