Praveen -
The code you just posted is almost entirely commented out; the only line that isn't commented out is the "count the number of records in the output table" line. But the output table is never populated, since there's nothing actually happening in the code, so the result will always be 0 records, though it will always succeed (since there's no code in there that could possibly have an error!).
Trying to look through your original error log, but it's got too much debug turned on to really read the code. Perhaps if you posted the code itself (rather than the log) someone could help, but without knowing what you're trying to do or where the code came from, it might be difficult. Do you have a local SAS Professional Services contact? You might find that engaging them for a bit of mentoring and a review of your system and code to be of benefit.
I should also point out that we strongly discourage the use of open code in process nodes like this - instead, you should develop and test your code in Enterprise Guide to make sure it won't have errors, then deploy it as a Stored Processes and have your process node select the already tested, reliable Stored Process instead. CI Studio makes a pretty poor debugging environment 🙂
Regards,
Steve
... View more