-
Title
Reader: invalid data -
Description
This applies to SharePlex version 9.0.
Missing database type notation in the routing map of the config file will make reader process stay in Idle state.
Config file
datasource:o.SOURCE_SID
#source tables target tables routing map
OWNER.TABLE OWNER .TABLE target@TARGET_SID ---> missing o. r.
sp_ctrl (ptysupl1:3000)> status
Brief Status for ptysupl1
Process State PID Running Since
--------------- ------------------------------ -------- --------------------
Cop Running 4641 18-Sep-18 15:24:42
Cmd & Ctrl Running 4662 18-Sep-18 15:24:50
Capture Running 5299 18-Sep-18 15:26:03
Read Idle
sp_ctrl (ptysupl1:3000)> version full
SharePlex Version = 9.0.0-b18 (m64, oracle110)
sp_ctrl (ptysupl1:3000)> show log reverse
Info 2018-09-18 15:27:45.981066 4641 825370464 Reader exited with code=1, pid = 6085 (from o.XXXXXX)
Error 2018-09-18 15:27:45.974262 6085 4294793056 Reader: invalid data (from o.XXXXXX) [module rim]
Notice 2018-09-18 15:27:44.960061 6085 4294793056 Reader: Oracle Available (from o.XXXXXX) [module ord]
Notice 2018-09-18 15:27:43.807435 6085 4294793056 Reader: Replicating according to target compatibility of "9.0.0" (from o.XXXXXX) [module sys]
-
Cause
Missing information in the config file.
-
Resolution
Add the database type notation to the routing map and reactivate the config file.