ORA-01458: invalid length inside variable character string (4222421)

Post stopped due to error - ORA-01458: invalid length inside variable character string

This error can occur due to a bug from the SQL cache feature of post process.

TEMPORARY WORKAROUND:
Disable the SQL Cache feature.

sp_ctrl>stop post
sp_ctrl>set param SP_OPO_SQL_CACHE_DISABLE 1
sp_ctrl>start post

If the above errors do not show up after turning off SQL cache, you may leave it like that for the time being. Turning off the SQL caching may degrade post performance so at a later time, you may want to undo the change and see if the error still occurs. The way to undo it is:

sp_ctrl>stop post
sp_ctrl>set param SP_OPO_SQL_CACHE_DISABLE 0
sp_ctrl>start post

Note: If you are running conflict resolution, the best practice is to disable sql cache to avoid this issue.

 fix is in 5.3.4