BookmarkSubscribeRSS Feed

Common External Replication Configuration Issue in SAS® Visual Investigator

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

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:





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:



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Free course: Data Literacy Essentials

Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning  and boost your career prospects.

Get Started

Article Tags