DataDeploy.. ARGGGHHHHH!!!!!

I've been in IT for over 15 years, and have never seen a product that is so muddled as this product. I am trying my best to figure out how to get a DCR file with metadata into a SQL table. I have spent the better part of 3 days trying to follow the documentation and frankly I'm at a loss. Is there a few words that some could give that would point me in a solid direction?

The things I have tried. Following the DAS Tutorial from the od.610.ddadmin.pdf file. Things go ok until I run iwsyncdb -initial and it gives me Runtime Exception in com.interwoven.dd100.syncdb.TRunIntial... string index out of range? ok..whatever...

Then

I've tried to use the DAS config withing the OpenDeploy UI but when I try to set up my SQL server database it tells me "There was a problem creating the file jmsconfig.xml. Check if the file jmsconfig_rdbms.xml.example exists and is valid" That tells me nothing.

I'm a beatin down man and frustrated at this point. Because I feel that no matter what direction I turn to I end up with some point of failure. The only success I had was the tutorial that took data out of an XML file and placed it into the SQL DAtabase..but that excercise provides me nothing at this point..

Thank you
Dave

Find more posts tagged with

Comments

Bill Klish

Ok, let's see if we can get you some help.

First question, why do you need DAS?

From the high level information you have provided, I would think you need to do this:

Do you need the DCR content and metadata (EAs) into the database? Are they independent of eachother (load 1 or more tables with DCR content, and all metadata into 1 table, or is there a mix of content and metadata that go into 1+ tables)?

Based on the manual names it looks like you are using OD 6.1. What platform and database are you trying to insert into?

dapcook

Ok, let's see if we can get you some help.

First question, why do you need DAS?

From the high level information you have provided, I would think you need to do this:

Do you need the DCR content and metadata (EAs) into the database? Are they independent of eachother (load 1 or more tables with DCR content, and all metadata into 1 table, or is there a mix of content and metadata that go into 1+ tables)?

Based on the manual names it looks like you are using OD 6.1. What platform and database are you trying to insert into?

I assume I need DAS.. I may be wrong. What I am wanting to do is take both content and extended attributes / meta data, and place this in a SQL Database. As far as using multiple tables, storing meta in one, content in another, that doesn't matter. My frustration is just knowing what tool to use properly and configuring it. The reason I was looking at DAS was because of a tutorial I found in the admin documentation that stated it would deploy DCR's from teamsite into a database. This premise could be incorrect, I don't know.

I amusing OD 6.1 and the database was/"suppose" to be SQL Express locally on the same server, but it can be a full fledged SQL server if need be.

Bill Klish

I would think you can accomplish what you need using the dbLoader functionality. See the DD admin manual for more information. You just need to create your database table/column mappings and should be good to go. Did you try using dbLoader?

dapcook

I would think you can accomplish what you need using the dbLoader functionality. See the DD admin manual for more information. You just need to create your database table/column mappings and should be good to go. Did you try using dbLoader?

No I haven't, but let me read up on that.

Thanks,
Dave

Migrateduser

dapcook,

I agree with you 100%. Datadeploy is at best a kludge and the documentation is atrocious. It's good to know that the market is still ripe for half-baked software -- it speaks well of our industry.

Dave

dapcook

Well, I don't want to speak overly negative of this product (Interwoven as a whole), but the first thing I noticed when going through both training classes this summer (TS Dev & TS Admin) was the lack of consistancy in how stuff works over all. The response I got was "well, we hired different contractors..blah blah blah" Well, if that's the case, why was there not much control over the prouct you were purchasing.

I think Teamsite can serve a good purpose in our organization, but with the troubles I have had, it makes me wonder if I can achieve our needs by more custom development than relying on hard to use features of this product.

I am making some headway with DataDeploy now, I finally have a Config file that will talk to SQLExpress locally on the same server. I'm now struggling with it actually populating the tables that it creates.

ISCBorisB

Well, I don't want to speak overly negative of this product (Interwoven as a whole), but the first thing I noticed when going through both training classes this summer (TS Dev & TS Admin) was the lack of consistancy in how stuff works over all

Are you living in the universe of "perfect software"? If so - you may even be right.
If not, think about a reality of software development in immature and rapidly evolving domain.

TS is just a tool. As such, it may be good or not so good fit for your particular needs. Forget *cosmic justice* and compare
in the same class of enterprise CMS. You'll find that there are not that many, all with it's own idiosyncrasies. For example
I like few Stellent features lacking in TS. It does not mean Stellent is better, it means it *may* be a better fit for some projects.

