OpenText ALM Quality Center" />
If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it! Learn more
You can no longer post new replies to this discussion. If you have a question you can start a new discussion
I am able to connect to Oracle database through ALM, but in "Site Admin Database Schema" tab I am getting the problem "The database administrator [schema-name] does not have all the required permissions or the schema password does not meet the password policy requirements." with the option of "Create a New Schema" even I am using "system" account or other account(which is having DBA permissions). If I created the schema in database and trying to connect to it by choosing the option of "connect to existing schema/second node" the screen is staying there itself. Please suggest me any solution for this.
Hi SivaPrasad, Generally, for selected action "Create a New Schema" ,Schema name should be qcsiteadmin_db its default password will be tdtdtd In the next page, for site administrator user , provide user name and password as qc12sa and try whether it accepting it. Infact you can provide any user name and password. Regards, Srihari
Thanks for responding
Here is the stack trace I am giving from ALM log file(Please refer stacktrace below).
I think main issue is happening because of this query to database " SELECT DOMS_VERSION FROM ADMIN " which I got from below stack trace.
I did any wrong configuration any where please help me in this.
DB type: oracle, native authentication: N, user: system, jdbc connection string: jdbc:mercury:oracle://XX.XX.XX.XXX:1521;servicename=orcl
Validation name: 'SaSchemaExistsValidation'
Validation status: SUCCEED
Message type:
User message: ''
Log message: 'null'
java.sql.SQLException: [Mercury][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
Failed SQL: /* ~~QC */ SELECT DOMS_VERSION FROM ADMIN
at com.hp.alm.platform.db.CAbsStatement.createSQLExceptionWithSQLStatement(CAbsStatement.java:251)
at com.hp.alm.platform.db.CAbsStatement.doExecute(CAbsStatement.java:192)
at com.hp.alm.platform.db.CAbsStatement.doExecute(CAbsStatement.java:128)
at com.hp.alm.platform.db.CTdPreparedStatement.executeQuery(CTdPreparedStatement.java:489)
at com.hp.alm.platform.db.jdbc.JDBCTemplate.executeQuery(JDBCTemplate.java:1053)
wrapped in com.hp.alm.platform.db.CTdDbException:
at com.hp.alm.platform.db.jdbc.JDBCTemplate.executeQuery(JDBCTemplate.java:1069)
at com.hp.alm.platform.db.jdbc.JDBCTemplateWithRetry.access2.exec(JDBCTemplateWithRetry.java:56)
at com.hp.alm.platform.db.jdbc.JDBCTemplateWithRetry.executeWithRetry(JDBCTemplateWithRetry.java:98)
at com.hp.alm.platform.db.jdbc.JDBCTemplateWithRetry.executeQuery(JDBCTemplateWithRetry.java:52)
at com.hp.alm.platform.db.jdbc.JDBCTemplate.queryForObject(JDBCTemplate.java:775)
at com.hp.alm.platform.db.jdbc.JDBCTemplate.queryForObject(JDBCTemplate.java:750)
at com.hp.alm.platform.db.jdbc.JDBCTemplate.queryForString(JDBCTemplate.java:633)
at com.hp.alm.platform.db.jdbc.JDBCTemplate.queryForString(JDBCTemplate.java:618)
at com.hp.alm.installAnywhere.utils.InstallationGeneralUtils.getDomsVersionFromExistingSaSchema(InstallationGeneralUtils.java:434)
at com.hp.alm.installAnywhere.validations.InstallationValidations.saSchema.UseExistingSaSchemaVersionValidation.execute(UseExistingSaSchemaVersionValidation.java:47)
at com.hp.alm.installAnywhere.validations.InstallationValidations.AbsInstallationValidation.validate(AbsInstallationValidation.java:34)
at com.hp.alm.installAnywhere.validations.InstallationValidations.AbsValidationsExecutor.executeValidation(AbsValidationsExecutor.java:49)
at com.hp.alm.installAnywhere.validations.InstallationValidations.AbsValidationsExecutor.executeValidations(AbsValidationsExecutor.java:33)
at com.hp.alm.installAnywhere.panels.gui.customPanels.AbsInstallerCustomCodeValidatablePanel.executePanelValidations(AbsInstallerCustomCodeValidatablePanel.java:55)
at com.hp.alm.installAnywhere.panels.gui.customPanels.SiteAdminDatabaseCustomPanel.executePanelValidations(SiteAdminDatabaseCustomPanel.java:506)
at com.hp.alm.installAnywhere.panels.gui.customPanels.AbsInstallerCustomCodeValidatablePanel.checkOkToContinue(AbsInstallerCustomCodeValidatablePanel.java:23)
at com.hp.alm.installAnywhere.panels.gui.customPanels.AbsInstallerCustomCodePanel.okToContinue(AbsInstallerCustomCodePanel.java:59)
at com.zerog.ia.installer.AAMgr.clickNextButton(Unknown Source)
at com.zerog.ia.installer.AAMgr.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton400(Unknown Source)
at java.awt.EventQueue3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)