SYMPTOMS:
A Command Manager 9.x script times out even after 20 minutes even though a timeout value of greater length is specified.
Sample Code/Error
PURGE STATISTICS FROM 1/01/2009 TO 1/31/2009
TIMEOUT 7200 IN PROJECT `Strategy Tutorial`
CAUSE:
The 20 minute timeout on the Command Manager side is by design. To avoid locking up the system indefinitely, Command Manager has a built-in timeout limit of 20 minutes. If a statement has been executing for 20 minutes with no response from Intelligence Server, Command Manager reports a request timeout error for that command, and executes the next instruction in the script.
However, Command Manager does not attempt to abort the command. In some cases, such as database-intensive tasks such as purging the statistics database, the task may continue to execute even after Command Manager reports a timeout error.
The following statements are not subject to the 20 minute Command Manager timeout limit. A script containing these statements continues executing until Intelligence Server reports that the task has succeeded or failed.