LoyEngineBatch Component Remains In "Not Online " State as Table Owner Is Not Included In The SQL
Last updated on MAY 02, 2017
Applies to:Siebel Loyalty Engine - Version 16.10 [IP2016] to 16.10 [IP2016] [Release V16]
Information in this document applies to any platform.
Customer is seeing an issue with LoyEngineBatch component that remains in "Not Online " state.
The following sql-statenemt is seen in the LoyEngineBatch.log file when trying to start the component:
SELECT /*+ ALL_ROWS */
Note that the schema name is missing in front of
.S_SYS_PREF T1 and this seems to cause the issue that the component can not be started.
E.g. it should be for example SIEBEL.S_SYS_PREF T1
New server datasource had been created
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