Post stops due to error and the following messages are observed in the event log:
Info 2011-01-14 19:11:27.546419 26993 1 Poster exited with code=1, pid = 27948 (posting from SID1, queue queue_name, to SID2)
Error 2011-01-14 19:11:27.515512 27948 1 Poster stopped: Internal error encountered; cannot continue (posting from SID1, queue queue_name, to SID2)
Error 2011-01-14 19:11:27.498093 27948 1 Poster: 15010 - Error reading pre-sync'd objcache for datasource objectcache_name, actid 4 (posting from SID1, queue queue_name, to SID2) [module opo]
Error 2011-01-14 19:11:27.484628 27948 1 Poster: 17006 - Cannot open object cache: Input/output: /u00/splex/var/state/0x0a01009c+PP+server+sp_opst+o.SID1-o.SID2-objcache_sp_opst.4: open() failed \ (posting from SID1, queue queue_name, to SID2) [module osp]
Info 2011-01-14 19:11:20.075846 27948 1 Poster launched, pid = 27948 (posting from SID1, queue queue_name, to SID2)
A missing object cache is causing Post to error.
Create the missing object cache on the target using the latest sp_ocap object cache from source and start post. Here are the steps involved:
1. Stop capture on the SOURCE. Make sure that it is “stopped by user” and not “stopping” when issuing “status” on source sp_ctrl
2. Restart it.
3. Login to the source database as Shareplex user and query the Shareplex_actid table. Note down the value in the actid column.
4. Go to vardir/state dir on the SOURCE and look for *objcache_sp_ocap.<actid value from Step 3.>
5. Copy the above object cache file in binary format to vardir/state on target.
6. On the target rename this file to same name as the name of the missing file reported in the target event_log,
mv *objcache_sp_ocap.<actid value from Step 3.> 0x0a01009c+PP+server+sp_opst+o.SID1-o.SID2-objcache_sp_opst.4
7. Make sure that the ownership/permissions of the newly created object cache are same as those of the other object cache files (identified by the string *objcache*) in the /vardir/state directory on target.
8. Start post.
