Incorrect sequence name in e*Insight upgrade scripts:
Last updated on OCTOBER 25, 2016
Applies to:Sun SeeBeyond e*Gate - Version: 4.5.3 and later
Information in this document applies to any platform.
When using the new Oracle database sequence, COMPLEX_TYPE_SEQ available in e*Insight 4.5.2 and upgrading to 4.5.3 there is a typing mistake in the upgrade script and the sequence is called COMPLEX_TYPE_SQ
This leads to a 'sequence can not be found' Oracle exception when starting the BP Engine.
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