Analysis Query Failure
After in-place upgrade, analysis queries fail with [nQSError: 60009] error if the database query time in seconds exceeds the value set for the DEFAULT_DB_MAX_EXEC_TIME parameter in the BI_DOMAIN/config/fmwconfig/biconfig/OBIS/NQSConfig.INI file.
To resolve this issue, perform one of the following:
- Optimize your query so that it executes within the time configured in the
DEFAULT_DB_MAX_EXEC_TIMEparameter. - Increase the value of the
DEFAULT_DB_MAX_EXEC_TIMEparameter to a reasonable time in seconds to allow your queries to complete.