E
dit
A
ttach
P
rintable
r6 - 2013-05-14 - 09:50:19 - Main.sbeard
You are here:
TWiki
>
Deployment Web
>
DeploymentTroubleshooting
>
UpgradeTroubleshooting
>
CLMUpgradeTroubleshooting
>
CLMUpgradeScripts
>
InsufficientPrivileges
<div id="header-title" style="padding: 10px 15px; border-width:1px; border-style:solid; border-color:#FFD28C; background-image: url(<nop>https://jazz.net/wiki/pub/Deployment/WebPreferences/TLASE.jpg); background-size: cover; font-size:120%"> ---+!! <img src="https://jazz.net/wiki/pub/Deployment/WebPreferences/new.png" alt="new.png" width="50" height="50" align="right"/> Why does qm_upgrade script fail with the error message =<i>"java.sql.SQLException: ORA-01031: insufficient privileges?"</i>= %DKGRAY% Authors: Upgrade Troubleshooting Team<br> Build basis: CLM 3.x and later %ENDCOLOR%</div></sticky> <!-- Page contents top of page on right hand side in box --> <sticky><div style="float:right; border-width:1px; border-style:solid; border-color:#DFDFDF; background-color:#F6F6F6; margin:0 0 15px 15px; padding: 0 15px 0 15px;"> %TOC{title="Page contents"}% </div></sticky> <sticky><div style="margin:15px;"></sticky> A very common problem when running qm_upgrade script is this error message =<i>"java.sql.SQLException: ORA-01031: insufficient privileges?"</i>=. You can follow below sections to resolve the error. ---++ Running qm_upgrade script The qm_upgrade script upgrades Jazz Team Server version 3.0.1.x or 4.0.0.x to 4.0.1 or later. Here is an example on running qm_upgrade script on Windows and UNIX: <b>Example</b> Windows: <verbatim> cd C:\Program Files\IBM\JazzTeamServer\Server\ upgrade\qm\qm_upgrade.bat -oldApplicationHome old_QM_install_dir\server\conf </verbatim> UNIX: <verbatim> cd opt/IBM/JazzTeamServer/Server/ ./upgrade/qm/qm_upgrade.sh -oldApplicationHome old_QM_install_dir/server/conf </verbatim> ---++ Resolution The error message =<i>"java.sql.SQLException: ORA-01031: insufficient privileges?"</i>= occurs when qm_upgrade script attempts to add new tables to the QM repository database but the database login ID for Oracle database does not have DBO privileges. Other database vendors would raise similary SQL exception messages. The Quality Management application teamserver.properties file under <b><i>old_QM_install_dir\server\conf</i></b> directory contains database schema connection information, including login ID and password for current database vendor. The login ID must have database DBO permission on all CLM applications, including databases for jts, qm, ccm, dw and rm. The creation of the warehouse on Oracle requires more permissions as compared to other databases. When you specify the database user in the connection spec for data warehouse, ensure that the database user has DBA permissions. Then you can remove that privilege after data warehouse configuration is complete. ---+++++!! Related topics: [[DeploymentTroubleshooting][DeploymentTroubleshooting]] ---+++++!! External links: * None ---+++++!! Additional contributors: Main.WilliamChen, Main.BrettBohnn <sticky></div></sticky>
E
dit
|
A
ttach
|
P
rintable
|
V
iew topic
|
Backlinks:
We
b
,
A
l
l Webs
|
H
istory
: r6
<
r5
<
r4
<
r3
<
r2
|
M
ore topic actions
Deployment
Deployment web
Planning and design
Installing and upgrading
Migrating and evolving
Integrating
Administering
Monitoring
Troubleshooting
Community information and contribution guidelines
Create new topic
Topic list
Search
Advanced search
Notify
RSS
Atom
Changes
Statistics
Web preferences
NOTE: Please use the Sandbox web for testing
Status icon key:
To do
Under construction
New
Updated
Constant change
None - stable page
Smaller versions of status icons for inline text:
Copyright © by IBM and non-IBM contributing authors. All material on this collaboration platform is the property of the contributing authors.
Contributions are governed by our
Terms of Use.
Please read the following
disclaimer
.
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more
here
.