DD error (ORA-01031: insufficient privileges)

Hi,

We are getting "ORA-01031: insufficient privileges" intermittently as log printed below. We are using
- DD 6.0.2
- TS 6.5 SP2
- Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production.

We tried the same deployment without any changes to DD or database... and it worked absolutely fine. There is no privilege issue on the database.

Also, if we deploy a set of files for first time, it works absolutely fine. If we redeploy the same set of files, it fails giving the 'insufficient privileges' error.

Thanks,

========================================
DD : SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWOV_IDMAPS'
DD : Building mappings cache...
DD : Built mapping cache(s) successfully.
DD : # column mappings: 0
DD : # table mappings: 0
DD : # view mappings: 0
DD : # constraint mappings: 0
DD : SELECT * FROM USER_TABLES WHERE TABLE_NAME='DOCUMENT'
DD : Table exists.
DD : Consumer setup for deployment [ea-to-dbdoc] ok
DD : Setting up consumer TDbAgent
DD : Validating cached connection...
DD : Cached connection OK
DD : Connected to [db.btwpd.vipx.bt.com:1521:btwpd]
DD : SELECT * FROM USER_TABLES WHERE TABLE_NAME='DOCUMENT_METADATA'
DD : Table exists.
DD : Consumer setup for deployment [ea-to-db] ok
DD : Running deployment [MetadataDeploy]
DD : extraction type=full
DD : tuple mode=wide
DD : area=/default/main/bt/btw/portal/21_ivvt1/WORKAREA/content
DD : filelist=[/data/software/iw/iw-home/Applications/contsync/list/fileListSubmit_Contsync.20070216-041309.lst3]
DD : /default/main/bt/btw/portal/21_ivvt1/WORKAREA/content/generated/content/event/help/faq/faq_summary.html
DD : Generate TFullEAExtractor start:Tue Feb 20 04:02:34 GMT 2007
DD : Generate TFullEAExtractor end :Tue Feb 20 04:02:34 GMT 2007
DD : Path not found -- interpret as 'NotPresent'
DD : TUPLE={state=NotPresent, path=generated/content/event/help/faq/faq_summary.html}
DD : TTableSchemaHelper not found in cache for [DOCUMENT]. Creating new.
DD : SELECT ID, DOCUMENT_SIZE,VERSION,AUTHOR,COMMENTS,TO_CHAR(CREATION_DATE,'YYYY-MM-DD HH:MI Smiley Frustrated

S') AS CREATION_DATE,TO_CHAR(MODIFIED_DATE,'YYYY-MM-DD HH:MI Smiley Frustrated

S') AS MODIFIED_DATE,MODIFIED_BY,MIME_TYPE FROM DOCUMENT WHERE ID=?
DD : TTableSchemaHelper object for [DOCUMENT] found in cache.
DD : WHERE clause parameter 1: generated/content/event/help/faq/faq_summary.html
DD : Column: ID, field: path, Index: 1,Converting 'generated/content/event/help/faq/faq_summary.html' to VARCHAR
DD : Using PreparedStatement for Update...
DD : TTableSchemaHelper object for [DOCUMENT] found in cache.
DD : TTableSchemaHelper object for [DOCUMENT] found in cache.
DD : Prepared update:UPDATE DOCUMENT SET DOCUMENT_SIZE = ? , VERSION = ? , AUTHOR = ? , COMMENTS = ? , CREATION_DATE = ? , MODIFIED_DATE = ? , MODIFIED_BY = ? , MIME_TYPE = ? WHERE ID = ?
DD : Updating DOCUMENT
DD : Parameter Index: 1, Value: (null)
DD : Column: DOCUMENT_SIZE, field: DocumentSize, Index: 1,null
DD : Parameter Index: 2, Value: (null)
DD : Column: VERSION, field: Version, Index: 2,null
DD : Parameter Index: 3, Value: (null)
DD : Column: AUTHOR, field: Author, Index: 3,null
DD : Parameter Index: 4, Value: IWOV, Converting 'IWOV' to VARCHAR
DD : Column: COMMENTS, literal: IWOV, Index: 4,Converting 'IWOV' to VARCHAR
DD : Parameter Index: 5, Value: (null)
DD : Column: CREATION_DATE, field: CreationDate, Index: 5,null
DD : Parameter Index: 6, Value: (null)
DD : Column: MODIFIED_DATE, field: ModifiedDate, Index: 6,null
DD : Parameter Index: 7, Value: (null)
DD : Column: MODIFIED_BY, field: ModifiedBy, Index: 7,null
DD : Parameter Index: 8, Value: (null)
DD : Column: MIME_TYPE, field: MimeType, Index: 8,null
DD : Parameter Index: 9, Value: generated/content/event/help/faq/faq_summary.html, Converting 'generated/content/event/help/faq/faq_summary.html' to VARCHAR
DD : Column: ID, field: path, Index: 9,Converting 'generated/content/event/help/faq/faq_summary.html' to VARCHAR
DD :
DD : *******************************************************
DD : SQLException occured in TDbAgent Smiley Tongue

reparedUpdate()
DD : Exception Message: ORA-01031: insufficient privileges

DD : Vendor Error Code: 1031
DD : SQL state: 42000
DD : *******************************************************
DD :
DD : *******STACK TRACE*************
java.sql.SQLException: ORA-01031: insufficient privileges

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
at com.interwoven.dd100.dd.TDbAgent.PreparedUpdate(TDbAgent.java:2045)
at com.interwoven.dd100.dd.TDbAgent.Update(TDbAgent.java:2950)
at com.interwoven.dd100.dd.TDbAgent.NarrowInsertUpdate(TDbAgent.java:2204)
at com.interwoven.dd100.dd.TDbAgent.WriteTuple(TDbAgent.java:3642)
at com.interwoven.dd100.dd.TTupleSubstitutor.WriteTuple(TTupleSubstitutor.java:113)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:398)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:387)
at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClient.java:919)
at com.interwoven.dd100.dd.TAgentClient.ProcessOneFileList(TAgentClient.java:581)
at com.interwoven.dd100.dd.TAgentClient.ProcessFileList(TAgentClient.java:538)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:483)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:261)
at com.interwoven.dd100.dd.TAgentClient.DoMultiDeployment(TAgentClient.java:221)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:185)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:545)
at com.interwoven.dd100.dd.IWDataDeploy.run(IWDataDeploy.java:576)
DD : Error occured in TDbAgent: Smiley Tongue

