Poster: 17006 - Error reading object cache from file "$SP_SYS_VARDIR/state/0xXXXXX+PP+host+sp_opst+o.sid-o.sidobjcache_sp_opst.xx": Illegal state: Item XXXXXX already in the object id registry (4217875)

Post core dumps on a table with long data type.

Corrupted object cache file for previous activation ID

STATUS: Issue fixed in ST99391 in SharePlex 7.6.2 and above

WORKAROUND:

On source:

1. sp_ctrl> copy config to

2. sp_ctrl> activate config

3. sp_ctrl> start capture

4. sp_ctrl> list config

5. Determine the activation ID from the "list config" command in step 4

6. Copy $SP_SYS_VARDIR/state/o.SID-objcache_sp_ocap. to target's $SP_SYS_VARDIR/state

On target:

7. go to $SP_SYS_VARDIR/state and recreate the post's object cache file from the copied o.SIE-objcache_sp_ocap.

a.  mv 0xXXXXXXXX+PP+queue_name+sp_opst+o.SID2-o.SID2-objcache_sp_opst. 0xXXXXXXXX+PP+queue_name+sp_opst+o.SID2-o.SID2-objcache_sp_opst.bad 

b. cp o.SID-objcache_sp_ocap. 0xXXXXXXXX+PP+queue_name+sp_opst+o.SID2-o.SID2-objcache_sp_opst.

c. Ensure that permissions and ownerships for the recreated object cache file is the same as for object cache file for the previous actid

8. sp_ctrl> start post