Latest Contributions by HiteshJilka

Hello, Arcgis 10.3, Oracle RDBMS: 12.1.0.2... is there a way for two feature class (say parent and child) to share same geometry shape but have their own set of attributes? New features created or updated on parent feature class share its geometry shape to child feature class but not any of its attributes. ... View more

Hello, ArcSDE: 10.3 Oracle: 12.1.0.2 Charset: AR8MSWIN1256 Our parent GDB contains feature class that has one field storing Arabic text. After Syncing with child GDB, in child GDB,  some of parcels value text is missing and it is showing question mark symbol (?) in replacement for some of the parcels. Checked in at SQL level as well but shows the same result. Other field values are intact that are stored in English.  As parent GDB has data present, it looks like during sync operation it replaced those Arabic text into symbol (?). Also, this has affected only 4-5 parcels, other parcels has values in Arabic. Both of GDB's having same database properties and same ArcSDE version. Would anyone please help me on this.  Thanks!!! ... View more

ArcMap Desktop: 10.4 SDE: 10.3 RDBMS: Oracle 12.1.0.2 After compressing GDB we are encountering below error while saving changes to our DEFAULT version.  "Unable to reconcile: the target version is currently being reconciled against" Users are not able to save their edits and have to stop their edits. There is no other version created or used by anyone.  Is there a bug on SDE 10.3 because this had occur earlier as well after compression... Do we have any solution for preventing this error. Thanks! ... View more

Hello, Sync operation is taking lots of time and when I see at execution plan of query fired within it shows most of time spend is at Domain Index.  ------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ------------------------------------------------------------------------------------------------------------------------- | 9 | DOMAIN INDEX (Sel: Default - Undefined) | A157_IX1 | | | 18E (0)|999:59:59 | From support, found below note: If (Sel: Default - Undefined) is reported it may indicate that there was an error generating statistics, or that the operator has been disassociated from the statistical type, such as the st_envintersects operator. I tried to gathered STATS and rebuilt index but it doesn't improve the sync time. Would anyone please help on this.  ... View more

Hello, ArcSDE v. 10.3 RDBMS: Oracle Db Enterprise 12c (12.1.0.2) We have replicas with full extent and some with extent to their city boundaries. Full extent replica synchronizes successfully even if I sync it in same day or after few days or even a week. Extent based replica synchronizes successfully if I sync in same day or a gap of two days. But if I skip sync for more days (say 4 days) it fails with error "ORA-03114 not connected to Oracle" error after processing data. As there is loads of transactions saved daily, thus size of data transfer increases and as per my understanding, for extent boundaries replicas, data filtering before transfer causes long wait and thus results in error. It took more than 4 hours to filter data and then sync failed. Attached error screenshot FYR... There is no connection timeout configuration done on Oracle side.  Will anyone please help me whether its a bug or any connection settings need to be done to prevent the same error. Thanks, Hitesh ... View more

Recently we fully compressed our Oracle GDB to bring it back to STATE 0. Later updated STATS and Rebuilt Indexes. But now users are complaining for slow performance while editing and saving. One of feature of type Annotation is extremely slow while edit and save. Please suggest on how we can improve performance. ... View more

Hello, I am testing a scenario where if I drop a field on Archive enabled dataset it also deletes the same field on Archive table. But I wanted to preserve that field and its data on Archive table. Is it possible ? I would not likely to disable archiving before deleting a field and re-enable it again as dropping a field can be done anytime and by anyone who is not aware of Archiving. Also, is it possible to use the same archive table again after re-enabling Archive for same dataset ? ... View more