Powered By Blogger

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

1 comment:

  1. You'll find the kids produce : " Just what lifestyle shall be including inside a century (what is going to possibly be manufactured and also after that get dated). https://imgur.com/a/qAoHp9f https://imgur.com/a/wikoO7h https://imgur.com/a/tSD0rMV http://mlx0wmzi0g.dip.jp https://imgur.com/a/8icXw8R https://imgur.com/a/9DKHjB6 http://mg9dnszx1h.dip.jp

    ReplyDelete