System Crashed - can't restore table defs

[jjrbikes]

Our system took a hard dive yesterday - but we're impressed with DS resilience!! However, it came to our attention today that in one - and only one - of our many projects our developers are unable to access any Table Definitions.

When an attempt is made to import table definitions the following error message is encountered:
"Table Definitions: Browse List is Empty"

With this knowledge we went through the appropriate steps and then issued the LIST DS_METADATA command for that project - and got this response:

File '/proj/dsadm/Ascential/DataStage/Projects/dovmmvs/DS_METADATA/DATA.30':
Computed blink of 0x800 does not match expected blink of 0x0!
Detected within group starting at address 0x117000!

we then ran the CLEAR.FILE DS_METADATA command and received this response:
File "DS_METADATA" has been cleared.

Followed by the LIST DS_METADATA command again which yielded this repsonse:
0 records listed.

From there we then imported our table definitions from our last backup into the problematic project. Now when we do the LIST DS_METADATA we get an extensive list. Likewise, if I go into Manager and request to do an export of the table definitions (by Individual Component) I again get a very long list of table defs to choose from.

But here's the problem - if I attempt to import a table def from designer I still get the message: "Table Definitions: Browse List is Empty" and my "Table Definitions" in my repository view in designer also appears empty - I see nothing in it.

Ideas?? Suggestions???
Help!!!

Thanks

Jennifer

[kduke]

Do a search on DS.TOOLS. There may be an index which got corrupted. You can rebuild all indexes with one of the programs in DS.TOOLS.

If it does not fix these indexes then you might be able to manually fix them by going to the good project and

LIST.INDEX DS_METADATA ALL

You would need to

DELETE.INDEX DS_METADATA index1
DELETE.INDEX DS_METADATA index2

CREATE.INDEX DS_METADATA index1
CREATE.INDEX DS_METADATA index2

BUILD.INDEX DS_METADATA all

[wpkalsow]

Hello, I am a co-worker with Jennifer.

What is the syntax for a "search on DS.TOOLS"?

The LIST.INDEX DS_METADATA ALL" returns information on four indexes:
ACCESSTYPE
ACCESSCAT
PLATFORMTYPE
CATEGORY

I am guessing that the CATEGORY one is the one that needs to be rebuilt.

Is there a way of rebuilding a specific index rather then the "DS.REINDEX DS_METADATA" or "DS.REINDEX ALL" commands?

The "DS.REINDEX DS_METADATA" seems to compile all but the CATEGORY one.

Thanks

Warren.

[kduke]

The list is

ACCESSTYPE
ACCESSCAT
PLATFORMTYPE
CATEGORY

So

Code: Select all

DELETE.INDEX DS_METADATA ACCESSTYPE
DELETE.INDEX DS_METADATA ACCESSCAT 
DELETE.INDEX DS_METADATA PLATFORMTYPE 
DELETE.INDEX DS_METADATA CATEGORY 

CREATE.INDEX DS_METADATA ACCESSTYPE
CREATE.INDEX DS_METADATA ACCESSCAT 
CREATE.INDEX DS_METADATA PLATFORMTYPE 
CREATE.INDEX DS_METADATA CATEGORY 

BUILD.INDEX DS_METADATA ALL

DS.TOOLS should be able to rebuild all of these. Make sure nobody is in DataStage when you do this. You have to have exclusive access to a file to build an index.

[wpkalsow]

THANKS!

Got everything to show up correctly!