This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

POST stopped

Hello All,

I have a test   environment . It has a single virtual box machine with single database. Here for me source and target databases are same.

Source Schema and table name  is splex.

Target Schemal  and table name is  splex_target.

Database is oracle.

performed some transactions but post process was stopped. Please assist us .


Brief Status for localhost.localdomain
Process          State                             PID     Running   Since
---------------  ------------------------------  --------  --------------------
Cop              Running                            13020  13-Feb-19 03:25:14
Capture          Running                            32690  13-Feb-19 06:07:07
Read             Running                            32712  13-Feb-19 06:07:14
Export           Running                            32727  13-Feb-19 06:07:18
Import           Running                            32730  13-Feb-19 06:07:18
Post             Stopped - due to error
Cmd & Ctrl       Running                             3745  13-Feb-19 06:56:17

sp_ctrl (localhost.localdomain:2100)> list config

File   Name                                         State       Datasource
--------------------------------------------------  ----------  ---------------
ORA_config                                          Inactive    o.SOURCE_SID
Last Modified At: 12-Feb-19 10:34    Size: 151

demo_config                                         Active      o.orclcdb
Last Modified At: 13-Feb-19 06:19    Size: 219     Internal Name: .conf.4

sp_ctrl (localhost.localdomain:2100)> view config demo_config

datasource:o.orclcdb

#source tables      target tables           routing map

##splex.demo_src      splex.demo_dest           target_system@o.target_sid
splex.itest      splex_target.itest          192.168.99.100@o.orclcdb

error message from event log.

)
Info     2019-02-13 06:08:31.129610 13020 1285547968 Poster exited with code=1, pid = 32731  (posting from o.orclcdb, queue localhost, to o.orclcdb)
Notice   2019-02-13 06:19:35.143388 13731 1215862720 User command: oracle edit/create config demo_config (from localhost)
Notice   2019-02-13 06:19:55.121896 13731 1215862720 User command: oracle start post (from localhost)
Info     2019-02-13 06:19:55.124019 1236 1285547968 Poster launched, pid = 1236  (posting from o.orclcdb, queue localhost, to o.orclcdb)
Notice   2019-02-13 06:20:02.232718 1236 2789451520 s:5 Poster: Oracle error: ORA-00942: table or view does not exist  rowid:AAASGDAAQAAAACtAAA  (posting from o.orclcdb
, queue localhost, to o.orclcdb) [module opo]
Error    2019-02-13 06:20:03.260320 1236 2789451520 Poster stopped: Internal error encountered; cannot continue  (posting from o.orclcdb, queue localhost, to o.orclcdb)
Info     2019-02-13 06:20:04.285437 13020 1285547968 Poster exited with code=1, pid = 1236  (posting from o.orclcdb, queue localhost, to o.orclcdb)
Notice   2019-02-13 06:21:08.621977 32712 1366443968 Reader: Table "SPLEX"."ITEST" (obj_id:13595755) was truncated  (from o.orclcdb) [module ord]
Info     2019-02-13 06:56:00.314115 3644 1388566464 Available instance - ORACLE_SID: orclcdb, ORACLE_HOME: /u01/app/oracle/product/version/db_1, Oracle version: 180  [o
ra_setup]
Notice   2019-02-13 06:56:00.549822 13020 1285547968 SharePlex for Oracle RAC/OPS, "Trial Key" will expire on Midnight of Mar 14, 2019
Notice   2019-02-13 06:56:00.706940 32712 1366443968 Reader: Replicating according to target compatibility of "9.2.0"  (from o.orclcdb) [module sys]
Notice   2019-02-13 06:57:02.441178 3745 2311833536 User command: oracle activate config demo_config (from localhost)
Info     2019-02-13 06:57:02.446960 3793 1285547968 Activation launched, pid = 3793  (activating datasource o.orclcdb)
Notice   2019-02-13 06:57:02.615997 3793 903763904 Activation: Replicating according to target compatibility of "9.2.0"  (activating datasource o.orclcdb) [module sys]
Notice   2019-02-13 06:57:02.616434 3793 903763904 Activation: Replicating according to target compatibility of "9.2.0"  (activating datasource o.orclcdb) [module sys]
Notice   2019-02-13 06:57:04.636088 3793 903763904 Activation: Oracle compatible parameter='18.0.0'   (activating datasource o.orclcdb) [module ocf]
Warning  2019-02-13 06:57:04.986224 3793 903763904 Activation: 13007 - No unique keys or primary key for object id 74115  (activating datasource o.orclcdb) [module osp]
Info     2019-02-13 06:57:08.149446 3793 903763904 Deactivation of "demo_config", actid 3, for database o.orclcdb started
Info     2019-02-13 06:57:08.150059 3793 903763904 Activation of "demo_config", actid 4, for database o.orclcdb complete
Info     2019-02-13 06:57:08.191264 13020 1285547968 Activation exited normally, pid = 3793  (activating datasource o.orclcdb)
Notice   2019-02-13 06:57:36.842920 3745 2311833536 User command: oracle start post (from localhost)
Info     2019-02-13 06:57:36.851505 3840 1285547968 Poster launched, pid = 3840  (posting from o.orclcdb, queue localhost, to o.orclcdb)
Notice   2019-02-13 06:57:42.719523 3840 3516651264 s:5 Poster: Oracle error: ORA-00942: table or view does not exist  rowid:AAASGDAAQAAAACtAAA  (posting from o.orclcdb
, queue localhost, to o.orclcdb) [module opo]
Error    2019-02-13 06:57:43.610892 3840 3516651264 Poster stopped: Internal error encountered; cannot continue  (posting from o.orclcdb, queue localhost, to o.orclcdb)
Info     2019-02-13 06:57:44.623460 13020 1285547968 Poster exited with code=1, pid = 3840  (posting from o.orclcdb, queue localhost, to o.orclcdb)

Please assist me here.

Thank you.