Incremental Refresh Error - DB2

[tbastian]

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 

[GilbertQ]

Hi @tbastian 

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

[tbastian]

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 ?