Using Aggregate Persistence Script With Nqcmd On TimesTen Target In Exalytics Fails With "Syntax Error In SQL Statement Before Or At...'' (Doc ID 1470976.1)

Last updated on MARCH 01, 2022

Applies to:

Symptoms

When running nqcmd to create an aggregate on an Exalytics environment, an error is encountered and aggregate creation fails.
Command issued is:

Results are:

-------------------------------------------------------------------------------
Oracle BI ODBC Client
Copyright (c) 1997-2011 Oracle Corporation, All rights reserved
-------------------------------------------------------------------------------

sql script file is utf8
create aggregates

"ag_aaa_bbb_ccc"
for "sss"."Fact_AAA_BBBB"("AAA","BBBB")
at levels ("HR"."AAA_BBB"."Detail")
using connection pool "TimesTen_AA"."EXALYTICS"
in "EXAYTICS".."ORACLEBI"
create aggregates

"ag_aaa_bbb_ccc"
for "sss"."Fact_AAA_BBBB"("AAA","BBBB")
at levels ("HR"."AAA_BBB"."Detail")
using connection pool "TimesTen_AA"."EXALYTICS"
in "EXAYTICS".."ORACLEBI"
[1001][State: 37000] [TimesTen][TimesTen 11.2.2.2.0 ODBC Driver][TimesTen]TT1001
: Syntax error in SQL statement before or at: ""ag_aaa_bbb_ccc"", character
position: 21 -- file "ptSqlY.y", lineno 254, procedure "sbPtParseSql"
Statement execute failed


Processed: 1 queries
Encountered 1 errors

--------------------------------

Connection from the Windows OBIEE Admin client machine to TimesTen on Exalytics is working. TimesTen database is mapped to the physical layer in the Repository (RPD) file.

Cause

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