Hi,
I'm working on a scenario with a JDBC Receiver. During the testing, messages going to the JDBC receiver were being delivered successfully, however after a while, messages started to end in error (while others end up in holding/delivering status). Checking the error, I got this:
+SQLException: Listener refused the connection with the following error: ORA-12528, TNS:listener: all appropriate instances are blocking new connections+
*note that connection to the same DB is working for a different interface*
Checking blogs, it was explained that this error happens when the "unregister" did not complete properly, since the listener did not unregister the instance and "appropriate" instance is already running, we get this error. A solution was also provided in the blog where the Listener should be bounced, and then the SQL instance should be restarted. -- this resolution is on the side of the Receiver DB.
My question is on the side of XI. I've already set the adapter status to "Inactive" in the configuration. Checked the Serialization to identify the bottle neck, tried to cancel and restart, but it is not working (getting the below error)
+Unable to cancel x of x messages; update the status+
+Unable to schedule x of x messages for processing; update the status+
So given the above scenario, how can I cancel the messages in System Error in AE -- so that holding/delivering can proceed - and will be cancelled eventually?
Any thoughts?
Regards,
G
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.