Friday, April 13, 2007

Teamsite: IWDataDeploy FAILED TDbSchemaSynchronizer create failure


Interwoven Teamsite is the worst piece of software i have ever used, and googling its errors gives you 0 hits. I am going to do the world a favor and change that!

Problem: I needed to deploy DCT data to the table which teamsite uses for its own record keeping. The file which takes care of this deployment is called AREA_dd.cfg where area is the name of the DCT. After making sure that teamsite is using the correct db info, and that all fields i was deploying existed i was getting the error: IWDataDeploy FAILED, where the root cause might have been:
(from the log in OD_HOME/OpenDeployNG/log/iwddd_something.log)

DBD: SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWTRACKER'
DBD: Table [iwtracker] exists.
DBD: DEFAULT__DEVICE__MAIN_STAGING not registered
DBD: Error occured in TDbSchemaSynchronizer
DBD: ERROR:TDbSchemaSynchronizer create failure.


(DEVICE is the name of my DCT)
Solution:
This solution is a hack, but it works. Open the database you are trying to commit to from teamsite, and run the following SQL query:
INSERT INTO IWTRACKER (NAME) VALUES('DEFAULT__DEVICE__MAIN_STAGING');
COMMIT;

where instead of 'DEFAULT__DEVICE__MAIN_STAGING' put the thing which the previous error claims is not registered. Save the DCT again and tail the log, the deployment should succeed. (if it fails, you are probably screwed because the support is terrible and the documentation is teh suck)

edit 11/6/2009: I no longer use teamshite, so please dont ask me any questions about this evil thing, i wont know the answers.

8 comments:

  1. I googled the Teamsite error for solutions and only your blog entries came out in the search result. You are a lifesaver!!
    I agree completely, Teamsite is a piece of cr*p.
    The javascript object structure is a mess.

    ReplyDelete
  2. Thanks thanks thanks!
    In addition to Herry, I'd like to add that Teamsite's documentation, architecture, interface (if there is such) specification, performance and usability are by far the worst I've ever seen.
    My compassion to everyone else who's forced to use that cr*p.

    ReplyDelete
  3. @Star: yeah its sad that i had to work with it for over 2 years. Someone recently pointed this out to me: http://www.teamsiteSucks.com - good stuff right there. i borrowed their logo for this post

    ReplyDelete
  4. Hi,

    Instead of having to run the sql query, any way i can insert the _staging table into iwtracker automatically?

    ReplyDelete
  5. Hi, im sorry, i cant help you, i no longer use teamshite. Thank god for that.

    ReplyDelete
  6. Seriously I'm also wondering why there are no more Google listings as to why TeamShite isn't listed as one of the worst pieces of software ever concieved.

    ReplyDelete
  7. amen. worst designed, most ill conceived user interface in history. absolute rubbish. anybody commissioning this pile of crap at enterprise level needs whipping. keeps people in jobs however trying to manage this crap.

    ReplyDelete
  8. + 1 for teamsite being a piece of garbage.

    ReplyDelete