ORA-00933 Error While Running a Jdbc Crawl In Endeca Integrator Acquisition System (Doc ID 2198683.1)

Last updated on NOVEMBER 13, 2016

Applies to:

Oracle Endeca Information Discovery Integrator - Version 3.2.0 and later
Information in this document applies to any platform.

Symptoms

ORA-00933 error is seen while running a jdbc crawl in Endeca Integrator Acquisition System.

While running a jdbc crawl in Endeca IAS server, the crawl is supposed to read a BLOB column in Oracle Database. The configuration file for the jdbc crawl has the information about the jdbc driver, jdbc URL, SQL Query.

You may be able to create a crawl and start the crawl using the Clover graph. However, when checking the ias-service.log, the ORA-00933 error is observed.

One can also enabled the trace at database level and see the query getting generated internally.

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