Forum Discussion

QEDavidLayton's avatar
QEDavidLayton
Advocate I
1 year ago

Error not specified refreshing MS Access data set

Hi community!

 

Since a couple of days, I'm getting a failure message upon refreshing a MS Access data set:

Error del origen de datos: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Error no especificado"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"*******.mdb"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: *****.
URI de clúster: WABI-WEST-EUROPE-D-PRIMARY-redirect.analysis.windows.net
Identificador de actividad: df76499f-c0b5-4092-97e8-7d8c4456ea77
Identificador de la solicitud: ba0e4918-3b4a-7be6-642c-0b666f84f4aa
Hora: 2024-12-03 14:51:11Z

 

As you can see the details are "not specified" or "unknown"

 

There seems to be an error related to Data Format. However, I tried refreshing a super reduced version of the report with just one table and a few rows and I keep getting the same error.

 

Not long ago, we updated on premise gateway version to 3000.246.5 (Nov 2024).

 

Any suggestions?

5 Replies

  • DavidSVC's avatar
    DavidSVC
    Regular Visitor

    Hi community! 

     

    Since a couple of days, I'm getting a failure message upon refreshing a MS Access data set: 

     

    Error del origen de datos: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Error no especificado"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"*******.mdb"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: *****.
    URI de clúster: WABI-WEST-EUROPE-D-PRIMARY-redirect.analysis.windows.net
    Identificador de actividad: df76499f-c0b5-4092-97e8-7d8c4456ea77
    Identificador de la solicitud: ba0e4918-3b4a-7be6-642c-0b666f84f4aa
    Hora: 2024-12-03 14:51:11Z

     

    As you can see the details are "not specified" or "unknown"

     

    There seems to be an error related to Data Format. However, I tried refreshing a super reduced version of the report with just one table and a few rows and I keep getting the same error.

     

    Not long ago, we updated on premise gateway version to 3000.246.5 (Nov 2024).

     

    Any suggestions?

  • Hi everyone!

     

    Since a couple of days, I'm getting a failure message upon refreshing a MS Access data set: 

     

    Error del origen de datos: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Error no especificado"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"*******.mdb"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: *****.
    URI de clúster: WABI-WEST-EUROPE-D-PRIMARY-redirect.analysis.windows.net
    Identificador de actividad: df76499f-c0b5-4092-97e8-7d8c4456ea77
    Identificador de la solicitud: ba0e4918-3b4a-7be6-642c-0b666f84f4aa
    Hora: 2024-12-03 14:51:11Z

     

    As you can see the details are "not specified" or "unknown"

     

    There seems to be an error related to Data Format. However, I tried refreshing a super reduced version of the report with just one table and a few rows and I keep getting the same error.

     

    Not long ago, we updated on premise gateway version to 3000.246.5 (Nov 2024).

     

    Any suggestions?

  • Do you remember the previous gateway version?  

     

    (you probably know that .mdb is positively ancient. It requires a special 32 bit driver and has lots of locking issues.  If you can, move to something a little fresher.)

    • DavidLayton's avatar
      DavidLayton
      New Member

      Hi lbendlin,

       

      Previuous version was August 2024 update (3000.234). 

       

      I've searched the code -2147467259 and I found the following: "The HResult code -2147467259 is a generic error in Windows applications and translates to E_FAIL, which indicates an unspecified failure"

      HRESULT Values

       

      I know how bad can be working with Access... Unfortunately, I don't think migration will happen in the near future. I guess restarting the Access server won't hurt anybody.

       

      Thanks