Datadeploy DAS

I have configured DAS for a workarea.

Initially whatever DCR's were created (i mean prior to the configuration of DAS) are getting inserted into the Databse in a table meant for STAZING.

But My workarea table is created but with no values.

After the DAS configuration what ever changes i made in DCR's are not getting reflected (WORKAREA table remains empty....) and even when i submit the DCR's to Stazing area the changes are not seen in the Stazing table.

Where as if i publish a new edition at this point of time it creates a new tables with the values..

I m pasting the iwddd.log file contents here under

TeamSite_Templating data_root is set to templatedata
Runmode: Serial Daemon
/mass1/teamsite/dd-home/datadeploy/install/dd_pid (Permission denied)
Server socket bound on port(2345) interface(techsun)
Lonely worker thread running...
thread[main] waiting to accept...

thread[main] accepted connection(1)!

SerialDaemon dispatch
awaiting msg...
msg [cfg="/iwmnt/default/main/upload/STAGING/templatedata/category/datatype/datatype_dd.cfg" deployment=basearea mybasearea="/default/main/upload/STAGING" mybasetable=DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_STAGING mybasetablenameprefix=DEFAULT_CATEGORY_DATATYPE mybasetablenamesuffix=MAIN_UPLOAD_STAGING mytemplatepath=templatedata/category/datatype/data ]
TWorkItem: Smiley Very Happy

oIt --- sock=2345 id=1
id=1 fDdArgs[0]=[cfg="/iwmnt/default/main/upload/STAGING/templatedata/category/datatype/datatype_dd.cfg"]
id=1 fDdArgs[1]=[deployment=basearea]
id=1 fDdArgs[2]=[mybasearea="/default/main/upload/STAGING"]
id=1 fDdArgs[3]=[mybasetable=DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_STAGING]
id=1 fDdArgs[4]=[mybasetablenameprefix=DEFAULT_CATEGORY_DATATYPE]
id=1 fDdArgs[5]=[mybasetablenamesuffix=MAIN_UPLOAD_STAGING]
id=1 fDdArgs[6]=[mytemplatepath=templatedata/category/datatype/data]
thread[main] accepted connection(2)!

SerialDaemon dispatch
awaiting msg...
msg [cfg="/iwmnt/default/main/upload/WORKAREA/travel/templatedata/category/datatype/datatype_dd.cfg" deployment=deltagen myarea="/default/main/upload/WORKAREA/travel" mybasearea="/default/main/upload/STAGING" mytable=DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_WORKAREA_TRAVEL mybasetable=DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_STAGING mybasetablenameprefix=DEFAULT_CATEGORY_DATATYPE mybasetablenamesuffix=MAIN_UPLOAD_STAGING mytablenameprefix=DEFAULT_CATEGORY_DATATYPE mytablenamesuffix=MAIN_UPLOAD_WORKAREA_TRAVEL mytemplatepath=templatedata/category/datatype/data ]
Database Vendor set to oracle
SQL datatype for column Description is CLOB
Area VPath:/default/main/upload/STAGING
Setting up TExtAttrDbAgent
>>> Loading drivers <<<
url : techsun:1521:star
login : starcms
login timeout=3
Connecting to the database...
Try connecting using jdbc Smiley Surprised

racle:thin:@techsun:1521:star...

Connected to jdbc Smiley Surprised

