Forum Discussion

tbastian's avatar
tbastian
Frequent Visitor
3 years ago

Incremental Refresh Error - DB2

Hello All,

 

I am facing an error while trying to set up Incremental Refresh. The Underlying Data source is a DB2<LUW> database on premise and i am accessing it through a Gateway.

The report works fine on the desktop .. but when published to the service and a refresh is attempted .. it fails 

part of the error message is below. The gateway can refresh other reports< without incremental refresh> from the same Database without issues  . 

[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The credentials provided for the DB2 source are invalid.

 

{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"AccessUnauthorized"}}],"exceptionCulprit":1}}

 

Does anybody have any insight on how to get around this ? 

 

Thank you very much 

 

Thomas 

Need Help

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    3 years ago

    Hi tbastian 

     

    That error appears to be a credential issue is not being authenticated to the DB database.

    • tbastian's avatar
      tbastian
      Frequent Visitor
      3 years ago

      Thank you for the response Gilbert.

      It doesnt look like it is an issue with the Credentials.

      I tested it on another report accessing the same Table and without Incremental refresh  and that refreshes without issues on the gateway . Could it be that the proper Error message is not being displayed ?