Highlighted
Absent Member.
Absent Member.
149 views

HP Quality Center 10.0 Installation Error: 'no privileges on tablespace'

Hi,

I would like to seek help regarding the error that we are encountering during the installation of the HP Quality Center 10.0. The quality center to be used will going to be integrated in SAP Solution Manager that is almost done with the necessary upgrade. Below is the error encountered.

Error Installation failed due to an error creating the Site Administration database schema. Reason: Failed SQL: /* ~~QC */ CREATE TABLE qcsiteadmin_db.ADMIN (ADMIN_PSWD VARCHAR2(255) NULL,DOMS_VERSION VARCHAR2(80) NOT NULL,LICENSE_KEY CLOB NULL ) [Mercury][Oracle JDBC Driver][Oracle]ORA-01950: no privileges on tablespace 'QCTABLESPACE' Message: Return Code:0

Exception:com.mercury.install.interfaces.ConfigException: com.mercury.optane.core.CTdException: Failed SQL: /* ~~QC */ CREATE TABLE qcsiteadmin_db.ADMIN (ADMIN_PSWD VARCHAR2(255) NULL,DOMS_VERSION VARCHAR2(80) NOT NULL,LICENSE_KEY CLOB NULL )
[Mercury][Oracle JDBC Driver][Oracle]ORA-01950: no privileges on tablespace 'QCTABLESPACE'
Inner Exceptions:com.mercury.optane.core.CTdException: Failed SQL: /* ~~QC */ CREATE TABLE qcsiteadmin_db.ADMIN (ADMIN_PSWD VARCHAR2(255) NULL,DOMS_VERSION VARCHAR2(80) NOT NULL,LICENSE_KEY CLOB NULL )
[Mercury][Oracle JDBC Driver][Oracle]ORA-01950: no privileges on tablespace 'QCTABLESPACE'
com.mercury.optane.core.CTdException: Cann't create table ADMINcom.mercury.optane.core.CTdException: Cann't create table 'ADMIN' com.mercury.optane.core.db.CTdDbException: java.sql.SQLException: Failed SQL: /* ~~QC */ CREATE TABLE qcsiteadmin_db.ADMIN (ADMIN_PSWD VARCHAR2(255) NULL,DOMS_VERSION VARCHAR2(80) NOT NULL,LICENSE_KEY CLOB NULL )
[Mercury][Oracle JDBC Driver][Oracle]ORA-01950: no privileges on tablespace 'QCTABLESPACE'
Stack Trace:com.mercury.td.saserver.setup.CAbsInstaller.createSchemacom.mercury.qc.configtool.QCConfig.executecom.mercury.install.wizard.action.CallConfigWA.executecom.installshield.wizard.RunnableWizardBeanContext.run

I tried granting the users; qcadm, qcadmin, admin, qcsiteadmin_db with unlimited tablespace but still we encounter that error. Also used user 'system' as the database administrator user name but we still encounter the error. Please help. Thanks in advance!

Regards,
Dunstan
0 Likes
1 Reply
Highlighted
Absent Member.
Absent Member.

Re: HP Quality Center 10.0 Installation Error: 'no privileges on tablespace'

Posted this inquiry in the Quality Center forum.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.