Oracle "insufficient priviledges"
![]()
Upgrading JTS (upgrade_jts.sh) from Version 4.0.3 to 5.0.0 the following error occurs whilst CREATE TABLE TEMP_REQUIREMENT_PTEXT_STG ( EXTERNAL_ID VARCHAR(100) NOT NULL, PTEXT VARCHAR(4000) NOT NULL ) TABLESPACE VNF_32K;
"insufficient priviledges"
The both users (repository.db and datawarehouse.db) have DBA, create table, create session........
We have even tried to grant sysdba with the same results......
The "hidden" users: CONFIG, RIASSET, RICALM, RIDW, RIODS, RISCHK, RPTUSER all have DBA permissions, create table, create session....
Who is trying to create the table TEMP_REQUIREMENT_PTEXT_STG and where!
|
One answer
Your answer
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.
Comments
Maybe you can try to verify it with SQL*Plus? First Confirm the connection information of the Oracle database first in teamserver.properties file, then connect to the Oracle database using the same Oracle user, and run the CREATE TABLE statement quoted in the above error.
Hi Donald,
Already tried with each user that I know to connect and create the table, but they all work without errors, its only the upgrade script that fails....
Is there anyway to turn on extra debugging for the SQL querries with the update Scripts?
Not sure how to turn on extra debugging at this stage. But it appears that the error is thrown when running "repotools-jts -addTables" command (called by upgrade_jts.sh). See if you can find the file server/repotools-jts_addTables.log and it may contain more information.
This is the logfile I found the CREATE TABLE statement in, unfortunately all the login names in the connection strings are xxxxx'ed out !