racle:thin:@techsun:1521:star
Driver Oracle JDBC driver
Version 8.1.7.0.0
Connected to [techsun:1521:star]
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWOV_IDMAPS'
Building mappings cache...
Built mapping cache(s) successfully.
# column mappings: 82
# table mappings: 643
# view mappings: 4
# constraint mappings: 14
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWT_11FB405DA7EC'
Generated short Identifier: IWO_140175FE9FA7 for long identifier: DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_STAGING_KEY
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWT_11FB405DA7EC'
Table [IWT_11FB405DA7EC] does not exist. Creating..
CREATE TABLE IWT_11FB405DA7EC (PATH VARCHAR(255) NOT NULL, IW_STATE VARCHAR(30), DESCRIPTION CLOB,CONSTRAINT IWO_140175FE9FA7 PRIMARY KEY (PATH))
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWTRACKER'
Table [iwtracker] exists.
DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_STAGING not registered
Registering DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_STAGING
INSERT INTO iwtracker (NAME,BASE,UPDATETIME,BRANCH) VALUES('DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_STAGING','__NO_BASE__',0, '/DEFAULT/MAIN/UPLOAD/STAGING')
Rows updated: 1
DELETE FROM IWT_11FB405DA7EC
Running deployment [basearea]
extraction type=default
tuple mode=wide
area=/default/main/upload/STAGING
/default/main/upload/STAGING/templatedata/category/datatype/data
Generate DirectoryContents start:Tue Jan 21 00:23:12 GMT-05:00 2003
Generate DirectoryContents end :Tue Jan 21 00:23:12 GMT-05:00 2003
Generate TDCRTupleProducer start:Tue Jan 21 00:23:12 GMT-05:00 2003
Generate TDCRTupleProducer end :Tue Jan 21 00:23:13 GMT-05:00 2003
FILE=[templatedata/category/datatype/data/ramamclob]
TUPLE={TeamSite/Templating/DCR/Type=category/datatype, state=Original, Description=hi, path=templatedata/category/datatype/data/ramamclob}
Starting SchemaHelper Cache Cleanup Thread...
TTableSchemaHelper not found in cache for [IWT_11FB405DA7EC]. Creating new.
SELECT Path, iw_state,Description FROM IWT_11FB405DA7EC WHERE Path=?
TTableSchemaHelper object for [IWT_11FB405DA7EC] found in cache.
WHERE clause parameter 1: templatedata/category/datatype/data/ramamclob
Column: Path, field: path, Index: 1,Converting 'templatedata/category/datatype/data/ramamclob' to VARCHAR
Using PreparedStatement for Insert....
TTableSchemaHelper object for [IWT_11FB405DA7EC] found in cache.
TTableSchemaHelper object for [IWT_11FB405DA7EC] found in cache.
PreparedInsert:INSERT_STR:INSERT INTO IWT_11FB405DA7EC (Path,iw_state, Description) VALUES (?,?, ?)
Inserting into IWT_11FB405DA7EC:
Parameter Index: 1, Value: templatedata/category/datatype/data/ramamclob, Converting 'templatedata/category/datatype/data/ramamclob' to VARCHAR
Column: Path, field: path, Index: 1,Converting 'templatedata/category/datatype/data/ramamclob' to VARCHAR
Parameter Index: 2, Value: Original, Converting 'Original' to VARCHAR
Column: iw_state, field: state, Index: 2,Converting 'Original' to VARCHAR
Parameter Index: 3, Value: hi, Converting 'hi' to STRING
length of CLOB data = 2
Column: Description, field: Description, Index: 3,Converting 'hi' to STRING
Processing CLOB data, count = 1
CLOB processing, Column = Description, Data Size = 2
SELECT_STR Smiley Frustrated

ELECT Description FROM IWT_11FB405DA7EC WHERE Path='templatedata/category/datatype/data/ramamclob'
Write to CLOB column [IWT_11FB405DA7EC Smiley Very Happy

escription] successful.
-- Inserted
FILE=[templatedata/category/datatype/data/startravel]
TUPLE={TeamSite/Templating/DCR/Type=category/datatype, state=Original, Description=ddd, path=templatedata/category/datatype/data/startravel}
TTableSchemaHelper object for [IWT_11FB405DA7EC] found in cache.
SELECT Path, iw_state,Description FROM IWT_11FB405DA7EC WHERE Path=?
TTableSchemaHelper object for [IWT_11FB405DA7EC] found in cache.
WHERE clause parameter 1: templatedata/category/datatype/data/startravel
Column: Path, field: path, Index: 1,Converting 'templatedata/category/datatype/data/startravel' to VARCHAR
Using PreparedStatement for Insert....
TTableSchemaHelper object for [IWT_11FB405DA7EC] found in cache.
TTableSchemaHelper object for [IWT_11FB405DA7EC] found in cache.
PreparedInsert:INSERT_STR:INSERT INTO IWT_11FB405DA7EC (Path,iw_state, Description) VALUES (?,?, ?)
Inserting into IWT_11FB405DA7EC:
Parameter Index: 1, Value: templatedata/category/datatype/data/startravel, Converting 'templatedata/category/datatype/data/startravel' to VARCHAR
Column: Path, field: path, Index: 1,Converting 'templatedata/category/datatype/data/startravel' to VARCHAR
Parameter Index: 2, Value: Original, Converting 'Original' to VARCHAR
Column: iw_state, field: state, Index: 2,Converting 'Original' to VARCHAR
Parameter Index: 3, Value: ddd, Converting 'ddd' to STRING
length of CLOB data = 17343
Column: Description, field: Description, Index: 3,Converting 'ddd' to STRING
Processing CLOB data, count = 1
CLOB processing, Column = Description, Data Size = 17343
SELECT_STR Smiley Frustrated

