SAP Knowledge Base Article - Public

2885847 - Failed to refresh import jobs in the model after user or password changed in data source system in SAP Analytics Cloud (SAC)

Symptom

  • Failed to refresh import jobs in the model after user or password changed in datasource system in SAP Analytics Cloud (SAC).
  • When refreshing the import job, the old user and password is used while connecting from SAC to the underlying data source system.

Environment

  • SAP Analytics Cloud (Enterprise)
  • Models on any imported connections. 

Reproducing the Issue

  1. Create an Acquire Data connection of SAP BW.
  2. Create a model on this import BW connection.
  3. Confirm import job successfully finished.
  4. Change the user and password in BW system.
  5. Update the same in the Acquire Data BW connection in SAC tenant.
  6. Try to run refresh job again and it returns error message:
    Error: Query view instantiation failed: name or password is incorrect.

Cause

The metadata of the query is not updated after making the change in the import BW connection.

Resolution

To update the metadata please refer to the following steps:

  1. Open the model and navigate to Data Management.
  2. Select the import job with issue and click Edit Query.
  3. Confirm that the query is connecting to the data source system successfully, save the query.
  4. After saving the query then the metadata should be updated.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, Import Data connection refresh error, Our models getting error message when we try to refresh. , KBA , when the user (who has create the query) , change his password the data can’t be r , data cannot can't be refresh refreshes r , refreshed , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0