Forum Discussion

IanCockcroft's avatar
IanCockcroft
Icon for Post Patron rankPost Patron
5 years ago
Solved

Gateway failing

Hi guys,

a number of y gateway refreshes are failing with the following 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":"We're sorry, an error occurred during evaluation."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}}],"exceptionCulprit":1}}} Table: Story.
Cluster URI:

 

same error on 3 differerent gateways. The only difference is the table name.

any one know what it means?

thanks

  • Hi IanCockcroft 

    What do you mean by 3 different Gateways? it can only be one Gateway with the right credentials to be able to connect to the server's source. So, it's either the credential, or the tables that don't match or the Gateway is out of date. Try first upgrading the Gateway and create a one new Gateway Connection with the right login and PSW.

     

2 Replies

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion

    Hi IanCockcroft 

    What do you mean by 3 different Gateways? it can only be one Gateway with the right credentials to be able to connect to the server's source. So, it's either the credential, or the tables that don't match or the Gateway is out of date. Try first upgrading the Gateway and create a one new Gateway Connection with the right login and PSW.

     

    • IanCockcroft's avatar
      IanCockcroft
      Icon for Post Patron rankPost Patron

      Hi Amine, thanks for pointing me in the right directions.

      we have datasets from different sources SQL, oracle etc.

      I couldt understand if its a data error or not. doubtful being a different source.

      turns   out credentials had expired.