DataStage Job not opned

thepakks · Post by **thepakks** » Tue Feb 17, 2009 1:25 am

Hi,
When I open a job I got following massage.

"Record TeradataPX in file DS_STAGETYPE does not exist."

Pls suggest a solution.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 17, 2009 1:43 am

Potassium permanganate in water.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 17, 2009 1:45 am

It sounds like the index on the local repository table DS_STAGETYPES has become out of date (or that the Teradata stage types were not installed in the project, but I'd guess the former).

Open your Administrator client command window and, when no-one else is using the project (and you can be absolutely sure that this is the case) execute the following command.

Code: Select all

DS.REINDEX DS_STAGETYPES

thepakks · Post by **thepakks** » Tue Feb 17, 2009 1:54 am

Only TeraData API and Mload stage is not opened.

Plz giv a solution.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 17, 2009 1:55 am

I did.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 17, 2009 1:56 am

I did.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 17, 2009 1:58 am

Try the following query to determine whether the stage types are installed in the project. It will return rows if they are, and no rows if they are not.

Code: Select all

SELECT * FROM DS_STAGETYPES WHERE EVAL "UPCASE(@ID)" LIKE '%TERA%' OR EVAL "UPCASE(@ID)" LIKE '%ML%';

ray.wurlod · Post by **ray.wurlod** » Tue Feb 17, 2009 2:00 am

Please be more careful with spelling ("please" rather than "plz" and "give" rather than "giv"). We like to maintain a professional standard of written English on DSXchange, not least because it is easier for those who do not have English as their first language.

thepakks · Post by **thepakks** » Tue Feb 17, 2009 2:10 am

ray.wurlod wrote:Please be more careful with spelling ("please" rather than "plz" and "give" rather than "giv"). We like to maintain a professional standard of written English on DSXchange, not least because it is easier for those who do not have English as their first language.

Hi,

I ran following query in command prompt and got following result set.

SELECT * FROM DS_STAGETYPES WHERE @ID LIKE '%TeradataPX%'

Result :

Stagetype name.... TeradataPX
Short description... Teradata data access
Category.............. Parallel/Database

1 records listed.

Teradata API and Mload Stage is disable in Designer.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 17, 2009 3:35 am

Please run the exact query that I specified. There should be four records reported.

attu · Post by **attu** » Tue Feb 17, 2009 11:34 am

Do you have "Enable remote execution of Parallel Jobs" checked in Administrator? If yes, Uncheck it.