Getting ERROR: Commit: Session forced off by PMPC or gtwglobal or security violation.

General
Enthusiast

Getting ERROR: Commit: Session forced off by PMPC or gtwglobal or security violation.

I am running a SAS code with in-database processing which creates a table in Teradata by performing a select from another table is Teradata, then sleep for 10 minutes and then drop that table was was created. These steps are iterated 10 times. During this processing, we got the below error:

"ERROR: Teradata prepare: ERROR: Commit: Session forced off by PMPC or gtwglobal or security violation.. SQL statement was........."

Code snippet:

%macro load;

proc sql;

  create table _user.&sysuserid.table_test as

  select col1, col2, col3

  from _user.&sysuserid._test_abc

;

quit;

data _null_;

/* argument to sleep must be expressed in seconds */

call sleep(600,1);

run;

proc sql;

drop table _user.&sysuserid.table_test;

quit;

%mend;

%macro dreate(iterations);

   %do i=1 %to &iterations;

     %load;

   %end;

%mend dreate;

%dreate(10);

Can anyone tell me why we are getting this error. I am running this SAS code under Teradata 14.10 release. Is there any TD settings that is causing some sort of a timeout due to inactivity. What could be the reason. Please help.