My Oracle Support Banner

OBIEE 12c: Getting [nQSError: 27002] Near <">: Syntax error (HY000) Error When Issuing SQL To Call ORE Stored Procedure (Doc ID 2554221.1)

Last updated on AUGUST 13, 2019

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.4.181016 and later
Information in this document applies to any platform.

Symptoms

An error occurs when following the steps to Configure Oracle R Enterprise as per the documentation from the Fusion Middleware Installing and Configuring Oracle Business Intelligence -> Installing R and Oracle R Enterprise for External Logical SQL Functions -> Configuring Oracle R Enterprise to Work with Oracle BI EE.

 

As per the steps in the documentation, open your instance of Oracle BI Presentation Services and click Administration. In the Administration page, click Issue SQL. The Issue SQL dialog displays.
In the Issue SQL dialog, enter and issue the following stored procedures:

call NQSRegisterScript("filerepo://obiee.Clustering.xml")
call NQSRegisterScript("filerepo://obiee.RegressionCreateModel.xml")
call NQSRegisterScript("filerepo://obiee.RegressionScoreModel.xml")
call NQSRegisterScript("filerepo://obiee.Outliers.xml")
call NQSRegisterScript("filerepo://obiee.Regression.xml")
call NQSRegisterScript("filerepo://obiee.RegressionCorrelation.xml")
call NQSRegisterScript("filerepo://obiee.TimeSeriesForecast.xml")

The following error occurs when entering the command in the box and clicking on Issue SQL button to call the stored procedures:

 

 

Changes

 

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
Changes
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.