Hi,
This is SCD job, reading from Delta file, with a Join on TD base table and finally inserts / updates the same table. Issue I am facing is, when I compile it simply hangs. It was compiling OK before. I added some null handling statements. If isnull(Link1.col1) then Setnull() else Link1.col1, so that I won't get warnings which I was getting before. I tried to see if TYPOED wrong or kept an extra space. But seems OK. Why the 'Compile' is hanging? Server 7.52 on Sun OS, Client 752 / 751A. Any thoughts.
Thanks,
Rick
Compile 'hangs'
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 437
- Joined: Fri Oct 15, 2004 6:13 am
- Location: Pune, India
We also faced this problem last year on a DS specific project. The server and projects are managed by diff group DS Admin group and we do not have the control.
The problem was solved by resolving some lock related things. They said, There is a internal DS table which manages all the jobs had a lock on certain group of jobs. These locks prevent the job from getting compiled. They never told us the exact table name and other details.
So check up with ur DS admin ppl if there is any such possiblity.
The problem was solved by resolving some lock related things. They said, There is a internal DS table which manages all the jobs had a lock on certain group of jobs. These locks prevent the job from getting compiled. They never told us the exact table name and other details.
So check up with ur DS admin ppl if there is any such possiblity.
Regards,
S. Kirtikumar.
S. Kirtikumar.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: