My Oracle Support Banner

Oracle Exalytics Aggregate Script Fails With Errors: "[TimesTen ODBC Driver][TimesTen]TT6003: Lock Request Denied Because Of Time-out..." (Doc ID 1513103.1)

Last updated on MAY 06, 2019

Applies to:

Oracle TimesTen In-Memory Database - Version to [Release 11.2]
Oracle Exalytics Software - Version to [Release 1.0]
Information in this document applies to any platform.


Successfully created an aggregate script using Summary Advisor in Oracle Business Intelligence Enterprise Edition (OBIEE) 11g Admin Tool.  When running the aggregate script via NQCMD command and an Oracle Exalytics server, the script execution fails with error:

The nqquery.log show errors:

[TimesTen][TimesTen ODBC Driver][TimesTen]TT6003: Lock request denied because of time-out
Details: Tran 1.833 (pid 21222) wants Xd lock on table EXALYTICS.SA_PART00000944. But tran 4.41 (pid 21237) has it in X (request was X). Holder SQL (CREATE INDEX SA_Par00001A0E_N5 ON
    SA_Part00000944 ( Part00000868 )) -- file "lockMgr.c", lineno 9282, procedure "sbLockENQandCheckTbl()".
[nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement.
[nQSError: 43119] Query Failed:




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.