Hi,
We are using Teamsite 6.7 and Opendeploy 6.1. We are facing issues in deploying standalone deployment for both xml to DB and EA to DB.
Following is the config file I used to test deployment.
same config file is working with Teamsite 6.5 to Opendeploy 6.1
filepath="/usr/OpenDeployNG/etc/database.xml"/>
options = "wide"
area = "/default/main/mansion/WORKAREA/content">
update-type = "standalone"
state-field = "state">
Following is the log generated:
ENG: 2006-11-20 12:22:57 SGT GMT+08:00 Proceed to execute the database deploymen
t
DBD: Deployment : testea
DBD: Database Vendor set to oracle
DBD: SQL datatype for column path is VARCHAR(255)
DBD: SQL datatype for column state is VARCHAR(255)
DBD: SQL datatype for column Title is VARCHAR(60)
DBD: # of columns: 3
DBD: # of primary key columns specified: 1
DBD: WARNING:Assuming group name as the table name for [testea].
DBD: # of groups defined in element: 1
DBD: [Mon Nov 20 12:22:57 SGT 2006] Begin executing testea
DBD: Area VPath:/default/main/mansion/WORKAREA/content
DBD: Setting up TDbSchemaAgent.
DBD: Validating cached connection...
DBD: Cached connection OK
DBD: Connected to [10.234.89.20:1521:mansion]
DBD: SELECT * FROM USER_TABLES WHERE TABLE_NAME='TESTEA'
DBD: Table [testea] exists.
DBD: Running deployment [testea]
DBD: extraction type=default
DBD: tuple mode=wide
DBD: area=/default/main/mansion/WORKAREA/content
DBD: /default/main/mansion/WORKAREA/content/templatedata/testing/testdd/data/tes
t.txt
DBD: Generate DirectoryContents start:Mon Nov 20 12:22:57 SGT 2006
DBD: Generate DirectoryContents end :Mon Nov 20 12:22:57 SGT 2006
DBD: Generate TFullEAExtractor start:Mon Nov 20 12:22:57 SGT 2006
DBD: Generate TFullEAExtractor end :Mon Nov 20 12:22:57 SGT 2006
DBD: Path not found -- interpret as 'NotPresent'
DBD: Building replicant order column information.
DBD: Building replicant order column information... Done.
DBD: TUPLE={state=NotPresent, path=templatedata/testing/testdd/data/test.txt}
DBD: TTableSchemaHelper object for [testea] found in cache.
DBD: SELECT
ELECT state,Title,path FROM testea WHERE path = ?
DBD: Recurse select: pIndex = 0, value = templatedata/testing/testdd/data/test.t
xt
DBD: BuildTuples:executeQuery returned valid result set
DBD: TTableSchemaHelper object for [testea] found in cache.
DBD: BuildTuples:BuildRows returned: true
DBD: -- Deleted
DBD: Stat for group [testea]:
DBD: -----------------------------------
DBD: Rows inserted : 0
DBD: Rows updated : 0
DBD: Rows deleted : 0
DBD: Rows failed : 0
DBD: Rows rolled back : 0
DBD: Rows skipped : 0
DBD: -----------------------------------
DBD: Committing database [10.234.89.20:1521:mansion]...
DBD: Deployment[testea]
DBD: -----------------------------------
DBD: Files with EAs inserted : 0
DBD: Files with EAs updated : 0
DBD: Files with EAs deleted : 1
DBD: Files with EAs failed : 0
DBD: Files with EAs rolled back : 0
DBD: Files with EAs skipped : 0
DBD: -----------------------------------
I am getting Path not found error. I tried all the ways of mentioning area and path values. like /iwmnt/default , /default,/.iwmnt/default
Please let me know if anyone used Teamsite 6.7 with Opendeploy 6.1
Regards,
krishnaprasad