That said, out of 5-6 IWOV products I worked with, DD is IMHO the worst one by any metrics (usability, documentation, bugs, features, you name it).

dapcook

Are you living in the universe of "perfect software"? If so - you may even be right.
If not, think about a reality of software development in immature and rapidly evolving domain.

TS is just a tool. As such, it may be good or not so good fit for your particular needs. Forget *cosmic justice* and compare
in the same class of enterprise CMS. You'll find that there are not that many, all with it's own idiosyncrasies. For example
I like few Stellent features lacking in TS. It does not mean Stellent is better, it means it *may* be a better fit for some projects.

That said, out of 5-6 IWOV products I worked with, DD is IMHO the worst one by any metrics (usability, documentation, bugs, features, you name it).

Sorry, I don't want to derail my original thread here. I have been in IT for 15 years and understand the complexity of software development. One of the biggest battles is the reality vs make believe world of management. Some of my frustrations is being put in a situation where the company spent good money on this CSM and we lost the key person who started the whole process of moving down this road. So it's more of a sink or swim, and lately I feel as if I'm sinking faster with this product.

I made great progress yeterday, albiet it small steps in getting a config that talked to the Database, right now when I start the deployment, it tells me it can not find any DCR's... A small snippet is below

DBD: area=/default/main/internet/WORKAREA/work
DBD: /default/main/internet/WORKAREA/work/templatedata/Forms/Article2/data
DBD: No DCR's found in directory path or visit-directory mode should be modified [Y:/default/main/internet/WORKAREA/work/templatedata/Forms/Article2/data]
DBD: Stat for group [Article2]:
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: -----------------------------------

My config file snippet is below

options="wide,full"
area="/default/main/internet/WORKAREA/work"
area-type="ts-filesystem">

dapcook

Here's teh config file, I believe the forum software slaughter my xml code.

<xml-source include-textended-attributes="yes"
options="wide,full"
area="/default/main/internet/WORKAREA/work"
area-type="ts-filesystem">
<path name="templatedata/Forms/Article2/data" visit-directory="no" />
</xml-source>

ISCBorisB

Here's teh config file, I believe the forum software slaughter my xml code.

<xml-source include-textended-attributes="yes"
options="wide,full"
area="/default/main/internet/WORKAREA/work"
area-type="ts-filesystem">
<path name="templatedata/Forms/Article2/data" visit-directory="no" />
</xml-source>

<path name="templatedata/Forms/Article2/data" visit-directory="shallow" />
Or perhaps "deep" if that's what you want...

dapcook

<path name="templatedata/Forms/Article2/data" visit-directory="shallow" />
Or perhaps "deep" if that's what you want...

It was originally "deep", but it appears none of the settings on visit-directory make a difference. I'm not sure why it would not find the DCR's in that directory. I am able to open up those DCR's and edit them inside of CCPro...the Extended attribute for these files is

TeamSite/Templating/DCR/Type: Forms/Article2

ISCBorisB

It was originally "deep", but it appears none of the settings on visit-directory make a difference. I'm not sure why it would not find the DCR's in that directory. I am able to open up those DCR's and edit them inside of CCPro...the Extended attribute for these files is

TeamSite/Templating/DCR/Type: Forms/Article2

First, leave it "shallow" for now.
Second, what is the type of your DCRs, IWOV or XML? You can check that in ...local/config/templating.cfg
Third, have you tried to build your Data Deploy configuration from OD GUI? It's slower but easier if you do not have some experience.
Finally, you may want to attach full configuration file and referenced dbchema File(s)

dapcook

First, leave it "shallow" for now.
Second, what is the type of your DCRs, IWOV or XML? You can check that in ...local/config/templating.cfg
Third, have you tried to build your Data Deploy configuration from OD GUI? It's slower but easier if you do not have some experience.
Finally, you may want to attach full configuration file and referenced dbchema File(s)

the DCR's are XML...not sure why, I didn't actually create these originally..Could this be the problem?

how do you use the OD GUI to create a Data Deploy Configuration? When It ry to edit the exiting configh file in the gui I get the error "Editing of this deployment configuration is not supported"

dapcook

Here's my config file.

ISCBorisB

the DCR's are XML...not sure why, I didn't actually create these originally..Could this be the problem?"

It could. Try
<xml-source include-textended-attributes="yes" options="wide,full" area="/default/main/internet/WORKAREA/work" area-type="ts-filesystem" xml-type="custom">

