ORACLE error 1422 in get_sm_info

Problem:

Concurrent managers not coming up after a refresh. The error in the concurrent manager logs states "ORACLE error 1422 in get_sm_info". The ICM comes up but other managers dont.


Solution:

This issue happens when there are more than one Service Managers are configured in the source instance and target instance does not have as many nodes. For eg, if you have a 3 node source instance with PCP enabled, and you are refreshing a target instance with 1 node, then the database will have the entries for 3 Service Managers which will cause this issue.

One of the fix is to do a clean up of concurrent queues and then run autoconfig. However, a simpler fix to overcome this issue would be to set the target_node and nodename columns in fnd_concurrent_queues table to NULL for those Service Managers which will not be used in the target environment. Leave the Service Manager for the target instance alone - do not change anything there.

Other "dirty" solution is to set the "GSM Enabled" to "N" which will not use the Service Manager. This would not be the right thing to do as this changes the architecture.

- Aravind Kamath