*** Failure 3156 Request aborted by TDWM. Exception criteria exceeded: AMP CPU Skew, AMP I/O Skew.

Database
Enthusiast

*** 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

1 REPLY
Enthusiast

Re: *** Failure 3156 Request aborted by TDWM. Exception criteria exceeded: AMP CPU Skew, AMP I/O Skew.

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.