1. Migrating and Upgrading to Oracle Analytics Server
  2. Troubleshooting Migrated Oracle Analytics Server
  3. Analysis Query Failure

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_TIME parameter.
  • Increase the value of the DEFAULT_DB_MAX_EXEC_TIME parameter to a reasonable time in seconds to allow your queries to complete.