I have written a SQL stored procedure which resets table from CHECK PENDING state after loading the same table. While invoking this stored procedure from command line processor, It is successful. But I had defined a user - defined program in Data warehouse center to invoke this procedure. This user - defined program is failing i.e. It is not resetting the table from CHECK PENDING state.

Can anyone tell why user - defined program is failing?
Please explain it.