Hi there, we have our data in Oracle (11.2.)and the feature classes are registered as versioned. I need to create a view to get data from multiple tables in order to export the aggregated data conveniently to Excel. Export needs to be done in ArcView (10.5.1). We also use third party app. When I create the view based on the versioned tables…(Show moreShow less)
If you open SQLPLUS and query against vmg_v_dbv_vertrag_test1 does it generate the same error? I am wondering if it is something the third-party app is doing and not anything with the views themselves.
I'm interacting with an existing database, created in 10.2.0 & recently upgraded to 10.6.1. It contains table entries that participate in a relationship class (M:M). I've noticed that ArcMap cant reliably "show related records" for relationship classes built pre-10.5. Has anyone else experienced this issue? Has there been a fundamental change in…(Show moreShow less)
Thanks for the response. Yeah, we were getting some crazy results returned and had thought we had corrupted our database in our latest upgrade. As of now, we are just exporting the features classes and tables out of the SQL database and joining them back up with some other software (i.e., Access, Excel, etc.) to get the information we our looking…
I'm having some issues when trying to edit a feature class. I'm getting the error "Incorrect edit version type". I'm using ArcMap (10.6.1) to edit. The sde connection is Oracle 11g and non-versioned. When I remove the feature class from the topology I have no problem editing. If I remove the feature class from the topology, then I re-add it I can…(Show moreShow less)
I would like to update a feature based on the values from another table. Can I reference other tables using attribute rules and arcade. 'FeatureSets' seems to only refer to referencing other layers in AGOL/Portal. Thanks! Xander Bakker ?
Hi T L , Good to hear that you have access to other features. When I look at the expression, there are a couple of comments that I can think of (but keep in mind that I don't really have experience with Attribute Rules): When you retrieve the other featureset you may need to include the field you want to query on (with filter). So include the…
Hi there, I have created a view in Oracle 11.2.. Its a view across three tables. I have contracts in one table and people related to the contracts in a second table (1:n). I need the people's names in a field next to the contract details (for export purposes only). Therefor I created a view using LISTAGG to concatenate all people's names…(Show moreShow less)
Hi there, I could solve the problem by doing a cast with "to_char". The LISTAGG command looks like that now: cast(listagg(to_char(nachname) || '; ' || to_char(vorname) , ' / ') within group(order by nachname) as varchar2(4000)) as eigentuemer_name, Further details can be found on my blog. Rob
I am building a comparison analysis for a database outside of my GDB, but still use the data within the GDB. I have imported the data into a File GDB and have the following fields I am working with: ACLARA_TYPE ACLARA_MODEL METER_TYPE ANALYSIS_FLAG Here is what I am doing: If ACLARA_TYPE = 39 and ACLARA_MODEL = 2 AND EQUALS…(Show moreShow less)
Hello, I created a spatial view by joining a layer and a view. For some reason I cannot Identify features and select them on the map. However: I can see the features on the map (e.g. geometry is joined) I can open attribute table and see the whole data (e.g. it's business data is joined) I can correctly zoom to a feature from the attribute…(Show moreShow less)
From time to time getting this error from the AGS Log, " RequestId: 15112 4/23/2019 6:29:19 PM 7a59b848-7642-4aa1-9c41-ac2adf9d711d Error: FDO_E_VERSION_REDEFINED. The version has been redefined to reference a new database state.. Made 19 failed attempt(s) to reconcile and save edits. Performing StopEditing (without save).FDO_E_VERSION_REDEFINED.…(Show moreShow less)
Hi Sam, The workaround I use was to Compress and Rebuild every hour depending perhaps how many concurrent users you have. We have at least 30 concurrent users. I run them both as a Task and in Task scheduler. @ 30 concurrent users every hour is required. If time is in your side, creating a named user I think is a better option. Though…