reparedUpdate()
DD : -- Failed
DD : ERROR:WriteTuple failure to consumer[0]
DD : ERROR:Unable to process TeamSite source generated/content/event/help/faq/faq_summary.html, obtained from filelist=/data/software/iw/iw-home/Applications/contsync/list/fileListSubmit_Contsync.20070216-041309.lst3
DD : Filelist walk done
DD : ERROR Smiley Very Happy

eployment [ea-to-dbdoc] FAILED
DD : ERROR:multi-deployment [MetadataDeploy] FAILED
DD : Error occured in area outside TDbAgent consumer (explicit rollback initiated)
DD : Rollback database [db.btwpd.vipx.bt.com:1521:btwpd]...
DD : Deployment[ea-to-db] Table[DOCUMENT_METADATA]
DD : -----------------------------------
DD : Tuples inserted : 0
DD : Tuples updated : 0
DD : Tuples deleted : 0
DD : Tuples failed : 0
DD : Tuples rolled back : 0
DD : Tuples skipped : 0
DD : -----------------------------------
DD : Deployment[ea-to-dbdoc] Table[DOCUMENT]
DD : -----------------------------------
DD : Tuples inserted : 0
DD : Tuples updated : 0
DD : Tuples deleted : 0
DD : Tuples failed : 1
DD : Tuples rolled back : 0
DD : Tuples skipped : 0
DD : -----------------------------------
DD : Started : Tue Feb 20 04:02:30 GMT 2007
DD : Finished: Tue Feb 20 04:02:36 GMT 2007
========================================

Find more posts tagged with

Comments

Adam Stoller

Hi,

We are getting "ORA-01031: insufficient privileges" intermittently as log printed below. We are using
- DD 6.0.2
- TS 6.5 SP2
- Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production.

We tried the same deployment without any changes to DD or database... and it worked absolutely fine. There is no privilege issue on the database.

Also, if we deploy a set of files for first time, it works absolutely fine. If we redeploy the same set of files, it fails giving the 'insufficient privileges' error.

I don't claim to be a DBA - but I seem to recall that one has to set different permissions for being able to INSERT (new) and UPDATE and/or DELETE (modify) on DB tables - perhaps you don't have all the permissions set the way they should be?

nagendra

Permissions are fine. Whats happening is that if we deploy a set of files for first time, it works absolutely fine. If we edit and redeploy the same set of files, it fails giving the 'insufficient privileges' error.

RajatChopra

Do you have UPDATE privileges on the DB??? It seems more like an Oracle error than DD/Teamsite.

-R

Mr_Cruise

I would suggest the following to diagnose the problem.

1. Use something like Toad to create a record, update it and then delete it. This will rule out any permission problems or possible key problems

2. Then check that primary key is set correctly in the DD configuration file. Another good check is to drop the table and let DD create the table/s and see if the structure is different from the design.

3. If the DD configuration is updating multiple tables then limit to primary (root-group) and expand until you see the problem. It is paramount that when you test each change, that you run DD twice. The first time will load any data and the second will expose any problems, if the data cannot be updated.

developer2008

I am also having exactly the same problem.I am able to deploy fine when I try for the first time but when I update and deploy it is giving me "Insufficient privileges" error.whats happening in my case is it is trying to a create a new table that is not present in DB "IWTEMP_6FB04603" .But I dont know why it is trying to create this and I dont have permission to create a new table.Any help?

RajatChopra

I am also having exactly the same problem.I am able to deploy fine when I try for the first time but when I update and deploy it is giving me "Insufficient privileges" error.whats happening in my case is it is trying to a create a new table that is not present in DB "IWTEMP_6FB04603" .But I dont know why it is trying to create this and I dont have permission to create a new table.Any help?

What is the action that you are trying to perform? DD does create temp tables to manipulate information for its operations. I suggest requesting table creation access for the schema with which you are working. It will hamper you often without it.

developer2008

Why does the dd create temp tables?can you explain?