Latest Contributions by RobertHu

Thank all of you! ... View more

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

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

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

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

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

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

You can use "arcpy.CreateFileGDB_management" within a python "for" loop to accomplish this, and should be fairly easy. Thanks! ... View more

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

You need to compress the SDE GDB. ... View more

Did you register the layer as versioned? Or did you choose the non-versioned editing option? ... View more

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