ELECT Description FROM IWT_11FB405DA7EC WHERE Path='templatedata/category/datatype/data/startravel'
Write to CLOB column [IWT_11FB405DA7EC Smiley Very Happy

escription] successful.
-- Inserted
UPDATE iwtracker SET UPDATETIME='Tue Jan 21 00:23:14 GMT-05:00 2003' WHERE NAME='DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_STAGING'
1 row(s) updated.
Committing database [techsun:1521:star]...
Deployment[basearea] Table[IWT_11FB405DA7EC]
-----------------------------------
Tuples inserted : 2
Tuples updated : 0
Tuples deleted : 0
Tuples failed : 0
Tuples rolled back : 0
Tuples skipped : 0
-----------------------------------
Files with EA's [2]
Started : Tue Jan 21 00:23:08 GMT-05:00 2003
Finished: Tue Jan 21 00:23:14 GMT-05:00 2003

### IWDataDeploy DONE ###

TWorkItem: Smiley Very Happy

oIt --- sock=2345 id=2
id=2 fDdArgs[0]=[cfg="/iwmnt/default/main/upload/WORKAREA/travel/templatedata/category/datatype/datatype_dd.cfg"]
id=2 fDdArgs[1]=[deployment=deltagen]
id=2 fDdArgs[2]=[myarea="/default/main/upload/WORKAREA/travel"]
id=2 fDdArgs[3]=[mybasearea="/default/main/upload/STAGING"]
id=2 fDdArgs[4]=[mytable=DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_WORKAREA_TRAVEL]
id=2 fDdArgs[5]=[mybasetable=DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_STAGING]
id=2 fDdArgs[6]=[mybasetablenameprefix=DEFAULT_CATEGORY_DATATYPE]
id=2 fDdArgs[7]=[mybasetablenamesuffix=MAIN_UPLOAD_STAGING]
id=2 fDdArgs[8]=[mytablenameprefix=DEFAULT_CATEGORY_DATATYPE]
id=2 fDdArgs[9]=[mytablenamesuffix=MAIN_UPLOAD_WORKAREA_TRAVEL]
id=2 fDdArgs[10]=[mytemplatepath=templatedata/category/datatype/data]
Database Vendor set to oracle
SQL datatype for column Description is CLOB
Area VPath:/default/main/upload/WORKAREA/travel
Setting up TExtAttrDbAgent
Validating cached connection...
Cached connection OK
Connected to [techsun:1521:star]
Generated short Identifier: IWT_160387435679 for long identifier: DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_WORKAREA_TRAVEL
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWT_160387435679'
Generated short Identifier: IWO_182929CAA18E for long identifier: DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_WORKAREA_TRAVEL_KEY
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWT_160387435679'
Table [IWT_160387435679] does not exist. Creating..
CREATE TABLE IWT_160387435679 (PATH VARCHAR(255) NOT NULL, IW_STATE VARCHAR(30), DESCRIPTION CLOB,CONSTRAINT IWO_182929CAA18E PRIMARY KEY (PATH))
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWTRACKER'
Table [iwtracker] exists.
DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_STAGING registered
DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_WORKAREA_TRAVEL not registered
Registering DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_WORKAREA_TRAVEL
INSERT INTO iwtracker (NAME,BASE,UPDATETIME,BRANCH) VALUES('DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_WORKAREA_TRAVEL','DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_STAGING',0, '/DEFAULT/MAIN/UPLOAD/WORKAREA')
Rows updated: 1
DELETE FROM IWT_160387435679
Creating table view...
DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_WORKAREA_TRAVEL_VW not registered
Generated short Identifier: IWV_17B4D663DADB for long identifier: DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_WORKAREA_TRAVEL_VW
DROP VIEW IWV_17B4D663DADB
CREATE VIEW IWV_17B4D663DADB AS SELECT * FROM IWT_11FB405DA7EC WHERE NOT EXISTS (SELECT * FROM IWT_160387435679 WHERE IWT_160387435679.Path = IWT_11FB405DA7EC.Path ) UNION SELECT * FROM IWT_160387435679 WHERE IWT_160387435679.iw_state != 'NotPresent'

*******************************************************
SQLException occured in TDbAgent:CreateView()
Exception Message: ORA-00932: inconsistent datatypes

Vendor Error Code: 932
SQL state: 42000
*******************************************************

