Hi Madelyn_SAS, and thanks for your reply.
I did run similar table successfuly prior to this table and did not get any error massage. i.e. all tables that i run from now on give me an error. just got another error message when closing the previous one: "The advisor job for the project (ID <JOB NAME>) was not completed. The state of the job is "failed"."