DSXchange

I have a strange problem. For some reason all of our database stage types vanished. They only vanished from one project. They are still on the other projects. How can I bring them back?

How do you add native stage types to a project? (DB2, ORACLE, SQL Server, etc..)

I looked at the DS_STAGYTYPES file, but it looks like it's a binary file so I can't do anything with that. Is there a way in the COMMAND interfce (Admin) to add them back in?

Try "Right Clicking on Palette->Customize Palette->Then add the Database Stages"

Let us know if you have already tried this option!!

Provided you didn't corrupt it when you "looked at" DS_STAGETYPES, you might try reindexing that table. But, before you do, export all of the project except stage types, because you may have to delete and re-create the project; this way you'll be able to reinstate your work. To reindex DS_STAGETYPES, execute

Thanks Ray. Reindexing worked :D I though of doing this but I forgot the command for reindexing.... I wish the DS documentation was better.

I still don't know how it happened. Everybody claims that they did not do anything unusual that could have caused the broken references.

Anyway, thanks again!

I agree that it's most unusual - this hashed file is typically only written to when new stage types are added. Usually this is when the project is being created or updated only.

Has anyone created a Custom stage, a Build stage or a Wrapped stage?

A glitch in index updating during the saving of same may have been the cause.