DSXchange

Some jobs had the OCI Stage in it while we developed. Suddenly all the Databse Stages have greyed out. It is throwing this message while opening the already developed jobs."When I try to open my jobs it gives a message that "Record PxOracle in file DS_STAGETYPES does not exist".and I dont see Oracle stage in my jobs" which was exisisting before.

Regards

Pratim

Welcome aboard. :D

This behaviour suggests that the index on DS_STAGETYPES needs to be rebuilt. You need to find a time when no client connection exists into DataStage in that project, and issue the command DS.REINDEX DS_STAGETYPES
You may as well make sure they're all intact: prefer DS.REINDEX ALL as the command.