nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

DBMS table not found-invalid object name

AlicePence

This error pops up when I'm trying to edit a feature in a feature class:

"Attribute Update: An unexpected failure occurred. DBMS table not found [42S02:[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'port.mv_ELEC_VAULT'.][gisdb.PORT.elec_vault]

but it lets me delete the feature and I can create a new feature as well. I've tried unregistering and re-registering DB and compress and all that -

Vind meer berichten getagd met

Accepted answers

Christian_Wells

That sounds great...here is a quick reference on using the SDE Command Line tools with a version above 10.2.x: FAQ: Can ArcSDE command line tools be used against 10.3 and newer geodatabases?

Here is the command line reference if needed:

ArcSDE Administration Command Reference

All comments

Christian_Wells

The "mv_" prefix looks like this was a multi-versioned view created some time at or prior to a 10.x version of the geodatabase. As such this may be an orphaned metadata entry in the Geodatabase.

In ArcCatalog, can you have the dataowner schema Enable SQL Access on the feature class? It may be as simple as having the object created for the reference metadata. Here are instructions on creating the versioned view: What is a versioned view?—Help | ArcGIS Desktop

AlicePence

I was wondering if that "mv_" was related to a multi-versioned view created before. I tried your step and the Enable SQL Access option is greyed out and I'm the dataowner

Christian_Wells

Ok, it sounds like this might be an orphaned repository record. Does that table (port.mv_ELEC_VAULT) exist in the database?

If not, do you mind if we get you connected with Technical Support?

AlicePence

I've looked in Table and Views in SQL server have not been able to find that port.mv_ELEC_VAULT - either its really good at hiding or it no longer exists (I fear the latter). I've found past documents on our GIS DB creation showing that MV tables are required, so not sure how those are set up ie different than the versioned tables that end in "_evw"

Christian_Wells

In the past, they would have been set up using the SDE command-line tools (deprecated at 10.2.x). Do you mind if I get you connected with Technical Support to help identify the cause and suggest a resolution?

AlicePence

I think we are getting closer now to figuring out the issue and it's those MV tables that -like you said- need to be created with the SDE command-line tools. I'm meeting with my team here soon to find if there is extra documentation somewhere about creating those and if we get stuck again - I'll gladly take that Tech Supports help. Thanks for the bit of insight of the issue so far!

Christian_Wells

That sounds great...here is a quick reference on using the SDE Command Line tools with a version above 10.2.x: FAQ: Can ArcSDE command line tools be used against 10.3 and newer geodatabases?

Here is the command line reference if needed:

ArcSDE Administration Command Reference

AlicePence

So after following your links i was able to see that if I use the 'Create Database View' tool and just straight up make a view called "mv_ELEC_VAULT" that trigger (created way before my time...) ended up working!! No need to figure out how to use the SDE Command Line tools -

Again, thanks for your insight and I was able to get the issue resolved. Now off to making all these new views.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.