post stopped due to invalid month "ORA-01843: not a valid month". (73349)

Post stopped due to invalid month "ORA-01843: not a valid month".

Turn on debug, the sql statements show shareplex construct it with "invalid" date value(s) for date column(s).

There are old messages in the queue that used an old object cache from old actid, and when shareplex tries to post messages with new actid, it does not use a correct object cache. As the result, it constructs sql statement and bind the values into the wrong columns.

Workaround:

Use qview with "set detail full" to dump the record to retrieve the actid from there.

a. qview -i

b. qinit

c. open p r

>> choose the right queue

d. set out

e. set detait full

f. oread 0 0

exit

grep -i actid qview.out

Replace old object cache (old actid) with a recent object cache (new actid from grep).

This can happen with different data type as well. For example, insert text into columns with number data type.