Oracle Exalytics Aggregate Script Fails With Errors: "[TimesTen 188.8.131.52.0 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 184.108.40.206.0 to 220.127.116.11.0 [Release 11.2]
Oracle Exalytics Software - Version 18.104.22.168.0 to 22.214.171.124.0 [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 126.96.36.199.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:
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