All Forums Database
abhi_pn 14 posts Joined 02/14
24 Mar 2014
*** Failure 3156 Request aborted by TDWM. Exception criteria exceeded: AMP CPU Skew, AMP I/O Skew.

Hi All,
 
While inserting records into a target table from source table using Bteq utility, I faced an error message like below, thus aborting the session.
 *** Failure 3156 Request aborted by TDWM. Exception criteria exceeded:   AMP CPU Skew, AMP I/O Skew.
Almost 150 millions records (for 2 days) were expected to go in this session.
 
But when I am running the same Bteq for 1 day (roughly 75 million records), I am having no issues like above.
Can anyone please suggest how to go ahead on this with out DBA intervention.
 
Thanks,
Abhi

krishaneesh 140 posts Joined 04/13
24 Mar 2014

This might be because of the session timeout set. there is a parameter like a system throttle which will abort any sessions which are logged on to the system for more than a specified period of time. This can also be a local parameter specified within the WLD for the workload to which the current user is assigned.

You must sign in to leave a comment.