POST
|
Hi, Does anyone know how to change the order of extended properties (not the field order but the entire property group of the extended table)? In WMX Administrator, I go to the Job type that has extended property, and there are two Extended property tables defined: 1)JTXX_EXTPROPS 2) CustomTable1. In WMX under the Extended Properties tab, the CustomTable group is at the top and the JTXX_ExtProps ins at the bottom. Is there a way to change this to switch the order of the table..? Thanks.
... View more
06-18-2013
11:13 AM
|
0
|
0
|
1530
|
POST
|
Thanks Tope. This is some logs from WMX. 3/15/2012 13:28:35.964 Level: 5 Starting ArcMap... 3/15/2012 13:28:35.964 Level: 5 Attempting to start ArcMap from C:\Program Files\ArcGIS\Desktop10.0\bin\ArcMap.exe with document C:\Documents and Settings\All Users\Application Data\ESRI\WMX\Jobs\JTX_CAD_146485.mxd 3/15/2012 13:28:36.055 Level: 5 Launching ArcMap with process ID 4988 3/15/2012 13:28:49.684 Level: 5 Finished launching ArcMap with process ID 4988 3/15/2012 13:28:49.684 Level: 5 Started ArcMap.. 3/15/2012 13:28:49.684 Level: 5 Configuring the Workflow Manager extension... 3/15/2012 13:28:49.761 Level: 5 Enabling the JTX extension... 3/15/2012 13:28:49.901 Level: 5 Passing information to job extension... 3/15/2012 13:28:49.901 Level: 5 Telling JTX extension to load the job.. 3/15/2012 13:28:49.901 Level: 5 Job-enabling the JTX extension... 3/15/2012 13:29:25.470 Level: 5 Failed to prepare correctly The remote procedure call failed. (Exception from HRESULT: 0x800706BE) 3/15/2012 13:29:25.485 Level: 5 at ESRI.ArcGIS.JTX.IJTXExtension3.set_JobID(Int32 pVal) at JTXDesktopSteps.LaunchArcMap.LoadJob() Do you have any other suggestions?
... View more
03-15-2012
09:40 AM
|
0
|
0
|
740
|
POST
|
When opening a map document from WMX's jobs, randomly it fails to load the map document. WMX popup widnow for processing status is still there, and in ArcMap the layers are added to TOC but no map displayed. I set up WMX logging option to 5 and checked ArcMap log when loading process is hung. Below is what I got when it is hung: JTXExtension: Connected to default database JTXExtension. PrepareMXD: Sleeping while waiting for ArcMap UI to be initialized JTXExtension: Added listener, FullName = ESRI.ArcGIS.JTXExt.JobPropsDockWin, type string = ~~~ JTXExtension: Added listener, FullName = ESRI.ArcGIS.JTXExt.DockableWindows.WorkflowWindow, type string = ~~~ JTXExtension: Added listener, FullName = ESRI.ArcGIS.JTXExt.Extension, type string = ESRI.ArcGIS.JTXExt.Extension In ArcMap JTX Extension toolbar didn't show up. What does this log mean?? I could launch it again after deleting Job Map and Normal.mxt files from specific user's and All User's local setting folder. Withut laoding the maps from WMX, ArcMap worked fine with Normal.mxt. Any suggestion/help would be appreciated...
... View more
03-12-2012
07:01 AM
|
0
|
9
|
3258
|
POST
|
Thanks for the reply Vince. I don't have intention to store data in SDE schema but the sde commands to create a feature class do not work when it is excuted by any other user than SDE. The user has the privileges described in the documentation as a data creator: �?�CREATE SESSION �?�CREATE SEQUENCE �?�CREATE TRIGGER �?�CREATE VIEW �?�CREATE TABLE In addtion, it also has 'UNLIMITED TABLESPACE'. 'execute any library'. But it seems to me that the user is still lacking some particular OBJECT PRIVILEGES on some objects in SDE schema...based on the previous error messages... To narrow my problem...can you give me any explaination on SE_LAYER-CREATE? Is this something in package or objects? Thank you...
... View more
01-18-2012
09:36 AM
|
0
|
0
|
615
|
POST
|
I found another symptom that is probably a similar issue... When I ran 'shp2sde -o create' command it gave me another error message: SDE Code (-51): Underlying DBMS error Extended DBMS error code: 1031 ORA-01031: insufficient privileges Error in SE_layer_create. again, the same command worked without any problems by SDE user, but the error occurs when other DB account used. I assume that it is due to lack of permission somehow but am not sure what it is... or where should I look to find the current permission on 'SE_layer_create'..? any packages or objects? I appreciate any help..!
... View more
01-18-2012
08:01 AM
|
0
|
0
|
615
|
POST
|
Thanks for the suggestion. I created the view using SQL by selecting objectid, shape, and some other attribute columns from feature classes. CREATE VIEW USER.TESTVIEW ( OBJECTID, COL_A, COL_B, SHAPE ) AS SELECT A.OBJECTID, A.COL_A, B.COL_B, A.SHAPE FROM USER.TABLE_A A, USER.TABLE_B B WHERE sde.ST_EnvIntersects (A.shape, B.shape) = 1; From the first query in your posting, I didn't get any spatial reference ID returned... One thing strange to me is that I can have this view registerd in the exact same process when the view is created in SDE schema. I also tried to run 'Register as Geodatabase' tool in ArcCatalog and traced it in database-side then I found it stops at a similar statement: SELECT layer_id, ly.description, gsize1, gsize2, gsize3, minx, miny, maxx, maxy, minz, minm, maxz, maxm, eflags, layer_mask, database_name, table_name, owner, spatial_column, cdate, layer_config, optimal_array_size, stats_date, minimum_id, base_layer_id, sr.falsex, sr.falsey, sr.xyunits, sr.falsez,sr.zunits, sr.falsem, sr.munits, sr.srtext, ly.srid,sr.object_flags,sr.xycluster_tol, sr.zcluster_tol, sr.mcluster_tol,sr2.falsex, sr2.falsey, sr2.xyunits, sr2.falsez,sr2.zunits, sr2.falsem, sr2.munits, ly.secondary_srid,sr2.object_flags FROM SDE.LAYERS ly LEFT OUTER JOIN SDE.spatial_references sr2 ON ly.secondary_srid = sr2.srid, SDE.spatial_references sr WHERE ly.srid = sr.srid AND ly.table_name = 'table_name' AND ly.owner = 'owner_name' This didn't get any rows as well. Am I missing any neccessary steps to register a view that created using SQL? + It resulted the same error with '-C option' and there were some SRID values matched with AUTH_SRID by running the query. Any further help would be appreciated.
... View more
01-11-2012
08:23 AM
|
0
|
0
|
615
|
POST
|
I attempted to run SDE command to register a view which contains a SHAPE column (in ST_GEOMETRY) as a layer. The following lines are the command that I tried to run and the error messages. >sdelayer -o register -l testview,shape -e p -t st_geometry -s servername -i servicename -u username -p password ArcSDE 10.0 for Oracle11g Build 1937 Tue Aug 16 16:08:18 2011 Layer Administration Utility ----------------------------------------------------- Error: Underlying DBMS error (-51). Error: Cannot Create Layer. ORA-00942: table or view does not exist With this error, I granted 'SELECT ANY TABLE' privilege to the user just in case it searches some tables in SDE schema...And then now I got different messages with the same command. ArcSDE 10.0 for Oracle11g Build 1937 Tue Aug 16 16:08:18 2011 Layer Administration Utility ----------------------------------------------------- Error: Underlying DBMS error (-51). Error: Cannot Create Layer. ORA-01031: insufficient privileges First I am not sure if 'Select Any Table' is required for this and why if yes. And what are the other privileges to make this work..? or is there any other permission to grant to use any objects related to ST_GEOMETRY or sptial references..? The user currently has the following permissions: CREATE INDEXTYPE CREATE PROCEDURE CREATE SEQUENCE CREATE SESSION CREATE TABLE CREATE TRIGGER CREATE VIEW EXECUTE ANY LIBRARY My SDE is at 10.0 SP3 w/ Oracle 11g R2.
... View more
01-11-2012
06:47 AM
|
0
|
7
|
3156
|
POST
|
I am running my SQL script with st_intersects and got an error. This is the problematic part: SELECT pa.pid, aa.aid FROM addresstable pa, activitytable aa WHERE sde.st_intersects (pa.shape, aa.shape) = 't'; The error that I got is: ERROR: ESRI: error changing coordref (SHAPE2) [20011]: SQL state: 22P02 The SRIDs for both layers are same. (Same ID number when checking with sdelayer -o describe_long command) So I don't understand why it attempts to change coordref...but if I run this for partial data (i.e WHERE sde.st_intersects (pa.shape, aa.shape) = 't' AND pa.pid <100; ) it worked. pa table has over 150K records if this could be a matter... Is there any restriction that I need to consider when using the spatial functions in SQL? I am using PostgreSQL 8.3 with ArcSDE 10 SP2... Thank you.
... View more
10-19-2011
05:35 AM
|
1
|
1
|
1525
|
Title | Kudos | Posted |
---|---|---|
1 | 10-19-2011 05:35 AM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:24 AM
|