DataStage Job not opned
Moderators: chulett, rschirm, roy
DataStage Job not opned
Hi,
When I open a job I got following massage.
"Record TeradataPX in file DS_STAGETYPE does not exist."
Pls suggest a solution.
When I open a job I got following massage.
"Record TeradataPX in file DS_STAGETYPE does not exist."
Pls suggest a solution.
Deepak
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Potassium permanganate in water.
Last edited by ray.wurlod on Tue Feb 17, 2009 1:54 am, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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%';
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.
Deepak
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: