-
Title
Poster: ORA-04045: errors during recompilation/revalidation -
Description
The following errors are observed in Post:
Notice 2017-09-01 18:15:18.878000 2552 4456 s:2 Poster: ORA-04045: errors during recompilation/revalidation of <name>.ORA-38301: can not perform DDL/DML over objects in Recycle Bin. (posting from SID1, queue QUEUE_NAME, to SID2) [module osp]
Error 2017-09-01 18:15:18.878000 2552 4456 s:2 Poster: que/seq = 2/ 221248 seqno/offset = 715/2214928 Unexpected Oracle error: ORA-04045: errors during recompilation/revalidation of <name>.ORA-38301: can not perform DDL/DML over objects in Recycle Bin. (object name: "CSELDB"."SE_MSG") (posting from SID1, queue QUEUE_NAME, to SID2) [module opo]
Info 2017-09-01 18:15:20.128000 3028 3172 Poster exited with code=1, pid = 5812 (posting from SID1, queue QUEUE_NAME, to SID2)
-
Cause
Some compilation issues with objects pointed to by the Oracle error. -
Resolution
Generally the objects pointed to by subsequent ORA errors may point to some compilation errors. This is certainly a database issue and not SharePlex issue. Since this error condition in the database can occur due to numerous reasons, there is no single condition that can be pointed to in the resolution. Suffice it to say that the users need to look at the object listed in the event log and/or the database’s alert log and see if they have any compilation issues and resolve them accordingly and then restart Post.
-
Additional Information
Here is the description of ORA-04045 ORA-04045: errors during recompilation/revalidation of string.string Cause: This message indicates the object to which the following errors apply. The errors occurred during implicit recompilation/revalidation of the object. Action: Check the following errors for more information, and make the necessary corrections to the object.