using dbLoader and eaAndXmlData broken

TeamSite 6.5 SP1
Solaris 2.9
OD 6.0.2

I am trying to use the dbLoader element to synchronize moving code files (JSP) and then loading the contents and metadata of DCRs into a DB.

When I use the following:

<dbLoader useDatabaseRef="webdb">
<eaAndXmlData>
<xmlData schemaMapFile="/opt/iw-home/OpenDeployNG/schemas/$dct^.xml" xmlType="interwoven"/>
<eaData schemaMapFile="/opt/iw-home/OpenDeployNG/schemas/TeamSite-Metadata.xml"/>
</eaAndXmlData>
</dbLoader>

The webdb has delete-tracker="yes" in the database.xml file on the target

The DCR xml data is written to the database correctly, and tracking information is recorded. There is no tracking information recorded for the metadata. When I go to do a delete, the metadata selection is processed first, and it wipes out all the rows from the IWDELTRACKER table, causing it to do nothing when trying to remove the tracker entries for my content table, since there are no longer any entries in the tracker table.

Here is a snippet from the log:
DD : TUPLE={state=NotPresent, path=templatedata/EnhancedBrand/BrandServices/data/bktest, iw_internal_area=/appsnfs/content/tmp/default/main/Enhanced/Conrad/WORKAREA/content}
DD : TTableSchemaHelper object for [ts_metadata2] found in cache.
DD : SELECT KEYCOLNAME , KEYCOLVALUE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ? AND KEYCOLNAME IN ( 'id')
DD : 0 PK values retrieved from iwdeltracker for templatedata/EnhancedBrand/BrandServices/data/bktest, /appsnfs/content/tmp/default/main/Enhanced/Conrad/WORKAREA/content
DD : DELETE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ?
DD : -- Deleted
DD : Deployment eafile_s0_p0 ok
DD : extraction type=full
DD : tuple mode=wide
DD : area=/appsnfs/content/tmp/default/main/Enhanced/Conrad/WORKAREA/content
DD : filelist=[/opt/iw-home/OpenDeployNG/log/development/ddfilelist50176.txt]
DD : ERROR:/appsnfs/content/tmp/default/main/Enhanced/Conrad/WORKAREA/content/templatedata/EnhancedBrand/BrandServices/data/bktest not found:/appsnfs/content/tmp/default/main/Enhanced/Conrad/WORKAREA/content/templatedata/EnhancedBrand/BrandServices/data/bktest (No such file or directory)
DD : Building replicant order column information.
DD : Building replicant order column information... Done.
DD : TUPLE={state=NotPresent, path=templatedata/EnhancedBrand/BrandServices/data/bktest}
DD : TTableSchemaHelper object for [ts_brand_services] found in cache.
DD : SELECT KEYCOLNAME , KEYCOLVALUE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ? AND KEYCOLNAME IN ( 'brand_id','svc_type')
DD : 0 PK values retrieved from iwdeltracker for templatedata/EnhancedBrand/BrandServices/data/bktest, /appsnfs/content/tmp/default/main/Enhanced/Conrad/WORKAREA/content
DD : DELETE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ?
DD : -- Deleted
DD : Filelist walk done
DD : Deployment filelist_s0_p0 ok

so, it seems the eaData component is dying on their being no file in the file system, since od is removing it, but that doesn't seem to be a problem for the xmlSource component.

The metadata table is a user defined schema. This works completely in standalone DataDeploy mode, and was hoping to use this dcLoader element, but i don't think we can.

All we are trying to do is move code and load content and metadata into a database. The only way around this issue that I see is to use Data Deploy in standalone mode through a deploy and run script, unless I am missing something.

Edited by bk99nd on 11/17/05 11:30 AM (server time).

Find more posts tagged with

Comments

Migrateduser

For my understanding... so you are deploying regular file assets, DCRs, and then EA's set on the DCRs? You are seeing that no EA's are deployed?

The log that you shared, was that from running a subsequent deployment (after the first deployment with the missing the EA's)? I want to be clear on the conditions ... ie do EA's never get deployed in this configuration.. or is there something more specific causing this... I don't understand where this missing OD files comes in. How is that file related to the EA?

Thanks
Mariam

Bill Klish

We are deploying files, and DCRs and EAs set on the DCRs only. The files are deployed correctly, and the DCRs are deployed into the temp file area, and the contents of the DCRs are loaded into the DB correctly, with the tracking information being recorded.

However, there is no tracking information being recorded for the metadata. The metadata gets written into the table, but since there is no tracking information, the data never gets removed if we delete the DCRs. The DCR content is removed, but then it doesn't know that it has to remove the metadata values too, since Data Deploy wrote no information to IWDELTRACKER.

The snippet of the log was what happens when I deleted the DCR (after the load (insert) had already occurred).

Does this make sense?

Bill Klish

I am just going to file a support case to see if we can get anywhere with this.

Migrateduser

One idea is that since the deployment is essentially split into two deployments (one for data and the other for ea's), the ea deployment happens first and updates the deltracker table. Then the file deployment happens and overwrites the ea info in deltracker since both ea and the file share the same path.

Can you try something.. can you just deploy the ea's (so skip the file part) and see if the deltracker info is there for the ea?

Mariam

Solito

any solution on this ..?
i'm really interested by the final answer
thanks

M

Bill Klish

This is a confirmed bug with solaris 2.9. Apparently it works in windows.

The bug # is 64114. contact support and attach your customer name to the bug so you will be contacted when it is corrected. This is a bug exists in 6.0.2 SP1 as well.

Solito

thanks mate

googlemaps.rptdesign