ID Resolver hangs with Oracle 11g R2 Database
When you do database migration from WCS6 to WCS7, migration scripts executes successfully with “check” parameter. When you execute the migration script with “migrate” parameter, some of the steps get executed successfully but when it reaches the IdResolver, it appears to be hung. Execution may appear to be hung at the line,
[idResolve] IDResolving /opt/IBM/WebSphere/CommerceServer70/xml/policies/xml/MergedACUserGroups_en_US_xmltrans.xml
Infact it is not hung, the script will keep on executing but takes long time to complete and if you let it run, it gets executed after long time (Approx. 10-15 hours). This issue is caused due to auto generated SQL by JDBC, which accesses ALL_CONSTRAINTS and ALL_CONS_COLUMNS and hence making it slow.
There is a work around to fix this issue is set the OPTIMIZER_FEATURES_ENABLE value to one of the prior versions of Oracle. Following is the query:
ALTER SESSION SET OPTIMIZER_FEATURES_ENABLE=’10.1.0′;
I felt, this is same as version of the oracle installed on your machine, you can reset once migration scripts are executed successfully
You can also refer to the following links for detailed information:
1. “idresgen (ID Resolver) hangs with Oracle database”
2. “Installing and configuring Oracle 11g database”
-Raghavendra Shanthappa