Oracle Exalytics Aggregate Script Fails With Errors: "[TimesTen 188.8.131.52.0 ODBC Driver][TimesTen]TT6003: Lock Request Denied Because Of Time-out..."
Last updated on NOVEMBER 17, 2014
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:
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