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 FEBRUARY 26, 2013

Applies to:

Oracle Exalytics Software - Version 1.0.0.0.0 to 1.0.0.0.0 [Release 1.0]
Linux x86-64

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_Fact_HCM_Vacanc"
for "HR"."Fact_HCM_Vacancies"("Current Vacancy","Vacancies Balance")
at levels ("HR"."DimH Organization"."Detail")
using connection pool "TimesTen_DB"."EXA_TimesTen"
in "TimesTen_DB".."ORACLEBI"
create aggregates

"ag_Fact_HCM_Vacanc"
for "HR"."Fact_HCM_Vacancies"("Current Vacancy","Vacancies Balance")
at levels ("HR"."DimH Organization"."Detail")
using connection pool "TimesTen_DB"."EXA_TimesTen"
in "TimesTen_DB".."ORACLEBI"
[1001][State: 37000] [TimesTen][TimesTen 11.2.2.2.0 ODBC Driver][TimesTen]TT1001
: Syntax error in SQL statement before or at: ""ag_Fact_HCM_Vacanc"", 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

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