Oracle Business Process Analysis Suite Publisher Will Not Create An Export due to The procedure was cancelled / ORA-00933 error (Doc ID 1528427.1)

Last updated on AUGUST 05, 2015

Applies to:

Oracle Business Process Analysis Suite - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

Symptoms

On : 11g, Business Process Publisher

When attempting to created a web export,
the following error occurs.

Error

The procedure was cancelled

In the log files you get the following:

IT_13c9117a65b_SEVERE 2013-01-31T09:51:51,771 com.idsscheer.aris.businesspublisher.application.dao.ADAOSystemFacade.dropDb
NO MESSAGE AVAILABLEcom.idsscheer.aris.businesspublisher.application.dao.ADAOException: ADAOException

...
Caused by: com.idsscheer.aris.businesspublisher.application.dao.util.ADAOSystemException: Error on retrieving all fk entries
...
Caused by: org.springframework.jdbc.BadSqlGrammarException: Error on retrieving all fk entries; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-00933: SQL command not properly ended

 

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