Hi,
i was trying to run a standalone deployment through the data deploy GUI . The following error keeps coming up and the deployment is failing..Any ideas as to how to resolve it ?
------------------------------------------
DataDeploy Version 5.6.0 Build 24549 Interwoven 20030903
Database Vendor set to oracle
SQL datatype for column Website is VARCHAR2(20)
SQL datatype for column Segment_Card_Program is VARCHAR2(50)
SQL datatype for column Card_Program_Region is VARCHAR2(50)
SQL datatype for column Card_Issuer is VARCHAR2(100)
# of columns: 4
# of primary key columns specified: 1
WARNING:Assuming group name as the table name for [Issuers_list].
# of groups defined in <dbschema> element: 1
Area VPath:/iwmnt/default/main/business/Europe/WORKAREA/DEVELOPMENT
Setting up TDbSchemaAgent.
>>> Loading drivers <<<
url : dde2:1111:dwddbl
login : user
login timeout=3
Connecting to the database...
Try connecting using jdbc

racle:thin:
@dde2:1111:dwddbl...
Connected to jdbc

racle:thin:
@dde2:1111:dwddbl
Driver Oracle JDBC driver
Version 9.0.1.1.0
Connected to [dde2:1111:dwddbl]
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWOV_IDMAPS'
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWOV_IDMAPS'
Creating identifier mapping table: IWOV_IDMAPS
CREATE TABLE IWOV_IDMAPS (TYPE INT NOT NULL, SHORTID VARCHAR(30) NOT NULL, LONGID VARCHAR(1024) NOT NULL)
ERROR

QLException: ORA-01031: insufficient privileges
ERROR:Vendor Error code: 1031
ERROR

QL state: 42000
ERROR:TIdentifierMappingTable constructor failed
Error occured in TDbAgent constructor
Stat for group [Issuers_list]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Rollback database [dde2:1111:dwddbl]...
Deployment[basearea]
ERROR:TDbAgent constructor failed.
Error occured in TDbSchemaAgent
Stat for group [Issuers_list]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Rollback database [dde2:1111:dwddbl]...
Deployment[basearea]
ERROR:TDbSchemaAgent create failure.
Started : Fri Oct 24 09:31:26 CDT 2003
Finished: Fri Oct 24 09:31:28 CDT 2003
### IWDataDeploy FAILED ###
------------------------------------------------
Thanks....