Page 1 of 1
DataStage Job not opned
Posted: Tue Feb 17, 2009 1:25 am
by thepakks
Hi,
When I open a job I got following massage.
"Record TeradataPX in file DS_STAGETYPE does not exist."
Pls suggest a solution.
Posted: Tue Feb 17, 2009 1:43 am
by ray.wurlod
Potassium permanganate in water.
Posted: Tue Feb 17, 2009 1:45 am
by ray.wurlod
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.
Posted: Tue Feb 17, 2009 1:54 am
by thepakks
Only TeraData API and Mload stage is not opened.
Plz giv a solution.
Posted: Tue Feb 17, 2009 1:55 am
by ray.wurlod
I did.
Posted: Tue Feb 17, 2009 1:56 am
by ray.wurlod
I did.
Posted: Tue Feb 17, 2009 1:58 am
by ray.wurlod
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%';
Posted: Tue Feb 17, 2009 2:00 am
by ray.wurlod
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.
Posted: Tue Feb 17, 2009 2:10 am
by thepakks
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.
Posted: Tue Feb 17, 2009 3:35 am
by ray.wurlod
Please run the exact query that I specified. There should be four records reported.
Posted: Tue Feb 17, 2009 11:34 am
by attu
Do you have "Enable remote execution of Parallel Jobs" checked in Administrator? If yes, Uncheck it.