My Oracle Support Banner

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:


C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orahome\bifoundation\server\bin>nqcmd -d EXA_TimesTen -u exalytics -p welcome1 -s C:\Users\4221\Desktop\test.sql

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

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
Symptoms
Cause
Solution
References


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