nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Data Deploy Problem...

akashmishra17

Guys,

In my deploymentscript when i Put path as "ts-filesystem" It does'nt work.

source>
xml-source options="wide,full" include-extended-attribute="yes" area="//Root/default/main/Shilpa_Test/WORKAREA/Test/templatedata/news/newslist/data/DCRNAME" area-type="ts-filesystem" xml-type="custom">

but when I put path as area-type="os-filesystem" and give OS Path then it works fine....

Can any body know what the problem may be...In Logs it says

2008-10-15 14:47:12 IST GMT+05:30 Database deployment execution returned 0

ENG: 2008-10-15 14:47:12 IST GMT+05:30 <<< Completed database deployment Invocation>>>

ENG: 2008-10-15 14:47:12 IST GMT+05:30 doTask returned 0

ENG: 2008-10-15 14:47:12 IST GMT+05:30 Setting final state to TASKDONE

ENG: 2008-10-15 14:47:12 IST GMT+05:30 Manifest path is C:/Interwoven/OpenDeployNG/log/testDD/src.newsTestCompKey.NewsCK.mlbp-0959.to.database.log.mf

ENG: 2008-10-15 14:47:12 IST GMT+05:30 Got Manifest object com.interwoven.od.adapter.delivery.base.IWODManifest@12b87e5

ENG: 2008-10-15 14:47:12 IST GMT+05:30 fHasFailedItems is set to false

ENG: 2008-10-15 14:47:12 IST GMT+05:30 Published leg event depUuid=[0d308e70-9a9a-11dd-814b-dce9e4965d11] legLabel=[database] nextUuid=[null] nextDep=[null]
ENG: 2008-10-15 14:47:12 IST GMT+05:30 Job ID=m36 Deployment leg=database Elapsed Time=78 ms <<<
ENG: 2008-10-15 14:47:12 IST GMT+05:30 End logfile [C:\Interwoven\OpenDeployNG\log\testDD\src.newsTestCompKey.NewsCK.mlbp-0959.to.database.log]

ENG: 2008-10-15 14:58:46 IST GMT+05:30 Begin logfile [C:\Interwoven\OpenDeployNG\log\testDD\src.newsTestCompKey.NewsCK.mlbp-0959.to.database.log] ---------
ENG: 2008-10-15 14:58:46 IST GMT+05:30 Job ID=m37 Deployment=testDD/newsTestCompKey
ENG: 2008-10-15 14:58:46 IST GMT+05:30 DataDeploy Version is 6.2.0.0.0
ENG: 2008-10-15 14:58:46 IST GMT+05:30 Owner started the deployment is MLBP-0959\Administrator
ENG: 2008-10-15 14:58:46 IST GMT+05:30 DD args iwdd="NewsCK" deployTargetUsername="sa" deployTargetPassword="pswd" cfg=C:\Interwoven\OpenDeployNG\conf\testDD\newsTestCompKey.xml need-result=yes depuuid=aaf2cc30-9a9b-11dd-814b-dce9e4965d11 leglabel=database

ENG: 2008-10-15 14:58:46 IST GMT+05:30 Proceed to execute the database deployment

DBD: Deployment : NewsCK
DBD: Database Vendor set to rdbms
DBD: SQL datatype for column Title is VARCHAR(50)
DBD: SQL datatype for column News is VARCHAR(50)
DBD: SQL datatype for column Link is VARCHAR(50)
DBD: SQL datatype for column Date is datetime
DBD: # of columns: 4
DBD: # of primary key columns specified: 2
DBD: # of groups defined in element: 1
DBD: [Wed Oct 15 14:58:46 IST 2008] Begin executing NewsCK
DBD: Begin Set up the publisher thread
DBD: End Set up the publisher thread
DBD: Area VPath://ip/default/main/Shilpa_Test/WORKAREA/NewjetTest/templatedata/jetnews/newslist/data/containertest
DBD: Setting up TDbSchemaAgent.
DBD: Validating cached connection...
DBD: Cached connection OK
DBD: Connected to [172.20.73.96:1433;databaseName=IWDB]
DBD: Table [JW_News] exists.
DBD: Running deployment [NewsCK]
DBD: extraction type=full
DBD: tuple mode=wide
DBD: area=//ip/default/main/Shilpa_Test/WORKAREA/NewjetTest/templatedata/jetnews/newslist/data/containertest
DBD: //ip/default/main/Shilpa_Test/WORKAREA/NewjetTest/templatedata/jetnews/newslist/data/containertest/.
DBD: Generate DirectoryContents start:Wed Oct 15 14:58:46 IST 2008
DBD: Generate DirectoryContents end :Wed Oct 15 14:58:46 IST 2008
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=.}
DBD: TTableSchemaHelper object for [JW_News] found in cache.
DBD: SELECT KEYCOLNAME , KEYCOLVALUE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ? AND KEYCOLNAME IN ( 'Title','News')
DBD: 0 PK values retrieved from iwdeltracker for ., //ip/default/main/Shilpa_Test/WORKAREA/NewjetTest/templatedata/jetnews/newslist/data/containertest
DBD: DELETE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ?
DBD: -- Deleted
DBD: Stat for group [JW_News]:
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 [ip:1433;databaseName=IWDB]...
DBD: Deployment[NewsCK]
DBD: -----------------------------------
DBD: DCRs inserted : 0
DBD: DCRs updated : 0
DBD: DCRs deleted : 1
DBD: DCRs failed : 0
DBD: DCRs rolled back : 0
DBD: DCRs skipped : 0
DBD: -----------------------------------
DBD: Started : Wed Oct 15 14:58:46 IST 2008
DBD: Shutting down DDD PublisherThread
DBD: Finished: Wed Oct 15 14:58:47 IST 2008

Find more posts tagged with

Comments

nipper

It is not finding your DCR. Check your deploy.cfg file and see if you have the teamsite version entry set.

msrinivas

[color=#007700]<xml-source options="wide,full" include-extended-attribute="yes" area="/default/main/Shilpa_Test/WORKAREA/Test" area-type="ts-filesystem" xml-type="custom">
<path name="/templatedata/news/newslist/data"
visit-directory="deep" />  [/color]

Try that!

HTH

nipper

Srinivas, correct me if I am wrong, but won't that take all DCRs in the data folder rather than a single one ? It is pretty hard ot use that type of deployment in a workflow....

msrinivas

Andy,

You are correct. But with incomplete information from OP I made my assumptions Smiley Wink

to come up with that. (Golden rule, of course, to never assume :rolleyes Smiley Happy

nipper

From this path:

templatedata/jetnews/newslist/data/containertest

I assumed it was a DCR named containertest

Of course extensions are a beautiful thing. Naming XML dcrs .xml seems like a trivial thing and yet people don't

Andy

akashmishra17

Thanks Guys Its really help me alot.....but can any one of you suggest me that can we use any Database queries or stored procedures with our deployment script.

Since I have four check boxes...and I wan't to deploy them in seperate rows, so can we able to do it by any logic....