Powered By Blogger
Showing posts with label ORA-25215. Show all posts
Showing posts with label ORA-25215. Show all posts

Thursday, September 19, 2013

java.sql.SQLException: ORA-25215: user_data type and queue type do not match

I would like to discuss possible causes that might throw error in subject

Above error comes when AQ adapter  is used from middleware point of view

As error is reminiscent, first obvious reason is AQ user data type in Oracle Apps is different than what AQ adapter is expecting from SOA composite.If you change AQ data type after deploying composite then re-run the AQ adapter wizard to sync up AQ data type definitions

Even after making sure above all is correct, if we still see error then following case also causes above error

If we drop and recreate AQ /data type definitions in Oracle Apps then SOA log throws errors for some time and stops. SOA should recover from this error after some time or DBA can also flush the database cache to recover quickly

Hope this helps