Upgrep process Hung - It was running for more than 24 hrs
Hello Experts -
We are Upgrading from 8.1.1.6 SEA (sql 2005, windows 2003) to 8.1.1.11 SIA (SQL 2012, windows 2012)
I have started upgrade in windows 2012 env
Upgrep process did not complete, on further analysis found that following SQL doesn't give any result, keeps running though.
Can you please let me know what does this do ? And how to fix it ?
This SQL is in repos_upgrade.sql
insert into TMP_DUP_UKA(REPOS_NAME,TBL_NAME,UK_NAME,UKA_NAME,UKA_ROW_ID)
select R.NAME
, T.NAME
, UK.NAME
, C1.NAME
, UKA.ROW_ID
from S_REPOSITORY R
, S_TABLE T
, S_USER_KEY UK