DD deployment using DBLoader

Hi,
We recently upgraded from OD5.6 to OD6.0.2.

We would like to use <dbloader/> tag in the opendeploy configuration to do OD/DD deployment rather than using DNR script. I was trying to do a POC, and that seems to lead me nowhere.

My OD configuration executes deployment with failed status. I am apparently doing something wrong here, but could someone please tell me what that is?

<definition name="DD_Definition">
<source>
<fileSystem>
<filelist area = "Y:\default\main\IIG\WorkArea\Content_Design" filePath="F:\apps\iw-home\temp\DDfilelist.txt">
<pathSpecification>
<path name="."/>

<dbLoader useDatabaseRef = "Preview">
<xmlData schemaMapFile = "F:\Apps\iw-home\opendeployng\OpenDeploy\conf\DeploymentConfigFiles\test_dd.xml" xmlType = "interwoven"/>
</dbLoader>
</pathSpecification>
</filelist>
</fileSystem>
</source>

<target useReplicationFarm="DEV">
<targetFilesystem area="somearea"/>
</target>
</definition>

<deployment transactional="yes" >

<execDeploymentTask useDefinition="DD_Definition"/>
</deployment>

<logRules maxBytes="32Mb" level="VERBOSE"/>

</deploymentConfiguration>

do I even need to specify target specification for a DD definition?

Any suggestion/pointer/RTFM(with specific reference of course :-)) is appreciated

-cliff

Find more posts tagged with

Comments

jed

Yes. You must have a valid target defined.

To skip the deployment of content, check out FR #57077
http://devnet.interwoven.com/forums/cgi-bin/showflat.pl?Cat=&Board=PRODUCTS_OPENDEPLOY&Number=60397&page=0&view=collapsed&sb=5&o=0&part=

--
Jed Michnowicz
jedm@sun.com
Content Management Engineering
Sun Microsystems

cliffhanger

Thanks Jed, this post answered some of my questions.

I changed the DD target to a valid one, and this is how my DD definition looks now:

<target useReplicationFarm="DD">
<targetFilesystem area="Y:\default\main\iig\WorkArea\Content_Design"/>
</target>

I have also added the areapath to <allowedDirectories> of my receiver host(base and receiver are the same for now). I restarted OD service after that change, yet when i attempt to do the deployment, it gives me the following error:

Receiver-ERROR: ERROR: commit-failed.
LIB: 2005-06-28 14:42:46 ERROR: Failed to deploy local_directory[.] of area[Y:\default\main\IIG\WorkArea\Content_Design] for filelist[F:\apps\iw-home\temp\DDfilelist.txt]
LIB: 2005-06-28 14:42:46 ERROR: Failed 1 of 1 filelists

DDfilelist.txt contains the following entry:
templatedata/Documents/Forms_And_Marketing_Materials/data/form-1

Any idea?

jed

If you take out the DBloader step, does it deploy properly? Have you setup the receiver to peform DD deployments? Something like this in odrcvr.xml

<databaseDeployment daemon_port="2345">
<standalone enabled="yes" />
<das enabled="no" />
</databaseDeployment>

--
Jed Michnowicz
jedm@sun.com
Content Management Engineering
Sun Microsystems

cliffhanger

If you take out the DBloader step, does it deploy properly?
YES.

Have you setup the receiver to peform DD deployments?
Yes, but I have both standalone and DAS enabled in the receiver, is that a problem? Do they have to be exclusively enabled?

jed

> Yes, but I have both standalone and DAS enabled in the receiver, is that a problem? Do they have to be exclusively enabled?

Not sure. We do not use DAS. You could always disable DAS, re-deploy and see what happens. Posting all the relevant configs/logs might help find an answer as well.

~jed

--
Jed Michnowicz
jedm@sun.com
Content Management Engineering
Sun Microsystems

Migrateduser

You should be able to safely disable DAS in the receiver.

DAS is typically enabled in a base server rather than a receiver. The typical use case for DAS is for TeamSite user actions to generate events. Those events trigger the base server to sync a TeamSite area directly with a database.

Todd Scallan
Director of Product Management
Interwoven
t: 408-530-7167
e: tscallan@interwoven.com

cliffhanger

