Problem Note 71159: A scenario flow that uses external replication fails with the error "Failed to replicate… invalid character..." when the primary key is non-numeric
 |  |  |  |  |
A scenario flow using external replication fails with the Failed to replicate... error when the input table primary key is non-numeric.
The following error occurs in the VSD logs:
2025-01-27 11:33:30.337 ERROR 656818 — [lTaskExecutor-1] c.s.f.v.p.service.SqlBatchService : postman-nld-dev@@nld [b2ee240340e0189f] Failed to replicate
com.sas.svi.jdbc.oracle.base.c: [SAS][Oracle JDBC Driver][Oracle]ORA-00911: invalid character
com.sas.svi.jdbc.oracle.base.c: [SAS][Oracle JDBC Driver][Oracle]ORA-00911: invalid character
Workaround
To circumvent this issue, change all primary keys from non-numeric to numeric.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Investigator (on SAS Viya 3.x) | Linux for x64 | 10.8 | Viya | ||
An update for this issue is available for SAS Visual Investigator 10.8. For instructions on how to access and apply these software updates, see the documentation links at the top of
https://tshf.sas.com/techsup/download/hotfix/HF2/Viya_VI_10_8_home.html#71159| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2025-03-18 16:12:37 |
| Date Created: | 2025-03-17 02:39:25 |