*******STACK TRACE*************
java.sql.SQLException: ORA-00932: inconsistent datatypes

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:693)
at com.interwoven.dd100.dd.TDbAgent.CreateView(TDbAgent.java:1016)
at com.interwoven.dd100.dd.TExtAttrDbAgent.<init>(TExtAttrDbAgent.java:68)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumer(TConsumerManager.java:596)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumersForOneDeployment(TConsumerManager.java:188)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumers(TConsumerManager.java:130)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:92)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:385)
at com.interwoven.dd100.dd.TWorkItem.DoIt(TWorkItem.java:163)
at com.interwoven.dd100.dd.TLonelyWorker.run(TLonelyWorker.java:32)
at java.lang.Thread.run(Thread.java:484)
Error occured in TDbAgent::CreateView()
View creation for DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_WORKAREA_TRAVEL_VW Failed.
Rollback database [techsun:1521:star]...
Deployment[deltagen] Table[IWT_160387435679]
-----------------------------------
Tuples inserted : 0
Tuples updated : 0
Tuples deleted : 0
Tuples failed : 0
Tuples rolled back : 0
Tuples skipped : 0
-----------------------------------
Files with EA's [0]
ERROR:TExtAttrDbAgent create failure
Started : Tue Jan 21 00:23:14 GMT-05:00 2003
Finished: Tue Jan 21 00:23:15 GMT-05:00 2003

### IWDataDeploy FAILED ###

thread[main] accepted connection(3)!

SerialDaemon dispatch
awaiting msg...
msg [cfg="/iwmnt/default/main/upload/WORKAREA/travel/templatedata/category/datatype/datatype_dd.cfg" deployment=submitlist myarea="/default/main/upload/WORKAREA/travel" mytable=DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_WORKAREA_TRAVEL mybasetable=DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_STAGING mybasetablenameprefix=DEFAULT_CATEGORY_DATATYPE mybasetablenamesuffix=MAIN_UPLOAD_STAGING mytablenameprefix=DEFAULT_CATEGORY_DATATYPE mytablenamesuffix=MAIN_UPLOAD_WORKAREA_TRAVEL mysubmitlist=/var/tmp/aaaela4RD ]
TWorkItem: Smiley Very Happy

oIt --- sock=2345 id=3
id=3 fDdArgs[0]=[cfg="/iwmnt/default/main/upload/WORKAREA/travel/templatedata/category/datatype/datatype_dd.cfg"]
id=3 fDdArgs[1]=[deployment=submitlist]
id=3 fDdArgs[2]=[myarea="/default/main/upload/WORKAREA/travel"]
id=3 fDdArgs[3]=[mytable=DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_WORKAREA_TRAVEL]
id=3 fDdArgs[4]=[mybasetable=DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_STAGING]
id=3 fDdArgs[5]=[mybasetablenameprefix=DEFAULT_CATEGORY_DATATYPE]
id=3 fDdArgs[6]=[mybasetablenamesuffix=MAIN_UPLOAD_STAGING]
id=3 fDdArgs[7]=[mytablenameprefix=DEFAULT_CATEGORY_DATATYPE]
id=3 fDdArgs[8]=[mytablenamesuffix=MAIN_UPLOAD_WORKAREA_TRAVEL]
id=3 fDdArgs[9]=[mysubmitlist=/var/tmp/aaaela4RD]
Database Vendor set to oracle
SQL datatype for column Description is CLOB
Area VPath:/default/main/upload/WORKAREA/travel
Setting up TExtAttrDbAgent
Validating cached connection...
Cached connection OK
Connected to [techsun:1521:star]
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWT_160387435679'
Table <IWT_160387435679> exists.
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWTRACKER'
Table [iwtracker] exists.
DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_STAGING registered
DEFAULT_CATEGORY_DATATYPE__MAIN_UPLOAD_WORKAREA_TRAVEL registered
Running deployment [submitlist]
extraction type=full
tuple mode=wide
area=/default/main/upload/WORKAREA/travel
filelist=[/var/tmp/aaaela4RD]
ERROR:FileNotFoundException: /var/tmp/aaaela4RD (Permission denied)
ERROR:deployment [submitlist] FAILED
Error occured in area outside TDbAgent consumer (explicit rollback initiated)
Rollback database [techsun:1521:star]...
Deployment[submitlist] Table[IWT_160387435679]
-----------------------------------
Tuples inserted : 0
Tuples updated : 0
Tuples deleted : 0
Tuples failed : 0
Tuples rolled back : 0
Tuples skipped : 0
-----------------------------------
Files with EA's [0]
Started : Tue Jan 21 00:28:07 GMT-05:00 2003
Finished: Tue Jan 21 00:28:07 GMT-05:00 2003

### IWDataDeploy FAILED ###

Find more posts tagged with

Comments

There are no comments yet