I ran into many issues during my test of the upgrade from version 9 to 10. I'd like to share my findings with others who are planning the upgrade. The single biggest issue was moving the db's to a SQL 2005 server and the fact that the upgrade does not update the qcsiteadmin db properly.
When performing a default install on sql2005 it tries to create the TD user and fails due to the default pw security. You need to create the TD user, set the pw as tdtdtd (you'll need to override the security settings for the user in SQL) Then run this:
sp_change_users_login 'update_one', 'td', 'td'
You'll also need to update the schema if you move your db's from 2000 to 2005. The other issue I ran into is all requirements come over as a type of undifined. I hammered out some SQL to fix that but you'll need to identify what should be a folder and so on.
Anyone out there able to accomplish this in Oracle? We are getting wierd errors with the Upgrade Assessment Tool, and the "red flags" are up for us. Something with DB Permissions. Sounds like s similar issue with pw security that was discovered here as well. Changing all of the existing requirement types sounds like a really bad issue to have to go back and fix. Thanks again HP, this is the worst upgrade yet!
"This may hurt a little, but it's something you'll get used to."