BookmarkSubscribeRSS Feed

Common External Replication Configuration Issue in SAS® Visual Investigator

Started ‎02-28-2023 by
Modified ‎02-28-2023 by
Views 748

In SAS Visual Investigator versions 10.7 and later, you can store replicated records or observations in another external table of a database. This storage method is commonly referred to as external replication.

 

However, you might run into a few issues while configuring external replications for a flow.

 

For example, you might encounter the following message when you try to select your external replication table. This message is an indicator for a common configuration issue:

 

Dhaval1_0-1677094519064.jpeg

 

 

The following reasons explain why you might experience this issue:

 

  • You might not have created your external replication table per the requirements. See the Context Records Replication Requirements for an External Table section in the SAS Visual Investigator documentation based on your version for additional details.
  • You might not have created an external entity for your external replication table in SAS Visual Investigator.
  • Column attributes in the external replication table such as name, length, assigned type, configured constraints, and so on do not match the corresponding column attributes in the source table. Note: the column names are case-sensitive.
  • You might have created or removed a column on the Fields tab for the external entity of your external replication table in the SAS Visual Investigator GUI. If this is the case, recreate the entity.
Version history
Last update:
‎02-28-2023 10:47 AM
Updated by:
Contributors

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

SAS AI and Machine Learning Courses

The rapid growth of AI technologies is driving an AI skills gap and demand for AI talent. Ready to grow your AI literacy? SAS offers free ways to get started for beginners, business leaders, and analytics professionals of all skill levels. Your future self will thank you.

Get started

Article Tags