Forum Discussion

JadhavVarsha_13's avatar
2 years ago

Error in Refresh HANA

Hello,

 

Getting this error for most of our reports today, can anyone help me with the same please 


There was an error when processing the data in the dataset.Hide details

Data source error:{"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 [S1010] [SAP AG][LIBODBCHDB DLL] Function sequence error"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Sales.
Cluster URI:WABI-US-EAST2-B-PRIMARY-redirect.analysis.windows.net
Activity ID:fe9db24c-c63f-4313-9bab-8e41af0db1e5
Request ID:f9a331b2-1ed3-4829-8ad6-860b46970175
Time:2024-06-19 15:31:29Z

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi JadhavVarsha_13 ,

    This error message is usually caused by an incompatibility between the ODBC driver version and the SAP HANA version.

    To resolve this issue, upgrade the HANA client as well to the same patch as server.

     
    Then, set the following property in odbc.ini file under SAP HANA DSN:
    IGNORESERVERWARNINGS=1

    Below is the link will help you:

    ERROR: "[SAP AG][LIBODBCHDB SO] Function sequence error.." while running sessions having SAP HANA source (informatica.com)

    Best Regards,

    Xianda Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi JadhavVarsha_13 ,

    Have you solved the current problem?

    Best Regards,

    Xianda Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.