how do you use the OD GUI to create a Data Deploy Configuration? When It ry to edit the exiting configh file in the gui I get the error "Editing of this deployment configuration is not supported"

For the first time do not edit it. Create new. Left OD GUI Panel->Configuration->DataDeploy Configuration and follow prompts

ISCBorisB

Here's my config file.

Originally I thought it was a typo in your post but you have the same in the File...
<xml-source include-textended-attributes="yes"

Attributes are actually extended, not textended :-)

dapcook

It could. Try
<xml-source include-textended-attributes="yes" options="wide,full" area="/default/main/internet/WORKAREA/work" area-type="ts-filesystem" xml-type="custom">For the first time do not edit it. Create new. Left OD GUI Panel->Configuration->DataDeploy Configuration and follow prompts

I saw an checkbox option in configuration next to the new "button" that says DataDeployWrapper, but when I click that and click the new button I get a screen that looks like the config screen, layout wise, but has not text in it.

I tried the changes you mention'd, and am still having no luck. Can this really be that difficult? wow..

ISCBorisB

I saw an checkbox option in configuration next to the new "button" that says DataDeployWrapper, but when I click that and click the new button I get a screen that looks like the config screen, layout wise, but has not text in it.

I tried the changes you mention'd, and am still having no luck. Can this really be that difficult? wow..

Have you also fixed that (mentioned in one of my replies)
<xml-source include-textended-attributes="yes"

What is your OD Version? Are you logged as OD Admin? Expand Configurations and use "Data Deploy Configuration" sub. It's not that hard.

dapcook

Have you also fixed that (mentioned in one of my replies)
<xml-source include-textended-attributes="yes"

What is your OD Version? Are you logged as OD Admin? Expand Configurations and use "Data Deploy Configuration" sub. It's not that hard.

sorry, yes, I did fix that typo. I honestly did not see that "Data Deploy Config" area.. I guess that was a numpty moment. I went and played around with that config area a bit and tired to run a few. I seem to have the same problem, it is not finding those DCR's that I have created. Is there something special that needs to be abou the DCR? They are XML dcr's (no explanation why), is there a extended attribute that needs to be set for it? I will try the safari area and see if I get the same result.s

Thanks for your input so far, I do appreciate it.

Dave

dapcook

Safari does the same thing...grrr hmmm I'm wondering about this

<xml-source include-extended-attributes="yes"
options="wide,full"
area="/default/main/internet/WORKAREA/work/templatedata/Forms/Article2"
area-type="ts-filesystem"
xml-type="interwoven">
<path name="data" visit-directory="shallow"/>
</xml-source>

The VPath for my DCR's are this
/default/main/internet/WORKAREA/work/templatedata/Forms/Article2/data

How should area and path name be set then? Is the way I have it set up above confusing it from know where to find the actual dcr's?

Dave

ISCBorisB

Safari does the same thing...grrr hmmm I'm wondering about this

<xml-source include-extended-attributes="yes"
options="wide,full"
area="/default/main/internet/WORKAREA/work/templatedata/Forms/Article2"
area-type="ts-filesystem"
xml-type="interwoven">
<path name="data" visit-directory="shallow"/>
</xml-source>

The VPath for my DCR's are this
/default/main/internet/WORKAREA/work/templatedata/Forms/Article2/data

How should area and path name be set then? Is the way I have it set up above confusing it from know where to find the actual dcr's?

Dave

Try the following instead of <xml-source. Note absence of the option 'wide' [html]
options="full" area="/default/main/internet/WORKAREA/work"
include-extended-attributes="yes"
custom="yes">

[/html]If that does not help - perhaps it's time for you to get to Support and/or hire help, even if it's for the brief troubleshooting tour

dapcook

Ok, still didn't make a difference..*sigh* I have a ticket open with helpdesk, haven't heard back yet from them so I'll work that avenue. Thanks for your help, I have learned alot since my first post.

Dave

ISCBorisB

Ok, still didn't make a difference..*sigh* I have a ticket open with helpdesk, haven't heard back yet from them so I'll work that avenue. Thanks for your help, I have learned alot since my first post.

Dave

Just in case you are still struggling with that issue...
Take a look at the resolution in [thread=18393]this[/thread] thread - last post

new_report.rptdesign

dapcook

Yep, it was the teamsite.version in deploy.cfg that was missing...

*sigh* It's always something small isn't it?

Now I'm on to the next of what seems like more endless problems. Smiley Sad