KNOWLEDGE BASE

Extract Refresh fails with unsuccessful execution due to resource limit being exceeded error


Published: 12 May 2021
Last Modified Date: 13 Aug 2021

Issue

Extract Refresh fails intermittently and the following error happens:

[IBM][CLI Driver][DB2] SQL0905N Unsuccessful execution due to resource limit being exceeded. Resource name="ASUTIME", limit="000000000741" CPU seconds ("000050000000" service unit) derived from "SYSIBM,DSNRLST01", SQLSTATE=57014
 

Environment

  • Tableau Server
  • DB2

Resolution

Work with the database administrator to verify the performance of the query and modify the query to consume less processor service units or database administrator can increase the ASUTIME parameter in the mentioned table ("SYSIBM,DSNRLST01") to prevent the issue.

Cause

The error message is from data source (db2 z/OS) and it indicates the query that user is running has exceeded the resource limit of a total of 741 CPU seconds per SQL statement. Therefore it is canceled.
According to this message, this limitation has been specified in "ASUTIME" parameter in "SYSIBM,DSNRLST01" table. 
Did this article resolve the issue?