Compile 'hangs'

rickrambo · Post by **rickrambo** » Mon Oct 02, 2006 6:28 pm

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

kumar_s · Post by **kumar_s** » Mon Oct 02, 2006 7:27 pm

Will it allow you to compile If you revert the changes?
Check if it does only in your machine or on all others? Like wise check for different user id as well.

Kirtikumar · Post by **Kirtikumar** » Tue Oct 03, 2006 12:36 am

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.

kumar_s · Post by **kumar_s** » Tue Oct 03, 2006 5:57 am

Check for any change in permission for the user id.

ray.wurlod · Post by **ray.wurlod** » Tue Oct 03, 2006 3:35 pm

Start with the job that compiles. Add bits to it until it doesn't compile. Figure out what the problem is with the most recently-added bit.