Well I did. But didn't help either, I still get the same error message.

So as Jed suggested, here are the relevant snippet of my configurations:
odbase.xml

<databaseDeployment daemon_port="2345">
<standalone enabled="yes" />
<das enabled="yes" />
</databaseDeployment>
<allowedHosts>
<node host="AWCTMD01">
<allowedDirectories>
<path name="F:\Apps\iw-home\opendeployng\OpenDeploy\tmp"/>
<path name="Y:\default\main\IIG\WorkArea\Content_Design"/>
<path name="\MY\ALLOWED\DIR\PATH-1"/>
<path name="f:\temp"/>
</allowedDirectories>
</node>
</allowedHosts>

odnodex.xml

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<nodeSet>
<node name="MyLocalHost"
host="AWCTMD01"
port="20014"
/>
<replicationFarmSet>
<replicationFarm name="MYFARMNAME">
<nodeRef useNode="MyLocalHost"/>
</replicationFarm>
</replicationFarmSet>
</nodeSet>

OD Config file

<?xml version="1.0" encoding="UTF-8"?>
<deploymentConfiguration >
<localNode host="AWCTMD01" />
<replicationFarmSet >
<replicationFarm name="DD" quorum="" >
<nodeRef useNode="MyLocalHost" >
</nodeRef>
</replicationFarm>
</replicationFarmSet>
<definition name="DD_Definition">
<source>
<fileSystem>
<filelist area = "Y:\default\main\IIG\WorkArea\Content_Design" filePath="F:\apps\iw-home\temp\DDfilelist.txt">
<pathSpecification>
<path name="."/>

<dbLoader useDatabaseRef = "IIG_CMS_Preview_Production">
<xmlData schemaMapFile = "F:\Apps\iw-home\opendeployng\OpenDeploy\conf\DeploymentConfigFiles\IIG_CMS20\Documents\document_dd.xml" xmlType = "interwoven"/>
</dbLoader>
</pathSpecification>
</filelist>
</fileSystem>
</source>

<target useReplicationFarm="DD">
<targetFilesystem area="Y:\default\main\iig\WorkArea\Content_Design"/>

<comparisonRules dateDifferent="no" revert="no" ignoreAcls="yes" ignoreModes="no" ignoreUser="no" ignoreGroup="no" />

<transferRules doDeletes="no" dontDo="no" preserveAcls="no" followLinks="no" svrTryCount="7" svrTryInterval="10" svrTryDisableOverwrite="no" rmReadOnly="no" compression="no" compressionLevel="" />

</target>
</definition>

<deployment transactional="yes" >
<execDeploymentTask useDefinition="DD_Definition"/>
</deployment>

<logRules maxBytes="32Mb" level="VERBOSE"/>

</deploymentConfiguration>

dd cfg file

<data-deploy-configuration>
<data-deploy-elements filepath="F:\Apps\iw-home\opendeployng\OpenDeploy\etc\database.xml" />
<client>
<deployment name="DocMetadata">
<source>
<teamsite-templating-records options="wide" area="$path">
<path filelist="$filelist" visit-directory="deep"/>
</teamsite-templating-records>
</source>
<destinations>
<database use="$dbname">

<dbschema>.............</dbschema>
</database>
</destinations>
</deployment>
</client>
</data-deploy-configuration>

Error LOG

LIB: 2005-06-30 09:01:46 BEGINNING Transactional Deployment
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 After SETUP, res=0
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 exiting setup
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 entering awaiting-dotask
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 still waiting for 0
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 exiting awaiting-dotask
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 entering dotask
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 COMPARE
LIB: 2005-06-30 09:01:46 Options: deploy svr_try_count=7 svr_try_interval=10 ignore_acls do_manifest_for_dnr verbose_level=5
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 After COMPARE, res=0
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 PRECOMMIT
LIB: 2005-06-30 09:01:46 DEPLOYING - [F:\apps\iw-home\temp] to [y:\default\main\iig\workarea\content_design]
LIB: 2005-06-30 09:01:46 Filelist=[F:\apps\iw-home\temp\DDfilelist.txt]
LIB: 2005-06-30 09:01:46 Sending [.\10-CBI-MO] [reason file_list]
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 After PRECOMMIT, res=0
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 exiting dotask
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 entering awaiting-commit
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 still waiting for 0
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 exiting awaiting-commit
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 entering commit
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Current deployment thread is an OD-DD leg
LIB: 2005-06-30 09:01:46 *** Proceed
LIB: 2005-06-30 09:01:46 *** fFailedCommitFromEngine 0
LIB: 2005-06-30 09:01:46 COMMITTING Transactional Deployment
LIB: 2005-06-30 09:01:46 Receiver-ERROR: ERROR: commit-failed.
LIB: 2005-06-30 09:01:46 ERROR: Failed to deploy local_directory[.] of area[F:\apps\iw-home\temp] for filelist[F:\apps\iw-home\temp\DDfilelist.txt]
LIB: 2005-06-30 09:01:46 ERROR: Failed 1 of 1 filelists
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 After COMMIT, res=-1
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 exiting commit
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 entering awaiting-rollback
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 still waiting for 0
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Result after commit -1
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 exiting awaiting-rollback
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 entering rollback
LIB: 2005-06-30 09:01:46 ROLLBACK Transactional Deployment
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 After ROLLBACK, res=0
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 exiting rollback
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 entering awaiting-cleanup
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 still waiting for 0
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 exiting awaiting-cleanup
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 entering cleanup
LIB: 2005-06-30 09:01:46 Remote status: server-OK
LIB: 2005-06-30 09:01:46 [Thu Jun 30 09:01:46 2005] opendeploy 20050630.4984.2 NT AUTHORITY\SYSTEM COMPLETED F:\apps\iw-home\temp .testdbloader1.DD_Definition.mylocalhost AWCTMD01 AWCTMD01
LIB: 2005-06-30 09:01:46 [Thu Jun 30 09:01:46 2005] 20050630.4984.2 STATS DEPLOYMENT F:\apps\iw-home\temp -- .testdbloader1.DD_Definition.mylocalhost OK
Directories deployed : 0 Files deployed : 1 Links deployed : 0
Directories failed : 0 Files failed : 0 Links failed : 0
Directories deleted : 0 Files deleted : 0 Links deleted : 0

LIB: 2005-06-30 09:01:46 File Content transferred: 1894 bytes
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 After CLEANUP, res=1
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 exiting cleanup
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 entering task-failed
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 still waiting for 0
LIB: 2005-06-30 09:01:46 LOGFILE=[F:\Apps\iw-home\opendeployng\OpenDeploy\log\src.testdbloader1.DD_Definition.AWCTMD01.to.mylocalhost.log]
LIB: 2005-06-30 09:01:46 Locale=[English_UnitedStates.MS1252@Binary]
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 PostDisConnect Dnr still waiting for 0
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 Deleting the internal config file = F:\Apps\iw-home\opendeployng\OpenDeploy\log\.testdbloader1.DD_Definition.mylocalhost
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 Job ID=m7 Deployment leg=mylocalhost.DD_Definition Elapsed Time=328 ms <<<
ENG: 2005-06-30 09:01:46 CDT GMT-05:00 Thread-41 End logfile [F:\Apps\iw-home\opendeployng\OpenDeploy\log\src.testdbloader1.DD_Definition.AWCTMD01.to.mylocalhost.log]

Let me know if anyone wants these files as attachments.

Thanks folks!!
-cliff

Ottawa_IWOV

Did u get this resolved. I am having a similar issue w/ deployment fails (really simple example scenario), and I have not a clue why.

Thanks,

Ottawa_IWOV

My Open Deploy base server is also my receiver. Is there anything else I would need to configure to get a dbLoader deployment working. This was not the case with anything prior to OD 6.0.2

cliffhanger

Yes we did get this issue resolved.

I think setting "databaseXmlFile" attribute in the dbLoader tag fixed it. I left that company about 3 months ago, so I have no way of going back to verify this change.
But I'll call up my colleague who's still there to find out from the support case history exactly what had resolved this issue.

-cliff

FurnaceFace

Hi Cliff,

Did you ever find out how this was resolved? I'm running into the exact same problem and did everything that was suggested in the thread to no avail. I even added in the databasexml tag to no avail. Any help would be appreciated.

Thanks,
/FF