User written code had been ignore

[Liangck]

Dear all,

     is there anyone here facing problem that when running a job, sas ignore your user written code?(does not process it) and it show process fullly successfully?.

     is there anyone here have any idea what actuallly is occur? is that the marco or any admin stuff?

Regards

Liangck

[ieva]

Hi,

Does it ignore all code? Maybe it could be some syntax error.

For example, some if or %if condition that is not true so further code is not processed.

Ieva

[LinusH]

Not really. Is it a specific transformation? What version are you using?

Sometimes the SQL Join is a bit "slow", you might have to save, leave and enter to make your code in effect.

/Linus

[Liangck]

Hi ieva and LinusH:

Thanks for reply. i using DI 4.2.

Erm..it happen so studenly on last week. still dint figure out what is the problem.

syntax error...maybe. but isnt it di studio help can help us game out a log that show what goes wrong. Such as variable &a not resolove blar blar blar..

Beside, i dint use any transformation other than user written code.

sometime, when i open the job and run it. it work and show some error. but after that i made some changest to the code, i ran again. the code status is FULLY successfully AND i go for the log to made a view.

what i saw is my log only have 200++ line instead of 6000++ line(when able to process).

may be is our team wrong =="

just affaird when deploy will came out this kind of problem.

@$@^@$&*@$ totally no idea...

I AM SORRY FOR MY POOR ENGLISH.....

PS:Agree to LinusH, SQl join quite "slow".......

Regards:

Liangck

[Halaku]

You can use:

%put your variable name

to verify that you actually have returning values and use this at different steps to debug the code.

Then after running the job you can open the LOG tab and look for the returning values to confirm that the code actually runs.

[Liangck]

Halaku:

ya, i do it all the way with %put ....and i get no result in the log.

totally no idea what happen last time...

now no problem alreadly, it work well, just want to made sure its not happen again.

Anyway,thanks for reply.

LiangCk

[nar_sas · Accepted solution]

Looking at the code in the code tab and in the log will show you if your user written code is being included in the job and if it was submitted successfully.  One thing that could cause this is if you have set the entire job to be user written, or have turned the node off in the client.  You can tell if the entire job is user written if you open the job;  there will be a note at the top of the job indicating that it is all user written.  Turning off the node will grey the node out in the client. 

If you still can't get the node to be included, I suggest you open a track with tech support and they can help you determine why the code is not getting included in the job.