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........."
create table _user.&sysuserid.table_test as
select col1, col2, col3
/* argument to sleep must be expressed in seconds */
drop table _user.&sysuserid.table_test;
%do i=1 %to &iterations;
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.