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

Last updated on NOVEMBER 17, 2014

Applies to:

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

Symptoms

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 11.2.2.3.0 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:


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms