topic Re: Target state not found in the STATES table[STATE_ID = 333001] in Geodatabase Questions

Target state not found in the STATES table[STATE_ID = 333001]

JoseSanchez — Wed, 09 Oct 2019 11:57:59 GMT

Hello everyone,

Any idea of how to check for this error in the database. We are using ArcSDE SQL Server.

"Target state not found in the STATES table[STATE_ID = 333001]"

Thanks

Re: Target state not found in the STATES table[STATE_ID = 333001]

CraigSwadner — Wed, 09 Oct 2019 12:17:38 GMT

When was the last time you did a full compress ?

Craig Swadner (GIS Coordinator)

City of Cape Coral

1015 Cultural Park Blvd.

Cape Coral, Fl 33990

Did you know the best way to report issues to ITS is to use the Service Desk system? This will ensure someone in ITS gets your request and allows us to track the progress. Please enter all your issues and/or questions by clicking https://breeze.cape.capecoral.net

Re: Target state not found in the STATES table[STATE_ID = 333001]

JoseSanchez — Wed, 09 Oct 2019 12:53:05 GMT

We compress the SDE Database daily using batch jobs.

This is what Esri recommends:

https://support.esri.com/en/technical-article/000013519

Re: Target state not found in the STATES table[STATE_ID = 333001]

George_Thompson — Wed, 09 Oct 2019 14:09:37 GMT

Have you tried these tools to help identify the issue:

Diagnose Version Metadata—Help | ArcGIS Desktop

Diagnose Version Tables—Help | ArcGIS Desktop

If there are issues, you can then run the following tools:

Repair Version Metadata—Help | ArcGIS Desktop

Repair Version Tables—Help | ArcGIS Desktop

Note: Be sure to take a full and verified backup of the Enterprise Geodatabase before completing these task.

Re: Target state not found in the STATES table[STATE_ID = 333001]

AndreaB_ — Mon, 01 Apr 2024 20:38:28 GMT

Hi @George_Thompson

I'm trying to run the Diagnose Version Metadata https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/diagnose-version-metadata.htm

and the Diagnose Version Tables https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/diagnose-version-tables.htm

but what do I input for the Diagnostic Version Metadata Log and the Diagnose Version Tables Log? Are these existing Log files sitting somewhere?

Thanks,

Andrea

Re: Target state not found in the STATES table[STATE_ID = 333001]

George_Thompson — Tue, 02 Apr 2024 10:34:25 GMT

I think those would be tables that are created by the tool to record any results. They could be "new" tables in your Enterprise Geodatabase or in another file geodatabase.