SAP Knowledge Base Article - Public

3156531 - Error "The Google credentials for this BigQuery connection have expired. Please edit this connection and reauthenticate with Google" for Connection and Model based on Import Connection to Google BigQuery

Symptom

  • For Import Connection to Google BigQuery (GBQ), data import models jobs are failing with the error message: "The Google credentials for this BigQuery connection have expired. Please edit this connection and reauthenticate with Google"
  • The error message appears 24 hours or less after reauthenticating to the same Google BigQuery project.
  • We create a new BigQuery connection from SAC with an username and password. For the day everything goes well, but the next day, if we want to use the data model already created or create a new data model/query, the system throws the above message.
  • Chrome HAR trace shows the error message: "EPM_SERVICE : {"errorCode":"PLUGIN_ERROR","rawError":"reauth related error (invalid_rapt)","errorDefinition":"{\"code\":\"ERROR_TOKEN_EXPIRED\",\"rawError\":\"reauth related error (invalid_rapt)\",\"params\":[\"\"]}","isUserError":false}"
  • It was working well previously, and these symptoms were not observed.  The issue seems to start in SAC Wave 2022.3

Environment

  • SAP Analytics Cloud (Enterprise) 2022.3

Reproducing the Issue

  1. Create Import Connection to Google BigQuery
  2. Create a model based on the above connection
  3. Schedule to run date import job repeatedly
  4. Import jobs succeed on the first day; For any subsequent scheduled job or manual refresh around one day later, it fails with the error message: "The Google credentials for this BigQuery connection have expired. Please edit this connection and reauthenticate with Google"

Workaround: Manually edit the connection to reauthenticate with Google.

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

Keywords

KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0