Latest Contributions by JoseSanchez

Hello everyone, the goal is to create an application or script that extracts by feature class all the records that were created, deleted and updated from the previous day, and then replicate them in a production database used only for read only access. How do you select and extract from a feature class all the features that were inserted, deleted and updated, since for example yesterday? thanks ... View more

Hello everyone, When I delete a feature dataset using Python with SDE 10.2, I get the error messages listed below: This only happens with Python. I am able to delete the eature dataset with ArcCatalog 10.2.2. in SDE. Also if I run the same script in Python but pointing to  File Geodatabase it works fine. My configuration: - ArcGIS 10.2.2 - Python 2.7.5 - SDE 10.2 - Oracle 11G Executing: Delete ...MyFeatureDatasetwithTopology FeatureDataset Start Time: Wed Oct 28 15:25:30 2015 DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist ][MDC.T_20_PolyErrors]] DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist ][MDC.T_20_PolyErrors]] DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist ][MDC.T_20_LineErrors]] DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist ][MDC.T_20_PointErrors]] Table not registered [ORA-00942: table or view does not exist ] [MDC.FFFFF] Table not registered [ORA-00942: table or view does not exist ] [MDC.T_20_LineErrors] Table not registered [ORA-00942: table or view does not exist ] [MDC.M] Table not registered [ORA-00942: table or view does not exist ] [MDC.T_20_DirtyAreas] Table not registered [ORA-00942: table or view does not exist ] [MDC.T_20_PointErrors] Table not registered [ORA-00942: table or view does not exist ] [MDC.MMMMM] Table not registered [ORA-00942: table or view does not exist ] [MDC.T_20_PolyErrors] DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist ][MDC.T_20_PolyErrors]] The item was not found. The item was not found. DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist ][MDC.T_20_PolyErrors]] DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist ][MDC.T_20_LineErrors]] DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist ][MDC.T_20_PointErrors]] DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist ][MDC.T_20_DirtyAreas]] The item was not found. Failed to execute (Delete). Failed at Wed Oct 28 15:26:13 2015 (Elapsed Time: 43.29 seconds) ... View more

H all I am building an Add-In that needs to connect to an Oracle database, so I added  an “app.config” file and a connectionStrings tag, but it does not work because it does not find the config file from the .vb program  <connectionStrings> clear/> add name=MyConnectionString" providerName="System.Data.OracleClient" connectionString="Data Source=XXXXPersist Security Info=True;User ID=AAA;Password=XXXX; Unicode=True;" /> <connectionStrings> How can I read a config file from an Add-In? Thanks ... View more

Hello everyone, In ArcMap whenever I start an editing session and try to "Open Attribute Table" I get an error message: "Could not load data from data source. If you can correct the problem, press the refresh button to reload data. Possible problems can include bad network connection, invaluid field, etc. Unable to create logfile system tables. User perhaps lacks permission or resources to create tables" I am working in SDE 10.2 and this happens when I try to edit a feature class that is not versioned. anyone with a similar issue? ... View more

Hi all, How can I see the table GDB_ITEMS  in a FGDB ? I need to check the errors listed in a geometric network thanks ... View more

Hello everyone How can I create an sde view in 10.2.2? In 10.1 and previous version I was using: sdetable -o create_view -T .... -t "..., ..."  -c "..., Thanks ... View more

Hello everyone, We are using Oracle 11 G. The Append and Delete versioned tables form one feature class have a text field with a length smaller than the same field in the feature class. the reason isthat I run an Oracle script to alter this field size on the feature class. Is there a way to resize this same field in the table Annnn  and Dnnnn with an SDE command? Can I run in Oracle: ALTER TABLE     Annnn     MODIFY     (      [myfield] nvarchar2(80)     );   commit; ... View more

Hello everyone, How do you ftp a file geodatabase? Do I need to zip it? Thanks ... View more

Hi all We added a field angle in a point FC. Is there a way to rotate the point 90degrees and keep the new value in the field angle and see it it in the symbology. thanks ... View more

Hello everyone, We have several FC that have default values on fields and these values are visible in ArcCatalog but when we edit the versioned layers with ArcMap  the default value is not showing. Any suggestion in how to fix this issue. thanks ... View more