topic Re: Microsoft Jet database engine cannot find the input table or query 'GDB_DataChang in ArcObjects SDK Questions

Microsoft Jet database engine cannot find the input table or query 'GDB_DataChanges'

FrançoisRobitaille — Wed, 27 Jun 2012 21:20:48 GMT

Hi,

I'm trying to perform an edit operation on a sde10 FeatureClass in a FeatureDataset. The FeatureDataset is Registered As Versioned. I wish to delete all features in the FeatureClass. I get this message when running the code below:

The Microsoft Jet database engine cannot find the input table or query 'GDB_DataChanges'
What is the The Microsoft Jet database engine has to do with it?

This is a fresh SDE 10 installation with fresh data...! The only way I can make it work is by using a FeatureClass not in a FeatureDataset And Without registering de FeatureClass As Versioned And without performing the "Editor.StartEditing(SDEDataset.Workspace)"

Can anyone help me with this?
TIA

This is the code we are using:

      '....Some code

      'Gets the SDE FeatureClass from the FocusMap
      Dim FClassSDE As IFeatureClass = General.FindFeatLayerByName("ZZ_Test").FeatureClass

      'Start an editing session
      Dim SDEDataset As IDataset = CType(FClassSDE, IDataset)
      Dim Editor As IEditor3 = Nothing
      Dim MonUID As New UIDClass()
      MonUID.value = "esriEditor.Editor"
      Editor = CType(pGlobal.pApplication.FindExtensionByCLSID(MonUID), IEditor)

      Try
        If Editor.EditState = esriEditState.esriStateNotEditing Then
          Editor.StartEditing(SDEDataset.Workspace)
        End If

        'Delete all Features from SDE FeatureClass
        Dim TableSDE As ITable = CType(FClassSDE, ITable)
        TableSDE.DeleteSearchedRows(Nothing)' *****Returns the error!!****

       ...Some code

      Catch Ex As Exception
        MsgBox(Ex.Message)
      Finally
        If Editor.EditState = esriEditState.esriStateEditing Then
          Editor.StopEditing(False)
        End If
      End Try

Re: Microsoft Jet database engine cannot find the input table or query 'GDB_DataChang

elioelias — Thu, 28 Mar 2013 13:17:25 GMT

Did you find out what was causing this problem?

An editor who uses my custom application (in arcGIS desktop 10) is having the same error thrown within this block:

       ...
       'class used to listen to conflictsEvent (in order to ignore conflicts caused by modification tracking fields)
        Dim clistenerhelper As CConflictsListenerHelper = New CConflictsListenerHelper(m_ModifiedDate_FieldName, m_ModifiedBy_FieldName)
        Try
            Dim work As IWorkspace = GetEditableWorkspace_FCR()
            If work Is Nothing Then Throw New Exception("The editable workspace does not have any feature class registered as versioned")

            Dim editVersion As IVersion = CType(work, IVersion)
            clistenerhelper.AddConflictsHandler(editVersion)

            Dim versionEdit As IVersionEdit2 = work
            Dim conflictsWindow As IConflictsWindow2
            Dim conID As New UIDClass
            conID.Value = "esriEditor.ConflictsWindow"

            pEditor = m_Editor
            Dim AlreadyEditing As Boolean = pEditor.EditState = esriEditState.esriStateEditing
            If Not AlreadyEditing Then pEditor.StartEditing(work)

            pEditor.StartOperation()
            oper = True

            Dim conflicts As Boolean = versionEdit.Reconcile2(m_SurrogateVersionName, False)
            If conflicts Then
                pEditor.StopOperation("Reconciled against " & m_SurrogateVersionName & " version")
                oper = False

                conflictsWindow = pEditor.FindExtension(conID)
                conflictsWindow.Reset()
                conflictsWindow.Visible = True
                ConflictsPresent = True
            Else
                ' NO CONFLICTS
                conflictsWindow = pEditor.FindExtension(conID)
                conflictsWindow.Visible = False
                pEditor.StopOperation("Reconciled against " & m_SurrogateVersionName & " version")
                oper = False

                If Not AlreadyEditing Then pEditor.StopEditing(True)
                conflictsWindow = Nothing
                ConflictsPresent = False
            End If

            Dim mxDoc As IMxDocument = m_App.Document
            Dim mapView As IActiveView = mxDoc.FocusMap
            mapView.PartialRefresh(esriViewDrawPhase.esriViewGeography, Nothing, Nothing)
            mxDoc.UpdateContents()

        Catch ex As Exception
            AbortOperation_IEditor(pEditor, oper)
            AbortEditing_IEditor(pEditor)

            Throw New Exception("<ReconcileEditVersion>. " & ex.Message)
        Finally
            'Unsubscribe to Conflicts Custom Event handler
            clistenerhelper.RemoveConflictsHandler()
            CGlobal.TrackingEditor = TE
        End Try

Re: Microsoft Jet database engine cannot find the input table or query 'GDB_DataChang

FrançoisRobitaille — Thu, 28 Mar 2013 14:44:43 GMT

Hi Elio,

In fact no! We worked a couple of days trying to solve the problem with ESRI's Tech support and they weren't able to reproduce the problem while there was no way to make it work in our place...

So we used a Geoprocessor as a workaround and it did the job pretty well... After that, we just stopped searching for the answer and we kept using the geoprocessor.

Sorry I cannot help you more with this...

Good luck!