When this application is implemented only those guys know the password for SA and TD so i have changed the password but i did not change the password in QC site admin so i have changed the password to same SQL server 2005 password and i am able to verify, repair and upgrade the projects successfully.
And I got another error with one project i.e. TESTCYCL_FUNC_IND field error so for this resolve i have deleted the project from QC and restored it and deleted the field from DB and its worked fine.
the steps i followed is:
i) install patch 34 for QC 9.0
ii) copy files i.e. migrate.* check box should be enabled in QC site admin after installing patch 34)
iii) uninstall QC 9.0
iv) install QC 10.0 ( same dB server)& install patch 14
v) verify , repair and upgrade
vi) test run.
Thanks and let me know if any one has any questions..
While upgrading a 9.2 database to the 10.0 schema you may encounter the following error during the “Verification” process:
16:32:26 Trying to connect to database MANUFACTURING_Test10 on server D700GV106
16:32:26 Connection established
16:32:26 The project version is 9.2
16:32:27 Checking if the project schema is not read-only ...
16:32:29 Check text search feature configuration
16:32:29 Is feature enabled at database level
16:32:30 Check that only valid fields are included in text search
16:32:30 Is text search enabled only on supported fields
16:32:30 Check that text search feature works properly
16:32:31 Checking for mixed table ownership ...
16:32:32 Checking if DB version is supported...
16:32:32 Checking DB permissions for DB administrator user...
16:34:19 Database system user [qc] does not have the necessary permissions on the DB server
16:34:19 No permission to 'db_owner' Failed to execute SQL 'use MANUFACTURING_Test10 select IS_MEMBER ('db_owner') AS "result"' Error=Failed SQL: /* ~~QC */ use MANUFACTURING_Test10 sele ...
16:34:19 ct IS_MEMBER ('db_owner') AS "result" [Mercury][SQLServer JDBC Driver][SQLServer]The server principal "qc" is not able to access the database "Manufacturing_Test10" under the current security context.
16:34:19 Checking DB permissions for QC project user...
16:34:19 Database system user td has the necessary permissions
16:34:19 Checking if tests are checked out...
16:34:19 Skipping check because version control is not enabled
16:34:19 Loading the extensions data ...
16:34:19 Verifying the project schema ...
16:34:24 Schema differences were found
16:34:24 Checking for duplicate IDs ...
16:34:24 Checking for duplicate values ...
16:34:24 Checking sequences ...
16:34:25 Checking trees ...
16:34:25 Some tree problems were found. See files under D:\Program Files\HP\Quality Center\repository\sa\DomsInfo\MaintenanceData\out\ LORILLARD\MANUFACTURING_Test10 for more information
16:34:26 Verify report file written to QCverifyReport_LORILLARD_MANUFACTURING_Test10_1280 781267276.html
16:34:26 in folder (on server side) D:\Program Files\HP\Quality Center\repository\sa\DomsInfo\MaintenanceData\out\ LORILLARD\MANUFACTURING_Test10\
16:34:26 Verify passed and found problems that cannot be fixed by the 'Repair tool'. Open the verification report to view the problems that must be fixed manually
If this error occurs, the chances are that QC has not been established as the DBO.
In order to correct this, please have the DBA MS SQL Group run the following Scripts:
CREATE USER [td] FOR LOGIN [td]
CREATE SCHEMA [td] AUTHORIZATION [td]
Alter user [td] with DEFAULT_SCHEMA=[td]
sp_addrolemember [db_ddladmin], [td]
exec sp_changedbowner 'qc'
If the First command returns the td user, run the second command
/***** Make td account work again *****/
EXEC sp_change_users_login 'Report'
EXEC sp_change_users_login 'Update_One', 'td', 'td'
exec sp_MSforeachtable "ALTER SCHEMA td TRANSFER ? PRINT '? modified' "