Guys
Did anyone faced this problem in datastage Designer?....
When I changed my existing job to add one new column it gave this error. And pressing the show button doesn't do anything
Will post you the finding if I come to know the reason
Thanks
Siva
The Precompilation failed - no other information provided!..
Moderators: chulett, rschirm, roy
I had found the problem which caused that error.
I created a copy of the job and did a compile and in that it said
"Active Stage output has no columns"
When I went back to the original job it didn't allowed me to even open the transformer. I said ole error for that transformer which had problem. I did closed the job and re-opened and deleted that link and recreated it. It then complied without any problem.
Cheers
Siva
I created a copy of the job and did a compile and in that it said
"Active Stage output has no columns"
When I went back to the original job it didn't allowed me to even open the transformer. I said ole error for that transformer which had problem. I did closed the job and re-opened and deleted that link and recreated it. It then complied without any problem.
Cheers
Siva
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Usually, when that kind of error occurs, the More button is enabled and you can determine what failure has happened. But not always. 
Always be alert for the More button becoming enabled.
Always be alert for the More button becoming enabled.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
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard. :D
Failed precompilation involves DataStage losing track of some kind of relationship between the objects in a job design. In Siva's case it was link properties; in your case it appears to have been either another link or stage properties. In any case you appear to have resolved it.
Failed precompilation involves DataStage losing track of some kind of relationship between the objects in a job design. In Siva's case it was link properties; in your case it appears to have been either another link or stage properties. In any case you appear to have resolved it.
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.
OK, I was able to solve this problem with no external help (hint, hint).
Steps to resolve the problem include (not sure if some of them are absolutely required):
1. Copy all components of the job to a new job - no need to save it.
2. Save the job as a another job name then delete all stages from the job. This step is especially useful if you have a lot of job parameters which you need to use.
3. Copy the stages from the unsaved job to the newly saved job. Compilation should be successful.
Other symptoms related to this problem include:
- Transformer stage properties cannot be viewed.
- Transformer stage properties do not display input or output columns in the top half of the screen.
- Re-linking stages does not propagate column information.
Steps to resolve the problem include (not sure if some of them are absolutely required):
1. Copy all components of the job to a new job - no need to save it.
2. Save the job as a another job name then delete all stages from the job. This step is especially useful if you have a lot of job parameters which you need to use.
3. Copy the stages from the unsaved job to the newly saved job. Compilation should be successful.
Other symptoms related to this problem include:
- Transformer stage properties cannot be viewed.
- Transformer stage properties do not display input or output columns in the top half of the screen.
- Re-linking stages does not propagate column information.
(hint, hint) what?Re-read what you posted. There was no hidden 'suggestion' from Ray because you did not indicate you were having any kind of problem.
Even your followup post only seemed informational. There were no questions posted. Next time, if you are looking for help with something, make that a little more clear and you'll get as much help as everyone here can provide.asingh wrote:I had to get the transformer from a previous version of the job and then it was fine.
Thanks for posting your resolution steps, it helps searchers with similar problems find answers here.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
I have tried this steps and this is not working for me.asingh wrote:OK, I was able to solve this problem with no external help (hint, hint).
Steps to resolve the problem include (not sure if some of them are absolutely required):
1. Copy all components of the job to a new job - no need to save it.
2. Save the job as a another job name then delete all stages from the job. This step is especially useful if you have a lot of job parameters which you need to use.
3. Copy the stages from the unsaved job to the newly saved job. Compilation should be successful.
Other symptoms related to this problem include:
- Transformer stage properties cannot be viewed.
- Transformer stage properties do not display input or output columns in the top half of the screen.
- Re-linking stages does not propagate column information.
Also more button is not enable.
How to solve this issue.
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Precomilation failed
I too faced this problem. I have closed the designer and the director and reopened again and it solved my problem. Try this one as the first option.