Latest Contributions by Myoung-okYoo

Can I do 'create local copy for editing' of feature service by specific layers or extent? Or can I use this function of large datasets? ... View more

​hi. Some layers was drawing fail on enterprise geodatabase (oracle 10g R2) I was able to see the records on attribute view on ArcMap 10.1. But geometry infomation was not drawing with below message ---------- Underlying DBMS error [ORA-29902: error in executing ODCIIndexStart() routine ORA-01006: bind variable does not exist ORA-06512: at "SYS.DBMS_SYS_SQL", line 913 ORA-06512: at "SYS.DBMS_SQL", line 45 ORA-06512: at "SDE.SPX_UTIL", line 1480 ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 139 ::SELECT V__1941.st_SHAPE$, V__1941.OBJECTID, V__1941.st_points,V__1941.st_numpts,V__1941.st_entity,V__1941.st_minx,V__1941.st_miny,V__1941.st_maxx,V__1941.st_maxy,V__1941.st_minz,V__1941.st_maxz,V__1941.st_minm,V__1941.st_maxm,V__1941.st_area$,V__1941.st_len$,V__1941.st_rowid FROM (SELECT 1 st_SHAPE$ ,b.OBJECTID,b.SHAPE.points as st_points,b.SHAPE.numpts as st_numpts,b.SHAPE.entity as st_entity,b.SHAPE.minx as st_minx,b.SHAPE.miny as st_miny,b.SHAPE.maxx as st_maxx,b.SHAPE.maxy as st_maxy,b.SHAPE.minz as st_minz,b.SHAPE.maxz as st_maxz,b.SHAPE.minm as st_minm,b.SHAPE.maxm as st_maxm,b.SHAPE.area as st_area$,b.SHAPE.len as st_len$,b.rowid as st_rowid FROM WIIS.FLOWMETER_PS b WHERE SDE.ST_EnvIntersects(b.SHAPE,:1,:2,:3,:4) = 1 AND b.OBJECTID NOT IN (SELECT /*+ HASH_AJ */ SDE_DELETES_ROW_ID FROM WIIS.D1941 WHERE DELETED_AT IN (SELECT l.lineage_id FROM SDE.state_lineages l WHERE l.lineage_name = :lineage_name1 AND l.lineage_id <= :state_id1) AND SDE_STATE_ID = 0) UNION ALL SELECT 2 st_SHAPE$ ,a.OBJECTID,a.SHAPE.points as st_points,a.SHAPE.numpts as st_numpts,a.SHAPE.entity as st_entity,a.SHAPE.minx as st_minx,a.SHAPE.miny as st_miny,a.SHAPE.maxx as st_maxx,a.SHAPE.maxy as st_maxy,a.SHAPE.minz as st_minz,a.SHAPE.maxz as st_maxz,a.SHAPE.minm as st_minm,a.SHAPE.maxm as st_maxm,a.SHAPE.area as st_area$,a.SHAPE.len as st_len$,a.rowid as st_rowid FROM WIIS.A1941 a,SDE.state_lineages SL WHERE SDE.ST_EnvIntersects(a.SHAPE,:5,:6,:7,:8) = 1 AND (a.OBJECTID, a.SDE_STATE_ID) NOT IN (SELECT /*+ HASH_AJ */ SDE_DELETES_ROW_ID, SDE_STATE_ID FROM WIIS.D1941 WHERE DELETED_AT IN (SELECT l.lineage_id FROM SDE.state_lineages l WHERE l.lineage_name = :lineage_name2 AND l.lineage_id <= :state_id2) AND SDE_STATE_ID > 0) AND a.SDE_STATE_ID = SL.lineage_id AND SL.lineage_name = :lineage_name3 AND SL.lineage_id <= :state_id3) V__1941] ----- I doubt some geography meta information of the layer, was crashed. the number of layers with the problem is getting more. Even not-editing layer has same problem. what things do I check on the geofdatabase? Any ideas will be helpful for me. THanks. ... View more

Hi~, I was reported by a load-test team of one client project. They said two many function call requested by ArcSOC.exe. and to improve performance of sql query, should modify function call to raw sql statements. they gave me the function-call sql like SDE.ST_EnvIntersects. I want to check two things. - Using function call, is more load on DB, than sql query. - If yes, How to reduce internal function call?                A. reduce returned features.      - to fetch versioning data , require bigger function call than non-versioning data?       (I see delta tables query in sql scanning) Thanks. ... View more

Is there a tool to delete multiversioned view on ArcGIS for Desktop? I have tried to delete multiversion view which created by 'Enable SQL Access' menu on ArcCatalog. Until now, I could not find ways to delete it on Desktop. Do I have to delete using sde command of sdetable. Thank you for your advice. ... View more

Does Operational Dashboard support custom basemaps with custom Spatial references? It could not display on the map widget. It displays only basemaps of 102100(3856) Thank you. ... View more