SAP Knowledge Base Article - Public

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

Symptom

  • Failed to refresh import jobs in the model after user or password changed in datasource system.
  • When refreshing the import job it's always using old user and password while connecting from SAC to the datasource system.

Environment

  • SAP Analytics Cloud (Enterprise) 2020.3.0
  • 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 importing job is 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 imported 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 on Edit Query.
  3. Confirm that the query is connecting to the datasource 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 , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem

Product

SAP Analytics Cloud 1.0