Hello,
We are migrating from 6.9 Patch 02 to RSA 7.0. The migration has come to 96% and since past 60hrs its running a sql "Upgrade/Initialization/postupdate/ACM-52968.sql".
We do have a large amount of data in the wp_user_data table but what we would like to know is :
Rgds
Sunita
Could you please check if there is any errors logged in the migration log?
Hello Baseem & Venkat,
THere are no errors in the Migration Log.
Venkar, as you said, i have reviewed both the sql and access package. It does have a Log4J kind of logging but I am not sure where is the switch to turn it on.
Support has asked for all the artifacts & there are db operations going on. No process is stuck and there is plenty of space.
What we are trying to figure out is HOW MUCH LONGER TO WAIT?
Rgds
Sunita
From the SQL file ACM-52968.sql, the procedure Access_Request_Pkg.Update_Proc_Refs is invoked multiple times, the number of times depending on the number of new custom workflows that have been created of certain categories. Running the select query that is in the file will give an exact count of times the procedure will be called.
There are logs written by the procedure Update_Proc_Refs into job stats table but they may not be visible till the execution gets completed. At this point, it would be better to look into OEM to see what exact query is running and how long it has been running for. If a single query has been running for most of the time, this may require support/engineering intervention.
Hi ,
Update on this case.
We were already working with Support on this issue.
We got sr support team involved.
The sql was still running even after 90hrs and had no way to know how much longer it will run. Thus we ended up killing the migration. Removed this SQL and another one which generates an ASR report from the migration path and completed the migration.
Thanks for the update. Was there not any need to run the removed SQL post migration? Will be good to know what was done to workaround that missed SQL.
please contact support on this: support@rsa.com
regards
Edwin