SUPPORT / SAMPLES & SAS NOTES
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 | ||