3710193 - Existing jobs may fail after making changes (i.e., host, port, credential, endpoint, etc.) to import connections in SAP Analytics Cloud(SAC)

• In SAP Analytics Cloud (SAC), you can generally modify an existing Import Data Connection, even if it is already used by multiple Import Jobs
• Existing Import Jobs continue to reference the same connection object (via connection ID), so changes to the connection are inherited by those jobs
• However, sometimes, the existing jobs may fail after making changes (for example host, port, credential, endpoint, etc.) to those import connections
  Possible Errors:
  • Schema of data source has been changed
  • Query view instantiation failed: name or password is incorrect.

1. Login to SAC tenant.
2. Create one import data connection.
3. Create one import job based on the connection to load data from source system.
4. Make some change to the import connection (i.e., changing one import connection from DEV to PRD).
5. Try to run the jobs created and executed successfully in step 3 again.
   => It fails.

• The underlying data structure and objects may be different between two source systems.
• For Import SQL Connection, you may change database name, which is written into job metadata. However, it is impossible in current product to update the new database name modified in connection dialog into metadata of existing jobs as per SAP KBA 3283906)

• If the source system is changed (i.e., from DEV to PRD), please ensure that the underlying data structure and objects remain identical between two source systems. 
  • For example, for Import HANA Connection, the calculation view used to create the job must exist under same schema and package with same columns (dimension + measures) in the target system.
  • SAP KBA 2927003 provides another example for import jobs from File server.
  • If the the underlying data structure and objects are different between two source systems, you may need to create a new connection to the new system and create new jobs.
  • SAP KBA 2919801 will help you to find the job metadata and then you can compare with the the underlying data structure and objects in the target system.
• If user or password is changed in data source system, you need to update the job metadata by following the steps described in SAP KBA 2885847.
• [Important] It is always recommended to create one separate connection to carry out some tests before changing the the connection on which a lot of jobs have been created.

• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
• 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• Search for SAP Analytics Cloud content using Google or Bing:
  • https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
  • https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
  • Note: Add relevant text or warning/error messages to the text search field to filter results.
• SAP Analytics Cloud Connection Guide
• Getting Started with SAP Analytics Cloud Expert Community page
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support or visit the solution finder today!

SAP Analytics Cloud, Import jobs, Connection, data management, acquired connections, metadata, host, port, enhancement request, troubleshooting, performance issues, planning model, refresh, switch sources, credentials, product behavior , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem